[QUEST] Cleaning UNUSED

[cyrex]

If done this:

SELECT entry,title FROM quest_template WHERE title like '%[%' OR title like '%EPRECATE%' OR title like '%REUSE%' OR title like '%<NYI>%' OR title like '%<CHANGE TO GOSSIP>%' OR title like '%COPY' OR title like '%UNUSED%' OR title like '%<TXT>%' OR title like '%[PH]%';

You will find a little over 300 missions that are Deprecated, unused and other reasons to delete them. I am separating all queries so devs can have a look in an easy way. Tell me what you think of those missions found.

[cyrex]

This one will check if the quest is related to anything AND will also do the check above:

SELECT entry,title FROM quest_template WHERE entry NOT IN (select quest FROM gameobject_involvedrelation) AND entry NOT IN (select quest FROM creature_involvedrelation) AND entry NOT IN (select quest FROM gameobject_questrelation) AND entry NOT IN (select quest FROM creature_questrelation) AND entry NOT IN (select quest FROM game_event_creature_quest) AND entry NOT IN (select quest FROM game_event_gameobject_quest) AND (title like '%[%' OR title like '%EPRECATE%' OR title like '%REUSE%' OR title like '%<NYI>%' OR title like '%<CHANGE TO GOSSIP>%' OR title like '%COPY' OR title like '%UNUSED%' OR title like '%<TXT>%' OR title like '%[PH]%');

[zhanhang02]

Very useful, thanks.

[YuruY]

http://ytdb.ru/showthread.php?p=30143#post30143