Сохранение

**$continue$** · 22.03.2015, 15:41

В логах все нормально, кинь запрос на прямую в базу, что вернет?
P.S: phpmyadmin > sql

PHP код:


UPDATE `accounts` SET `player_name` = 'свой_ник', `password` = 'char_passwords', `pol` = '1', `skin` = '1' WHERE `ID` = 'свой_ид_аккаунта'

**Skyline** · 22.03.2015, 18:11

В логах:

Код 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

Скин так же не появляется и пол. Сохраняется только пароль.

**$continue$** · 22.03.2015, 21:05

Сообщение от Skyline

В логах:

Код 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

Скин так же не появляется и пол. Сохраняется только пароль.

-_-

Напрямую в базу, сказал же phpmyadmin > sql

**Skyline** · 22.03.2015, 21:56

Ну вот, так и сделал.

Код 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

**$continue$** · 22.03.2015, 21:57

И прости какой жопой, тебе в логах от сервера это показало? -_-
Пожалуй пора документацию от sql читать

**Skyline** · 22.03.2015, 23:06

Короче ладно, я это не понимаю. Извини что украл время.

Тема: Сохранение

Опции темы

Поиск по теме

Информация о теме

Пользователи, просматривающие эту тему

Ваши права