Ray_Grand
Умник
В общем, такая проблема. Первый раз работаю с MySQL R6, с R8 проблем не было. Делал загрузку, вроде бы всё в порядке, с другими модами сравнивал всё нормально, однако не загружает.
server log:
PHP:
stock LoadFuel()
{
new time = GetTickCount();
mysql_query("SELECT * FROM `fuel`");
mysql_store_result();
if(mysql_num_rows() > 0)
{
for(new i = 1; i <= mysql_num_rows(); i++)
{
mysql_fetch_row(query1);
sscanf(query1, "p<|>ii", FuelInfo[i][fId], FuelInfo[i][fAmount]);
printf("Заправка: %d | Бензина: %d",FuelInfo[i][fId], FuelInfo[i][fAmount]);
TOTAL_FUEL++;
}
}
printf("%d за %i",TOTAL_FUEL, GetTickCount() - time);
mysql_free_result();
return 1;
}
[21:23:31]
[21:23:31] ---------------------------
[21:23:31] MySQL Debugging activated (07/28/14)
[21:23:31] ---------------------------
[21:23:31]
[21:23:31] >> mysql_set_charset( Connection handle: 1 )
[21:23:31] >> mysql_query( Connection handle: 1 )
[21:23:31] CMySQLHandler::Query(SET NAMES 'cp1251') - Successfully executed.
[21:23:31] >> mysql_query( Connection handle: 1 )
[21:23:31] CMySQLHandler::Query(SET CHARACTER SET 'cp1251') - Successfully executed.
[21:23:31] >> mysql_query( Connection handle: 1 )
[21:23:31] CMySQLHandler::Query(SELECT * FROM `fuel`) - Successfully executed.
[21:23:31] >> mysql_store_result( Connection handle: 1 )
[21:23:31] CMySQLHandler::StoreResult() - Result was stored.
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_fetch_row_format( Connection handle: 1 )
[21:23:31] CMySQLHandler::FetchRow() - Return: 1|55
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_fetch_row_format( Connection handle: 1 )
[21:23:31] CMySQLHandler::FetchRow() - Return: 2|200
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_free_result( Connection handle: 1 )
[21:23:31] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:23:31] ---------------------------
[21:23:31] MySQL Debugging activated (07/28/14)
[21:23:31] ---------------------------
[21:23:31]
[21:23:31] >> mysql_set_charset( Connection handle: 1 )
[21:23:31] >> mysql_query( Connection handle: 1 )
[21:23:31] CMySQLHandler::Query(SET NAMES 'cp1251') - Successfully executed.
[21:23:31] >> mysql_query( Connection handle: 1 )
[21:23:31] CMySQLHandler::Query(SET CHARACTER SET 'cp1251') - Successfully executed.
[21:23:31] >> mysql_query( Connection handle: 1 )
[21:23:31] CMySQLHandler::Query(SELECT * FROM `fuel`) - Successfully executed.
[21:23:31] >> mysql_store_result( Connection handle: 1 )
[21:23:31] CMySQLHandler::StoreResult() - Result was stored.
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_fetch_row_format( Connection handle: 1 )
[21:23:31] CMySQLHandler::FetchRow() - Return: 1|55
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_fetch_row_format( Connection handle: 1 )
[21:23:31] CMySQLHandler::FetchRow() - Return: 2|200
[21:23:31] >> mysql_num_rows( Connection handle: 1 )
[21:23:31] CMySQLHandler::NumRows() - Returned 2 row(s)
[21:23:31] >> mysql_free_result( Connection handle: 1 )
[21:23:31] CMySQLHandler::FreeResult() - Result was successfully free'd.
server log:
PHP:
Заправка: 0 | Бензина: 0
Заправка: 0 | Бензина: 0
