diff options
Diffstat (limited to 'sql')
15 files changed, 139 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_24_00_world_spell_script_name.sql b/sql/updates/world/2014_01_24_00_world_spell_script_name.sql new file mode 100644 index 00000000000..51030a39a85 --- /dev/null +++ b/sql/updates/world/2014_01_24_00_world_spell_script_name.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_gen_slow_roasted_turkey', +'spell_gen_cranberry_chutney', +'spell_gen_spice_bread_stuffing', +'spell_gen_pumpkin_pie', +'spell_gen_candied_sweet_potato' +); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(65422, 'spell_gen_slow_roasted_turkey'), -- Slow-Roasted Turkey +(65420, 'spell_gen_cranberry_chutney'), -- Cranberry Chutney +(65419, 'spell_gen_spice_bread_stuffing'), -- Spice Bread Stuffing +(65421, 'spell_gen_pumpkin_pie'), -- Pumpkin Pie +(65418, 'spell_gen_candied_sweet_potato'); -- Candied Sweet Potato diff --git a/sql/updates/world/2014_01_24_01_world_sai.sql b/sql/updates/world/2014_01_24_01_world_sai.sql new file mode 100644 index 00000000000..56ecec3bafc --- /dev/null +++ b/sql/updates/world/2014_01_24_01_world_sai.sql @@ -0,0 +1,11 @@ +-- Scalewing Serpent SAI +SET @ENTRY := 20749; +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,0,0,100,0,2000,6000,12000,13000,11,37841,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Scalewing Serpent - Combat - Casts Lightning Strike'), +(@ENTRY,0,1,0,31,0,100,0,37841,0,0,0,33,21910,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Scalewing Serpent - On Spellhit - Killcredit'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=20749; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(22,2,20749,0,0,1,0,37830,0,0,0,0,0, '', 'SAI - Scalewing Serpent gives kill credit if quest item aura is applied'); diff --git a/sql/updates/world/2014_01_24_02_world_creature_template.sql b/sql/updates/world/2014_01_24_02_world_creature_template.sql new file mode 100644 index 00000000000..be8bb9d6f07 --- /dev/null +++ b/sql/updates/world/2014_01_24_02_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `gossip_menu_id` = 0 WHERE `entry` = 5634; diff --git a/sql/updates/world/2014_01_24_03_world_sai.sql b/sql/updates/world/2014_01_24_03_world_sai.sql new file mode 100644 index 00000000000..06fe58f137a --- /dev/null +++ b/sql/updates/world/2014_01_24_03_world_sai.sql @@ -0,0 +1,16 @@ +-- +UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry`=16847; +DELETE FROM `smart_scripts` WHERE `entryorguid`=16847 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 +(16847,0,0,1,8,0,100,0,29314,0,60000,60000,33,16847,0,0,0,0,0,7,0,0,0,0,0,0,0,'Debilitated Maghar Grunt - On Spellhit (Quest - Healing Salve) - Give Kill Credit'), +(16847,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,'Debilitated Maghar Grunt - Linked with Previous Event - Say'), +(16847,0,2,3,61,0,100,0,0,0,0,0,3,16846,0,0,0,0,0,1,0,0,0,0,0,0,0,'Debilitated Maghar Grunt - Linked with Previous Event - Change Entry'), +(16847,0,3,0,61,0,100,0,0,0,0,0,41,15000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Debilitated Maghar Grunt - Linked with Previous Event - Despawn'), +(16847,0,4,0,25,0,100,0,0,0,0,0,3,16847,0,0,0,0,0,1,0,0,0,0,0,0,0,'Debilitated Maghar Grunt - On Spawn - Change Entry'); + + +DELETE FROM `creature_text` WHERE `entry` =16847; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(16847,0,0,'My strength.... is... returning!',12,0,100,0,0,0,'Debilitated Maghar Grunt'), +(16847,0,1,'You''ve found a cure! We will crush our enemies!',12,0,100,0,0,0,'Debilitated Maghar Grunt'), +(16847,0,2,'You''ve restored my health! I''m in your debt, $N.',12,0,100,0,0,0,'Debilitated Maghar Grunt'); diff --git a/sql/updates/world/2014_01_24_04_world_sai.sql b/sql/updates/world/2014_01_24_04_world_sai.sql new file mode 100644 index 00000000000..6864160c2c5 --- /dev/null +++ b/sql/updates/world/2014_01_24_04_world_sai.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template` SET `AIName`= '' WHERE `entry`=23450; +DELETE FROM `smart_scripts` WHERE `entryorguid`=23450 AND `source_type`=0; +UPDATE `creature_template` SET `AIName`= '' WHERE `entry`=28674; diff --git a/sql/updates/world/2014_01_24_05_world_creature_queststarter.sql b/sql/updates/world/2014_01_24_05_world_creature_queststarter.sql new file mode 100644 index 00000000000..9b2893a859d --- /dev/null +++ b/sql/updates/world/2014_01_24_05_world_creature_queststarter.sql @@ -0,0 +1,4 @@ +-- Fixes the Dragonmaw Race: Wing Commander Ichman creature_queststarter mistake +UPDATE creature_template SET npcflag=3 WHERE entry=23345; +DELETE FROM creature_queststarter WHERE quest=11069; +INSERT INTO creature_queststarter VALUES (23345,11069); diff --git a/sql/updates/world/2014_01_24_06_world_gameobject_loot_template.sql b/sql/updates/world/2014_01_24_06_world_gameobject_loot_template.sql new file mode 100644 index 00000000000..3ca7a513409 --- /dev/null +++ b/sql/updates/world/2014_01_24_06_world_gameobject_loot_template.sql @@ -0,0 +1,3 @@ +-- +INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`) VALUES +(18111, 22795, 10); diff --git a/sql/updates/world/2014_01_24_07_world_sai.sql b/sql/updates/world/2014_01_24_07_world_sai.sql new file mode 100644 index 00000000000..c1c00091be9 --- /dev/null +++ b/sql/updates/world/2014_01_24_07_world_sai.sql @@ -0,0 +1,3 @@ +-- Fixes to Highlord Demitrian smart_scripts +UPDATE smart_scripts SET `comment`='Highlord Demitrian - On Gossip Complete - Add Item Vessel of Rebirth' WHERE entryorguid=14347 AND event_type=62; +UPDATE smart_scripts SET action_param2=6, action_param3=60000, target_type=8, target_x='-6241.771973',target_y='1717.143311',target_z='4.250421',target_o='0.680879',`comment`='Highlord Demitrian - On Quest Thunderaan the Windseeker Finished - Summon Creature Prince Thunderaan at XYZO' WHERE entryorguid=14347 AND event_type=20; diff --git a/sql/updates/world/2014_01_26_00_world_sai.sql b/sql/updates/world/2014_01_26_00_world_sai.sql new file mode 100644 index 00000000000..671b0f081ba --- /dev/null +++ b/sql/updates/world/2014_01_26_00_world_sai.sql @@ -0,0 +1,13 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=24601 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 +(24601, 0, 2, 0, 6, 0, 100, 0, 0, 0, 0, 0, 33, 25987, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Steam Rager - On Death - Kill Credit'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry` =24601; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(22,3,24601,0,0,1,1,46374,0,0,0,0,'','Windsoul Totem Credit only if aura present at death'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=46374; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13,1,46374,0,0,31,0,3,24601,0,0,0,0,'','Windsoul Totem Aura targets only Steam Rager'), +(13,1,46374,0,0,36,0,0,0,0,0,0,0,'','Windsoul Totem Aura targets only alive units'); diff --git a/sql/updates/world/2014_01_26_01_world_sai.sql b/sql/updates/world/2014_01_26_01_world_sai.sql new file mode 100644 index 00000000000..b585b4a0547 --- /dev/null +++ b/sql/updates/world/2014_01_26_01_world_sai.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=37056; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 37056, 0, 0, 31, 0, 3, 21316, 0, 0, 0, '','Kill Legion Hold Infernals Targets Deathforged Infernal'); + +UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry`=21512; +DELETE FROM `smart_scripts` WHERE `entryorguid`=21512 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 +(21512,0,0,1,8,0,100,0,37055,0,300000,300000,33,21512,0,0,0,0,0,7,0,0,0,0,0,0,0,'Invis Legion Hold Glyph - On Spellhit (Destroy Legion Hold Infernals) - Give Kill Credit'), +(21512,0,1,0,61,0,100,0,37055,0,0,0,11,37056,0,0,0,0,0,1,0,0,0,0,0,0,0,'Invis Legion Hold Glyph - Linked with Previous Event - Cast Kill Legion Hold Infernals'); diff --git a/sql/updates/world/2014_01_26_02_world_sai.sql b/sql/updates/world/2014_01_26_02_world_sai.sql new file mode 100644 index 00000000000..81d52f8e9e2 --- /dev/null +++ b/sql/updates/world/2014_01_26_02_world_sai.sql @@ -0,0 +1,12 @@ +-- +UPDATE `smart_scripts` SET `event_type`=11 WHERE `entryorguid`=9546 AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=12, `target_param1`=1 WHERE `entryorguid`=954600 AND `source_type`=9 AND `id`=2; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=164954 AND `source_type`=1; +DELETE FROM `smart_scripts` WHERE `entryorguid`=16495400 AND `source_type`=9; + +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 +(164954,1,0,1,19,0,100,0,4265,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Zukk'ash Pod - On Quest Accept - Store Target List"), +(164954,1,1,2,61,0,100,0,0,0,0,0,12,9546,1,25000,0,0,0,8,0,0,0,-5314.81,430.89,11.79,3.46,"Zukk'ash Pod - On Quest Accept - Summon Raschal the Courier"), +(164954,1,2,0,61,0,100,0,0,0,0,0,80,16495400,2,0,0,0,0,1,0,0,0,0,0,0,0,"Zukk'ash Pod - On Quest Accept - Run Script"), +(16495400,9,0,0,0,0,100,0,100,100,0,0,100,1,0,0,0,0,0,19,9546,0,0,0,0,0,0,"Zukk'ash Pod - Script - Send Target List to Raschal the Courier"); diff --git a/sql/updates/world/2014_01_26_04_world_sai.sql b/sql/updates/world/2014_01_26_04_world_sai.sql new file mode 100644 index 00000000000..0ca7e70159d --- /dev/null +++ b/sql/updates/world/2014_01_26_04_world_sai.sql @@ -0,0 +1,18 @@ +-- [11796] Emergency Protocol: Section 8.2, Paragraph D +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN(25845,25846,25847); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (25845,25846,25847); +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 +(25845, 0, 0, 0, 8, 0, 100, 0, 46171, 0, 0, 0, 33, 25845 , 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Northwest Crash - On Spellhit - Kill Credit'), +(25846, 0, 0, 0, 8, 0, 100, 0, 46171, 0, 0, 0, 33, 25846 , 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'South Crash - On Spellhit - Kill Credit'), +(25847, 0, 0, 0, 8, 0, 100, 0, 46171, 0, 0, 0, 33, 25847 , 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'East Crash - On Spellhit - Kill Credit'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=46171; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13,1,46171,0,0,31,0,3,25845,0,0,0,0,'','Scuttle Wrecked Flying Machine targets Northwest Crash'), +(13,1,46171,0,1,31,0,3,25846,0,0,0,0,'','Scuttle Wrecked Flying Machine targets South Crash'), +(13,1,46171,0,2,31,0,3,25847,0,0,0,0,'','Scuttle Wrecked Flying Machine Flare targets East Crash'); + +DELETE FROM `disables` WHERE `sourceType`=0 AND `entry`=46171; +INSERT INTO `disables` (`sourceType`, `entry`, `flags`, `params_0`, `params_1`, `comment`) VALUES +(0, 46171, 64, '', '', 'Ignore LOS on Scuttle Wrecked Flying Machine'); diff --git a/sql/updates/world/2014_01_26_05_world_sai.sql b/sql/updates/world/2014_01_26_05_world_sai.sql new file mode 100644 index 00000000000..9f4b1092532 --- /dev/null +++ b/sql/updates/world/2014_01_26_05_world_sai.sql @@ -0,0 +1,15 @@ +-- +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= 29978; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=29978; +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 +(29978, 0, 0, 0, 6, 0, 100, 0, 0, 0, 0, 0, 33, 30297, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Iron Dwarf Assailant - On Death - Give Kill credit'); + +UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= 29984; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=29984; +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 +(29984, 0, 0, 0, 6, 0, 100, 0, 0, 0, 0, 0, 33, 30296, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Iron Sentinel <Servant of Loken> - On Death - Give Kill credit'), +(29984, 0, 1, 0, 9, 0, 100, 0, 0,10, 12000, 24000, 11, 56490, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Iron Sentinel <Servant of Loken> - On Range - Cast Stomp'), +(29984, 0, 2, 0, 0, 0, 100, 0, 0, 3000, 5000, 8000, 11, 55811, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Iron Sentinel <Servant of Loken> - IC - Cast Throw Bolder'), +(29984, 0, 3, 0, 9, 0, 100, 0, 0, 5, 5000, 7000, 11, 5568, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Iron Sentinel <Servant of Loken> - IC - Cast Trample'); diff --git a/sql/updates/world/2014_01_26_06_world_spells.sql b/sql/updates/world/2014_01_26_06_world_spells.sql new file mode 100644 index 00000000000..ff00f9eddcb --- /dev/null +++ b/sql/updates/world/2014_01_26_06_world_spells.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (58387,20230,-48438); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(58387, 'spell_warr_glyph_of_sunder_armor'), +(20230, 'spell_warr_retaliation'), +(-48438,'spell_dru_wild_growth'); + +DELETE FROM `spell_proc_event` WHERE `entry`=58387; diff --git a/sql/updates/world/2014_01_26_07_world_spell_script_names.sql b/sql/updates/world/2014_01_26_07_world_spell_script_names.sql new file mode 100644 index 00000000000..b0809b98ece --- /dev/null +++ b/sql/updates/world/2014_01_26_07_world_spell_script_names.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-34861,64844,64904,54968,71610,71641); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(-34861,'spell_pri_circle_of_healing'), +(64844, 'spell_pri_divine_hymn'), +(64904, 'spell_pri_hymn_of_hope'), +(54968, 'spell_pal_glyph_of_holy_light'), +(71610, 'spell_item_echoes_of_light'), +(71641, 'spell_item_echoes_of_light'); |