[austin070]

EDIT: FIXED

I can't get mySQL to save player position. Here is my code:

pawn Код:

SavePlayerData(playerid)
{
    new Float:x, Float:y, Float:z, Float:a;
    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, a);
    
    new query[600];
    format(query, 600, "UPDATE accounts SET LastX = '%f', LastY = '%f', LastZ = '%f', LastA = '%f' WHERE ID = '%d'", x, y, z, a, PlayerInfo[playerid][ID]);
    mysql_query(query);
    return 1;
}

Note: Please don't make a comment on my signature. I've already used ****** -.-

[Retardedwolf]

pawn Код:

UPDATE accounts SET ( LastX, LastY, LastZ, LastA ) WHERE ID = '%d' VALUES( '%f', '%f', '%f', '%f' )

Try that query.

[=WoR=G4M3Ov3r]

I don't know what you mean exactly, but if its not saving in the .sql database, try using this

PHP код:

ConnectToDatabase(); 


[austin070]

Quote:

Originally Posted by Retardedwolf pawn Код: UPDATE accounts SET ( LastX, LastY, LastZ, LastA ) WHERE ID = '%d' VALUES( '%f', '%f', '%f', '%f' ) Try that query.

I fixed it right before you posted. I changed

pawn Код:

WHERE ID = '%d'

to

pawn Код:

WHERE Name = '%s'

Thank you for the response, anyway.

[Retardedwolf]

Using the mysql_debug function could also help a lot.

[[HiC]TheKiller]

pawn Код:

mysql_debug(1);

On OnGameModeInit then go to the MySQL log in the server directory and paste it here.