From 56dff4c6c659584536a504dba57093faed02710a Mon Sep 17 00:00:00 2001 From: dr-j Date: Sun, 17 Nov 2019 21:23:02 +0100 Subject: DB/SAI: Jack Likes His Drink Use dbc spell to create the item instead of SAI action 56 Closes #23922 (cherry picked from commit 343453587109c8de4fe2d8ede76e67832f33d818) --- sql/updates/world/master/2021_12_18_68_world_2019_11_17_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/master/2021_12_18_68_world_2019_11_17_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_12_18_68_world_2019_11_17_00_world.sql b/sql/updates/world/master/2021_12_18_68_world_2019_11_17_00_world.sql new file mode 100644 index 00000000000..6d6aaa66138 --- /dev/null +++ b/sql/updates/world/master/2021_12_18_68_world_2019_11_17_00_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `smart_scripts` SET `action_type`=134, `action_param1`=44428 WHERE `entryorguid`=24788 AND `source_type`=0 AND `id`=3 AND `link`=4; +DELETE FROM `serverside_spell_effect` WHERE `SpellID`=44428; +INSERT INTO `serverside_spell_effect` (`SpellID`, `Effect`, `EffectItemType`, `ImplicitTarget1`) VALUES +(44428, 24, 34116, 0); -- cgit v1.2.3