[Unknown123]

Pawn Code:

pawn Код:

stock SavePlayerAccount(playerid)
{
    new queue[184];
    format(queue, sizeof(queue), "UPDATE `Players` SET AdminLevel= '%d', Score= '%d', Money= '%d', BankMoney= '%d', Kills= '%d', Deaths= '%d', Army= '%d', Swat= '%d', RobRank= '%d', TazerRank= '%d' WHERE Username= '%s'",
    PlayerData[playerid][AdminLevel], GetPlayerScore(playerid), GetPlayerMoney(playerid), PlayerData[playerid][BankMoney],
    PlayerData[playerid][Kills], PlayerData[playerid][Deaths], PlayerData[playerid][Army], PlayerData[playerid][Swat],
    PlayerData[playerid][RobRank], PlayerData[playerid][TazerRank], PlayerName(playerid));
    mysql_query(queue);
    return 1;
}

Error:

Код:

Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Unkn' at line 1.

pawn Код:

use near ''Unkn' at line 1. //Look, It dont get my full name (Unknown123)

[Bumbis]

maybe the string lenght is too short.

[Hiddos]

Quote:

Originally Posted by silvis123 maybe the string lenght is too short.

Yep, it's way too short. The 'unformatted' string itself IS 184 characters/cells, so it will not fit when you try to format it lol.

[Unknown123]

Quote:

Originally Posted by silvis123 maybe the string lenght is too short.

Indeed xD I changed it to

pawn Код:

new queue[256];

And now it works

-Thanks