[Deroxi]

For some reason the score of a player is not updating in MySQL:

PHP код:

public OnPlayerDisconnect(playerid, reason)
{
    new
        query[128],
        Float:pos[4],
        name[24],
        score;
    GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
    GetPlayerFacingAngle(playerid, pos[3]);
    GetPlayerName(playerid, name, 24);
    GetPlayerScore(playerid, Player[playerid][Score]);
    mysql_format(mysql, query, sizeof(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(mysql, query, sizeof query, "UPDATE 'accounts' SET 'Score' = '%i' WHERE 'Name' = '%s'", score, name);
    mysql_tquery(mysql, query, "", "");
    return true;
} 


[Dayrion]

Hm. Did you redefine GetPlayerScore ?

PHP код:

GetPlayerScore(playerid, Player[playerid][Score]); 


This should be better.

PHP код:

Player[playerid][Score] = GetPlayerScore(playerid); 


[Deroxi]

I got it working already, I think:

PHP код:

    mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'",GetPlayerMoney(playerid),GetPlayerScore(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]); 


[Dayrion]

Quote:

Originally Posted by Deroxi I got it working already, I think: PHP код:     mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'",GetPlayerMoney(playerid),GetPlayerScore(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);

This is working too but your variable wont get updated.

[Deroxi]

I dont get it? Why wouldn't my var update?
Its on OnPlayerDisconnect(), so when they login again it gets loaded

[oMa37]

Quote:

Originally Posted by Dayrion This is working too but your variable wont get updated.

Can i know why?
How he did will get it updated and everything fine.

[Deroxi]

Quote:

Originally Posted by oMa37 Can i know why? How he did will get it updated and everything fine.

It isn't

[Dayrion]

Oh, I mean this variable : Player[playerid][Score].
It will be updated anyway?

[oMa37]

This would be better:

PHP код:

Player[playerid][Score] = GetPlayerScore(playerid);
Player[playerid][Money] = GetPlayerMoney(playerid);
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'", Player[playerid][Money],  Player[playerid][Score], pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]); 


[Deroxi]

Quote:

Originally Posted by oMa37 This would be better: PHP код: Player[playerid][Score] = GetPlayerScore(playerid); Player[playerid][Money] = GetPlayerMoney(playerid); mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'", Player[playerid][Money],  Player[playerid][Score], pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);

I did that, didn't work