Mysql Saving data problem
#1

Hello, everyone. I've been trying from a while to save the player data upon the player leaves the server, I've been trying to script it from a long time but I keep on getting error in one line ( marked it on the code provided below ). Can anyone help me out to resolve this issue and explain of where I went wrong? ( Plug version is R39-9 ).

PHP код:
    new Query[900];
    
GetPlayerName(playeridQueryMAX_PLAYER_NAME);
    
mysql_real_escape_string(QueryQuery);
    
format(Querysizeof(Query), "UPDATE `accounts` SET `Admin` = '%d', `VIP` = '%d', `Money` = '%d', `Kills` = '%d', `Deaths` = '%d', `Score` = '%d' WHERE `Name` = '%s'",
                                  
Player[playerid][Admin],
                                  
Player[playerid][VIP],
                                  
Player[playerid][Money],
                                  
Player[playerid][Kills],
                                  
Player[playerid][Deaths],
                                  
Player[playerid][Score],
                                  
Query);
    
mysql_query(Query);
    return 
1;

Reply


Messages In This Thread
Mysql Saving data problem - by DeeadPool - 10.04.2017, 08:09
Re: Mysql Saving data problem - by Stev - 10.04.2017, 08:12
Re: Mysql Saving data problem - by Sjn - 10.04.2017, 08:28
Re: Mysql Saving data problem - by DeeadPool - 10.04.2017, 08:56
Re: Mysql Saving data problem - by DeeadPool - 10.04.2017, 20:11
Re: Mysql Saving data problem - by Vince - 10.04.2017, 20:19
Re: Mysql Saving data problem - by DeeadPool - 10.04.2017, 22:27
Re: Mysql Saving data problem - by Sanady - 10.04.2017, 22:49
Re: Mysql Saving data problem - by DeeadPool - 10.04.2017, 22:52
Re: Mysql Saving data problem - by Sanady - 10.04.2017, 23:08

Forum Jump:


Users browsing this thread: 1 Guest(s)