aboutsummaryrefslogtreecommitdiff
path: root/sql/base
AgeCommit message (Collapse)Author
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
2011-08-13DB/FULL: Remove redundant full content files for world database from the ↵Machiavelli
repo. They serve no particular purpose to the project other than consume precious time of the developers having to maintain it. If you're using TDB, this shouldn't affect you in any way since the full world database is periodically dumped and uploaded.
2011-08-07Core/Spells: Fix Shaman talent Nature's Guardian and rewrite fix for ↵Machiavelli
fc52f08. Fixes some spells not triggering.
2011-08-06Core/Commands: Add .cast dest #spellid #x #y #z which orders selected unit ↵QAston
to cast a spell at selected destination.
2011-08-03Core/Refer-a-Friend: Finish base work for Refer-a-Friend.Silinoron
Any testing would be very much appreciated.
2011-08-01Core/Spells: Fix Soul Preserver trinketMachiavelli
2011-07-27Core/Commands: Allow muting offline players - the mute will become effective ↵Machiavelli
on next player login.
2011-07-23Core/Spells: Fix talent Deep Wounds. Original idea by DrTenmatobmaps
Closes #395 Closes #954 Closes #1188