SaveAcc

[Huseyn]

Всем привет , у меня проблема с сохранением аккаунта, вот код ошибки.

[ERROR] error #1064 while executing query "INSERT INTO `accounts` (`player_name`, `password`, `level`, `pol_player`, `skin_player`, `money_player`) VALUES ('NICK', '12345', '1', '1', '79": 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 ''79' at line 1

stock SaveAccount(playerid)
{
    new query_string[700] = "UPDATE `accounts` SET";

    format(query_string, sizeof(query_string), "%s `player_name` = '%s',", query_string, pInfo[playerid][pName]);
    format(query_string, sizeof(query_string), "%s `password` = '%s',", query_string, pInfo[playerid][pPassword]);
    format(query_string, sizeof(query_string), "%s `admin` = '%d',", query_string, pInfo[playerid][pAdmin]);
    format(query_string, sizeof(query_string), "%s `level` = '%d',", query_string, pInfo[playerid][pLevel]);
    format(query_string, sizeof(query_string), "%s `spawn` = '%d',", query_string, pInfo[playerid][pSpawn]);
    format(query_string, sizeof(query_string), "%s `pol_player` = '%d',", query_string, pInfo[playerid][pSex]);
    format(query_string, sizeof(query_string), "%s `skin_player` = '%d',", query_string, pInfo[playerid][pSkin]);
    format(query_string, sizeof(query_string), "%s `money_player` = '%d',", query_string, pInfo[playerid][pMoney]);
    format(query_string, sizeof(query_string), "%s `leader` = '%d',", query_string, pInfo[playerid][pLeader]);
    format(query_string, sizeof(query_string), "%s `member` = '%d',", query_string, pInfo[playerid][pMember]);
    format(query_string, sizeof(query_string), "%s `memberskin` = '%d',", query_string, pInfo[playerid][pMemberSkin]);
    format(query_string, sizeof(query_string), "%s `rank` = '%d',", query_string, pInfo[playerid][pRank]);
    format(query_string, sizeof(query_string), "%s `templeader` = '%d',", query_string, pInfo[playerid][pTempLeader]);
    format(query_string, sizeof(query_string), "%s `leader_warn` = '%d',", query_string, pInfo[playerid][pLwarn]);
    format(query_string, sizeof(query_string), "%s `mute_player` = '%d',", query_string, pInfo[playerid][pMute]);
    format(query_string, sizeof(query_string), "%s `exp` = '%d',", query_string, pInfo[playerid][pExp]);
    format(query_string, sizeof(query_string), "%s `zakon` = '%d',", query_string, pInfo[playerid][pZakon]);
    format(query_string, sizeof(query_string), "%s `age` = '%d',", query_string, pInfo[playerid][pAge]);
    format(query_string, sizeof(query_string), "%s `warn` = '%d',", query_string, pInfo[playerid][pWarn]);
    format(query_string, sizeof(query_string), "%s `warn_skok` = '%d',", query_string, pInfo[playerid][pUnWarn]);
    format(query_string, sizeof(query_string), "%s `wanted` = '%d',", query_string, pInfo[playerid][pWanted]);
    format(query_string, sizeof(query_string), "%s `wantedtime` = '%d',", query_string, pInfo[playerid][pWantedTime]);
    format(query_string, sizeof(query_string), "%s `crimes` = '%d',", query_string, pInfo[playerid][pCrimes]);
    format(query_string, sizeof(query_string), "%s `rep` = '%d'", query_string, pInfo[playerid][pRep]);

    format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, pInfo[playerid][pID]);
    mysql_tquery(mysql_connect_ID, query_string, "", "");

    foreach(new i: Player)
	{
		if(PlayerLogged[i] == false) continue;
	  	SaveAccount(playerid );
 	}
    return 1;
}

---------- Сообщение добавлено в 18:10 ---------- Предыдущее сообщение добавлено в 18:09 ----------

stock CreateNewAccount(playerid, password[])
{
    new query_string[66+MAX_PLAYER_NAME-4+30+50];
    format(query_string, sizeof(query_string), "INSERT INTO `accounts` (`player_name`, `password`, `level`, `pol_player`, `skin_player`, `money_player`) VALUES ('%s', '%s', '1', '%d', '%d', '560')", pInfo[playerid][pName], password, pInfo[playerid][pSex], pInfo[playerid][pSkin]);
    mysql_tquery(mysql_connect_ID, query_string, "UploadPlayerAccountNumber", "i", playerid);
    pInfo[playerid][pLevel] = 1; //new
    pInfo[playerid][pMoney] = 560;//new
    pInfo[playerid][pSpawn] = 1;//new
   	GivePlayerMoney(playerid, pInfo[playerid][pMoney]);//new
   	SetPlayerScore(playerid, pInfo[playerid][pLevel]);//new
    format(query_string, sizeof(query_string), "Аккаунт %s успешно зарегистрирован. Администрация желает Вам приятной игры!", pInfo[playerid][pName]);
    SendClientMessage(playerid, 0xFFFFFF00, query_string);
    SetPlayerAuthorized(playerid, PLAYER_ONLINE);
    SpawnPlayer(playerid);
    TogglePlayerSpectating(playerid, false);
    return 1;
}