1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Doors loading problem
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#1

15.11.2013, 10:32
Hello, I've got a gamemode, based on MYSQL + SSCANF, ZCMD, and some more things.
Well the problem is, the gamemode is dynamic. No faction doors, HQ's nothing.
I created faction door and I've set a teleporting to HQ, it's dynamic.
Door was created and everything worked great.
But when I crash the server and start it, the doors don't appear ingame.
But they appear on MYSQL database.
What's the problem here? loading? how to fix it please.
Thanks for your help.
Find
Reply
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#2

16.11.2013, 16:39
Help me please.
Find
Reply
BizzyD
Gangsta
*****
Posts: 879
Threads: 90
Joined: Jan 2011
Reputation: 0
#3

16.11.2013, 16:51
Give us some codes to work with.
Find
Reply
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#4

16.11.2013, 17:01
Tell me what to copy for you please.
Find
Reply
BizzyD
Gangsta
*****
Posts: 879
Threads: 90
Joined: Jan 2011
Reputation: 0
#5

16.11.2013, 17:06
Anything that has to do with the loading.
Also, check if you have any errors in the mysql log.
Can usally be found in the main directory or in scriptfiles.
Find
Reply
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#6

16.11.2013, 17:33
Код:
public LoadDynamicFactionDoors()
{
    new rows, fields;
	new total = 0;
    cache_get_data(rows, fields);
    if(rows)
    {
		while(total < rows)
		{
			FactionDoors[total][dID] = cache_get_row_int(total, 0);
			FactionDoors[total][dFaction] = cache_get_row_int(total, 1);
			cache_get_row(total, 2, FactionDoors[total][dInfo], dbHandle, 128);
			FactionDoors[total][dEnterX] = cache_get_row_float(total, 3);
			FactionDoors[total][dEnterY] = cache_get_row_float(total, 4);
			FactionDoors[total][dEnterZ] = cache_get_row_float(total, 5);
			FactionDoors[total][dExitX] = cache_get_row_float(total, 6);
			FactionDoors[total][dExitY] = cache_get_row_float(total, 7);
			FactionDoors[total][dExitZ] = cache_get_row_float(total, 8);
			FactionDoors[total][dEnterInterior] = cache_get_row_int(total, 9);
			FactionDoors[total][dExitInterior] = cache_get_row_int(total, 10);
			FactionDoors[total][dVirtualWorld] = cache_get_row_int(total, 11);
			FactionDoors[total][dWithVehicle] = cache_get_row_int(total, 12);
			FactionDoors[total][dEnterAngle] = cache_get_row_float(total, 13);
			FactionDoors[total][dExitAngle] = cache_get_row_float(total, 14);
			FactionDoors[total][dDoorOn] = 1;
			FactionDoors[total][dLocked] = 1;
			FactionDoors[total][dPickUp] = CreateDynamicPickup(1239, 2, FactionDoors[total][dEnterX], FactionDoors[total][dEnterY], FactionDoors[total][dEnterZ], -1, -1, -1, 100.0);
			total++;
		}
    }
	format(msg,sizeof(msg), "Loaded %d faction doors from MySQL.", total);
	printf(msg);
    return 1;
}
Find
Reply
BizzyD
Gangsta
*****
Posts: 879
Threads: 90
Joined: Jan 2011
Reputation: 0
#7

16.11.2013, 17:37
Do you get the message in your server logs?
And was there any errors in mysql.log?
Find
Reply
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#8

16.11.2013, 17:42
I don't think so let me start the server and clear mysql.log I'll create the doors again and check.
Find
Reply
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#9

16.11.2013, 18:06
mysql.log

Код:
[21:05:51] >> mysql_query_callback(Connection handle: 1)
[21:05:51] ProcessQueryThread(OnFactionDoorInsert) - Executing query INSERT INTO `factiondoors` (info, withvehicle, enterinterior, faction, enterx, entery, enterz) VALUES('LSPD', 0, 0, 0, 1554.523559, -1675.353637, 16.195312)...
[21:05:51] ProcessQueryThread(OnFactionDoorInsert) - Query was successful.
[21:05:51] ProcessQueryThread(OnFactionDoorInsert) - Data caching enabled.
[21:05:51] CMySQLHandler::StoreResult() - No data to store.
[21:05:51] ProcessQueryThread(OnFactionDoorInsert) - Data being passed to ProcessTick().
[21:05:51] OnFactionDoorInsert(d) - Callback is being called...
[21:05:51] >> mysql_insert_id(Connection handle: 1)
[21:05:51] ProcessTick() - The cache has been cleared.
[21:06:09] Plugin succesfully loaded!
[21:06:09] >> mysql_connect(localhost, root, lsrp, ***) on port 3306
[21:06:09] CMySQLHandler::CMySQLHandler() - constructor called.
[21:06:09] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "lsrp" | Username: "root"...
[21:06:09] CMySQLHandler::Connect() - Connection was successful.
[21:06:09] CMySQLHandler::Connect() - Auto-reconnect has been enabled.
[21:06:09]  
[21:06:09]  ** MySQL Debugging enabled.
[21:06:09]  
[21:06:09] >> mysql_ping(Connection handle: 1)
[21:06:09] CMySQLHandler::Ping() - Connection is still alive.
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] >> mysql_query_callback(Connection handle: 1)
[21:06:09] ProcessQueryThread(LoadDynamicLabels) - Executing query SELECT * FROM `labels`...
[21:06:09] ProcessQueryThread(LoadDynamicLabels) - Query was successful.
[21:06:09] ProcessQueryThread(LoadDynamicLabels) - Data caching enabled.
[21:06:09] CMySQLHandler::StoreResult() - Result was stored.
[21:06:09] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:09] ProcessQueryThread(LoadDynamicLabels) - Data being passed to ProcessTick().
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] LoadDynamicLabels() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicGates) - Executing query SELECT * FROM `gates`...
[21:06:10] ProcessQueryThread(LoadDynamicGates) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicGates) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicGates) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicGates() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicATMS) - Executing query SELECT * FROM `atms`...
[21:06:10] ProcessQueryThread(LoadDynamicATMS) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicATMS) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicATMS) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicATMS() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicTeles) - Executing query SELECT * FROM `ateles`...
[21:06:10] ProcessQueryThread(LoadDynamicTeles) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicTeles) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicTeles) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicTeles() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicObjects) - Executing query SELECT * FROM `objects`...
[21:06:10] ProcessQueryThread(LoadDynamicObjects) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicObjects) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicObjects) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicObjects() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicCPT) - Executing query SELECT * FROM `infos`...
[21:06:10] ProcessQueryThread(LoadDynamicCPT) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicCPT) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicCPT) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicCPT() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicGasStations) - Executing query SELECT * FROM `gstations`...
[21:06:10] ProcessQueryThread(LoadDynamicGasStations) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicGasStations) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicGasStations) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicGasStations() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicBanks) - Executing query SELECT * FROM `banks`...
[21:06:10] ProcessQueryThread(LoadDynamicBanks) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicBanks) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicBanks) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicBanks() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicVehicles) - Executing query SELECT * FROM `vehicles`...
[21:06:10] ProcessQueryThread(LoadDynamicVehicles) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicVehicles) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicVehicles) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicVehicles() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicHouses) - Executing query SELECT * FROM `houses`...
[21:06:10] ProcessQueryThread(LoadDynamicHouses) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicHouses) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicHouses) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicHouses() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] >> mysql_query_callback(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicBiz) - Executing query SELECT * FROM `business`...
[21:06:10] ProcessQueryThread(LoadDynamicBiz) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicBiz) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicBiz) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicBiz() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicStands) - Executing query SELECT * FROM `foodstands`...
[21:06:10] ProcessQueryThread(LoadDynamicStands) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicStands) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicStands) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicStands() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicMeters) - Executing query SELECT * FROM `parkmeters`...
[21:06:10] ProcessQueryThread(LoadDynamicMeters) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicMeters) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicMeters) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicMeters() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(OnLoadApbs) - Executing query SELECT * FROM `apbs`...
[21:06:10] ProcessQueryThread(OnLoadApbs) - Query was successful.
[21:06:10] ProcessQueryThread(OnLoadApbs) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(OnLoadApbs) - Data being passed to ProcessTick().
[21:06:10] OnLoadApbs() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicFactions) - Executing query SELECT * FROM `factions` ORDER BY `factionid`...
[21:06:10] ProcessQueryThread(LoadDynamicFactions) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicFactions) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicFactions) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicFactions() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadDynamicJobs) - Executing query SELECT * FROM `jobs` ORDER BY `jobid`...
[21:06:10] ProcessQueryThread(LoadDynamicJobs) - Query was successful.
[21:06:10] ProcessQueryThread(LoadDynamicJobs) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadDynamicJobs) - Data being passed to ProcessTick().
[21:06:10] LoadDynamicJobs() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadRadios) - Executing query SELECT * FROM `radios`...
[21:06:10] ProcessQueryThread(LoadRadios) - Query was successful.
[21:06:10] ProcessQueryThread(LoadRadios) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadRadios) - Data being passed to ProcessTick().
[21:06:10] LoadRadios() - Callback is being called...
[21:06:10] >> cache_get_data(Connection handle: 1)
[21:06:10] ProcessTick() - The cache has been cleared.
[21:06:10] ProcessQueryThread(LoadMoveDoors) - Executing query SELECT * FROM `movedoors`...
[21:06:10] ProcessQueryThread(LoadMoveDoors) - Query was successful.
[21:06:10] ProcessQueryThread(LoadMoveDoors) - Data caching enabled.
[21:06:10] CMySQLHandler::StoreResult() - Result was stored.
[21:06:10] CMySQLHandler::FreeResult() - Result was successfully freed.
[21:06:10] ProcessQueryThread(LoadMoveDoors) - Data being passed to ProcessTick().
[21:06:10] LoadMoveDoors() - Callback is being called...
It shows the door on MYSQL database, but again, not ingame.

8 0 LSPD 1554.52 -1675.35 16.1953 NULL NULL NULL 0 NULL NULL 0 NULL NULL
Find
Reply
nati5860
Little Clucker
**
Posts: 26
Threads: 3
Joined: Nov 2012
Reputation: 0
#10

16.11.2013, 21:43
Any help please? I got the old version of that gamemode, and there it works good, but I don't want to use the older version, I want to use the newer one.
Please tell me how to fix it like the older one.
Thanks and much appreciated guys.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help