Search results

-- 33961 33962 Scourge Device DELETE FROM `creature_loot_template` WHERE `entry`=23643 AND `item`=33961; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23643, 33961, 1.4, 1, 0, 1, 1); DELETE FROM...

186498 Gjalerbron Cage Missing Prisoners Missing -- 186498 Gjalerbron Cage DELETE FROM `gameobject` WHERE `id`=186498; INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`...

-- 24023 Queen Angerboda DELETE FROM `smart_scripts` WHERE (`entryorguid`=24023 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`...

-- 33314 33345 Vrykul Scroll of Ascension -- Stop The Ascension -- 23671 Halfdan the Ice-Hearted UPDATE `creature_template` SET `unit_flags` = 32768 WHERE `entry` = 23671; DELETE FROM `creature_text` WHERE `entry`=23671 AND `groupid`=0 AND `id`=0; INSERT INTO `creature_text` (`entry`...

Dropping his head at 33 percent was wrong. -- 23954 Ingvar The Plunderer DELETE FROM `creature_loot_template` WHERE `entry`=23954 AND `item`=22829; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23954...

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

Her conditions were set so that her gossip only showed when a quest was taken, But quest 11229 has no objectives, So it skipped showing the gossip text. I reset it to condition quest complete 28, and her gossip option 0 now shows properly. Conditions for quest 11170 test at sea were missing...

The auto attack function of creatures doesn't work unless one of them moves, And since the horde guards are in formation, I gave movement to the sailors. And this causes them to fight like their supposed to. -- 23866 Northfleet Sailor UPDATE `creature_template` SET `MovementType` = 1 WHERE...

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

The quest 29609 Friends in Dalaran requires you to speak to the flight master, And then fly to Dalaran. However the players do not know the flight path in Dalaran. Wether this should be learned at character creation, Or upon taking the quest I have no idea. But I also have no idea how to...

-- 23929 Giant Tidecrawler Movement UPDATE `creature_template` SET `MovementType` = 1 WHERE `entry` = 23929; UPDATE `creature` SET `spawndist`='10', `MovementType`='1' WHERE `id`= 23929;

I know i fixed this one before. This sounds like their scripts are messed up bigtime.

This means their scripts are missing or not running. So frigging stupid how things break sometimes.

-- 45300 Caretaker Nuunwa UPDATE `creature_template` SET `npcflag` = 65537 WHERE `entry` = 45300; UPDATE `gossip_menu_option` SET `option_id`='8', `npc_option_npcflag`='65536' WHERE `menu_id`=12003 AND `id`=0;

Uldum Hp & Movement Fixes 12/13/2017 Updated With Twinstar Data I played through Uldum as horde, Until I finished the quest gnomebliteration, And then I suddenly had no more quests. I'm not familiar enough with it to know if there was supposed to be more quests. Anyway This is a fix for most...

-- 60487 Tombs of the Precursors Digsite UPDATE `creature_template` SET `flags_extra` = 128 WHERE `entry` = 60487;

-- 48886 Kazemde Innkeeper UPDATE `creature_template` SET `npcflag` = 65665 WHERE `entry` = 48886;

-- 45321 Riverbed Crocolisk UPDATE `creature_template` SET `MovementType` = 1, `Health_mod` = 1 WHERE `entry` = 45321; UPDATE `creature` SET `spawndist`='20', `MovementType`='1' WHERE `id`=45321;

For some reason this script did not want to summon the second set of galeks at 10 seconds, So I changed it to six seconds, Which seems to work just fine. -- 25798 25799 Defend the Drill DELETE FROM `smart_scripts` WHERE (`entryorguid`=41299 AND `source_type`=0); INSERT INTO `smart_scripts`...

25543 Circle the Wagons... er, Boats Quest Order Spell Area -- 25543 Circle the Wagons... er, Boats Quest Order Spell Area UPDATE `quest_template` SET `PrevQuestId` = 25533 WHERE `Id` = 25543; UPDATE `quest_template` SET `PrevQuestId` = 25533 WHERE `Id` = 25562; DELETE FROM `spell_area` WHERE...