Score not updating (Mysql)
#1

So for some reason the score of a player wont update to mysql:
PHP код:
public OnPlayerDisconnect(playeridreason)
{
    new
        
query[128],
        
Float:pos[4],
        
name[24],
        
score;
    
GetPlayerPos(playeridpos[0], pos[1], pos[2]);
    
GetPlayerFacingAngle(playeridpos[3]);
    
GetPlayerName(playeridname24);
    
GetPlayerScore(playeridPlayer[playerid][Score]);
    
mysql_format(mysqlquerysizeof(query), "UPDATE `accounts` SET `Money` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f WHERE `ID` = %d",
    
GetPlayerMoney(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
    
mysql_format(mysqlquerysizeof query"UPDATE 'accounts' SET 'Score' = '%i' WHERE 'Name' = '%s'"scorename);
    
mysql_tquery(mysqlquery"""");
    return 
true;

Could you help me out?
Reply


Messages In This Thread
Score not updating (Mysql) - by Deroxi - 02.06.2016, 13:27
Re: Score not updating (Mysql) - by BloodyRP - 02.06.2016, 13:30
Re: Score not updating (Mysql) - by Deroxi - 02.06.2016, 13:33
Re: Score not updating (Mysql) - by oMa37 - 02.06.2016, 13:39
Re: Score not updating (Mysql) - by BloodyRP - 02.06.2016, 13:43

Forum Jump:


Users browsing this thread: 1 Guest(s)