Quote:
Originally Posted by ChaosSlayerZ
Loading spawn groups failed.
|
Well, I don't have your source code, so I can't look at what that function does in the old version, but now it performs these two queries:
Code:
SELECT DISTINCT(spawngroupID), spawngroup.name, spawngroup.spawn_limit, spawngroup.dist, spawngroup.max_x, spawngroup.min_x, spawngroup.max_y, spawngroup.min_y, spawngroup.delay FROM spawn2,spawngroup WHERE spawn2.spawngroupID=spawngroup.ID AND spawn2.version=0 AND zone='crushbone'
SELECT DISTINCT spawnentry.spawngroupID, npcid, chance, npc_types.spawn_limit AS sl FROM spawnentry, spawn2, npc_types WHERE spawnentry.npcID=npc_types.id AND spawnentry.spawngroupID=spawn2.spawngroupID AND zone='crushbone'
Replace crushbone with whatever zone you like and make sure they both run in whatever SQL tool you use. You can search in your source code for the error message and see what the code does. It's probably close to the same I'd guess. The function I pulled those from is ZoneDatabase::LoadSpawnGroups in spawngroup.cpp.