PDA

Просмотр полной версии : [Вопрос] Не сохраняет аккаунты в БД


Poe
04.12.2016, 00:17
Добрый вечер, столкнулся с такой проблемой, что после регистрации аккаунт не сохраняется полностью, проигнорированы pSex и pSkin.
Помогите разобраться человеку, который не шарит в работе с MySQL:)
Создание аккаунта:

stock CreateNewAccount(playerid, password[])
{
new query_string[66+MAX_PLAYER_NAME-4+30];
format(query_string, sizeof(query_string), "INSERT INTO `accounts` (`player_name`, `password`) VALUES ('%s', '%s')", pInfo[playerid][pName], password);
mysql_tquery(mysql_connect_ID, query_string, "UploadPlayerAccountNumber", "i", playerid);
SetPlayerAuthorized(playerid, PLAYER_ONLINE);
SpawnPlayer(playerid);
return 1;
}

Сохранение аккаунта:

stock SaveAccount(playerid)
{
new query_string[(21)+(16+11)+(20+MAX_PLAYER_NAME)+(16+30)] = "UPDATE `accounts` SET";

format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, pInfo[playerid][pID]);
format(query_string, sizeof(query_string), "%s `sex` = '%s',", query_string, pInfo[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `skin` = '%s',", query_string, pInfo[playerid][pSkin]);
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]);
mysql_tquery(mysql_connect_ID, query_string, "", "");
return 1;
}
gangzone.ini
04.12.2016, 01:18
stock SaveAccount(playerid)
{
new query_string[(21)+(16+11)+(20+MAX_PLAYER_NAME)+(16+30)] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `sex` = '%d',", query_string, pInfo[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `skin` = '%d',", query_string, pInfo[playerid][pSkin]);
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 WHERE `id` = '%d'", query_string, pInfo[playerid][pID]);
mysql_tquery(mysql_connect_ID, query_string, "", "");
return 1;
}
Poe
04.12.2016, 10:01
stock SaveAccount(playerid)
{
new query_string[(21)+(16+11)+(20+MAX_PLAYER_NAME)+(16+30)] = "UPDATE `accounts` SET";
format(query_string, sizeof(query_string), "%s `sex` = '%d',", query_string, pInfo[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `skin` = '%d',", query_string, pInfo[playerid][pSkin]);
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 WHERE `id` = '%d'", query_string, pInfo[playerid][pID]);
mysql_tquery(mysql_connect_ID, query_string, "", "");
return 1;
}


Спасибо