aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
2013-10-17SQL: Update auth baseVincent-Michael
2013-09-30Core/RBAC: Fix errors in RBAC sql related to ea2fe0217dSpp
2013-09-29Fix compile under linux and update auth db with latest changesSpp
2013-09-10SQL: Update sql/base/auth_database.sqlNay
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-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>
2013-07-19Core/Misc: Change creatures and gameobject phasemask from 16 to 32 bitsVlad
Signed-off-by: Nay <dnpd.dd@gmail.com>
2013-06-02Merge pull request #9854 from Ascathor/masterSubv
Core/Command: Optimized .pinfo more
2013-06-02DB/Autobroadcast: Update correct db struktur and auth basejoschiwald
2013-05-26Core/Command: Optimized .pinfo moreAscathor
* Moved some checks around * Added RBAC Permission for Email, last login and last ip (group 3 and 4) -- If missing RBAC permission, then it displays "Unauthorized (RBAC)" * Changed totalmail output from uint64 to uint32 * Level either puts Max level, or a list of information necessary * Only queries guild if the current xp query also detects guild membership * Incorporated recent changes into code * Commander requires higher than target to get sensitive data beside RBAC permission.
2013-04-26Update auth_database.sql due the added ip2nation tables.Bezo
2013-04-22[Ip2nationLock] Implement the ip2nation lock country.Bezo
2013-04-05Core/PacketIO: Implemented possibility to ban client addons serversideShauren
2013-03-09SQL: Update sql/base/auth_database.sqlNay
2013-03-04Core/Players: Implemented converting quests on faction change (keeping old ↵Shauren
faction quests in disabled state - not loaded during login) and restoring them if changing back to original faction Closes #890 Closes #9248
2013-02-26Core&SQL: Fix typos (RBAC and equips related)Nay
2013-02-26sql typo fixesSpp
2013-02-26Core/RBAC: Correction to last sqls and update base/auth_database.sqlSpp
2013-02-08Core/Auth: Reverted part of fb43a92cc2aaffab42efebf025b6a12c01af8fde - ↵Shauren
session key is still needed after logging in to be able to switch realms
2013-02-07Core/Accounts: sessionkey field in account table is only a temporary storage ↵Shauren
to pass data from authserver to worldserver and should only be used as such. Clearing sessionkey from database after a successful login to prevent possible exploits.
2013-02-04DB/Characters: Update sql/base/characters_database.sqlNay
2013-02-04DB/Auth: Update sql/base/auth_database.sqlNay
2013-02-04Merge pull request #9099 from Bezo/mutenewAokromes
Add Mute reason and mute by to the db so you can get this info from the ...
2013-01-30DB/Auth: Fix typo in sql/base/auth_database.sqlEmo
ERROR 1136 (21S01) at line 216: Column count doesn't match value count at row 1
2013-01-30Add Mute reason and mute by to the db so you can get this info from the db ↵Bezo
with the pinfo command when player get muted. old LOGIN_UPD_MUTE_TIME change to LOGIN_UPD_MUTE_TIME_LOGIN due the use of it when character login to world.
2013-01-27Core/Authserver: Added possibility to allow realm connections both from ↵Shauren
"world" and local networks.
2012-12-15Implements saving of loot (items / money) contained inside lootable ↵MrSmite
inventory items. * Unlooted items / money persist across player sessions * Loot inside items is tied to the item rather than the player so if trading partially looted items becomes possible, this implementation will still work * New tables added: characters_database.sql (first time users) characters_create_item_loot.sql (existing users) Implementation Can be tested with: Watertight Trunk [21113] Bulging Sack of Gems [25422] Fat Sack of Coins [11937] Closes #2048
2012-12-04SQL: Update characters_database.sqlVincent-Michael
2012-11-18Core/Calendar: Completely rewrite and fix most of the calendar systemhorn
There are still some issues that need to be fixed, for more info see CalendarHandler.cpp TODO part. Some unblizzlike behaviour possible, we don't have a lot of sniffs. Big thanks to @Warpten, he joined my project and helped a lot. IMPORTANT NOTE: Read / append packed time functions in ByteBuffer.h are not correct, they need to be fixed in order to have event times accurate Signed-off-by: Nay <dnpd.dd@gmail.com>
2012-11-07Update characters_database.sql (Missing changes from 58ec4e5319)Spp
2012-10-17DB: Add gm_tickets changes to base character dbkaelima
2012-10-09allow glyph1 be null like other glyph slotstibbi
2012-09-08SQL: Update characters_database.sqlNay
2012-08-12Update sql/base/auth_database.sqlNay
2012-08-07Core/Players: Improved alcohol handling, weeeeeeeeeeeeeeeeeShauren
Closes #7293
2012-07-13Core/Player: Fix issues with 'ignore this slot' option on equipment manager ↵NNN666
usage
2012-06-07And missing full sql changesShauren
2012-04-08Core/Conditions: Add missing code for CONDITION_TITLENay
DB/Char: Add changes to character base Thanks to manuel and QAston for noticing
2012-04-05DB/GOs: Correct some templates and add a missing one (WDB)Nay
DB/Auth: Add missed change to auth_base.sql Also fix file endings in some of hte sqls
2012-04-01DB/Auth: Increase realmlist.address size to 64 (varchar)Nay
You might want to verify if the previous size did not truncate your address (it was 15)
2012-03-28SQL: Auth db data type cleanup `logs`, `realmcharacters`, `realmlist`, ↵leak
`uptime` / Storage engine switched to InnoDB Note: As for the redundant `uptime`.`startstring` being removed, this page might be of interest how to generate time strings from unix timestamps http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_from-unixtime
2012-03-28SQL: Auth db data type cleanup `account_access`, `account_banned`, ↵leak
`ip_banned` / Storage engine switched to InnoDB
2012-03-28SQL: Auth db data type cleanup `account` / Storage engine switched to InnoDBleak
2012-03-26DB/Auth: Update auth_database.sql with recent changesNay
2012-03-25DB/Auth: Update auth_database.sql with recent changesNay
DB/GameEvent: Resync Darkmoon, again - by Aokromes
2012-02-19Core/Warden: Base implementation for Warden functionalityleak
Note: The default config file action for clients failing the checks can be changed for each check via the characters.warden_action table Credits to TOM_RUS
2012-02-19DB/Schema: Update auth db base SQL to recent mysqldump formatleak
2012-01-19DB/Characters: Add missing table create to characters_database.sql from ↵Nay
f4075f0f945c842fe2b1a08ea4a7fa253e8e2e53
2012-01-07DB: Add missing changes to characters base sqlNay
2011-09-05Core/Quests: Implement quests that require PlayerSlain. Closes #169Nay