From 6215da0d640bd86a7c2bc144859c1542f09fc1a6 Mon Sep 17 00:00:00 2001 From: Giacomo Pozzoni Date: Thu, 17 Sep 2020 21:49:52 +0200 Subject: Script/Commands: Add ".pdump copy" command (#25455) * Script/Commands: Add ".pdump copy" command Syntax: .pdump copy $playerNameOrGUID $account [$newname] [$newguid] Copy character with name/guid $playerNameOrGUID into character list of $account with $newname, with first free or $newguid guid. * Add missing return * Restore eof check * Fix sql * Use forward declaration header Co-authored-by: Shauren * Remove buffer when reading a line * Rename sql files Co-authored-by: Shauren --- sql/base/auth_database.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'sql/base/auth_database.sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index dba680bea8b..47484732f4d 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1783,7 +1783,8 @@ INSERT INTO `rbac_permissions` VALUES (876,'Command: lookup item id'), (877,'Command: lookup quest id'), (878,'Command: debug questreset'), -(879,'Command: debug poolstatus'); +(879,'Command: debug poolstatus'), +(880,'Command: pdump copy'); /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */; UNLOCK TABLES; @@ -1972,7 +1973,8 @@ INSERT INTO `updates` VALUES ('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 00:00:00',0), ('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','ARCHIVED','2020-08-22 00:00:00',0), ('2020_09_06_00_auth.sql','DC4B5D4C65EB138D5609F137799C3289B9CC2493','ARCHIVED','2020-09-06 00:00:00',0), -('2020_09_15_00_auth.sql','0AA5BCA384A372DC789647F838657766D51D8CC7','ARCHIVED','2020-09-15 19:35:18',0); +('2020_09_15_00_auth.sql','0AA5BCA384A372DC789647F838657766D51D8CC7','ARCHIVED','2020-09-15 19:35:18',0), +('2020_09_17_00_auth.sql','BBC0A8B2BBED38A57A83999909EB066753A893C5','ARCHIVED','2020-09-17 00:00:00',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; -- cgit v1.2.3