[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