Core/DBLayer: Restore pinfo ban info output

2 files changed, 10 insertions, 2 deletions

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();
     }