Pawno.INC
Умник
Сама ошибка
Stock сохранения аккаунтов
В чем ошибка ? если поможете отблагодарю +++.
PHP:
[11:43:29] [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 '`pLevel` = '1' `pExp` = '4' `pPayDay` = '6' `pPayCheck` = '0' `pSex` = '1' `pAdm' at line 1
PHP:
stock UpdateAccount(playerid)
{
new query_string[1800] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `pKey` = '%s'", query_string, PlayerData[playerid][pKey]);
format(query_string, sizeof(query_string), "%s `pLevel` = '%d'", query_string, PlayerData[playerid][pLevel]);
format(query_string, sizeof(query_string), "%s `pExp` = '%d'", query_string, PlayerData[playerid][pExp]);
format(query_string, sizeof(query_string), "%s `pPayDay` = '%d'", query_string, PlayerData[playerid][pPayDay]);
format(query_string, sizeof(query_string), "%s `pPayCheck` = '%d'", query_string, PlayerData[playerid][pPayCheck]);
format(query_string, sizeof(query_string), "%s `pSex` = '%d'", query_string, PlayerData[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `pAdmin` = '%d'", query_string, PlayerData[playerid][pAdmin]);
format(query_string, sizeof(query_string), "%s `pHelper` = '%d'", query_string, PlayerData[playerid][pHelper]);
format(query_string, sizeof(query_string), "%s `pMuted` = '%d'", query_string, PlayerData[playerid][pMuted]);
format(query_string, sizeof(query_string), "%s `pWarn` = '%d'", query_string, PlayerData[playerid][pWarn]);
format(query_string, sizeof(query_string), "%s `pWarnTime` = '%d'", query_string, PlayerData[playerid][pWarnTime]);
format(query_string, sizeof(query_string), "%s `pJail` = '%d'", query_string, PlayerData[playerid][pJail]);
format(query_string, sizeof(query_string), "%s `pJailTime` = '%d'", query_string, PlayerData[playerid][pJailTime]);
format(query_string, sizeof(query_string), "%s `pChar` = '%d'", query_string, PlayerData[playerid][pChar]);
format(query_string, sizeof(query_string), "%s `pModel` = '%d'", query_string, PlayerData[playerid][pModel]);
format(query_string, sizeof(query_string), "%s `pMember` = '%d'", query_string, PlayerData[playerid][pMember]);
format(query_string, sizeof(query_string), "%s `pLeader` = '%d'", query_string, PlayerData[playerid][pLeader]);
format(query_string, sizeof(query_string), "%s `pRank` = '%d'", query_string, PlayerData[playerid][pRank]);
format(query_string, sizeof(query_string), "%s `pJob` = '%d'", query_string, PlayerData[playerid][pJob]);
format(query_string, sizeof(query_string), "%s `pCash` = '%d'", query_string, PlayerData[playerid][pCash]);
format(query_string, sizeof(query_string), "%s `pBank` = '%d'", query_string, PlayerData[playerid][pBank]);
format(query_string, sizeof(query_string), "%s `pSIM` = '%d'", query_string, PlayerData[playerid][pSIM]);
format(query_string, sizeof(query_string), "%s `pSIMBalance` = '%d'", query_string, PlayerData[playerid][pSIMBalance]);
format(query_string, sizeof(query_string), "%s `pCarKey` = '%d'", query_string, PlayerData[playerid][pCarKey]);
format(query_string, sizeof(query_string), "%s `pBizzKey` = '%d'", query_string, PlayerData[playerid][pBizzKey]);
format(query_string, sizeof(query_string), "%s WHERE `Name` = '%s'", query_string, PlayerData[playerid][pNames]);
mysql_function_query(connects, query_string, false, "", "");
return 1;
}
Последнее редактирование:
