Search results

11153 Break the Blockade 33098 Petrov's Cluster Bombs Howling Fjord westguard keep The bombs are unusable most of the time, Because the ship is actually leaving the shattered straights area 4064, And crossing area 495 Howling Fjord. It seems like the bombs are only usable in area 4064, But the...

The harpoon should not move around. -- 11436 Let's Go Surfing Now -- 24701 Large Vrykul Harpoon Gun UPDATE `creature_template` SET `unit_flags` = 33555204 WHERE `entry` = 24701; UPDATE `creature` SET `spawndist`='0', `MovementType`='0' WHERE `id`=24701;

A gun was missing, No skills on gun, Gun wasn't usable. Defenders are spawned instead of scripted, Could change this later i guess. -- 11421 It Goes to 11... -- 27992 Vrykul Harpoon Gun UPDATE `creature_template` SET `unit_flags` = 16777216 WHERE `entry` = 27992; UPDATE `creature_template`...

Removes Console error due to non existing gameobject. -- 24806 Iron Rune Construct DELETE FROM `smart_scripts` WHERE (`entryorguid`=24806 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`...

The banner shouldn't be able to move or attack. -- 11429 Drop It then Rock It! -- 24640 Alliance Banner UPDATE `creature_template` SET `unit_flags` = 131076 WHERE `entry` = 24640;

There were missing eggs. The falcon couldn't fly, And was missing skills. Also the eggs had no SAI to loot eggs on spellhit. -- 11470 There Exists No Honor Among Birds -- 186946 Fjord Hawk Egg ONLY RUN THIS ONCE INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`...

Howling Fjord Daily Item 40946 Anuniaq's Net, Does not give the player a tasty reef fish when used on the spell focus object school of tasty reef fish. So the quest can never be completed. The spell for the net is 21014.

This fixes the bombers and their scripts. Gives new vehicle id's. Making it possible to fly to your destination. However there is a problem with the waypoints being processed for the bombers. The bomber always drops you before you reach your destination. And the bombers travel way too slow...

Sorlof had no SmartAI, Also he would not despawn in time to loot sorlof's booty. -- 11529 Sorlof's Booty UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24914; DELETE FROM `smart_scripts` WHERE (`entryorguid`=24914 AND `source_type`=0); INSERT INTO `smart_scripts`...

The victim did not have gossip options turned on. -- 11479 "Crowleg" Dan UPDATE `creature_template` SET `npcflag` = 1 WHERE `entry` = 24713;

Since the server can't perform spellclick on a creature that has no spell related to it. The creature must be despawned as an item is placed in the players inventory. This fixes that. And a few other corrections. -- 11476 A Carver and a Croaker DELETE FROM `creature_text` WHERE `entry`...

This fixes Harry's script . And sets conditions so his gossip only shows up if your on the quest. And fixes his alternate gossip menu -- 24539 "Silvermoon" Harry -- 11464 Gambling Debt DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9010 AND `SourceEntry`=0 AND...

This adds the missing Vrykul Gondolas to howling fjord -- RUN THIS ONLY ONCE -- 188360 Doodad_Vrykul_Gondola01 -- 190587 Doodad_Vrykul_Gondola_01 INSERT INTO `gameobject` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`...

This is a workaround for Orfus Of Kamagua not showing quests to horde characters. It changes the quest id, And fixes the spell area for Northsea Force Reaction spell. -- 11504 The Dead Rise! Renumbered UPDATE `quest_template` SET `Id`='1150400' WHERE `Id`=11504; UPDATE `quest_template` SET...

The great lift is not running in howling fjord. I am not familiar enough with the transports to know why this isn't operating. Ok After a lot of research, I finally found the missing gondolas in utgarde pinnacle, And copied them into howling fjord coordinates. The fix is here...

Howling Fjord at the great lift. From Orfus of Kamagua The quest The dead rise! should be available to horde and alliance with no prerequisite quests. But it does not show up to horde. Changing the quest giver faction to friendly had no effect. Changing the id of the quest has no effect. The...

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