Search results

Missing stockpiles and ingots added Stockpiles DELETE FROM `gameobject` WHERE `guid`=9969137; INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`...

Quest King Of The Foulwealds 13989 fix 7.02 The temp foulweald totem bunny wasn't spawned Also the server problem where it always spawns four of every summoned creature, Makes this quest a nightmare. DELETE FROM `gameobject` WHERE `guid`=9969079; INSERT INTO `gameobject` (`guid`, `id`, `map`...

This fixes the error spam in console for samantha shackleton in undercity. And enables her local speech. However, Changing the speech timers in the smart scripts seems to have no effect whatsoever. Possibly they hardcoded her into the server? I do not understand. But nonetheless this fixes...

SFG was not spawned on corpse of Sgt DELETE FROM `gameobject` WHERE `guid`=9968523; INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`...

No loot option on dead soldiers, No npc to turn quest in to. Set flags on soldiers DELETE FROM `creature_template` WHERE `entry`=36756; INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`...

The cages were missing data which i added. The smart scripts are preexisting in 7.02. If there is a condition set for this quest I am unable to find it. Quest 10238 DELETE FROM `quest_template` WHERE `Id`=10238; INSERT INTO `quest_template` (`Id`, `Method`, `Note`, `Status`, `Level`...

On spell hit condition DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=99431 AND `SourceId`=0 AND `ElseGroup`=1 AND `ConditionTypeOrReference`=31 AND `ConditionTarget`=0 AND `ConditionValue1`=3 AND `ConditionValue2`=53543 AND `ConditionValue3`=0...

Missing fishing loot in Southfury river. DELETE FROM `fishing_loot_template` WHERE (`entry`=814); INSERT INTO `fishing_loot_template` VALUES (814, 58951, -100, 1, 0, 1, 1), (814, 818, 0.10619, 1, 1, 1, 1), (814, 2967, 0.10619, 1, 1, 1, 1), (814, 7350, 0.10619, 1, 1, 1, 1), (814, 45188...

Orgrimmar theif was missing Placement DELETE FROM `creature` WHERE `guid`=71222; INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`...

No crawfish were spawned, And they were attackable, Not lootable. Placement of crawfish DELETE FROM `creature` WHERE `guid`=717896; INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`...

Giant flesh eating tadpole droprate was too low in stillwater pond. DELETE FROM `fishing_loot_template` WHERE (`entry`=810) AND (`item`=69905); INSERT INTO `fishing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (810, 69905...

[Name, Type] Undercity, ruins of Lordaeron Moat, quest Moat Monster 29361 [What it does] Using the alliance disguise kit cannot be done as there are no nearby Ruins of Lordaeron moat objects. Using the alliance disguise kit requires you to target the moat monster first. This is wrong it should...

Drop rate was too low. DELETE FROM `fishing_loot_template` WHERE (`entry`=1497) AND (`item`=69901); INSERT INTO `fishing_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (1497, 69901, 5, 1, 1, 1, 1);

Brightwater Snail This sets the flags on the Brightwater Snail, And creates the smart_scripts that complete the quest. DELETE FROM `creature_template` WHERE `entry`=53526; INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`...

If your an avid crafter, Then you may have noticed the large amount of missing ores in version 7.02. And if you went to badlands, Searing Gorge, Or Burning Steppes. Then you probably saw the hundreds of Truesilver and Mithril ores clustered everywhere on those maps. This is a fix for those two...

I ran a couple of complex queries that identify quests that have no quest starter, And/Or no quest ender. This includes quests started and ended by npc's, gameobjects, And items. Once i had a list for starters, and enders. I spent two days online searching every single quest on those lists to...

Bug Report Tutorial + Truice V2.0 When creating a new bug report, It is important to have a format that is easy for the developers to read, So that they can scan the list quickly, And organize them accordingly. Bug reports should be submitted in the Cataclysm bug reports forum listed on the...

[Name, Type] azshara, wasn't it obvious?. horde [What it does] Nothing, There is no portal to walk through. [What it should do] Teleport me to a location to speak to other npc's. http://www.wowhead.com/quest=14389/wasnt-it-obvious https://www.youtube.com/watch?v=jjxuUFiLTOM&ytbChannel=MURLOC.TV

[Name, Type] Gurthalak, Voice of the Deeps, Item [What it does] the lower stone doesn't work. and is missing [What it should do] aquire arcane runestone by kills, then turn in at the lower scrying stone. http://www.wowhead.com/quest=14429/arcane-de-construction...

[Name, Type] azshara, amberwinds journal, horde [What it does] Kill the lorekeeper to get the item, then turn it in at the scrying stone, the stone doesnt work. [What it should do] turn in at the scrying stone. http://www.wowhead.com/quest=14428/amberwinds-journal...