Аккаунт

[Huseyn]

Здравствуйте P-I, у меня проблема с БД, при регистрации нового аккаунта, в БД не создаётся данный аккаунт.

вот код:

[21:06:09] [plugins/mysql] CCallback::Execute - invalid AMX instance
[21:06:09] [plugins/mysql] CCallback::Execute - invalid AMX instance
[21:06:33] [plugins/mysql] error #1136 while executing query "INSERT INTO `accounts` (`player_name`, `password`, `level`, `pol_player`, `skin_player`, `age`, `money_player`) VALUES ('pizdas', 'aaaa', '1', '1', '75', '560')": Column count doesn't match value count at row 1
[21:06:35] [plugins/mysql] error #1064 while executing query "INSERT INTO `accounts` (`player_name`, `password`, `level`, `pol_player`, `skin_player`, `age`, `money_player`) VALUES ('MENE_PIZDAa', 'huseyn', '1', '1', '18', '560": 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 ''560' at line 1
[21:06:41] [plugins/mysql] error #1054 while executing query "UPDATE `accounts` SET `player_name` = 'MENE_PIZDAa', `password` = 'huseyn', `admin` = '0', `level` = '1', `spawn` = '1', `pol_player` = '1', `skin_player` = '78', `money_player` = '560', `leader` = '0', `member` = '0', `memberskin` = '0', `rank` = '0', `templeader` = '0', `leader_warn` = '0', `mute_player` = '0', `exp` = '0', `zakon` = '0', `subsection` = '0', `age` = '18' WHERE `id` = '0'": Unknown column 'subsection' in 'field list'

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 `subsection` = '%d',", query_string, pInfo[playerid][pSubsection]);
    format(query_string, sizeof(query_string), "%s `age` = '%d'", query_string, pInfo[playerid][pAge]);

    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;
}

может быть и тут ошибка.

---------- Сообщение добавлено в 21:14 ---------- Предыдущее сообщение добавлено в 21:12 ----------

forward UploadPlayerAccount(playerid);
public UploadPlayerAccount(playerid)
{
    cache_get_value_name_int(0, "id", pInfo[playerid][pID]);
    cache_get_value_name_int(0, "admin", pInfo[playerid][pAdmin]);
    cache_get_value_name_int(0, "level", pInfo[playerid][pLevel]);
    cache_get_value_name_int(0, "spawn", pInfo[playerid][pSpawn]);
    cache_get_value_name_int(0, "pol_player", pInfo[playerid][pSex]);
    cache_get_value_name_int(0, "skin_player", pInfo[playerid][pSkin]);
    cache_get_value_name_int(0, "money_player", pInfo[playerid][pMoney]);
    cache_get_value_name_int(0, "leader", pInfo[playerid][pLeader]);
    cache_get_value_name_int(0, "member", pInfo[playerid][pMember]);
    cache_get_value_name_int(0, "memberskin", pInfo[playerid][pMemberSkin]);
    cache_get_value_name_int(0, "rank", pInfo[playerid][pRank]);
    cache_get_value_name_int(0, "templeader", pInfo[playerid][pTempLeader]);
    cache_get_value_name_int(0, "leader_warn", pInfo[playerid][pLwarn]);
    cache_get_value_name_int(0, "mute_player", pInfo[playerid][pMute]);
    cache_get_value_name_int(0, "exp", pInfo[playerid][pExp]);
    cache_get_value_name_int(0, "zakon", pInfo[playerid][pZakon]);
    cache_get_value_name_int(0, "subsection", pInfo[playerid][pSubsection]);
    cache_get_value_name_int(0, "age", pInfo[playerid][pAge]);