10.05.2013, 09:08
Hey,
I wanted to test my script and when I join it takes really long so I thought there must be something wrong.
Then after a few minutes it sais Server Lost Connection and then I noticed that my console closed...
The LOG doesn't show anything.
I started ******ing and I saw a topic that it could be the mysql data so I checked my log and it turns out that it has something to do with this.
I think it is that because when I check MYSQL log it is FULL of Spam of these things.
Look at this:
up to the 2000...
and
up to the 1000...
and maybe like a thousand times
at the beginning
I wanted to test my script and when I join it takes really long so I thought there must be something wrong.
Then after a few minutes it sais Server Lost Connection and then I noticed that my console closed...
The LOG doesn't show anything.
Код:
SA-MP Dedicated Server ---------------------- v0.3x, ©2005-2013 SA-MP Team [10:45:33] filterscripts = "" (string) [10:45:33] [10:45:33] Server Plugins [10:45:33] -------------- [10:45:33] Loading plugin: mysql [10:45:33] > MySQL plugin R7 successfully loaded. [10:45:33] Loaded. [10:45:33] Loading plugin: Whirlpool [10:45:33] [10:45:33] ================== [10:45:33] [10:45:33] Whirlpool loaded [10:45:33] [10:45:33] ================== [10:45:33] [10:45:33] Loaded. [10:45:33] Loading plugin: streamer [10:45:33] *** Streamer Plugin v2.6.1 by Incognito loaded *** [10:45:33] Loaded. [10:45:33] Loaded 3 plugins. [10:45:34] [10:45:34] Filterscripts [10:45:34] --------------- [10:45:34] Loaded 0 filterscripts. [10:45:34] [10:45:34] [10:45:34] [10:45:34] ======================================= [10:45:34] | | [10:45:34] | YSI version 1.06.0002 | [10:45:34] | By Alex "******" Cole | [10:45:34] | | [10:45:34] ======================================= [10:45:34] [10:45:34] [10:45:34] [10:45:34] * Connecting to MySQL: Success [10:45:35] [10:45:35] [10:45:35] -----------------------GAMEMODE LOADING----------------------- [10:45:35] ------------- Gamemode created by: Stefantjuh97 -------------- [10:45:35] --------------- Email: Stefantjuh97@gmail.com ---------------- [10:45:35] -----------------------GAMEMODE LOADED----------------------- [10:45:35] [10:45:35] [10:45:35] Number of vehicle models: 0 [10:45:35] [System] Faction 1 with faction name: Los Santos Police Department spawned. [10:45:35] [System] Faction 2 with faction name: Los Santos Emergency Services spawned. [10:45:35] [System] Faction 3 with faction name: Federal Bureau of Investigations spawned. [10:45:35] [System] Faction 4 with faction name: Cable News Network spawned. [10:45:35] [System] Faction 5 with faction name: Taxi Company spawned. [10:45:37] Incoming connection: 25.137.80.58:53059 [10:45:37] [join] Danny_Williams has joined the server (0:25.137.80.58)
pawn Код:
stock InitFactions()
{
new query[400];
for(new id; id < MAX_FACTIONS; id++) // Goes through all the slots, looking for the data
{
format(query, sizeof(query), "SELECT * FROM `Factions` WHERE `FactionID` = %d", id); // Selects all the information from the table
mysql_function_query(connectionHandle, query, true, "LoadFactionsCallback", "d", id);
}
return 1;
}
stock InitVehicles()
{
new query[400];
for(new id; id < MAX_VEHICLES; id++) // Goes through all the slots, looking for the data
{
format(query, sizeof(query), "SELECT * FROM `Vehicles` WHERE `CarFileID` = %d", id); // Selects all the information from the table
mysql_function_query(connectionHandle, query, true, "LoadVehiclesCallback", "d", id);
}
return 1;
}
stock InitHouses()
{
new query[400];
for(new id; id < MAX_HOUSES; id++) // Goes through all the slots, looking for the data
{
format(query, sizeof(query), "SELECT * FROM `Houses` WHERE `HouseID` = %d", id); // Selects all the information from the table
mysql_function_query(connectionHandle, query, true, "LoadHousesCallback", "d", id);
}
return 1;
}
Look at this:
Код:
[10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 0 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 0) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 1 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 1) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 2 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 2) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 3 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 3) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 4 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 4) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 5 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 5) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 6 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 6) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared. [10:51:42] Passing query SELECT * FROM `Vehicles` WHERE `CarFileID` = 7 | d [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Query was successful. (SELECT * FROM `Vehicles` WHERE `CarFileID` = 7) [10:51:42] ProcessQueryThread(LoadVehiclesCallback) - Data caching enabled. [10:51:42] CMySQLHandler::StoreResult() - Result was stored. [10:51:42] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:51:42] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:51:42] LoadVehiclesCallback(d) - Threaded function called. [10:51:42] >> cache_get_data( Connection handle: 1 ) [10:51:42] ProcessTick() - The cache has been cleared.
and
Код:
[10:52:04] ProcessTick() - The cache has been cleared. [10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 1 | d [10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 1) [10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled. [10:52:04] CMySQLHandler::StoreResult() - Result was stored. [10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:52:04] LoadHousesCallback(d) - Threaded function called. [10:52:04] >> cache_get_data( Connection handle: 1 ) [10:52:04] ProcessTick() - The cache has been cleared. [10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 2 | d [10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 2) [10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled. [10:52:04] CMySQLHandler::StoreResult() - Result was stored. [10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:52:04] LoadHousesCallback(d) - Threaded function called. [10:52:04] >> cache_get_data( Connection handle: 1 ) [10:52:04] ProcessTick() - The cache has been cleared. [10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 3 | d [10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 3) [10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled. [10:52:04] CMySQLHandler::StoreResult() - Result was stored. [10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:52:04] LoadHousesCallback(d) - Threaded function called. [10:52:04] >> cache_get_data( Connection handle: 1 ) [10:52:04] ProcessTick() - The cache has been cleared. [10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 4 | d [10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 4) [10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled. [10:52:04] CMySQLHandler::StoreResult() - Result was stored. [10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:52:04] LoadHousesCallback(d) - Threaded function called. [10:52:04] >> cache_get_data( Connection handle: 1 ) [10:52:04] ProcessTick() - The cache has been cleared. [10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 5 | d [10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 5) [10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled. [10:52:04] CMySQLHandler::StoreResult() - Result was stored. [10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:52:04] LoadHousesCallback(d) - Threaded function called. [10:52:04] >> cache_get_data( Connection handle: 1 ) [10:52:04] ProcessTick() - The cache has been cleared. [10:52:04] Passing query SELECT * FROM `Houses` WHERE `HouseID` = 6 | d [10:52:04] ProcessQueryThread(LoadHousesCallback) - Query was successful. (SELECT * FROM `Houses` WHERE `HouseID` = 6) [10:52:04] ProcessQueryThread(LoadHousesCallback) - Data caching enabled. [10:52:04] CMySQLHandler::StoreResult() - Result was stored. [10:52:04] CMySQLHandler::FreeResult() - Result was successfully free'd. [10:52:04] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() [10:52:04] LoadHousesCallback(d) - Threaded function called. [10:52:04] >> cache_get_data( Conne
and maybe like a thousand times
Код:
[10:51:41] >> mysql_query_callback( Connection handle: 1 )