diff options
Diffstat (limited to 'sql')
11 files changed, 326 insertions, 0 deletions
diff --git a/sql/updates/world/2013_06_18_05_world_misc.sql b/sql/updates/world/2013_06_18_05_world_misc.sql new file mode 100644 index 00000000000..7971ea5e89a --- /dev/null +++ b/sql/updates/world/2013_06_18_05_world_misc.sql @@ -0,0 +1,29 @@ +-- Add texts for Captured Rageclaw +DELETE FROM `creature_text` WHERE `entry`=29686; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(29686,0,0,'I poop on you, trollses!',0,0,100,0,0,0,'Captured Rageclaw'), +(29686,0,1,'ARRRROOOOGGGGAAAA!',0,0,100,0,0,0,'Captured Rageclaw'), +(29686,0,2,'No more mister nice wolvar!',0,0,100,0,0,0,'Captured Rageclaw'); + +-- Add option conditions for Crusade Recruit +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (9650); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,9650,0,0,9,12509,0,0,0,0,'','Crusade Recruit - Show gossip option only if player has quest Troll Patrol: Intestinal Fortitude'); + +-- Add Any Missing Gossip Option for Gymer +DELETE FROM `gossip_menu_option` WHERE menu_id=9852; +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`)VALUES +(9852,0,0,"I'm ready, Gymer. Let's go!",1,1,0,0,0,0,''); + +-- Add option conditions for Gymer +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (15) AND `SourceGroup` IN (9852); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,9852,0,0,9,12919,0,0,0,0,'','Gymer - Show gossip option only if player has quest The Storm King''s Vengeance'); + +-- Gymer SAI Quest: The Storm King''s Vengeance +SET @ENTRY := 29647; +UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`= '' WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY; +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,62,0,100,0,9852,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Gymer - On Gossip Option Select - Close Gossip Window'), +(@ENTRY,0,1,0,61,0,100,0,0,0,0,0,85,55568,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Gymer - On Gossip Option Select - Player cast Summon Gymer on self'); diff --git a/sql/updates/world/2013_06_18_06_world_conditions.sql b/sql/updates/world/2013_06_18_06_world_conditions.sql new file mode 100644 index 00000000000..07bbf69bf39 --- /dev/null +++ b/sql/updates/world/2013_06_18_06_world_conditions.sql @@ -0,0 +1,4 @@ +-- Add spell target for Throw Ingredient +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=51025; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `Comment`) VALUES +(13,1,51025,0,31,3,28240,0,0, 'Throw Ingredient can be casted on Finklestein''s Cauldron Bunny'); diff --git a/sql/updates/world/2013_06_18_07_world_gossip.sql b/sql/updates/world/2013_06_18_07_world_gossip.sql new file mode 100644 index 00000000000..733ccab0748 --- /dev/null +++ b/sql/updates/world/2013_06_18_07_world_gossip.sql @@ -0,0 +1,18 @@ +-- Add Missing Gossip Menu Gurgthock +UPDATE `creature_template` SET `gossip_menu_id`=9863 WHERE `entry`=30007; +-- Add Missing Gossip Menu items for Gurgthock +DELETE FROM `gossip_menu` WHERE `entry`=9863 AND `text_id`=13679; -- Before Quest 12948 +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9863,13679); +DELETE FROM `gossip_menu` WHERE `entry`=9863 AND `text_id`=13680; -- After Quest 12948 +INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (9863,13680); +-- Add Gossip Menu conditions for Gurgthock +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14) AND `SourceGroup` IN (9863); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(14,9863,13679,0,8,12948,0,0,1,0,'','Gurgthock - Show gossip text only if player does not have Quest 12948 rewarded'), +(14,9863,13680,0,8,12948,0,0,0,0,'','Gurgthock - Show gossip text only if player does have Quest 12948 rewarded'); +-- Add some miss texts for Gurgthock +DELETE FROM `creature_text` WHERE `entry`=30007 AND `groupid` IN (7,8,9); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(30007,7,0,'The grand Amphitheater of Anguish awaits, $N. Remember, once a battle starts you have to stay in the area. WIN OR DIE!',12,0,100,1,0,0,'Gurgthock'), +(30007,8,0,'Here we are once again, ladies and gentlemen. The epic struggle between life and death in the Amphitheater of Anguish! For this round we have $N versus the hulking jormungar, Yg... Yggd? Yggdoze? Who comes up with these names?! $N versus big worm!',14,0,100,0,0,13363,'Gurgthock SAY_QUEST_AMPHITHEATER_ANGUISH_YGGDRAS'), +(30007,9,0,'Prepare to make you stand, $N! Get in the Amphitheater and stand ready! Remember, you and your opponent must stay in the arena at all times or you will be disqualified!',12,0,100,1,0,0,'Gurgthock'); diff --git a/sql/updates/world/2013_06_19_00_world_creature.sql b/sql/updates/world/2013_06_19_00_world_creature.sql new file mode 100644 index 00000000000..7ac3cd694f9 --- /dev/null +++ b/sql/updates/world/2013_06_19_00_world_creature.sql @@ -0,0 +1,78 @@ +-- Fix The Amphitheater of Anguish Spawning +SET @GUID := 125601; -- 40 required +DELETE FROM `creature` WHERE `id`IN (30193,30102); +DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+39; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +-- Invisible Stalker +(@GUID+0,15214,571,1,1,0,0,5729.15 ,-3015.369,296.5512,4.607669,120,0,0,1,0,0,0,0,0), +(@GUID+1,15214,571,1,1,0,0,5818.867,-2976.993,290.2759,2.495821,120,0,0,1,0,0,0,0,0), +(@GUID+2,15214,571,1,1,0,0,5743.459,-3012.192,290.7671,2.565634,120,0,0,1,0,0,0,0,0), +(@GUID+3,15214,571,1,1,0,0,5740.554,-3009.175,290.2759,0.296706,120,0,0,1,0,0,0,0,0), +(@GUID+4,15214,571,1,1,0,0,5791.739,-3015.988,286.5712,1.605703,120,0,0,1,0,0,0,0,0), +(@GUID+5,15214,571,1,1,0,0,5816.957,-2972.925,290.2759,3.333579,120,0,0,1,0,0,0,0,0), +(@GUID+6,15214,571,1,1,0,0,5796.063,-3015.993,286.6147,4.974188,120,0,0,1,0,0,0,0,0), +(@GUID+7,15214,571,1,1,0,0,5824.51 ,-2955.568,296.551,0.9948376,120,0,0,1,0,0,0,0,0), +-- Amphitheater Spectator +(@GUID+8,30102,571,1,1,0,0,5723.329,-3040.881,303.6286,0.3316126,120,0,0,1,0,0,0,0,0), +(@GUID+9,30102,571,1,1,0,0,5691.038,-2993.651,307.4399,0.05358058,120,0,0,1,0,0,0,0,0), +(@GUID+10,30102,571,1,1,0,0,5697.557,-2985.958,303.6294,0.3316126,120,0,0,1,0,0,0,0,0), +(@GUID+11,30102,571,1,1,0,0,5732.329,-3059.191,303.6294,0.541052,120,0,0,1,0,0,0,0,0), +(@GUID+12,30102,571,1,1,0,0,5735.703,-3037.584,296.5507,0.5585054,120,0,0,1,0,0,0,0,0), +(@GUID+13,30102,571,1,1,0,0,5849.702,-2984.776,300.2807,3.089233,120,0,0,1,0,0,0,0,0), +(@GUID+14,30102,571,1,1,0,0,5862.831,-2978.309,307.4399,3.071779,120,0,0,1,0,0,0,0,0), +(@GUID+15,30102,571,1,1,0,0,5826.039,-2935.936,300.2697,3.647738,120,0,0,1,0,0,0,0,0), +(@GUID+16,30102,571,1,1,0,0,5691.663,-2974.02,303.6294,0.122173,120,0,0,1,0,0,0,0,0), +(@GUID+17,30102,571,1,1,0,0,5823.243,-2895.698,307.4401,3.979351,120,0,0,1,0,0,0,0,0), +(@GUID+18,30102,571,1,1,0,0,5824.486,-2917.669,303.6294,4.122175,120,0,0,1,0,0,0,0,0), +(@GUID+19,30102,571,1,1,0,0,5801.149,-2895.24,303.6294,4.537856,120,0,0,1,0,0,0,0,0), +(@GUID+20,30102,571,1,1,0,0,5814.957,-2911.626,300.2807,4.253134,120,0,0,1,0,0,0,0,0), +(@GUID+21,30102,571,1,1,0,0,5821.17,-2911.49,303.6294,3.787364,120,0,0,1,0,0,0,0,0), +(@GUID+22,30102,571,1,1,0,0,5790.656,-2901.042,300.2807,4.939282,120,0,0,1,0,0,0,0,0), +-- Amphitheater Spectator +(@GUID+23,30193,571,1,1,0,0,5716.436,-3047.592,307.4399,0.3490658,120,0,0,1,0,0,0,0,0), +(@GUID+24,30193,571,1,1,0,0,5730.827,-3041.423,300.2801,0.4886922,120,0,0,1,0,0,0,0,0), +(@GUID+25,30193,571,1,1,0,0,5704.682,-2986.659,300.2743,0.3665192,120,0,0,1,0,0,0,0,0), +(@GUID+26,30193,571,1,1,0,0,5705.174,-2973.334,296.5504,0.1396263,120,0,0,1,0,0,0,0,0), +(@GUID+27,30193,571,1,1,0,0,5722.959,-3059.555,307.44,0.541052,120,0,0,1,0,0,0,0,0), +(@GUID+28,30193,571,1,1,0,0,5841.792,-2986.62,296.5501,3.179028,120,0,0,1,0,0,0,0,0), +(@GUID+29,30193,571,1,1,0,0,5855.139,-2997.216,300.2807,3.700098,120,0,0,1,0,0,0,0,0), +(@GUID+30,30193,571,1,1,0,0,5742.438,-3050.167,296.5508,0.5235988,120,0,0,1,0,0,0,0,0), +(@GUID+31,30193,571,1,1,0,0,5865.154,-3003.392,303.6294,3.124139,120,0,0,1,0,0,0,0,0), +(@GUID+32,30193,571,1,1,0,0,5856.421,-2985.136,303.6294,3.089233,120,0,0,1,0,0,0,0,0), +(@GUID+33,30193,571,1,1,0,0,5868.514,-2990.317,307.44,3.127902,120,0,0,1,0,0,0,0,0), +(@GUID+34,30193,571,1,1,0,0,5696.096,-2968.275,300.2807,0.03490658,120,0,0,1,0,0,0,0,0), +(@GUID+35,30193,571,1,1,0,0,5715.793,-2945.014,296.5512,5.462881,120,0,0,1,0,0,0,0,0), +(@GUID+36,30193,571,1,1,0,0,5810.117,-2898.158,303.6294,4.359755,120,0,0,1,0,0,0,0,0), +(@GUID+37,30193,571,1,1,0,0,5836.928,-2924.024,307.4398,3.965052,120,0,0,1,0,0,0,0,0), +-- Amphitheater Vendor +(@GUID+38,30098,571,1,1,0,0,5691.513,-3001.708,307.3175,1.629701,120,0,0,1,0,0,0,0,0), +(@GUID+39,30098,571,1,1,0,0,5834.321,-2966.102,296.4593,1.962511,120,0,0,1,0,0,0,0,0); + +SET @GUID := 13; -- 2 required +DELETE FROM `creature` WHERE `guid` IN (@GUID,@GUID+1); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES +-- Zena <Wodin's Warrior Kitten> +(@GUID+0,30140,571,1,1,0,0,5791.278,-3021.8,286.468,4.550161,120,5,0,1,0,1,0,0,0), +-- [DND] Anguish Spectator Bunny +(@GUID+1,30156,571,1,1,0,0,5776.664,-2989.059,278.9828,0.4014257,120,0,0,1,0,0,0,0,0); + +-- Update [DND] Anguish Spectator Bunny +UPDATE `creature_template` SET `InhabitType`=4, `flags_extra`=128 WHERE `entry`=30156; +-- Update Wodin the Troll-Servant +UPDATE `creature` SET `modelid`=12829, `orientation`=1.832596 WHERE `guid`=200821; +UPDATE `creature_template_addon` SET `bytes1`=0, `bytes2`=1 WHERE `entry`=30009; +-- Update Gurgthock <Fight Promoter> +UPDATE `creature` SET `orientation`=2.024582 WHERE `guid`=200822; +UPDATE `creature_template_addon` SET `path_id`=0, `mount`=26755, `bytes1`=0, `bytes2`=1 WHERE `entry`=30007; +-- Invisible Stalker +UPDATE `creature` SET `modelid`=0 WHERE `id`=15214; + +-- Add Missing go's +SET @OGUID := 7093; -- 5 required +DELETE FROM `gameobject` WHERE `map`=571 AND `id` IN (192238,192614,192615,192237,192240); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@OGUID+0,192238,571,1,1,5784.361,-3105.425,326.7856,0.4450589,0,0,0.2206974,0.9753423,120,0,1), +(@OGUID+1,192614,571,1,1,5850.665,-3038.08,307.9219,2.015852,0,0,0.845727,0.5336158,120,0,1), +(@OGUID+2,192615,571,1,1,5770.064,-3076.525,307.9219,2.015852,0,0,0.845727,0.5336158,120,0,1), +(@OGUID+3,192237,571,1,1,5865.14,-3066.895,326.8948,0.4450589,0,0,0.2206974,0.9753423,120,0,1), +(@OGUID+4,192240,571,1,1,5827.597,-3123.574,345.3081,-1.125737,0,0,-0.5336142,0.845728,120,0,1); diff --git a/sql/updates/world/2013_06_20_00_world_creature.sql b/sql/updates/world/2013_06_20_00_world_creature.sql new file mode 100644 index 00000000000..1ce9bce76d7 --- /dev/null +++ b/sql/updates/world/2013_06_20_00_world_creature.sql @@ -0,0 +1,2 @@ +-- Cleaning db, those mobs already have emote asigned on creature_template_addon +DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE `id` = 33236) AND `emote`=27; diff --git a/sql/updates/world/2013_06_20_01_world_misc.sql b/sql/updates/world/2013_06_20_01_world_misc.sql new file mode 100644 index 00000000000..426e898f601 --- /dev/null +++ b/sql/updates/world/2013_06_20_01_world_misc.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=55945; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(55945,"spell_gen_spectator_cheer_trigger"); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (30102,30193); +INSERT INTO `creature_template_addon` (`entry`,`bytes2`,`auras`) VALUES +(30102,1, '55944 56060'),(30193,1, '55944 56060'); diff --git a/sql/updates/world/2013_06_20_02_world_creature_text.sql b/sql/updates/world/2013_06_20_02_world_creature_text.sql new file mode 100644 index 00000000000..416ead95371 --- /dev/null +++ b/sql/updates/world/2013_06_20_02_world_creature_text.sql @@ -0,0 +1,11 @@ +-- Creature text for Amphitheater Vendor +DELETE FROM `creature_text` WHERE `entry` IN (30098); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(30098,0,0, 'Snacks!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,1, 'Snacks for sale!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,2, 'Get your snacks here!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,3, 'Snacks! Get your snacks here!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,4, 'Popcorn! Get your popcorn!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,5, 'Peanuts! Get your peanuts here!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,6, 'Anguish Ale! Cold Anguish Ale here!',12,0,100,0,0,0,'Amphitheater Vendor'), +(30098,0,7, 'Popcorn! Peanuts! Ale!',12,0,100,0,0,0,'Amphitheater Vendor'); diff --git a/sql/updates/world/2013_06_20_03_world_spell_script_names.sql b/sql/updates/world/2013_06_20_03_world_spell_script_names.sql new file mode 100644 index 00000000000..5863a4031aa --- /dev/null +++ b/sql/updates/world/2013_06_20_03_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=56096; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(56096,"spell_gen_vendor_bark_trigger"); diff --git a/sql/updates/world/2013_06_20_04_world_waypoints.sql b/sql/updates/world/2013_06_20_04_world_waypoints.sql new file mode 100644 index 00000000000..2828f320835 --- /dev/null +++ b/sql/updates/world/2013_06_20_04_world_waypoints.sql @@ -0,0 +1,156 @@ +-- Pathing for Amphitheater Vendor Entry: 30098 +SET @NPC := 125639; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5714.727,`position_y`=-2993.386,`position_z`=296.461 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '56094'); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`,`orientation`) VALUES +(@PATH,1,5714.727,-2993.386,296.461,6000,0,0,100,0,2.04084), +(@PATH,2,5714.554,-2992.06,296.4618,0,0,0,100,0,0), +(@PATH,3,5711.305,-2988.808,296.4676,0,0,0,100,0,0), +(@PATH,4,5705.161,-2981.065,296.4691,0,0,0,100,0,0), +(@PATH,5,5700.827,-2970.708,296.4702,0,0,0,100,0,0), +(@PATH,6,5696.297,-2957.711,296.4715,0,0,0,100,0,0), +(@PATH,7,5696.799,-2955.088,296.4714,0,0,0,100,0,0), +(@PATH,8,5697.822,-2953.404,296.4712,6000,0,0,100,0,0), +(@PATH,9,5695.771,-2953.885,296.4716,0,0,0,100,0,0), +(@PATH,10,5696.042,-2961.384,296.4715,0,0,0,100,0,0), +(@PATH,11,5702.383,-2974.2,296.4698,0,0,0,100,0,0), +(@PATH,12,5707.034,-2983.82,296.4686,0,0,0,100,0,0), +(@PATH,13,5713.569,-2990.567,296.4613,0,0,0,100,0,0), +(@PATH,14,5712.346,-2989.936,296.4673,6000,0,0,100,0,0), +(@PATH,15,5714.215,-2991.943,296.4613,0,0,0,100,0,0), +(@PATH,16,5717.194,-2999.773,296.4234,0,0,0,100,0,0), +(@PATH,17,5728.412,-3022.169,296.4291,0,0,0,100,0,0), +(@PATH,18,5730.965,-3027.998,296.45895,0,0,0,100,0,0), +(@PATH,19,5708.885,-3039.621,307.3123,0,0,0,100,0,0), +(@PATH,20,5711.497,-3040.242,307.3558,6000,0,0,100,0,0), +(@PATH,21,5711.84,-3044.363,307.3188,0,0,0,100,0,0), +(@PATH,22,5716.811,-3055.433,307.3327,0,0,0,100,0,0), +(@PATH,23,5721.602,-3063.456,307.36,0,0,0,100,0,0), +(@PATH,24,5725.222,-3067.889,307.3367,0,0,0,100,0,0), +(@PATH,25,5725.133,-3070.596,307.3248,0,0,0,100,0,0), +(@PATH,26,5719.292,-3073.477,311.0657,0,0,0,100,0,0), +(@PATH,27,5713.645,-3075.998,312.6586,6000,0,0,100,0,0), +(@PATH,28,5714.134,-3075.827,312.6587,0,0,0,100,0,0), +(@PATH,29,5720.383,-3072.84,310.5493,0,0,0,100,0,0), +(@PATH,30,5725.57,-3070.224,307.3301,0,0,0,100,0,0), +(@PATH,31,5723.997,-3066.298,307.3327,0,0,0,100,0,0), +(@PATH,32,5720.401,-3061.947,307.3509,0,0,0,100,0,0), +(@PATH,33,5716.573,-3055.332,307.33,0,0,0,100,0,0), +(@PATH,34,5713.17,-3048.396,307.3137,0,0,0,100,0,0), +(@PATH,35,5708.885,-3039.621,307.3123,0,0,0,100,0,0), +(@PATH,36,5710.52,-3038.915,307.3293,6000,0,0,100,0,0), +(@PATH,37,5730.965,-3027.998,296.45895,0,0,0,100,0,0), +(@PATH,38,5732.765,-3031.719,296.4664,0,0,0,100,0,0), +(@PATH,39,5732.112,-3034.138,296.4667,6000,0,0,100,0,0), +(@PATH,40,5733.084,-3031.317,296.4664,0,0,0,100,0,0), +(@PATH,41,5730.009,-3025.079,296.4313,0,0,0,100,0,0), +(@PATH,42,5725.542,-3017.257,296.4236,0,0,0,100,0,0), +(@PATH,43,5717.127,-2999.863,296.4223,0,0,0,100,0,0), +(@PATH,44,5714.964,-2994.664,296.4603,0,0,0,100,0,0), +(@PATH,45,5692.41,-3004.103,307.3565,6000,0,0,100,0,0.1291), +(@PATH,46,5691.513,-3001.708,307.3175,0,0,0,100,0,0), +(@PATH,47,5688.313,-2996.178,307.3124,0,0,0,100,0,0), +(@PATH,48,5684.693,-2989.563,307.3086,0,0,0,100,0,0), +(@PATH,49,5677.367,-2974.369,307.3082,0,0,0,100,0,0), +(@PATH,50,5674.822,-2968.894,307.309,0,0,0,100,0,0), +(@PATH,51,5678.438,-2968.422,307.3421,6000,0,0,100,0,0), +(@PATH,52,5676.909,-2970.624,307.3198,0,0,0,100,0,0), +(@PATH,53,5678.826,-2977.606,307.3074,0,0,0,100,0,0), +(@PATH,54,5685.183,-2989.712,307.3122,0,0,0,100,0,0), +(@PATH,55,5692.096,-3002.872,307.3178,0,0,0,100,0,0), +(@PATH,56,5693.071,-3001.71,307.3307,6000,0,0,100,0,0), +(@PATH,57,5694.927,-3003.501,307.34024,0,0,0,100,0,0), +(@PATH,58,5714.964,-2994.664,296.4603,0,0,0,100,0,0); +-- 0xF130007592007A8C .go 5714.727 -2993.386 296.461 + +-- Pathing for Amphitheater Vendor Entry: 30098 +SET @NPC := 125640; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=5815.197,`position_y`=-2890.652,`position_z`=307.3073 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '56094'); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`,`orientation`) VALUES +(@PATH,1,5815.197,-2890.652,307.3073,0,0,0,100,0,0), +(@PATH,2,5794.252,-2883.318,307.3083,0,0,0,100,0,0), +(@PATH,3,5788.011,-2882.464,307.3129,0,0,0,100,0,0), +(@PATH,4,5777.774,-2887.472,307.314,6000,0,0,100,0,5.081746), +(@PATH,5,5781.212,-2885.993,307.3153,0,0,0,100,0,0), +(@PATH,6,5790.22,-2882.968,307.3221,0,0,0,100,0,0), +(@PATH,7,5812.069,-2889.932,307.3122,0,0,0,100,0,0), +(@PATH,8,5824.013,-2894.033,307.3106,0,0,0,100,0,0), +(@PATH,9,5832.72,-2904.214,307.3027,0,0,0,100,0,0), +(@PATH,10,5839.131,-2917.173,307.3007,0,0,0,100,0,0), +(@PATH,11,5842.978,-2932.468,307.3301,6000,0,0,100,0,3.49564), +(@PATH,12,5823.141,-2942.902,296.4594,0,0,0,100,0,0), +(@PATH,13,5820.456,-2941.357,296.463,0,0,0,100,0,0), +(@PATH,14,5818.377,-2934.065,296.4635,0,0,0,100,0,0), +(@PATH,15,5815.375,-2925.807,296.4646,0,0,0,100,0,0), +(@PATH,16,5810.773,-2915.595,296.4659,0,0,0,100,0,0), +(@PATH,17,5806.843,-2906.805,296.467,0,0,0,100,0,0), +(@PATH,18,5803.637,-2903.886,296.4672,0,0,0,100,0,0), +(@PATH,19,5793.222,-2907.475,296.4679,0,0,0,100,0,0), +(@PATH,20,5789.824,-2907.318,296.4679,0,0,0,100,0,0), +(@PATH,21,5793.065,-2905.667,296.4679,6000,0,0,100,0,0), +(@PATH,22,5802.28,-2903.771,296.467,0,0,0,100,0,0), +(@PATH,23,5805.051,-2905.157,296.4671,0,0,0,100,0,0), +(@PATH,24,5811.012,-2917.848,296.4655,0,0,0,100,0,0), +(@PATH,25,5816.104,-2930.128,296.4639,0,0,0,100,0,0), +(@PATH,26,5819.828,-2938.419,296.463,0,0,0,100,0,0), +(@PATH,27,5823.147,-2946.686,296.4627,0,0,0,100,0,0), +(@PATH,28,5826.026,-2950.458,296.4608,6000,0,0,100,0,0), +(@PATH,29,5836.404,-2972.255,296.4608,0,0,0,100,0,0), +(@PATH,30,5838.149,-2976.351,296.4612,0,0,0,100,0,0), +(@PATH,31,5859.727,-2966.575,307.32678,0,0,0,100,0,0), +(@PATH,32,5861.81,-2971.323,307.3561,0,0,0,100,0,0), +(@PATH,33,5863.061,-2972.167,307.3237,0,0,0,100,0,0), +(@PATH,34,5866.722,-2976.944,307.311,0,0,0,100,0,0), +(@PATH,35,5871.775,-2988.365,307.3141,0,0,0,100,0,0), +(@PATH,36,5872.965,-2994.138,307.3567,0,0,0,100,0,0), +(@PATH,37,5874.925,-2998.613,307.3567,0,0,0,100,0,0), +(@PATH,38,5880.139,-2996.332,310.5986,0,0,0,100,0,0), +(@PATH,39,5887.151,-2993.677,312.6583,0,0,0,100,0,0), +(@PATH,40,5889.792,-2992.4,312.6583,0,0,0,100,0,0), +(@PATH,41,5885.894,-2993.681,312.6583,6000,0,0,100,0,0), +(@PATH,42,5880.026,-2996.398,310.5436,0,0,0,100,0,0), +(@PATH,43,5874.923,-2998.589,307.3567,0,0,0,100,0,0), +(@PATH,44,5872.593,-2994.324,307.3567,0,0,0,100,0,0), +(@PATH,45,5866.108,-2975.193,307.3089,0,0,0,100,0,0), +(@PATH,46,5863.831,-2970.042,307.3072,0,0,0,100,0,0), +(@PATH,47,5862.619,-2971.012,307.3227,0,0,0,100,0,0), +(@PATH,48,5859.727,-2966.575,307.32678,6000,0,0,100,0,0), +(@PATH,49,5838.149,-2976.351,296.4612,0,0,0,100,0,0), +(@PATH,50,5840.075,-2980.193,296.4609,0,0,0,100,0,0), +(@PATH,51,5841.883,-2981.336,296.4596,0,0,0,100,0,0), +(@PATH,52,5845.005,-2984.348,296.4602,0,0,0,100,0,0), +(@PATH,53,5847.249,-2989.125,296.461,0,0,0,100,0,0), +(@PATH,54,5850.176,-2994.417,296.4619,0,0,0,100,0,0), +(@PATH,55,5854.216,-3003.275,296.4633,0,0,0,100,0,0), +(@PATH,56,5857.905,-3012.948,296.4679,0,0,0,100,0,0), +(@PATH,57,5855.694,-3012.666,296.4679,6000,0,0,100,0,0), +(@PATH,58,5856.008,-3008.202,296.4679,0,0,0,100,0,0), +(@PATH,59,5852.001,-2999.263,296.4626,0,0,0,100,0,0), +(@PATH,60,5846.733,-2987.699,296.4607,0,0,0,100,0,0), +(@PATH,61,5841.884,-2981.688,296.4596,0,0,0,100,0,0), +(@PATH,62,5839.803,-2981.84,296.4595,6000,0,0,100,0,0), +(@PATH,63,5838.802,-2979.086,296.464,0,0,0,100,0,0), +(@PATH,64,5837.438,-2973.646,296.4601,0,0,0,100,0,0), +(@PATH,65,5834.321,-2966.102,296.4593,0,0,0,100,0,0), +(@PATH,66,5827.733,-2952.834,296.4597,0,0,0,100,0,0), +(@PATH,67,5824.319,-2947.607,296.4614,0,0,0,100,0,0), +(@PATH,68,5824.185,-2944.959,296.4594,0,0,0,100,0,0), +(@PATH,69,5823.141,-2942.902,296.4594,0,0,0,100,0,0), +(@PATH,70,5842.978,-2932.468,307.3301,0,0,0,100,0,0), +(@PATH,71,5842.981,-2931.031,307.3559,6000,0,0,100,0,2.07934), +(@PATH,72,5842.807,-2925.778,307.3042,0,0,0,100,0,0), +(@PATH,73,5836.683,-2912.875,307.3041,0,0,0,100,0,0), +(@PATH,74,5832.72,-2904.214,307.3027,0,0,0,100,0,0), +(@PATH,75,5824.013,-2894.033,307.3106,0,0,0,100,0,0); +-- 0xF130007592006C29 .go 5815.197 -2890.652 307.3073 + +-- Remove unneeded spawn +DELETE FROM `creature` WHERE `guid`=109649; +DELETE FROM `creature_addon` WHERE `guid`=109649; diff --git a/sql/updates/world/2013_06_21_00_world_creature.sql b/sql/updates/world/2013_06_21_00_world_creature.sql new file mode 100644 index 00000000000..7749b46d5e4 --- /dev/null +++ b/sql/updates/world/2013_06_21_00_world_creature.sql @@ -0,0 +1,15 @@ +-- Restore Lost Data +DELETE FROM `creature_addon` WHERE `guid` IN (14448,14449,14456,14458,14459); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES +(14448,144480,1,0, '22766'), +(14449,144490,1,0, '22766'), +(14456,144560,1,0, '22766'), +(14458,144580,1,0, '22766'), +(14459,144590,1,0, '22766'); + +DELETE FROM `creature_template_addon` WHERE `entry`=3457; +INSERT INTO `creature_template_addon` (`entry`,`path_id`,`bytes2`,`mount`,`auras`) VALUES +(3457,0,1,0, '22766'); + +-- Fix respawn for Steelforged Defenders at Ulduar +UPDATE `creature` SET `spawntimesecs`=7200 WHERE (`id`=33236); diff --git a/sql/updates/world/2013_06_21_01_world_creature.sql b/sql/updates/world/2013_06_21_01_world_creature.sql new file mode 100644 index 00000000000..64b0de97f34 --- /dev/null +++ b/sql/updates/world/2013_06_21_01_world_creature.sql @@ -0,0 +1,3 @@ +-- Proper respawn time for a lot of mobs and delete incorrectly spawned mobs +DELETE FROM `creature` WHERE `id` IN (14397,15718); +UPDATE `creature` SET `spawntimesecs`=7200 WHERE (`map` IN (209,329,429,469,509,531) AND `spawntimesecs` IN (3520,3300,1800,1650)) OR `id` IN (12129,32593); |