TDB 335.19091 - 2019/09/15TDB335.19091

29 files changed, 15 insertions, 5 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 61c08d40e26..8e6557fb577 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1833,7 +1833,8 @@ INSERT INTO `updates` VALUES
 ('2019_07_17_00_auth.sql','4F983F039904894ACC483BE885676C5F0A18F06B','ARCHIVED','2019-07-17 00:00:00',0),
 ('2019_08_10_00_auth.sql','E936802893474BB9B459D01BB5F181F54EDF0653','ARCHIVED','2019-08-10 00:00:00',0),
 ('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0),
-('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0);
+('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0),
+('2019_09_15_00_auth.sql','2EEE632B5A365D45747B7BB25DE5239FB5B1A1BD','ARCHIVED','2019-09-15 09:21:36',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -1935,4 +1936,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 2019-08-16  6:25:10
+-- Dump completed on 2019-09-15  9:21:37
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index b786a9e588f..8e78687cb1e 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2636,7 +2636,8 @@ INSERT INTO `updates` VALUES
 ('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0),
 ('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0),
 ('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0),
-('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0);
+('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0),
+('2019_09_15_00_characters.sql','75F3355AF6E9C0A2CAF5F523D87208C726C9D042','ARCHIVED','2019-09-15 09:21:36',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2803,4 +2804,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-08-16  6:25:11
+-- Dump completed on 2019-09-15  9:21:37
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 82243763ca4..33ad1402358 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -3443,6 +3443,7 @@ CREATE TABLE `spell_proc` (
   `SpellPhaseMask` int(10) unsigned NOT NULL DEFAULT '0',
   `HitMask` int(10) unsigned NOT NULL DEFAULT '0',
   `AttributesMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0',
   `ProcsPerMinute` float NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '0',
   `Cooldown` int(10) unsigned NOT NULL DEFAULT '0',
@@ -3842,4 +3843,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2019-08-16  6:25:11
+-- Dump completed on 2019-09-15  9:21:37
diff --git a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql
index 6544c316449..6544c316449 100644
--- a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql
index 5d9a26ec653..5d9a26ec653 100644
--- a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2019_08_16_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql
index 7cb4c1c9abb..7cb4c1c9abb 100644
--- a/sql/updates/world/3.3.5/2019_08_16_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_17_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql
index 860c830e416..860c830e416 100644
--- a/sql/updates/world/3.3.5/2019_08_17_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_17_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql
index f9239dd8a2e..f9239dd8a2e 100644
--- a/sql/updates/world/3.3.5/2019_08_17_01_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_17_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql
index fa322bbb391..fa322bbb391 100644
--- a/sql/updates/world/3.3.5/2019_08_17_02_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_18_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql
index bc781184e28..bc781184e28 100644
--- a/sql/updates/world/3.3.5/2019_08_18_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_22_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql
index d5b8414eaa8..d5b8414eaa8 100644
--- a/sql/updates/world/3.3.5/2019_08_22_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_30_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql
index 7f0e90367a7..7f0e90367a7 100644
--- a/sql/updates/world/3.3.5/2019_08_30_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_07_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql
index 4b5eb530785..4b5eb530785 100644
--- a/sql/updates/world/3.3.5/2019_09_07_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_07_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql
index f47fcb7d056..f47fcb7d056 100644
--- a/sql/updates/world/3.3.5/2019_09_07_01_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_07_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql
index 3b100cd4b75..3b100cd4b75 100644
--- a/sql/updates/world/3.3.5/2019_09_07_02_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_07_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql
index cc2285867f9..cc2285867f9 100644
--- a/sql/updates/world/3.3.5/2019_09_07_03_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_07_04_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql
index e465b964d02..e465b964d02 100644
--- a/sql/updates/world/3.3.5/2019_09_07_04_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_08_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql
index 613583dbd6b..613583dbd6b 100644
--- a/sql/updates/world/3.3.5/2019_09_08_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_08_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql
index 852c6588cb8..852c6588cb8 100644
--- a/sql/updates/world/3.3.5/2019_09_08_01_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_09_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql
index 68eb8bdd2c0..68eb8bdd2c0 100644
--- a/sql/updates/world/3.3.5/2019_09_09_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql
index 7fd1fa416d6..7fd1fa416d6 100644
--- a/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_09_09_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql
index 595175a2f40..595175a2f40 100644
--- a/sql/updates/world/3.3.5/2019_09_09_02_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_10_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql
index 7afa08f854e..7afa08f854e 100644
--- a/sql/updates/world/3.3.5/2019_09_10_00_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_12_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql
index e492c6cdb5a..e492c6cdb5a 100644
--- a/sql/updates/world/3.3.5/2019_09_12_01_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_12_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql
index 805033401e7..805033401e7 100644
--- a/sql/updates/world/3.3.5/2019_09_12_02_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_09_12_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql
index 033a7471c56..033a7471c56 100644
--- a/sql/updates/world/3.3.5/2019_09_12_03_world.sql
+++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql
diff --git a/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql b/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql
new file mode 100644
index 00000000000..2bca2a89a56
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19091 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql b/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql
new file mode 100644
index 00000000000..e01645f91b0
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19091 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2019_09_15_00_world.sql b/sql/updates/world/3.3.5/2019_09_15_00_world.sql
new file mode 100644
index 00000000000..6d3536df062
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_09_15_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.19091 world
+UPDATE `version` SET `db_version`='TDB 335.19091', `cache_id`=19091 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';