07.05.2018, 16:54
Many thanks for your help, I solved the problem myself.
Arranged commas as follows and the account is saved successfully.
Arranged commas as follows and the account is saved successfully.
PHP код:
/* ======================================================================== */
stock SaveAccount(playerid)
{
new query_string[(1000)+(1000+11)+(100+MAX_PLAYER_NAME)+(100+100)] = "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 `sex` = '%d',", query_string, pInfo[playerid][pSex]);
format(query_string, sizeof(query_string), "%s `rasa` = '%d',", query_string, pInfo[playerid][pRasa]);
format(query_string, sizeof(query_string), "%s `religia` = '%d'", query_string, pInfo[playerid][pReligia]);
format(query_string, sizeof(query_string), "%s WHERE `id` = '%d'", query_string, pInfo[playerid][pID]);
mysql_function_query(mysql_connect_ID, query_string, false, "", "");
return printf("Данные аккаунта № %d (%s) были сохранены.", pInfo[playerid][pID], pInfo[playerid][pName]);
}