For-rum 3server.cz
Halloween event (autocomplete fix) - Printable Version

+- For-rum 3server.cz (http://for-rum.3server.cz)
+-- Forum: TEAM ONLY (http://for-rum.3server.cz/forumdisplay.php?fid=4)
+--- Forum: SQL (http://for-rum.3server.cz/forumdisplay.php?fid=6)
+---- Forum: Solved (http://for-rum.3server.cz/forumdisplay.php?fid=10)
+---- Thread: Halloween event (autocomplete fix) (/showthread.php?tid=51)



Halloween event (autocomplete fix) - doktorblazen - 10-29-2018

Fire Trainning

Update quest_template set Method = 0, RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0 where Id=11361;
UPDATE quest_template SET Method = 0, RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0 WHERE Id=11449;
UPDATE quest_template SET Method = 0, RequiredNpcOrGo1 = 0, RequiredNpcOrGoCount1 = 0 WHERE Id=11450;

npc = 23973 quest giver
quest = 11361 , 11449, 11450


Stop the Fires!

npc = 23973 quest giver
quest = 11219, 11131

Update quest_template set Method = 0 where Id=11219;
Update quest_template set Method = 0 where Id=11131;

Let the Fires Come!

npc = 23973 quest giver
quest = 12139, 12135

Update quest_template set Method = 0 where Id=12139;
Update quest_template set Method = 0 where Id=12135;


Oprava Headless horseman Fly

UPDATE creature_template SET InhabitType = 5 WHERE entry=23682;


RE: Halloween event (autocomplete fix) - leo - 05-04-2019

opravené a nahodené