PHP код:
[14:03:05] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 ' Pohodka=0, Member=0, Leader=0, Rank=0, Mute=0 WHERE Name='Edi_Alvares'' at line 1
[14:03:06] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 ' Pohodka=0, Member=0, Leader=0, Rank=0, Mute=0 WHERE Name='Edi_Alvares'' at line 1
[14:03:07] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 ' Pohodka=0, Member=0, Leader=0, Rank=0, Mute=0 WHERE Name='Edi_Alvares'' at line 1
PHP код:
stock SavePlayer(playerid)
{
if(Logged[playerid] == true || IsPlayerConnected(playerid))
{
new query[500] = "UPDATE "table_account" SET ";
format(query, sizeof(query), "%s Skin=%d,", query, PlayerInfo[playerid][pSkin]);//7+3
format(query, sizeof(query), "%s Sex=%d,", query, PlayerInfo[playerid][pSex]);//6+1
format(query, sizeof(query), "%s Cash=%d,", query, PlayerInfo[playerid][pCash]);//7+11
format(query, sizeof(query), "%s Level=%d,", query, PlayerInfo[playerid][pLevel]);//8+11
format(query, sizeof(query), "%s Admin=%d,", query, PlayerInfo[playerid][pAdmin]);//8+2
format(query, sizeof(query), "%s Rasa=%d,", query, PlayerInfo[playerid][pRasa]);//7+2
format(query, sizeof(query), "%s Gorod=%d,", query, PlayerInfo[playerid][pGorod]);//7+1
format(query, sizeof(query), "%s Exp=%d,", query, PlayerInfo[playerid][pExp]);
format(query, sizeof(query), "%s AdminKey=%s,", query, PlayerInfo[playerid][pAdminKey]);
format(query, sizeof(query), "%s Pohodka=%d,", query, PlayerInfo[playerid][pPohodka]);
format(query, sizeof(query), "%s Member=%d,", query, PlayerInfo[playerid][pMember]);
format(query, sizeof(query), "%s Leader=%d,", query, PlayerInfo[playerid][pLeader]);
format(query, sizeof(query), "%s Rank=%d,", query, PlayerInfo[playerid][pRank]);
format(query, sizeof(query), "%s Mute=%d", query, PlayerInfo[playerid][pMute]);
format(query, sizeof(query), "%s WHERE Name='%s'", query, GN(playerid));//14+MAX_PLAYER_NAME
mysql_function_query(mysql_connection, query, false, "", "");
}
else printf("Îøèáêà ñîõðàí¸íèÿ.");
return true;
}