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
#2

That should work.
PHP код:
public OnPlayerDisconnect(playeridreason)
{
    new
        
query[128],
        
Float:pos[4];
    
GetPlayerPos(playeridpos[0], pos[1], pos[2]);
    
GetPlayerFacingAngle(playeridpos[3]);
    
GetPlayerScore(playeridPlayer[playerid][Score]);
    
mysql_format(mysqlquerysizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'",GetPlayerMoney(playerid),Player[playerid][Score], pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
    
mysql_tquery(mysqlquery);
    return 
true;

Reply
#3

Thanks
Reply
#4

use GetPlayerMoney, GetPlayerScore for updating.

Quote:
Originally Posted by BloodyRP
Посмотреть сообщение
Already fixed by me, bro
I'm just saying to avoid this in future.
Reply
#5

Quote:
Originally Posted by oMa37
Посмотреть сообщение
use GetPlayerMoney, GetPlayerScore for updating.
Already fixed by me, bro
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)