diff options
Diffstat (limited to 'sql')
9 files changed, 73 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_06_00_world_creature_template_addon.sql b/sql/updates/world/2012_01_06_00_world_creature_template_addon.sql new file mode 100644 index 00000000000..0ebc498ac03 --- /dev/null +++ b/sql/updates/world/2012_01_06_00_world_creature_template_addon.sql @@ -0,0 +1,4 @@ +-- Give Sai'kkal Invisibility aura to Sai'kkal +DELETE FROM `creature_template_addon` WHERE `entry`=22932; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(22932,0,0,0,0,'39680'); diff --git a/sql/updates/world/2012_01_06_11_world_sai.sql b/sql/updates/world/2012_01_06_11_world_sai.sql new file mode 100644 index 00000000000..c785030b93e --- /dev/null +++ b/sql/updates/world/2012_01_06_11_world_sai.sql @@ -0,0 +1,14 @@ +-- Quest "Torgos!" 10035 (A) - 10036 (H) +-- Converted to SAI +SET @TRACHELA := 21515; +SET @TORGOS := 18707; +DELETE FROM `creature` WHERE `id`=@TORGOS; -- Torgos must to appear only by quest +UPDATE `creature_template` SET `unit_flags`=`unit_flags`&~256 WHERE `entry`=@TORGOS; -- removing OOC +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@TORGOS,@TRACHELA); +DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (@TORGOS,@TRACHELA); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@TORGOS,@TRACHELA); +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 +(@TRACHELA,0,0,0,0,0,100,0,5000,8000,10000,14000,11,32903,1,0,0,0,0,5,0,0,0,0,0,0,0, 'Trachela - On combat - Cast Fevered Disease'), +(@TORGOS,0,0,0,0,0,100,0,2000,5000,12000,20000,11,32022,1,0,0,0,0,2,0,0,0,0,0,0,0, 'Torgos - On combat - Cast Gut Rip'), +(@TORGOS,0,1,0,0,0,100,0,8000,10000,20000,25000,11,13579,1,0,0,0,0,3,0,0,0,0,0,0,0, 'Torgos - On combat - Cast Gouge'), +(@TORGOS,0,2,0,0,0,100,0,5000,8000,10000,14000,11,32903,1,0,0,0,0,5,0,0,0,0,0,0,0, 'Torgos - On combat - Cast Fevered Disease'); diff --git a/sql/updates/world/2012_01_06_12_world_sai.sql b/sql/updates/world/2012_01_06_12_world_sai.sql new file mode 100644 index 00000000000..b9c1319347d --- /dev/null +++ b/sql/updates/world/2012_01_06_12_world_sai.sql @@ -0,0 +1,2 @@ +UPDATE smart_scripts SET action_param2 = action_param3 WHERE action_type = 80; +UPDATE smart_scripts SET action_param3 = 0 WHERE action_type = 80;
\ No newline at end of file diff --git a/sql/updates/world/2012_01_07_00_world_creature_addon.sql b/sql/updates/world/2012_01_07_00_world_creature_addon.sql new file mode 100644 index 00000000000..83e1efbac80 --- /dev/null +++ b/sql/updates/world/2012_01_07_00_world_creature_addon.sql @@ -0,0 +1,2 @@ +-- A-Me 01 and Un'Goro Thunderer (only one) were emoting to be dead +UPDATE `creature_addon` SET `bytes1`=0 WHERE `guid` IN (24268,24081); diff --git a/sql/updates/world/2012_01_07_01_world_creature_template.sql b/sql/updates/world/2012_01_07_01_world_creature_template.sql new file mode 100644 index 00000000000..deba1c596f0 --- /dev/null +++ b/sql/updates/world/2012_01_07_01_world_creature_template.sql @@ -0,0 +1,8 @@ +-- Template updates for creature 36595 (Unleashed Soul) +UPDATE `creature_template` SET `exp`=2,`minlevel`=80,`maxlevel`=80,`baseattacktime`=2000,`speed_walk`=1.111112,`speed_run`=0.71429 WHERE `entry`=36595; -- Unleashed Soul +-- Model data 14594 (creature 36595 (Unleashed Soul)) +UPDATE `creature_model_info` SET `bounding_radius`=1.1,`combat_reach`=1.65,`gender`=2 WHERE `modelid`=14594; -- Unleashed Soul +-- Addon data for creature 36595 (Unleashed Soul) +DELETE FROM `creature_template_addon` WHERE `entry`=36595; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(36595,0,0,1,0, NULL); -- Unleashed Soul diff --git a/sql/updates/world/2012_01_07_02_world_gameobject_template.sql b/sql/updates/world/2012_01_07_02_world_gameobject_template.sql new file mode 100644 index 00000000000..438a49d969a --- /dev/null +++ b/sql/updates/world/2012_01_07_02_world_gameobject_template.sql @@ -0,0 +1,2 @@ +-- Fix Stratholme Service Gate Entrance +UPDATE `gameobject_template` SET `data1`=879 WHERE `entry`=175368; diff --git a/sql/updates/world/2012_01_07_03_world_creature_template.sql b/sql/updates/world/2012_01_07_03_world_creature_template.sql new file mode 100644 index 00000000000..fdbdfc5a689 --- /dev/null +++ b/sql/updates/world/2012_01_07_03_world_creature_template.sql @@ -0,0 +1,8 @@ +-- Set standard immunities to The Nexus bosses. +UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|1|2|4|8|16|32|64|256|512|1024|2048|4096|8192|65536|131072|262144|524288|4194304|8388608|67108864|536870912 WHERE `entry` IN +(26731,30510, -- Grand Magus Telestra + 26763,30529, -- Anomalus + 26794,30532, -- Ormorok the Tree-Shaper + 26723,30540, -- Keristrasza + 26796,30398, -- Commander Stoutbeard + 26798,30397); -- Commander Kolurg diff --git a/sql/updates/world/2012_01_07_04_world_creature_loot_template.sql b/sql/updates/world/2012_01_07_04_world_creature_loot_template.sql new file mode 100644 index 00000000000..6855308ed82 --- /dev/null +++ b/sql/updates/world/2012_01_07_04_world_creature_loot_template.sql @@ -0,0 +1,29 @@ +-- Update Narain's Scrying Goggles +SET @Item := 20951; +DELETE FROM `creature_loot_template` WHERE `item`=@Item; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(11502,@Item,-100,1,0,1,1), -- Ragnaros +(11658,@Item,-100,1,0,1,1), -- Molten Giant +(11659,@Item,-100,1,0,1,1), -- Molten Destroyer +(11661,@Item,-100,1,0,1,1), -- Flamewaker +(11662,@Item,-100,1,0,1,1), -- Flamewaker Priest +(11663,@Item,-100,1,0,1,1), -- Flamewaker Healer +(11664,@Item,-100,1,0,1,1), -- Flamewaker Elite +(11665,@Item,-100,1,0,1,1), -- Lava Annihilator +(11666,@Item,-100,1,0,1,1), -- Firewalker +(11667,@Item,-100,1,0,1,1), -- Flameguard +(11669,@Item,-100,1,0,1,1), -- Flame Imp +(11673,@Item,-100,1,0,1,1), -- Ancient Core Hound +(11982,@Item,-100,1,0,1,1), -- Magmadar +(11988,@Item,-100,1,0,1,1), -- Golemagg the Incinerator +(12056,@Item,-100,1,0,1,1), -- Baron Geddon +(12057,@Item,-100,1,0,1,1), -- Garr +(12076,@Item,-100,1,0,1,1), -- Lava Elemental +(12098,@Item,-100,1,0,1,1), -- Sulfuron Harbinger +(12100,@Item,-100,1,0,1,1), -- Lava Reaver +(12101,@Item,-100,1,0,1,1), -- Lava Surger +(12118,@Item,-100,1,0,1,1), -- Lucifron +(12119,@Item,-100,1,0,1,1), -- Flamewaker Protector +(12231,@Item,-100,1,0,1,1), -- Firelord +(12259,@Item,-100,1,0,1,1), -- Gehennas +(12264,@Item,-100,1,0,1,1); -- Shazzrah diff --git a/sql/updates/world/2012_01_07_05_world_creature_loot_template.sql b/sql/updates/world/2012_01_07_05_world_creature_loot_template.sql new file mode 100644 index 00000000000..5ffdb8f6261 --- /dev/null +++ b/sql/updates/world/2012_01_07_05_world_creature_loot_template.sql @@ -0,0 +1,4 @@ +-- correct id for firelord +DELETE FROM `creature_loot_template` WHERE `entry` IN (12231,11668) AND `item`=20951; +INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(11668,20951,-100,1,0,1,1); -- Firelord |