Core/PacketIO: Rewrite updatefield handling

2 files changed, 4 insertions, 20 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index cd0f77945c2..9dc252d866b 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -754,11 +754,8 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,304),
 (196,305),
 (196,306),
-(196,307),
-(196,308),
 (196,309),
 (196,310),
-(196,313),
 (196,314),
 (196,319),
 (196,320),
@@ -773,13 +770,9 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,329),
 (196,330),
 (196,331),
-(196,332),
-(196,333),
-(196,334),
 (196,335),
 (196,336),
 (196,337),
-(196,338),
 (196,339),
 (196,340),
 (196,341),
@@ -1199,7 +1192,6 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (198,532),
 (198,544),
 (198,545),
-(198,546),
 (198,547),
 (198,548),
 (198,549),
@@ -1452,13 +1444,10 @@ INSERT INTO `rbac_permissions` VALUES
 (304,'Command: debug bg'),
 (305,'Command: debug entervehicle'),
 (306,'Command: debug getitemstate'),
-(307,'Command: debug getitemvalue'),
-(308,'Command: debug getvalue'),
 (309,'Command: debug hostil'),
 (310,'Command: debug itemexpire'),
 (311,'Command: debug lootrecipient'),
 (312,'Command: debug los'),
-(313,'Command: debug mod32value'),
 (314,'Command: debug moveflags'),
 (315,'Command: debug play'),
 (316,'Command: debug play cinematics'),
@@ -1477,13 +1466,9 @@ INSERT INTO `rbac_permissions` VALUES
 (329,'Command: debug send setphaseshift'),
 (330,'Command: debug send spellfail'),
 (331,'Command: debug setaurastate'),
-(332,'Command: debug setbit'),
-(333,'Command: debug setitemvalue'),
-(334,'Command: debug setvalue'),
 (335,'Command: debug setvid'),
 (336,'Command: debug spawnvehicle'),
 (337,'Command: debug threat'),
-(338,'Command: debug update'),
 (339,'Command: debug uws'),
 (340,'Command: wpgps'),
 (341,'Command: deserter'),
@@ -1690,7 +1675,6 @@ INSERT INTO `rbac_permissions` VALUES
 (543,'Command: demorph'),
 (544,'Command: modify'),
 (545,'Command: modify arenapoints'),
-(546,'Command: modify bit'),
 (547,'Command: modify drunk'),
 (548,'Command: modify energy'),
 (549,'Command: modify faction'),
@@ -2195,7 +2179,8 @@ INSERT INTO `updates` VALUES
 ('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','RELEASED','2018-06-29 22:34:04',0),
 ('2018_12_09_00_auth_2017_01_06_00_auth.sql','6CCFE6A9774EC733C9863D36A0F15F3534189BBD','RELEASED','2018-11-22 22:21:26',0),
 ('2018_12_09_01_auth.sql','576C2A11BE671D8420FA3EB705E594E381ECCC56','RELEASED','2018-12-09 14:49:17',0),
-('2019_06_08_00_auth.sql','EA5A78F5A26C17BC790481EA9B3772D3A6912459','RELEASED','2019-05-20 17:21:20',0);
+('2019_06_08_00_auth.sql','EA5A78F5A26C17BC790481EA9B3772D3A6912459','RELEASED','2019-05-20 17:21:20',0),
+('2019_06_08_01_auth.sql','8165B1B787E3ECF0C8C0AD2D641513270977ABB4','RELEASED','2019-06-04 16:51:31',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index fa28bd1fa25..5933558354a 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1625,7 +1625,6 @@ CREATE TABLE `character_void_storage` (
   `creatorGuid` bigint(20) unsigned NOT NULL DEFAULT '0',
   `randomPropertyType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `randomProperty` int(10) unsigned NOT NULL DEFAULT '0',
-  `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0',
   `upgradeId` int(10) unsigned NOT NULL DEFAULT '0',
   `fixedScalingLevel` int(10) unsigned DEFAULT '0',
   `artifactKnowledgeLevel` int(10) unsigned DEFAULT '0',
@@ -2970,7 +2969,6 @@ CREATE TABLE `item_loot_items` (
   `needs_quest` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'quest drop',
   `rnd_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'random enchantment type',
   `rnd_prop` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled',
-  `rnd_suffix` int(10) NOT NULL DEFAULT '0' COMMENT 'random suffix added when originally rolled',
   `context` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `bonus_list_ids` text COMMENT 'Space separated list of bonus list ids',
   PRIMARY KEY (`container_id`,`item_id`)
@@ -3571,7 +3569,8 @@ INSERT INTO `updates` VALUES
 ('2018_07_31_00_characters.sql','7DA8D4A4534520B23E6F5BBD5B8EE205B799C798','RELEASED','2018-07-31 20:54:39',0),
 ('2018_12_09_00_characters.sql','7FE9641C93ED762597C08F1E9B6649C9EC2F0E47','RELEASED','2018-09-18 23:34:29',0),
 ('2018_12_09_01_characters.sql','C80B936AAD94C58A0F33382CED08CFB4E0B6AC34','RELEASED','2018-10-10 22:05:28',0),
-('2018_12_09_02_characters.sql','DBBA0C06985CE8AC4E6E7E94BD6B2673E9ADFAE2','RELEASED','2018-12-02 17:32:31',0);
+('2018_12_09_02_characters.sql','DBBA0C06985CE8AC4E6E7E94BD6B2673E9ADFAE2','RELEASED','2018-12-02 17:32:31',0),
+('2019_06_08_00_characters.sql','6C5AF52AEF03BC019B96E7A07592C22660F9327B','RELEASED','2019-06-03 20:04:47',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;