[MYSQL]Help To Convert R6 To Latest Version
#1

Guys Please Tell Me How I Can Convert R6 To Latest Version Of MySQL.
Here Is The Errors
Код:
C:\Users\Anurag\Desktop\Call of Duty - Desert Warfare\gamemodes\COD-DW-v1.50.pwn(1394) : error 017: undefined symbol "mysql_store_result"
C:\Users\Anurag\Desktop\Call of Duty - Desert Warfare\gamemodes\COD-DW-v1.50.pwn(1395) : error 017: undefined symbol "mysql_num_rows"
C:\Users\Anurag\Desktop\Call of Duty - Desert Warfare\gamemodes\COD-DW-v1.50.pwn(1397) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\Anurag\Desktop\Call of Duty - Desert Warfare\gamemodes\COD-DW-v1.50.pwn(1399) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Anurag\Desktop\Call of Duty - Desert Warfare\gamemodes\COD-DW-v1.50.pwn(1417) : error 017: undefined symbol "mysql_free_result"
C:\Users\Anurag\Desktop\Call of Duty - Desert Warfare\gamemodes\COD-DW-v1.50.pwn(1393) : error 035: argument type mismatch (argument 1)
Please Help Me To Tell He What I Have To Change In Script To Make It Work
Code Of Error Line For Argument Type Mismatch
Код:
stock MySQL_BanCheck(playerid)
{
  new query[200], admin[50], pname[50], IP[16], string1[100];
  GetPlayerIp(playerid, IP, 16);
  format(query, sizeof(query),"SELECT * FROM `bandata` WHERE(`player`='%s' OR `IP`='%s') AND `banned`=1 LIMIT 1", escpname(playerid), IP);
  mysql_query(query);////Errror Line
  mysql_store_result();
  if(mysql_num_rows() != 0)
  {
	 while(mysql_fetch_row(query))
	 {
	   mysql_fetch_field_row(admin, "admin");
	   mysql_fetch_field_row(pname, "player");
	   mysql_fetch_field_row(string1, "reason");
	 }
  new string[50], str[50], str1[100];
  format(string, sizeof(string),"Admin: {FFFFFF}%s", admin);
  format(str, sizeof(str),"Player: {FFFFFF}%s", pname);
  format(str1, sizeof(str1),"Reason: {FFFFFF}%s", string1);
  SendClientMessage(playerid, RED,"You are banned from this server!");
  SendClientMessage(playerid, RED,"___________________");
  SendClientMessage(playerid, RED, str);
  SendClientMessage(playerid, RED, string);
  SendClientMessage(playerid, RED, str1);
  SendClientMessage(playerid, RED,"___________________");
  SendClientMessage(playerid, RED, "If you think you this is a mistake please visit our website");
  SendClientMessage(playerid, RED, "www.cod-samp.in"); //Change ME!
  Kick(playerid);
  }
  mysql_free_result();
  return 1;
}
Reply
#2

Here you go

https://sampforum.blast.hk/showthread.php?tid=616103

https://sampwiki.blast.hk/wiki/MySQL/R40
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)