From ffbee169f49d2eba408d76a1e181a3e4589dd8ab Mon Sep 17 00:00:00 2001 From: leak Date: Sun, 25 Mar 2012 21:22:53 +0200 Subject: Core/DBLayer: Restore pinfo ban info output --- sql/updates/auth/2012_03_25_00_auth_misc.sql | 8 ++++++++ src/server/game/Chat/Commands/Level2.cpp | 4 ++-- 2 files changed, 10 insertions(+), 2 deletions(-) create mode 100644 sql/updates/auth/2012_03_25_00_auth_misc.sql diff --git a/sql/updates/auth/2012_03_25_00_auth_misc.sql b/sql/updates/auth/2012_03_25_00_auth_misc.sql new file mode 100644 index 00000000000..f34882af8f6 --- /dev/null +++ b/sql/updates/auth/2012_03_25_00_auth_misc.sql @@ -0,0 +1,8 @@ +ALTER TABLE `account_banned` + CHANGE `bandate` `bandate` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `unbandate` `unbandate` INT(10) UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `ip_banned` + CHANGE `ip` `ip` VARCHAR(15) CHARSET utf8 COLLATE utf8_general_ci DEFAULT '127.0.0.1' NOT NULL, + CHANGE `bandate` `bandate` INT(10) UNSIGNED NOT NULL, + CHANGE `unbandate` `unbandate` INT(10) UNSIGNED NOT NULL; diff --git a/src/server/game/Chat/Commands/Level2.cpp b/src/server/game/Chat/Commands/Level2.cpp index ca6a43457f1..cc7c9020d38 100755 --- a/src/server/game/Chat/Commands/Level2.cpp +++ b/src/server/game/Chat/Commands/Level2.cpp @@ -395,8 +395,8 @@ bool ChatHandler::HandlePInfoCommand(const char* args) if (result2) { - Field* fields = result->Fetch(); - banTime = fields[1].GetBool() ? 0 : fields[0].GetUInt64(); + Field* fields = result2->Fetch(); + banTime = int64(fields[1].GetBool() ? 0 : fields[0].GetUInt32()); bannedby = fields[2].GetString(); banreason = fields[3].GetString(); } -- cgit v1.2.3