diff options
Diffstat (limited to 'sql')
7 files changed, 497 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 0f828b08c50..4a11ccb6380 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1001,6 +1001,7 @@ DROP TABLE IF EXISTS `character_queststatus_rewarded`; CREATE TABLE `character_queststatus_rewarded` ( `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `active` tinyint(10) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql b/sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql new file mode 100644 index 00000000000..e4dbf73ad7a --- /dev/null +++ b/sql/updates/characters/2013_03_04_00_characters_character_queststatus_rewarded.sql @@ -0,0 +1 @@ +ALTER TABLE `character_queststatus_rewarded` ADD `active` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `quest`; diff --git a/sql/updates/world/2013_03_04_01_world_waypoint_data.sql b/sql/updates/world/2013_03_04_01_world_waypoint_data.sql new file mode 100644 index 00000000000..3a2001e7e36 --- /dev/null +++ b/sql/updates/world/2013_03_04_01_world_waypoint_data.sql @@ -0,0 +1,153 @@ +SET @GUID := 40470; +SET @PATH := @GUID*10; +DELETE FROM `creature` where `id`=18686; +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 +(@GUID,18686,530,1,1,0,0,-2847.327,3195.10722,7.4167,.0910940,300,0,0,9144,13525,2,0,0,0); +-- Pathing Data +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_flag`,`action`,`action_chance`) VALUES +(@PATH,1,-2843.86,3205.97,5.45323,0,0,0,0,100), +(@PATH,2,-2829.24,3218.81,9.59048,0,0,0,0,100), +(@PATH,3,-2814.12,3235.72,10.1736,0,0,0,0,100), +(@PATH,4,-2792.54,3259.91,5.91885,0,0,0,0,100), +(@PATH,5,-2774.46,3280.17,2.8828,0,0,0,0,100), +(@PATH,6,-2751.21,3306.24,0.199384,0,0,0,0,100), +(@PATH,7,-2728.55,3318.21,-0.833018,0,0,0,0,100), +(@PATH,8,-2719.59,3331.35,-1.04936,0,0,0,0,100), +(@PATH,9,-2708.94,3349.74,-0.819842,0,0,0,0,100), +(@PATH,10,-2694.72,3374.29,-0.156626,0,0,0,0,100), +(@PATH,11,-2685.08,3390.93,0.328583,0,0,0,0,100), +(@PATH,12,-2675.69,3407.16,0.474826,0,0,0,0,100), +(@PATH,13,-2669.68,3416.29,0.743526,0,0,0,0,100), +(@PATH,14,-2660.96,3425.20,0.805554,0,0,0,0,100), +(@PATH,15,-2654.25,3430.82,0.77502,0,0,0,0,100), +(@PATH,16,-2645.46,3437.83,1.28666,0,0,0,0,100), +(@PATH,17,-2639.59,3442.50,3.25542,0,0,0,0,100), +(@PATH,18,-2630.71,3449.41,1.86245,0,0,0,0,100), +(@PATH,19,-2621.54,3456.21,0.653284,0,0,0,0,100), +(@PATH,20,-2617.41,3460.51,0.593326,0,0,0,0,100), +(@PATH,21,-2611.50,3471.52,0.520041,0,0,0,0,100), +(@PATH,22,-2610.04,3475.69,0.53993,0,0,0,0,100), +(@PATH,23,-2606.90,3480.85,0.492544,0,0,0,0,100), +(@PATH,24,-2590.41,3502.84,0.225892,0,0,0,0,100), +(@PATH,25,-2582.03,3512.00,0.101641,0,0,0,0,100), +(@PATH,26,-2566.36,3522.06,0.189451,0,0,0,0,100), +(@PATH,27,-2534.38,3523.07,1.3404,0,0,0,0,100), +(@PATH,28,-2523.33,3527.83,1.66667,0,0,0,0,100), +(@PATH,29,-2516.31,3533.95,1.65006,0,0,0,0,100), +(@PATH,30,-2507.47,3544.67,1.56155,0,0,0,0,100), +(@PATH,31,-2491.83,3549.68,1.43199,0,0,0,0,100), +(@PATH,32,-2471.56,3551.98,1.23732,0,0,0,0,100), +(@PATH,33,-2463.14,3555.66,1.03546,0,0,0,0,100), +(@PATH,34,-2456.30,3555.25,0.942503,0,0,0,0,100), +(@PATH,35,-2452.53,3537.02,0.402467,0,0,0,0,100), +(@PATH,36,-2446.32,3528.59,-0.236494,0,0,0,0,100), +(@PATH,37,-2462.93,3549.41,1.08819,0,0,0,0,100), +(@PATH,38,-2460.92,3557.50,1.00403,0,0,0,0,100), +(@PATH,39,-2425.49,3596.20,0.274173,0,0,0,0,100), +(@PATH,40,-2405.20,3613.88,0.217946,0,0,0,0,100), +(@PATH,41,-2391.31,3632.83,0.792431,0,0,0,0,100), +(@PATH,42,-2383.97,3658.54,0.99065,0,0,0,0,100), +(@PATH,43,-2351.54,3700.72,0.420721,0,0,0,0,100), +(@PATH,44,-2314.59,3729.83,0.0297019,0,0,0,0,100), +(@PATH,45,-2296.57,3749.89,0.363868,0,0,0,0,100), +(@PATH,46,-2285.44,3767.70,0.291327,0,0,0,0,100), +(@PATH,47,-2279.30,3787.95,0.314858,0,0,0,0,100), +(@PATH,48,-2276.30,3799.32,0.521091,0,0,0,0,100), +(@PATH,49,-2254.61,3831.13,2.70024,0,0,0,0,100), +(@PATH,50,-2251.75,3848.92,5.15061,0,0,0,0,100), +(@PATH,51,-2249.52,3869.55,2.39354,0,0,0,0,100), +(@PATH,52,-2244.66,3893.46,1.58335,0,0,0,0,100), +(@PATH,53,-2239.88,3904.19,1.10899,0,0,0,0,100), +(@PATH,54,-2224.28,3927.45,0.706091,0,0,0,0,100), +(@PATH,55,-2187.45,3958.22,0.921813,0,0,0,0,100), +(@PATH,56,-2175.09,3978.98,0.929392,0,0,0,0,100), +(@PATH,57,-2171.14,4011.04,0.450247,0,0,0,0,100), +(@PATH,58,-2175.93,4027.88,0.519539,0,0,0,0,100), +(@PATH,59,-2187.96,4064.43,1.42810,0,0,0,0,100), +(@PATH,60,-2166.44,4102.49,4.27243,0,0,0,0,100), -- Had guid as action_id +(@PATH,61,-1700.15,3993.57,55.6859,0,0,0,0,100), +(@PATH,62,-1710.59,4034.97,60.6101,0,0,0,0,100), +(@PATH,63,-1719.95,4059.83,62.7452,0,0,0,0,100), +(@PATH,64,-1718.67,4104.32,64.3796,0,0,0,0,100), +(@PATH,65,-1743.77,4151.60,62.3929,0,0,0,0,100), +(@PATH,66,-1754.61,4173.29,58.3691,0,0,0,0,100), +(@PATH,67,-1788.41,4206.51,44.1839,0,0,0,0,100), +(@PATH,68,-1818.93,4214.12,33.1137,0,0,0,0,100), +(@PATH,69,-1841.51,4228.10,22.0741,0,0,0,0,100), +(@PATH,70,-1871.54,4263.50,8.22153,0,0,0,0,100), +(@PATH,71,-1891.00,4295.91,3.23019,0,0,0,0,100), +(@PATH,72,-1911.96,4351.49,1.66825,0,0,0,0,100), +(@PATH,73,-1910.12,4389.42,1.77078,0,0,0,0,100), +(@PATH,74,-1907.67,4417.31,2.99456,0,0,0,0,100), +(@PATH,75,-1917.63,4452.07,6.27493,0,0,0,0,100), +(@PATH,76,-1929.40,4473.47,8.90937,0,0,0,0,100), +(@PATH,77,-1942.74,4489.67,11.1029,0,0,0,0,100), +(@PATH,78,-1958.47,4508.45,12.7432,0,0,0,0,100), +(@PATH,79,-1975.36,4519.94,13.1616,0,0,0,0,100), +(@PATH,80,-1982.19,4524.49,13.0993,0,0,0,0,100), +(@PATH,81,-1983.38,4507.03,12.7591,0,0,0,0,100), +(@PATH,82,-1984.02,4496.55,11.9535,0,0,0,0,100), +(@PATH,83,-1984.87,4482.57,11.1499,0,0,0,0,100), +(@PATH,84,-1978.92,4509.87,12.6695,0,0,0,0,100), +(@PATH,85,-1978.12,4527.35,13.36,0,0,0,0,100), +(@PATH,86,-1967.33,4546.79,12.8741,0,0,0,0,100), +(@PATH,87,-1953.04,4566.47,10.1123,0,0,0,0,100), +(@PATH,88,-1946.50,4582.91,7.44598,0,0,0,0,100), +(@PATH,89,-1948.30,4599.58,4.61956,0,0,0,0,100), +(@PATH,90,-1955.08,4637.48,-0.0588505,0,0,0,0,100), +(@PATH,91,-1943.63,4685.04,-2.18987,0,0,0,0,100), +(@PATH,92,-1941.99,4705.25,-2.67768,0,0,0,0,100), +(@PATH,93,-1945.22,4727.47,-3.22917,0,0,0,0,100), +(@PATH,94,-1951.89,4748.79,-2.9388,0,0,0,0,100), +(@PATH,95,-1957.77,4773.70,-1.42409,0,0,0,0,100), +(@PATH,96,-1957.36,4798.11,-0.0807409,0,0,0,0,100), +(@PATH,97,-1944.66,4829.17,0.67,0,0,0,0,100), +(@PATH,98,-1929.68,4851.09,1.64973,0,0,0,0,100), +(@PATH,99,-1918.23,4883.89,2.11937,0,0,0,0,100), +(@PATH,100,-1901.18,4906.49,-1.12705,0,0,0,0,100), +(@PATH,101,-1881.87,4926.69,-9.60835,0,0,0,0,100), +(@PATH,102,-1870.05,4946.21,-17.0149,0,0,0,0,100), +(@PATH,103,-1866.49,4960.25,-20.2899,0,0,0,0,100), +(@PATH,104,-1860.94,5033.3,-26.0991,0,0,0,0,100), +(@PATH,105,-1869.80,4962.46,-20.3781,0,0,0,0,100), +(@PATH,106,-1884.86,4924.67,-8.30171,0,0,0,0,100), +(@PATH,107,-1904.83,4905.16,-0.202733,0,0,0,0,100), +(@PATH,108,-1922.67,4912.5,6.06643,0,0,0,0,100), +(@PATH,109,-1937.46,4934.99,14.8054,0,0,0,0,100), +(@PATH,110,-1953.22,4961.69,24.7149,0,0,0,0,100), +(@PATH,111,-1958.07,4992.99,30.1767,0,0,0,0,100), +(@PATH,112,-1958.74,5013.42,32.4293,0,0,0,0,100), +(@PATH,113,-1947.03,5042.52,25.2899,0,0,0,0,100), +(@PATH,114,-1942.58,5058.03,19.5292,0,0,0,0,100), +(@PATH,115,-1963.32,5083.08,11.1075,0,0,0,0,100), +(@PATH,116,-1984.50,5100.08,7.82778,0,0,0,0,100), +(@PATH,117,-2004.59,5114.07,8.26657,0,0,0,0,100), +(@PATH,118,-2029.48,5123.26,8.48839,0,0,0,0,100), +(@PATH,119,-2055.94,5125.38,7.48301,0,0,0,0,100), +(@PATH,120,-2089.33,5115.44,3.14184,0,0,0,0,100), +(@PATH,121,-2112.53,5107.32,-2.40737,0,0,0,0,100), +(@PATH,122,-2137.40,5108.51,-11.5709,0,0,0,0,100), +(@PATH,123,-2155.69,5115.97,-18.1534,0,0,0,0,100), +(@PATH,124,-2170.60,5125.13,-21.2824,0,0,0,0,100), +(@PATH,125,-2182.81,5131.87,-21.667,0,0,0,0,100), +(@PATH,126,-2198.88,5138.77,-21.2323,0,0,0,0,100), +(@PATH,127,-2219.62,5144.57,-19.6848,0,0,0,0,100), +(@PATH,128,-2238.57,5146.29,-17.4706,0,0,0,0,100), +(@PATH,129,-2266.45,5144.26,-13.0598,0,0,0,0,100), +(@PATH,130,-2290.86,5142.23,-9.17377,0,0,0,0,100), +(@PATH,131,-2308.35,5142.09,-7.11532,0,0,0,0,100), +(@PATH,132,-2333.72,5149.44,-5.0165,0,0,0,0,100), +(@PATH,133,-2365.45,5157.88,-2.8501,0,0,0,0,100), +(@PATH,134,-2390.26,5158.22,-1.19618,0,0,0,0,100), +(@PATH,135,-2417.84,5153.35,0.775549,0,0,0,0,100), +(@PATH,136,-2442.28,5142.04,3.53141,0,0,0,0,100), +(@PATH,137,-2469.81,5120.56,6.76948,0,0,0,0,100), +(@PATH,138,-2498.06,5115.06,7.87731,0,0,0,0,100), +(@PATH,139,-2532.85,5118.89,7.54034,0,0,0,0,100), +(@PATH,140,-2555.60,5120.59,7.69492,0,0,0,0,100), -- GUID+1 as action_id +(@PATH,141,-2843.86,3205.97,5.45323,0,0,0,0,100); +-- Assign Path +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES +(@GUID,@PATH); diff --git a/sql/updates/world/2013_03_04_02_world_quest_template.sql b/sql/updates/world/2013_03_04_02_world_quest_template.sql new file mode 100644 index 00000000000..82f01a39a85 --- /dev/null +++ b/sql/updates/world/2013_03_04_02_world_quest_template.sql @@ -0,0 +1,2 @@ +UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=8345; +UPDATE `quest_template` SET `NextQuestId`=0 WHERE `Id`=8330; diff --git a/sql/updates/world/2013_03_04_03_world_sai.sql b/sql/updates/world/2013_03_04_03_world_sai.sql new file mode 100644 index 00000000000..6cb234cc805 --- /dev/null +++ b/sql/updates/world/2013_03_04_03_world_sai.sql @@ -0,0 +1,77 @@ +-- The Admiral Revealed (12852) - http://www.wowhead.com/quest=12852 +-- http://www.youtube.com/watch?v=I9doc1BVmA8 +SET @WHIRLWIND := 49807; -- Admiral's Whirlwind, AoE, used in phase 1 +SET @STRIKE := 57846; -- Admiral's Heroic Strike, cast on tank, used in phase 1 +SET @CLEAVE := 15284; -- Admiral's Cleave, cast in cone, used in phase 1 +SET @TOUCH := 60501; -- Selfcast on Mal'Ganis, heals him, used in phase 2 +SET @SLEEP := 53045; -- Mal'Ganis Sleep,Cast on random group member, used in phase 2 +SET @BLAST := 60500; -- Mal'Ganis Mind Blast, Cast on random group member, used in phase 2 +SET @CARRION := 60502; -- Mal'Ganis Carrion Swarm, Cast in cone, used in phase 2 +SET @SHIELD := 50161; -- Cast when Admiral on 50 % +SET @ITEMSPELL := 31699; -- Spell to disable shield +SET @ADMIRAL := 29621; -- Grand Admiral Westwind +SET @MALGANIS := 29620; -- Dreadlord Mal'Ganis +SET @PORTAL := 27731; -- Portal visual +SET @LEGION_TELEPORT := 35502; -- Mal'Ganis Legion Portal visual +SET @CREDIT_BUNNY := 29627; -- Cute little flaming bunny +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (@CREDIT_BUNNY); +DELETE FROM `smart_scripts` WHERE `entryorguid`=@CREDIT_BUNNY 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 +(@CREDIT_BUNNY, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 75, @PORTAL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Credit Bunny - Just Summoned - Cast Portal'); +-- SAI for Grand Admiral Westwind +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (@ADMIRAL,@MALGANIS,@ADMIRAL*100); +DELETE FROM `smart_scripts` WHERE `entryorguid`IN (@ADMIRAL,@ADMIRAL*100) AND `source_type` IN (0,9); +DELETE FROM `smart_scripts` WHERE `entryorguid`=@MALGANIS 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 +(@ADMIRAL, 0, 0, 1, 4, 0, 100, 0, 0, 0, 0, 0, 42, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On aggro - Set invicibility at 1 HP'), +(@ADMIRAL, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Link - Say line 0'), +(@ADMIRAL, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Link - Set phase 1'), +(@ADMIRAL, 0, 3, 4, 2, 0, 100, 1, 0, 50, 0, 0, 11, @SHIELD, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - At 50% HP - Cast Protection Sphere'), +(@ADMIRAL, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - Link - Say line 1'), +(@ADMIRAL, 0, 5, 6, 8, 0, 100, 0, @ITEMSPELL, 0, 0, 0, 28, @SHIELD, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On spell hit - Remove aura'), +(@ADMIRAL, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - Link - Say line 2'), +(@ADMIRAL, 0, 7, 8, 2, 0, 100, 1, 0, 30, 0, 0, 3, @MALGANIS, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - At 30% HP - Morph to Dreadlord Mal''Ganis'), +(@ADMIRAL, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 22, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Link - Set phase 2'), +(@ADMIRAL, 0, 9,10, 61, 0, 100, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - Link - Say line 3'), +(@ADMIRAL, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 40, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Grand Admiral Westwind - Link - Sheath'), +(@ADMIRAL, 0, 11, 0, 2, 0, 100, 1, 0, 15, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - At 15% HP - Say line 4'), +(@ADMIRAL, 0, 12, 0, 1, 0, 100, 0, 0, 0, 0, 0, 3, @ADMIRAL, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On evade - Restore model'), +(@ADMIRAL, 0, 13, 14, 2, 0, 100, 1, 1, 1, 0, 0, 18, 33554434, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On 1 hp - Set unit_flags'), +(@ADMIRAL, 0, 14, 15, 61, 0, 100, 1, 0, 0, 0, 0, 12, @CREDIT_BUNNY, 1, 19000, 0, 0, 0, 8, 0, 0, 0, 7494.893066, 4871.533203, -12.655286, 1.376, 'Grand Admiral Westwind - On Link - Summon Npc'), +(@ADMIRAL, 0, 15, 16, 61, 0, 100, 1, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Link - Stop Combat/Attack Attack State'), +(@ADMIRAL, 0, 16, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, @ADMIRAL*100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Link - Start timed script'), +(@ADMIRAL*100, 9, 0, 0, 0, 0, 100, 0, 1500, 1500, 0, 0, 22, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On script - Set phase 3'), +(@ADMIRAL*100, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 69, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 7494.788, 4872.567, -12.72154, 0, 'Grand Admiral Westwind - On Script - Move to Pos'), +(@ADMIRAL*100, 9, 2, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Script - Say line 6'), +(@ADMIRAL*100, 9, 3, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 11, @LEGION_TELEPORT, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Script - Cast spell on self'), +(@ADMIRAL*100, 9, 4, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 33, @CREDIT_BUNNY, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Script - Give quest credit'), +(@ADMIRAL*100, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 41, 3500, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Script - Despawn'), +(@ADMIRAL, 0, 17, 0, 11, 0, 100, 0, 0, 0, 0, 0, 19, 33554434, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Respawn - Unset unit_flags'), +(@ADMIRAL, 0, 18, 0, 0, 1, 100, 0, 15000, 16000, 16000, 16000, 11, @WHIRLWIND, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 1 - Cast Whirlwind'), +(@ADMIRAL, 0, 19, 0, 0, 1, 100, 0, 6000, 7000, 6000, 7000, 11, @STRIKE, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 1 - Cast Heroic Strike'), +(@ADMIRAL, 0, 20, 0, 0, 2, 100, 0, 15000, 16000, 15000, 16000, 11, @SLEEP, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 2 - Cast Sleep'), +(@ADMIRAL, 0, 21, 0, 0, 2, 100, 0, 6000, 7000, 6000, 7000, 11, @TOUCH, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 2- Cast Vampiric Touch'), +(@ADMIRAL, 0, 22, 0, 0, 1, 100, 0, 13000, 13500, 13000, 13500, 11, @CLEAVE, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 1 - Cast Cleave'), +(@ADMIRAL, 0, 23, 0, 0, 2, 100, 0, 8000, 9000, 8000, 9000, 11, @CARRION, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 2 - Cast Carrion Swarm'), +(@ADMIRAL, 0, 24, 0, 0, 2, 100, 0, 18000, 19000, 18000, 19000, 11, @BLAST, 1, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - In combat Phase 2 - Cast Mind Blast'), +(@ADMIRAL, 0, 25, 0, 25, 0, 100, 0, 0, 0, 0, 0, 20, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Grand Admiral Westwind - On Reset - Allow Attack State'); +/* +Sound ID's +14429 Final speech - When he uses portal +14428 2% HP - When he becomes immune +14427 15 % - When he rages +14426 30% HP - When he morphs +14207 Sphere removed - When Item spell is used on him +14205 Sphere cast - When he casts sphere on self +14201 Beginning of combat - When he aggros +*/ +-- Sniffed text with sounds +DELETE FROM `creature_text` WHERE `entry` IN (@ADMIRAL,@MALGANIS); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@ADMIRAL,0,0, 'How did you find me? Did Landgren tell?',12,0,100,0,0,14201, 'Grand Admiral Westwind'), +(@ADMIRAL,1,0, 'You thought I would just let you kill me?',12,0,100,0,0,14205, 'Grand Admiral Westwind'), +(@ADMIRAL,2,0, 'WHAT?! No matter. Even without my sphere, I will crush you! Behold my true identity and despair!',14,0,100,0,0,14207, 'Grand Admiral Westwind'), +(@ADMIRAL,3,0, 'Gah! I spent too much time in that weak little shell.',14,0,100,0,0,14426, 'Grand Admiral Westwind'), +(@ADMIRAL,4,0, 'Kirel narak! I am Mal''Ganis. I AM ETERNAL!',14,0,100,0,0,14427, 'Grand Admiral Westwind'), +(@ADMIRAL,5,0, 'ENOUGH! I waste my time here. I must gather my strength on the homeworld.',14,0,100,0,0,14428, 'Grand Admiral Westwind'), +(@ADMIRAL,6,0, 'You''ll never defeat the Lich King without my forces. I''ll have my revenge... on him AND you!',14,0,100,0,0,14429, 'Grand Admiral Westwind'); diff --git a/sql/updates/world/2013_03_04_04_world_player_factionchange_quests.sql b/sql/updates/world/2013_03_04_04_world_player_factionchange_quests.sql new file mode 100644 index 00000000000..163383cf0a5 --- /dev/null +++ b/sql/updates/world/2013_03_04_04_world_player_factionchange_quests.sql @@ -0,0 +1,11 @@ +-- ---------------------------- +-- Table structure for `player_factionchange_quests` +-- ---------------------------- +DROP TABLE IF EXISTS `player_factionchange_quests`; +CREATE TABLE `player_factionchange_quests` ( + `alliance_id` int(10) unsigned NOT NULL, + `horde_id` int(10) unsigned NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`), + UNIQUE INDEX `alliance_uniq` (`alliance_id`), + UNIQUE INDEX `horde_uniq` (`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/world/2013_03_04_05_world_player_factionchange_quests.sql b/sql/updates/world/2013_03_04_05_world_player_factionchange_quests.sql new file mode 100644 index 00000000000..cd08b4cbcc9 --- /dev/null +++ b/sql/updates/world/2013_03_04_05_world_player_factionchange_quests.sql @@ -0,0 +1,252 @@ +DELETE FROM `player_factionchange_quests` WHERE `alliance_id` IN (9524, 8114, 7168, 7169, 7170, 7171, 7172, 8115, 8311, 8960, 8860, 8997, 9520, 9522, 9587, 9869, 9933, 9938, 9940, 9982, 9994, 9996, 10005, 10014, 10033, 10035, 10038, 10040, 10042, 10048, 10051, 10053, 10054, 10055, 10056, 10057, 10076, 10078, 10080, 10083, 10084, 10115, 10116, 10140, 10141, 10122, 10142, 10126, 10145, 10128, 10146, 10130, 10131, 10147, 10148, 10137, 10138, 10139, 10163, 10394, 10397, 10395, 10443, 10444, 10476, 10562, 10563, 10564, 10572, 10582, 10583, 10585, 10586, 10589, 10606, 10612, 10621, 10626, 10662, 10680, 10744, 10772, 10773, 10754, 10762, 10763, 10764, 10759, 10774, 10766, 10775, 10776, 10863, 10869, 10962, 11002, 11117, 11122, 11123, 11150, 11185, 11242, 11302, 11346, 11348, 11349, 11355, 11358, 11359, 11321, 11131, 12135, 11400, 11486, 11502, 11657, 11713, 11704, 11731, 11882, 11921, 11924, 11986, 11993, 12022, 12105, 12129, 12130, 12131, 12133, 12138, 12142, 12143, 12146, 12153, 12161, 12183, 12184, 12185, 12219, 12220, 12222, 12223, 12246, 12247, 12249, 12248, 12250, 12255, 12278, 12464, 12323, 12416, 12417, 12418, 12460, 12479, 12491, 12854, 12858, 12860, 12862, 12870, 12872, 12885, 13186, 13222, 13188, 13226, 13395, 13387, 13388, 13389, 13390, 13391, 13392, 13284, 13393, 13394, 13332, 13334, 13309, 13337, 13338, 13339, 13335, 13336, 13341, 13396, 13397, 13398, 13399, 13400, 13401, 13402, 13403, 13380, 13381, 13382, 13383, 13408, 13410, 13415, 13418, 13480, 13484, 13633, 13625, 13671, 13672, 13679, 13686, 13828, 13835, 13837, 14022, 14023, 14024, 14028, 14030, 14033, 14035, 14048, 14051, 14053, 14054, 14055, 14096, 14111, 20438, 20439, 24498, 24499, 24500, 24510, 24535, 24656, 24657, 24683, 24710, 24711, 24655, 24804, 24848, 25055, 25180, 25253, 25282, 25290, 25414); +INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES +(9524, 9525), +(8114, 8121), +(7168, 7163), +(7169, 7164), +(7170, 7165), +(7171, 7166), +(7172, 7167), +(8115, 8122), +(8311, 8312), +(8960, 9032), +(8860, 8861), +(8997, 8998), +(9520, 9535), +(9522, 9536), +(9587, 9588), +(9869, 9870), +(9933, 9934), +(9938, 9937), +(9940, 9939), +(9982, 9983), +(9994, 9995), +(9996, 9997), +(10005, 10006), +(10014, 10015), +(10033, 10034), +(10035, 10036), +(10038, 10039), +(10040, 10041), +(10042, 10043), +(10048, 10049), +(10051, 10052), +(10053, 10059), +(10054, 10060), +(10055, 10086), +(10056, 10158), +(10057, 10062), +(10076, 10074), +(10078, 10087), +(10080, 10089), +(10083, 10090), +(10084, 10092), +(10115, 10118), +(10116, 10117), +(10140, 10120), +(10141, 10121), +(10122, 10150), +(10142, 10123), +(10126, 10151), +(10145, 10127), +(10128, 10153), +(10146, 10129), +(10130, 10152), +(10131, 10154), +(10147, 10133), +(10148, 10135), +(10137, 10155), +(10138, 10156), +(10139, 10157), +(10163, 10162), +(10394, 10390), +(10397, 10392), +(10395, 10393), +(10443, 10442), +(10444, 10448), +(10476, 10479), +(10562, 10595), +(10563, 10596), +(10564, 10598), +(10572, 10597), +(10582, 10600), +(10583, 10601), +(10585, 10602), +(10586, 10603), +(10589, 10604), +(10606, 10611), +(10612, 10613), +(10621, 10623), +(10626, 10627), +(10662, 10663), +(10680, 10681), +(10744, 10745), +(10772, 10750), +(10773, 10751), +(10754, 10755), +(10762, 10756), +(10763, 10757), +(10764, 10758), +(10759, 10761), +(10774, 10765), +(10766, 10767), +(10775, 10768), +(10776, 10769), +(10863, 10862), +(10869, 10868), +(10962, 10963), +(11002, 11003), +(11117, 11431), +(11122, 11412), +(11123, 11124), +(11150, 11205), +(11185, 11186), +(11242, 11403), +(11302, 11312), +(11346, 11350), +(11348, 11352), +(11349, 11351), +(11355, 11365), +(11358, 11366), +(11359, 11367), +(11321, 11413), +(11131, 11219), +(12135, 12139), +(11400, 11419), +(11486, 11487), +(11502, 11503), +(11657, 11923), +(11713, 11684), +(11704, 11702), +(11731, 11922), +(11882, 11915), +(11921, 11926), +(11924, 11925), +(11986, 12026), +(11993, 12058), +(12022, 12191), +(12105, 12423), +(12129, 12165), +(12130, 12196), +(12131, 12197), +(12133, 12155), +(12138, 12198), +(12142, 12144), +(12143, 12145), +(12146, 12147), +(12153, 12199), +(12161, 12425), +(12183, 12201), +(12184, 12202), +(12185, 12203), +(12219, 12207), +(12220, 12213), +(12222, 12256), +(12223, 12257), +(12246, 12229), +(12247, 12231), +(12249, 12236), +(12248, 12241), +(12250, 12242), +(12255, 12259), +(12278, 12306), +(12464, 12285), +(12323, 12324), +(12416, 12448), +(12417, 12449), +(12418, 12450), +(12460, 12461), +(12479, 12480), +(12491, 12492), +(12854, 12895), +(12858, 12926), +(12860, 12927), +(12862, 13060), +(12870, 12882), +(12872, 12928), +(12885, 12929), +(13186, 13185), +(13222, 13223), +(13188, 13189), +(13226, 13227), +(13395, 13236), +(13387, 13259), +(13388, 13262), +(13389, 13263), +(13390, 13271), +(13391, 13275), +(13392, 13282), +(13284, 13301), +(13393, 13304), +(13394, 13305), +(13332, 13306), +(13334, 13307), +(13309, 13310), +(13337, 13312), +(13338, 13316), +(13339, 13328), +(13335, 13329), +(13336, 13330), +(13341, 13340), +(13396, 13348), +(13397, 13349), +(13398, 13359), +(13399, 13360), +(13400, 13361), +(13401, 13362), +(13402, 13363), +(13403, 13364), +(13380, 13373), +(13381, 13374), +(13382, 13376), +(13383, 13379), +(13408, 13409), +(13410, 13411), +(13415, 13416), +(13418, 13419), +(13480, 13479), +(13484, 13483), +(13633, 13634), +(13625, 13677), +(13671, 13676), +(13672, 13678), +(13679, 13680), +(13686, 13687), +(13828, 13829), +(13835, 13838), +(13837, 13839), +(14022, 14036), +(14023, 14037), +(14024, 14040), +(14028, 14041), +(14030, 14044), +(14033, 14043), +(14035, 14047), +(14048, 14061), +(14051, 14062), +(14053, 14059), +(14054, 14060), +(14055, 14058), +(14096, 14142), +(14111, 14100), +(20438, 24556), +(20439, 24451), +(24498, 24507), +(24499, 24511), +(24500, 24802), +(24510, 24506), +(24535, 24563), +(24656, 24541), +(24657, 24576), +(24683, 24682), +(24710, 24712), +(24711, 24713), +(24655, 24536), +(24804, 24805), +(24848, 24850), +(25055, 25092), +(25180, 25181), +(25253, 25228), +(25282, 25254), +(25290, 25288), +(25414, 25293); |