From 40d1f7a2e8fa54b3c9432b4432d6df968ec60cc4 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Wed, 14 Jun 2023 19:37:17 +0000 Subject: TDB 335.23061 - 2023/06/14 --- revision_data.h.in.cmake | 2 +- sql/base/auth_database.sql | 19 +- sql/base/characters_database.sql | 21 +- sql/base/dev/world_database.sql | 482 ++++++++++----------- .../auth/23011_2023_06_14/2023_01_16_00_auth.sql | 2 + .../auth/23011_2023_06_14/2023_02_05_00_auth.sql | 19 + .../auth/23011_2023_06_14/2023_02_05_01_auth.sql | 2 + .../auth/23011_2023_06_14/2023_05_05_00_auth.sql | 2 + .../23011_2023_06_14/2023_01_16_00_characters.sql | 2 + .../23011_2023_06_14/2023_02_05_00_characters.sql | 91 ++++ .../23011_2023_06_14/2023_02_05_01_characters.sql | 2 + .../world/23011_2023_06_14/2023_01_16_00_world.sql | 3 + .../world/23011_2023_06_14/2023_03_24_00_world.sql | 86 ++++ .../world/23011_2023_06_14/2023_04_05_00_world.sql | 6 + .../world/23011_2023_06_14/2023_04_05_01_world.sql | 2 + .../world/23011_2023_06_14/2023_04_05_02_world.sql | 2 + .../world/23011_2023_06_14/2023_04_05_03_world.sql | 2 + .../world/23011_2023_06_14/2023_04_05_04_world.sql | 2 + .../world/23011_2023_06_14/2023_04_05_05_world.sql | 2 + .../world/23011_2023_06_14/2023_04_05_06_world.sql | 4 + .../world/23011_2023_06_14/2023_04_06_00_world.sql | 33 ++ .../world/23011_2023_06_14/2023_04_06_01_world.sql | 2 + .../world/23011_2023_06_14/2023_04_06_02_world.sql | 2 + .../world/23011_2023_06_14/2023_04_06_03_world.sql | 3 + .../world/23011_2023_06_14/2023_04_06_04_world.sql | 5 + .../world/23011_2023_06_14/2023_04_06_05_world.sql | 2 + .../world/23011_2023_06_14/2023_04_06_06_world.sql | 6 + .../world/23011_2023_06_14/2023_04_06_07_world.sql | 9 + .../world/23011_2023_06_14/2023_04_07_00_world.sql | 24 + .../world/23011_2023_06_14/2023_04_08_00_world.sql | 17 + .../world/23011_2023_06_14/2023_04_08_01_world.sql | 15 + .../world/23011_2023_06_14/2023_04_20_00_world.sql | 2 + .../world/23011_2023_06_14/2023_04_25_00_world.sql | 7 + .../world/23011_2023_06_14/2023_04_28_00_world.sql | 9 + .../world/23011_2023_06_14/2023_04_29_00_world.sql | 2 + .../world/23011_2023_06_14/2023_04_29_01_world.sql | 13 + .../world/23011_2023_06_14/2023_05_05_00_world.sql | 10 + .../world/23011_2023_06_14/2023_05_07_00_world.sql | 3 + .../world/23011_2023_06_14/2023_05_07_01_world.sql | 2 + .../world/23011_2023_06_14/2023_05_09_00_world.sql | 5 + .../world/23011_2023_06_14/2023_05_09_01_world.sql | 4 + .../world/23011_2023_06_14/2023_05_10_00_world.sql | 4 + .../world/23011_2023_06_14/2023_05_11_00_world.sql | 9 + .../world/23011_2023_06_14/2023_05_14_00_world.sql | 10 + .../world/23011_2023_06_14/2023_05_14_01_world.sql | 2 + .../world/23011_2023_06_14/2023_05_15_00_world.sql | 23 + .../world/23011_2023_06_14/2023_05_15_01_world.sql | 2 + .../world/23011_2023_06_14/2023_05_16_00_world.sql | 5 + .../world/23011_2023_06_14/2023_05_17_00_world.sql | 2 + .../world/23011_2023_06_14/2023_06_11_00_world.sql | 83 ++++ .../world/23011_2023_06_14/2023_06_11_01_world.sql | 5 + .../world/23011_2023_06_14/2023_06_11_02_world.sql | 5 + .../world/23011_2023_06_14/2023_06_11_03_world.sql | 5 + .../world/23011_2023_06_14/2023_06_11_04_world.sql | 35 ++ .../world/23011_2023_06_14/2023_06_11_05_world.sql | 5 + sql/updates/auth/3.3.5/2023_01_16_00_auth.sql | 2 - sql/updates/auth/3.3.5/2023_02_05_00_auth.sql | 19 - sql/updates/auth/3.3.5/2023_02_05_01_auth.sql | 2 - sql/updates/auth/3.3.5/2023_05_05_00_auth.sql | 2 - sql/updates/auth/3.3.5/2023_06_14_00_auth.sql | 2 + .../characters/3.3.5/2023_01_16_00_characters.sql | 2 - .../characters/3.3.5/2023_02_05_00_characters.sql | 91 ---- .../characters/3.3.5/2023_02_05_01_characters.sql | 2 - .../characters/3.3.5/2023_06_14_00_characters.sql | 2 + sql/updates/world/3.3.5/2023_01_16_00_world.sql | 3 - sql/updates/world/3.3.5/2023_03_24_00_world.sql | 86 ---- sql/updates/world/3.3.5/2023_04_05_00_world.sql | 6 - sql/updates/world/3.3.5/2023_04_05_01_world.sql | 2 - sql/updates/world/3.3.5/2023_04_05_02_world.sql | 2 - sql/updates/world/3.3.5/2023_04_05_03_world.sql | 2 - sql/updates/world/3.3.5/2023_04_05_04_world.sql | 2 - sql/updates/world/3.3.5/2023_04_05_05_world.sql | 2 - sql/updates/world/3.3.5/2023_04_05_06_world.sql | 4 - sql/updates/world/3.3.5/2023_04_06_00_world.sql | 33 -- sql/updates/world/3.3.5/2023_04_06_01_world.sql | 2 - sql/updates/world/3.3.5/2023_04_06_02_world.sql | 2 - sql/updates/world/3.3.5/2023_04_06_03_world.sql | 3 - sql/updates/world/3.3.5/2023_04_06_04_world.sql | 5 - sql/updates/world/3.3.5/2023_04_06_05_world.sql | 2 - sql/updates/world/3.3.5/2023_04_06_06_world.sql | 6 - sql/updates/world/3.3.5/2023_04_06_07_world.sql | 9 - sql/updates/world/3.3.5/2023_04_07_00_world.sql | 24 - sql/updates/world/3.3.5/2023_04_08_00_world.sql | 17 - sql/updates/world/3.3.5/2023_04_08_01_world.sql | 15 - sql/updates/world/3.3.5/2023_04_20_00_world.sql | 2 - sql/updates/world/3.3.5/2023_04_25_00_world.sql | 7 - sql/updates/world/3.3.5/2023_04_28_00_world.sql | 9 - sql/updates/world/3.3.5/2023_04_29_00_world.sql | 2 - sql/updates/world/3.3.5/2023_04_29_01_world.sql | 13 - sql/updates/world/3.3.5/2023_05_05_00_world.sql | 10 - sql/updates/world/3.3.5/2023_05_07_00_world.sql | 3 - sql/updates/world/3.3.5/2023_05_07_01_world.sql | 2 - sql/updates/world/3.3.5/2023_05_09_00_world.sql | 5 - sql/updates/world/3.3.5/2023_05_09_01_world.sql | 4 - sql/updates/world/3.3.5/2023_05_10_00_world.sql | 4 - sql/updates/world/3.3.5/2023_05_11_00_world.sql | 9 - sql/updates/world/3.3.5/2023_05_14_00_world.sql | 10 - sql/updates/world/3.3.5/2023_05_14_01_world.sql | 2 - sql/updates/world/3.3.5/2023_05_15_00_world.sql | 23 - sql/updates/world/3.3.5/2023_05_15_01_world.sql | 2 - sql/updates/world/3.3.5/2023_05_16_00_world.sql | 5 - sql/updates/world/3.3.5/2023_05_17_00_world.sql | 2 - sql/updates/world/3.3.5/2023_06_11_00_world.sql | 83 ---- sql/updates/world/3.3.5/2023_06_11_01_world.sql | 5 - sql/updates/world/3.3.5/2023_06_11_02_world.sql | 5 - sql/updates/world/3.3.5/2023_06_11_03_world.sql | 5 - sql/updates/world/3.3.5/2023_06_11_04_world.sql | 35 -- sql/updates/world/3.3.5/2023_06_11_05_world.sql | 5 - sql/updates/world/3.3.5/2023_06_14_00_world.sql | 3 + 109 files changed, 869 insertions(+), 860 deletions(-) create mode 100644 sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql create mode 100644 sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql create mode 100644 sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql create mode 100644 sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql create mode 100644 sql/old/3.3.5a/characters/23011_2023_06_14/2023_01_16_00_characters.sql create mode 100644 sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_00_characters.sql create mode 100644 sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_01_characters.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_01_16_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_03_24_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_02_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_03_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_04_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_05_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_06_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_02_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_03_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_04_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_05_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_06_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_07_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_07_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_20_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_25_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_28_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_05_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_10_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_11_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_16_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_05_17_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_00_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_01_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_02_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_03_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_04_world.sql create mode 100644 sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_05_world.sql delete mode 100644 sql/updates/auth/3.3.5/2023_01_16_00_auth.sql delete mode 100644 sql/updates/auth/3.3.5/2023_02_05_00_auth.sql delete mode 100644 sql/updates/auth/3.3.5/2023_02_05_01_auth.sql delete mode 100644 sql/updates/auth/3.3.5/2023_05_05_00_auth.sql create mode 100644 sql/updates/auth/3.3.5/2023_06_14_00_auth.sql delete mode 100644 sql/updates/characters/3.3.5/2023_01_16_00_characters.sql delete mode 100644 sql/updates/characters/3.3.5/2023_02_05_00_characters.sql delete mode 100644 sql/updates/characters/3.3.5/2023_02_05_01_characters.sql create mode 100644 sql/updates/characters/3.3.5/2023_06_14_00_characters.sql delete mode 100644 sql/updates/world/3.3.5/2023_01_16_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_03_24_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_03_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_04_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_05_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_05_06_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_03_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_04_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_05_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_06_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_06_07_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_07_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_08_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_08_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_20_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_25_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_28_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_29_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_04_29_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_05_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_07_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_07_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_09_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_09_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_10_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_11_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_14_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_14_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_15_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_15_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_16_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_05_17_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_06_11_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_06_11_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_06_11_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_06_11_03_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_06_11_04_world.sql delete mode 100644 sql/updates/world/3.3.5/2023_06_11_05_world.sql create mode 100644 sql/updates/world/3.3.5/2023_06_14_00_world.sql diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake index 4e2b74cc38b..4a1c531fcc9 100644 --- a/revision_data.h.in.cmake +++ b/revision_data.h.in.cmake @@ -9,7 +9,7 @@ #define _SOURCE_DIRECTORY R"(@CMAKE_SOURCE_DIR@)" #define _BUILD_DIRECTORY R"(@BUILDDIR@)" #define _MYSQL_EXECUTABLE R"(@MYSQL_EXECUTABLE@)" - #define _FULL_DATABASE "TDB_full_world_335.23011_2023_01_16.sql" + #define _FULL_DATABASE "TDB_full_world_335.23061_2023_06_14.sql" #define VER_COMPANYNAME_STR "TrinityCore Developers" #define VER_LEGALCOPYRIGHT_STR "(c)2008-@rev_year@ TrinityCore" #define VER_FILEVERSION 0,0,0 diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 876cee1e60a..0018c699df4 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,13 +1,13 @@ --- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64) -- -- Host: localhost Database: auth -- ------------------------------------------------------ --- Server version 8.0.31-0ubuntu0.20.04.2 +-- Server version 8.0.33-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!50503 SET NAMES utf8mb4 */; +/*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; @@ -2005,9 +2005,10 @@ INSERT INTO `updates` VALUES ('2022_08_15_00_auth.sql','9EED4B445CAEC5337879206849A5C194872F228D','ARCHIVED','2022-08-15 11:21:17',0), ('2022_10_17_00_auth.sql','EB711C5B9B3272A05DDF47CA998F87E5DE6DE238','ARCHIVED','2022-10-17 09:02:28',0), ('2023_01_16_00_auth.sql','8431F03DE6A036BEED6682C21F4B67F384390905','ARCHIVED','2023-01-16 11:06:30',0), -('2023_02_05_00_auth.sql','DC8A2046EB4201D55342C541A0E9C398499E12B1','RELEASED','2023-02-05 14:50:30',0), -('2023_02_05_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0), -('2023_05_05_00_auth.sql','DEEB1D5533658E3479FC3C988EF4B9816C511BC3','RELEASED','2023-05-07 11:52:00',0); +('2023_02_05_00_auth.sql','DC8A2046EB4201D55342C541A0E9C398499E12B1','ARCHIVED','2023-02-05 14:50:30',0), +('2023_02_05_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0), +('2023_05_05_00_auth.sql','DEEB1D5533658E3479FC3C988EF4B9816C511BC3','ARCHIVED','2023-05-07 11:52:00',0), +('2023_06_14_00_auth.sql','BB8A7EB214F4F3632C4F54EA596CB7C8FBA305D5','ARCHIVED','2023-06-14 19:34:24',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2032,9 +2033,9 @@ CREATE TABLE `updates_include` ( LOCK TABLES `updates_include` WRITE; /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; INSERT INTO `updates_include` VALUES -('$/sql/updates/auth','RELEASED'), ('$/sql/custom/auth','RELEASED'), -('$/sql/old/3.3.5a/auth','ARCHIVED'); +('$/sql/old/3.3.5a/auth','ARCHIVED'), +('$/sql/updates/auth','RELEASED'); /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; UNLOCK TABLES; @@ -2146,4 +2147,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2023-01-16 11:08:17 +-- Dump completed on 2023-06-14 19:34:37 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index b2dc3eaa1cf..7edbe051fa2 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,13 +1,13 @@ --- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 8.0.31-0ubuntu0.20.04.2 +-- Server version 8.0.33-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; -/*!50503 SET NAMES utf8mb4 */; +/*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; @@ -2604,8 +2604,8 @@ INSERT INTO `updates` VALUES ('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0), ('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0), ('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0), -('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0), ('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0), +('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0), ('2015_10_06_00_characters.sql','16842FDD7E8547F2260D3312F53EFF8761EFAB35','ARCHIVED','2015-10-06 16:06:38',0), ('2015_10_07_00_characters.sql','E15AB463CEBE321001D7BFDEA4B662FF618728FD','ARCHIVED','2015-10-07 23:32:00',0), ('2015_10_12_00_characters.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-10-12 15:35:47',0), @@ -2678,9 +2678,10 @@ INSERT INTO `updates` VALUES ('2022_08_15_00_characters.sql','B2468D3323AB51872385A0B36EF66688C4F661EA','ARCHIVED','2022-08-15 11:21:17',0), ('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0), ('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0), -('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','RELEASED','2023-01-16 14:51:30',0), -('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0), -('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','RELEASED','2023-05-19 18:40:42',0); +('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','ARCHIVED','2023-01-16 14:51:30',0), +('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0), +('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0), +('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2705,9 +2706,9 @@ CREATE TABLE `updates_include` ( LOCK TABLES `updates_include` WRITE; /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; INSERT INTO `updates_include` VALUES -('$/sql/updates/characters','RELEASED'), ('$/sql/custom/characters','RELEASED'), -('$/sql/old/3.3.5a/characters','ARCHIVED'); +('$/sql/old/3.3.5a/characters','ARCHIVED'), +('$/sql/updates/characters','RELEASED'); /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; UNLOCK TABLES; @@ -2851,4 +2852,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2023-01-16 11:08:17 +-- Dump completed on 2023-06-14 19:34:37 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 6136160325f..15f9e206042 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 8.0.31-0ubuntu0.20.04.2 +-- Server version 8.0.33-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -33,8 +33,8 @@ CREATE TABLE `access_requirement` ( `quest_done_A` int unsigned NOT NULL DEFAULT '0', `quest_done_H` int unsigned NOT NULL DEFAULT '0', `completed_achievement` int unsigned NOT NULL DEFAULT '0', - `quest_failed_text` mediumtext COLLATE utf8mb4_unicode_ci, - `comment` mediumtext COLLATE utf8mb4_unicode_ci, + `quest_failed_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`mapId`,`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Access Requirements'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -51,7 +51,7 @@ CREATE TABLE `achievement_criteria_data` ( `type` tinyint unsigned NOT NULL DEFAULT '0', `value1` int unsigned NOT NULL DEFAULT '0', `value2` int unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`criteria_id`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Achievment system'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -88,8 +88,8 @@ CREATE TABLE `achievement_reward` ( `TitleH` int unsigned NOT NULL DEFAULT '0', `ItemID` int unsigned NOT NULL DEFAULT '0', `Sender` int unsigned NOT NULL DEFAULT '0', - `Subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `Body` mediumtext COLLATE utf8mb4_unicode_ci, + `Subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MailTemplateID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; @@ -104,9 +104,9 @@ DROP TABLE IF EXISTS `achievement_reward_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `achievement_reward_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Subject` mediumtext COLLATE utf8mb4_unicode_ci, - `Body` mediumtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Subject` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -134,7 +134,7 @@ DROP TABLE IF EXISTS `areatrigger_scripts`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_scripts` ( `entry` int NOT NULL, - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -148,7 +148,7 @@ DROP TABLE IF EXISTS `areatrigger_tavern`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_tavern` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `name` mediumtext COLLATE utf8mb4_unicode_ci, + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -162,13 +162,13 @@ DROP TABLE IF EXISTS `areatrigger_teleport`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_teleport` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Name` mediumtext COLLATE utf8mb4_unicode_ci, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `target_map` smallint unsigned NOT NULL DEFAULT '0', `target_position_x` float NOT NULL DEFAULT '0', `target_position_y` float NOT NULL DEFAULT '0', `target_position_z` float NOT NULL DEFAULT '0', `target_orientation` float NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`), FULLTEXT KEY `name` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; @@ -183,8 +183,8 @@ DROP TABLE IF EXISTS `battlefield_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battlefield_template` ( `TypeId` tinyint unsigned NOT NULL, - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `comment` mediumtext COLLATE utf8mb4_unicode_ci + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -207,8 +207,8 @@ CREATE TABLE `battleground_template` ( `HordeStartO` float NOT NULL, `StartMaxDist` float NOT NULL DEFAULT '0', `Weight` tinyint unsigned NOT NULL DEFAULT '1', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Comment` char(32) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -237,8 +237,8 @@ DROP TABLE IF EXISTS `broadcast_text`; CREATE TABLE `broadcast_text` ( `ID` int unsigned NOT NULL DEFAULT '0', `LanguageID` int unsigned NOT NULL DEFAULT '0', - `Text` longtext COLLATE utf8mb4_unicode_ci, - `Text1` longtext COLLATE utf8mb4_unicode_ci, + `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `EmoteID1` int unsigned NOT NULL DEFAULT '0', `EmoteID2` int unsigned NOT NULL DEFAULT '0', `EmoteID3` int unsigned NOT NULL DEFAULT '0', @@ -262,10 +262,10 @@ DROP TABLE IF EXISTS `broadcast_text_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `broadcast_text_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text` mediumtext COLLATE utf8mb4_unicode_ci, - `Text1` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -278,8 +278,8 @@ DROP TABLE IF EXISTS `command`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `command` ( - `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `help` longtext COLLATE utf8mb4_unicode_ci, + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `help` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -305,8 +305,8 @@ CREATE TABLE `conditions` ( `NegativeCondition` tinyint unsigned NOT NULL DEFAULT '0', `ErrorType` int unsigned NOT NULL DEFAULT '0', `ErrorTextId` int unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Condition System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -341,7 +341,7 @@ CREATE TABLE `creature` ( `npcflag` int unsigned NOT NULL DEFAULT '0', `unit_flags` int unsigned NOT NULL DEFAULT '0', `dynamicflags` int unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci DEFAULT '', + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `VerifiedBuild` int DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_map` (`map`), @@ -368,7 +368,7 @@ CREATE TABLE `creature_addon` ( `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0', `emote` int unsigned NOT NULL DEFAULT '0', `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0', - `auras` mediumtext COLLATE utf8mb4_unicode_ci, + `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -393,7 +393,7 @@ CREATE TABLE `creature_classlevelstats` ( `damage_base` float NOT NULL DEFAULT '0', `damage_exp1` float NOT NULL DEFAULT '0', `damage_exp2` float NOT NULL DEFAULT '0', - `comment` mediumtext COLLATE utf8mb4_unicode_ci, + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`level`,`class`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -425,7 +425,7 @@ CREATE TABLE `creature_equip_template` ( `ItemID1` int unsigned NOT NULL DEFAULT '0', `ItemID2` int unsigned NOT NULL DEFAULT '0', `ItemID3` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`CreatureID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -466,7 +466,7 @@ CREATE TABLE `creature_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -570,7 +570,7 @@ CREATE TABLE `creature_questitem` ( `CreatureEntry` int unsigned NOT NULL DEFAULT '0', `Idx` int unsigned NOT NULL DEFAULT '0', `ItemId` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`CreatureEntry`,`Idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -607,7 +607,7 @@ CREATE TABLE `creature_summon_groups` ( `orientation` float NOT NULL DEFAULT '0', `summonType` tinyint unsigned NOT NULL DEFAULT '0', `summonTime` int unsigned NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -629,9 +629,9 @@ CREATE TABLE `creature_template` ( `modelid2` int unsigned NOT NULL DEFAULT '0', `modelid3` int unsigned NOT NULL DEFAULT '0', `modelid4` int unsigned NOT NULL DEFAULT '0', - `name` char(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', - `subname` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `IconName` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `subname` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `IconName` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gossip_menu_id` int unsigned NOT NULL DEFAULT '0', `minlevel` tinyint unsigned NOT NULL DEFAULT '1', `maxlevel` tinyint unsigned NOT NULL DEFAULT '1', @@ -661,7 +661,7 @@ CREATE TABLE `creature_template` ( `VehicleId` int unsigned NOT NULL DEFAULT '0', `mingold` int unsigned NOT NULL DEFAULT '0', `maxgold` int unsigned NOT NULL DEFAULT '0', - `AIName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `AIName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `MovementType` tinyint unsigned NOT NULL DEFAULT '0', `HoverHeight` float NOT NULL DEFAULT '1', `HealthModifier` float NOT NULL DEFAULT '1', @@ -675,8 +675,8 @@ CREATE TABLE `creature_template` ( `mechanic_immune_mask` int unsigned NOT NULL DEFAULT '0', `spell_school_immune_mask` int unsigned NOT NULL DEFAULT '0', `flags_extra` int unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `VerifiedBuild` smallint DEFAULT '0', + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`), KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; @@ -701,7 +701,7 @@ CREATE TABLE `creature_template_addon` ( `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0', `emote` int unsigned NOT NULL DEFAULT '0', `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0', - `auras` mediumtext COLLATE utf8mb4_unicode_ci, + `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -715,10 +715,10 @@ DROP TABLE IF EXISTS `creature_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_locale` ( `entry` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name` mediumtext COLLATE utf8mb4_unicode_ci, - `Title` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -754,7 +754,7 @@ CREATE TABLE `creature_template_resistance` ( `CreatureID` int unsigned NOT NULL, `School` tinyint unsigned NOT NULL, `Resistance` smallint DEFAULT NULL, - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`CreatureID`,`School`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -770,7 +770,7 @@ CREATE TABLE `creature_template_spell` ( `CreatureID` int unsigned NOT NULL, `Index` tinyint unsigned NOT NULL DEFAULT '0', `Spell` int unsigned NOT NULL, - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`CreatureID`,`Index`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -786,7 +786,7 @@ CREATE TABLE `creature_text` ( `CreatureID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '0', - `Text` longtext COLLATE utf8mb4_unicode_ci, + `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Type` tinyint unsigned NOT NULL DEFAULT '0', `Language` tinyint NOT NULL DEFAULT '0', `Probability` float unsigned NOT NULL DEFAULT '0', @@ -795,7 +795,7 @@ CREATE TABLE `creature_text` ( `Sound` int unsigned NOT NULL DEFAULT '0', `BroadcastTextId` int NOT NULL DEFAULT '0', `TextRange` tinyint unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -811,8 +811,8 @@ CREATE TABLE `creature_text_locale` ( `CreatureID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text` mediumtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`CreatureID`,`GroupID`,`ID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -828,9 +828,9 @@ CREATE TABLE `disables` ( `sourceType` int unsigned NOT NULL, `entry` int unsigned NOT NULL, `flags` smallint NOT NULL, - `params_0` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `params_1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `params_0` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `params_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`sourceType`,`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -852,7 +852,7 @@ CREATE TABLE `disenchant_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -875,7 +875,7 @@ CREATE TABLE `event_scripts` ( `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -910,7 +910,7 @@ CREATE TABLE `fishing_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -930,7 +930,7 @@ CREATE TABLE `game_event` ( `length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event', `holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', `holidayStage` tinyint unsigned NOT NULL DEFAULT '0', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console', `world_event` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event', `announce` tinyint unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', PRIMARY KEY (`eventEntry`) @@ -978,7 +978,7 @@ CREATE TABLE `game_event_condition` ( `req_num` float DEFAULT '0', `max_world_state_field` smallint unsigned NOT NULL DEFAULT '0', `done_world_state_field` smallint unsigned NOT NULL DEFAULT '0', - `description` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `description` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`eventEntry`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1165,7 +1165,7 @@ CREATE TABLE `game_tele` ( `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `map` smallint unsigned NOT NULL DEFAULT '0', - `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1191,7 +1191,7 @@ CREATE TABLE `game_weather` ( `winter_rain_chance` tinyint unsigned NOT NULL DEFAULT '25', `winter_snow_chance` tinyint unsigned NOT NULL DEFAULT '25', `winter_storm_chance` tinyint unsigned NOT NULL DEFAULT '25', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`zone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Weather System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1222,8 +1222,8 @@ CREATE TABLE `gameobject` ( `spawntimesecs` int NOT NULL DEFAULT '0', `animprogress` tinyint unsigned NOT NULL DEFAULT '0', `state` tinyint unsigned NOT NULL DEFAULT '0', - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci DEFAULT '', - `VerifiedBuild` smallint DEFAULT '0', + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`guid`) ) ENGINE=InnoDB AUTO_INCREMENT=2134507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1264,7 +1264,7 @@ CREATE TABLE `gameobject_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1309,7 +1309,7 @@ CREATE TABLE `gameobject_questitem` ( `GameObjectEntry` int unsigned NOT NULL DEFAULT '0', `Idx` int unsigned NOT NULL DEFAULT '0', `ItemId` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`GameObjectEntry`,`Idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1339,10 +1339,10 @@ CREATE TABLE `gameobject_template` ( `entry` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', `displayId` int unsigned NOT NULL DEFAULT '0', - `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `IconName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `castBarCaption` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `unk1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `IconName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `castBarCaption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `unk1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `size` float NOT NULL DEFAULT '1', `Data0` int unsigned NOT NULL DEFAULT '0', `Data1` int NOT NULL DEFAULT '0', @@ -1368,9 +1368,9 @@ CREATE TABLE `gameobject_template` ( `Data21` int unsigned NOT NULL DEFAULT '0', `Data22` int unsigned NOT NULL DEFAULT '0', `Data23` int unsigned NOT NULL DEFAULT '0', - `AIName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `VerifiedBuild` smallint DEFAULT '0', + `AIName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`), KEY `idx_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System'; @@ -1406,10 +1406,10 @@ DROP TABLE IF EXISTS `gameobject_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_template_locale` ( `entry` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `name` mediumtext COLLATE utf8mb4_unicode_ci, - `castBarCaption` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `castBarCaption` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1440,7 +1440,7 @@ CREATE TABLE `gossip_menu_option` ( `MenuID` smallint unsigned NOT NULL DEFAULT '0', `OptionID` smallint unsigned NOT NULL DEFAULT '0', `OptionIcon` int unsigned NOT NULL DEFAULT '0', - `OptionText` mediumtext COLLATE utf8mb4_unicode_ci, + `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `OptionBroadcastTextID` int NOT NULL DEFAULT '0', `OptionType` tinyint unsigned NOT NULL DEFAULT '0', `OptionNpcFlag` int unsigned NOT NULL DEFAULT '0', @@ -1448,7 +1448,7 @@ CREATE TABLE `gossip_menu_option` ( `ActionPoiID` int unsigned NOT NULL DEFAULT '0', `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0', `BoxMoney` int unsigned NOT NULL DEFAULT '0', - `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BoxBroadcastTextID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`MenuID`,`OptionID`) @@ -1465,9 +1465,9 @@ DROP TABLE IF EXISTS `gossip_menu_option_locale`; CREATE TABLE `gossip_menu_option_locale` ( `MenuID` smallint unsigned NOT NULL DEFAULT '0', `OptionID` smallint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `OptionText` mediumtext COLLATE utf8mb4_unicode_ci, - `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`MenuID`,`OptionID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1483,7 +1483,7 @@ CREATE TABLE `graveyard_zone` ( `ID` int unsigned NOT NULL DEFAULT '0', `GhostZone` int unsigned NOT NULL DEFAULT '0', `Faction` smallint unsigned NOT NULL DEFAULT '0', - `Comment` mediumtext COLLATE utf8mb4_unicode_ci, + `Comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`GhostZone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1516,7 +1516,7 @@ CREATE TABLE `instance_encounters` ( `creditType` tinyint unsigned NOT NULL DEFAULT '0', `creditEntry` int unsigned NOT NULL DEFAULT '0', `lastEncounterDungeon` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1548,7 +1548,7 @@ DROP TABLE IF EXISTS `instance_template`; CREATE TABLE `instance_template` ( `map` smallint unsigned NOT NULL, `parent` smallint unsigned NOT NULL, - `script` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `script` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `allowMount` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`map`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1586,7 +1586,7 @@ CREATE TABLE `item_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1600,9 +1600,9 @@ DROP TABLE IF EXISTS `item_set_names`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_set_names` ( `entry` int unsigned NOT NULL, - `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `InventoryType` tinyint unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1616,9 +1616,9 @@ DROP TABLE IF EXISTS `item_set_names_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_set_names_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1635,7 +1635,7 @@ CREATE TABLE `item_template` ( `class` tinyint unsigned NOT NULL DEFAULT '0', `subclass` tinyint unsigned NOT NULL DEFAULT '0', `SoundOverrideSubclass` tinyint NOT NULL DEFAULT '-1', - `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `displayid` int unsigned NOT NULL DEFAULT '0', `Quality` tinyint unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', @@ -1733,7 +1733,7 @@ CREATE TABLE `item_template` ( `spellcategory_5` smallint unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_5` int NOT NULL DEFAULT '-1', `bonding` tinyint unsigned NOT NULL DEFAULT '0', - `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `PageText` int unsigned NOT NULL DEFAULT '0', `LanguageID` tinyint unsigned NOT NULL DEFAULT '0', `PageMaterial` tinyint unsigned NOT NULL DEFAULT '0', @@ -1763,13 +1763,13 @@ CREATE TABLE `item_template` ( `duration` int unsigned NOT NULL DEFAULT '0', `ItemLimitCategory` smallint NOT NULL DEFAULT '0', `HolidayId` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `DisenchantID` int unsigned NOT NULL DEFAULT '0', `FoodType` tinyint unsigned NOT NULL DEFAULT '0', `minMoneyLoot` int unsigned NOT NULL DEFAULT '0', `maxMoneyLoot` int unsigned NOT NULL DEFAULT '0', `flagsCustom` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`), KEY `idx_name` (`name`), KEY `items_index` (`class`) @@ -1785,10 +1785,10 @@ DROP TABLE IF EXISTS `item_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_template_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name` mediumtext COLLATE utf8mb4_unicode_ci, - `Description` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1823,7 +1823,7 @@ CREATE TABLE `lfg_dungeon_template` ( `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`dungeonId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1876,7 +1876,7 @@ CREATE TABLE `mail_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1898,7 +1898,7 @@ CREATE TABLE `milling_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1928,8 +1928,8 @@ DROP TABLE IF EXISTS `npc_text`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `npc_text` ( `ID` int unsigned NOT NULL DEFAULT '0', - `text0_0` longtext COLLATE utf8mb4_unicode_ci, - `text0_1` longtext COLLATE utf8mb4_unicode_ci, + `text0_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text0_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID0` int NOT NULL DEFAULT '0', `lang0` tinyint unsigned NOT NULL DEFAULT '0', `Probability0` float NOT NULL DEFAULT '0', @@ -1939,8 +1939,8 @@ CREATE TABLE `npc_text` ( `Emote0_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay0_2` smallint unsigned NOT NULL DEFAULT '0', `Emote0_2` smallint unsigned NOT NULL DEFAULT '0', - `text1_0` longtext COLLATE utf8mb4_unicode_ci, - `text1_1` longtext COLLATE utf8mb4_unicode_ci, + `text1_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text1_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID1` int NOT NULL DEFAULT '0', `lang1` tinyint unsigned NOT NULL DEFAULT '0', `Probability1` float NOT NULL DEFAULT '0', @@ -1950,8 +1950,8 @@ CREATE TABLE `npc_text` ( `Emote1_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay1_2` smallint unsigned NOT NULL DEFAULT '0', `Emote1_2` smallint unsigned NOT NULL DEFAULT '0', - `text2_0` longtext COLLATE utf8mb4_unicode_ci, - `text2_1` longtext COLLATE utf8mb4_unicode_ci, + `text2_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text2_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID2` int NOT NULL DEFAULT '0', `lang2` tinyint unsigned NOT NULL DEFAULT '0', `Probability2` float NOT NULL DEFAULT '0', @@ -1961,8 +1961,8 @@ CREATE TABLE `npc_text` ( `Emote2_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay2_2` smallint unsigned NOT NULL DEFAULT '0', `Emote2_2` smallint unsigned NOT NULL DEFAULT '0', - `text3_0` longtext COLLATE utf8mb4_unicode_ci, - `text3_1` longtext COLLATE utf8mb4_unicode_ci, + `text3_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text3_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID3` int NOT NULL DEFAULT '0', `lang3` tinyint unsigned NOT NULL DEFAULT '0', `Probability3` float NOT NULL DEFAULT '0', @@ -1972,8 +1972,8 @@ CREATE TABLE `npc_text` ( `Emote3_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay3_2` smallint unsigned NOT NULL DEFAULT '0', `Emote3_2` smallint unsigned NOT NULL DEFAULT '0', - `text4_0` longtext COLLATE utf8mb4_unicode_ci, - `text4_1` longtext COLLATE utf8mb4_unicode_ci, + `text4_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text4_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID4` int NOT NULL DEFAULT '0', `lang4` tinyint unsigned NOT NULL DEFAULT '0', `Probability4` float NOT NULL DEFAULT '0', @@ -1983,8 +1983,8 @@ CREATE TABLE `npc_text` ( `Emote4_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay4_2` smallint unsigned NOT NULL DEFAULT '0', `Emote4_2` smallint unsigned NOT NULL DEFAULT '0', - `text5_0` longtext COLLATE utf8mb4_unicode_ci, - `text5_1` longtext COLLATE utf8mb4_unicode_ci, + `text5_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text5_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID5` int NOT NULL DEFAULT '0', `lang5` tinyint unsigned NOT NULL DEFAULT '0', `Probability5` float NOT NULL DEFAULT '0', @@ -1994,8 +1994,8 @@ CREATE TABLE `npc_text` ( `Emote5_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay5_2` smallint unsigned NOT NULL DEFAULT '0', `Emote5_2` smallint unsigned NOT NULL DEFAULT '0', - `text6_0` longtext COLLATE utf8mb4_unicode_ci, - `text6_1` longtext COLLATE utf8mb4_unicode_ci, + `text6_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text6_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID6` int NOT NULL DEFAULT '0', `lang6` tinyint unsigned NOT NULL DEFAULT '0', `Probability6` float NOT NULL DEFAULT '0', @@ -2005,8 +2005,8 @@ CREATE TABLE `npc_text` ( `Emote6_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay6_2` smallint unsigned NOT NULL DEFAULT '0', `Emote6_2` smallint unsigned NOT NULL DEFAULT '0', - `text7_0` longtext COLLATE utf8mb4_unicode_ci, - `text7_1` longtext COLLATE utf8mb4_unicode_ci, + `text7_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `text7_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BroadcastTextID7` int NOT NULL DEFAULT '0', `lang7` tinyint unsigned NOT NULL DEFAULT '0', `Probability7` float NOT NULL DEFAULT '0', @@ -2016,7 +2016,7 @@ CREATE TABLE `npc_text` ( `Emote7_1` smallint unsigned NOT NULL DEFAULT '0', `EmoteDelay7_2` smallint unsigned NOT NULL DEFAULT '0', `Emote7_2` smallint unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2030,23 +2030,23 @@ DROP TABLE IF EXISTS `npc_text_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `npc_text_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text0_0` longtext COLLATE utf8mb4_unicode_ci, - `Text0_1` longtext COLLATE utf8mb4_unicode_ci, - `Text1_0` longtext COLLATE utf8mb4_unicode_ci, - `Text1_1` longtext COLLATE utf8mb4_unicode_ci, - `Text2_0` longtext COLLATE utf8mb4_unicode_ci, - `Text2_1` longtext COLLATE utf8mb4_unicode_ci, - `Text3_0` longtext COLLATE utf8mb4_unicode_ci, - `Text3_1` longtext COLLATE utf8mb4_unicode_ci, - `Text4_0` longtext COLLATE utf8mb4_unicode_ci, - `Text4_1` longtext COLLATE utf8mb4_unicode_ci, - `Text5_0` longtext COLLATE utf8mb4_unicode_ci, - `Text5_1` longtext COLLATE utf8mb4_unicode_ci, - `Text6_0` longtext COLLATE utf8mb4_unicode_ci, - `Text6_1` longtext COLLATE utf8mb4_unicode_ci, - `Text7_0` longtext COLLATE utf8mb4_unicode_ci, - `Text7_1` longtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text0_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text0_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text1_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text1_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text2_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text2_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text3_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text3_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text4_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text4_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text5_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text5_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text6_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text6_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text7_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Text7_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2065,7 +2065,7 @@ CREATE TABLE `npc_vendor` ( `maxcount` tinyint unsigned NOT NULL DEFAULT '0', `incrtime` int unsigned NOT NULL DEFAULT '0', `ExtendedCost` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`entry`,`item`,`ExtendedCost`), KEY `slot` (`slot`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Npc System'; @@ -2080,8 +2080,8 @@ DROP TABLE IF EXISTS `outdoorpvp_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `outdoorpvp_template` ( `TypeId` tinyint unsigned NOT NULL, - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `comment` mediumtext COLLATE utf8mb4_unicode_ci, + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`TypeId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='OutdoorPvP Templates'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2095,7 +2095,7 @@ DROP TABLE IF EXISTS `page_text`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_text` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `NextPageID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) @@ -2111,9 +2111,9 @@ DROP TABLE IF EXISTS `page_text_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_text_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2151,7 +2151,7 @@ DROP TABLE IF EXISTS `pet_name_generation`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_name_generation` ( `id` int unsigned NOT NULL, - `word` text COLLATE utf8mb4_unicode_ci NOT NULL, + `word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `entry` int unsigned NOT NULL DEFAULT '0', `half` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) @@ -2175,7 +2175,7 @@ CREATE TABLE `pickpocketing_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2220,10 +2220,10 @@ DROP TABLE IF EXISTS `player_factionchange_items`; CREATE TABLE `player_factionchange_items` ( `race_A` int unsigned NOT NULL, `alliance_id` int unsigned NOT NULL, - `commentA` mediumtext COLLATE utf8mb4_unicode_ci, + `commentA` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `race_H` int unsigned NOT NULL, `horde_id` int unsigned NOT NULL, - `commentH` mediumtext COLLATE utf8mb4_unicode_ci, + `commentH` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`alliance_id`,`horde_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2384,7 +2384,7 @@ CREATE TABLE `playercreateinfo_cast_spell` ( `raceMask` int unsigned NOT NULL DEFAULT '0', `classMask` int unsigned NOT NULL DEFAULT '0', `spell` int unsigned NOT NULL DEFAULT '0', - `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL + `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2417,7 +2417,7 @@ CREATE TABLE `playercreateinfo_skills` ( `classMask` int unsigned NOT NULL, `skill` smallint unsigned NOT NULL, `rank` smallint unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`raceMask`,`classMask`,`skill`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2433,7 +2433,7 @@ CREATE TABLE `playercreateinfo_spell_custom` ( `racemask` int unsigned NOT NULL DEFAULT '0', `classmask` int unsigned NOT NULL DEFAULT '0', `Spell` int unsigned NOT NULL DEFAULT '0', - `Note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`racemask`,`classmask`,`Spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2452,8 +2452,8 @@ CREATE TABLE `points_of_interest` ( `Icon` int unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `Importance` int unsigned NOT NULL DEFAULT '0', - `Name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, - `VerifiedBuild` smallint DEFAULT '0', + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2467,9 +2467,9 @@ DROP TABLE IF EXISTS `points_of_interest_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `points_of_interest_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2486,7 +2486,7 @@ CREATE TABLE `pool_members` ( `spawnId` int unsigned NOT NULL, `poolSpawnId` int unsigned NOT NULL, `chance` float NOT NULL, - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`type`,`spawnId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2501,7 +2501,7 @@ DROP TABLE IF EXISTS `pool_template`; CREATE TABLE `pool_template` ( `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', `max_limit` int unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2523,7 +2523,7 @@ CREATE TABLE `prospecting_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2562,8 +2562,8 @@ CREATE TABLE `quest_greeting` ( `Type` tinyint unsigned NOT NULL DEFAULT '0', `GreetEmoteType` smallint unsigned NOT NULL DEFAULT '0', `GreetEmoteDelay` int unsigned NOT NULL DEFAULT '0', - `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`Type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2578,9 +2578,9 @@ DROP TABLE IF EXISTS `quest_greeting_locale`; CREATE TABLE `quest_greeting_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`Type`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2616,7 +2616,7 @@ CREATE TABLE `quest_offer_reward` ( `EmoteDelay2` int unsigned NOT NULL DEFAULT '0', `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', `EmoteDelay4` int unsigned NOT NULL DEFAULT '0', - `RewardText` mediumtext COLLATE utf8mb4_unicode_ci, + `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2631,9 +2631,9 @@ DROP TABLE IF EXISTS `quest_offer_reward_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_offer_reward_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `RewardText` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2654,7 +2654,7 @@ CREATE TABLE `quest_poi` ( `Floor` int unsigned NOT NULL DEFAULT '0', `Priority` int unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`QuestID`,`id`), KEY `idx` (`QuestID`,`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2673,7 +2673,7 @@ CREATE TABLE `quest_poi_points` ( `Idx2` int unsigned NOT NULL DEFAULT '0', `X` int NOT NULL DEFAULT '0', `Y` int NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`), KEY `questId_id` (`QuestID`,`Idx1`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2690,7 +2690,7 @@ CREATE TABLE `quest_pool_members` ( `questId` int unsigned NOT NULL, `poolId` int unsigned NOT NULL, `poolIndex` tinyint unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`questId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2705,7 +2705,7 @@ DROP TABLE IF EXISTS `quest_pool_template`; CREATE TABLE `quest_pool_template` ( `poolId` int unsigned NOT NULL, `numActive` int unsigned NOT NULL COMMENT 'Number of indices to have active at any time', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`poolId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2721,7 +2721,7 @@ CREATE TABLE `quest_request_items` ( `ID` int unsigned NOT NULL DEFAULT '0', `EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0', `EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0', - `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci, + `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2736,9 +2736,9 @@ DROP TABLE IF EXISTS `quest_request_items_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_request_items_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2825,11 +2825,11 @@ CREATE TABLE `quest_template` ( `RewardFactionOverride5` int NOT NULL DEFAULT '0', `TimeAllowed` int unsigned NOT NULL DEFAULT '0', `AllowableRaces` smallint unsigned NOT NULL DEFAULT '0', - `LogTitle` mediumtext COLLATE utf8mb4_unicode_ci, - `LogDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `QuestDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `AreaDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `QuestCompletionLog` mediumtext COLLATE utf8mb4_unicode_ci, + `LogTitle` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `LogDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `QuestDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `AreaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `QuestCompletionLog` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `RequiredNpcOrGo1` int NOT NULL DEFAULT '0', `RequiredNpcOrGo2` int NOT NULL DEFAULT '0', `RequiredNpcOrGo3` int NOT NULL DEFAULT '0', @@ -2851,11 +2851,11 @@ CREATE TABLE `quest_template` ( `RequiredItemCount5` smallint unsigned NOT NULL DEFAULT '0', `RequiredItemCount6` smallint unsigned NOT NULL DEFAULT '0', `Unknown0` tinyint unsigned NOT NULL DEFAULT '0', - `ObjectiveText1` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText2` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText3` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText4` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `ObjectiveText1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2899,17 +2899,17 @@ DROP TABLE IF EXISTS `quest_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_template_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Title` mediumtext COLLATE utf8mb4_unicode_ci, - `Details` mediumtext COLLATE utf8mb4_unicode_ci, - `Objectives` mediumtext COLLATE utf8mb4_unicode_ci, - `EndText` mediumtext COLLATE utf8mb4_unicode_ci, - `CompletedText` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText1` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText2` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText3` mediumtext COLLATE utf8mb4_unicode_ci, - `ObjectiveText4` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Details` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Objectives` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `EndText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `CompletedText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ObjectiveText4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2931,7 +2931,7 @@ CREATE TABLE `reference_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3032,7 +3032,7 @@ CREATE TABLE `script_waypoint` ( `location_y` float NOT NULL DEFAULT '0', `location_z` float NOT NULL DEFAULT '0', `waittime` int unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', - `point_comment` mediumtext COLLATE utf8mb4_unicode_ci, + `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3116,7 +3116,7 @@ CREATE TABLE `skinning_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3158,7 +3158,7 @@ CREATE TABLE `smart_scripts` ( `target_y` float NOT NULL DEFAULT '0', `target_z` float NOT NULL DEFAULT '0', `target_o` float NOT NULL DEFAULT '0', - `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment', + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment', PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3187,7 +3187,7 @@ DROP TABLE IF EXISTS `spawn_group_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spawn_group_template` ( `groupId` int unsigned NOT NULL, - `groupName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `groupName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `groupFlags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`groupId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3228,7 +3228,7 @@ CREATE TABLE `spell_bonus_data` ( `dot_bonus` float NOT NULL DEFAULT '0', `ap_bonus` float NOT NULL DEFAULT '0', `ap_dot_bonus` float NOT NULL DEFAULT '0', - `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3337,7 +3337,7 @@ CREATE TABLE `spell_dbc` ( `EffectSpellClassMaskC1` int unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC2` int unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC3` int unsigned NOT NULL DEFAULT '0', - `SpellName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `SpellName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `MaxTargetLevel` int unsigned NOT NULL DEFAULT '0', `SpellFamilyName` int unsigned NOT NULL DEFAULT '0', `SpellFamilyFlags1` int unsigned NOT NULL DEFAULT '0', @@ -3426,7 +3426,7 @@ CREATE TABLE `spell_linked_spell` ( `spell_trigger` int NOT NULL, `spell_effect` int NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', - `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3448,7 +3448,7 @@ CREATE TABLE `spell_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3536,7 +3536,7 @@ DROP TABLE IF EXISTS `spell_script_names`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_script_names` ( `spell_id` int NOT NULL, - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3560,7 +3560,7 @@ CREATE TABLE `spell_scripts` ( `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3579,7 +3579,7 @@ CREATE TABLE `spell_target_position` ( `PositionY` float NOT NULL DEFAULT '0', `PositionZ` float NOT NULL DEFAULT '0', `Orientation` float NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`ID`,`EffectIndex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3628,8 +3628,8 @@ CREATE TABLE `trainer` ( `Id` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '2', `Requirement` int unsigned NOT NULL DEFAULT '0', - `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3643,9 +3643,9 @@ DROP TABLE IF EXISTS `trainer_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trainer_locale` ( `Id` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Greeting_lang` mediumtext COLLATE utf8mb4_unicode_ci, - `VerifiedBuild` smallint DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Greeting_lang` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`Id`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3667,7 +3667,7 @@ CREATE TABLE `trainer_spell` ( `ReqAbility2` int unsigned NOT NULL DEFAULT '0', `ReqAbility3` int unsigned NOT NULL DEFAULT '0', `ReqLevel` tinyint unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint DEFAULT '0', + `VerifiedBuild` int DEFAULT NULL, PRIMARY KEY (`TrainerId`,`SpellId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3682,8 +3682,8 @@ DROP TABLE IF EXISTS `transports`; CREATE TABLE `transports` ( `guid` int unsigned NOT NULL AUTO_INCREMENT, `entry` int unsigned NOT NULL DEFAULT '0', - `name` mediumtext COLLATE utf8mb4_unicode_ci, - `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`), UNIQUE KEY `idx_entry` (`entry`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Transports'; @@ -3698,15 +3698,15 @@ DROP TABLE IF EXISTS `trinity_string`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trinity_string` ( `entry` int unsigned NOT NULL DEFAULT '0', - `content_default` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, - `content_loc1` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc2` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc3` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc4` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc5` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc6` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc7` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc8` mediumtext COLLATE utf8mb4_unicode_ci, + `content_default` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `content_loc1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc5` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc6` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc7` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc8` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3719,9 +3719,9 @@ DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) @@ -3736,8 +3736,8 @@ DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3754,7 +3754,7 @@ CREATE TABLE `vehicle_accessory` ( `accessory_entry` int unsigned NOT NULL DEFAULT '0', `seat_id` tinyint NOT NULL DEFAULT '0', `minion` tinyint unsigned NOT NULL DEFAULT '0', - `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`guid`,`seat_id`) @@ -3806,7 +3806,7 @@ CREATE TABLE `vehicle_template_accessory` ( `accessory_entry` int unsigned NOT NULL DEFAULT '0', `seat_id` tinyint NOT NULL DEFAULT '0', `minion` tinyint unsigned NOT NULL DEFAULT '0', - `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`entry`,`seat_id`) @@ -3821,9 +3821,9 @@ DROP TABLE IF EXISTS `version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `version` ( - `core_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', - `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `db_version` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.', + `core_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', + `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `db_version` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.', `cache_id` int DEFAULT '0', PRIMARY KEY (`core_version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Version Notes'; @@ -3923,14 +3923,14 @@ DROP TABLE IF EXISTS `warden_checks`; CREATE TABLE `warden_checks` ( `id` smallint unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned DEFAULT NULL, - `str` varchar(170) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `str` varchar(170) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` int unsigned DEFAULT NULL, `length` tinyint unsigned DEFAULT NULL, - `comment` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` binary(24) DEFAULT NULL, `result` varbinary(24) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +) ENGINE=InnoDB AUTO_INCREMENT=812 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3975,7 +3975,7 @@ CREATE TABLE `waypoint_scripts` ( `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', `guid` int NOT NULL DEFAULT '0', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3995,7 +3995,7 @@ CREATE TABLE `waypoints` ( `position_z` float NOT NULL DEFAULT '0', `orientation` float DEFAULT NULL, `delay` int unsigned NOT NULL DEFAULT '0', - `point_comment` mediumtext COLLATE utf8mb4_unicode_ci, + `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4067,4 +4067,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2023-01-16 11:08:18 +-- Dump completed on 2023-06-14 19:34:39 diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql new file mode 100644 index 00000000000..2b56c992617 --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.23011 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql new file mode 100644 index 00000000000..a1db2d6b2a9 --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql @@ -0,0 +1,19 @@ +ALTER TABLE `account` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_muted` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `autobroadcast` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `build_info` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `ip_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `logs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `logs_ip_actions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_account_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_default_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_linked_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `realmcharacters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `realmlist` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `secret_digest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `updates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `updates_include` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `uptime` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql new file mode 100644 index 00000000000..c1cca3f8c7d --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql @@ -0,0 +1,2 @@ +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql new file mode 100644 index 00000000000..c4b98641686 --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql @@ -0,0 +1,2 @@ +-- +UPDATE `rbac_permissions` SET `name` = 'Command: reload graveyard_zone' WHERE `id` = 645; diff --git a/sql/old/3.3.5a/characters/23011_2023_06_14/2023_01_16_00_characters.sql b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_01_16_00_characters.sql new file mode 100644 index 00000000000..518902308ae --- /dev/null +++ b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_01_16_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.23011 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_00_characters.sql b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_00_characters.sql new file mode 100644 index 00000000000..60f84b11235 --- /dev/null +++ b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_00_characters.sql @@ -0,0 +1,91 @@ +ALTER TABLE `account_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_instance_times` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_tutorial` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `addons` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `arena_team` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `arena_team_member` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `auctionbidders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `auctionhouse` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `banned_addons` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `battleground_deserters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `bugreport` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `calendar_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `calendar_invites` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `channels` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_account_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_achievement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_achievement_progress` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_action` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_arena_stats` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_aura` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_battleground_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_battleground_random` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_declinedname` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_equipmentsets` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_fishingsteps` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_gifts` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_glyphs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_homebind` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_inventory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_pet` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_pet_declinedname` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_queststatus` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_queststatus_daily` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_queststatus_monthly` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_queststatus_rewarded` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_queststatus_seasonal` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_queststatus_weekly` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_reputation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_skills` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_social` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_spell` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_spell_cooldown` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_stats` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `character_talent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `characters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `corpse` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `game_event_condition_save` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `game_event_save` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `gm_subsurvey` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `gm_survey` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `gm_ticket` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `group_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `group_member` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_bank_eventlog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_bank_item` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_bank_right` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_bank_tab` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_eventlog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_member` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_member_withdraw` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `guild_rank` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `instance_reset` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `item_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `item_loot_items` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `item_loot_money` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `item_refund_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `item_soulbound_trade_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `lag_reports` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `lfg_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `mail` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `mail_items` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `pet_aura` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `pet_spell` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `pet_spell_cooldown` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `petition` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `petition_sign` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `pool_quest_save` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `pvpstats_battlegrounds` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `pvpstats_players` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `quest_tracker` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `reserved_name` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `respawn` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `updates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `updates_include` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `warden_action` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `worldstates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_01_characters.sql b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_01_characters.sql new file mode 100644 index 00000000000..c1cca3f8c7d --- /dev/null +++ b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_01_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_01_16_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_01_16_00_world.sql new file mode 100644 index 00000000000..425832740e8 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_01_16_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.23011 world +UPDATE `version` SET `db_version`='TDB 335.23011', `cache_id`=23011 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_03_24_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_03_24_00_world.sql new file mode 100644 index 00000000000..e4e280580b3 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_03_24_00_world.sql @@ -0,0 +1,86 @@ +-- npc professions tailor +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (8530,8531,8532) AND `OptionID` IN (1,2); +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(8531, 1, 0, 'Please teach me how to become a Spellcloth tailor', 20241, 0, 0, 0, 0, 0, 200000, '*WARNING!* You can only select one tailoring specialization.', 20246, 0), +(8531, 2, 0, 'I wish to unlearn Spellfire Tailoring', 21566, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Spellfire Tailoring is not something to do lightly. If you choose to abandon it you will forget all recipes that require Spellfire Tailoring to create!$b$bAre you absolutely sure?', 21660, 0), +(8530, 1, 0, 'Please teach me how to become a Mooncloth tailor', 20240, 0, 0, 0, 0, 0, 200000, '*WARNING!* You can only select one tailoring specialization.', 20247, 0), +(8530, 2, 0, 'I wish to unlearn Mooncloth Tailoring', 21659, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Mooncloth Tailoring is not something to do lightly. If you choose to abandon it you will forget all recipes that require Mooncloth Tailoring to create!$b$bAre you absolutely sure?', 21662, 0), +(8532, 1, 0, 'Please teach me how to become a Shadoweave tailor', 20237, 0, 0, 0, 0, 0, 200000, '*WARNING!* You can only select one tailoring specialization.', 20248, 0), +(8532, 2, 0, 'I wish to unlearn Shadoweave Tailoring', 21658, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Shadoweave Tailoring is not something to do lightly. If you choose to abandon it you will forget all recipes that require Shadoweave Tailoring to create!$b$bAre you absolutely sure?', 21661, 0); + +-- npc professions alchemy (https://tbc.wowhead.com/spell=41564/unlearn-elixir-mastery#comments) +UPDATE `creature_template` SET `ScriptName`='npc_prof_alchemy' WHERE `entry` IN (17909,19052,22427); +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (7571,8540,8542) AND `OptionID` IN (1,2); +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(8542, 1, 0, 'I\'ve trained as an alchemist once again. I wish to specialize in transmutations.', 20292, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(8542, 2, 0, 'I wish to unlearn Transmutation Mastery.', 21876, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Transmutation Mastery is not something to do lightly.Are you absolutely sure?', 21872, 0), +(8540, 1, 0, 'I\'ve trained as an alchemist once again. I wish to specialize in elixirs.', 20289, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(8540, 2, 0, 'I wish to unlearn Elixir Mastery.', 21875, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Elixir Mastery is not something to do lightly.Are you absolutely sure?', 21871, 0), +(7571, 1, 0, 'I\'ve trained as an alchemist once again. I wish to specialize in potions.', 20287, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(7571, 2, 0, 'I wish to unlearn Potion Mastery.', 21874, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Potion Mastery is not something to do lightly.Are you absolutely sure?', 21870, 0); + +-- npc professions leatherworking +UPDATE `creature_template` SET `gossip_menu_id`=3071 WHERE `entry`=7871; +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (3067,3068,3069,3070,3071,3072) AND `OptionID` IN (1,2,3,4); +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(3067, 1, 0, 'I am absolutely certain that I want to learn dragonscale leatherworking.', 11889, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(3067, 2, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 250000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), +(3067, 3, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 500000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), +(3067, 4, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 1000000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), +(3068, 1, 0, 'I am absolutely certain that I want to learn dragonscale leatherworking.', 11889, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(3068, 2, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 250000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), +(3068, 3, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 500000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), +(3068, 4, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 1000000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), +(3070, 1, 0, 'I am absolutely certain that I want to learn elemental leatherworking.', 11890, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(3070, 2, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 250000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), +(3070, 3, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 500000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), +(3070, 4, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 1000000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), +(3069, 1, 0, 'I am absolutely certain that I want to learn elemental leatherworking.', 11890, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(3069, 2, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 250000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), +(3069, 3, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 500000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), +(3069, 4, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 1000000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), +(3072, 1, 0, 'I am absolutely certain that I want to learn tribal leatherworking.', 11891, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(3072, 2, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 250000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), +(3072, 3, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 500000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), +(3072, 4, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 1000000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), +(3071, 1, 0, 'I am absolutely certain that I want to learn tribal leatherworking.', 11891, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), +(3071, 2, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 250000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), +(3071, 3, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 500000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), +(3071, 4, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 1000000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0); + +-- npc professions blacksmithing +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (3182,3187,3201,3202,597,3203) AND `OptionID` IN (1,2); +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6090,6089,6091) AND `OptionID` IN (1,2,3,4); +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(3182, 1, 0, 'I wish to become a weaponsmith.', 6477, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(3182, 2, 0, 'I wish to become an armorsmith.', 6476, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(3187, 1, 0, 'I wish to become a weaponsmith.', 6477, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(3187, 2, 0, 'I wish to become an armorsmith.', 6476, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(3201, 1, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 50000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), +(3201, 2, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 100000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), +(3202, 1, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 50000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), +(3202, 2, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 100000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), +(597, 1, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 50000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), +(597, 2, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 100000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), +(3203, 1, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 50000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), +(3203, 2, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 100000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), +(6090, 1, 0, 'Please teach me how to become a hammersmith, Lilith.', 9988, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(6090, 2, 0, 'I wish to unlearn Hammersmithing!', 18990, 0, 0, 0, 0, 0, 250000, 'Forgetting your Hammersmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Hammersmithing to create!', 18991, 0), +(6090, 3, 0, 'I wish to unlearn Hammersmithing!', 18990, 0, 0, 0, 0, 0, 500000, 'Forgetting your Hammersmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Hammersmithing to create!', 18991, 0), +(6090, 4, 0, 'I wish to unlearn Hammersmithing!', 18990, 0, 0, 0, 0, 0, 1000000, 'Forgetting your Hammersmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Hammersmithing to create!', 18991, 0), +(6089, 1, 0, 'Please teach me how to become an axesmith, Kilram.', 9985, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(6089, 2, 0, 'I wish to unlearn Axesmithing!', 18986, 0, 0, 0, 0, 0, 250000, 'Forgetting your Axesmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Axesmithing to create!', 18987, 0), +(6089, 3, 0, 'I wish to unlearn Axesmithing!', 18986, 0, 0, 0, 0, 0, 500000, 'Forgetting your Axesmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Axesmithing to create!', 18987, 0), +(6089, 4, 0, 'I wish to unlearn Axesmithing!', 18986, 0, 0, 0, 0, 0, 1000000, 'Forgetting your Axesmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Axesmithing to create!', 18987, 0), +(6091, 1, 0, 'Please teach me how to become a swordsmith, Seril.', 9991, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(6091, 2, 0, 'I wish to unlearn Swordsmithing!', 18982, 0, 0, 0, 0, 0, 250000, 'Forgetting your swordsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require swordsmithing to create!', 18983, 0), +(6091, 3, 0, 'I wish to unlearn Swordsmithing!', 18982, 0, 0, 0, 0, 0, 500000, 'Forgetting your swordsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require swordsmithing to create!', 18983, 0), +(6091, 4, 0, 'I wish to unlearn Swordsmithing!', 18982, 0, 0, 0, 0, 0, 1000000, 'Forgetting your swordsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require swordsmithing to create!', 18983, 0); + +-- npc professions engineering +DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6092,6094,8308,8306) AND `OptionID` IN (2); +INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(6092, 2, 0, 'This Dimensional Imploder sounds dangerous! How can I make one?', 9994, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(6094, 2, 0, 'I must build a beacon for this marvelous device!', 9997, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(8308, 2, 0, 'This Dimensional Imploder sounds dangerous! How can I make one?', 9994, 0, 0, 0, 0, 0, 0, NULL, 0, 0), +(8306, 2, 0, 'I must build a beacon for this marvelous device!', 9997, 0, 0, 0, 0, 0, 0, NULL, 0, 0); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_00_world.sql new file mode 100644 index 00000000000..e6439cc825b --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_00_world.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_template_addon` SET `SheathState`=0 WHERE `entry` IN (11280,30731,32643,34045); +UPDATE `creature_template_addon` SET `SheathState`=1 WHERE `entry` =11316; + +UPDATE `creature_addon` SET `SheathState`=0, `StandState`=5 WHERE `guid` =135230;-- fix phantom guest sit on medium chair +UPDATE `creature_addon` SET `SheathState`=1 WHERE `guid` IN (8143,8146,8147,63387,78195,78196,78197,78198,82292,112378); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_01_world.sql new file mode 100644 index 00000000000..7944655cd89 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_01_world.sql @@ -0,0 +1,2 @@ +-- Wrath of the Lich King Patch 3.1.0 (2009-04-14): Model updated from a kodo beast to a rhino. +UPDATE `creature` SET `modelid`=26266 WHERE `id`=25968 AND `modelid`=23486; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_02_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_02_world.sql new file mode 100644 index 00000000000..4bedfe2136a --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_02_world.sql @@ -0,0 +1,2 @@ +-- Update Prince Tortheldrin spawn coordinates +UPDATE `creature` SET `position_x`=132.6259, `position_y`=625.9129, `position_z`=-48.38363, `orientation`=4.625122547149658203 WHERE `guid`=56951 AND `id`=11486; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_03_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_03_world.sql new file mode 100644 index 00000000000..29f769d3699 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_03_world.sql @@ -0,0 +1,2 @@ +-- Sons of Hodir: quests reputation reward rate increased 30% +UPDATE `reputation_reward_rate` SET `quest_rate`=1.3,`quest_daily_rate`=1.3,`quest_weekly_rate`=1.3,`quest_monthly_rate`=1.3,`quest_repeatable_rate`=1.3 WHERE `faction`=1119; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_04_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_04_world.sql new file mode 100644 index 00000000000..7c2f16efd45 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_04_world.sql @@ -0,0 +1,2 @@ +-- Ritual Channeler immune to stuns +UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|2048 WHERE `entry` IN (27281,30804); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_05_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_05_world.sql new file mode 100644 index 00000000000..23daff98f38 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_05_world.sql @@ -0,0 +1,2 @@ +-- Fix ruRU translation of the `Details` field for quest 399 +UPDATE `quest_template_locale` SET `VerifiedBuild`=0, `Details`='С тех пор как я мальчишкой работал на ферме в Западном Крае, прошла целая вечность. Говорят, нельзя вернуться в прошлое – и это верно. Дважды верно, если говорить обо мне – ведь мой родной дом был разграблен ворами и сожжен.$B$BЯ спросил у отца о судьбе некоторых моих вещей, например, о моем первом компасе. Отец не мог его захватить при бегстве, но сказал, что компас спрятан где-то на ферме.$B$BУсадьба Алекстона расположена к западу от Сторожевого холма. Может быть, ты найдешь мой компас?' WHERE `ID`=399 AND `locale`='ruRU'; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_06_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_06_world.sql new file mode 100644 index 00000000000..015d1035ff8 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_06_world.sql @@ -0,0 +1,4 @@ +-- Zorbo the Advisor Reputation +DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 18413; +INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillRepFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES +(18413, 978, 941, 7, 0, 10, 7, 0, 10, 1); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_00_world.sql new file mode 100644 index 00000000000..7515a92ee56 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_00_world.sql @@ -0,0 +1,33 @@ +-- +DELETE FROM `game_event_gameobject` WHERE `guid` IN (28140, 28142, 28143, 28144, 28150, 28152, 28156, 28157, 28160, 28161, 28162, 28163, 28168, 28169, 28171, 28173, 28176, 28177, 28178, 28180, 28188, 77739, 77740, 77742, 77743, 77745, 77746, 77747) AND `eventEntry` IN (1, 12); +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +-- MFF Cleanup +(1, 28140), +(1, 28142), +(1, 28143), +(1, 28144), +(1, 28150), +(1, 28152), +(1, 28156), +(1, 28157), +(1, 28160), +(1, 28161), +(1, 28162), +(1, 28163), +(1, 28168), +(1, 28169), +(1, 28171), +(1, 28173), +(1, 28176), +(1, 28177), +(1, 28178), +(1, 28180), +(1, 28188), +-- Hallow's End Cleanup +(12, 77739), +(12, 77740), +(12, 77742), +(12, 77743), +(12, 77745), +(12, 77746), +(12, 77747); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_01_world.sql new file mode 100644 index 00000000000..c9519266151 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature` SET `position_x`=-1751.5304, `position_y`=5168.483, `position_z`=-37.204906, `orientation`=4.747295379638671875 WHERE `guid`=68835; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_02_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_02_world.sql new file mode 100644 index 00000000000..4e42780f230 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_02_world.sql @@ -0,0 +1,2 @@ +-- Warlock - Backlash: Should also proc with absorbs +UPDATE `spell_proc` SET `HitMask`=`HitMask`|0x00000001|0x00000002|0x00000400 WHERE `SpellId`=-34935; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_03_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_03_world.sql new file mode 100644 index 00000000000..a33546f4630 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_03_world.sql @@ -0,0 +1,3 @@ +-- Update two more missing spells cooldown values +UPDATE `spell_proc` SET `Cooldown`=0 WHERE `SpellId`=54909; -- Demonic Pact +UPDATE `spell_proc` SET `Cooldown`=0 WHERE `SpellId`=20375; -- Seal of Command diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_04_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_04_world.sql new file mode 100644 index 00000000000..47b0d57d8f1 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_04_world.sql @@ -0,0 +1,5 @@ +-- Remove PvPFlags for Cavedweller Worg +UPDATE `creature_template_addon` SET `PvPFlags`=0 WHERE `entry`=30164; + +-- update worg fur drop rate +UPDATE `creature_loot_template` SET `Chance`=27 WHERE `Item`=42510 AND `Entry`=30164; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_05_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_05_world.sql new file mode 100644 index 00000000000..1f9a88d40bb --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_05_world.sql @@ -0,0 +1,2 @@ +-- Peon Gakra +UPDATE `creature_template` SET `npcflag`=`npcflag`|65665 WHERE `entry`=29944; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_06_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_06_world.sql new file mode 100644 index 00000000000..8edd584e63b --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_06_world.sql @@ -0,0 +1,6 @@ +-- Maelstrom Weapon +UPDATE `spell_proc` SET `ProcsPerMinute`=2 WHERE `SpellId`=51528; +UPDATE `spell_proc` SET `ProcsPerMinute`=4 WHERE `SpellId`=51529; +UPDATE `spell_proc` SET `ProcsPerMinute`=6 WHERE `SpellId`=51530; +UPDATE `spell_proc` SET `ProcsPerMinute`=8 WHERE `SpellId`=51531; +UPDATE `spell_proc` SET `ProcsPerMinute`=10 WHERE `SpellId`=51532; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_07_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_07_world.sql new file mode 100644 index 00000000000..2d243f0f44f --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_07_world.sql @@ -0,0 +1,9 @@ +-- These 2 creatures have a 25 difficulty (naxx), in them they have gold, it doesn't make sense that in one difficulty they have it and in another they don't. +UPDATE `creature_template` SET `mingold`=3883, `maxgold`=5076 WHERE `entry`=16215; +UPDATE `creature_template` SET `mingold`=4138, `maxgold`=5409 WHERE `entry`=16216; + +-- Restored old gold values for this creature: +UPDATE `creature_template` SET `mingold`=4776, `maxgold`=6241 WHERE `entry`=16194; + +-- Karazhan - Spectral Charger: Remove wrong gold values. +UPDATE `creature_template` SET `mingold`=0, `maxgold`=0 WHERE `entry`=15547; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_07_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_07_00_world.sql new file mode 100644 index 00000000000..02868a65a30 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_07_00_world.sql @@ -0,0 +1,24 @@ +-- deletes for rerunability ensure any custom entries are not being replaced first +DELETE FROM `warden_checks` WHERE `id` IN (793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811); + +-- insert new warden checks +INSERT INTO `warden_checks` (`id`, `type`, `str`, `address`, `length`, `comment`, `data`, `result`) VALUES +(793, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find("New addon name is ") then return true end end', NULL, NULL, 'Custom Detects KickKitty', NULL, NULL), +(794, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find(". It\'s in new directory not this one") then return true end end', NULL, NULL, 'Custom Detects KickKitty', NULL, NULL), +(795, 217, 'BlackMagic.dll', 0, 0, 'Custom BlackMagic - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(796, 217, 'x0.dll', 0, 0, 'Custom x0 gold hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(797, 217, 'Luim.dll', 0, 0, 'Custom Lua Unlocker dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(798, 217, 'Gold Hack.dll', 0, 0, 'Custom Gold Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(799, 217, 'fasmdll_managed.dll', 0, 0, 'Custom Rotation Bot', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(800, 217, 'PortBlock.dll', 0, 0, 'Custom Multiclient Lagger', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(801, 217, 'PinvokeCollection.dll', 0, 0, 'Custom Keysender', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(802, 217, 'FuncCollection.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(803, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find("Rotation : %3s") then return true end end', NULL, NULL, 'Custom Cloud Magic Rotation Bot', NULL, NULL), +(804, 217, 'nampower.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(805, 217, 'EWTDll.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(806, 217, 'iKillFish.dll', 0, 0, 'Custom Fish Bot', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(807, 217, 'iwanna.dll', 0, 0, 'Custom Fish Bot', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(808, 217, 'oGasai.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(809, 217, 'tMorph.dll', 0, 0, 'Custom tMorph - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(810, 217, 'jMorph.dll', 0, 0, 'Custom jMorph - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), +(811, 217, 'dmorph.dll', 0, 0, 'Custom dmorph - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_00_world.sql new file mode 100644 index 00000000000..0f99ce5d67e --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_00_world.sql @@ -0,0 +1,17 @@ +-- I used 1124 and 1125 seems not used +SET @GROUPID1 := 1124; +SET @GROUPID2 := 1125; + +DELETE FROM `spell_group` WHERE `id` IN (1083,1085) AND `spell_id`=-1073; +DELETE FROM `spell_group` WHERE `id`=@GROUPID1 AND `spell_id` IN (-1085,-1073); +DELETE FROM `spell_group` WHERE `id`=@GROUPID2 AND `spell_id` IN (-1083,-1073); +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(@GROUPID1,-1085), -- Spirit Buffs +(@GROUPID1,-1073), -- Fel Intelligence +(@GROUPID2,-1083), -- Intellect Buffs +(@GROUPID2,-1073); -- Fel Intelligence + +DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (@GROUPID1,@GROUPID2); +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +(@GROUPID1,3), +(@GROUPID2,3); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_01_world.sql new file mode 100644 index 00000000000..dfffd1ba75a --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_01_world.sql @@ -0,0 +1,15 @@ +-- +UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=28800 AND `locale`='ruRU'; +UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=28813 AND `locale`='ruRU'; +DELETE FROM `item_template_locale` WHERE `ID` IN (3930) AND `locale` = 'ruRU'; +INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (3930, 'ruRU', 'Ключ Моури'); +DELETE FROM `item_template_locale` WHERE `ID` IN (42482) AND `locale` = 'ruRU'; +INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (42482, 'ruRU', 'Ключ Аметистовой крепости'); +UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=30572 AND `locale`='ruRU'; +UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=30437 AND `locale`='ruRU'; +UPDATE `item_template_locale` SET `Description`='Этим порошком определённо должна заинтересоваться Тиффани Картье из Даларана.' WHERE `ID`=46849 AND `locale`='ruRU'; +DELETE FROM `item_template_locale` WHERE `ID` IN (44581,44582,45796) AND `locale` = 'ruRU'; +INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (44581, 'ruRU', 'Ключ для доступа к героическому режиму Радужного Средоточия'); +INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (44582, 'ruRU', 'Ключ к Радужному Средоточию'); +INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (45796, 'ruRU', 'Ключ к Священному Планетарию'); +UPDATE `creature_template_locale` SET `Title`='Продавец особых боеприпасов' WHERE `entry`=29493 AND `locale`='ruRU'; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_20_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_20_00_world.sql new file mode 100644 index 00000000000..a4d08177da6 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_20_00_world.sql @@ -0,0 +1,2 @@ +-- Warden checks cleanup +DELETE FROM `warden_checks` WHERE `id` IN (793,794,803); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_25_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_25_00_world.sql new file mode 100644 index 00000000000..bc794f330b1 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_25_00_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_icehowl_massive_crash'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(66683,'spell_icehowl_massive_crash'), +(67660,'spell_icehowl_massive_crash'), +(67661,'spell_icehowl_massive_crash'), +(67662,'spell_icehowl_massive_crash'); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_28_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_28_00_world.sql new file mode 100644 index 00000000000..891561f3339 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_28_00_world.sql @@ -0,0 +1,9 @@ +-- +DELETE FROM `spell_area` WHERE `spell` = 57940 AND `area` IN (4723, 4809, 4813, 4820); +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(57940, 4723, 0, 0, 0, 0, 2, 1, 0, 0), +(57940, 4809, 0, 0, 0, 0, 2, 1, 0, 0), +(57940, 4813, 0, 0, 0, 0, 2, 1, 0, 0), +(57940, 4820, 0, 0, 0, 0, 2, 1, 0, 0); + +UPDATE `spell_area` SET `quest_start_status` = 0, `quest_end_status` = 0 WHERE `spell` = 57940; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_00_world.sql new file mode 100644 index 00000000000..4a7b0ff9555 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `conditions` SET `ConditionValue1` = 57940 WHERE `SourceEntry` = 43228 AND `ConditionValue1` = 58045; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_01_world.sql new file mode 100644 index 00000000000..e5b278a4c9a --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_01_world.sql @@ -0,0 +1,13 @@ +-- +DELETE FROM `spell_area` WHERE `spell` = 57940 AND `area` IN (495,4277); +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(57940, 495, 0, 0, 0, 0, 2, 1, 0, 0), -- Howling Fjord +(57940, 4277, 0, 0, 0, 0, 2, 1, 0, 0); -- Azjol-Nerub (Dungeon) + +-- Remove Essence of Wintergrasp in Instances (must be obtained only in only Northrend map and Dungeons) +DELETE FROM `spell_area` WHERE `spell` = 57940 AND `area` IN ( +3456, -- Naxxramas +4493, -- The Obsidian Sanctum +4603, -- Vault of Archavon +4273 -- Ulduar +); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_05_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_05_00_world.sql new file mode 100644 index 00000000000..64d83138f92 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_05_00_world.sql @@ -0,0 +1,10 @@ +-- +UPDATE `graveyard_zone` SET `Faction` = 67 WHERE `ID` = 97 AND `GhostZone` = 209; +UPDATE `graveyard_zone` SET `Faction` = 469 WHERE `ID` = 149 AND `GhostZone` = 209; + + +DELETE FROM `graveyard_zone` WHERE `ID`= 1256 AND `GhostZone` = 209; +INSERT INTO `graveyard_zone` VALUES +(1256, 209, 0, 'Silverpine Forest, South GY - Silverpine Forest'); + +UPDATE `command` SET `help` = 'Syntax: .neargrave [alliance horde]\r\n\r\nFind nearest graveyard linked to zone (or only nearest from accepts alliance or horde faction ghosts).' WHERE `name` = 'neargrave'; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_00_world.sql new file mode 100644 index 00000000000..0df13372961 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_00_world.sql @@ -0,0 +1,3 @@ +-- Val'kyr Battle-maiden +UPDATE `creature_template` SET `AIName` = '' WHERE `entry` = 28487; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 28487 AND `source_type` = 0; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_01_world.sql new file mode 100644 index 00000000000..0bbe58fbbb2 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_01_world.sql @@ -0,0 +1,2 @@ +-- UPDATE Argent Crusader and Knight of the Ebon Blade to run instead walk to the ICC entrance +UPDATE `smart_scripts` SET `action_param1` = 1 WHERE `entryorguid` IN (38493, 38505) AND `source_type` = 0 AND `id` = 0; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_00_world.sql new file mode 100644 index 00000000000..1c90a3d9897 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_00_world.sql @@ -0,0 +1,5 @@ +-- Avenging spirits Wither aura +DELETE FROM `creature_template_addon` WHERE `entry` IN (27386, 30756); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(27386, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "48584"), +(30756, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "48584"); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_01_world.sql new file mode 100644 index 00000000000..3409c102477 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_01_world.sql @@ -0,0 +1,4 @@ +-- Design: Infused Twilight Opal for Anub'arak in the Azjol-Nerub Heroic mode +DELETE FROM `creature_loot_template` WHERE `Entry`=31610 AND `Item`=41796; +INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(31610, 41796, 0, 17, 0, 1, 1, 1, 1, NULL); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_10_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_10_00_world.sql new file mode 100644 index 00000000000..7b7494fa4af --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_10_00_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `vehicle_template_accessory` WHERE `entry`=36794 AND `seat_id`=0; +INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES +(36794, 36658, 0, 0, 'Scourgelord Tyrannus on Scourgelord Tyrannus', 6, 300); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_11_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_11_00_world.sql new file mode 100644 index 00000000000..cab83f5d0ab --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_11_00_world.sql @@ -0,0 +1,9 @@ +-- Guard Slip'kik minor movement correction +UPDATE `creature_template` SET `speed_walk`=2 WHERE `entry`=14323; + +UPDATE `creature_template_addon` SET `SheathState`=1 WHERE `entry` IN (14323, 14321, 14326, 14327, 14325, 11501, 14324, 11488, 11486); + +UPDATE `creature` SET `equipment_id`=1 WHERE `guid`=56945 AND `id`=14324; +DELETE FROM `creature_equip_template` WHERE `CreatureID`=14324 AND `ID`=1; +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES +(14324, 1, 2176, 0, 0, 0); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_00_world.sql new file mode 100644 index 00000000000..1353b77d46e --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_00_world.sql @@ -0,0 +1,10 @@ +-- Westwind Refugee Camp + +-- Fix an issue when NPC were despawning when in combat with hostile player (tested, this won't affect any quest involved) +UPDATE `smart_scripts` SET `event_param1` =8 WHERE `entryorguid` IN (26184, 26179) AND `source_type` =0 AND `id` =8; + +-- Add sniffed sleep aura +UPDATE `creature_addon` SET `auras` =16093 WHERE `guid` IN (102139, 102504, 102141, 102501, 102140, 102507, 102137); + +-- Remove fishing pole/s (from the wrong specific ones) +UPDATE `creature` SET `equipment_id` =0 WHERE `guid` IN (102126, 102131, 102132, 102137, 102138, 102139, 102140, 102141, 102142, 102143, 102145, 102146, 102147, 102148, 102149, 102150, 102492, 102493, 102495, 102496, 102498, 102501, 102503, 102504, 102505, 102506, 102507, 102508, 102509, 102510, 102512, 102513, 102514); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_01_world.sql new file mode 100644 index 00000000000..6beeb4e0187 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_01_world.sql @@ -0,0 +1,2 @@ +-- Stabled Kurenai Panther and Stabled Kurenai Lion sniffed values +UPDATE `creature_template_addon` SET `StandState`=3, `SheathState`=0, `PvpFlags`=1 WHERE `entry` IN (19027, 19030); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_00_world.sql new file mode 100644 index 00000000000..84e0462615f --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_00_world.sql @@ -0,0 +1,23 @@ +-- Add random movement +-- Mountaineer Swarth +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8233 AND `id` = 2518; +-- Mountaineer Harn +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8239 AND `id` = 2506; +-- Mountaineer Roghan +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8306 AND `id` = 2512; +-- Mountaineer Fazgard +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8238 AND `id` = 2515; +-- Mountaineer Janha +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8237 AND `id` = 2513; +-- Mountaineer Cragg +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8234 AND `id` = 2509; +-- Mountaineer Wuar +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8240 AND `id` = 2508; +-- Mountaineer Dalk +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8235 AND `id` = 1338; +-- Mountaineer Uthan +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8302 AND `id` = 2507; +-- Mountaineer Bludd +UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8303 AND `id` = 2511; +-- Mountaineer Ozmok +UPDATE `creature` SET `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 8745 AND `id` = 2510; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_01_world.sql new file mode 100644 index 00000000000..0b3876dea7f --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_01_world.sql @@ -0,0 +1,2 @@ +-- Gordok Mage-Lord update walk speed +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=11444; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_16_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_16_00_world.sql new file mode 100644 index 00000000000..00737b62d2f --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_16_00_world.sql @@ -0,0 +1,5 @@ +-- Fix Ymirjar Skycaller mount behaviour on Iceborn Proto-Drake +UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 31260; +DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryorguid` = 31260 AND `id` =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 +(31260, 0, 2, 0, 1, 0, 100, 7, 0, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 9, 36891, 0, 20, 1, 0, 0, 0, 0, "Ymirjar Skycaller - OOC - Cast 'Ride Vehicle Hardcoded' (No Repeat)"); diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_17_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_17_00_world.sql new file mode 100644 index 00000000000..699e6fa10f6 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_17_00_world.sql @@ -0,0 +1,2 @@ +-- Update Gruul's Lair min level requirement +UPDATE `access_requirement` SET `level_min`=65 WHERE `mapId`=565 AND `difficulty`=0; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_00_world.sql new file mode 100644 index 00000000000..58b5b980d22 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_00_world.sql @@ -0,0 +1,83 @@ +-- Darkmoon Faire (Elwyn Forest) +UPDATE `holiday_dates` SET `date_value`=391135232 WHERE `id`=374 AND `date_id`=0; -- 2023-06-02 +UPDATE `holiday_dates` SET `date_value`=394264576 WHERE `id`=374 AND `date_id`=1; -- 2023-09-01 +UPDATE `holiday_dates` SET `date_value`=397410304 WHERE `id`=374 AND `date_id`=2; -- 2023-12-01 +UPDATE `holiday_dates` SET `date_value`=404750336 WHERE `id`=374 AND `date_id`=3; -- 2024-03-01 +UPDATE `holiday_dates` SET `date_value`=407339008 WHERE `id`=374 AND `date_id`=4; -- 2024-05-31 +UPDATE `holiday_dates` SET `date_value`=410468352 WHERE `id`=374 AND `date_id`=5; -- 2024-08-30 +UPDATE `holiday_dates` SET `date_value`=413597696 WHERE `id`=374 AND `date_id`=6; -- 2024-11-29 +UPDATE `holiday_dates` SET `date_value`=420921344 WHERE `id`=374 AND `date_id`=7; -- 2025-02-28 +UPDATE `holiday_dates` SET `date_value`=424099840 WHERE `id`=374 AND `date_id`=8; -- 2025-05-30 +UPDATE `holiday_dates` SET `date_value`=427229184 WHERE `id`=374 AND `date_id`=9; -- 2025-08-29 +UPDATE `holiday_dates` SET `date_value`=430358528 WHERE `id`=374 AND `date_id`=10; -- 2025-11-28 +UPDATE `holiday_dates` SET `date_value`=437682176 WHERE `id`=374 AND `date_id`=11; -- 2026-02-27 +UPDATE `holiday_dates` SET `date_value`=440860672 WHERE `id`=374 AND `date_id`=12; -- 2026-05-29 +UPDATE `holiday_dates` SET `date_value`=443990016 WHERE `id`=374 AND `date_id`=13; -- 2026-08-28 +UPDATE `holiday_dates` SET `date_value`=447119360 WHERE `id`=374 AND `date_id`=14; -- 2026-11-27 +UPDATE `holiday_dates` SET `date_value`=454443008 WHERE `id`=374 AND `date_id`=15; -- 2027-02-26 +UPDATE `holiday_dates` SET `date_value`=457621504 WHERE `id`=374 AND `date_id`=16; -- 2027-05-28 +UPDATE `holiday_dates` SET `date_value`=460750848 WHERE `id`=374 AND `date_id`=17; -- 2027-08-27 +UPDATE `holiday_dates` SET `date_value`=463880192 WHERE `id`=374 AND `date_id`=18; -- 2027-11-26 +UPDATE `holiday_dates` SET `date_value`=471203840 WHERE `id`=374 AND `date_id`=19; -- 2028-02-25 +UPDATE `holiday_dates` SET `date_value`=474365952 WHERE `id`=374 AND `date_id`=20; -- 2028-05-26 +UPDATE `holiday_dates` SET `date_value`=477495296 WHERE `id`=374 AND `date_id`=21; -- 2028-08-25 +UPDATE `holiday_dates` SET `date_value`=480624640 WHERE `id`=374 AND `date_id`=22; -- 2028-11-24 +UPDATE `holiday_dates` SET `date_value`=487948288 WHERE `id`=374 AND `date_id`=23; -- 2029-02-23 +UPDATE `holiday_dates` SET `date_value`=491126784 WHERE `id`=374 AND `date_id`=24; -- 2029-05-25 +UPDATE `holiday_dates` SET `date_value`=494256128 WHERE `id`=374 AND `date_id`=25; -- 2029-08-24 + +-- Darkmoon Faire (Mulgore) +UPDATE `holiday_dates` SET `date_value`=391593984 WHERE `id`=375 AND `date_id`=0; -- 2023-06-30 +UPDATE `holiday_dates` SET `date_value`=394723328 WHERE `id`=375 AND `date_id`=1; -- 2023-09-29 +UPDATE `holiday_dates` SET `date_value`=397869056 WHERE `id`=375 AND `date_id`=2; -- 2023-12-29 +UPDATE `holiday_dates` SET `date_value`=405209088 WHERE `id`=375 AND `date_id`=3; -- 2024-03-29 +UPDATE `holiday_dates` SET `date_value`=408338432 WHERE `id`=375 AND `date_id`=4; -- 2024-06-28 +UPDATE `holiday_dates` SET `date_value`=411467776 WHERE `id`=375 AND `date_id`=5; -- 2024-09-27 +UPDATE `holiday_dates` SET `date_value`=414613504 WHERE `id`=375 AND `date_id`=6; -- 2024-12-27 +UPDATE `holiday_dates` SET `date_value`=421969920 WHERE `id`=375 AND `date_id`=7; -- 2025-03-28 +UPDATE `holiday_dates` SET `date_value`=425099264 WHERE `id`=375 AND `date_id`=8; -- 2025-06-27 +UPDATE `holiday_dates` SET `date_value`=428228608 WHERE `id`=375 AND `date_id`=9; -- 2025-09-26 +UPDATE `holiday_dates` SET `date_value`=431374336 WHERE `id`=375 AND `date_id`=10; -- 2025-12-26 +UPDATE `holiday_dates` SET `date_value`=438730752 WHERE `id`=375 AND `date_id`=11; -- 2026-03-27 +UPDATE `holiday_dates` SET `date_value`=441860096 WHERE `id`=375 AND `date_id`=12; -- 2026-06-26 +UPDATE `holiday_dates` SET `date_value`=444989440 WHERE `id`=375 AND `date_id`=13; -- 2026-09-25 +UPDATE `holiday_dates` SET `date_value`=448135168 WHERE `id`=375 AND `date_id`=14; -- 2026-12-25 +UPDATE `holiday_dates` SET `date_value`=455491584 WHERE `id`=375 AND `date_id`=15; -- 2027-03-26 +UPDATE `holiday_dates` SET `date_value`=458620928 WHERE `id`=375 AND `date_id`=16; -- 2027-06-25 +UPDATE `holiday_dates` SET `date_value`=461750272 WHERE `id`=375 AND `date_id`=17; -- 2027-09-24 +UPDATE `holiday_dates` SET `date_value`=464896000 WHERE `id`=375 AND `date_id`=18; -- 2027-12-24 +UPDATE `holiday_dates` SET `date_value`=472236032 WHERE `id`=375 AND `date_id`=19; -- 2028-03-24 +UPDATE `holiday_dates` SET `date_value`=475365376 WHERE `id`=375 AND `date_id`=20; -- 2028-06-23 +UPDATE `holiday_dates` SET `date_value`=478494720 WHERE `id`=375 AND `date_id`=21; -- 2028-09-22 +UPDATE `holiday_dates` SET `date_value`=481640448 WHERE `id`=375 AND `date_id`=22; -- 2028-12-22 +UPDATE `holiday_dates` SET `date_value`=488996864 WHERE `id`=375 AND `date_id`=23; -- 2029-03-23 +UPDATE `holiday_dates` SET `date_value`=492126208 WHERE `id`=375 AND `date_id`=24; -- 2029-06-22 +UPDATE `holiday_dates` SET `date_value`=495255552 WHERE `id`=375 AND `date_id`=25; -- 2029-09-21 + +-- Darkmoon Faire (Terokkar Forest) +UPDATE `holiday_dates` SET `date_value`=393265152 WHERE `id`=376 AND `date_id`=0; -- 2023-08-04 +UPDATE `holiday_dates` SET `date_value`=396394496 WHERE `id`=376 AND `date_id`=1; -- 2023-11-03 +UPDATE `holiday_dates` SET `date_value`=403718144 WHERE `id`=376 AND `date_id`=2; -- 2024-02-02 +UPDATE `holiday_dates` SET `date_value`=406880256 WHERE `id`=376 AND `date_id`=3; -- 2024-05-03 +UPDATE `holiday_dates` SET `date_value`=410009600 WHERE `id`=376 AND `date_id`=4; -- 2024-08-02 +UPDATE `holiday_dates` SET `date_value`=413138944 WHERE `id`=376 AND `date_id`=5; -- 2024-11-01 +UPDATE `holiday_dates` SET `date_value`=419921920 WHERE `id`=376 AND `date_id`=6; -- 2025-01-31 +UPDATE `holiday_dates` SET `date_value`=423641088 WHERE `id`=376 AND `date_id`=7; -- 2025-05-02 +UPDATE `holiday_dates` SET `date_value`=426770432 WHERE `id`=376 AND `date_id`=8; -- 2025-08-01 +UPDATE `holiday_dates` SET `date_value`=429359104 WHERE `id`=376 AND `date_id`=9; -- 2025-10-31 +UPDATE `holiday_dates` SET `date_value`=436682752 WHERE `id`=376 AND `date_id`=10; -- 2026-01-30 +UPDATE `holiday_dates` SET `date_value`=440401920 WHERE `id`=376 AND `date_id`=11; -- 2026-05-01 +UPDATE `holiday_dates` SET `date_value`=442990592 WHERE `id`=376 AND `date_id`=12; -- 2026-07-31 +UPDATE `holiday_dates` SET `date_value`=446119936 WHERE `id`=376 AND `date_id`=13; -- 2026-10-30 +UPDATE `holiday_dates` SET `date_value`=453443584 WHERE `id`=376 AND `date_id`=14; -- 2027-01-29 +UPDATE `holiday_dates` SET `date_value`=456605696 WHERE `id`=376 AND `date_id`=15; -- 2027-04-30 +UPDATE `holiday_dates` SET `date_value`=459751424 WHERE `id`=376 AND `date_id`=16; -- 2027-07-30 +UPDATE `holiday_dates` SET `date_value`=462880768 WHERE `id`=376 AND `date_id`=17; -- 2027-10-29 +UPDATE `holiday_dates` SET `date_value`=470204416 WHERE `id`=376 AND `date_id`=18; -- 2028-01-28 +UPDATE `holiday_dates` SET `date_value`=473350144 WHERE `id`=376 AND `date_id`=19; -- 2028-04-28 +UPDATE `holiday_dates` SET `date_value`=476495872 WHERE `id`=376 AND `date_id`=20; -- 2028-07-28 +UPDATE `holiday_dates` SET `date_value`=479625216 WHERE `id`=376 AND `date_id`=21; -- 2028-10-27 +UPDATE `holiday_dates` SET `date_value`=486948864 WHERE `id`=376 AND `date_id`=22; -- 2029-01-26 +UPDATE `holiday_dates` SET `date_value`=490110976 WHERE `id`=376 AND `date_id`=23; -- 2029-04-27 +UPDATE `holiday_dates` SET `date_value`=493256704 WHERE `id`=376 AND `date_id`=24; -- 2029-07-27 +UPDATE `holiday_dates` SET `date_value`=496386048 WHERE `id`=376 AND `date_id`=25; -- 2029-10-26 diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_01_world.sql new file mode 100644 index 00000000000..e246908b08f --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_01_world.sql @@ -0,0 +1,5 @@ +-- "Inoculation" (9303) is missing Reward next quest +UPDATE `quest_template` SET `RewardNextQuest`=9309 WHERE `Id`=9303; + +-- "Urgent Delivery!" (9409) is missing Reward next quest +UPDATE `quest_template` SET `RewardNextQuest`=9283 WHERE `Id`=9409; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_02_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_02_world.sql new file mode 100644 index 00000000000..a3fd03e9080 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_02_world.sql @@ -0,0 +1,5 @@ +-- The reward text for quest "Priest Training" (9291) are missing line breaks and should have lower case "c" in class name. +UPDATE `quest_offer_reward` SET `RewardText` = "It gives me great hope for our future that you come seeking my wisdom. While I have my hands full here with our injured, I am not so busy that I cannot spare a moment to aid you in your first steps as a $c. To walk in the Light is the highest of callings, and one that I am certain you are more than ready to undertake!$b$bSpeak with me again when you feel that you are ready to begin your training." WHERE ID=9291; + +-- The reward text for quest "Mage Training" (9290) are missing line breaks. +UPDATE `quest_offer_reward` SET `RewardText` = "I am pleased that you have come seeking my knowledge. We have much to do if your magical skills are to be honed.$b$bFor over a hundred years I have taught the arcane, frost and fire magics, and I can feel them just as strongly on this world. Would you like me to impart some of what I know to you?" WHERE ID=9290; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_03_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_03_world.sql new file mode 100644 index 00000000000..1a16ec79528 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_03_world.sql @@ -0,0 +1,5 @@ +-- "Vindicator Aldar" (10304) should be breadcrumb quest +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=9303 WHERE `ID`=10304; + +-- "Seek Huntress Kella Nightbow" (9759) should be breadcrumb quest +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=9591 WHERE `ID`=9757; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_04_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_04_world.sql new file mode 100644 index 00000000000..258d9a16731 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_04_world.sql @@ -0,0 +1,35 @@ +-- Convert SMALLINT TO INT for VerifiedBuild tables +ALTER TABLE areatrigger_teleport MODIFY VerifiedBuild INTEGER; +ALTER TABLE broadcast_text_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE creature_equip_template MODIFY VerifiedBuild INTEGER; +ALTER TABLE creature_questitem MODIFY VerifiedBuild INTEGER; +ALTER TABLE creature_template MODIFY VerifiedBuild INTEGER; +ALTER TABLE creature_template_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE creature_template_resistance MODIFY VerifiedBuild INTEGER; +ALTER TABLE creature_template_spell MODIFY VerifiedBuild INTEGER; +ALTER TABLE gameobject MODIFY VerifiedBuild INTEGER; +ALTER TABLE gameobject_questitem MODIFY VerifiedBuild INTEGER; +ALTER TABLE gameobject_template MODIFY VerifiedBuild INTEGER; +ALTER TABLE gameobject_template_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE item_set_names MODIFY VerifiedBuild INTEGER; +ALTER TABLE item_set_names_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE item_template MODIFY VerifiedBuild INTEGER; +ALTER TABLE item_template_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE lfg_dungeon_template MODIFY VerifiedBuild INTEGER; +ALTER TABLE npc_text MODIFY VerifiedBuild INTEGER; +ALTER TABLE npc_vendor MODIFY VerifiedBuild INTEGER; +ALTER TABLE page_text_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE points_of_interest MODIFY VerifiedBuild INTEGER; +ALTER TABLE points_of_interest_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_greeting MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_greeting_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_offer_reward_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_poi MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_poi_points MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_request_items_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_template MODIFY VerifiedBuild INTEGER; +ALTER TABLE quest_template_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE spell_target_position MODIFY VerifiedBuild INTEGER; +ALTER TABLE trainer MODIFY VerifiedBuild INTEGER; +ALTER TABLE trainer_locale MODIFY VerifiedBuild INTEGER; +ALTER TABLE trainer_spell MODIFY VerifiedBuild INTEGER; diff --git a/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_05_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_05_world.sql new file mode 100644 index 00000000000..b305f47a2f4 --- /dev/null +++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_05_world.sql @@ -0,0 +1,5 @@ +-- Add two missing mailbox in Moonglade Nighthaven +DELETE FROM `gameobject` WHERE `guid` IN (100507, 100508); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(100507, 195218, 1, 0, 0, 1, 1, 8008.7421875, -2668.053955078125, 512.06414794921875, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 0), +(100508, 195219, 1, 0, 0, 1, 1, 7867.26904296875, -2575.546875, 486.91259765625, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 0); diff --git a/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql b/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql deleted file mode 100644 index 2b56c992617..00000000000 --- a/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql +++ /dev/null @@ -1,2 +0,0 @@ --- TDB 335.23011 auth -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/auth/3.3.5/2023_02_05_00_auth.sql b/sql/updates/auth/3.3.5/2023_02_05_00_auth.sql deleted file mode 100644 index a1db2d6b2a9..00000000000 --- a/sql/updates/auth/3.3.5/2023_02_05_00_auth.sql +++ /dev/null @@ -1,19 +0,0 @@ -ALTER TABLE `account` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `account_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `account_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `account_muted` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `autobroadcast` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `build_info` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `ip_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `logs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `logs_ip_actions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `rbac_account_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `rbac_default_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `rbac_linked_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `rbac_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `realmcharacters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `realmlist` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `secret_digest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `updates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `updates_include` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `uptime` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/updates/auth/3.3.5/2023_02_05_01_auth.sql b/sql/updates/auth/3.3.5/2023_02_05_01_auth.sql deleted file mode 100644 index c1cca3f8c7d..00000000000 --- a/sql/updates/auth/3.3.5/2023_02_05_01_auth.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; -ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/updates/auth/3.3.5/2023_05_05_00_auth.sql b/sql/updates/auth/3.3.5/2023_05_05_00_auth.sql deleted file mode 100644 index c4b98641686..00000000000 --- a/sql/updates/auth/3.3.5/2023_05_05_00_auth.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `rbac_permissions` SET `name` = 'Command: reload graveyard_zone' WHERE `id` = 645; diff --git a/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql b/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql new file mode 100644 index 00000000000..90ead8908c8 --- /dev/null +++ b/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.23061 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql b/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql deleted file mode 100644 index 518902308ae..00000000000 --- a/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ --- TDB 335.23011 characters -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2023_02_05_00_characters.sql b/sql/updates/characters/3.3.5/2023_02_05_00_characters.sql deleted file mode 100644 index 60f84b11235..00000000000 --- a/sql/updates/characters/3.3.5/2023_02_05_00_characters.sql +++ /dev/null @@ -1,91 +0,0 @@ -ALTER TABLE `account_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `account_instance_times` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `account_tutorial` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `addons` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `arena_team` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `arena_team_member` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `auctionbidders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `auctionhouse` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `banned_addons` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `battleground_deserters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `bugreport` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `calendar_events` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `calendar_invites` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `channels` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_account_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_achievement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_achievement_progress` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_action` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_arena_stats` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_aura` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_battleground_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_battleground_random` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_declinedname` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_equipmentsets` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_fishingsteps` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_gifts` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_glyphs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_homebind` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_inventory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_pet` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_pet_declinedname` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_queststatus` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_queststatus_daily` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_queststatus_monthly` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_queststatus_rewarded` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_queststatus_seasonal` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_queststatus_weekly` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_reputation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_skills` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_social` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_spell` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_spell_cooldown` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_stats` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `character_talent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `characters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `corpse` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `game_event_condition_save` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `game_event_save` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `gm_subsurvey` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `gm_survey` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `gm_ticket` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `group_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `group_member` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `groups` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_bank_eventlog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_bank_item` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_bank_right` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_bank_tab` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_eventlog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_member` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_member_withdraw` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `guild_rank` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `instance_reset` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `item_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `item_loot_items` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `item_loot_money` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `item_refund_instance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `item_soulbound_trade_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `lag_reports` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `lfg_data` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `mail` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `mail_items` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `pet_aura` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `pet_spell` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `pet_spell_cooldown` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `petition` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `petition_sign` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `pool_quest_save` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `pvpstats_battlegrounds` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `pvpstats_players` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `quest_tracker` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `reserved_name` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `respawn` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `updates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `updates_include` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `warden_action` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -ALTER TABLE `worldstates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/updates/characters/3.3.5/2023_02_05_01_characters.sql b/sql/updates/characters/3.3.5/2023_02_05_01_characters.sql deleted file mode 100644 index c1cca3f8c7d..00000000000 --- a/sql/updates/characters/3.3.5/2023_02_05_01_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; -ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/updates/characters/3.3.5/2023_06_14_00_characters.sql b/sql/updates/characters/3.3.5/2023_06_14_00_characters.sql new file mode 100644 index 00000000000..49ccffbdc2c --- /dev/null +++ b/sql/updates/characters/3.3.5/2023_06_14_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.23061 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2023_01_16_00_world.sql b/sql/updates/world/3.3.5/2023_01_16_00_world.sql deleted file mode 100644 index 425832740e8..00000000000 --- a/sql/updates/world/3.3.5/2023_01_16_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 335.23011 world -UPDATE `version` SET `db_version`='TDB 335.23011', `cache_id`=23011 LIMIT 1; -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2023_03_24_00_world.sql b/sql/updates/world/3.3.5/2023_03_24_00_world.sql deleted file mode 100644 index e4e280580b3..00000000000 --- a/sql/updates/world/3.3.5/2023_03_24_00_world.sql +++ /dev/null @@ -1,86 +0,0 @@ --- npc professions tailor -DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (8530,8531,8532) AND `OptionID` IN (1,2); -INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES -(8531, 1, 0, 'Please teach me how to become a Spellcloth tailor', 20241, 0, 0, 0, 0, 0, 200000, '*WARNING!* You can only select one tailoring specialization.', 20246, 0), -(8531, 2, 0, 'I wish to unlearn Spellfire Tailoring', 21566, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Spellfire Tailoring is not something to do lightly. If you choose to abandon it you will forget all recipes that require Spellfire Tailoring to create!$b$bAre you absolutely sure?', 21660, 0), -(8530, 1, 0, 'Please teach me how to become a Mooncloth tailor', 20240, 0, 0, 0, 0, 0, 200000, '*WARNING!* You can only select one tailoring specialization.', 20247, 0), -(8530, 2, 0, 'I wish to unlearn Mooncloth Tailoring', 21659, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Mooncloth Tailoring is not something to do lightly. If you choose to abandon it you will forget all recipes that require Mooncloth Tailoring to create!$b$bAre you absolutely sure?', 21662, 0), -(8532, 1, 0, 'Please teach me how to become a Shadoweave tailor', 20237, 0, 0, 0, 0, 0, 200000, '*WARNING!* You can only select one tailoring specialization.', 20248, 0), -(8532, 2, 0, 'I wish to unlearn Shadoweave Tailoring', 21658, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Shadoweave Tailoring is not something to do lightly. If you choose to abandon it you will forget all recipes that require Shadoweave Tailoring to create!$b$bAre you absolutely sure?', 21661, 0); - --- npc professions alchemy (https://tbc.wowhead.com/spell=41564/unlearn-elixir-mastery#comments) -UPDATE `creature_template` SET `ScriptName`='npc_prof_alchemy' WHERE `entry` IN (17909,19052,22427); -DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (7571,8540,8542) AND `OptionID` IN (1,2); -INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES -(8542, 1, 0, 'I\'ve trained as an alchemist once again. I wish to specialize in transmutations.', 20292, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(8542, 2, 0, 'I wish to unlearn Transmutation Mastery.', 21876, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Transmutation Mastery is not something to do lightly.Are you absolutely sure?', 21872, 0), -(8540, 1, 0, 'I\'ve trained as an alchemist once again. I wish to specialize in elixirs.', 20289, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(8540, 2, 0, 'I wish to unlearn Elixir Mastery.', 21875, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Elixir Mastery is not something to do lightly.Are you absolutely sure?', 21871, 0), -(7571, 1, 0, 'I\'ve trained as an alchemist once again. I wish to specialize in potions.', 20287, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(7571, 2, 0, 'I wish to unlearn Potion Mastery.', 21874, 0, 0, 0, 0, 0, 1500000, 'Forgetting your skill in Potion Mastery is not something to do lightly.Are you absolutely sure?', 21870, 0); - --- npc professions leatherworking -UPDATE `creature_template` SET `gossip_menu_id`=3071 WHERE `entry`=7871; -DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (3067,3068,3069,3070,3071,3072) AND `OptionID` IN (1,2,3,4); -INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES -(3067, 1, 0, 'I am absolutely certain that I want to learn dragonscale leatherworking.', 11889, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(3067, 2, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 250000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), -(3067, 3, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 500000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), -(3067, 4, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 1000000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), -(3068, 1, 0, 'I am absolutely certain that I want to learn dragonscale leatherworking.', 11889, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(3068, 2, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 250000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), -(3068, 3, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 500000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), -(3068, 4, 0, 'I wish to unlearn dragonscale leatherworking!', 18977, 0, 0, 0, 0, 0, 1000000, 'Forgetting dragonscale leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require dragonscale leatherworking as well!', 18976, 0), -(3070, 1, 0, 'I am absolutely certain that I want to learn elemental leatherworking.', 11890, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(3070, 2, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 250000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), -(3070, 3, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 500000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), -(3070, 4, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 1000000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), -(3069, 1, 0, 'I am absolutely certain that I want to learn elemental leatherworking.', 11890, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(3069, 2, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 250000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), -(3069, 3, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 500000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), -(3069, 4, 0, 'I wish to unlearn elemental leatherworking!', 18917, 0, 0, 0, 0, 0, 1000000, 'Forgetting elemental leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require elemental leatherworking as well!', 18923, 0), -(3072, 1, 0, 'I am absolutely certain that I want to learn tribal leatherworking.', 11891, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(3072, 2, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 250000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), -(3072, 3, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 500000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), -(3072, 4, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 1000000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), -(3071, 1, 0, 'I am absolutely certain that I want to learn tribal leatherworking.', 11891, 0, 0, 0, 0, 0, 200000, NULL, 0, 0), -(3071, 2, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 250000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), -(3071, 3, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 500000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0), -(3071, 4, 0, 'I wish to unlearn tribal leatherworking!', 18975, 0, 0, 0, 0, 0, 1000000, 'Forgetting tribal leatherworking is not something to do lightly. If you choose to abandon it you will forget all recipes that require tribal leatherworking as well!', 18974, 0); - --- npc professions blacksmithing -DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (3182,3187,3201,3202,597,3203) AND `OptionID` IN (1,2); -DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6090,6089,6091) AND `OptionID` IN (1,2,3,4); -INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES -(3182, 1, 0, 'I wish to become a weaponsmith.', 6477, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(3182, 2, 0, 'I wish to become an armorsmith.', 6476, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(3187, 1, 0, 'I wish to become a weaponsmith.', 6477, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(3187, 2, 0, 'I wish to become an armorsmith.', 6476, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(3201, 1, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 50000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), -(3201, 2, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 100000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), -(3202, 1, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 50000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), -(3202, 2, 0, 'I wish to unlearn Weaponsmithing!', 19007, 0, 0, 0, 0, 0, 100000, 'Forgetting your Weaponsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Weaponsmithing to create!', 19008, 0), -(597, 1, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 50000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), -(597, 2, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 100000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), -(3203, 1, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 50000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), -(3203, 2, 0, 'I wish to unlearn Armorsmithing!', 19010, 0, 0, 0, 0, 0, 100000, 'Forgetting your Armorsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Armorsmithing to create!', 19011, 0), -(6090, 1, 0, 'Please teach me how to become a hammersmith, Lilith.', 9988, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(6090, 2, 0, 'I wish to unlearn Hammersmithing!', 18990, 0, 0, 0, 0, 0, 250000, 'Forgetting your Hammersmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Hammersmithing to create!', 18991, 0), -(6090, 3, 0, 'I wish to unlearn Hammersmithing!', 18990, 0, 0, 0, 0, 0, 500000, 'Forgetting your Hammersmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Hammersmithing to create!', 18991, 0), -(6090, 4, 0, 'I wish to unlearn Hammersmithing!', 18990, 0, 0, 0, 0, 0, 1000000, 'Forgetting your Hammersmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Hammersmithing to create!', 18991, 0), -(6089, 1, 0, 'Please teach me how to become an axesmith, Kilram.', 9985, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(6089, 2, 0, 'I wish to unlearn Axesmithing!', 18986, 0, 0, 0, 0, 0, 250000, 'Forgetting your Axesmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Axesmithing to create!', 18987, 0), -(6089, 3, 0, 'I wish to unlearn Axesmithing!', 18986, 0, 0, 0, 0, 0, 500000, 'Forgetting your Axesmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Axesmithing to create!', 18987, 0), -(6089, 4, 0, 'I wish to unlearn Axesmithing!', 18986, 0, 0, 0, 0, 0, 1000000, 'Forgetting your Axesmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require Axesmithing to create!', 18987, 0), -(6091, 1, 0, 'Please teach me how to become a swordsmith, Seril.', 9991, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(6091, 2, 0, 'I wish to unlearn Swordsmithing!', 18982, 0, 0, 0, 0, 0, 250000, 'Forgetting your swordsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require swordsmithing to create!', 18983, 0), -(6091, 3, 0, 'I wish to unlearn Swordsmithing!', 18982, 0, 0, 0, 0, 0, 500000, 'Forgetting your swordsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require swordsmithing to create!', 18983, 0), -(6091, 4, 0, 'I wish to unlearn Swordsmithing!', 18982, 0, 0, 0, 0, 0, 1000000, 'Forgetting your swordsmithing skill is not something to do lightly. If you choose to abandon it you will forget all recipes that require swordsmithing to create!', 18983, 0); - --- npc professions engineering -DELETE FROM `gossip_menu_option` WHERE `MenuID` IN (6092,6094,8308,8306) AND `OptionID` IN (2); -INSERT INTO `gossip_menu_option`(`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES -(6092, 2, 0, 'This Dimensional Imploder sounds dangerous! How can I make one?', 9994, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(6094, 2, 0, 'I must build a beacon for this marvelous device!', 9997, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(8308, 2, 0, 'This Dimensional Imploder sounds dangerous! How can I make one?', 9994, 0, 0, 0, 0, 0, 0, NULL, 0, 0), -(8306, 2, 0, 'I must build a beacon for this marvelous device!', 9997, 0, 0, 0, 0, 0, 0, NULL, 0, 0); diff --git a/sql/updates/world/3.3.5/2023_04_05_00_world.sql b/sql/updates/world/3.3.5/2023_04_05_00_world.sql deleted file mode 100644 index e6439cc825b..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_00_world.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -UPDATE `creature_template_addon` SET `SheathState`=0 WHERE `entry` IN (11280,30731,32643,34045); -UPDATE `creature_template_addon` SET `SheathState`=1 WHERE `entry` =11316; - -UPDATE `creature_addon` SET `SheathState`=0, `StandState`=5 WHERE `guid` =135230;-- fix phantom guest sit on medium chair -UPDATE `creature_addon` SET `SheathState`=1 WHERE `guid` IN (8143,8146,8147,63387,78195,78196,78197,78198,82292,112378); diff --git a/sql/updates/world/3.3.5/2023_04_05_01_world.sql b/sql/updates/world/3.3.5/2023_04_05_01_world.sql deleted file mode 100644 index 7944655cd89..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Wrath of the Lich King Patch 3.1.0 (2009-04-14): Model updated from a kodo beast to a rhino. -UPDATE `creature` SET `modelid`=26266 WHERE `id`=25968 AND `modelid`=23486; diff --git a/sql/updates/world/3.3.5/2023_04_05_02_world.sql b/sql/updates/world/3.3.5/2023_04_05_02_world.sql deleted file mode 100644 index 4bedfe2136a..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_02_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Update Prince Tortheldrin spawn coordinates -UPDATE `creature` SET `position_x`=132.6259, `position_y`=625.9129, `position_z`=-48.38363, `orientation`=4.625122547149658203 WHERE `guid`=56951 AND `id`=11486; diff --git a/sql/updates/world/3.3.5/2023_04_05_03_world.sql b/sql/updates/world/3.3.5/2023_04_05_03_world.sql deleted file mode 100644 index 29f769d3699..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_03_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Sons of Hodir: quests reputation reward rate increased 30% -UPDATE `reputation_reward_rate` SET `quest_rate`=1.3,`quest_daily_rate`=1.3,`quest_weekly_rate`=1.3,`quest_monthly_rate`=1.3,`quest_repeatable_rate`=1.3 WHERE `faction`=1119; diff --git a/sql/updates/world/3.3.5/2023_04_05_04_world.sql b/sql/updates/world/3.3.5/2023_04_05_04_world.sql deleted file mode 100644 index 7c2f16efd45..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_04_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Ritual Channeler immune to stuns -UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|2048 WHERE `entry` IN (27281,30804); diff --git a/sql/updates/world/3.3.5/2023_04_05_05_world.sql b/sql/updates/world/3.3.5/2023_04_05_05_world.sql deleted file mode 100644 index 23daff98f38..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_05_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Fix ruRU translation of the `Details` field for quest 399 -UPDATE `quest_template_locale` SET `VerifiedBuild`=0, `Details`='С тех пор как я мальчишкой работал на ферме в Западном Крае, прошла целая вечность. Говорят, нельзя вернуться в прошлое – и это верно. Дважды верно, если говорить обо мне – ведь мой родной дом был разграблен ворами и сожжен.$B$BЯ спросил у отца о судьбе некоторых моих вещей, например, о моем первом компасе. Отец не мог его захватить при бегстве, но сказал, что компас спрятан где-то на ферме.$B$BУсадьба Алекстона расположена к западу от Сторожевого холма. Может быть, ты найдешь мой компас?' WHERE `ID`=399 AND `locale`='ruRU'; diff --git a/sql/updates/world/3.3.5/2023_04_05_06_world.sql b/sql/updates/world/3.3.5/2023_04_05_06_world.sql deleted file mode 100644 index 015d1035ff8..00000000000 --- a/sql/updates/world/3.3.5/2023_04_05_06_world.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Zorbo the Advisor Reputation -DELETE FROM `creature_onkill_reputation` WHERE `creature_id` = 18413; -INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `RewOnKillRepFaction2`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `MaxStanding2`, `IsTeamAward2`, `RewOnKillRepValue2`, `TeamDependent`) VALUES -(18413, 978, 941, 7, 0, 10, 7, 0, 10, 1); diff --git a/sql/updates/world/3.3.5/2023_04_06_00_world.sql b/sql/updates/world/3.3.5/2023_04_06_00_world.sql deleted file mode 100644 index 7515a92ee56..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_00_world.sql +++ /dev/null @@ -1,33 +0,0 @@ --- -DELETE FROM `game_event_gameobject` WHERE `guid` IN (28140, 28142, 28143, 28144, 28150, 28152, 28156, 28157, 28160, 28161, 28162, 28163, 28168, 28169, 28171, 28173, 28176, 28177, 28178, 28180, 28188, 77739, 77740, 77742, 77743, 77745, 77746, 77747) AND `eventEntry` IN (1, 12); -INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES --- MFF Cleanup -(1, 28140), -(1, 28142), -(1, 28143), -(1, 28144), -(1, 28150), -(1, 28152), -(1, 28156), -(1, 28157), -(1, 28160), -(1, 28161), -(1, 28162), -(1, 28163), -(1, 28168), -(1, 28169), -(1, 28171), -(1, 28173), -(1, 28176), -(1, 28177), -(1, 28178), -(1, 28180), -(1, 28188), --- Hallow's End Cleanup -(12, 77739), -(12, 77740), -(12, 77742), -(12, 77743), -(12, 77745), -(12, 77746), -(12, 77747); diff --git a/sql/updates/world/3.3.5/2023_04_06_01_world.sql b/sql/updates/world/3.3.5/2023_04_06_01_world.sql deleted file mode 100644 index c9519266151..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature` SET `position_x`=-1751.5304, `position_y`=5168.483, `position_z`=-37.204906, `orientation`=4.747295379638671875 WHERE `guid`=68835; diff --git a/sql/updates/world/3.3.5/2023_04_06_02_world.sql b/sql/updates/world/3.3.5/2023_04_06_02_world.sql deleted file mode 100644 index 4e42780f230..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_02_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Warlock - Backlash: Should also proc with absorbs -UPDATE `spell_proc` SET `HitMask`=`HitMask`|0x00000001|0x00000002|0x00000400 WHERE `SpellId`=-34935; diff --git a/sql/updates/world/3.3.5/2023_04_06_03_world.sql b/sql/updates/world/3.3.5/2023_04_06_03_world.sql deleted file mode 100644 index a33546f4630..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_03_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Update two more missing spells cooldown values -UPDATE `spell_proc` SET `Cooldown`=0 WHERE `SpellId`=54909; -- Demonic Pact -UPDATE `spell_proc` SET `Cooldown`=0 WHERE `SpellId`=20375; -- Seal of Command diff --git a/sql/updates/world/3.3.5/2023_04_06_04_world.sql b/sql/updates/world/3.3.5/2023_04_06_04_world.sql deleted file mode 100644 index 47b0d57d8f1..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_04_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Remove PvPFlags for Cavedweller Worg -UPDATE `creature_template_addon` SET `PvPFlags`=0 WHERE `entry`=30164; - --- update worg fur drop rate -UPDATE `creature_loot_template` SET `Chance`=27 WHERE `Item`=42510 AND `Entry`=30164; diff --git a/sql/updates/world/3.3.5/2023_04_06_05_world.sql b/sql/updates/world/3.3.5/2023_04_06_05_world.sql deleted file mode 100644 index 1f9a88d40bb..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_05_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Peon Gakra -UPDATE `creature_template` SET `npcflag`=`npcflag`|65665 WHERE `entry`=29944; diff --git a/sql/updates/world/3.3.5/2023_04_06_06_world.sql b/sql/updates/world/3.3.5/2023_04_06_06_world.sql deleted file mode 100644 index 8edd584e63b..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_06_world.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Maelstrom Weapon -UPDATE `spell_proc` SET `ProcsPerMinute`=2 WHERE `SpellId`=51528; -UPDATE `spell_proc` SET `ProcsPerMinute`=4 WHERE `SpellId`=51529; -UPDATE `spell_proc` SET `ProcsPerMinute`=6 WHERE `SpellId`=51530; -UPDATE `spell_proc` SET `ProcsPerMinute`=8 WHERE `SpellId`=51531; -UPDATE `spell_proc` SET `ProcsPerMinute`=10 WHERE `SpellId`=51532; diff --git a/sql/updates/world/3.3.5/2023_04_06_07_world.sql b/sql/updates/world/3.3.5/2023_04_06_07_world.sql deleted file mode 100644 index 2d243f0f44f..00000000000 --- a/sql/updates/world/3.3.5/2023_04_06_07_world.sql +++ /dev/null @@ -1,9 +0,0 @@ --- These 2 creatures have a 25 difficulty (naxx), in them they have gold, it doesn't make sense that in one difficulty they have it and in another they don't. -UPDATE `creature_template` SET `mingold`=3883, `maxgold`=5076 WHERE `entry`=16215; -UPDATE `creature_template` SET `mingold`=4138, `maxgold`=5409 WHERE `entry`=16216; - --- Restored old gold values for this creature: -UPDATE `creature_template` SET `mingold`=4776, `maxgold`=6241 WHERE `entry`=16194; - --- Karazhan - Spectral Charger: Remove wrong gold values. -UPDATE `creature_template` SET `mingold`=0, `maxgold`=0 WHERE `entry`=15547; diff --git a/sql/updates/world/3.3.5/2023_04_07_00_world.sql b/sql/updates/world/3.3.5/2023_04_07_00_world.sql deleted file mode 100644 index 02868a65a30..00000000000 --- a/sql/updates/world/3.3.5/2023_04_07_00_world.sql +++ /dev/null @@ -1,24 +0,0 @@ --- deletes for rerunability ensure any custom entries are not being replaced first -DELETE FROM `warden_checks` WHERE `id` IN (793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804, 805, 806, 807, 808, 809, 810, 811); - --- insert new warden checks -INSERT INTO `warden_checks` (`id`, `type`, `str`, `address`, `length`, `comment`, `data`, `result`) VALUES -(793, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find("New addon name is ") then return true end end', NULL, NULL, 'Custom Detects KickKitty', NULL, NULL), -(794, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find(". It\'s in new directory not this one") then return true end end', NULL, NULL, 'Custom Detects KickKitty', NULL, NULL), -(795, 217, 'BlackMagic.dll', 0, 0, 'Custom BlackMagic - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(796, 217, 'x0.dll', 0, 0, 'Custom x0 gold hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(797, 217, 'Luim.dll', 0, 0, 'Custom Lua Unlocker dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(798, 217, 'Gold Hack.dll', 0, 0, 'Custom Gold Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(799, 217, 'fasmdll_managed.dll', 0, 0, 'Custom Rotation Bot', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(800, 217, 'PortBlock.dll', 0, 0, 'Custom Multiclient Lagger', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(801, 217, 'PinvokeCollection.dll', 0, 0, 'Custom Keysender', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(802, 217, 'FuncCollection.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(803, 139, 'local f=DEFAULT_CHAT_FRAME for i=1,f:GetNumMessages() do if (f:GetMessageInfo(i)):find("Rotation : %3s") then return true end end', NULL, NULL, 'Custom Cloud Magic Rotation Bot', NULL, NULL), -(804, 217, 'nampower.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(805, 217, 'EWTDll.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(806, 217, 'iKillFish.dll', 0, 0, 'Custom Fish Bot', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(807, 217, 'iwanna.dll', 0, 0, 'Custom Fish Bot', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(808, 217, 'oGasai.dll', 0, 0, 'Custom Multi Hack dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(809, 217, 'tMorph.dll', 0, 0, 'Custom tMorph - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(810, 217, 'jMorph.dll', 0, 0, 'Custom jMorph - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''), -(811, 217, 'dmorph.dll', 0, 0, 'Custom dmorph - injected dll', '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', ''); diff --git a/sql/updates/world/3.3.5/2023_04_08_00_world.sql b/sql/updates/world/3.3.5/2023_04_08_00_world.sql deleted file mode 100644 index 0f99ce5d67e..00000000000 --- a/sql/updates/world/3.3.5/2023_04_08_00_world.sql +++ /dev/null @@ -1,17 +0,0 @@ --- I used 1124 and 1125 seems not used -SET @GROUPID1 := 1124; -SET @GROUPID2 := 1125; - -DELETE FROM `spell_group` WHERE `id` IN (1083,1085) AND `spell_id`=-1073; -DELETE FROM `spell_group` WHERE `id`=@GROUPID1 AND `spell_id` IN (-1085,-1073); -DELETE FROM `spell_group` WHERE `id`=@GROUPID2 AND `spell_id` IN (-1083,-1073); -INSERT INTO `spell_group` (`id`,`spell_id`) VALUES -(@GROUPID1,-1085), -- Spirit Buffs -(@GROUPID1,-1073), -- Fel Intelligence -(@GROUPID2,-1083), -- Intellect Buffs -(@GROUPID2,-1073); -- Fel Intelligence - -DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (@GROUPID1,@GROUPID2); -INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES -(@GROUPID1,3), -(@GROUPID2,3); diff --git a/sql/updates/world/3.3.5/2023_04_08_01_world.sql b/sql/updates/world/3.3.5/2023_04_08_01_world.sql deleted file mode 100644 index dfffd1ba75a..00000000000 --- a/sql/updates/world/3.3.5/2023_04_08_01_world.sql +++ /dev/null @@ -1,15 +0,0 @@ --- -UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=28800 AND `locale`='ruRU'; -UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=28813 AND `locale`='ruRU'; -DELETE FROM `item_template_locale` WHERE `ID` IN (3930) AND `locale` = 'ruRU'; -INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (3930, 'ruRU', 'Ключ Моури'); -DELETE FROM `item_template_locale` WHERE `ID` IN (42482) AND `locale` = 'ruRU'; -INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (42482, 'ruRU', 'Ключ Аметистовой крепости'); -UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=30572 AND `locale`='ruRU'; -UPDATE `creature_template_locale` SET `Title`='Боеприпасы' WHERE `entry`=30437 AND `locale`='ruRU'; -UPDATE `item_template_locale` SET `Description`='Этим порошком определённо должна заинтересоваться Тиффани Картье из Даларана.' WHERE `ID`=46849 AND `locale`='ruRU'; -DELETE FROM `item_template_locale` WHERE `ID` IN (44581,44582,45796) AND `locale` = 'ruRU'; -INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (44581, 'ruRU', 'Ключ для доступа к героическому режиму Радужного Средоточия'); -INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (44582, 'ruRU', 'Ключ к Радужному Средоточию'); -INSERT INTO `item_template_locale` (`ID`, `locale`, `Name`) VALUES (45796, 'ruRU', 'Ключ к Священному Планетарию'); -UPDATE `creature_template_locale` SET `Title`='Продавец особых боеприпасов' WHERE `entry`=29493 AND `locale`='ruRU'; diff --git a/sql/updates/world/3.3.5/2023_04_20_00_world.sql b/sql/updates/world/3.3.5/2023_04_20_00_world.sql deleted file mode 100644 index a4d08177da6..00000000000 --- a/sql/updates/world/3.3.5/2023_04_20_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Warden checks cleanup -DELETE FROM `warden_checks` WHERE `id` IN (793,794,803); diff --git a/sql/updates/world/3.3.5/2023_04_25_00_world.sql b/sql/updates/world/3.3.5/2023_04_25_00_world.sql deleted file mode 100644 index bc794f330b1..00000000000 --- a/sql/updates/world/3.3.5/2023_04_25_00_world.sql +++ /dev/null @@ -1,7 +0,0 @@ --- -DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_icehowl_massive_crash'; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(66683,'spell_icehowl_massive_crash'), -(67660,'spell_icehowl_massive_crash'), -(67661,'spell_icehowl_massive_crash'), -(67662,'spell_icehowl_massive_crash'); diff --git a/sql/updates/world/3.3.5/2023_04_28_00_world.sql b/sql/updates/world/3.3.5/2023_04_28_00_world.sql deleted file mode 100644 index 891561f3339..00000000000 --- a/sql/updates/world/3.3.5/2023_04_28_00_world.sql +++ /dev/null @@ -1,9 +0,0 @@ --- -DELETE FROM `spell_area` WHERE `spell` = 57940 AND `area` IN (4723, 4809, 4813, 4820); -INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES -(57940, 4723, 0, 0, 0, 0, 2, 1, 0, 0), -(57940, 4809, 0, 0, 0, 0, 2, 1, 0, 0), -(57940, 4813, 0, 0, 0, 0, 2, 1, 0, 0), -(57940, 4820, 0, 0, 0, 0, 2, 1, 0, 0); - -UPDATE `spell_area` SET `quest_start_status` = 0, `quest_end_status` = 0 WHERE `spell` = 57940; diff --git a/sql/updates/world/3.3.5/2023_04_29_00_world.sql b/sql/updates/world/3.3.5/2023_04_29_00_world.sql deleted file mode 100644 index 4a7b0ff9555..00000000000 --- a/sql/updates/world/3.3.5/2023_04_29_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `conditions` SET `ConditionValue1` = 57940 WHERE `SourceEntry` = 43228 AND `ConditionValue1` = 58045; diff --git a/sql/updates/world/3.3.5/2023_04_29_01_world.sql b/sql/updates/world/3.3.5/2023_04_29_01_world.sql deleted file mode 100644 index e5b278a4c9a..00000000000 --- a/sql/updates/world/3.3.5/2023_04_29_01_world.sql +++ /dev/null @@ -1,13 +0,0 @@ --- -DELETE FROM `spell_area` WHERE `spell` = 57940 AND `area` IN (495,4277); -INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES -(57940, 495, 0, 0, 0, 0, 2, 1, 0, 0), -- Howling Fjord -(57940, 4277, 0, 0, 0, 0, 2, 1, 0, 0); -- Azjol-Nerub (Dungeon) - --- Remove Essence of Wintergrasp in Instances (must be obtained only in only Northrend map and Dungeons) -DELETE FROM `spell_area` WHERE `spell` = 57940 AND `area` IN ( -3456, -- Naxxramas -4493, -- The Obsidian Sanctum -4603, -- Vault of Archavon -4273 -- Ulduar -); diff --git a/sql/updates/world/3.3.5/2023_05_05_00_world.sql b/sql/updates/world/3.3.5/2023_05_05_00_world.sql deleted file mode 100644 index 64d83138f92..00000000000 --- a/sql/updates/world/3.3.5/2023_05_05_00_world.sql +++ /dev/null @@ -1,10 +0,0 @@ --- -UPDATE `graveyard_zone` SET `Faction` = 67 WHERE `ID` = 97 AND `GhostZone` = 209; -UPDATE `graveyard_zone` SET `Faction` = 469 WHERE `ID` = 149 AND `GhostZone` = 209; - - -DELETE FROM `graveyard_zone` WHERE `ID`= 1256 AND `GhostZone` = 209; -INSERT INTO `graveyard_zone` VALUES -(1256, 209, 0, 'Silverpine Forest, South GY - Silverpine Forest'); - -UPDATE `command` SET `help` = 'Syntax: .neargrave [alliance horde]\r\n\r\nFind nearest graveyard linked to zone (or only nearest from accepts alliance or horde faction ghosts).' WHERE `name` = 'neargrave'; diff --git a/sql/updates/world/3.3.5/2023_05_07_00_world.sql b/sql/updates/world/3.3.5/2023_05_07_00_world.sql deleted file mode 100644 index 0df13372961..00000000000 --- a/sql/updates/world/3.3.5/2023_05_07_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Val'kyr Battle-maiden -UPDATE `creature_template` SET `AIName` = '' WHERE `entry` = 28487; -DELETE FROM `smart_scripts` WHERE `entryorguid` = 28487 AND `source_type` = 0; diff --git a/sql/updates/world/3.3.5/2023_05_07_01_world.sql b/sql/updates/world/3.3.5/2023_05_07_01_world.sql deleted file mode 100644 index 0bbe58fbbb2..00000000000 --- a/sql/updates/world/3.3.5/2023_05_07_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- UPDATE Argent Crusader and Knight of the Ebon Blade to run instead walk to the ICC entrance -UPDATE `smart_scripts` SET `action_param1` = 1 WHERE `entryorguid` IN (38493, 38505) AND `source_type` = 0 AND `id` = 0; diff --git a/sql/updates/world/3.3.5/2023_05_09_00_world.sql b/sql/updates/world/3.3.5/2023_05_09_00_world.sql deleted file mode 100644 index 1c90a3d9897..00000000000 --- a/sql/updates/world/3.3.5/2023_05_09_00_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Avenging spirits Wither aura -DELETE FROM `creature_template_addon` WHERE `entry` IN (27386, 30756); -INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES -(27386, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "48584"), -(30756, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "48584"); diff --git a/sql/updates/world/3.3.5/2023_05_09_01_world.sql b/sql/updates/world/3.3.5/2023_05_09_01_world.sql deleted file mode 100644 index 3409c102477..00000000000 --- a/sql/updates/world/3.3.5/2023_05_09_01_world.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Design: Infused Twilight Opal for Anub'arak in the Azjol-Nerub Heroic mode -DELETE FROM `creature_loot_template` WHERE `Entry`=31610 AND `Item`=41796; -INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES -(31610, 41796, 0, 17, 0, 1, 1, 1, 1, NULL); diff --git a/sql/updates/world/3.3.5/2023_05_10_00_world.sql b/sql/updates/world/3.3.5/2023_05_10_00_world.sql deleted file mode 100644 index 7b7494fa4af..00000000000 --- a/sql/updates/world/3.3.5/2023_05_10_00_world.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -DELETE FROM `vehicle_template_accessory` WHERE `entry`=36794 AND `seat_id`=0; -INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES -(36794, 36658, 0, 0, 'Scourgelord Tyrannus on Scourgelord Tyrannus', 6, 300); diff --git a/sql/updates/world/3.3.5/2023_05_11_00_world.sql b/sql/updates/world/3.3.5/2023_05_11_00_world.sql deleted file mode 100644 index cab83f5d0ab..00000000000 --- a/sql/updates/world/3.3.5/2023_05_11_00_world.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Guard Slip'kik minor movement correction -UPDATE `creature_template` SET `speed_walk`=2 WHERE `entry`=14323; - -UPDATE `creature_template_addon` SET `SheathState`=1 WHERE `entry` IN (14323, 14321, 14326, 14327, 14325, 11501, 14324, 11488, 11486); - -UPDATE `creature` SET `equipment_id`=1 WHERE `guid`=56945 AND `id`=14324; -DELETE FROM `creature_equip_template` WHERE `CreatureID`=14324 AND `ID`=1; -INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES -(14324, 1, 2176, 0, 0, 0); diff --git a/sql/updates/world/3.3.5/2023_05_14_00_world.sql b/sql/updates/world/3.3.5/2023_05_14_00_world.sql deleted file mode 100644 index 1353b77d46e..00000000000 --- a/sql/updates/world/3.3.5/2023_05_14_00_world.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Westwind Refugee Camp - --- Fix an issue when NPC were despawning when in combat with hostile player (tested, this won't affect any quest involved) -UPDATE `smart_scripts` SET `event_param1` =8 WHERE `entryorguid` IN (26184, 26179) AND `source_type` =0 AND `id` =8; - --- Add sniffed sleep aura -UPDATE `creature_addon` SET `auras` =16093 WHERE `guid` IN (102139, 102504, 102141, 102501, 102140, 102507, 102137); - --- Remove fishing pole/s (from the wrong specific ones) -UPDATE `creature` SET `equipment_id` =0 WHERE `guid` IN (102126, 102131, 102132, 102137, 102138, 102139, 102140, 102141, 102142, 102143, 102145, 102146, 102147, 102148, 102149, 102150, 102492, 102493, 102495, 102496, 102498, 102501, 102503, 102504, 102505, 102506, 102507, 102508, 102509, 102510, 102512, 102513, 102514); diff --git a/sql/updates/world/3.3.5/2023_05_14_01_world.sql b/sql/updates/world/3.3.5/2023_05_14_01_world.sql deleted file mode 100644 index 6beeb4e0187..00000000000 --- a/sql/updates/world/3.3.5/2023_05_14_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Stabled Kurenai Panther and Stabled Kurenai Lion sniffed values -UPDATE `creature_template_addon` SET `StandState`=3, `SheathState`=0, `PvpFlags`=1 WHERE `entry` IN (19027, 19030); diff --git a/sql/updates/world/3.3.5/2023_05_15_00_world.sql b/sql/updates/world/3.3.5/2023_05_15_00_world.sql deleted file mode 100644 index 84e0462615f..00000000000 --- a/sql/updates/world/3.3.5/2023_05_15_00_world.sql +++ /dev/null @@ -1,23 +0,0 @@ --- Add random movement --- Mountaineer Swarth -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8233 AND `id` = 2518; --- Mountaineer Harn -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8239 AND `id` = 2506; --- Mountaineer Roghan -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8306 AND `id` = 2512; --- Mountaineer Fazgard -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8238 AND `id` = 2515; --- Mountaineer Janha -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8237 AND `id` = 2513; --- Mountaineer Cragg -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8234 AND `id` = 2509; --- Mountaineer Wuar -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8240 AND `id` = 2508; --- Mountaineer Dalk -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8235 AND `id` = 1338; --- Mountaineer Uthan -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8302 AND `id` = 2507; --- Mountaineer Bludd -UPDATE `creature` SET `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 8303 AND `id` = 2511; --- Mountaineer Ozmok -UPDATE `creature` SET `wander_distance` = 5, `MovementType` = 1 WHERE `guid` = 8745 AND `id` = 2510; diff --git a/sql/updates/world/3.3.5/2023_05_15_01_world.sql b/sql/updates/world/3.3.5/2023_05_15_01_world.sql deleted file mode 100644 index 0b3876dea7f..00000000000 --- a/sql/updates/world/3.3.5/2023_05_15_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Gordok Mage-Lord update walk speed -UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=11444; diff --git a/sql/updates/world/3.3.5/2023_05_16_00_world.sql b/sql/updates/world/3.3.5/2023_05_16_00_world.sql deleted file mode 100644 index 00737b62d2f..00000000000 --- a/sql/updates/world/3.3.5/2023_05_16_00_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Fix Ymirjar Skycaller mount behaviour on Iceborn Proto-Drake -UPDATE `creature_template` SET `AIName` = 'SmartAI' WHERE `entry` = 31260; -DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryorguid` = 31260 AND `id` =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 -(31260, 0, 2, 0, 1, 0, 100, 7, 0, 0, 0, 0, 0, 11, 46598, 0, 0, 0, 0, 0, 9, 36891, 0, 20, 1, 0, 0, 0, 0, "Ymirjar Skycaller - OOC - Cast 'Ride Vehicle Hardcoded' (No Repeat)"); diff --git a/sql/updates/world/3.3.5/2023_05_17_00_world.sql b/sql/updates/world/3.3.5/2023_05_17_00_world.sql deleted file mode 100644 index 699e6fa10f6..00000000000 --- a/sql/updates/world/3.3.5/2023_05_17_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Update Gruul's Lair min level requirement -UPDATE `access_requirement` SET `level_min`=65 WHERE `mapId`=565 AND `difficulty`=0; diff --git a/sql/updates/world/3.3.5/2023_06_11_00_world.sql b/sql/updates/world/3.3.5/2023_06_11_00_world.sql deleted file mode 100644 index 58b5b980d22..00000000000 --- a/sql/updates/world/3.3.5/2023_06_11_00_world.sql +++ /dev/null @@ -1,83 +0,0 @@ --- Darkmoon Faire (Elwyn Forest) -UPDATE `holiday_dates` SET `date_value`=391135232 WHERE `id`=374 AND `date_id`=0; -- 2023-06-02 -UPDATE `holiday_dates` SET `date_value`=394264576 WHERE `id`=374 AND `date_id`=1; -- 2023-09-01 -UPDATE `holiday_dates` SET `date_value`=397410304 WHERE `id`=374 AND `date_id`=2; -- 2023-12-01 -UPDATE `holiday_dates` SET `date_value`=404750336 WHERE `id`=374 AND `date_id`=3; -- 2024-03-01 -UPDATE `holiday_dates` SET `date_value`=407339008 WHERE `id`=374 AND `date_id`=4; -- 2024-05-31 -UPDATE `holiday_dates` SET `date_value`=410468352 WHERE `id`=374 AND `date_id`=5; -- 2024-08-30 -UPDATE `holiday_dates` SET `date_value`=413597696 WHERE `id`=374 AND `date_id`=6; -- 2024-11-29 -UPDATE `holiday_dates` SET `date_value`=420921344 WHERE `id`=374 AND `date_id`=7; -- 2025-02-28 -UPDATE `holiday_dates` SET `date_value`=424099840 WHERE `id`=374 AND `date_id`=8; -- 2025-05-30 -UPDATE `holiday_dates` SET `date_value`=427229184 WHERE `id`=374 AND `date_id`=9; -- 2025-08-29 -UPDATE `holiday_dates` SET `date_value`=430358528 WHERE `id`=374 AND `date_id`=10; -- 2025-11-28 -UPDATE `holiday_dates` SET `date_value`=437682176 WHERE `id`=374 AND `date_id`=11; -- 2026-02-27 -UPDATE `holiday_dates` SET `date_value`=440860672 WHERE `id`=374 AND `date_id`=12; -- 2026-05-29 -UPDATE `holiday_dates` SET `date_value`=443990016 WHERE `id`=374 AND `date_id`=13; -- 2026-08-28 -UPDATE `holiday_dates` SET `date_value`=447119360 WHERE `id`=374 AND `date_id`=14; -- 2026-11-27 -UPDATE `holiday_dates` SET `date_value`=454443008 WHERE `id`=374 AND `date_id`=15; -- 2027-02-26 -UPDATE `holiday_dates` SET `date_value`=457621504 WHERE `id`=374 AND `date_id`=16; -- 2027-05-28 -UPDATE `holiday_dates` SET `date_value`=460750848 WHERE `id`=374 AND `date_id`=17; -- 2027-08-27 -UPDATE `holiday_dates` SET `date_value`=463880192 WHERE `id`=374 AND `date_id`=18; -- 2027-11-26 -UPDATE `holiday_dates` SET `date_value`=471203840 WHERE `id`=374 AND `date_id`=19; -- 2028-02-25 -UPDATE `holiday_dates` SET `date_value`=474365952 WHERE `id`=374 AND `date_id`=20; -- 2028-05-26 -UPDATE `holiday_dates` SET `date_value`=477495296 WHERE `id`=374 AND `date_id`=21; -- 2028-08-25 -UPDATE `holiday_dates` SET `date_value`=480624640 WHERE `id`=374 AND `date_id`=22; -- 2028-11-24 -UPDATE `holiday_dates` SET `date_value`=487948288 WHERE `id`=374 AND `date_id`=23; -- 2029-02-23 -UPDATE `holiday_dates` SET `date_value`=491126784 WHERE `id`=374 AND `date_id`=24; -- 2029-05-25 -UPDATE `holiday_dates` SET `date_value`=494256128 WHERE `id`=374 AND `date_id`=25; -- 2029-08-24 - --- Darkmoon Faire (Mulgore) -UPDATE `holiday_dates` SET `date_value`=391593984 WHERE `id`=375 AND `date_id`=0; -- 2023-06-30 -UPDATE `holiday_dates` SET `date_value`=394723328 WHERE `id`=375 AND `date_id`=1; -- 2023-09-29 -UPDATE `holiday_dates` SET `date_value`=397869056 WHERE `id`=375 AND `date_id`=2; -- 2023-12-29 -UPDATE `holiday_dates` SET `date_value`=405209088 WHERE `id`=375 AND `date_id`=3; -- 2024-03-29 -UPDATE `holiday_dates` SET `date_value`=408338432 WHERE `id`=375 AND `date_id`=4; -- 2024-06-28 -UPDATE `holiday_dates` SET `date_value`=411467776 WHERE `id`=375 AND `date_id`=5; -- 2024-09-27 -UPDATE `holiday_dates` SET `date_value`=414613504 WHERE `id`=375 AND `date_id`=6; -- 2024-12-27 -UPDATE `holiday_dates` SET `date_value`=421969920 WHERE `id`=375 AND `date_id`=7; -- 2025-03-28 -UPDATE `holiday_dates` SET `date_value`=425099264 WHERE `id`=375 AND `date_id`=8; -- 2025-06-27 -UPDATE `holiday_dates` SET `date_value`=428228608 WHERE `id`=375 AND `date_id`=9; -- 2025-09-26 -UPDATE `holiday_dates` SET `date_value`=431374336 WHERE `id`=375 AND `date_id`=10; -- 2025-12-26 -UPDATE `holiday_dates` SET `date_value`=438730752 WHERE `id`=375 AND `date_id`=11; -- 2026-03-27 -UPDATE `holiday_dates` SET `date_value`=441860096 WHERE `id`=375 AND `date_id`=12; -- 2026-06-26 -UPDATE `holiday_dates` SET `date_value`=444989440 WHERE `id`=375 AND `date_id`=13; -- 2026-09-25 -UPDATE `holiday_dates` SET `date_value`=448135168 WHERE `id`=375 AND `date_id`=14; -- 2026-12-25 -UPDATE `holiday_dates` SET `date_value`=455491584 WHERE `id`=375 AND `date_id`=15; -- 2027-03-26 -UPDATE `holiday_dates` SET `date_value`=458620928 WHERE `id`=375 AND `date_id`=16; -- 2027-06-25 -UPDATE `holiday_dates` SET `date_value`=461750272 WHERE `id`=375 AND `date_id`=17; -- 2027-09-24 -UPDATE `holiday_dates` SET `date_value`=464896000 WHERE `id`=375 AND `date_id`=18; -- 2027-12-24 -UPDATE `holiday_dates` SET `date_value`=472236032 WHERE `id`=375 AND `date_id`=19; -- 2028-03-24 -UPDATE `holiday_dates` SET `date_value`=475365376 WHERE `id`=375 AND `date_id`=20; -- 2028-06-23 -UPDATE `holiday_dates` SET `date_value`=478494720 WHERE `id`=375 AND `date_id`=21; -- 2028-09-22 -UPDATE `holiday_dates` SET `date_value`=481640448 WHERE `id`=375 AND `date_id`=22; -- 2028-12-22 -UPDATE `holiday_dates` SET `date_value`=488996864 WHERE `id`=375 AND `date_id`=23; -- 2029-03-23 -UPDATE `holiday_dates` SET `date_value`=492126208 WHERE `id`=375 AND `date_id`=24; -- 2029-06-22 -UPDATE `holiday_dates` SET `date_value`=495255552 WHERE `id`=375 AND `date_id`=25; -- 2029-09-21 - --- Darkmoon Faire (Terokkar Forest) -UPDATE `holiday_dates` SET `date_value`=393265152 WHERE `id`=376 AND `date_id`=0; -- 2023-08-04 -UPDATE `holiday_dates` SET `date_value`=396394496 WHERE `id`=376 AND `date_id`=1; -- 2023-11-03 -UPDATE `holiday_dates` SET `date_value`=403718144 WHERE `id`=376 AND `date_id`=2; -- 2024-02-02 -UPDATE `holiday_dates` SET `date_value`=406880256 WHERE `id`=376 AND `date_id`=3; -- 2024-05-03 -UPDATE `holiday_dates` SET `date_value`=410009600 WHERE `id`=376 AND `date_id`=4; -- 2024-08-02 -UPDATE `holiday_dates` SET `date_value`=413138944 WHERE `id`=376 AND `date_id`=5; -- 2024-11-01 -UPDATE `holiday_dates` SET `date_value`=419921920 WHERE `id`=376 AND `date_id`=6; -- 2025-01-31 -UPDATE `holiday_dates` SET `date_value`=423641088 WHERE `id`=376 AND `date_id`=7; -- 2025-05-02 -UPDATE `holiday_dates` SET `date_value`=426770432 WHERE `id`=376 AND `date_id`=8; -- 2025-08-01 -UPDATE `holiday_dates` SET `date_value`=429359104 WHERE `id`=376 AND `date_id`=9; -- 2025-10-31 -UPDATE `holiday_dates` SET `date_value`=436682752 WHERE `id`=376 AND `date_id`=10; -- 2026-01-30 -UPDATE `holiday_dates` SET `date_value`=440401920 WHERE `id`=376 AND `date_id`=11; -- 2026-05-01 -UPDATE `holiday_dates` SET `date_value`=442990592 WHERE `id`=376 AND `date_id`=12; -- 2026-07-31 -UPDATE `holiday_dates` SET `date_value`=446119936 WHERE `id`=376 AND `date_id`=13; -- 2026-10-30 -UPDATE `holiday_dates` SET `date_value`=453443584 WHERE `id`=376 AND `date_id`=14; -- 2027-01-29 -UPDATE `holiday_dates` SET `date_value`=456605696 WHERE `id`=376 AND `date_id`=15; -- 2027-04-30 -UPDATE `holiday_dates` SET `date_value`=459751424 WHERE `id`=376 AND `date_id`=16; -- 2027-07-30 -UPDATE `holiday_dates` SET `date_value`=462880768 WHERE `id`=376 AND `date_id`=17; -- 2027-10-29 -UPDATE `holiday_dates` SET `date_value`=470204416 WHERE `id`=376 AND `date_id`=18; -- 2028-01-28 -UPDATE `holiday_dates` SET `date_value`=473350144 WHERE `id`=376 AND `date_id`=19; -- 2028-04-28 -UPDATE `holiday_dates` SET `date_value`=476495872 WHERE `id`=376 AND `date_id`=20; -- 2028-07-28 -UPDATE `holiday_dates` SET `date_value`=479625216 WHERE `id`=376 AND `date_id`=21; -- 2028-10-27 -UPDATE `holiday_dates` SET `date_value`=486948864 WHERE `id`=376 AND `date_id`=22; -- 2029-01-26 -UPDATE `holiday_dates` SET `date_value`=490110976 WHERE `id`=376 AND `date_id`=23; -- 2029-04-27 -UPDATE `holiday_dates` SET `date_value`=493256704 WHERE `id`=376 AND `date_id`=24; -- 2029-07-27 -UPDATE `holiday_dates` SET `date_value`=496386048 WHERE `id`=376 AND `date_id`=25; -- 2029-10-26 diff --git a/sql/updates/world/3.3.5/2023_06_11_01_world.sql b/sql/updates/world/3.3.5/2023_06_11_01_world.sql deleted file mode 100644 index e246908b08f..00000000000 --- a/sql/updates/world/3.3.5/2023_06_11_01_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- "Inoculation" (9303) is missing Reward next quest -UPDATE `quest_template` SET `RewardNextQuest`=9309 WHERE `Id`=9303; - --- "Urgent Delivery!" (9409) is missing Reward next quest -UPDATE `quest_template` SET `RewardNextQuest`=9283 WHERE `Id`=9409; diff --git a/sql/updates/world/3.3.5/2023_06_11_02_world.sql b/sql/updates/world/3.3.5/2023_06_11_02_world.sql deleted file mode 100644 index a3fd03e9080..00000000000 --- a/sql/updates/world/3.3.5/2023_06_11_02_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- The reward text for quest "Priest Training" (9291) are missing line breaks and should have lower case "c" in class name. -UPDATE `quest_offer_reward` SET `RewardText` = "It gives me great hope for our future that you come seeking my wisdom. While I have my hands full here with our injured, I am not so busy that I cannot spare a moment to aid you in your first steps as a $c. To walk in the Light is the highest of callings, and one that I am certain you are more than ready to undertake!$b$bSpeak with me again when you feel that you are ready to begin your training." WHERE ID=9291; - --- The reward text for quest "Mage Training" (9290) are missing line breaks. -UPDATE `quest_offer_reward` SET `RewardText` = "I am pleased that you have come seeking my knowledge. We have much to do if your magical skills are to be honed.$b$bFor over a hundred years I have taught the arcane, frost and fire magics, and I can feel them just as strongly on this world. Would you like me to impart some of what I know to you?" WHERE ID=9290; diff --git a/sql/updates/world/3.3.5/2023_06_11_03_world.sql b/sql/updates/world/3.3.5/2023_06_11_03_world.sql deleted file mode 100644 index 1a16ec79528..00000000000 --- a/sql/updates/world/3.3.5/2023_06_11_03_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- "Vindicator Aldar" (10304) should be breadcrumb quest -UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=9303 WHERE `ID`=10304; - --- "Seek Huntress Kella Nightbow" (9759) should be breadcrumb quest -UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=9591 WHERE `ID`=9757; diff --git a/sql/updates/world/3.3.5/2023_06_11_04_world.sql b/sql/updates/world/3.3.5/2023_06_11_04_world.sql deleted file mode 100644 index 258d9a16731..00000000000 --- a/sql/updates/world/3.3.5/2023_06_11_04_world.sql +++ /dev/null @@ -1,35 +0,0 @@ --- Convert SMALLINT TO INT for VerifiedBuild tables -ALTER TABLE areatrigger_teleport MODIFY VerifiedBuild INTEGER; -ALTER TABLE broadcast_text_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE creature_equip_template MODIFY VerifiedBuild INTEGER; -ALTER TABLE creature_questitem MODIFY VerifiedBuild INTEGER; -ALTER TABLE creature_template MODIFY VerifiedBuild INTEGER; -ALTER TABLE creature_template_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE creature_template_resistance MODIFY VerifiedBuild INTEGER; -ALTER TABLE creature_template_spell MODIFY VerifiedBuild INTEGER; -ALTER TABLE gameobject MODIFY VerifiedBuild INTEGER; -ALTER TABLE gameobject_questitem MODIFY VerifiedBuild INTEGER; -ALTER TABLE gameobject_template MODIFY VerifiedBuild INTEGER; -ALTER TABLE gameobject_template_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE item_set_names MODIFY VerifiedBuild INTEGER; -ALTER TABLE item_set_names_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE item_template MODIFY VerifiedBuild INTEGER; -ALTER TABLE item_template_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE lfg_dungeon_template MODIFY VerifiedBuild INTEGER; -ALTER TABLE npc_text MODIFY VerifiedBuild INTEGER; -ALTER TABLE npc_vendor MODIFY VerifiedBuild INTEGER; -ALTER TABLE page_text_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE points_of_interest MODIFY VerifiedBuild INTEGER; -ALTER TABLE points_of_interest_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_greeting MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_greeting_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_offer_reward_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_poi MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_poi_points MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_request_items_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_template MODIFY VerifiedBuild INTEGER; -ALTER TABLE quest_template_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE spell_target_position MODIFY VerifiedBuild INTEGER; -ALTER TABLE trainer MODIFY VerifiedBuild INTEGER; -ALTER TABLE trainer_locale MODIFY VerifiedBuild INTEGER; -ALTER TABLE trainer_spell MODIFY VerifiedBuild INTEGER; diff --git a/sql/updates/world/3.3.5/2023_06_11_05_world.sql b/sql/updates/world/3.3.5/2023_06_11_05_world.sql deleted file mode 100644 index b305f47a2f4..00000000000 --- a/sql/updates/world/3.3.5/2023_06_11_05_world.sql +++ /dev/null @@ -1,5 +0,0 @@ --- Add two missing mailbox in Moonglade Nighthaven -DELETE FROM `gameobject` WHERE `guid` IN (100507, 100508); -INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES -(100507, 195218, 1, 0, 0, 1, 1, 8008.7421875, -2668.053955078125, 512.06414794921875, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 0), -(100508, 195219, 1, 0, 0, 1, 1, 7867.26904296875, -2575.546875, 486.91259765625, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, 0); diff --git a/sql/updates/world/3.3.5/2023_06_14_00_world.sql b/sql/updates/world/3.3.5/2023_06_14_00_world.sql new file mode 100644 index 00000000000..9820cf651bf --- /dev/null +++ b/sql/updates/world/3.3.5/2023_06_14_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.23061 world +UPDATE `version` SET `db_version`='TDB 335.23061', `cache_id`=23061 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; -- cgit v1.2.3