summaryrefslogtreecommitdiff
path: root/src/account-server/dalstorage.cpp
AgeCommit message (Collapse)AuthorFilesLines
2008-11-05Added version information to item database. Gameserver reports its local ↵Andreas Habel1-0/+53
version to account server during registration and gets notified if the version is up-to-date or outdated to prevent inconsistencies.
2008-11-03Added tables and statements to store and retrieve letters. Attachments not ↵Andreas Habel1-3/+108
functional as long as items not stored as individual items.
2008-10-27Added changing player's character and account level (game-server commit to ↵David Athay1-9/+35
come at a later date)
2008-10-26Some cleanup and an unsuccesful attempt at fixing a crash on map server exitBjørn Lindeijer1-2/+6
when there is no connection the account server (a different one surfaced).
2008-10-24Added post callback for getting post.David Athay1-0/+13
Added GM command for changing player attributes. Changed GM command to @ as '/' was already being used by client for local commands.
2008-10-24Fixed a bug when trying to change password or mailaddress via client, caused ↵Andreas Habel1-24/+61
by nested transactions. Fixed deletion of characters which left over garbage in sqlite.
2008-10-21Game Server now reconnects to Account Server. Some postal system bugs fixed.David Athay1-5/+1
2008-10-13fixed bug 456: erroneous sql query at character saveAndreas Habel1-6/+6
2008-09-19* Doxygen now writes all warnings into a separate fileAndreas Habel1-48/+104
* Added link to wiki documentation as comment into tmwserv.xml * Added table tmw_char_skills to store skills of a character and removed weapon skills from table tmw_characters.
2008-09-17* Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel1-325/+257
and postgresql. The create table statements have been completely removed out from the c++ source into separate, provider specific sql files. Accountserver will no longer create a sqlite file if none present. * Added database specific config parameters to configure each provider independent. * Simplified the connect routine of DALStorage class since every dataprovider is now responsible to retrieve its own parameters. * Extended abstract dataprovider to support transactions, functionally implemented for SQLite and mySQL. * Added methods to retrieve last inserted auto-increment value and the number of modified rows by the last statement. * Rewrite of DALStorage class to be a little more transactional. * Fixed a bug when deleting a character. Old function left data in quests table and guilds table. * Doxygen now also includes non-documented functions and provides a dictionary for all classes
2008-09-15* Added doxygen file, docu will be generated under docs/api/htmlAndreas Habel1-0/+80
* Added table definition "tmw_world_states" to store map and world-specific variables * Extended DALStorage to set and get those new variables * Applied Kess's diff file from mantis #424 with modifications for PostgreSQL support
2008-09-10* Extended tmw_accounts table with columns for lastlogin and registration ↵Andreas Habel1-6/+73
date. Modified account-server to fill the new columns on registration and login. Recreation of database needed! * Added createIndex function to create indexes on tables.
2008-08-28Better SQL query used for expired bans.David Athay1-39/+5
2008-08-28Added checking for expired bans.David Athay1-0/+52
2008-08-28Set banned user's level to AL_BANNEDDavid Athay1-1/+2
2008-08-18Changed guilds to use character id.David Athay1-22/+17
2008-08-18Misc fixes with guildDavid Athay1-1/+1
2008-07-28fix crash from last commit, guild fixes, damage calculation fixRoderic Morris1-7/+7
2008-07-22Save guild member permissions to dbDavid Athay1-3/+23
2008-06-15work around for members not being added to their guildsRoderic Morris1-1/+9
2008-06-03stop storing channels in the db, send channel announcementsRoderic Morris1-96/+0
2008-04-20Fixed some compiler errors/warnings.Bjørn Lindeijer1-1/+2
2008-04-01Consolidated public and private channels into one,David Athay1-2/+2
which also includes guild channels. Channels now have a joinable field, which is true for channels that are created by users, and false for guild channels. Chatting in guild channels now works, and non-guild members can no longer join guild channels
2008-03-06Fixed telling clients what guilds they are in after they reconnectDavid Athay1-2/+3
2008-03-05Fixed guild creation.David Athay1-2/+6
2008-02-28Added placeholder function so that account server now compiles.David Athay1-0/+9
2008-02-28Work in Progress commit of guilds.David Athay1-26/+2
2008-01-28Added weapon skill system and leveling system.Philipp Sehmisch1-8/+44
2007-12-18fixed an sql statement that I broke with the last commit.Philipp Sehmisch1-1/+1
2007-12-18Updated attribute system to the latest design decisions (removed charisma, ↵Philipp Sehmisch1-17/+15
kept agility in)
2007-09-22Cleaned both configuration and resource managers.Guillaume Melquiond1-2/+2
2007-08-31Implemented "ban" remote command.Guillaume Melquiond1-2/+39
2007-08-31Plugged several account leaks on error. Prevented banned players from ↵Guillaume Melquiond1-0/+20
logging in.
2007-08-30Fixed or removed obsolete comments.Guillaume Melquiond1-5/+0
2007-08-30Missed a few occurrences of "open" when removing them.Guillaume Melquiond1-17/+0
2007-08-30Got rid of abstract storage and reference-counted pointers. Fixed lifetime ↵Guillaume Melquiond1-245/+75
of accounts and characters in server memory. Cleaned some code.
2007-08-29Fixed handling of account levels.Guillaume Melquiond1-1/+2
2007-08-28Implemented quest variables.Guillaume Melquiond1-0/+56
2007-08-18First part of a patch for completing the RPG system (character attributes) ↵Guillaume Melquiond1-49/+33
of TMWserv.
2007-08-14Handled money as part of the inventory.Guillaume Melquiond1-4/+4
2007-08-13Deleted obsolete files. Cleaned configuration. Removed obsolete SQL tables.Guillaume Melquiond1-2/+0
2007-07-28Replaced user names by client pointers when handling channels, in order to ↵Guillaume Melquiond1-11/+9
reduce lookups in ChatHandler::sendInChannel.
2007-07-25Removed a host of unnecessary methods from ChatChannelManager.Bjørn Lindeijer1-9/+12
2007-07-17Some more cleanup of chat handler related code.Bjørn Lindeijer1-9/+9
2007-07-05Robustified account server with respect to failed SQL requests.Guillaume Melquiond1-16/+37
2007-07-02Added support for persistent inventory.Guillaume Melquiond1-22/+49
2007-07-02Cleaned prototypes and factored out duplicate code.Guillaume Melquiond1-168/+58
2007-07-01Added support for storing inventory in database.Guillaume Melquiond1-30/+42
2007-07-01Reverted inventory handling code to the last known working state. Simplified ↵Guillaume Melquiond1-0/+2
serialization interface along the way.
2007-06-26Merged guilds-and-parties branch to trunkDavid Athay1-0/+268