01.04.2013, 13:14
(
Last edited by Trooja; 01/04/2013 at 01:46 PM.
)
Managed to fix it..
Updated Mysql to R6: Server plugin (VS9) ( https://sampforum.blast.hk/showthread.php?tid=56564 ).
In script just needed to delete " new MySQL:mysql; " and things that were with that line.
Finally I got errors from these lines:
All I had to do was to replace " mysql_fetch_int " with " mysql_fetch_field_row ". And now it's working!
Thanks for all help before too!
EDIT// Well.. Doesn't work as expected.. If I update something @ phpmyadmin, the changes wont come to server.. Trying to solve that..
Updated Mysql to R6: Server plugin (VS9) ( https://sampforum.blast.hk/showthread.php?tid=56564 ).
In script just needed to delete " new MySQL:mysql; " and things that were with that line.
Finally I got errors from these lines:
pawn Code:
mysql_fetch_int("id", pInfo[playerid][ID]);
// the special identifier of a user called "id"
mysql_fetch_int("admin", pInfo[playerid][pAdmin]);
// the admin level of the player
mysql_fetch_int("score", pInfo[playerid][pScore]); SetPlayerScore(playerid, pInfo[playerid][pScore]);
// here we fetch the score and save it to the enum and also save it to the server by using setplayerscore
mysql_fetch_int("money", pInfo[playerid][pMoney]); GivePlayerMoney(playerid, pInfo[playerid][pMoney]);
// here we fetch the score and save it to the enum and also save it to the server by using setplayerscore
mysql_fetch_int("kills", pInfo[playerid][pKills]);
// the amount of kills a player has
mysql_fetch_int("deaths", pInfo[playerid][pDeaths]);
// the amount of deaths a player has
Thanks for all help before too!
EDIT// Well.. Doesn't work as expected.. If I update something @ phpmyadmin, the changes wont come to server.. Trying to solve that..