diff options
| author | Ascathor <Break_the_Chain@web.de> | 2014-05-02 03:44:21 +0200 |
|---|---|---|
| committer | Ascathor <Break_the_Chain@web.de> | 2014-06-13 16:25:11 +0200 |
| commit | 6949735098144e478451e73179ca2d9c6e7344f7 (patch) | |
| tree | 083b22ce75e2a5b40f6623c18feb74e8dd448063 /sql/base | |
| parent | 58043720420a0f59e95a5e7d226fec3ee98ebfa4 (diff) | |
Core/Misc:
* Fix some codestyle, fix some typos
* Change CMakeLists for: Custom (can be uncommented), Events, World
** Custom is theoretically unchanged. You can, however, uncomment the glob_recurse that initializes every file within. This might be easier for beginners.
* Introducing the IP Based Action Log System:
** On several different actions, e.g. Login, Character Login, etc., a new entry is added
** Can be logged on and off in worldserver config
*** Disabled by default to prevent increased log db size for unknowing users.
* Add a new row to account table called 'last_attempt_ip'
** Lists the last ip trying to connect to the account
* Add a new type of HookScripts: AccountScript
** Includes: OnAccountLogin, OnFailedAccountLogin, OnEmailChange, OnFailedChange, OnPasswordChange, OnFailedPasswordChange
* Added new Hook to PlayerScripts: OnFailedPlayerDelete
* Added new variables to PlayerScripts: OnPlayerDelete
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index a1337fbca12..be64a560798 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -34,6 +34,7 @@ CREATE TABLE `account` ( `reg_mail` varchar(255) NOT NULL DEFAULT '', `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', + `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', `failed_logins` int(10) unsigned NOT NULL DEFAULT '0', `locked` tinyint(3) unsigned NOT NULL DEFAULT '0', `lock_country` varchar(2) NOT NULL DEFAULT '00', @@ -240,6 +241,36 @@ LOCK TABLES `logs` WRITE; UNLOCK TABLES; -- +-- Table structure for table `logs_ip_actions` +-- + +DROP TABLE IF EXISTS `logs_ip_actions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `logs_ip_actions` ( +`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier', +`account_id` INT(10) UNSIGNED NOT NULL COMMENT 'Account ID', +`character_guid` INT(10) UNSIGNED NOT NULL COMMENT 'Character Guid', +`type` TINYINT(3) UNSIGNED NOT NULL, +`ip` VARCHAR(15) NOT NULL DEFAULT '127.0.0.1', +`systemnote` TEXT NULL COMMENT 'Notes inserted by system', +`unixtime` INT(10) UNSIGNED NOT NULL COMMENT 'Unixtime', +`time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp', +`comment` TEXT NULL COMMENT 'Allows users to add a comment', +PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `logs_ip_actions` +-- + +LOCK TABLES `logs_ip_actions` WRITE; +/*!40000 ALTER TABLE `logs_ip_actions` DISABLE KEYS */; +/*!40000 ALTER TABLE `logs_ip_actions` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `rbac_account_permissions` -- |