From 6dd5fb9d88e7a8b7da696bbe7b96947217b1ace2 Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 19 Nov 2024 21:40:49 +0100 Subject: Core/Auras: Implemented mount equipment --- sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql | 13 +++++++++++++ sql/updates/world/master/2024_11_19_00_world.sql | 5 +++++ 2 files changed, 18 insertions(+) create mode 100644 sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql create mode 100644 sql/updates/world/master/2024_11_19_00_world.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql new file mode 100644 index 00000000000..678c526c8e2 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_11_19_00_hotfixes.sql @@ -0,0 +1,13 @@ +-- +-- Table structure for table `mount_equipment` +-- +DROP TABLE IF EXISTS `mount_equipment`; +CREATE TABLE `mount_equipment` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Item` int NOT NULL DEFAULT '0', + `BuffSpell` int NOT NULL DEFAULT '0', + `Unknown820` int NOT NULL DEFAULT '0', + `LearnedBySpell` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/sql/updates/world/master/2024_11_19_00_world.sql b/sql/updates/world/master/2024_11_19_00_world.sql new file mode 100644 index 00000000000..dc2c1212fb1 --- /dev/null +++ b/sql/updates/world/master/2024_11_19_00_world.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_comfortable_riders_barding'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_saddlechute'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(296837, 'spell_gen_comfortable_riders_barding'), +(297091, 'spell_gen_saddlechute'); -- cgit v1.2.3