Detaljan opis problema: Napokon sam napravio da mi se kuce ucitavaju iz MySQL baze, ali moram 3 puta utipkat komandu /loadhouses plus jednom sto se ucitaju u OnGameModeInIt. Prva tri puta mi MySQL vraca ovaj error CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
Dio skripte:
LoadHouses
stock LoadHouses()
{
new buffer;
new field;
new idx;
mysql_function_query(gConnectionHandle, "SELECT * FROM houses", false, "OnQueryFinish", "s", "SELECT * FROM houses");
mysql_store_result();
if(mysql_num_rows() > 0)
{
while(mysql_fetch_row_format(buffer, "|"))
{
split(buffer, field, '|');
idx = strval(field);
HouseInfo = floatstr(field);
HouseInfo = floatstr(field);
HouseInfo = floatstr(field);
HouseInfo = floatstr(field);
HouseInfo = floatstr(field);
HouseInfo = floatstr(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
strmid(HouseInfo, field, 0, strlen(field), 255);
strmid(HouseInfo, field, 0, strlen(field), 255);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
if(HouseInfo == 457)
{
HouseInfo = 411;
}
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
HouseInfo = strval(field);
if(HouseInfo == 0)
{
AddStaticPickup(1273, 1, HouseInfo, HouseInfo, HouseInfo);
pickups++;
}
if(HouseInfo == 1)
{
AddStaticPickup(1239, 1, HouseInfo, HouseInfo, HouseInfo);
pickups++;
}
AddStaticVehicleEx(HouseInfo, HouseCarSpawns, HouseCarSpawns, HouseCarSpawns, HouseCarSpawns, HouseInfo, HouseInfo, 60000);
gCarLock[idx+1] = 1;
}
}
printf("Houses Loaded");
mysql_free_result();
return 1;
}Komanda /loadhouses
if(strcmp(cmd, "/loadhouses", true) == 0)
{
LoadHouses();
SendClientMessage(playerid, COLOR_YELLOW, "Ucitao si kuce");
return 1;
}mysql_log nakon sto sam jednom zvao funkciju LoadHouses
[15:59:33] >> mysql_connect(localhost, root, sa-mp, ******) on port 3306
[15:59:33] CMySQLHandler::CMySQLHandler() - constructor called.
[15:59:33] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root"
[15:59:33] CMySQLHandler::Connect() - Connection was successful.
[15:59:33] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[15:59:33]
[15:59:33] ** MySQL Debugging enabled (09/23/12)
[15:59:33]
[15:59:33] >> mysql_query_callback( Connection handle: 1 )
[15:59:33] >> mysql_store_result( Connection handle: 1 )
[15:59:33] CMySQLHandler::StoreResult() - No data to store.
[15:59:33] >> mysql_num_rows( Connection handle: 1 )
[15:59:33] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[15:59:33] >> mysql_free_result( Connection handle: 1 )
[15:59:33] CMySQLHandler::FreeResult() - The result is already empty.
[15:59:33] Passing query SELECT * FROM houses | s
[15:59:33] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[15:59:33] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[15:59:33] OnQueryFinish(s) - Threaded function called.
MySQL log nakon sto sam 4 puta zvao funkciju LoadHouses
[16:03:02] >> mysql_connect(localhost, root, sa-mp, ******) on port 3306
[16:03:02] CMySQLHandler::CMySQLHandler() - constructor called.
[16:03:02] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sa-mp" | Username: "root"
[16:03:02] CMySQLHandler::Connect() - Connection was successful.
[16:03:02] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[16:03:02]
[16:03:02] ** MySQL Debugging enabled (09/23/12)
[16:03:02]
[16:03:02] >> mysql_query_callback( Connection handle: 1 )
[16:03:02] >> mysql_store_result( Connection handle: 1 )
[16:03:02] CMySQLHandler::StoreResult() - No data to store.
[16:03:02] >> mysql_num_rows( Connection handle: 1 )
[16:03:02] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[16:03:02] >> mysql_free_result( Connection handle: 1 )
[16:03:02] CMySQLHandler::FreeResult() - The result is already empty.
[16:03:02] Passing query SELECT * FROM houses | s
[16:03:02] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[16:03:02] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[16:03:02] OnQueryFinish(s) - Threaded function called.
[16:03:56] >> mysql_query_callback( Connection handle: 1 )
[16:03:56] >> mysql_store_result( Connection handle: 1 )
[16:03:56] CMySQLHandler::StoreResult() - No data to store.
[16:03:56] >> mysql_num_rows( Connection handle: 1 )
[16:03:56] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[16:03:56] >> mysql_free_result( Connection handle: 1 )
[16:03:56] CMySQLHandler::FreeResult() - The result is already empty.
[16:03:56] Passing query SELECT * FROM houses | s
[16:03:56] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[16:03:56] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[16:03:56] OnQueryFinish(s) - Threaded function called.
[16:04:30] >> mysql_query_callback( Connection handle: 1 )
[16:04:30] >> mysql_store_result( Connection handle: 1 )
[16:04:30] CMySQLHandler::StoreResult() - Result was stored.
[16:04:30] Passing query SELECT * FROM houses | s
[16:04:30] >> mysql_num_rows( Connection handle: 1 )
[16:04:30] CMySQLHandler::NumRows() - Returned 16 row(s)
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT * FROM houses)
[16:04:30] CMySQLHandler::FetchRow() - Return: 1|2495.47754|-1690.99097|14.76560|2496.64990|-1696.55005|1014.73999|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Srednja Kuca|25000|0|0|3|1|0|0|10|0|844|418|-1|-1|260|3
[16:04:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 3|2256.97583|-1644.55859|15.51976|346.87003|309.25903|999.15570|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|6|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 2|2244.44385|-1638.32654|15.90741|328.10660|1478.01062|1084.43750|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|15|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 4|2282.12915|-1642.15674|15.62792|225.75699|1240.00000|1082.14990|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|2|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 5|2362.70020|-1643.99109|13.53179|328.10660|1478.01062|1084.43750|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|15|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 6|2393.31885|-1646.20093|13.90510|244.41199|305.03299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 7|2413.85889|-1647.03125|14.01192|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 8|2451.93555|-1641.82703|13.73574|260.98398|1286.54993|1080.29993|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|4|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 9|2469.66235|-1647.00232|13.51823|244.41199|305.03299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 10|2469.66235|-1647.00232|13.51823|244.41199|305.03299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzavno|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|418|-1|-1|267|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 11|2384.68457|-1675.17322|14.91522|302.18100|300.72299|999.23199|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|4|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 12|2368.25269|-1675.30371|14.16817|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|260|3
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 13|2327.33350|-1681.67078|14.92969|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|0|-1|-1|203|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 14|2327.33350|-1681.67078|14.92969|223.19290|1287.07800|1082.14062|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzavno|Mala Kuca|25000|0|0|1|1|0|0|0|0|0|418|-1|-1|267|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 15|2385.89233|-1712.09888|14.24219|446.50140|507.02951|1001.41949|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzava|Mala Kuca|25000|0|0|12|1|0|0|0|0|0|0|-1|-1|203|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] CMySQLHandler::FetchRow() - Return: 16|2385.89233|-1712.09888|14.24219|446.50140|507.02951|1001.41949|0.00000|0.00000|0.00000|0.00000|0.00000|0.00000|Drzavno|Mala Kuca|25000|0|0|12|1|0|0|0|0|0|418|-1|-1|267|0
[16:04:30] >> mysql_fetch_row_format( Connection handle: 1 )
[16:04:30] >> mysql_free_result( Connection handle: 1 )
[16:04:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:04:30] OnQueryFinish(s) - Threaded function called.Neke slike/video za lakse dobivanje pomoci(neobavezno):