diff options
| author | Killyana <morphone1@gmail.com> | 2020-04-27 00:57:21 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-01 21:42:51 +0100 |
| commit | 567b26e0c7342b3484f7d5763ddee496e44262bb (patch) | |
| tree | 0e12ca46fec49fe390811e0261a8de9ddb1546b8 /sql | |
| parent | 4cd76638ae992a8e8b821c3b150a5fed0aa76a89 (diff) | |
DB/Pet: Toxic Wasteling
Closes #12773
(cherry picked from commit 3f5e0927c3e7e3c0fc471f9d8dd4944b270dc40e)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_01_01_37_world_2020_04_26_03_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_37_world_2020_04_26_03_world.sql b/sql/updates/world/master/2022_01_01_37_world_2020_04_26_03_world.sql new file mode 100644 index 00000000000..d52e10c9f39 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_37_world_2020_04_26_03_world.sql @@ -0,0 +1,16 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` IN (71849); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17, 0, 71849, 0, 24, 1, 8, 0, 0, 0, '', "Toxic Wasteling Find Target hits only critters"); + +DELETE FROM `creature_template_addon` WHERE `entry` = 38374; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(38374, 0, 0, 0, 0, 0, '71849'); + +DELETE FROM `spell_scripts` WHERE `id` IN (71848 ,71874,26264); +INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(71848 ,0,0,15,71847,0,0,0,0,0,0), +(71848 ,0,1,15,71874,0,0,0,0,0,0), +(71874 ,1,1,15,71854,1,0,0,0,0,0), +(71874 ,1,1,15,26264,2,0,0,0,0,0), +(26264 ,0,0,18,0,0,0,0,0,0,0); |