[Tutorial] How to make a MySQL Admin System!
#29

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:
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
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..
Reply


Messages In This Thread
How to make a MySQL Admin System! - by kamzaf - 13.03.2013, 02:07
Re: How to make a MySQL Admin System! - by RajatPawar - 13.03.2013, 05:42
Re: How to make a MySQL Admin System! - by Vince - 13.03.2013, 06:09
Re: How to make a MySQL Admin System! - by kamzaf - 13.03.2013, 14:34
Respuesta: How to make a MySQL Admin System! - by MiGu3X - 13.03.2013, 15:25
Re: How to make a MySQL Admin System! - by RajatPawar - 13.03.2013, 15:54
Re: How to make a MySQL Admin System! - by Bakr - 13.03.2013, 16:10
Re: How to make a MySQL Admin System! - by daddyblake - 13.03.2013, 17:22
Re: How to make a MySQL Admin System! - by kamzaf - 14.03.2013, 18:52
Re: How to make a MySQL Admin System! - by M0nSt3r - 20.03.2013, 22:14
Re: How to make a MySQL Admin System! - by Scenario - 20.03.2013, 22:21
Re: How to make a MySQL Admin System! - by kamzaf - 20.03.2013, 23:18
Re: How to make a MySQL Admin System! - by Scenario - 20.03.2013, 23:53
Respuesta: How to make a MySQL Admin System! - by PabloDiCostanzo - 21.03.2013, 01:17
Re : Respuesta: How to make a MySQL Admin System! - by kamzaf - 21.03.2013, 02:30
Respuesta: How to make a MySQL Admin System! - by PabloDiCostanzo - 21.03.2013, 19:37
Re: How to make a MySQL Admin System! - by ReneG - 21.03.2013, 20:02
Re: How to make a MySQL Admin System! - by LarzI - 21.03.2013, 20:14
Re: How to make a MySQL Admin System! - by ReneG - 21.03.2013, 21:12
Re: How to make a MySQL Admin System! - by Konstantinos - 21.03.2013, 21:26
Re: How to make a MySQL Admin System! - by ReneG - 21.03.2013, 21:35
Re: How to make a MySQL Admin System! - by LarzI - 22.03.2013, 07:01
Re: Respuesta: How to make a MySQL Admin System! - by kamzaf - 25.03.2013, 21:26
Re: How to make a MySQL Admin System! - by Trooja - 29.03.2013, 20:48
Re: How to make a MySQL Admin System! - by kamzaf - 30.03.2013, 01:14
Re: How to make a MySQL Admin System! - by Trooja - 30.03.2013, 13:28
Re: How to make a MySQL Admin System! - by kamzaf - 30.03.2013, 17:14
Re: How to make a MySQL Admin System! - by Trooja - 30.03.2013, 20:58
Re: How to make a MySQL Admin System! - by Trooja - 01.04.2013, 13:14
Re: How to make a MySQL Admin System! - by kamzaf - 13.04.2013, 17:01
Re: How to make a MySQL Admin System! - by YanLanger - 29.09.2014, 13:31
Re: How to make a MySQL Admin System! - by vignesh007 - 29.09.2014, 14:13
Re: How to make a MySQL Admin System! - by Ryz - 05.10.2014, 05:06
Re: How to make a MySQL Admin System! - by Ryz - 22.10.2014, 12:51
Re: How to make a MySQL Admin System! - by Hittop65 - 30.11.2014, 01:56
Re: How to make a MySQL Admin System! - by DemME - 30.11.2014, 02:50

Forum Jump:


Users browsing this thread: 3 Guest(s)