В логах все нормально, кинь запрос на прямую в базу, что вернет?
P.S: phpmyadmin > sql
PHP код:
UPDATE `accounts` SET `player_name` = 'свой_ник', `password` = 'char_passwords', `pol` = '1', `skin` = '1' WHERE `ID` = 'свой_ид_аккаунта'
В логах все нормально, кинь запрос на прямую в базу, что вернет?
P.S: phpmyadmin > sql
PHP код:
UPDATE `accounts` SET `player_name` = 'свой_ник', `password` = 'char_passwords', `pol` = '1', `skin` = '1' WHERE `ID` = 'свой_ид_аккаунта'
В логах:
Скин так же не появляется и пол. Сохраняется только пароль.Код HTML:[17:09:22] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "first_database", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [17:09:22] [DEBUG] CMySQLHandle::Create - creating new connection.. [17:09:22] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [17:09:22] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [17:09:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [17:09:22] [DEBUG] CMySQLConnection::Connect - connection was successful [17:09:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [17:09:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [17:09:22] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [17:09:22] [DEBUG] CMySQLConnection::Connect - connection was successful [17:09:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [17:09:22] [DEBUG] CMySQLConnection::Connect - connection was successful [17:09:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [17:09:22] [DEBUG] CMySQLConnection::Connect - connection was successful [17:09:22] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [17:09:53] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `password` FROM `accounts` WHERE `player_name` = 'Kent_No", callback: "FindPlayerInTable", format: "i" [17:09:53] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - starting query execution [17:09:53] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - query was successfully executed within 11.357 milliseconds [17:09:53] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [17:09:53] [DEBUG] Calling callback "FindPlayerInTable".. [17:09:53] [DEBUG] cache_get_data - connection: 1 [17:09:53] [DEBUG] cache_get_field_content - row: 0, field_name: "password", connection: 1, max_len: 30 [17:09:53] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "password", data: "123456" [17:09:53] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [17:09:57] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `player_name` = 'Kent_No'", callback: "UploadPlayerAccount", format: "i" [17:09:57] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccount] - starting query execution [17:09:57] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccount] - query was successfully executed within 0.450 milliseconds [17:09:57] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [17:09:57] [DEBUG] Calling callback "UploadPlayerAccount".. [17:09:57] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1 [17:09:57] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "35" [17:09:57] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
Ну вот, так и сделал.
Код HTML:[20:55:58] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "first_database", password: "****", port: 3306, autoreconnect: true, pool_size: 2 [20:55:58] [DEBUG] CMySQLHandle::Create - creating new connection.. [20:55:58] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called [20:55:58] [DEBUG] CMySQLHandle::Create - connection created (id: 1) [20:55:58] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:55:58] [DEBUG] CMySQLConnection::Connect - connection was successful [20:55:58] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:55:58] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `password` FROM `accounts` WHERE `player_name` = 'Kent_No", callback: "FindPlayerInTable", format: "i" [20:55:58] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:55:58] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:55:58] [DEBUG] CMySQLConnection::Connect - establishing connection to database... [20:55:58] [DEBUG] CMySQLConnection::Connect - connection was successful [20:55:58] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:55:58] [DEBUG] CMySQLConnection::Connect - connection was successful [20:55:58] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:55:58] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - starting query execution [20:55:58] [DEBUG] CMySQLQuery::Execute[FindPlayerInTable] - query was successfully executed within 0.615 milliseconds [20:55:58] [DEBUG] CMySQLConnection::Connect - connection was successful [20:55:58] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:55:58] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled [20:55:58] [DEBUG] Calling callback "FindPlayerInTable".. [20:55:58] [DEBUG] cache_get_data - connection: 1 [20:55:58] [DEBUG] cache_get_field_content - row: 0, field_name: "password", connection: 1, max_len: 30 [20:55:58] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "password", data: "123456" [20:55:58] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called [20:56:03] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `player_name` = 'Kent_No'", callback: "UploadPlayerAccount", format: "i" [20:56:03] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccount] - starting query execution [20:56:03] [DEBUG] CMySQLQuery::Execute[UploadPlayerAccount] - query was successfully executed within 0.533 milliseconds [20:56:03] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:56:03] [DEBUG] Calling callback "UploadPlayerAccount".. [20:56:03] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1 [20:56:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "36" [20:56:03] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
И прости какой жопой, тебе в логах от сервера это показало? -_-
Пожалуй пора документацию от sql читать
Короче ладно, я это не понимаю. Извини что украл время.
Эту тему просматривают: 1 (пользователей: 0 , гостей: 1)