Search results

-- 27416 The Brood of Onyxia 27424 27414 Required UPDATE `quest_template` SET `PrevQuestId` = -27414 WHERE `Id` = 27416; UPDATE `quest_template` SET `NextQuestId` = 27416, `ExclusiveGroup` = -27414, `NextQuestIdChain` = 27416 WHERE `Id` = 27414; UPDATE `quest_template` SET `NextQuestId` = 27416...

-- 27295 Seek Out Tabetha UPDATE `quest_template` SET `PrevQuestId` = 27293 WHERE `Id` = 27295;

This is rewritten in SAI because the C++ script doesn't work. I wasn't able find a reference for the visual spell that is cast just before Zelfrax is summoned. But the rest works. -- 27190 Cleansing Witch Hill -- 33113 Witchbane Torch -- 42521 Light Witchbane Torch -- 23864 Zelfrax -- 23868...

-- 23585 Witch Light Has equipment DELETE FROM `creature_equip_template` WHERE `entry`=23585 AND `id`=2;

-- 27191 Hungry as an Ogre! UPDATE `quest_template` SET `PrevQuestId` = 27184 WHERE `Id` = 27191;

-- 27306 Talk to Ogron UPDATE `quest_template` SET `PrevQuestId` = 27260 WHERE `Id` = 27306;

-- 27293 The Grimtotem Plot UPDATE `quest_template` SET `PrevQuestId` = 27292 WHERE `Id` = 27293; DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=27309; INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES (1, 27309, 0, '', '', 'Deprecated...

-- 27257 The Black Shield Horde UPDATE `quest_template` SET `NextQuestId` = 27258, `NextQuestIdChain` = 27258 WHERE `Id` = 27257; UPDATE `quest_template` SET `PrevQuestId` = 27257 WHERE `Id` = 27258; UPDATE `quest_template` SET `PrevQuestId` = 27258 WHERE `Id` = 27292;

-- Dustwallow Marsh -- Inspecting The Ruins 27253 Horde 27249 Alliance -- Suspicious Hoofprints 27259 Horde 27262 Alliance -- lieutenant paval reeth 27260 Horde 27263 Alliance -- the black shield 27254 Horde 27252 Alliance -- Horde UPDATE `quest_template` SET `PrevQuestId` = 27253 WHERE...

Have you ever thought to yourself. I wish I knew how to fix Creatures, Objects, And Quests? During an average day of playing, You probably encounter hundreds of bugs that could be fixed in seconds, If you only knew how. But you never went to tech school, And most likely don't want to ask...

Adds quest objectives, Gives aura bunny script. High preistess Slithera should be putting the giant into a trance, But I have no idea what spell to use for that. -- 24452 Profitability Scouting -- 37143 Heart of Arkkoroc Aura Bunny -- 36873 High Priestess Silthera -- 36854 Heart of Arkkoroc...

This sets the phase to 2, Adds missing spawns, Corrects phasemasks. Fixes portals gossip and smart scripts, And phasing. -- 27513 Transdimensional Warfare: Chapter II DELETE FROM `spell_area` WHERE `spell`=59073 AND `area`=233 AND `quest_start`=27513 AND `quest_start_active`=0 AND...

[CODE-- 45610 Daschla DELETE FROM `creature` WHERE `id`=45610; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`...

This is a temp fix for this quest. It leaves out the entire scenario, but gives quest credit. The Involved spells do not work yet, So I did this instead. -- 27472 Rise, Godfrey -- The great escape should not change phase until rise godfrey is finished -- 45525 Sylvanas 300018 Quest Giver...

There were six ores, Which is wrong, And they were a hundred feet high in the air. This places them on the ground, and adds them in all listed areas. -- 202740 Rich Pyrite Deposit DELETE FROM `gameobject` WHERE `id`=202740; INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`...

-- 45405 Master Sergeant Pietro Zaren DELETE FROM `creature` WHERE `id`=45405; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`...

This is a workaround for non functioning area trigger. But it's better than autocomplete. Also the village was supposed to be dead and burning, this fixes that. -- 27349 Break in Communications: Dreadwatch Outpost -- 45345 Abomination -- 182090 Vector Coil Fire -- 6246 Areatrigger UPDATE...

It seems that some of the data in creature template bugged out when it was copied into the creature table. Deleting and reinserting these creatures makes them visible again. -- 4614 Martha Alliestar Invis Fix -- 4615 Katrina Alliestar Invis Fix DELETE FROM `creature` WHERE `id`=4614; INSERT...

-- 5662 Sergeant Houser missing text DELETE FROM `creature_text` WHERE `entry`=5662 AND `groupid`=0 AND `ID`=0; INSERT INTO `creature_text` (`entry`, `groupid`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES (5662, 0, 0, 'You...