Search results

Non looting Moonleafs were missing quest id number in template. DELETE FROM `gameobject_template` WHERE `entry`=201914; INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`...

Lard lost his lunch fix 7.02 If you are using version 7.02 or lower of the server repack. Then you can use this single sql file to correct the multitude of over spawned summoned creatures, That are called via event_scripts. Most scripts were summoning four times the required amount of...

Health Modifier, Damage was extremely high. Set to gold elite, It's a normal. DELETE FROM `creature_template` WHERE `entry`=3771; INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`...

Missing Fel Wood Replaced DELETE FROM `gameobject` WHERE `guid`=9969278; INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`...

This is an ongoing list of broken vendors as i find and repair them. Feel free to add your own vendor fixes to this list as well. Jeremiah Payson 8403 No longer quest associated, So his quest flag, and gossip flags were removed. This fixed him. DELETE FROM `creature_template` WHERE...

Missing fertile dirt mounds. DELETE FROM `gameobject` WHERE `guid`=9969149; INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`...

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