nak
Ученик
Вот код сохранения
а вот ошибка
PHP:
stock SaveAccount(playerid)
{
if(PlayerLogged[playerid] == 0) return 1;
new src[1024];
/////////////////////////////////
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
format(src,sizeof(src),"Password='%s',",PlayerInfo[playerid][pPassword]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Cash=%d,",PlayerInfo[playerid][pCash]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Bank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Admin=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Char=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Exp=%d",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE Name='%s' LIMIT 1",PN(playerid));
strcat(query,src,sizeof(query));
mysql_query(query);
return 1;
}
PHP:
CMySQLHandler::Query(UPDATE users SET Password='123456789',Level=1,Cash=300,Bank=0,Admin=0,Model=12,Char=0,Exp=0 WHERE Name='Nikita_Zubarev' LIMIT 1) - An error has occured. (Error ID: 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 'Char=0,Exp=0 WHERE Name='Nikita_Zubarev' LIMIT 1' at line 1)
Последнее редактирование:
