diff options
| -rw-r--r-- | sql/realmd.sql | 2 | ||||
| -rw-r--r-- | sql/updates/6712_realmd_account_access.sql | 1 | ||||
| -rw-r--r-- | src/game/WorldSocket.cpp | 20 |
3 files changed, 12 insertions, 11 deletions
diff --git a/sql/realmd.sql b/sql/realmd.sql index 41a1946cb1d..af983e72d30 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -20,7 +20,7 @@ -- CREATE TABLE `account_access` ( - `id` bigint(20) unsigned NOT NULL, + `id` int(11) unsigned NOT NULL, `gmlevel` tinyint(3) unsigned NOT NULL, `RealmID` int(11) NOT NULL, PRIMARY KEY (`id`,`RealmID`) diff --git a/sql/updates/6712_realmd_account_access.sql b/sql/updates/6712_realmd_account_access.sql new file mode 100644 index 00000000000..0ada6f615b9 --- /dev/null +++ b/sql/updates/6712_realmd_account_access.sql @@ -0,0 +1 @@ +ALTER TABLE `account_access` CHANGE `id` `id` int(11) UNSIGNED NOT NULL;
\ No newline at end of file diff --git a/src/game/WorldSocket.cpp b/src/game/WorldSocket.cpp index 34efa1066fb..0097da8f359 100644 --- a/src/game/WorldSocket.cpp +++ b/src/game/WorldSocket.cpp @@ -820,16 +820,16 @@ int WorldSocket::HandleAuthSession (WorldPacket& recvPacket) delete result; - // Checks gmlevel per Realm - result = - loginDatabase.PQuery ("SELECT " - "RealmID, " //0 - "gmlevel " //1 - "FROM account_access " - "WHERE id = '%d'" - " AND (RealmID = '%d'" - " OR RealmID = '-1')", - id, realmID); + // Checks gmlevel per Realm + result = + loginDatabase.PQuery ("SELECT " + "RealmID, " //0 + "gmlevel " //1 + "FROM account_access " + "WHERE id = '%d'" + " AND (RealmID = '%d'" + " OR RealmID = '-1')", + id, realmID); if(!result) security = 0; else |