Search results

-- 25001 Abyssal Flamewalker Abyssal Meteor Fall Forces him from Invisible to visible. -- 25001 Abyssal Flamewalker DELETE FROM `smart_scripts` WHERE (`entryorguid`=25001 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`...

Not all of these were missing their flags, But this is more of a broad sweep just to make sure. Basically, A vehicle that has no spellclick flag cannot be mounted. So this adds that ability to some that didn't work. And no this is not every vehicle in the game. UPDATE `creature_template` SET...

The cocoons shouldn't be able to attack, And should not give xp. UPDATE `creature_template` SET `unit_flags`=131076 WHERE `entry`=24210; UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry`=24210;

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

This quest was not able to complete, Because the spellfocus gameobject was in the water, Not between the two flags at the end of the warsong jetty. This fixes it to the center location between the flags. DELETE FROM `gameobject` WHERE `guid`=9955227; INSERT INTO `gameobject` (`guid`, `id`...

-- NPC 25288 Turida Coldwind, update existing gossip menu option with missing values UPDATE `gossip_menu_option` SET `OptionBroadcastTextID`= 53141, `option_id`= 4, `npc_option_npcflag`= 8192 WHERE `menu_id`= 13048; -- insert missing gossip menu DELETE FROM `gossip_menu` WHERE `entry` = 13048...

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