aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
AgeCommit message (Collapse)Author
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
2013-09-02Core/RBAC: Move honor commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move guild commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move gobject commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move go commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move gm commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move event commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move disable commands to RBAC (using individual permissions)Spp
2013-09-02Normalize sql file names from 722a6c1Spp
2013-09-02Core/RBAC: Move deserter commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move debug commands to RBAC (using individual permissions)Spp
2013-09-02Core/RBAC: Move cheat commands to RBAC (using individual permissions)Spp
2013-09-01Core/Account: Make account password change security variable and various changesAscathor
Settings within worldserver.conf: Three settings for secruity level: 0 - None - No change to current system 1 - Email - Always requires the email entered on registration for confirming. 2 - RBAC - Groups applied with the RBAC role always require the email entered on registration for confirming. RBAC default to every group. Changed some logs to make it more clear what is going on at all. Emails may now no longer exceed 64 chars. Current email is used as regmail. On account creation, two emails are saved. Registration email and normal email. Normal email is relevant afterwards. Registration email can be changed by console ONLY. Includes new commands and changes to existing ones: .account fulfills several new functions: * Still prints GM Level. * If account has permission, it displays the current email. This is not defaulted to any group. * Security level is displayed. Also displays if user has RBAC perm if RBAC security mode is selected .account email allows user to change email with sufficient confirmation .account set sec email allows higher sec with higher sec than account to change the normal email. Registrationemail remains untouched here. .account set sec regmail allows console to change registration email. .pinfo now displays the registration and normal mail. Also fixes .learn all crafts. Closes #10558
2013-08-31Core/RBAC: Move bf commands to RBAC (using individual permissions)Nay
2013-08-30Core/RBAC: Move ban commands to RBAC (using individual permissions)Spp
2013-08-30Core/RBAC: Move Achievements and Arena commands to RBAC (using individual ↵Spp
permissions)
2013-08-30Core/RBAC: Move account commands to RBAC (using individual permissions)Spp
2013-08-30Corrections to ea26928 sql filesSpp
2013-08-30Core/RBAC: Move RBAC commands to RBAC using individual permissionsSpp
- Use this commit as a sample on how to move commands to RBAC
2013-08-25Core/Auth: Implement time-based token for user login as described in RFC 6238.raczman
New column in account table is a base32 of token key bytes, coincidentally it is the same format Google's Authenticator Android app uses. If you want that to work, set system time on server correctly and use ntpd. Closes #10527 Signed-off-by: Nay <dnpd.dd@gmail.com>