diff options
| -rw-r--r-- | sql/updates/world/2015_11_01_00_world_from_335.sql | 175 |
1 files changed, 175 insertions, 0 deletions
diff --git a/sql/updates/world/2015_11_01_00_world_from_335.sql b/sql/updates/world/2015_11_01_00_world_from_335.sql new file mode 100644 index 00000000000..4d1adbb96d2 --- /dev/null +++ b/sql/updates/world/2015_11_01_00_world_from_335.sql @@ -0,0 +1,175 @@ +-- From d53d3c7b804573db475d16e9f3ff8d3e0de87ab6 Mon Sep 17 00:00:00 2001 +-- From: Dr-J <daniel.jarrott0@gmail.com> +-- Date: Sat, 18 Apr 2015 16:15:23 +0100 +-- Subject: [PATCH] DB/Misc: Delete duplicated gameobject +DELETE FROM `gameobject` WHERE `guid`=49312 AND `id`=187493; + +-- From 444cc12610af936fdd4ca9c599e8a9ec74deba42 Mon Sep 17 00:00:00 2001 +-- From: Dr-J <daniel.jarrott0@gmail.com> +-- Date: Sun, 19 Apr 2015 16:44:37 +0100 +-- Subject: [PATCH] DB/Quest: Vision Guide (Credit) +UPDATE `smart_scripts` SET `action_type`=85, `action_param1`=36569, `action_param2`=2, `comment`='Triggger - LOS -Cast Vision Guide: Quest Complete' WHERE `entryorguid`=21321 AND `source_type`=0 AND `id`=0 AND `link`=1; + +-- From 5310fb1aa7bb37daaf58f1e351440bc040d42faa Mon Sep 17 00:00:00 2001 +-- From: Kittnz <frederik156@hotmail.com> +-- Date: Sun, 19 Apr 2015 21:57:20 +0200 +-- Subject: [PATCH] DB/Path: Added group Highland Mustang pathing +-- Highland Mustang SAI +SET @ENTRY := 26472; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,8,0,100,0,49266,0,0,0,69,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Highland Mustang - On Spell Hit(Dangle Wild Carrot) - Move To Player"), +(@ENTRY,0,1,2,34,0,100,0,0,1,0,0,103,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Highland Mustang - On Reached Point 1 - Set Rooted Off"), +(@ENTRY,0,2,0,61,0,100,0,0,1,0,0,85,49282,0,0,0,0,0,1,0,0,0,0,0,0,0,"Highland Mustang - On Reached Point 1 - Invoker Cast 'Ride Highland Mustang'"), +(@ENTRY,0,3,0,27,0,100,0,0,0,0,0,103,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Highland Mustang - On Passenger Boarded - Remove Root"), +(@ENTRY,0,4,5,8,0,100,1,49319,0,0,0,89,10,0,0,0,0,0,1,0,0,0,0,0,0,0,"Highland Mustang - On Spellhit 'Scare Highland Mustang' - Flee For Assist (No Repeat)"), +(@ENTRY,0,5,6,61,0,100,0,0,0,0,0,11,49323,0,0,0,0,0,7,0,0,0,0,0,0,0,"Highland Mustang - On Spellhit 'Scare Highland Mustang' - Cast 'Highland Mustang Spooking Credit' (No Repeat)"), +(@ENTRY,0,6,0,61,0,100,0,0,0,0,0,41,5000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Highland Mustang - On Spellhit 'Scare Highland Mustang' - Despawn In 5000 ms (No Repeat)"); + +SET @LEADER := 105333; +DELETE FROM `creature_formations` WHERE `leaderGUID`=@LEADER; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(@LEADER, @LEADER, 0, 0, 2), +(@LEADER, 105334, 6, 20, 2), +(@LEADER, 105307, 6, 60, 2), +(@LEADER, 105327, 6, 100, 2), +(@LEADER, 105332, 6, 140, 2), +(@LEADER, 105330, 6, 180, 2), +(@LEADER, 105331, 6, 220, 2), +(@LEADER, 105310, 6, 260, 2), +(@LEADER, 105325, 6, 290, 2), +(@LEADER, 105308, 6, 340, 2); + +-- Pathing for Highland Mustang Entry: 26472 'TDB FORMAT' +SET @NPC := 105333; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4427.042,`position_y`=-4339.906,`position_z`=156.9126 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4427.042,-4339.906,156.9126,0,0,1,0,100,0), -- 12:00:19 +(@PATH,2,4408.496,-4311.258,159.5146,0,0,1,0,100,0), -- 12:00:25 +(@PATH,3,4395.234,-4306.927,159.0624,0,0,1,0,100,0), -- 12:00:28 +(@PATH,4,4357.375,-4353.118,158.7053,0,0,1,0,100,0), -- 12:00:32 +(@PATH,5,4358.002,-4387.411,154.6664,0,0,1,0,100,0), -- 12:00:37 +(@PATH,6,4350.741,-4420.083,151.4936,0,0,1,0,100,0), -- 12:00:41 +(@PATH,7,4355.459,-4451.332,147.9055,0,0,1,0,100,0), -- 12:00:45 +(@PATH,8,4382.324,-4459.469,141.1845,0,0,1,0,100,0), -- 12:00:49 +(@PATH,9,4389.952,-4415.67,148.3579,0,0,1,0,100,0), -- 12:00:53 +(@PATH,10,4397.468,-4374.768,153.7379,0,0,1,0,100,0); -- 12:00:58 +-- 0x203930476019DA0000000D0000337E18 .go 4427.042 -4339.906 156.9126 + +SET @LEADER := 105349; +DELETE FROM `creature_formations` WHERE `leaderGUID`=@LEADER; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES +(@LEADER, @LEADER, 0, 0, 2), +(@LEADER, 105304, 6, 20, 2), +(@LEADER, 105303, 6, 60, 2), +(@LEADER, 105305, 6, 100, 2), +(@LEADER, 105301, 6, 140, 2), +(@LEADER, 105283, 6, 180, 2), +(@LEADER, 105302, 6, 220, 2), +(@LEADER, 105350, 6, 260, 2), +(@LEADER, 105322, 6, 290, 2), +(@LEADER, 105321, 6, 340, 2); + +-- Pathing for Highland Mustang Entry: 26472 'TDB FORMAT' +SET @NPC := 105349; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=4402.506,`position_y`=-4058.453,`position_z`=178.0393 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,4402.506,-4058.453,178.0393,0,0,1,0,100,0), -- 11:54:03 +(@PATH,2,4409.204,-4045.754,177.6823,0,0,1,0,100,0), -- 11:54:07 +(@PATH,3,4437.108,-4006.367,180.2671,0,0,1,0,100,0), -- 11:54:09 +(@PATH,4,4444.708,-3989.958,182.246,0,0,1,0,100,0), -- 11:54:13 +(@PATH,5,4449.759,-3956.142,185.0904,0,0,1,0,100,0), -- 11:54:15 +(@PATH,6,4428.842,-3946.839,183.3041,0,0,1,0,100,0), -- 11:54:18 +(@PATH,7,4415.667,-3952.115,181.8032,0,0,1,0,100,0), -- 11:54:21 +(@PATH,8,4397.648,-3971.361,180.6909,0,0,1,0,100,0), -- 11:54:24 +(@PATH,9,4390.27,-4002.242,179.2844,0,0,1,0,100,0), -- 11:54:28 +(@PATH,10,4391.74,-4008.471,178.8489,0,0,1,0,100,0), -- 11:54:30 +(@PATH,11,4385.273,-4030.866,179.386,0,0,1,0,100,0), -- 11:54:31 +(@PATH,12,4376.343,-4062.502,181.3641,0,0,1,0,100,0), -- 11:54:34 +(@PATH,13,4392.244,-4068.051,179.3222,0,0,1,0,100,0); -- 11:54:37 +-- 0x203930476019DA0000000D00003393C1 .go 4402.506 -4058.453 178.0393 + +-- From bd8611baed3fdcb3ad25908eddaae98eb28ee8d6 Mon Sep 17 00:00:00 2001 +-- From: Killyana +-- Date: Thu, 23 Apr 2015 20:04:10 +0200 +-- Subject: [PATCH] DB/Misc: Fix conditions delete error on 210e45e303b +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND SourceEntry IN (46598,49078); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(18,34776,46598,0,0,31,0,3,0,0,0,0,'','Require unit for spellclick'), +(18,35069,46598,0,0,31,0,3,0,0,0,0,'','Require unit for spellclick'), +(18,35431,46598,0,0,31,0,3,0,0,0,0,'','Require unit for spellclick'), +(18,35433,46598,0,0,31,0,3,0,0,0,0,'','Require unit for spellclick'), +(18,28312,46598,0,0,31,0,3,0,0,0,0,'','Require unit for spellclick'), +(18,32627,46598,0,0,31,0,3,0,0,0,0,'','Require unit for spellclick'), +(18,25334,46598,0,0,9,0,11652,0,0,0,0,'','Player must have The Plains of Nasam taken but not completed to use Horde Siege tank'), +(18,27587,46598,0,0,31,0,3,0,0,0,0,'','Only npc for spellclick'), +(18,27587,49078,0,0,9,0,12326,0,0,0,0,'','Required quest active for spellclick'); + +-- From 83ffc5fca8648c90bc7f5d1e023faf82edada1cf Mon Sep 17 00:00:00 2001 +-- From: Dr-J <daniel.jarrott0@gmail.com> +-- Date: Thu, 23 Apr 2015 22:48:24 +0100 +-- Subject: [PATCH] DB/Quest: The Plume of Alystros +DELETE FROM `event_scripts` WHERE `id`=18223; +INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES +(18223, 0, 10, 23837, 180000, 0, 2629.2, 8.1333, 26.347, 0.401426); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=23837 AND `source_type`=0 AND `id` =6; +DELETE FROM `smart_scripts` WHERE `entryorguid`=27249 AND `source_type`=0 AND `id`>2; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(23837, 0, 6, 0, 11, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 27249, 0, 0, 0, 0, 0, 0, 'ELM General Purpose Bunny - On Just Summoned - Set Data to Alystros the Verdant Keeper'), +(27249, 0, 3, 4, 38, 0, 100, 0, 1, 1, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alystros the Verdant Keeper - On Data Set - Set Emote State None'), +(27249, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 19, 768, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alystros the Verdant Keeper - On Data Set - Set Unit Flags'), +(27249, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 4, 3605, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Alystros the Verdant Keeper - On Data Set - Play Sound 3605'), +(27249, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, 'Alystros the Verdant Keeper - On Data Set - Attack'); + +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=27249; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=7 AND `SourceEntry`=23837; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22, 7, 23837, 0, 0, 23, 1, 4179, 0, 0, 0, 0, 0, '', 'Only run SAI at Emerald Dragonshrine'), +(22, 7, 23837, 0, 1, 23, 1, 3979, 0, 0, 0, 0, 0, '', 'Only run SAI at Emerald Dragonshrine'); + +UPDATE `gameobject` SET `position_x`=2642.311523, `position_y`=-19.100948, `position_z`=1.434421 WHERE `guid`=99753; + +-- From abdb21130448be410b38f3753aa0a32ae08b5630 Mon Sep 17 00:00:00 2001 +-- From: Killyana +-- Date: Sun, 26 Apr 2015 14:01:22 +0200 +-- Subject: [PATCH] DB/Quest: The Black Knight's Orders +UPDATE smart_scripts SET event_param1=44 WHERE entryorguid=33519 AND source_type=0 AND id=2; + +-- From f62b0391c1763b840b004493f18f0ac3c1d99844 Mon Sep 17 00:00:00 2001 +-- From: sirikfoll +-- Date: Sun, 26 Apr 2015 14:03:40 +0200 +-- Subject: [PATCH] DB/Creature: Fix Kalecgos event +UPDATE `spell_linked_spell` SET `type`=0 WHERE `spell_trigger`=44869 AND `spell_effect`=44866 AND `type`=1; + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=46021 AND `spell_effect`=44852; +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(46021,44852,0,'Transported to the spectral realm turn Sathrovarr Hostile'); + +-- From ced8348beb659c159738c6b1785cd61fa6ffbbd6 Mon Sep 17 00:00:00 2001 +-- From: Killyana +-- Date: Sun, 26 Apr 2015 14:05:25 +0200 +-- Subject: [PATCH] DB/Item: Halaa bombs +SET @ENTRY := 18225; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,1,54,0,100,0,0,0,0,0,85,31961,0,0,0,0,0,1,0,0,0,0,0,0,0,"Fire Bomb Target - On Just Summoned - InvokerCast 'Fire Bomb'"), +(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,11,31963,0,0,0,0,0,1,0,0,0,0,0,0,0,"Fire Bomb Target - On Just Summoned - Cast to Summon Fire Bomb"); + +-- From d5850bc0f6c95fd7e635bed3639a7eb4b73e87d9 Mon Sep 17 00:00:00 2001 +-- From: Killyana +-- Date: Sun, 26 Apr 2015 14:09:03 +0200 +-- Subject: [PATCH] DB/Creature: Echeyakee +UPDATE `event_scripts` SET `x`=453.896027, `y`=-3039.76147, `z`=91.785370 WHERE `id`=2980; |