aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
AgeCommit message (Collapse)Author
2014-07-09Core/Battleground:joschiwald
* added a possibility to reload battleground templates * cleaned up the template structure * use mapids from BattlemasterList.dbc to calculate random bg
2014-07-05TDB 335.54 - 2014/07/05TDB335.54Vincent-Michael
2014-06-25SQL: Renamed updates to follow naming conventionShauren
2014-06-24Update 2014_06_23_00_action_ip_logger.sqlAokromes
2014-06-24SQL: Rename sql after merge prVincent-Michael
2014-06-23Merge pull request #11976 from Ascathor/masterAokromes
Core/Misc: New ability to log account IP access history
2014-06-14SQL: Renamed files to match the naming rulesShauren
2014-06-13Core/Misc:Ascathor
* 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
2014-04-28DB/RBAC: Fix rbac_permissions orderVincent-Michael
2014-04-25Core/Texts:Vincent-Michael
* Enable some BroadcastTexts stuff (is not finish) * Added reload command for broadcast_text table ToDo: - Enable: Sound/Emote stuff, etc. - Auth base need refresh
2014-03-29TDB 335.53 - 2014/03/29TDB335.53Duarte Duarte
2014-01-31SQL: Update old .sql files to keep consistency with auth_database.sqlDuarte Duarte
Also update characters_database.sql (generated by mysqldump)
2014-01-19Missing changes in 313b294d6b7b248738e30f8164ee4624a66ac5b5Vincent_Michael
2014-01-19Core/RBAC: Fix difference problems with 4.3.4Vincent_Michael
2014-01-19Misc/SQL: Rename SQL from fa2616fe4efa4651d48710c7458cd2d479e9338bDiscover-
2013-12-06Add mailbox commandCarbenium
2013-12-01Update 2013_12_01_00_auth_rbac_permissions.sqlAokromes
2013-12-01Core/Misc: Removed more unused eventAI stuffVincent_Michael
2013-12-01Core/AI: Good bye, Good bye my beloved EventAI system :(Vincent_Michael
2013-11-11Core/Logging: Minor changesSpp
- Select stderr when writing ERROR and FATAL messages - Simplify function defines - Fix `logs` table structure with latest logging changes
2013-10-16Fixed sql files for ce55647c415b710c6b440d96c2f26ebbc06c1d6eShauren
2013-10-16Core/TransportsShauren
* Rewritten path generation, now uses splines - timers are a lot more accurate now * Implemented stopping transports * Implemented spawning transports in instances * Implemented spawning gameobjects as transport passengers * Transport passengers are now stored in creature/gameobject table using gameobject_template.data6 from transport's template as map id
2013-09-29Fix compile under linux and update auth db with latest changesSpp
2013-09-29Core/RBAC: Simplify RBAC implementationSpp
- Drop groups (roles than can have inherited roles) and roles (set of permissions) - Permissions can now have inherited permissions (those act as roles) RBAC DB structure is now limited to four tables - rbac_permissions: Contains permissions and roles - rbac_linked_permissions: Contains the relation between permissions and linked permissions (those permissions that have linked permissions are called roles) - rbac_default_permissions: Contains the list of permissions to be granted to each security level [Added to maintain compatibility in an easy way] - rbac_account_permissions: Contains the list of permissions granted or denied for a particular account. NOTE: IF YOU ARE USING CUSTOM PERMISSIONS, ROLES OR GROUPS CHECK THE SQL BEFORE APPLYING...
2013-09-10Core/RBAC: Fix typos in recent SQL filesAokromes
I hope this is final one....
2013-09-10Core/RBAC: Fix typos in recent SQL filesSpp
2013-09-10Core/RBAC: Remove obsolete generic command permissionsSpp
Note: If you have any custom command, CHECK THE SQLS BEFORE APPLYING
2013-09-10Core/RBAC: Move titles and wp commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move ticket commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move tele commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move server commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move reset commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move reload command to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move quest commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move npc commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move modify commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move mmap commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move misc commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move send commands to RBAC (using individual permissions)Spp
2013-09-10Core/RBAC: Move pet commands to RBAC (using individual permissions)Spp
- Pet commands moved from cs_misc.cpp to own file
2013-09-10Core/RBAC: Move group commands to RBAC (using individual permissions)Spp
- group commands moved from cs_misc.cpp to own file - renamed groupsummon to "group summon"
2013-09-02Fix SQL typos after RBAC commitsSpp
2013-09-02Core/RBAC: Move cast and characters commands to RBAC (using individual ↵Nay
permissions)
2013-09-02Compile Fix (and edit of last 2 sqls to add the missing permissions)Spp
2013-09-02Core/RBAC: Move message commands to RBAC (using individual permissions)Spp
2013-09-02Core/Commands: Move lookup commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move list commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move lfg commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move learn commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move instance commands to RBAC (using individual permissions)Spp