Fix for Stable Master [ALL VERSIONS]

[pedroevil51]

This query will fix all the master stables.
If i'm missing some please tell me.

UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 13616;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 13617;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 9896;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 22551;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 22577;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 23392;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 9567;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 27236;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 27429;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 28555;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 28683;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 31991;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 32105;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 37310;
UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `entry` = 37426;

Creditos to
[MENTION=12877]Vain[/MENTION] for the fix
And me for the query.

 

[Vain]

Actually there are 187 stable masters...

The Query that I would use is:

UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `subname` = 'Stable Master';

That would automatically include all the stable masters...

 

[eyerobot]

Thank you. I recommend Vains fix for this. We can find the few broken quest giver stable masters later on.

 

[pedroevil51]

Actually there are 187 stable masters...

The Query that I would use is:

UPDATE `creature_template` SET `npcflag` = 4194304 WHERE `subname` = 'Stable Master';

That would automatically include all the stable masters...

Nice, i used truice to search anyone who had stable masters on the subname but only showed those i did the query. anyway, thx for the better fix

 

[ExO]

Thanks. It's now executed