Сохранение

[Skyline]

Ошибка есть, походу стринг маленький судя по всему...
Для точности сделай так, и не выходя из игры кинь лог что выведет в чат:

stock SaveAccount(playerid)
{
     new string_test[500];
    new query_string[(21)+(16+11)+(19+MAX_PLAYER_NAME)+(16+30)] = "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 `pol` = '%d',", query_string, pInfo[playerid][pSex]);
    format(query_string, sizeof(query_string), "%s `skin` = '%d',", query_string, pInfo[playerid][pChar]);
    format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, pInfo[playerid][pID]);
    format(string_test, sizeof(string_test), "%s", query_string);
    SendClientMessageToAll(0xFFCD00ff, string_test);
    mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    return 1;
}  

OnPlayerUpdate

 /* НА ВРЕМЯ!! */
SaveAccount(playerid)  

Вот что использую.
Вот сам скрин. Ссылка
В игре все пишет правильно, но при этом в БД не записывается ни пол, ни скин.

[$continue$]

А если так?

stock SaveAccount(playerid)
{
    new query_string[(21)+(16+11)+(19+MAX_PLAYER_NAME)+(16+30)] = "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 `pol` = '%d',", query_string, pInfo[playerid][pSex]);
    format(query_string, sizeof(query_string), "%s `skin` = '%d'", query_string, pInfo[playerid][pChar]);
    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 1;
}  

[Skyline]

Не записывается, если оставить SaveAccounts(playerid); В OnPlayerUpdate, то записывает одну секунду, если перезайти, то все слетат так же и в БД все онулировано, (пол и скин)

[$continue$]

Логи mysql + скрин из игры

stock SaveAccount(playerid)
{
     new string_test[500];
    new query_string[(21)+(16+11)+(19+MAX_PLAYER_NAME)+(16+30)] = "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 `pol` = '%d',", query_string, pInfo[playerid][pSex]);
    format(query_string, sizeof(query_string), "%s `skin` = '%d'", query_string, pInfo[playerid][pChar]);
    format(query_string, sizeof(query_string), "%s WHERE `ID` = '%d'", query_string, pInfo[playerid][pID]);
    format(string_test, sizeof(string_test), "%s", query_string);
    SendClientMessageToAll(0xFFCD00ff, string_test);
    mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    return 1;
}  

[Skyline]

21:42:42] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 11.627 milliseconds
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:42] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 10.522 milliseconds
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:43] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 4.37 milliseconds
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:43] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 35.663 milliseconds
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:44] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:44] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:44] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 4.844 milliseconds
[21:42:44] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Скриншот.

[$continue$]

21:42:42] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 11.627 milliseconds
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:42] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 10.522 milliseconds
[21:42:42] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:43] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 4.37 milliseconds
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:43] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 35.663 milliseconds
[21:42:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[21:42:44] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `player_name` = 'Kent_No', `password` = '1", callback: "(null)", format: "(null)"
[21:42:44] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:42:44] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 4.844 milliseconds
[21:42:44] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Скриншот.

Все отлично сохранено по логам... Да и нету синтаксической ошибки в запросе...
До сих пор не сохраняет? mysql_log(LOG_ALL) включен?

[Skyline]

Не сохраняет.
А в БД записывал данные, т.к. мы вызывали SaveAccount в OnPlayerUpdate, но даже если записывали, то после перезахода все онулировалось и пол и скин = 0.
Причины так и не пойму.
А все показывало хорошо именно из-за OnPlayerUpdate - он делал каждую секунду сверку, но не сохранял, а только было назначение данных параметров, а после перезахода сохранения никакого не произошло.

mysql_log(LOG_ALL); Включен.

[$continue$]

Не сохраняет.
А в БД записывал данные, т.к. мы вызывали SaveAccount в OnPlayerUpdate, но даже если записывали, то после перезахода все онулировалось и пол и скин = 0.
Причины так и не пойму.
А все показывало хорошо именно из-за OnPlayerUpdate - он делал каждую секунду сверку, но не сохранял, а только было назначение данных параметров, а после перезахода сохранения никакого не произошло.

mysql_log(LOG_ALL); Включен.

Из OnPlayerUpdate уберай код вызов стока сохранение, по логом все спокойно, отчисть логи, зайди на сервер, оффнись покажи логи, нету ошибок

[Skyline]

[22:15:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `password` FROM `accounts` WHERE `player_name` = 'Kent_No", callback: "FindPlayerInTable", format: "i"
[22:15:08] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - starting query execution
[22:15:08] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - query was successfully executed within 1.972 milliseconds
[22:15:08] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:15:08] [DEBUG] Calling callback "FindPlayerInTable"..
[22:15:08] [DEBUG] cache_get_data - connection: 1
[22:15:08] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:15:11] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`player_name`, `password`) VALUES ('Kent", callback: "(null)", format: "(null)"
[22:15:11] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:15:12] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 17.820 milliseconds
[22:15:12] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:15:14] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `player_name` = 'Kent_No'", callback: "UploadPlayerAccount", format: "i"
[22:15:14] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccount] - starting query execution
[22:15:14] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccount] - query was successfully executed within 0.382 milliseconds
[22:15:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:15:14] [DEBUG] Calling callback "UploadPlayerAccount"..
[22:15:14] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[22:15:14] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "35"
[22:15:14] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

Вот без SaveAccount в OnPlayerUpdate.

[Skyline]

Проблема не устранена.