[Ahmed21]

Quote:

Originally Posted by Konstantinos Код: if (cache_get_row_count()) cache_get_row(0, 0, query); Field IDs start from 0. Can you enable LOG_ALL, remove anything written in mysql logs and let it load the houses? Afterwards, post your mysql logs.

Well, printf says loaded 10 houses but it loaded only the first because it's owned.

I removed the whole logs and made the file empty, and restarted the server, and here you are:

PHP код:

[05:50:04] [DEBUG] mysql_connect - host: "localhost", user: "f3413_ahcnr", database: "f3413_ahcnr", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[05:50:04] [DEBUG] CMySQLHandle::Create - creating new connection..
[05:50:04] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[05:50:04] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] mysql_errno - connection: 1
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM stores"
[05:50:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM stores", callback: "LoadStores", format: "(null)"
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM houses"
[05:50:04] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM houses", callback: "LoadHouses", format: "(null)"
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[05:50:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[05:50:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadStores] - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadStores] - query was successfully executed within 0.51 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadHouses] - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute[LoadHouses] - query was successfully executed within 0.211 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] Calling callback "LoadStores"..
[05:50:04] [DEBUG] cache_get_data - connection: 1
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "2"
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 1, connection: 1, max_len: 100
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "beloBolo"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 11, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "51"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 12, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '12', data: "15"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 14, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '14', data: "5"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 13, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '13', data: "29"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 2, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "-1808.61"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 3, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "945.813"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 4, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "24.8906"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 5, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "372.355"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 6, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "-133.523"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 7, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "1001.49"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 8, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "377.601"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 9, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "-113.971"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 10, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "1001.49"
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 0, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '0', data: "3"
[05:50:04] [DEBUG] cache_get_row - row: 1, field_idx: 1, connection: 1, max_len: 100
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '1', data: "Victim"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 11, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '11', data: "5000"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 12, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '12', data: "2500"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 14, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '14', data: "5"
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 13, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '13', data: "45"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 2, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '2', data: "-1694.58"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 3, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '3', data: "951.918"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 4, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '4', data: "24.8906"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 5, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '5', data: "227.563"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 6, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '6', data: "-8.1016"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 7, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '7', data: "1002.21"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 8, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '8', data: "204.854"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 9, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '9', data: "-7.8775"
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 10, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '1', field: '10', data: "1001.21"
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] Calling callback "LoadHouses"..
[05:50:04] [DEBUG] cache_get_data - connection: 1
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "33"
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "Home"
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "N/A"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "3"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 10, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '10', data: "2"
[05:50:04] [DEBUG] cache_get_row_int - row: 0, field_idx: 11, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '11', data: "1337"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 4, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "-1780.6"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 5, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "901.42"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 6, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "25.219"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 7, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "266.499"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 8, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "304.978"
[05:50:04] [DEBUG] cache_get_row_float - row: 0, field_idx: 9, connection: 1
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '9', data: "999.148"
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 3 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.66 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_get_row - row: 0, field_idx: 0, connection: 1, max_len: 50
[05:50:04] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "Cloudy"
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 1, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 1, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 1, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 1, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.171 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 2, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 2, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 2, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 2, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.75 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 3, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 3, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 3, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 3, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.35 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 4, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 4, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 4, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 4, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.32 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 5, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 5, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 5, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 5, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.47 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 6, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 6, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 6, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 6, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.210 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 7, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 7, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 7, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 7, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.24 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 8, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 8, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 8, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 8, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.39 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 0, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 9, field_idx: 2, connection: 1, max_len: 35
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row - row: 9, field_idx: 3, connection: 1, max_len: 4
[05:50:04] [WARNING] cache_get_row - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 1, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 10, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_int - row: 9, field_idx: 11, connection: 1
[05:50:04] [WARNING] cache_get_row_int - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 4, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 5, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 6, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 7, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 8, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] cache_get_row_float - row: 9, field_idx: 9, connection: 1
[05:50:04] [WARNING] cache_get_row_float - no active cache
[05:50:04] [DEBUG] mysql_format - connection: 1, len: 50, format: "SELECT Name FROM accounts WHERE ID = %d LIMIT 1"
[05:50:04] [DEBUG] mysql_query - connection: 1, query: "SELECT Name FROM accounts WHERE ID = 0 LIMIT 1", use_cache: true
[05:50:04] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:04] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.25 milliseconds
[05:50:04] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:04] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:04] [DEBUG] cache_get_row_count - connection: 1
[05:50:04] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:04] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:04] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:18] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:18] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name` = 'Cloudy' LIMIT 1", use_cache: true
[05:50:18] [DEBUG] CMySQLQuery::Execute - starting query execution
[05:50:18] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.414 milliseconds
[05:50:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[05:50:18] [DEBUG] cache_get_row_count - connection: 1
[05:50:18] [DEBUG] cache_get_row_count - connection: 1
[05:50:18] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1
[05:50:18] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "3"
[05:50:18] [DEBUG] cache_delete - cache_id: 1, connection: 1
[05:50:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:18] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
[05:50:18] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `bans` WHERE `BannedAccID` = '%d' LIMIT 1"
[05:50:18] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `bans` WHERE `BannedAccID` = '3' LIMIT 1", callback: "OnBanCheck", format: "i"
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnBanCheck] - starting query execution
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnBanCheck] - query was successfully executed within 0.96 milliseconds
[05:50:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUG] Calling callback "OnBanCheck"..
[05:50:18] [DEBUG] cache_get_data - connection: 1
[05:50:18] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:18] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `accounts` WHERE `Name` = 'Cloudy' ", callback: "OnAccountCheck", format: "i"
[05:50:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[05:50:18] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.380 milliseconds
[05:50:18] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:18] [DEBUG] Calling callback "OnAccountCheck"..
[05:50:18] [DEBUG] cache_get_data - connection: 1
[05:50:18] [DEBUG] cache_get_field_content - row: 0, field_name: "Password", connection: 1, max_len: 129
[05:50:18] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Password", data: "3F4811B9E6C37CE5900ADA5BC660C8632D13EA28A11DD0C54E3E0FD4C776F285AB1678C7FA708FF0078FB495BC05C09D654B063F07EB1859F3440E4B5F1B5449"
[05:50:18] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[05:50:18] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "3"
[05:50:18] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:19] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `accounts` WHERE `Name` = '%e' LIMIT 1"
[05:50:19] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name` = 'Cloudy' LIMIT 1", callback: "OnAccountLoad", format: "i"
[05:50:19] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - starting query execution
[05:50:19] [DEBUG] CMySQLQuery::Execute[OnAccountLoad] - query was successfully executed within 0.92 milliseconds
[05:50:19] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[05:50:19] [DEBUG] Calling callback "OnAccountLoad"..
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "ID", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "3"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "6"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "VIP", data: "6"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Money", data: "433554"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Score", data: "523"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Owner", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Owner", data: "1"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Wanted", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Wanted", data: "0"
[05:50:19] [DEBUG] cache_get_field_content_int - row: 0, field_name: "XP", connection: 1
[05:50:19] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "XP", data: "1759"
[05:50:19] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `accounts` SET `LoggedIn` = %d, `LastLogged` = %d WHERE `ID` = %d"
[05:50:19] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `LoggedIn` = 1, `LastLogged` = 14838 WHERE", callback: "(null)", format: "(null)"
[05:50:19] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[05:50:19] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[05:50:19] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 25.682 milliseconds
[05:50:19] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving