UnO33
Специалист
В общем вот такой код работает:
А вот такой нет,хз почему...
Вот вырезка из mysql_log.txt.
1 код:
PHP:
new str[128];
format(str,sizeof(str),"UPDATE `Accounts` SET `Level` = '%i', `Admin` = '%i', `Gang` = '%i'",//, `Kills` = '%i', `Deaths` = '%i', `Skin` = '%i'",
PlayerInfo[p][pLevel], PlayerInfo[p][pAdmin], PlayerInfo[p][pGang]);//, PlayerInfo[p][pKills], PlayerInfo[p][pDeaths], PlayerInfo[p][pSkin]);
format(str, sizeof(str),"%s WHERE `Name` = '%s'", str, Name(p));
mysql_function_query(connectionHandle,str,false, "","iiis",p);
PHP:
new src[1024], pname[MAX_PLAYER_NAME], query[256]; GetPlayerName(p, pname, sizeof(pname));
/////////////////////////////////
format(query,sizeof(query),"UPDATE `Acoounts` SET ");
format(src,sizeof(src)," `Level` = '%i',",PlayerInfo[p][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," `Admin` = '%i',",PlayerInfo[p][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," `Gang` = '%i',",PlayerInfo[p][pGang]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," `Kills` = '%i',",PlayerInfo[p][pKills]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," `Deaths` = '%i',",PlayerInfo[p][pDeaths]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," `Skin` = '%i'",PlayerInfo[p][pSkin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE `Name` = '%s'",pname);
strcat(query,src,sizeof(query));
mysql_function_query(connectionHandle,query,false, "","",p);
1 код:
2 код:[16:42:04] Passing query UPDATE `Accounts` SET `Level` = '0', `Admin` = '0', `Gang` = '0' WHERE `Name` = 'UnO' | iiis
[16:42:04] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `Level` = '0', `Admin` = '0', `Gang` = '0' WHERE `Name` = 'UnO')
[16:42:04] CMySQLHandler:rocessQueryThread() - Data is getting passed to ->ProcessTick()
Не понимаю чем отличаться запросы друг от друга,но первый работает,а второй нет.[16:58:53] Passing query UPDATE `Acoounts` SET `Level` = '0', `Admin` = '0', `Gang` = '0', `Kills` = '0', `Deaths` = '', `Skin` = '0' WHERE `Name` = 'UnO' | iiis
[16:58:53] CMySQLHandler:rocessQueryThread() - Error will be triggered to OnQueryError()
