diff options
| -rw-r--r-- | sql/base/auth_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2022_01_01_00_auth.sql | 1 | ||||
| -rw-r--r-- | src/server/scripts/World/action_ip_logger.cpp | 8 |
3 files changed, 8 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 0b7a5e69f96..0c3e4cd9993 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -341,7 +341,7 @@ DROP TABLE IF EXISTS `logs_ip_actions`; CREATE TABLE `logs_ip_actions` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier', `account_id` int unsigned NOT NULL COMMENT 'Account ID', - `character_guid` int unsigned NOT NULL COMMENT 'Character Guid', + `character_guid` bigint unsigned NOT NULL COMMENT 'Character Guid', `realm_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Realm ID', `type` tinyint unsigned NOT NULL, `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', @@ -1996,7 +1996,8 @@ INSERT INTO `updates` VALUES ('2021_09_28_00_auth.sql','07B3ECF2EBAF1F1C3692059CB3A05B1088A93E18','ARCHIVED','2021-09-28 20:48:10',0), ('2021_10_15_00_auth.sql','4FFD29A3ED1DB13874E755A84BFD7ABA2DF5C2DB','ARCHIVED','2021-10-15 08:43:41',0), ('2021_11_15_00_auth.sql','82D88B06301130C7149E21A991364F62279E219B','ARCHIVED','2021-11-15 16:22:37',0), -('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0); +('2021_12_16_00_auth.sql','A0765C5337833E827B029A5E29F8B7601C81F89E','ARCHIVED','2021-12-16 21:17:10',0), +('2022_01_01_00_auth.sql','CDC8349AA1135258D66F351141C0D9AD4EE7EB14','RELEASED','2022-01-01 19:35:19',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/3.3.5/2022_01_01_00_auth.sql b/sql/updates/auth/3.3.5/2022_01_01_00_auth.sql new file mode 100644 index 00000000000..cea9e9580b9 --- /dev/null +++ b/sql/updates/auth/3.3.5/2022_01_01_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `logs_ip_actions` MODIFY `character_guid` bigint unsigned NOT NULL COMMENT 'Character Guid'; diff --git a/src/server/scripts/World/action_ip_logger.cpp b/src/server/scripts/World/action_ip_logger.cpp index 4f207baa3c6..2c3ac642795 100644 --- a/src/server/scripts/World/action_ip_logger.cpp +++ b/src/server/scripts/World/action_ip_logger.cpp @@ -144,7 +144,7 @@ class AccountActionIpLogger : public AccountScript LoginDatabasePreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_INS_ALDL_IP_LOGGING); stmt->setUInt32(0, playerGuid); - stmt->setUInt32(1, characterGuid); + stmt->setUInt64(1, characterGuid); stmt->setUInt32(2, realmId); stmt->setUInt8(3, aType); stmt->setUInt32(4, playerGuid); @@ -156,7 +156,7 @@ class AccountActionIpLogger : public AccountScript LoginDatabasePreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_INS_FACL_IP_LOGGING); stmt->setUInt32(0, playerGuid); - stmt->setUInt32(1, characterGuid); + stmt->setUInt64(1, characterGuid); stmt->setUInt32(2, realmId); stmt->setUInt8(3, aType); stmt->setUInt32(4, playerGuid); @@ -240,7 +240,7 @@ class CharacterActionIpLogger : public PlayerScript LoginDatabasePreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_INS_CHAR_IP_LOGGING); stmt->setUInt32(0, playerGuid); - stmt->setUInt32(1, characterGuid); + stmt->setUInt64(1, characterGuid); stmt->setUInt32(2, realmId); stmt->setUInt8(3, aType); stmt->setString(4, currentIp); // We query the ip here. @@ -302,7 +302,7 @@ public: LoginDatabasePreparedStatement* stmt = LoginDatabase.GetPreparedStatement(LOGIN_INS_ALDL_IP_LOGGING); stmt->setUInt32(0, playerGuid); - stmt->setUInt32(1, characterGuid); + stmt->setUInt64(1, characterGuid); stmt->setUInt32(2, realmId); stmt->setUInt8(3, aType); stmt->setUInt32(4, playerGuid); |