summaryrefslogtreecommitdiff
path: root/src/account-server/dalstoragesql.hpp
AgeCommit message (Collapse)AuthorFilesLines
2008-11-03Added tables and statements to store and retrieve letters. Attachments not ↵Andreas Habel1-0/+12
functional as long as items not stored as individual items.
2008-10-24Fixed a bug when trying to change password or mailaddress via client, caused ↵Andreas Habel1-0/+8
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-1/+4
2008-09-19* Doxygen now writes all warnings into a separate fileAndreas Habel1-0/+5
* 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-251/+2
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-121/+148
* 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-7/+10
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-18Changed guilds to use character id.David Athay1-15/+15
2008-07-22Save guild member permissions to dbDavid Athay1-0/+3
2008-06-03stop storing channels in the db, send channel announcementsRoderic Morris1-28/+0
2008-04-01Consolidated public and private channels into one,David Athay1-3/+6
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-01-28Added weapon skill system and leveling system.Philipp Sehmisch1-7/+46
2007-12-18Updated attribute system to the latest design decisions (removed charisma, ↵Philipp Sehmisch1-3/+0
kept agility in)
2007-08-30Got rid of abstract storage and reference-counted pointers. Fixed lifetime ↵Guillaume Melquiond1-0/+1
of accounts and characters in server memory. Cleaned some code.
2007-08-28Implemented quest variables.Guillaume Melquiond1-7/+17
2007-08-13Deleted obsolete files. Cleaned configuration. Removed obsolete SQL tables.Guillaume Melquiond1-111/+22
2007-07-28Replaced user names by client pointers when handling channels, in order to ↵Guillaume Melquiond1-6/+3
reduce lookups in ChatHandler::sendInChannel.
2007-07-01Added support for storing inventory in database.Guillaume Melquiond1-3/+3
2007-06-26Merged guilds-and-parties branch to trunkDavid Athay1-0/+49
2007-03-20Removed check for difference between lowest and highest attribute at char ↵Philipp Sehmisch1-3/+3
creation. Unified order of basic attributes.
2007-03-15Set the default map position of new characters to a value that makes more ↵Philipp Sehmisch1-3/+6
sense. Implemented new basic attribute system on account server. Removed attribute modifiers, unified basic and derived attributes, storing attributes in a vector, renamed some attribute identifiers, removed identifiers for derived attributes that aren't needed yet.
2007-03-05Added an abstrart base class for characterdata, in order to use the same ↵Rogier Polak1-9/+10
serialize and deserialize functions on both the accountserver and the gameserver.
2007-02-27Implementation of chat channels by Trapdoor.Philipp Sehmisch1-4/+7
2006-12-29Physically split the server into one tmwserv-acount program (account +Guillaume Melquiond1-0/+334
chat + database) and multiple tmwserv-game programs (selected with respect to the maps). Cleaned the repository by moving server-specific source files into dedicated directories.