Thread: Removing NPCs
View Single Post
  #3  
Old 08-13-2015, 07:43 PM
AdrianD
Discordant
 
Join Date: Dec 2013
Posts: 297
Default

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.
Reply With Quote