From 6215da0d640bd86a7c2bc144859c1542f09fc1a6 Mon Sep 17 00:00:00 2001
From: Giacomo Pozzoni <giacomopoz@gmail.com>
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 <shauren.trinity@gmail.com>

* Remove buffer when reading a line

* Rename sql files

Co-authored-by: Shauren <shauren.trinity@gmail.com>
---
 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

