Thanks Shendare.
That will be useful to me for immediate resolution.
I build expansions from a main DB with a set of queries to isolate rows based on various criteria. In a few tables, I added a column to assist with isolation.
Here is a specific example for what I am doing with anything before Luclin; I don't update every time:
Code:
use main_db;
update npc_types set expansion = 3 where race = 130;
run all expansion_build queries
use live_db;
update spawnentry set chance = 0 select spawnentry.* from npc_types join spawnentry
where spawnentry.npcid = npc_types.id and npc_types.race = 130;
ALTER TABLE npc_types DROP column `expansion`;
This won't remove the npc_types entries for the zones where race = 130 but, it will disable the spawn from occuring. My concern/question was if there is a better or more efficient way.