Search results

Quest does not give quest complete signal. This should fix it. If not just let me know. UPDATE `quest_template` SET `RequiredNpcOrGo1` = -187655, `RequiredNpcOrGo4` = 0, `RequiredNpcOrGoCount1` = 10, `RequiredNpcOrGoCount4` = 0 WHERE `Id` = 11602;

High overlord saurfang showed three versions of this quest to everyone. This is incorrect. The conditions for each version of the quest are different. One requires nothing prior. Another requires the quest lord of the blackrock. And another requires a title from Ahn'qiraj. So the version...

Head of Nefarian in blackwing lair. 19003 should be alliance only. 19002 should be horde only Also loot chance was 1, It should be around a fifty percent chance to get this. UPDATE `item_template` SET `AllowableRace` = 2098253 WHERE `entry` = 19003; UPDATE `item_template` SET `AllowableRace`...

Corrects spell_script_target and conditions tables to target bunnies instead of gameobjects. DELETE FROM `spell_script_target` WHERE `entry`=34387 AND `type`=0 AND `targetEntry`=184289; DELETE FROM `spell_script_target` WHERE `entry`=34387 AND `type`=0 AND `targetEntry`=184290; DELETE FROM...

Adds missing unaura spellid 38776 to Smart scripts. DELETE FROM `smart_scripts` WHERE (`entryorguid`=17841 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`...

Corrected conditions to target 21511 unit Corrected spell_script_target to use unit not gameobject spawned 21511 Created smart scripts for 21469 Daranelle Removed script npc_daranelle Created SmartAI for Kiliri Totem 21468 to prevent server crash DELETE FROM `conditions` WHERE...

Created new fertile soil 185149 to replace bugged 185148 adjust requirements of quest 10771 corrected missing data in gameobject templates DELETE FROM `quest_template` WHERE `Id`=10771; INSERT INTO `quest_template` (`Id`, `Method`, `Note`, `Status`, `Level`, `MinLevel`, `MaxLevel`...

Quests 11585 and 11586 Are almost identical, And both show up on the Warsong recuitment officer 25273. The problem is that nobody ever set the faction requirements for these quests. Because if you have completed the greatmother quest chain in nagrand, That gives Mag'har reputation, You would...

There were only a few giant tidecrawlers in howling fjord area. I spaced them out like i saw on youtube, I do not have sniff data to use, But they walk around anyway. DELETE FROM `creature` WHERE `guid`=138002; INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`...

The smart scripts were using a wrong spellid to cast flying carpet. DELETE FROM `smart_scripts` WHERE `entryorguid`=2546000 AND `source_type`=9 AND `id`=0 AND `action_type`=11; UPDATE `smart_scripts` SET `id`=0 WHERE `entryorguid`=2546000 AND `source_type`=9 AND `id`=1 AND `action_type`=53;

Too many things were wrong with this quest to list. And a lot of the data was just missing. This is completely working on 7.02. If you run into any problems, Just let me know. There seems to be a problem with the flare gun vanishing from your inventory. It was listed as usable in eastern...

The wrong Garrosh hellscream was spawned in Warsong Hold. The correct one is 25237 DELETE FROM `creature` WHERE `id`=25237; INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`...

Kodo's remained dead after mounting them. DELETE FROM `smart_scripts` WHERE (`entryorguid`=25596 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`...

The creatures would not despawn. This made fighting multiple times almost impossible because of the corpses piled up. Killing the blue brothers only required one brother killed for quest completion. Now it requires both. Now they all despawn immediately except for the final boss, Who i left...

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