Error ID: 1064

[Mr.DeViLsS]

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 '`Sex` = 1,`Reg` = 1,`Skin` = 170,`Ban` = 0,`Level` = 0,`Exp` = 0,`Money` = 0,`Le' at line 1)


CMySQLHandler::Query(UPDATE `accounts` SET `Email` = 'None',`AdminLevel` = 5`Sex` = 1,`Reg` = 1,`Skin` = 170,`Ban` = 0,`Level` = 0,`Exp` = 0,`Money` = 0,`Leader` = 0,`Member` = 0,`Rank` = 0,`Team` = 0,`Online` = 0 WHERE `Name`= 'Francis_Warren') - 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 '`Sex` = 1,`Reg` = 1,`Skin` = 170,`Ban` = 0,`Level` = 0,`Exp` = 0,`Money` = 0,`Le' at line 1)


stock SaveAccount(playerid)
{
if(GetPVarInt(playerid, "Logged") == 0) return 1;
new src[128], name[24];
GetPlayerName(playerid, name, 24);
format(mysqlquery,sizeof(mysqlquery),"UPDATE `"T_ACCOUNT"` SET ");

format(src,sizeof(src),"`Email` = '%s',",PlayerInfo[playerid][pEmail]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`AdminLevel` = %i",PlayerInfo[playerid][pAdminkalev]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Sex` = %i,",PlayerInfo[playerid][pSex]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Reg` = %i,",PlayerInfo[playerid][pReg]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Skin` = %i,",PlayerInfo[playerid][pSkin]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Ban` = %i,",PlayerInfo[playerid][pBan]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Level` = %i,",PlayerInfo[playerid][pLevel]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Exp` = %i,",PlayerInfo[playerid][pExp]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Money` = %i,",PlayerInfo[playerid][pMoney]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Leader` = %i,",PlayerInfo[playerid][pLeader]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Member` = %i,",PlayerInfo[playerid][pMember]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Rank` = %i,",PlayerInfo[playerid][pRank]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Team` = %i,",PlayerInfo[playerid][pTeam]);
strcat(mysqlquery,src,sizeof(mysqlquery));
format(src,sizeof(src),"`Online` = %i",PlayerInfo[playerid][pOnline]);
strcat(mysqlquery,src,sizeof(mysqlquery));

format(src,sizeof(src)," WHERE `Name`= '%s'",name);
strcat(mysqlquery,src,sizeof(mysqlquery));
mysql_query(mysqlquery);
return 1;
}

[KShaddix]

format(src,sizeof(src),"`AdminLevel` = %i",PlayerInfo[playerid][pAdminkalev]);
Запятой после %i нет.

[Mr.DeViLsS]

Запятой после %i нет.

спасибо )

[Salvacore]

Closed.