diff options
| author | TDB Release <tdb-release@build.bot> | 2022-08-15 11:23:44 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2022-08-15 11:23:44 +0000 |
| commit | c04fe4974b9403f555d0d405aa4d3f4f1f02eb65 (patch) | |
| tree | 46ed8b6e9f7ef2dec21f90297b156e51bdbccea1 /sql/updates | |
| parent | 87f2180f7687ee4783468a16b2fd09d71e5f5e99 (diff) | |
TDB 335.22081 - 2022/08/15TDB335.22081
Diffstat (limited to 'sql/updates')
37 files changed, 5 insertions, 1187 deletions
diff --git a/sql/updates/auth/3.3.5/2022_06_01_00_auth.sql b/sql/updates/auth/3.3.5/2022_08_15_00_auth.sql index 7b91a8a470b..db8dd1f7ce2 100644 --- a/sql/updates/auth/3.3.5/2022_06_01_00_auth.sql +++ b/sql/updates/auth/3.3.5/2022_08_15_00_auth.sql @@ -1,2 +1,2 @@ --- TDB 335.22061 auth +-- TDB 335.22081 auth UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2022_06_01_00_characters.sql b/sql/updates/characters/3.3.5/2022_08_15_00_characters.sql index 135ad810aea..721c57af960 100644 --- a/sql/updates/characters/3.3.5/2022_06_01_00_characters.sql +++ b/sql/updates/characters/3.3.5/2022_08_15_00_characters.sql @@ -1,2 +1,2 @@ --- TDB 335.22061 characters +-- TDB 335.22081 characters UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2022_06_01_00_world.sql b/sql/updates/world/3.3.5/2022_06_01_00_world.sql deleted file mode 100644 index 30dd4165af4..00000000000 --- a/sql/updates/world/3.3.5/2022_06_01_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 335.22061 world -UPDATE `version` SET `db_version`='TDB 335.22061', `cache_id`=22061 LIMIT 1; -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2022_06_04_00_world.sql b/sql/updates/world/3.3.5/2022_06_04_00_world.sql deleted file mode 100644 index f9c0bd6ecbf..00000000000 --- a/sql/updates/world/3.3.5/2022_06_04_00_world.sql +++ /dev/null @@ -1,81 +0,0 @@ --- -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_fjord_the_way_to_his_heart_reverse_cast','spell_fjord_the_way_to_his_heart_quest_complete','spell_gen_pet_wait'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(44455,'spell_fjord_the_way_to_his_heart_reverse_cast'), -(44462,'spell_fjord_the_way_to_his_heart_quest_complete'), -(36553,'spell_gen_pet_wait'); - --- Bull -DELETE FROM `smart_scripts` WHERE `entryorguid` = 24786 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 2478600 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(24786,0,0,0,8,0,100,0,44454,0,0,0,0,80,2478600,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Bull - On Spellhit 'Tasty Reef Fish' - Run Script"), -(24786,0,1,0,1,0,100,0,30000,60000,30000,60000,0,4,3403,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Bull - Out of Combat - Play Sound 3403"), --- Call for Help? -(24786,0,2,0,4,0,100,0,0,0,0,0,0,1,0,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Reef Bull - On Aggro - Say Line 0"), - -(2478600,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Reef Bull - On Script - Set Orientation Invoker"), -(2478600,9,1,0,0,0,100,0,0,0,0,0,0,11,44455,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Reef Bull - On Script - Cast 'Character Script Effect Reverse Cast'"), -(2478600,9,2,0,0,0,100,0,1000,1000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Bull - On Script - Despawn"); - -DELETE FROM `creature_text` WHERE `CreatureID` = 24786; -INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(24786,0,0,"A Lion Seal has become alerted to your presence and begins bellowing a warning!",16,0,100,0,0,0,22437,0,"Reef Bull"); - --- Attracted Bull -UPDATE `creature_template` SET `speed_run` = 1, `unit_flags` = 32768 WHERE `entry` = 24804; -UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 24804; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 24804 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2480400,2480401,2480402) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(24804,0,0,0,11,0,100,0,0,0,0,0,0,80,2480400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Spawn - Run Script"), -(24804,0,1,0,8,0,100,0,44454,0,0,0,0,80,2480401,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Spellhit 'Tasty Reef Fish' - Run Script"), --- Interrupting previous action list here is a good idea (see comment below) but it gives a weird side-effect --- (creature despawns a bit longer than 12 sec (last action in this action list)) -(24804,0,2,0,8,0,100,0,44453,0,0,0,0,80,2480402,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Spellhit 'Reef Cow Aura' - Run Script"), - -(2480400,9,0,0,0,0,100,0,0,0,0,0,0,4,3403,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Play Sound 3403"), -(2480400,9,1,0,0,0,100,0,0,0,0,0,0,29,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Follow Owner"), --- It looks weird and unnecessary here since they can simply add timer to follow action, maybe it's not this simple --- It wasn't used last time when he got attention from a cow, was interrupted by next action list -(2480400,9,2,0,0,0,100,0,3000,3000,0,0,0,11,36553,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Cast 'PetWait'"), - -(2480401,9,0,0,0,0,100,0,0,0,0,0,0,5,35,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Play Emote 35"), -(2480401,9,1,0,0,0,100,0,0,0,0,0,0,4,3403,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Play Sound 3403"), -(2480401,9,2,0,0,0,100,0,0,0,0,0,0,29,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Follow Invoker"), -(2480401,9,3,0,0,0,100,0,3000,3000,0,0,0,11,36553,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Cast 'PetWait'"), - -(2480402,9,0,0,0,0,100,0,0,0,0,0,0,11,44462,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Cast 'Cast Quest Complete on Master'"), -(2480402,9,1,0,0,0,100,0,0,0,0,0,0,11,44460,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Cast 'True Love'"), -(2480402,9,2,0,0,0,100,0,0,0,0,0,0,4,3403,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Play Sound 3403"), -(2480402,9,3,0,0,0,100,0,0,0,0,0,0,69,0,0,0,2,0,0,7,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Move To Invoker"), -(2480402,9,4,0,0,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,7,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Set Data 0 1 (Invoker)"), -(2480402,9,5,0,0,0,100,0,12000,12000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Attracted Reef Bull - On Script - Despawn"); - --- Cow -UPDATE `creature_template_addon` SET `bytes2` = 1, `auras` = '44476' WHERE `entry` = 24797; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 24797 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 2479700 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(24797,0,0,0,1,0,100,0,30000,60000,30000,60000,0,4,3403,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Cow - Out of Combat - Play Sound 3403"), -(24797,0,1,0,38,0,100,0,0,1,0,0,0,80,2479700,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Cow - On Data Set 0 1 - Run Script"), - -(2479700,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Set Orientation Invoker"), -(2479700,9,1,0,0,0,100,0,0,0,0,0,0,11,44460,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Cast 'True Love'"), -(2479700,9,2,0,0,0,100,0,0,0,0,0,0,1,0,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Say Line 0"), -(2479700,9,3,0,0,0,100,0,0,0,0,0,0,144,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Set ImmunePC"), -(2479700,9,4,0,0,0,100,0,3000,3000,0,0,0,4,3405,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Play Sound 3405"), -(2479700,9,5,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Set Orientation Invoker"), -(2479700,9,6,0,0,0,100,0,9000,9000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Reef Cow - On Script - Despawn"); - --- 44476 (Reef Cow Periodic) is the aura always applied on cows (sniff) --- 44453 (Reef Cow Aura) apparently is the spell which periodically triggers aura above --- RangeIndex of 44453 (Self) and spell name makes it confusing a bit but we have similar spells, like 27999 + 28000 --- So we'll just copy existing combination -UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 6, `EffectImplicitTargetA1` = 1, `EffectApplyAuraName1` = 23, `EffectAmplitude1` = 2000, `EffectTriggerSpell1` = 44453 WHERE `Id` = 44476; -UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 3, `EffectImplicitTargetA1` = 22, `EffectImplicitTargetB1` = 7, `EffectRadiusIndex1` = 13 WHERE `Id` = 44453; - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 44453; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(13,1,44453,0,0,31,0,3,24804,0,0,0,0,"","Group 0: Spell 'The Way to His Heart...: Reef Cow Aura' (Effect 0) targets creature 'Attracted Reef Bull'"); diff --git a/sql/updates/world/3.3.5/2022_06_04_01_world.sql b/sql/updates/world/3.3.5/2022_06_04_01_world.sql deleted file mode 100644 index 1badc7e5b1f..00000000000 --- a/sql/updates/world/3.3.5/2022_06_04_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -DELETE FROM `smart_scripts` WHERE `entryorguid` = 1968500 AND `source_type` = 9 AND `id` = 1; diff --git a/sql/updates/world/3.3.5/2022_06_05_00_world.sql b/sql/updates/world/3.3.5/2022_06_05_00_world.sql deleted file mode 100644 index 09ca4448528..00000000000 --- a/sql/updates/world/3.3.5/2022_06_05_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `smart_scripts` SET `event_type` = 83, `comment` = "Bonesunder - On Spell Cast 'Bone Crack' - Say Line 1" WHERE `entryorguid` = 27006 AND `event_type` = 31; diff --git a/sql/updates/world/3.3.5/2022_06_05_01_world.sql b/sql/updates/world/3.3.5/2022_06_05_01_world.sql deleted file mode 100644 index 87aa484bf94..00000000000 --- a/sql/updates/world/3.3.5/2022_06_05_01_world.sql +++ /dev/null @@ -1,12 +0,0 @@ --- -DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (12429,12430)); -UPDATE `creature_addon` SET `bytes2` = `bytes2` |256 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (5484,26044)); - -UPDATE `creature_template_addon` SET `bytes2` = `bytes2` |256 WHERE `entry` IN (739,927,1182,1444,5661,8140,12423,12427,12428,12429,12430); -DELETE FROM `creature_template_addon` WHERE `entry` IN (1351,5484,5489,12336,26044); -INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES -(1351,0,0,0,0,257,0,0,''), -(5484,0,0,0,0,257,0,0,''), -(5489,0,0,0,0,257,0,0,''), -(12336,0,0,0,0,257,0,0,''), -(26044,0,0,0,0,257,0,0,''); diff --git a/sql/updates/world/3.3.5/2022_06_09_00_world.sql b/sql/updates/world/3.3.5/2022_06_09_00_world.sql deleted file mode 100644 index f358f931085..00000000000 --- a/sql/updates/world/3.3.5/2022_06_09_00_world.sql +++ /dev/null @@ -1,288 +0,0 @@ --- The Perfect Dissemblance (12260) --- Priest -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_dragonblight_cancel_banshees_magic_mirror'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(48692,'spell_dragonblight_cancel_banshees_magic_mirror'); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 27202 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (/*2720200,*/2720201) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27202,0,0,0,4,0,30,0,0,0,0,0,0,1,1,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Aggro - Say Line 1"), -(27202,0,1,0,8,0,100,1,48268,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Spellhit 'Container of Rats' - Despawn (No Repeat)"), -(27202,0,2,0,8,0,100,1,48679,0,0,0,0,80,2720201,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Spellhit 'Banshee's Magic Mirror' - Run Script (No Repeat)"), -(27202,0,3,0,0,0,100,0,0,0,3400,4800,0,11,50740,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - In Combat CMC - Cast 'Raven Flock'"), -(27202,0,4,0,2,0,100,0,0,30,14000,18000,0,11,50750,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - Between 0-30% Health - Cast 'Raven Heal'"), - -(2720201,9,0,0,0,0,100,0,0,0,0,0,0,11,48654,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Cast 'The Perfect Dissemblance: Summon Priest's Footman'"), -(2720201,9,1,0,0,0,100,0,0,0,0,0,0,11,48648,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Cast 'Banshee's Magic Mirror'"), --- Hack, 48648 above should be enough, but force-cast of that spell doesn't work always for unknown reason --- Sadly, yes, if it works, player summons two footmen instead of one -(2720201,9,2,0,0,0,100,0,0,0,0,0,0,85,48655,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Self Cast 'The Perfect Dissemblance: Summon Player's Footman & Credit Credit'"), -(2720201,9,3,0,0,0,100,0,0,0,0,0,0,1,2,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Say Line 2"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 27202 AND `SourceId` = 0; - -DELETE FROM `creature_text` WHERE `CreatureID` = 27202; -INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(27202,0,0,"I've heard whisperings of intruders. Be wary.",12,0,100,0,0,0,26254,0,"Onslaught Raven Priest"), -(27202,0,1,"I sense the taint of this land in you, footman. Report to the Bishop before the start of your next shift.",12,0,100,0,0,0,26256,0,"Onslaught Raven Priest"), -(27202,0,2,"You stink. Take a shower.",12,0,100,0,0,0,26257,0,"Onslaught Raven Priest"), -(27202,0,3,"Your protection is strong, child. Continue your work.",12,0,100,0,0,0,26390,0,"Onslaught Raven Priest"), -(27202,0,4,"You require the Bishop's blessing. Go to him soon.",12,0,100,0,0,0,26391,0,"Onslaught Raven Priest"), -(27202,0,5,"Remain on the pure path. The Light will protect you.",12,0,100,0,0,0,26392,0,"Onslaught Raven Priest"), -(27202,0,6,"The Grand Admiral himself has come to see to our dedication. If I see you slacking on your post again, I will gut you myself.",12,0,100,0,0,0,26655,0,"Onslaught Raven Priest"), - -(27202,1,0,"You are impure!",12,0,100,0,0,0,26393,0,"Onslaught Raven Priest"), -(27202,1,1,"Die, cur!",12,0,100,0,0,0,26394,0,"Onslaught Raven Priest"), -(27202,1,2,"Be washed from my sight!",12,0,100,0,0,0,26395,0,"Onslaught Raven Priest"), -(27202,1,3,"By the Light!",12,0,100,0,0,0,26396,0,"Onslaught Raven Priest"), -(27202,1,4,"Wretch!",12,0,100,0,0,0,26397,0,"Onslaught Raven Priest"), -(27202,1,5,"Defiler!",12,0,100,0,0,0,26398,0,"Onslaught Raven Priest"), -(27202,1,6,"Abbendis will see you purged!",12,0,100,0,0,0,26399,0,"Onslaught Raven Priest"), - -(27202,2,0,"HELP! HELP! THIS $g MAN : WOMAN; HAS STOLEN MY IMAGE!",12,0,100,0,0,0,26543,0,"Onslaught Raven Priest"), - -(27202,3,0,"Gah! What are you doing?",12,0,100,0,0,0,26637,0,"Onslaught Raven Priest"), -(27202,4,0,"A member of the priesthood whom I've never seen before.",12,0,100,0,0,0,26638,0,"Onslaught Raven Priest"); - --- Footmen, yes, it's intended when one attacks player and another attacks priest, they even talk about that -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27405,27406) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2740500,2740600) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27405,0,0,0,11,0,100,0,0,0,0,0,0,80,2740500,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Footman - On Spawn - Run Script"), -(27405,0,1,0,0,0,100,0,0,10000,30000,40000,0,11,50714,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Footman - In Combat - Cast 'Unrelenting Onslaught'"), - -(27406,0,0,0,11,0,100,0,0,0,0,0,0,80,2740600,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Footman - On Spawn - Run Script"), -(27406,0,1,0,0,0,100,0,0,10000,30000,40000,0,11,50714,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Footman - In Combat - Cast 'Unrelenting Onslaught'"), - -(2740500,9,0,0,0,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Onslaught Footman - On Script - Start Attack Summoner"), -(2740500,9,1,0,0,0,100,0,0,0,0,0,0,1,0,0,1,0,0,0,23,0,0,0,0,0,0,0,0,"Onslaught Footman - On Script - Say Line 0"), - -(2740600,9,0,0,0,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Onslaught Footman - On Script - Start Attack Summoner"), -(2740600,9,1,0,0,0,100,0,3000,3000,0,0,0,1,0,0,1,0,0,0,23,0,0,0,0,0,0,0,0,"Onslaught Footman - On Script - Say Line 0"); - - --- A Fall From Grace (12274) --- Disguise stuff --- Shouldn't be here, cancels disguise everytime, not a real solution but still -DELETE FROM `spell_area` WHERE `spell` = 48358 AND `area` = 4180; - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_dragonblight_scarlet_raven_priest_image_master','spell_dragonblight_cancel_scarlet_raven_priest_image'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(48762,'spell_dragonblight_scarlet_raven_priest_image_master'), -(48769,'spell_dragonblight_cancel_scarlet_raven_priest_image'); - -UPDATE `quest_template_addon` SET `SourceSpellID` = 0 WHERE `ID` = 12274; - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 27350 AND `SourceId` = 0; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 27350 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27350,0,0,0,19,0,100,0,12274,0,0,0,0,11,48774,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Agent Skully - On Quest 'A Fall From Grace' Taken - Cast 'A Fall from Grace: Quest Accept'"), -(27350,0,1,0,62,0,100,0,9501,0,0,0,0,11,48774,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Agent Skully - On Gossip Option 0 Selected - Cast 'A Fall from Grace: Quest Accept'"); - --- Bell stuff -DELETE FROM `smart_scripts` WHERE `entryorguid` = 188713 AND `source_type` = 1; -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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(188713,1,0,1,70,0,100,0,2,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Abbey Bell Rope - On State Changed - Store Targetlist"), -(188713,1,1,2,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,10,102082,27202,0,0,0,0,0,0,"Abbey Bell Rope - On State Changed - Send Target 1 (Onslaught Raven Priest)"), -(188713,1,2,3,61,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,10,100277,24110,0,0,0,0,0,0,"Abbey Bell Rope - On State Changed - Set Data 1 1 (ELM General Purpose Bunny Large)"), -(188713,1,3,4,61,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,10,102082,27202,0,0,0,0,0,0,"Abbey Bell Rope - On State Changed - Set Data 1 1 (Onslaught Raven Priest)"), -(188713,1,4,5,61,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,10,105877,27245,0,0,0,0,0,0,"Abbey Bell Rope - On State Changed - Set Data 1 1 (High Abbot Landgren)"), -(188713,1,5,0,61,0,100,0,0,0,0,0,0,45,1,1,0,0,0,0,10,106200,27247,0,0,0,0,0,0,"Abbey Bell Rope - On State Changed - Set Data 1 1 (Devout Bodyguard)"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = -100277 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 2411000 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(-100277,0,0,0,38,0,100,0,1,1,0,0,0,80,2411000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"ELM General Purpose Bunny Large - On Data Set 1 1 - Run Script"), - -(2411000,9,0,0,0,0,100,0,0,0,0,0,0,4,7256,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"ELM General Purpose Bunny Large - On Script - Play Sound 7256"), -(2411000,9,1,0,0,0,100,0,3000,3000,0,0,0,4,7256,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"ELM General Purpose Bunny Large - On Script - Play Sound 7256"), -(2411000,9,2,0,0,0,100,0,3000,3000,0,0,0,4,7256,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"ELM General Purpose Bunny Large - On Script - Play Sound 7256"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = -102082 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2720202,2720203) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(-102082,0,0,0,4,0,30,0,0,0,0,0,0,1,1,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Aggro - Say Line 1"), -(-102082,0,1,0,8,0,100,1,48268,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Spellhit 'Container of Rats' - Despawn (No Repeat)"), -(-102082,0,2,0,8,0,100,1,48679,0,0,0,0,80,2720201,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Spellhit 'Banshee's Magic Mirror' - Run Script (No Repeat)"), -(-102082,0,3,0,0,0,100,0,0,0,3400,4800,0,11,50740,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - In Combat CMC - Cast 'Raven Flock'"), -(-102082,0,4,0,2,0,100,0,0,30,14000,18000,0,11,50750,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - Between 0-30% Health - Cast 'Raven Heal'"), -(-102082,0,5,0,38,0,100,0,1,1,0,0,0,80,2720202,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Data Set 1 1 - Run Script"), -(-102082,0,6,0,38,0,100,0,1,2,0,0,0,80,2720203,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Data Set 1 2 - Run Script"), - -(2720202,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Set Orientation Stored Target 1"), -(2720202,9,1,0,0,0,100,0,0,0,0,0,0,5,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Play Emote 5"), -(2720202,9,2,0,0,0,100,0,0,0,0,0,0,1,3,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Say Line 3"), -(2720202,9,3,0,0,0,100,0,0,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Remove Flag Standstate Kneel"), -(2720202,9,4,0,0,0,100,0,3000,3000,0,0,0,5,6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Play Emote 6"), -(2720202,9,5,0,0,0,100,0,10000,10000,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,3.944444179534912109,"Onslaught Raven Priest - On Script - Set Orientation"), -(2720202,9,6,0,0,0,100,0,1000,1000,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Set Flag Standstate Kneel"), - -(2720203,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Set Orientation Invoker"), -(2720203,9,1,0,0,0,100,0,0,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Remove Flag Standstate Kneel"), -(2720203,9,2,0,0,0,100,0,2000,2000,0,0,0,5,6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Play Emote 6"), -(2720203,9,3,0,0,0,100,0,0,0,0,0,0,1,4,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Say Line 4"), -(2720203,9,4,0,0,0,100,0,11000,11000,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,3.944444179534912109,"Onslaught Raven Priest - On Script - Set Orientation"), -(2720203,9,5,0,0,0,100,0,1000,1000,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Priest - On Script - Set Flag Standstate Kneel"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 27245 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27245,0,0,0,38,0,100,0,1,1,60000,60000,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Data Set 1 1 - Say Line 0"), -(27245,0,1,0,62,0,100,0,9536,0,0,0,0,11,48756,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Gossip Option 0 Selected - Cast 'A Fall from Grace: Ring Kissed Dummy Aura'"); - -DELETE FROM `creature_text` WHERE `CreatureID` = 27245; -INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(27245,0,0,"Boys, go see who's doing that.",12,0,100,1,0,0,26608,0,"High Abbot Landgren"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (-106200,-106201) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2724700,2724701) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(-106200,0,0,0,38,0,100,1,1,1,0,0,0,80,2724700,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Data Set 1 1 - Run Script (No Repeat)"), -(-106200,0,1,0,58,0,100,0,0,0,0,0,0,80,2724701,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Waypoint Finished - Run Script"), -(-106200,0,2,0,0,0,100,0,5000,10000,10000,15000,0,11,38256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - In Combat - Cast 'Piercing Howl'"), - -(-106201,0,0,0,0,0,100,0,5000,10000,10000,15000,0,11,38256,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - In Combat - Cast 'Piercing Howl'"), - -(2724700,9,0,0,0,0,100,0,3000,3000,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Script - Say Line 0"), -(2724700,9,1,0,0,0,100,0,3000,3000,0,0,0,53,1,27247,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Script - Start Waypoint"), - -(2724701,9,0,0,0,0,100,0,1000,1000,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Script - Say Line 1"), -(2724701,9,1,0,0,0,100,0,0,0,0,0,0,45,1,2,0,0,0,0,10,102082,27202,0,0,0,0,0,0,"Devout Bodyguard - On Script - Set Data 1 2 (Onslaught Raven Priest)"), -(2724701,9,2,0,0,0,100,0,4000,4000,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Script - Say Line 2"), -(2724701,9,3,0,0,0,100,0,20000,20000,0,0,0,41,0,0,0,0,0,0,10,106201,27247,0,0,0,0,0,0,"Devout Bodyguard - On Script - Despawn (Devout Bodyguard)"), -(2724701,9,4,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Devout Bodyguard - On Script - Despawn"); - -DELETE FROM `creature_text` WHERE `CreatureID` = 27247; -INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(27247,0,0,"Yes, your eminence. Come on!",12,0,100,2,0,0,26609,0,"Devout Bodyguard"), -(27247,1,0,"Hey, who rang the bell?",12,0,100,6,0,0,26610,0,"Devout Bodyguard"), -(27247,2,0,"The bodyguard grunts.",16,0,100,0,0,0,26611,0,"Devout Bodyguard"); - -DELETE FROM `waypoints` WHERE `entry` IN (27247,2724700,2724701); -INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES -(27247,1,2800.5461,-479.0516,119.616455,"Devout Bodyguard"), -(27247,2,2807.7734,-471.9484,119.61645,"Devout Bodyguard"), -(27247,3,2814.5222,-465.90128,119.6147,"Devout Bodyguard"), -(27247,4,2821.4888,-471.29794,123.11067,"Devout Bodyguard"), -(27247,5,2827.7585,-472.69525,128.75671,"Devout Bodyguard"), -(27247,6,2833.6016,-470.6969,134.06349,"Devout Bodyguard"), -(27247,7,2839.7278,-464.88617,135.3624,"Devout Bodyguard"), -(27247,8,2837.8572,-452.8187,135.36316,"Devout Bodyguard"), -(27247,9,2827.6262,-447.17468,135.36287,"Devout Bodyguard"), -(27247,10,2816.3098,-452.6234,135.36247,"Devout Bodyguard"), -(27247,11,2814.4758,-463.5507,135.36266,"Devout Bodyguard"), -(27247,12,2819.273,-470.78683,136.68086,"Devout Bodyguard"), -(27247,13,2827.964,-473.3304,144.91586,"Devout Bodyguard"), -(27247,14,2834.3506,-470.6176,150.68944,"Devout Bodyguard"), -(27247,15,2837.8606,-466.93002,150.83655,"Devout Bodyguard"), -(27247,16,2833.3555,-463.5104,150.8349,"Devout Bodyguard"); - -DELETE FROM `creature_formations` WHERE `memberGUID` IN (106200,106201); -INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES -(106200,106200,0,0,515,0,0), -(106200,106201,2,0,515,0,0); - -UPDATE `creature` SET `spawntimesecs` = 30 WHERE `id` = 27247; - --- AT -DELETE FROM `areatrigger_involvedrelation` WHERE `id` = 4987; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 4987 AND `source_type` = 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(4987,2,0,1,46,0,100,0,4987,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Areatrigger (New Hearthglen) - On Trigger - Store Targetlist"), -(4987,2,1,2,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,10,98593,23837,0,0,0,0,0,0,"Areatrigger (New Hearthglen) - On Link - Send Target 1 (ELM General Purpose Bunny)"), -(4987,2,2,0,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,10,98593,23837,0,0,0,0,0,0,"Areatrigger (New Hearthglen) - On Link - Set Data 0 1 (ELM General Purpose Bunny)"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = -98593 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES --- Hack, bunny here should cast 48759 on player but that works only if player does not move (if player teleports to creature) --- It works with similar spells, for example 40917 -(-98593,0,0,0,38,0,100,0,0,1,0,0,0,85,48757,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"ELM General Purpose Bunny - On Data Set 0 1 - Self Cast 'A Fall from Grace: Summon High Abbot Landgren'"), --- That aura indeed is removed and that gives us possibility to prevent double-summoning no matter how we handle summon -(-98593,0,1,0,38,0,100,0,0,1,0,0,0,28,48756,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"ELM General Purpose Bunny - On Data Set 0 1 - Remove Aura 'A Fall from Grace: Ring Kissed Dummy Aura'"); - --- Final part (no, he doesn't use vehicle for jump) -UPDATE `creature_template` SET `speed_walk` = 2 WHERE `entry` = 27439; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 27439 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2743900,2743901) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27439,0,0,0,11,0,100,0,0,0,0,0,0,80,2743900,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Spawn - Run Script"), -(27439,0,1,0,58,0,100,0,0,0,0,0,0,80,2743901,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Waypoint Finished - Run Script"), - --- Hack, at this moment personal spawns can attack any creature, that completely breaks script -(2743900,9,0,0,0,0,100,0,0,0,0,0,0,145,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set ImmuneNPC"), -(2743900,9,1,0,0,0,100,0,1000,1000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set Orientation Summoner"), -(2743900,9,2,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Say Line 0"), -(2743900,9,3,0,0,0,100,0,5000,5000,0,0,0,53,0,27439,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Start Waypoint"), - -(2743901,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set Orientation Summoner"), -(2743901,9,1,0,0,0,100,0,1000,1000,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Say Line 1"), -(2743901,9,2,0,0,0,100,0,6000,6000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set Orientation Summoner"), -(2743901,9,3,0,0,0,100,0,0,0,0,0,0,1,2,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Say Line 2"), -(2743901,9,4,0,0,0,100,0,5000,5000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set Orientation Summoner"), -(2743901,9,5,0,0,0,100,0,0,0,0,0,0,1,3,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Say Line 3"), -(2743901,9,6,0,0,0,100,0,3000,3000,0,0,0,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Play Emote 1"), -(2743901,9,7,0,0,0,100,0,5000,5000,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set Orientation Summoner"), -(2743901,9,8,0,0,0,100,0,0,0,0,0,0,1,4,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Say Line 4"), -(2743901,9,9,0,0,0,100,0,3000,3000,0,0,0,11,48771,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Cast 'A Fall from Grace: Kill Credit'"), --- No idea why it's still needed -(2743901,9,10,0,0,0,100,0,0,0,0,0,0,15,12274,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Quest Credit 'A Fall from Grace'"), -(2743901,9,11,0,0,0,100,0,0,0,0,0,0,1,5,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Say Line 5"), -(2743901,9,12,0,0,0,100,0,0,0,0,0,0,17,427,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Set Emote State 427"), -(2743901,9,13,0,0,0,100,0,0,0,0,0,0,97,25,32,0,0,0,0,1,0,0,0,0,2715.55,-560.343,10.6656,0,"High Abbot Landgren - On Script - Jump To Pos"), -(2743901,9,14,0,0,0,100,0,4000,4000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"High Abbot Landgren - On Script - Despawn"); - -DELETE FROM `waypoints` WHERE `entry` = 27439; -INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES -(27439,1,2827.0466,-412.4136,118.283745,"High Abbot Landgren"), -(27439,2,2810.891,-412.49506,118.283745,"High Abbot Landgren"), -(27439,3,2786.2637,-436.96738,118.26536,"High Abbot Landgren"), -(27439,4,2776.9878,-464.75424,116.191505,"High Abbot Landgren"), -(27439,5,2765.8164,-488.21484,114.05323,"High Abbot Landgren"), -(27439,6,2737.89,-524.4745,103.4476,"High Abbot Landgren"); - - --- Bombard the Ballistae (12232) -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_dragonblight_bombard_the_ballistae_fx_master'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(48347,'spell_dragonblight_bombard_the_ballistae_fx_master'); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 27331 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 2733100 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27331,0,0,0,8,0,100,0,48345,0,0,0,0,80,2733100,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bombard the Ballistae Kill Credit Bunny - On Spellhit 'Siegesmith Bombs' - Run Script"), - -(2733100,9,0,0,0,0,100,0,0,0,0,0,0,33,27331,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Bombard the Ballistae Kill Credit Bunny - On Script - Quest Credit 'Bombard the Ballistae'"), -(2733100,9,1,0,0,0,100,0,0,0,0,0,0,11,48347,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bombard the Ballistae Kill Credit Bunny - On Script - Cast 'Bombard the Ballistae: FX Master'"), -(2733100,9,2,0,0,0,100,0,5000,5000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bombard the Ballistae Kill Credit Bunny - On Script - Despawn"); - - --- Without a Prayer (12254) -DELETE FROM `smart_scripts` WHERE `entryorguid` = 27246 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 2724600 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(27246,0,0,0,38,0,100,0,0,1,60000,60000,0,80,2724600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bishop Street - On Data Set 0 1 - Run Script"), -(27246,0,1,0,4,0,100,0,0,0,0,0,0,1,2,0,1,0,0,0,7,0,0,0,0,0,0,0,0,"Bishop Street - On Aggro - Say Line 2"), -(27246,0,2,0,0,0,100,0,0,0,3400,4800,0,11,20820,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Bishop Street - In Combat CMC - Cast 'Holy Smite'"), -(27246,0,3,0,0,0,100,0,12000,16000,45000,55000,0,11,11974,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bishop Street - In Combat - Cast 'Power Word: Shield'"), - -(2724600,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bishop Street - On Script - Say Line 0"), -(2724600,9,1,0,0,0,100,0,4000,4000,0,0,0,11,48183,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bishop Street - On Script - Cast 'Blessing of the Light'"), -(2724600,9,2,0,0,0,100,0,4000,4000,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Bishop Street - On Script - Say Line 1"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 4984 AND `source_type` = 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(4984,2,0,0,46,0,100,0,4984,0,0,0,0,45,0,1,0,0,0,0,19,27246,0,0,0,0,0,0,0,"Areatrigger (New Hearthglen) - On Trigger - Set Data 0 1 (Bishop Street)"); - -DELETE FROM `areatrigger_scripts` WHERE `entry` = 4984; -INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES -(4984,"SmartTrigger"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 4984 AND `SourceId` = 2; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(22,1,4984,2,0,9,0,12254,0,0,0,0,0,"","Group 0: Execute Event 0 if player has taken quest 'Without a Prayer'"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 48183; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(13,1,48183,0,0,31,0,3,27203,0,0,0,0,"","Group 0: Spell 'Blessing of the Light' (Effect 0) targets creature 'Onslaught Footman'"); diff --git a/sql/updates/world/3.3.5/2022_06_09_01_world.sql b/sql/updates/world/3.3.5/2022_06_09_01_world.sql deleted file mode 100644 index 3231c540777..00000000000 --- a/sql/updates/world/3.3.5/2022_06_09_01_world.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -UPDATE `spell_script_names` SET `ScriptName` = 'spell_undercity_bending_shinbone' WHERE `ScriptName` = 'spell_q1846_bending_shinbone'; -UPDATE `spell_script_names` SET `ScriptName` = 'spell_eastern_plaguelands_test_fetid_skull' WHERE `ScriptName` = 'spell_q5206_test_fetid_skull'; -UPDATE `spell_script_names` SET `ScriptName` = 'spell_azuremyst_isle_cast_fishing_net' WHERE `ScriptName` = 'spell_q9452_cast_net'; -UPDATE `spell_script_names` SET `ScriptName` = 'spell_dustwallow_marsh_salvage_wreckage' WHERE `ScriptName` = 'spell_q11140salvage_wreckage'; -UPDATE `spell_script_names` SET `ScriptName` = 'spell_borean_tundra_arcane_prisoner_rescue' WHERE `ScriptName` = 'spell_q11587_arcane_prisoner_rescue'; diff --git a/sql/updates/world/3.3.5/2022_06_12_00_world.sql b/sql/updates/world/3.3.5/2022_06_12_00_world.sql deleted file mode 100644 index bf84803ebe2..00000000000 --- a/sql/updates/world/3.3.5/2022_06_12_00_world.sql +++ /dev/null @@ -1,22 +0,0 @@ --- -UPDATE `creature_template` SET `speed_walk` = 1, `minlevel` = 65, `maxlevel` = 65, `unit_flags` = 33554944 WHERE `entry` = 18225; - -DELETE FROM `creature_template_movement` WHERE `CreatureId` = 18225; -INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`) VALUES -(18225,1,0,1,0,0,0); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 18225 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(18225,0,0,0,11,0,100,0,0,0,0,0,0,11,31959,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fire Bomb Target - On Spawn - Cast 'Fire Bomb Target Summon Trigger'"); - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_nagrand_fire_bomb_target_summon_trigger','spell_nagrand_fire_bomb_target_summon_effect','spell_nagrand_fire_bomb_damage_missile'); -DELETE FROM `spell_script_names` WHERE `spell_id` = 34658 AND `ScriptName` = 'spell_gen_despawn_aura'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(31959,'spell_nagrand_fire_bomb_target_summon_trigger'), -(31960,'spell_nagrand_fire_bomb_target_summon_effect'), -(31961,'spell_nagrand_fire_bomb_damage_missile'), -(34658,'spell_gen_despawn_aura'); - -DELETE FROM `spell_custom_attr` WHERE `entry` = 31960; -INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES -(31960,262144); diff --git a/sql/updates/world/3.3.5/2022_06_15_00_world.sql b/sql/updates/world/3.3.5/2022_06_15_00_world.sql deleted file mode 100644 index 4e700cebbbc..00000000000 --- a/sql/updates/world/3.3.5/2022_06_15_00_world.sql +++ /dev/null @@ -1,22 +0,0 @@ --- -UPDATE `creature_template` SET `minlevel` = 64, `maxlevel` = 64 WHERE `entry` IN (18176,18177,18179); -UPDATE `creature_template` SET `minlevel` = 72, `maxlevel` = 72 WHERE `entry` IN (19897,19899,19900); -UPDATE `creature_template` SET `minlevel` = 1, `maxlevel` = 1 WHERE `entry` IN (20208,22322); - -DELETE FROM `creature_template_addon` WHERE `entry` IN (18176,18179); - -DELETE FROM `creature_template_spell` WHERE `CreatureID` IN (19897,19900,19899,22322); -INSERT INTO `creature_template_spell` (`CreatureID`, `Index`, `Spell`, `VerifiedBuild`) VALUES -(19897,0,31982,12340), -(19900,0,31986,12340), -(19899,0,33134,12340), -(22322,0,38799,12340); - --- Casts nova when its aura kills him or when someone kills him, basically one event, one spell for both modes(scales with level) --- No anim for some reason -DELETE FROM `smart_scripts` WHERE `entryorguid` = 18179 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(18179,0,0,0,6,0,100,0,0,0,0,0,0,11,33132,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Nova Totem - On Death - Cast 'Fire Nova'"); - -UPDATE `creature_template` SET `AIName` = '' WHERE `entry` = 18177; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 18177 AND `source_type` = 0; diff --git a/sql/updates/world/3.3.5/2022_06_15_01_world.sql b/sql/updates/world/3.3.5/2022_06_15_01_world.sql deleted file mode 100644 index 5ea196d24f7..00000000000 --- a/sql/updates/world/3.3.5/2022_06_15_01_world.sql +++ /dev/null @@ -1,29 +0,0 @@ --- -UPDATE `creature` SET `spawntimesecs` = 90 WHERE `id` = 30746; -UPDATE `creature_loot_template` SET `Chance` = 100 WHERE `Entry` = 30746 AND `Item` = 43159 AND `Reference` = 0; - -DELETE FROM `spell_scripts` WHERE `id` = 57852; - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30742,30744,30745,30950) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3074200,3074400,3074500,3095000) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(30742,0,0,0,8,0,100,0,57852,0,0,0,0,80,3074200,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"First Summoning Altar - On Spellhit 'Destroy Altar' - Run Script"), -(30744,0,0,0,8,0,100,0,57852,0,0,0,0,80,3074400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Second Summoning Altar - On Spellhit 'Destroy Altar' - Run Script"), -(30745,0,0,0,8,0,100,0,57852,0,0,0,0,80,3074500,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Third Summoning Altar - On Spellhit 'Destroy Altar' - Run Script"), -(30950,0,0,0,8,0,100,0,57852,0,0,0,0,80,3095000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fourth Summoning Altar - On Spellhit 'Destroy Altar' - Run Script"), - -(3074200,9,0,0,0,0,100,0,0,0,0,0,0,11,57931,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"First Summoning Altar - On Script - Cast 'Cosmetic - Low Poly Fire'"), -(3074200,9,1,0,0,0,100,0,0,0,0,0,0,11,46419,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"First Summoning Altar - On Script - Cast 'Cosmetic - Explosion'"), -(3074200,9,2,0,0,0,100,0,0,0,0,0,0,33,30742,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"First Summoning Altar - On Script - Quest Credit 'Destroying the Altars'"), - -(3074400,9,0,0,0,0,100,0,0,0,0,0,0,11,57931,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Second Summoning Altar - On Script - Cast 'Cosmetic - Low Poly Fire'"), -(3074400,9,1,0,0,0,100,0,0,0,0,0,0,11,46419,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Second Summoning Altar - On Script - Cast 'Cosmetic - Explosion'"), -(3074400,9,2,0,0,0,100,0,0,0,0,0,0,33,30744,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Second Summoning Altar - On Script - Quest Credit 'Destroying the Altars'"), - -(3074500,9,0,0,0,0,100,0,0,0,0,0,0,11,57931,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Third Summoning Altar - On Script - Cast 'Cosmetic - Low Poly Fire'"), -(3074500,9,1,0,0,0,100,0,0,0,0,0,0,11,46419,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Third Summoning Altar - On Script - Cast 'Cosmetic - Explosion'"), -(3074500,9,2,0,0,0,100,0,0,0,0,0,0,33,30745,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Third Summoning Altar - On Script - Quest Credit 'Destroying the Altars'"), - -(3095000,9,0,0,0,0,100,0,0,0,0,0,0,11,57931,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fourth Summoning Altar - On Script - Cast 'Cosmetic - Low Poly Fire'"), -(3095000,9,1,0,0,0,100,0,0,0,0,0,0,11,46419,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fourth Summoning Altar - On Script - Cast 'Cosmetic - Explosion'"), -(3095000,9,2,0,0,0,100,0,0,0,0,0,0,33,30950,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Fourth Summoning Altar - On Script - Quest Credit 'Destroying the Altars'"); diff --git a/sql/updates/world/3.3.5/2022_06_15_02_world.sql b/sql/updates/world/3.3.5/2022_06_15_02_world.sql deleted file mode 100644 index 8205e8f77e6..00000000000 --- a/sql/updates/world/3.3.5/2022_06_15_02_world.sql +++ /dev/null @@ -1,37 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` = 58854; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 3123500 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(3123500,9,0,0,0,0,100,0,2000,2000,0,0,0,11,37692,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Cast 'Fake Blood Spurt'"), -(3123500,9,1,0,0,0,100,0,2000,2000,0,0,0,11,37692,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Cast 'Fake Blood Spurt'"), -(3123500,9,2,0,0,0,100,0,2000,2000,0,0,0,11,58854,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Cast 'Resurrection'"), -(3123500,9,3,0,0,0,100,0,0,0,0,0,0,28,35356,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Remove Aura 'Spawn Feign Death'"), -(3123500,9,4,0,0,0,100,0,4000,4000,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Say Line 0"), -(3123500,9,5,0,0,0,100,0,3000,3000,0,0,0,5,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Play Emote 2"), -(3123500,9,6,0,0,0,100,0,3000,3000,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Say Line 1"), -(3123500,9,7,0,0,0,100,0,6000,6000,0,0,0,1,2,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Say Line 2"), -(3123500,9,8,0,0,0,100,0,0,0,0,0,0,33,31235,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Quest Credit 'Putting Olakin Back Together Again'"), -(3123500,9,9,0,0,0,100,0,6000,6000,0,0,0,53,1,31235,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crusader Olakin Sainrith - On Script - Start Waypoint"); - --- -DELETE FROM `spell_scripts` WHERE `id` IN (26264,34874,45451); -DELETE FROM `spell_script_names` WHERE `spell_id` IN (26264,34874,45451) AND `ScriptName` = 'spell_gen_despawn_target'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(26264,'spell_gen_despawn_target'), -(34874,'spell_gen_despawn_target'), -(45451,'spell_gen_despawn_target'); - --- -DELETE FROM `spell_scripts` WHERE `id` IN (45505,45507,45509,45511); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 25401 AND `source_type` = 0 AND `id` BETWEEN 1 AND 5; -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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(25401,0,1,5,8,0,100,0,45505,0,0,0,0,11,45506,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Seaforium Depth Charge - On Spellhit 'Nerub'ar Sinkhole Credit (SW)' - Cast 'Nerub'ar Sinkhole Credit (SW)'"), -(25401,0,2,5,8,0,100,0,45507,0,0,0,0,11,45508,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Seaforium Depth Charge - On Spellhit 'Nerub'ar Sinkhole Credit (SE)' - Cast 'Nerub'ar Sinkhole Credit (SE)'"), -(25401,0,3,5,8,0,100,0,45509,0,0,0,0,11,45510,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Seaforium Depth Charge - On Spellhit 'Nerub'ar Sinkhole Credit (NW)' - Cast 'Nerub'ar Sinkhole Credit (NW)'"), -(25401,0,4,5,8,0,100,0,45511,0,0,0,0,11,45512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Seaforium Depth Charge - On Spellhit 'Nerub'ar Sinkhole Credit (NE)' - Cast 'Nerub'ar Sinkhole Credit (NE)'"), -(25401,0,5,0,61,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Seaforium Depth Charge - On Link - Despawn"); - --- -DELETE FROM `spell_scripts` WHERE `id` = 55288; diff --git a/sql/updates/world/3.3.5/2022_06_15_03_world.sql b/sql/updates/world/3.3.5/2022_06_15_03_world.sql deleted file mode 100644 index 8431d4851f9..00000000000 --- a/sql/updates/world/3.3.5/2022_06_15_03_world.sql +++ /dev/null @@ -1,35 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` = 56099; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 30169 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 3016900 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(30169,0,0,0,11,0,100,0,0,0,0,0,0,11,56073,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Spawn - Cast 'Summon Smoldering Scrap'"), -(30169,0,1,0,8,0,100,1,56099,0,0,0,0,80,3016900,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Spellhit 'Throw Ice' - Run Script (No Repeat)"), - -(3016900,9,0,0,0,0,100,0,0,0,0,0,0,28,56118,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Script - Remove Aura 'Smolder Smoke'"), -(3016900,9,1,0,0,0,100,0,0,0,0,0,0,11,56101,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Script - Cast 'Summon Frozen Iron Scrap'"), -(3016900,9,2,0,0,0,100,0,0,0,0,0,0,11,56135,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Script - Cast 'Frost Nova Effect'"), --- Was Set Loot State, doesn't make it more bugged (see below) and correct action here -(3016900,9,3,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,20,192124,5,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Script - Despawn Closest GameObject 'Smoldering Scrap'"), --- 100000 in sniffs, but 100000 increases chance spell will be launched on wrong target (less available targets - better), --- ideally despawn it instantly but we want to keep anim which lasts for 15 sec. According to comments Blizz too has problems with target --- selector in this quest, maybe less serious. Removing condition for spell makes it only worse -(3016900,9,4,0,0,0,100,0,15000,15000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Smoldering Scrap Bunny - On Script - Despawn"); - --- -DELETE FROM `spell_scripts` WHERE `id` = 68052; - -UPDATE `creature_text` SET `Emote` = 0 WHERE `CreatureID` = 35642 AND `GroupID` = 0; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 35642 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3564200,3564201) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(35642,0,0,0,11,0,100,0,0,0,0,0,0,80,3564200,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Jeeves - On Spawn - Run Script"), -(35642,0,1,0,8,0,100,0,68052,0,0,0,0,80,3564201,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Jeeves - On Spellhit 'Jeeves Goodbye' - Run Script"), - -(3564200,9,0,0,0,0,100,0,0,0,0,0,0,11,68054,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Jeeves - On Script - Cast 'Pressing Engagement'"), -(3564200,9,1,0,0,0,100,0,1500,1500,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Jeeves - On Script - Set Orientation Owner"), - -(3564201,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Jeeves - On Script - Say Line 0"), -(3564201,9,1,0,0,0,100,0,1500,1500,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Jeeves - On Script - Despawn"); diff --git a/sql/updates/world/3.3.5/2022_06_16_00_world.sql b/sql/updates/world/3.3.5/2022_06_16_00_world.sql deleted file mode 100644 index 286f59d46aa..00000000000 --- a/sql/updates/world/3.3.5/2022_06_16_00_world.sql +++ /dev/null @@ -1,33 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` = 44688; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 24852 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2485200,2485201) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(24852,0,0,0,11,0,100,512,0,0,0,0,0,80,2485200,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Spawn - Run Script"), -(24852,0,1,0,58,0,100,512,0,0,0,0,0,80,2485201,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Waypoint Finished - Run Script"), - -(2485200,9,0,0,0,0,100,512,4000,4000,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Say Line 0"), -(2485200,9,1,0,0,0,100,512,0,0,0,0,0,11,44687,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Cast 'Rocket Jump'"), -(2485200,9,2,0,0,0,100,512,2000,2000,0,0,0,53,1,24852,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Start Waypoint"), - -(2485201,9,0,0,0,0,100,512,0,0,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Say Line 1"), -(2485201,9,1,0,0,0,100,512,0,0,0,0,0,28,44687,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Remove Aura 'Rocket Jump'"), -(2485201,9,2,0,0,0,100,512,2000,2000,0,0,0,11,44688,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Cast 'System Failure'"), -(2485201,9,3,0,0,0,100,512,1500,1500,0,0,0,11,44741,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Construct - On Script - Cast 'System Failure'"); - -DELETE FROM `spell_target_position` WHERE `ID` IN (49976); -INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `VerifiedBuild`) VALUES -(49976,0,571,478.996,-5941.52,308.746,0,14545); - --- -DELETE FROM `spell_scripts` WHERE `id` = 25952; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 15664 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 1566400 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(15664,0,0,0,62,0,100,1,6763,0,0,0,0,80,1566400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Metzen the Reindeer - On Gossip Option 0 Selected - Run Script (No Repeat)"), - -(1566400,9,0,0,0,0,100,0,0,0,0,0,0,11,25952,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Metzen the Reindeer - On Script - Cast 'Reindeer Dust Effect'"), -(1566400,9,1,0,0,0,100,0,0,0,0,0,0,33,15664,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Metzen the Reindeer - On Script - Quest Credit 'Metzen the Reindeer'"), -(1566400,9,2,0,0,0,100,0,8000+3000,8000+3000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Metzen the Reindeer - On Script - Despawn"); diff --git a/sql/updates/world/3.3.5/2022_06_16_01_world.sql b/sql/updates/world/3.3.5/2022_06_16_01_world.sql deleted file mode 100644 index 17eb530e921..00000000000 --- a/sql/updates/world/3.3.5/2022_06_16_01_world.sql +++ /dev/null @@ -1,20 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` = 55818; -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 55818; - -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_storm_peaks_call_of_earth'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(55512,'spell_storm_peaks_call_of_earth'); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29375,29503) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(29375,0,0,0,0,0,100,0,0,10000,20000,25000,0,11,57741,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Stormforged Iron Giant - In Combat - Cast 'Shockwave'"), -(29375,0,1,0,8,0,100,0,55818,0,0,0,0,11,55512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Stormforged Iron Giant - On Spellhit 'Hurl Boulder' - Cast 'Call of Earth'"), - -(29503,0,0,0,0,0,100,0,0,10000,20000,25000,0,11,57801,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fjorn - In Combat - Cast 'Flame Breath'"), -(29503,0,1,0,8,0,100,0,55818,0,0,0,0,11,55512,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fjorn - On Spellhit 'Hurl Boulder' - Cast 'Call of Earth'"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` = 55818; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(17,0,55818,0,0,31,1,3,29375,0,0,0,0,"","Group 0: Spell 'Hurl Boulder' targets creature 'Stormforged Iron Giant'"), -(17,0,55818,0,1,31,1,3,29503,0,0,0,0,"","Group 1: Spell 'Hurl Boulder' targets creature 'Fjorn'"); diff --git a/sql/updates/world/3.3.5/2022_06_20_00_world.sql b/sql/updates/world/3.3.5/2022_06_20_00_world.sql deleted file mode 100644 index 7491fa6b919..00000000000 --- a/sql/updates/world/3.3.5/2022_06_20_00_world.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -DELETE FROM `creature_loot_template` WHERE `Entry` IN (4625,11374,12352,27213,27414,31205); -DELETE FROM `pickpocketing_loot_template` WHERE `Entry` IN (12352); -UPDATE `creature_template` SET `lootid` = 0, `pickpocketloot` = 0 WHERE `entry` IN (4625,11374,12352,27213,27414,31205); diff --git a/sql/updates/world/3.3.5/2022_06_20_01_world.sql b/sql/updates/world/3.3.5/2022_06_20_01_world.sql deleted file mode 100644 index cc2e8915b81..00000000000 --- a/sql/updates/world/3.3.5/2022_06_20_01_world.sql +++ /dev/null @@ -1,17 +0,0 @@ --- -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_the_black_stalker_levitate', -'spell_the_black_stalker_levitation_pulse', -'spell_the_black_stalker_someone_grab_me', -'spell_the_black_stalker_magnetic_pull', -'spell_the_black_stalker_summon_spore_strider'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(31704,'spell_the_black_stalker_levitate'), -(31701,'spell_the_black_stalker_levitation_pulse'), -(31702,'spell_the_black_stalker_someone_grab_me'), -(31703,'spell_the_black_stalker_magnetic_pull'), -(38756,'spell_the_black_stalker_summon_spore_strider'); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 31702; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(13,1,31702,0,0,31,0,3,17992,0,0,0,0,"","Group 0: Spell 'Someone Grab Me' (Effect 0) targets creature 'Coilfang Invisible Vacuum Dummy'"); diff --git a/sql/updates/world/3.3.5/2022_06_20_02_world.sql b/sql/updates/world/3.3.5/2022_06_20_02_world.sql deleted file mode 100644 index a40965b092d..00000000000 --- a/sql/updates/world/3.3.5/2022_06_20_02_world.sql +++ /dev/null @@ -1,15 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` = 57884; -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 57889; - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_icecrown_through_the_eye_the_eye_of_the_lk','spell_icecrown_through_the_eye_kill_credit_to_master'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(25732,'spell_icecrown_through_the_eye_the_eye_of_the_lk'), -(57884,'spell_icecrown_through_the_eye_kill_credit_to_master'); - -DELETE FROM `creature_text` WHERE `CreatureID` = 23837 AND `GroupID` = 0; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = -121192 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 192861 AND `source_type` = 1 AND `id` IN (1,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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(192861,1,1,0,61,0,100,0,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Eye of the Lich King - On Gossip Option 0 Selected - Close Gossip"); diff --git a/sql/updates/world/3.3.5/2022_06_20_03_world.sql b/sql/updates/world/3.3.5/2022_06_20_03_world.sql deleted file mode 100644 index d7263fd974b..00000000000 --- a/sql/updates/world/3.3.5/2022_06_20_03_world.sql +++ /dev/null @@ -1,16 +0,0 @@ --- -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 38224; - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_shadowmoon_illidari_agent_illusion','spell_shadowmoon_quest_credit_crazed_colossus'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(38224,'spell_shadowmoon_illidari_agent_illusion'), -(38223,'spell_shadowmoon_quest_credit_crazed_colossus'); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 19823 AND `SourceId` = 0; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 19823 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(19823,0,0,0,2,0,100,1,0,75,0,0,0,11,37947,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crazed Colossus - Between 0-75% Health - Cast 'Summon Crazed Shardling' (No Repeat)"), -(19823,0,1,0,2,0,100,1,0,50,0,0,0,11,37948,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crazed Colossus - Between 0-50% Health - Cast 'Summon Crazed Shardling' (No Repeat)"), -(19823,0,2,0,2,0,100,1,0,25,0,0,0,11,37949,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Crazed Colossus - Between 0-25% Health - Cast 'Summon Crazed Shardling' (No Repeat)"), -(19823,0,3,0,6,0,100,0,0,0,0,0,0,11,38223,2,0,0,0,0,7,0,0,0,0,0,0,0,0,"Crazed Colossus - On Death - Cast 'Quest Credit: Crazed Colossus'"); diff --git a/sql/updates/world/3.3.5/2022_06_22_00_world.sql b/sql/updates/world/3.3.5/2022_06_22_00_world.sql deleted file mode 100644 index b4e147f13cd..00000000000 --- a/sql/updates/world/3.3.5/2022_06_22_00_world.sql +++ /dev/null @@ -1,37 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` IN (23645,23725,24194,24195,38358,45185,47097,47958,57082,47703,47724,50252); - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_item_hourglass_sand', -'spell_item_lifegiving_gem', -'spell_quest_uther_grom_tribute', -'spell_fathomlord_karathress_tidal_surge', -'spell_brutallus_stomp', -'spell_dragonblight_surge_needle_teleporter', -'spell_ormorok_summon_crystal_spikes', -'spell_dragonblight_fill_blood_unholy_frost_gem'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(23645,'spell_item_hourglass_sand'), -(23725,'spell_item_lifegiving_gem'), -(24194,'spell_quest_uther_grom_tribute'), -(24195,'spell_quest_uther_grom_tribute'), -(38358,'spell_fathomlord_karathress_tidal_surge'), -(45185,'spell_brutallus_stomp'), -(47097,'spell_dragonblight_surge_needle_teleporter'), -(47958,'spell_ormorok_summon_crystal_spikes'), -(57082,'spell_ormorok_summon_crystal_spikes'), -(47703,'spell_dragonblight_fill_blood_unholy_frost_gem'), -(47724,'spell_dragonblight_fill_blood_unholy_frost_gem'), -(50252,'spell_dragonblight_fill_blood_unholy_frost_gem'); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` IN -(24101,24102,24103,24104,69530,24105,24106,24107,24108,69533,47324,47325); - -DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (47954,47955,47956,47957); -INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`, `spellid2`, `spellid3`) VALUES -(47954,47954,57077,0,0), -(47955,47955,57078,0,0), -(47956,47956,57080,0,0), -(47957,47957,57081,0,0); - -UPDATE `spell_script_names` SET `ScriptName` = 'spell_ormorok_crystal_spike' WHERE `ScriptName` = 'spell_crystal_spike'; diff --git a/sql/updates/world/3.3.5/2022_06_24_00_world.sql b/sql/updates/world/3.3.5/2022_06_24_00_world.sql deleted file mode 100644 index dee6269c76f..00000000000 --- a/sql/updates/world/3.3.5/2022_06_24_00_world.sql +++ /dev/null @@ -1,43 +0,0 @@ --- Copied from 35153 by them -UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 28, `EffectDieSides1` = 1, `EffectImplicitTargetA1` = 73, `EffectRadiusIndex1` = 37, `EffectMiscValue1` = 28166, `EffectMiscValueB1` = 64, `DmgMultiplier1` = 1, `DmgMultiplier2` = 1 WHERE `Id` = 50754; - --- Same, from 35148 -UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 6, `EffectImplicitTargetA1` = 1, `EffectApplyAuraName1` = 23, `EffectAmplitude1` = 2000, `EffectTriggerSpell1` = 50757, `DmgMultiplier1` = 1, `DmgMultiplier2` = 1 WHERE `Id` = 50755; - --- While at it, update both of them -UPDATE `creature_template` SET `flags_extra` = `flags_extra` &~ 0x00002000 WHERE `entry` IN (20405,21534); -UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 28166; - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (20405,28166) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2040500,2816600) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(20405,0,0,0,37,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On AI Initialize - Set Reactstate Passive"), -(20405,0,1,0,11,0,100,0,0,0,0,0,0,80,2040500,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Spawn - Run Script"), - -(2040500,9,0,0,0,0,100,0,0,0,0,0,0,11,35150,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Script - Cast 'Nether Charge Passive'"), -(2040500,9,1,0,0,0,100,0,0,0,0,0,0,11,37670,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Script - Cast 'Nether Charge Timer'"), -(2040500,9,2,0,0,0,100,0,0,0,0,0,0,89,20,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Script - Start Random Movement"), -(2040500,9,3,0,0,0,100,0,8500,8500,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Script - Stop Random Movement"), -(2040500,9,4,0,0,0,100,0,0,0,0,0,0,11,35148,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Script - Cast 'Nether Charge Countdown'"), -(2040500,9,5,0,0,0,100,0,9500,9500,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Nether Charge - On Script - Despawn"), - -(28166,0,0,0,37,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On AI Initialize - Set Reactstate Passive"), -(28166,0,1,0,11,0,100,0,0,0,0,0,0,80,2816600,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Spawn - Run Script"), - -(2816600,9,0,0,0,0,100,0,1000,1000,0,0,0,11,51347,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Cast 'Teleport Visual Only'"), -(2816600,9,1,0,0,0,100,0,0,0,0,0,0,11,50756,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Cast 'Unstable Sphere Passive'"), -(2816600,9,2,0,0,0,100,0,0,0,0,0,0,11,50758,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Cast 'Unstable Sphere Timer'"), -(2816600,9,3,0,0,0,100,0,0,0,0,0,0,89,40,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Start Random Movement"), -(2816600,9,4,0,0,0,100,0,8000,8000,0,0,0,89,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Stop Random Movement"), -(2816600,9,5,0,0,0,100,0,0,0,0,0,0,11,50755,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Cast 'Unstable Sphere Countdown'"), -(2816600,9,6,0,0,0,100,0,10000,10000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Unstable Sphere - On Script - Despawn"); - -DELETE FROM `spell_scripts` WHERE `id` = 51336; - -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_drakos_magic_pull'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(51336,'spell_drakos_magic_pull'); - -DELETE FROM `creature_text` WHERE `CreatureID` = 27654 AND `GroupID` = 5; -INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES -(27654,5,0,"%s begins to cast Magic Pull!",41,0,100,0,0,0,27550,0,"drakos EMOTE_PULL"); diff --git a/sql/updates/world/3.3.5/2022_06_26_00_world.sql b/sql/updates/world/3.3.5/2022_06_26_00_world.sql deleted file mode 100644 index 221ba43c7a7..00000000000 --- a/sql/updates/world/3.3.5/2022_06_26_00_world.sql +++ /dev/null @@ -1,7 +0,0 @@ --- -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-33711,-38794,33686,51010); -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_murmur_murmurs_touch','spell_item_dire_brew'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(33711,'spell_murmur_murmurs_touch'), -(38794,'spell_murmur_murmurs_touch'), -(51010,'spell_item_dire_brew'); diff --git a/sql/updates/world/3.3.5/2022_06_30_00_world.sql b/sql/updates/world/3.3.5/2022_06_30_00_world.sql deleted file mode 100644 index 5201a0ef842..00000000000 --- a/sql/updates/world/3.3.5/2022_06_30_00_world.sql +++ /dev/null @@ -1,55 +0,0 @@ --- -UPDATE `spell_script_names` SET `ScriptName` = 'spell_pet_gen_lich_pet_onsummon' WHERE `ScriptName` = 'spell_gen_lich_pet_onsummon'; -UPDATE `spell_script_names` SET `ScriptName` = 'spell_pet_gen_lich_pet_aura_remove' WHERE `ScriptName` = 'spell_gen_lich_pet_aura_remove'; -UPDATE `spell_script_names` SET `ScriptName` = 'spell_pet_gen_lich_pet_aura' WHERE `ScriptName` = 'spell_gen_lich_pet_aura'; - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_pet_gen_lich_pet_periodic_emote', -'spell_pet_gen_lich_pet_emote', -'spell_pet_gen_lich_pet_focus'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(70050,'spell_pet_gen_lich_pet_periodic_emote'), -(70049,'spell_pet_gen_lich_pet_emote'), -(69682,'spell_pet_gen_lich_pet_focus'); - -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 70049; -DELETE FROM `spell_scripts` WHERE `id` IN (69731,69682); - -UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 36979; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 36979 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3697900,3697901) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(36979,0,0,0,11,0,100,0,0,0,0,0,0,11,69735,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Spawn - Cast 'Lich Pet OnSummon'"), -(36979,0,1,0,86,0,100,0,0,0,0,0,0,11,69736,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Despawn - Cast 'Lich Pet Aura Remove'"), -(36979,0,2,0,8,0,100,0,69731,0,0,0,0,80,3697900,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Spellhit 'Lich Pet Aura OnKill' - Run Script"), -(36979,0,3,0,83,0,100,0,69681,0,0,0,0,80,3697901,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Spell Cast 'Lil' Frost Blast' - Run Script"), - --- Movement is definitely paused in both cases. --- If we root creature, and if both emote event and critter event will be executed at once, root will be cleared on aura remove, in other --- words before we clean it manually in script. That will screw up entire critter event. And doesn't really look like it should be rooted, --- more like movement is stopped. But packets are different. - --- The only way they can temporarily stop movement here is replace one action list by another. --- But that would mean they somehow overwrited default pet follow by scripted follow, would be weird. --- Actually we have a bunch of guardians and their default follow movement is somehow completely ignored by creature: Khadgar's Servant, --- Ancestral Spirit Wolf. Both actually are scripted on retail using only one action list which handles everything from spawn to despawn. --- At the same time Fel Guard Hound follows owner after spawn by default but has again one action list which interrupts default follow --- movement and resumes it after action list is finished. Kindal Moonweaver is a bit different because follow movement is launched from --- very first action list and is paused by another she executes(https://youtu.be/GV64q-i420o?t=115). --- So it looks like execution of any action list pauses follow movement no matter is it scripted or is default. Will such global mechanic --- work always without any problems? No idea. Something to think of. - -(3697900,9,0,0,0,0,100,0,0,0,0,0,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Stop Follow"), -(3697900,9,1,0,0,0,100,0,0,0,0,0,0,4,16493,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Play Sound 16493"), -(3697900,9,2,0,0,0,100,0,0,0,0,0,0,17,451,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Set Emote State 451"), -(3697900,9,3,0,0,0,100,0,1000,1000,0,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Set Emote State 0"), -(3697900,9,4,0,0,0,100,0,3000,3000,0,0,0,29,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Start Follow Owner"), - -(3697901,9,0,0,0,0,100,0,0,0,0,0,0,29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Stop Follow"), -(3697901,9,1,0,0,0,100,0,2000,2000,0,0,0,4,16493,0,1,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Play Sound 16493"), -(3697901,9,2,0,0,0,100,0,0,0,0,0,0,17,451,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Set Emote State 451"), -(3697901,9,3,0,0,0,100,0,1000,1000,0,0,0,17,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Set Emote State 0"), -(3697901,9,4,0,0,0,100,0,3000,3000,0,0,0,29,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Lil' K.T. - On Script - Start Follow Owner"); - --- Never was needed, never will work the way author expected -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` IN (71849,69683); diff --git a/sql/updates/world/3.3.5/2022_07_03_00_world.sql b/sql/updates/world/3.3.5/2022_07_03_00_world.sql deleted file mode 100644 index 3a067ef633c..00000000000 --- a/sql/updates/world/3.3.5/2022_07_03_00_world.sql +++ /dev/null @@ -1,37 +0,0 @@ --- -UPDATE `creature_template` SET `unit_flags` = 33554688 WHERE `entry` = 28780; -UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 28778; - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28780,28778) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2878000,2877800) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(28780,0,0,0,11,0,100,0,0,0,0,0,0,80,2878000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Spawn - Run Script"), - -(2878000,9,0,0,0,0,100,0,0,0,0,0,0,11,52346,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Cast 'Kill Credit'"), -(2878000,9,1,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Say Line 0"), -(2878000,9,2,0,0,0,100,0,1000,1000,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Say Line 1"), -(2878000,9,3,0,0,0,100,0,1000,1000,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Say Line 2"), -(2878000,9,4,0,0,0,100,0,1000,1000,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Say Line 3"), -(2878000,9,5,0,0,0,100,0,1000,1000,0,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Say Line 4"), -(2878000,9,6,0,0,0,100,0,1000,1000,0,0,0,11,52322,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Cast 'Detonate Charges'"), -(2878000,9,7,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Explosive Charges Bunny - On Script - Despawn"), - -(28778,0,0,0,8,0,100,0,52322,0,0,0,0,80,2877800,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Scourgewagon Bunny - On Spellhit 'Detonate Charges' - Run Script"), - -(2877800,9,0,0,0,0,100,0,0,0,0,0,0,11,52324,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Scourgewagon Bunny - On Script - Cast 'Scourgewagon Explosion'"), -(2877800,9,1,0,0,0,100,0,0,0,0,0,0,11,52335,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Scourgewagon Bunny - On Script - Cast 'Drop Scourge Disguise'"), -(2877800,9,2,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,20,190732,15,0,0,0,0,0,0,"Scourgewagon Bunny - On Script - Despawn Closest Gameobject 'Explosive Charges'"), -(2877800,9,3,0,0,0,100,0,0,0,0,0,0,41,0,0,0,0,0,0,20,190731,15,0,0,0,0,0,0,"Scourgewagon Bunny - On Script - Despawn Closest Gameobject 'Scourgewagon'"), -(2877800,9,4,0,0,0,100,0,5000,5000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Scourgewagon Bunny - On Script - Despawn"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` IN (52322); -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(13,1,52322,0,0,31,0,3,28778,0,0,0,0,"","Group 0: Spell 'Detonate Charges' (Effect 0) targets creature 'Scourgewagon Bunny'"); - -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 52322; - -DELETE FROM `spell_script_names` WHERE `spell_id` = 52335 AND `ScriptName` = 'spell_zuldrak_drop_disguise'; -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_zuldrak_scourgewagon_explosion'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(52335,'spell_zuldrak_drop_disguise'), -(52324,'spell_zuldrak_scourgewagon_explosion'); diff --git a/sql/updates/world/3.3.5/2022_07_03_01_world.sql b/sql/updates/world/3.3.5/2022_07_03_01_world.sql deleted file mode 100644 index 0f40b759d34..00000000000 --- a/sql/updates/world/3.3.5/2022_07_03_01_world.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (-12480,12479,12480); -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_sunken_temple_hex_of_jammalan','spell_sunken_temple_hex_of_jammalan_transform'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(12479,'spell_sunken_temple_hex_of_jammalan'), -(12480,'spell_sunken_temple_hex_of_jammalan_transform'); diff --git a/sql/updates/world/3.3.5/2022_07_03_02_world.sql b/sql/updates/world/3.3.5/2022_07_03_02_world.sql deleted file mode 100644 index 76537134ad1..00000000000 --- a/sql/updates/world/3.3.5/2022_07_03_02_world.sql +++ /dev/null @@ -1,23 +0,0 @@ --- -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (70192,-71450,71522,71539); -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_love_is_in_the_air_fragrant_air_analysis', -'spell_love_is_in_the_air_heavily_perfumed', -'spell_love_is_in_the_air_recently_analyzed', -'spell_love_is_in_the_air_sample_satisfaction', -'spell_love_is_in_the_air_cancel_service_uniform', -'spell_love_is_in_the_air_perfume_cologne_immune'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(70192,'spell_love_is_in_the_air_fragrant_air_analysis'), -(71507,'spell_love_is_in_the_air_heavily_perfumed'), -(71508,'spell_love_is_in_the_air_recently_analyzed'), -(69438,'spell_love_is_in_the_air_sample_satisfaction'), -(71522,'spell_love_is_in_the_air_cancel_service_uniform'), -(71539,'spell_love_is_in_the_air_cancel_service_uniform'), -(68529,'spell_love_is_in_the_air_perfume_cologne_immune'), -(68530,'spell_love_is_in_the_air_perfume_cologne_immune'); - -UPDATE `spell_script_names` SET `ScriptName` = 'spell_love_is_in_the_air_service_uniform' WHERE `ScriptName` = 'spell_gen_aura_service_uniform'; - -DELETE FROM `spell_group` WHERE `id`=68529; -DELETE FROM `spell_group_stack_rules` WHERE `group_id`=68529; diff --git a/sql/updates/world/3.3.5/2022_07_10_00_world.sql b/sql/updates/world/3.3.5/2022_07_10_00_world.sql deleted file mode 100644 index 0604bf0637a..00000000000 --- a/sql/updates/world/3.3.5/2022_07_10_00_world.sql +++ /dev/null @@ -1,80 +0,0 @@ --- -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_magus_telestra_summon_clones', -'spell_magus_telestra_clone_dies'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(47710,'spell_magus_telestra_summon_clones'), -(47711,'spell_magus_telestra_clone_dies'), -(47712,'spell_magus_telestra_clone_dies'), -(47713,'spell_magus_telestra_clone_dies'); - -DELETE FROM `spell_target_position` WHERE `ID` = 47754; -INSERT INTO `spell_target_position` (`ID`,`EffectIndex`,`MapID`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`VerifiedBuild`) VALUES -(47754,0,576,504.742,88.9122,-16.1245,0,11159); - -UPDATE `creature_template` SET `minlevel` = 72, `maxlevel` = 72 WHERE `entry` = 26731; - - --- Should be 15214 but it has 2 models. -UPDATE `spell_dbc` SET `ProcChance` = 101, `Effect1` = 6, `EffectImplicitTargetA1` = 1, `EffectApplyAuraName1` = 56, `EffectMiscValue1` = 2334, `DmgMultiplier1` = 1 WHERE `Id` = 41577; - -UPDATE `creature_template` SET `BaseAttackTime` = 2000 WHERE `entry` IN (26928,26929,26930); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (26928,26929,26930) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2692800,2692900,2693000) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(26928,0,0,0,37,0,100,0,0,0,0,0,0,42,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On AI Initialize - Set Invincibility HP 1"), -(26928,0,1,0,11,0,100,0,0,0,0,0,0,11,47705,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Spawn - Cast 'Grand Magus Telestra (Fire) Visual'"), -(26928,0,2,0,2,0,100,1,0,1,0,0,0,80,2692800,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - Between 0-1% Health - Run Script (No Repeat)"), -(26928,0,3,0,0,0,100,2,0,0,1600,2400,0,11,47723,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat CMC - Cast 'Scorch'"), -(26928,0,4,0,0,0,100,4,0,0,1600,2400,0,11,56938,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat CMC - Cast 'Scorch'"), -(26928,0,5,0,0,0,100,2,6000,12000,6000,12000,0,11,47721,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat - Cast 'Fire Blast'"), -(26928,0,6,0,0,0,100,4,6000,12000,6000,12000,0,11,56939,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat - Cast 'Fire Blast'"), - -(2692800,9,0,0,0,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,23,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Data 0 1 (Summoner)"), -(2692800,9,1,0,0,0,100,0,0,0,0,0,0,28,47705,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Remove Aura 'Grand Magus Telestra (Fire) Visual'"), -(2692800,9,2,0,0,0,100,0,0,0,0,0,0,11,41577,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Transform: Invisible Stalker'"), -(2692800,9,3,0,0,0,100,0,0,0,0,0,0,11,47711,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Telestra Clone Dies (Fire)'"), -(2692800,9,4,0,0,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Reactstate Passive"), -(2692800,9,5,0,0,0,100,0,0,0,0,0,0,146,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Uninteractible"), --- Actually despawn after 3 sec, but aura can't be applied if caster is already destroyed --- (if clone is just 20 yards away from boss, aura will not be applied, breaking whole encounter) - --- Great, now, as creature can continue cast COMBAT spells while being passive AND THAT IS ACTUALLY PROBABLY CORRECT, --- but we increased despawn time to 30 sec, hackily silence it, what else we can do -(2692800,9,6,0,0,0,100,0,0,0,0,0,0,11,42201,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Eternal Silence'"), -(2692800,9,7,0,0,0,100,0,30000,30000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Despawn"), - - -(26929,0,0,0,37,0,100,0,0,0,0,0,0,42,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On AI Initialize - Set Invincibility HP 1"), -(26929,0,1,0,11,0,100,0,0,0,0,0,0,11,47704,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Spawn - Cast 'Grand Magus Telestra (Arcane) Visual'"), -(26929,0,2,0,2,0,100,1,0,1,0,0,0,80,2692900,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - Between 0-1% Health - Run Script (No Repeat)"), -(26929,0,3,0,0,0,100,0,6000,8000,12000,12000,0,11,47731,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat - Cast 'Critter'"), -(26929,0,4,0,0,0,100,0,10000,15000,15000,15000,0,11,47736,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat - Cast 'Time Stop'"), - -(2692900,9,0,0,0,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,23,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Data 0 1 (Summoner)"), -(2692900,9,1,0,0,0,100,0,0,0,0,0,0,28,47704,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Remove Aura 'Grand Magus Telestra (Arcane) Visual'"), -(2692900,9,2,0,0,0,100,0,0,0,0,0,0,11,41577,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Transform: Invisible Stalker'"), -(2692900,9,3,0,0,0,100,0,0,0,0,0,0,11,47713,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Telestra Clone Dies (Arcane)'"), -(2692900,9,4,0,0,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Reactstate Passive"), -(2692900,9,5,0,0,0,100,0,0,0,0,0,0,146,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Uninteractible"), -(2692900,9,6,0,0,0,100,0,0,0,0,0,0,11,42201,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Eternal Silence'"), -(2692900,9,7,0,0,0,100,0,30000,30000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Despawn"), - - -(26930,0,0,0,37,0,100,0,0,0,0,0,0,42,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On AI Initialize - Set Invincibility HP 1"), -(26930,0,1,0,11,0,100,0,0,0,0,0,0,11,47706,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Spawn - Cast 'Grand Magus Telestra (Frost) Visual'"), -(26930,0,2,0,2,0,100,1,0,1,0,0,0,80,2693000,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - Between 0-1% Health - Run Script (No Repeat)"), -(26930,0,3,0,0,0,100,2,0,0,1200,1200,0,11,47729,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat CMC - Cast 'Ice Barb'"), -(26930,0,4,0,0,0,100,4,0,0,1200,1200,0,11,56937,64,0,0,0,0,2,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat CMC - Cast 'Ice Barb'"), -(26930,0,5,0,0,0,100,2,8000,12000,10000,15000,0,11,47727,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat - Cast 'Blizzard'"), -(26930,0,6,0,0,0,100,4,8000,12000,10000,15000,0,11,56936,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - In Combat - Cast 'Blizzard'"), - -(2693000,9,0,0,0,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,23,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Data 0 1 (Summoner)"), -(2693000,9,1,0,0,0,100,0,0,0,0,0,0,28,47706,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Remove Aura 'Grand Magus Telestra (Frost) Visual'"), -(2693000,9,2,0,0,0,100,0,0,0,0,0,0,11,41577,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Transform: Invisible Stalker'"), -(2693000,9,3,0,0,0,100,0,0,0,0,0,0,11,47712,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Telestra Clone Dies (Frost)'"), -(2693000,9,4,0,0,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Reactstate Passive"), -(2693000,9,5,0,0,0,100,0,0,0,0,0,0,146,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Set Uninteractible"), -(2693000,9,6,0,0,0,100,0,0,0,0,0,0,11,42201,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Cast 'Eternal Silence'"), -(2693000,9,7,0,0,0,100,0,30000,30000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Grand Magus Telestra - On Script - Despawn"); diff --git a/sql/updates/world/3.3.5/2022_07_11_00_world.sql b/sql/updates/world/3.3.5/2022_07_11_00_world.sql deleted file mode 100644 index 35124d9c843..00000000000 --- a/sql/updates/world/3.3.5/2022_07_11_00_world.sql +++ /dev/null @@ -1,49 +0,0 @@ --- -DELETE FROM `smart_scripts` WHERE `entryorguid` = 5108 AND `source_type` = 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(5108,2,0,1,46,0,100,0,5108,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Areatrigger (The Stormwright's Shelf) - On Trigger - Store Targetlist"), -(5108,2,1,2,61,0,100,0,0,0,0,0,0,100,1,0,0,0,0,0,19,29079,0,0,0,0,0,0,0,"Areatrigger (The Stormwright's Shelf) - On Link - Send Target 1 (Shrine of the Tempest)"), -(5108,2,2,0,61,0,100,0,0,0,0,0,0,45,0,1,0,0,0,0,19,29079,0,0,0,0,0,0,0,"Areatrigger (The Stormwright's Shelf) - On Link - Set Data 0 1 (Shrine of the Tempest)"); - -DELETE FROM `areatrigger_scripts` WHERE `entry` = 5108; -INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES -(5108,"SmartTrigger"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 5108 AND `SourceId` = 2; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(22,1,5108,2,0,9,0,12741,0,0,0,0,0,"","Group 0: Execute SAI (Action 0) if player has taken quest 'Strength of the Tempest'"); - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 29079 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(29079,0,0,0,38,0,100,0,0,1,0,0,0,11,53062,0,0,0,0,0,12,1,0,0,0,0,0,0,0,"Shrine of the Tempest - On Data Set 0 1 - Cast 'Lightning Strike'"); - -DELETE FROM `spell_scripts` WHERE `id` = 53062; -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_sholazar_lightning_strike'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(53062,'spell_sholazar_lightning_strike'); - --- -DELETE FROM `spell_scripts` WHERE `id` = 51071; -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_sholazar_flight_to_sholazar'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(51071,'spell_sholazar_flight_to_sholazar'); - -DELETE FROM `creature_text` WHERE `CreatureID` = 28192; - --- Yes, it is unrealistic that other 8 will be used -DELETE FROM `spell_scripts` WHERE `id` IN (53341,53343); -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_chapter1_runeforging_credit'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(53323,'spell_chapter1_runeforging_credit'), -(53331,'spell_chapter1_runeforging_credit'), -(53341,'spell_chapter1_runeforging_credit'), -(53342,'spell_chapter1_runeforging_credit'), -(53343,'spell_chapter1_runeforging_credit'), -(53344,'spell_chapter1_runeforging_credit'), -(54446,'spell_chapter1_runeforging_credit'), -(54447,'spell_chapter1_runeforging_credit'), -(62158,'spell_chapter1_runeforging_credit'), -(70164,'spell_chapter1_runeforging_credit'); - --- Already scripted. -DELETE FROM `spell_scripts` WHERE `id` IN (40904,44997); diff --git a/sql/updates/world/3.3.5/2022_07_13_00_world.sql b/sql/updates/world/3.3.5/2022_07_13_00_world.sql deleted file mode 100644 index 3e8f4b34086..00000000000 --- a/sql/updates/world/3.3.5/2022_07_13_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature_template_addon` SET `bytes2` = 257 WHERE `entry` = 17551; diff --git a/sql/updates/world/3.3.5/2022_07_13_01_world.sql b/sql/updates/world/3.3.5/2022_07_13_01_world.sql deleted file mode 100644 index 4531f8c091a..00000000000 --- a/sql/updates/world/3.3.5/2022_07_13_01_world.sql +++ /dev/null @@ -1,20 +0,0 @@ --- -DELETE FROM `spell_scripts` WHERE `id` IN (57337,57397,58466,58475,66477); -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_item_great_feast', -'spell_item_fish_feast', -'spell_item_gigantic_feast', -'spell_item_small_feast', -'spell_item_bountiful_feast', -'spell_gen_feast'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(57301,'spell_item_great_feast'), -(57426,'spell_item_fish_feast'), -(58465,'spell_item_gigantic_feast'), -(58474,'spell_item_small_feast'), -(66476,'spell_item_bountiful_feast'), -(57337,'spell_gen_feast'), -(57397,'spell_gen_feast'), -(58466,'spell_gen_feast'), -(58475,'spell_gen_feast'), -(66477,'spell_gen_feast'); diff --git a/sql/updates/world/3.3.5/2022_07_17_00_world.sql b/sql/updates/world/3.3.5/2022_07_17_00_world.sql deleted file mode 100644 index f40b8ec5f6e..00000000000 --- a/sql/updates/world/3.3.5/2022_07_17_00_world.sql +++ /dev/null @@ -1,15 +0,0 @@ --- -UPDATE `spell_script_names` SET `ScriptName` = 'spell_gen_hate_to_zero_caster_target' WHERE `ScriptName` = 'spell_yogg_saron_hate_to_zero'; - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_gen_hate_to_zero', -'spell_gen_hate_to_50', -'spell_gen_hate_to_75'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(9204,'spell_gen_hate_to_zero'), -(20538,'spell_gen_hate_to_zero'), -(26569,'spell_gen_hate_to_zero'), -(26637,'spell_gen_hate_to_zero'), -(37326,'spell_gen_hate_to_zero'), -(19707,'spell_gen_hate_to_50'), -(26886,'spell_gen_hate_to_75'); diff --git a/sql/updates/world/3.3.5/2022_07_18_00_world.sql b/sql/updates/world/3.3.5/2022_07_18_00_world.sql deleted file mode 100644 index 9d215cfe2bf..00000000000 --- a/sql/updates/world/3.3.5/2022_07_18_00_world.sql +++ /dev/null @@ -1,36 +0,0 @@ --- -UPDATE `creature_template` SET `minlevel` = 1, `maxlevel` = 1, `exp` = 0 WHERE `entry` = 22444; -UPDATE `creature_template` SET `unit_flags` = 33024 WHERE `entry` = 22454; - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (22444,16878,22454) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2245400) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(22444,0,0,0,60,0,100,0,5000,5000,5000,5000,0,11,39184,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Anchorite Relic Bunny - On Update - Cast 'Anchorite Contrition'"), - -(16878,0,0,0,4,0,100,0,0,0,0,0,0,11,35570,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Shattered Hand Berserker - On Aggro - Cast 'Charge'"), -(16878,0,1,2,2,0,100,1,0,30,0,0,0,11,8599,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Hand Berserker - Between 0-30% Health - Cast 'Enrage' (No Repeat)"), -(16878,0,2,0,61,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Hand Berserker - Between 0-30% Health - Say Line 0 (No Repeat)"), -(16878,0,3,0,6,0,100,0,0,0,0,0,0,11,39190,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Shattered Hand Berserker - On Death - Cast 'Send Vengeance'"), - -(22454,0,0,0,11,0,100,0,0,0,0,0,0,80,2245400,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fel Spirit - On Spawn - Run Script"), - -(2245400,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Fel Spirit - On Script - Say Line 0"), -(2245400,9,1,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Fel Spirit - On Script - Set Orientation (Summoner)"), -(2245400,9,2,0,0,0,100,0,3000,3000,0,0,0,144,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Fel Spirit - On Script - Set ImmunePC Off"), -(2245400,9,3,0,0,0,100,0,0,0,0,0,0,49,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Fel Spirit - On Script - Start Attack Summoner"); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 16878 AND `SourceId` = 0; -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 39190; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES --- Channeled aura is removed on death > condition always is false, this should be a bit better than previous SpellHit > Phase -(22,4,16878,0,0,29,1,22444,30,0,0,0,0,"","Group 0: Execute Event (Action 3) if creature 'Anchorite Relic Bunny' is within 30 yards"), -(13,1,39190,0,0,31,0,3,22444,0,0,0,0,"","Group 0: Spell 'Send Vengeance' (Effect 0) targets creature 'Anchorite Relic Bunny'"); - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_hellfire_peninsula_send_vengeance', -'spell_hellfire_peninsula_send_vengeance_to_player'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(39190,'spell_hellfire_peninsula_send_vengeance'), -(39202,'spell_hellfire_peninsula_send_vengeance_to_player'); - -UPDATE `gameobject_template_addon` SET `flags` = 0 WHERE `entry` = 185298; diff --git a/sql/updates/world/3.3.5/2022_07_20_00_world.sql b/sql/updates/world/3.3.5/2022_07_20_00_world.sql deleted file mode 100644 index 477970228b9..00000000000 --- a/sql/updates/world/3.3.5/2022_07_20_00_world.sql +++ /dev/null @@ -1,127 +0,0 @@ --- -SET @CGUID := 132276; -- 17 - -DELETE FROM `spell_scripts` WHERE `id` = 67751; -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_black_knight_ghoul_explode', -'spell_black_knight_ghoul_explode_risen_ghoul'); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(67751,'spell_black_knight_ghoul_explode'), -(67754,'spell_black_knight_ghoul_explode_risen_ghoul'), -(67889,'spell_black_knight_ghoul_explode_risen_ghoul'); - - --- -UPDATE `creature_template` SET `flags_extra` = `flags_extra` &~ 2 WHERE `entry` = 30273; - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30273,30274) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (3027400) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(30273,0,0,0,37,0,100,0,0,0,0,0,0,116,8,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Webbed Crusader - On AI Initialize - Set Corpse Delay"), -(30273,0,1,0,37,0,100,0,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Webbed Crusader - On AI Initialize - Set Reactstate Passive"), -(30273,0,2,0,6,0,100,0,0,0,0,0,0,11,56515,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Webbed Crusader - On Death - Cast 'Summon Freed Crusader'"), - -(30274,0,0,0,11,0,100,0,0,0,0,0,0,80,3027400,2,0,0,0,0,1,0,0,0,0,0,0,0,0,"Freed Crusader - On Spawn - Run Script"), - -(3027400,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Say Line 0"), -(3027400,9,1,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Set Orientation Summoner"), -(3027400,9,2,0,0,0,100,0,0,0,0,0,0,11,56525,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Cast 'Blessing of Kings'"), -(3027400,9,3,0,0,0,100,0,0,0,0,0,0,33,30274,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Quest Credit 'Scourge Tactics'"), -(3027400,9,4,0,0,0,100,0,4000,4000,0,0,0,1,1,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Say Line 1"), -(3027400,9,5,0,0,0,100,0,0,0,0,0,0,11,56539,0,0,0,0,0,23,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Cast 'Holy Light'"), --- One of ~3 random paths\points, then despawn -(3027400,9,6,0,0,0,100,0,3000,3000,0,0,0,53,1,30274,0,0,0,0,1,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Start Waypoint"), -(3027400,9,7,0,0,0,100,0,0,0,0,0,0,41,4000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Freed Crusader - On Script - Despawn"); - -UPDATE `creature_text` SET `GroupID` = 1, `ID` = 0 WHERE `CreatureID` = 30274 AND `GroupID` = 0 AND `ID` = 3; - -DELETE FROM `spell_scripts` WHERE `id` = 56515; -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_icecrown_summon_freed_crusader'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(56515,'spell_icecrown_summon_freed_crusader'); - - --- -DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+00 AND @CGUID+16 AND `id` = 29686; -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES -(@CGUID+00,29686,571,0,0,1,1,0,0,4810.87,-2350.84,238.935,0.20944,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+01,29686,571,0,0,1,1,0,0,4832.77,-2376.45,235.068,0.314159,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+02,29686,571,0,0,1,1,0,0,4857.28,-2385.37,234.187,1.27409,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+03,29686,571,0,0,1,1,0,0,4861.24,-2295.76,244.068,2.40855,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+04,29686,571,0,0,1,1,0,0,4861.6,-2359.89,234.864,4.93928,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+05,29686,571,0,0,1,1,0,0,4871.34,-2369.81,234.509,2.75762,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+06,29686,571,0,0,1,1,0,0,4872.12,-2324.38,239.137,4.72984,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+07,29686,571,0,0,1,1,0,0,4878.67,-2384.11,234.211,2.32129,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+08,29686,571,0,0,1,1,0,0,4907.5,-2281.84,244.421,3.78736,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+09,29686,571,0,0,1,1,0,0,4920.46,-2283.21,243.879,5.58505,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+10,29686,571,0,0,1,1,0,0,4923.23,-2367.81,241.606,0.226893,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+11,29686,571,0,0,1,1,0,0,4929.72,-2299.41,244.346,1.46608,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+12,29686,571,0,0,1,1,0,0,4941.36,-2299.2,244.354,1.58825,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+13,29686,571,0,0,1,1,0,0,4965.36,-2314.32,245.154,4.86947,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+14,29686,571,0,0,1,1,0,0,4972,-2341.04,245.81,1.78024,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+15,29686,571,0,0,1,1,0,0,4972.22,-2354.94,245.45,4.46804,30,0,0,0,0,0,0,0,0,'',12340), -(@CGUID+16,29686,571,0,0,1,1,0,0,4990.17,-2360.19,246.498,2.28638,30,0,0,0,0,0,0,0,0,'',12340); - -UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` IN (29686,29700); - -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (29686,29700) AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2968600) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(29686,0,0,0,11,0,100,0,0,0,0,0,0,11,54990,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Spawn - Cast 'Chains of the Scourge'"), -(29686,0,1,0,8,0,100,1,55083,0,0,0,0,80,2968600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Spellhit 'Unlock Shackle' - Run Script (No Repeat)"), - -(2968600,9,0,0,0,0,100,0,0,0,0,0,0,92,0,54990,1,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Interrupt Spell 'Chains of the Scourge'"), -(2968600,9,1,0,0,0,100,0,0,0,0,0,0,11,55085,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Cast 'Unshackled!'"), -(2968600,9,2,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Say Line 0"), -(2968600,9,3,0,0,0,100,0,0,0,0,0,0,89,10,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Start Random Movement"), -(2968600,9,4,0,0,0,100,0,0,0,0,0,0,145,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Set ImmuneNPC Off"), -(2968600,9,5,0,0,0,100,0,0,0,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Remove Flag Standstate Kneel"), -(2968600,9,6,0,0,0,100,0,0,0,0,0,0,33,29686,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Quest Credit 'Trolls Is Gone Crazy!'"), -(2968600,9,7,0,0,0,100,0,10000,10000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Captured Rageclaw - On Script - Despawn"), - -(29700,0,0,0,8,0,100,0,55083,0,0,0,0,92,0,55009,1,0,0,0,1,0,0,0,0,0,0,0,0,"Drakuru Shackles - On Spellhit 'Unlock Shackle' - Interrupt Spell 'Chains of the Scourge'"); - --- 55223 is not used -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` IN (55223,55083); -INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES -(13,1,55083,0,0,31,0,3,29700,0,0,0,0,"","Group 0: Spell 'Unlock Shackle' (Effect 0) targets creature 'Drakuru Shackles'"), -(13,2,55083,0,0,31,0,3,29686,0,0,0,0,"","Group 0: Spell 'Unlock Shackle' (Effect 1) targets creature 'Captured Rageclaw'"); - -DELETE FROM `spell_scripts` WHERE `id` = 54990; -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_zuldrak_chains_of_the_scourge'; -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(54990,'spell_zuldrak_chains_of_the_scourge'); - - --- -DELETE FROM `spell_scripts` WHERE `id` = 52741; - -DELETE FROM `smart_scripts` WHERE `entryorguid` = 29329 AND `source_type` = 0 AND `id` IN (2,3,4); -DELETE FROM `smart_scripts` WHERE `entryorguid` = 29330 AND `source_type` = 0 AND `id` IN (2,3,4); -DELETE FROM `smart_scripts` WHERE `entryorguid` = 29333 AND `source_type` = 0 AND `id` IN (0,1,2); -DELETE FROM `smart_scripts` WHERE `entryorguid` = 29338 AND `source_type` = 0 AND `id` IN (2,3,4); -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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(29329,0,2,3,8,0,100,1,52741,0,0,0,0,11,54415,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Paladin - On Spellhit 'Darkmender's Tincture' - Cast 'Summon Corrupted Scarlet Onslaught' (No Repeat)"), -(29329,0,3,4,61,0,100,0,0,0,0,0,0,33,29398,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Paladin - On Spellhit 'Darkmender's Tincture' - Quest Credit 'From Their Corpses, Rise!'"), -(29329,0,4,0,61,0,100,0,0,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Paladin - On Spellhit 'Darkmender's Tincture' - Despawn"), - -(29330,0,2,3,8,0,100,1,52741,0,0,0,0,11,54415,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Harbor Guard - On Spellhit 'Darkmender's Tincture' - Cast 'Summon Corrupted Scarlet Onslaught' (No Repeat)"), -(29330,0,3,4,61,0,100,0,0,0,0,0,0,33,29398,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Harbor Guard - On Spellhit 'Darkmender's Tincture' - Quest Credit 'From Their Corpses, Rise!'"), -(29330,0,4,0,61,0,100,0,0,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Harbor Guard - On Spellhit 'Darkmender's Tincture' - Despawn"), - -(29333,0,0,1,8,0,100,1,52741,0,0,0,0,11,54415,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Gryphon Rider - On Spellhit 'Darkmender's Tincture' - Cast 'Summon Corrupted Scarlet Onslaught' (No Repeat)"), -(29333,0,1,2,61,0,100,0,0,0,0,0,0,33,29398,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Gryphon Rider - On Spellhit 'Darkmender's Tincture' - Quest Credit 'From Their Corpses, Rise!'"), -(29333,0,2,0,61,0,100,0,0,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Gryphon Rider - On Spellhit 'Darkmender's Tincture' - Despawn"), - -(29338,0,2,3,8,0,100,1,52741,0,0,0,0,11,54415,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Bishop - On Spellhit 'Darkmender's Tincture' - Cast 'Summon Corrupted Scarlet Onslaught' (No Repeat)"), -(29338,0,3,4,61,0,100,0,0,0,0,0,0,33,29398,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Onslaught Raven Bishop - On Spellhit 'Darkmender's Tincture' - Quest Credit 'From Their Corpses, Rise!'"), -(29338,0,4,0,61,0,100,0,0,0,0,0,0,41,1000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Onslaught Raven Bishop - On Spellhit 'Darkmender's Tincture' - Despawn"); - -UPDATE `creature_template` SET `unit_flags` = 33280 WHERE `entry` = 29400; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 29400 AND `source_type` = 0; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 2940000 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES -(29400,0,0,0,11,0,100,0,0,0,0,0,0,80,2940000,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Scarlet Onslaught - On Spawn - Run Script"), -(29400,0,1,0,0,0,100,0,2000,15000,30000,45000,0,11,38056,0,0,0,0,0,2,0,0,0,0,0,0,0,0,"Corrupted Scarlet Onslaught - In Combat - Cast 'Flesh Rip'"), - -(2940000,9,0,0,0,0,100,0,2000,2000,0,0,0,145,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Corrupted Scarlet Onslaught - On Script - Set ImmuneNPC Off"); diff --git a/sql/updates/world/3.3.5/2022_08_04_00_world.sql b/sql/updates/world/3.3.5/2022_08_04_00_world.sql deleted file mode 100644 index c9197ca6c21..00000000000 --- a/sql/updates/world/3.3.5/2022_08_04_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature_template` SET `DamageModifier` = 1.5 WHERE `entry` = 29851; diff --git a/sql/updates/world/3.3.5/2022_08_04_01_world.sql b/sql/updates/world/3.3.5/2022_08_04_01_world.sql deleted file mode 100644 index 2fd6575f4c6..00000000000 --- a/sql/updates/world/3.3.5/2022_08_04_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `reference_loot_template` SET `entry`=34211 WHERE `entry`=34215 AND `Item`=40811; diff --git a/sql/updates/world/3.3.5/2022_08_15_00_world.sql b/sql/updates/world/3.3.5/2022_08_15_00_world.sql new file mode 100644 index 00000000000..51f6a53e5ff --- /dev/null +++ b/sql/updates/world/3.3.5/2022_08_15_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.22081 world +UPDATE `version` SET `db_version`='TDB 335.22081', `cache_id`=22081 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; |
