Search results

The horn was made a 100% drop rate back in lich king. -- 9530 Horn of Hatetalon DELETE FROM `creature_loot_template` WHERE `entry`=5362 AND `item`=9530; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES...

The scripts for this quest had nothing to do with the quest. So I wrote new scripts. -- 27347 Corrosion Prevention -- 33108 Ooze Buster -- 42486 Ooze channel credit -- 42489 Cast Ooze Zap When Energized -- 42485 End Of Ooze Channel -- 4393 Bubbling Swamp ooze -- 4394 Acidic Swamp Ooze...

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

Creatures instant despawn when spell is applied, So no repeats on the same corpse. -- 27409 The Essence of Enmity -- 33088 Brogg's Totem -- 42411 Spell -- 4331 Firemane Ash Tail UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 4331; DELETE FROM `smart_scripts` WHERE...

Item should not drop from creatures, Only from the gameobject -- 33086 Stonemaul Banner DELETE FROM `creature_loot_template` WHERE `entry`=4328 AND `item`=33086;

-- 27408 Banner of the Stonemaul UPDATE `quest_template` SET `NextQuestId` = 27409, `NextQuestIdChain` = 27409 WHERE `Id` = 27408; UPDATE `quest_template` SET `PrevQuestId` = 27408 WHERE `Id` = 27409; UPDATE `quest_template` SET `PrevQuestId` = 27409 WHERE `Id` = 27410; UPDATE `quest_template`...

-- 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...