iDiego
29.10.2014, 13:24
Ребят, в общем. Сделал таблицу под мускул, аккаунты сохраняются, все нормально, но.
Если в строке pAdmin, в БД поставить значение админки на 6, то админка будет всегда. А если выдать админку через /makeadmin, то админка не сохраняется. В команде все нормально (DeimoS'y скидывал)
Вот мускул лог:
[12:14:40] ---------------------------
[12:14:40] MySQL Debugging activated (10/29/14)
[12:14:40] ---------------------------
[12:14:40]
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Jacob_Tenpeny') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '94.137.46.140') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - The result is already empty.
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Jacob_Tenpeny' LIMIT 1) - Successfully executed.
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - Result was stored.
[12:14:40] >> mysql_num_rows( Connection handle: 1 )
[12:14:40] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Dimko_Tenpeny') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '92.243.182.216') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - The result is already empty.
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - Result was stored.
[12:14:40] >> mysql_num_rows( Connection handle: 1 )
[12:14:40] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:14:44] >> mysql_query( Connection handle: 1 )
[12:14:44] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name`='Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:14:44] >> mysql_store_result( Connection handle: 1 )
[12:14:44] CMySQLHandler::StoreResult() - Result was stored.
[12:14:44] >> mysql_num_rows( Connection handle: 1 )
[12:14:44] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:14:44] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:44] CMySQLHandler::FetchRow() - Return: 15|Dimko_Tenpeny|23|1|0
[12:14:44] >> mysql_query( Connection handle: 1 )
[12:14:44] CMySQLHandler::Query(UPDATE `accounts` SET `lastip`='92.243.182.216', `online`='1' WHERE `name`='Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'lastip' in 'field list')
[12:14:44] >> mysql_free_result( Connection handle: 1 )
[12:14:44] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:15:02] >> mysql_query( Connection handle: 1 )
[12:15:02] CMySQLHandler::Query(UPDATE accounts SET `level`=1,`admin`=6,`vip`=0,`hours`=0,`registered`=0,`money`=2500,`kills`=0,`deaths`=0,`warns`=0,`lastip`='255.255.255.255',`online`=0 WHERE name = 'Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'level' in 'field list')
[12:15:02] >> mysql_query( Connection handle: 1 )
[12:15:02] CMySQLHandler::Query(UPDATE `accounts` SET `online`='0' WHERE `name`='Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'online' in 'field list')
[12:15:36] >> mysql_query( Connection handle: 1 )
[12:15:36] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Dimko_Tenpeny') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:15:36] >> mysql_store_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::StoreResult() - No data to store.
[12:15:36] >> mysql_fetch_row_format( Connection handle: 1 )
[12:15:36] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:15:36] >> mysql_query( Connection handle: 1 )
[12:15:36] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '92.243.182.216') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:15:36] >> mysql_store_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::StoreResult() - No data to store.
[12:15:36] >> mysql_fetch_row_format( Connection handle: 1 )
[12:15:36] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:15:36] >> mysql_free_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::FreeResult() - The result is already empty.
[12:15:36] >> mysql_query( Connection handle: 1 )
[12:15:36] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:15:36] >> mysql_store_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::StoreResult() - Result was stored.
[12:15:36] >> mysql_num_rows( Connection handle: 1 )
[12:15:36] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:15:36] >> mysql_free_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:15:38] >> mysql_query( Connection handle: 1 )
[12:15:38] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name`='Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:15:38] >> mysql_store_result( Connection handle: 1 )
[12:15:38] CMySQLHandler::StoreResult() - Result was stored.
[12:15:38] >> mysql_num_rows( Connection handle: 1 )
[12:15:38] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:15:38] >> mysql_fetch_row_format( Connection handle: 1 )
[12:15:38] CMySQLHandler::FetchRow() - Return: 15|Dimko_Tenpeny|23|1|0
[12:15:38] >> mysql_query( Connection handle: 1 )
[12:15:38] CMySQLHandler::Query(UPDATE `accounts` SET `lastip`='92.243.182.216', `online`='1' WHERE `name`='Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'lastip' in 'field list')
[12:15:38] >> mysql_free_result( Connection handle: 1 )
[12:15:38] CMySQLHandler::FreeResult() - Result was successfully free'd.
Если в строке pAdmin, в БД поставить значение админки на 6, то админка будет всегда. А если выдать админку через /makeadmin, то админка не сохраняется. В команде все нормально (DeimoS'y скидывал)
Вот мускул лог:
[12:14:40] ---------------------------
[12:14:40] MySQL Debugging activated (10/29/14)
[12:14:40] ---------------------------
[12:14:40]
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Jacob_Tenpeny') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '94.137.46.140') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - The result is already empty.
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Jacob_Tenpeny' LIMIT 1) - Successfully executed.
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - Result was stored.
[12:14:40] >> mysql_num_rows( Connection handle: 1 )
[12:14:40] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Dimko_Tenpeny') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '92.243.182.216') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - No data to store.
[12:14:40] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:40] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - The result is already empty.
[12:14:40] >> mysql_query( Connection handle: 1 )
[12:14:40] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:14:40] >> mysql_store_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::StoreResult() - Result was stored.
[12:14:40] >> mysql_num_rows( Connection handle: 1 )
[12:14:40] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:14:40] >> mysql_free_result( Connection handle: 1 )
[12:14:40] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:14:44] >> mysql_query( Connection handle: 1 )
[12:14:44] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name`='Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:14:44] >> mysql_store_result( Connection handle: 1 )
[12:14:44] CMySQLHandler::StoreResult() - Result was stored.
[12:14:44] >> mysql_num_rows( Connection handle: 1 )
[12:14:44] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:14:44] >> mysql_fetch_row_format( Connection handle: 1 )
[12:14:44] CMySQLHandler::FetchRow() - Return: 15|Dimko_Tenpeny|23|1|0
[12:14:44] >> mysql_query( Connection handle: 1 )
[12:14:44] CMySQLHandler::Query(UPDATE `accounts` SET `lastip`='92.243.182.216', `online`='1' WHERE `name`='Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'lastip' in 'field list')
[12:14:44] >> mysql_free_result( Connection handle: 1 )
[12:14:44] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:15:02] >> mysql_query( Connection handle: 1 )
[12:15:02] CMySQLHandler::Query(UPDATE accounts SET `level`=1,`admin`=6,`vip`=0,`hours`=0,`registered`=0,`money`=2500,`kills`=0,`deaths`=0,`warns`=0,`lastip`='255.255.255.255',`online`=0 WHERE name = 'Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'level' in 'field list')
[12:15:02] >> mysql_query( Connection handle: 1 )
[12:15:02] CMySQLHandler::Query(UPDATE `accounts` SET `online`='0' WHERE `name`='Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'online' in 'field list')
[12:15:36] >> mysql_query( Connection handle: 1 )
[12:15:36] CMySQLHandler::Query(SELECT * FROM bans WHERE name = 'Dimko_Tenpeny') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:15:36] >> mysql_store_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::StoreResult() - No data to store.
[12:15:36] >> mysql_fetch_row_format( Connection handle: 1 )
[12:15:36] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:15:36] >> mysql_query( Connection handle: 1 )
[12:15:36] CMySQLHandler::Query(SELECT * FROM bans WHERE ip = '92.243.182.216') - An error has occured. (Error ID: 1146, Table 'bbuf9TG.bans' doesn't exist)
[12:15:36] >> mysql_store_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::StoreResult() - No data to store.
[12:15:36] >> mysql_fetch_row_format( Connection handle: 1 )
[12:15:36] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[12:15:36] >> mysql_free_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::FreeResult() - The result is already empty.
[12:15:36] >> mysql_query( Connection handle: 1 )
[12:15:36] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name` = 'Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:15:36] >> mysql_store_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::StoreResult() - Result was stored.
[12:15:36] >> mysql_num_rows( Connection handle: 1 )
[12:15:36] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:15:36] >> mysql_free_result( Connection handle: 1 )
[12:15:36] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:15:38] >> mysql_query( Connection handle: 1 )
[12:15:38] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `name`='Dimko_Tenpeny' LIMIT 1) - Successfully executed.
[12:15:38] >> mysql_store_result( Connection handle: 1 )
[12:15:38] CMySQLHandler::StoreResult() - Result was stored.
[12:15:38] >> mysql_num_rows( Connection handle: 1 )
[12:15:38] CMySQLHandler::NumRows() - Returned 1 row(s)
[12:15:38] >> mysql_fetch_row_format( Connection handle: 1 )
[12:15:38] CMySQLHandler::FetchRow() - Return: 15|Dimko_Tenpeny|23|1|0
[12:15:38] >> mysql_query( Connection handle: 1 )
[12:15:38] CMySQLHandler::Query(UPDATE `accounts` SET `lastip`='92.243.182.216', `online`='1' WHERE `name`='Dimko_Tenpeny') - An error has occured. (Error ID: 1054, Unknown column 'lastip' in 'field list')
[12:15:38] >> mysql_free_result( Connection handle: 1 )
[12:15:38] CMySQLHandler::FreeResult() - Result was successfully free'd.