diff options
| author | dr-j <dr-j@users.noreply.github.com> | 2019-11-17 21:23:02 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-19 00:41:21 +0100 |
| commit | 56dff4c6c659584536a504dba57093faed02710a (patch) | |
| tree | fe0d421d2449e4eea6f86d15c12060a583932bd7 | |
| parent | e42aae18952d198680f4215d16175d274d4be179 (diff) | |
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)
| -rw-r--r-- | sql/updates/world/master/2021_12_18_68_world_2019_11_17_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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); |