Search results

This removes the matron from the world unless it's during hallows end event. -- 23973 Masked Orphan Matron added to hallows end DELETE FROM `game_event_creature` WHERE `guid`=172254 AND `eventEntry`=12; INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES (12, 172254);

These two quests are mutually exclusive, Meaning you can only have one or the other, Not both. So I created an exclusive group, And added both quests to it. -- 24492 Escaped From Gilneas Have You Seen Anything Weird Out There? Quest Order UPDATE `quest_template` SET `ExclusiveGroup` = 24992...

The old scripts were too simple to work properly, The new trinitycore scripts don't work either. So here is a rewrite of everything that actually does work. -- Ever So Lonely 24974 SET @Oracle := 1544; SET @Puddlejumper := 1543; SET @OracleC := 39078; SET @PuddlejumperC :=38923; SET @Sparky...

Rewritten to correct problem with players being attacked. -- A Scarlet Letter 24979 SET @Lilian:= 38999; SET @Gebler:= 39002; DELETE FROM `smart_scripts` WHERE `entryorguid` = @Lilian AND `source_type` = 0; DELETE FROM `smart_scripts` WHERE `entryorguid` = @Lilian*100 AND...

-- Deathknell Guards Health Mod Fix Stops them from laying dead -- 1740 1741 1736 1739 UPDATE `creature_template` SET `Health_mod` = 1 WHERE `entry` IN (1736, 1739, 1740, 1741);

-- The Wakening 24960 SET @Valdred := 49231; SET @Marshal := 49230; SET @Lilian := 38895; SET @Caice := 2307; DELETE FROM `creature` WHERE `id`=49231; DELETE FROM `creature` WHERE `id`=49230; DELETE FROM `creature` WHERE `id`=38895; UPDATE `creature_template` SET...

The undead should be in the grave, Not on the ground next to it. -- 24959 Fresh out of the Grave Placement Fix -- Undead Create Coordinates DELETE FROM `playercreateinfo` WHERE `race`=5 AND `class`=9; INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`...

Volcanoth should not move. -- 38855 Volcanoth Movement Fix UPDATE `creature_template` SET `unit_flags` = 32772 WHERE `entry` = 38855;

Removed from loot table, Added into SAI -- 24859 Naga Hide Drop Rate Fix -- 50437 Intact Naga Hide -- 38360 Vashj'elan Siren DELETE FROM `smart_scripts` WHERE (`entryorguid`=38360 AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`...

The traps will now despawn, But they don't do it instantly. -- 24741 Trading Up -- 201972 Raptor Trap -- 201974 Raptor Egg -- 50232 Wild Clucker Eggs Object -- 38195 Wild Clucker Egg Npc -- 56576 Wild clucker Spell UPDATE `gameobject_template` SET `flags` = 4 WHERE `entry` = 201972; DELETE...

-- 6491 Spirit Healer Wild Overlook Lost Isles DELETE FROM `creature` WHERE `id`=6491; INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`...

The hot rods were slow as a snail, Even with rocket boost turned on, So I made them faster. -- 34840 Hot Rod UPDATE `creature_template` SET `speed_run` = 2 WHERE `entry` = 34840;

This was an attempt to stop the Gyrochoppah from Falling out of the sky during it's waypoint movments. However it did not work. But I did manage to fix the speed problem with it. -- 36143 Gyrochoppah UPDATE `creature_template` SET `flags_extra` = 536870912 WHERE `entry` = 36143; UPDATE...

-- 39152 Bastia Waypoint Movement Fix UPDATE `creature_template` SET `flags_extra` = 536870912 WHERE `entry` = 39152;

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