summaryrefslogtreecommitdiff
path: root/src/account-server/dalstorage.hpp
AgeCommit message (Collapse)AuthorFilesLines
2009-10-01Adds code for saving and getting status effects from the databaseChuck Miller1-0/+8
2009-07-10Changed database to using prepared statements, to stop SQL injection attacksDavid Athay1-8/+5
2009-04-26Standardize on the position of the const keywordBjørn Lindeijer1-11/+11
Same as for the client.
2009-03-06Added transactional history to game server.David Athay1-2/+2
2009-03-05Added transactional historyDavid Athay1-0/+16
2009-01-27Changed guild member permissions. Restricted players to owning only 1 guild.David Athay1-1/+1
2008-12-01Added new table to store online users. See mantis #553Andreas Habel1-0/+8
This upgrade will be the first, we provide database installation scripts and update scripts to upgrade from the previous version. For more details about database upgrades see http://wiki.themanaworld.org/index.php/Upgrade_Database and feel free to comment.
2008-11-30Add sync Buffer according to mantis #550Andreas Habel1-0/+21
The game server buffers all changes made to a character in a sync buffer. The buffer is sent to the account server if the buffer contains more then 20 message, reaches size of 1kb or at least every 10 seconds. ATM Character attributes, corr points and attribute points and skills are synchronized. TODO: items, location, money...
2008-11-16Got rid of CVS/Subversion $Id$ markersBjørn Lindeijer1-3/+0
2008-11-05* Account server now loads item database on startup and synchronizes ↵Andreas Habel1-1/+13
tmw_items table in the database. * Added method to DataProvider to escape quotes in strings so that they can be used in SQL statements.
2008-11-05Added version information to item database. Gameserver reports its local ↵Andreas Habel1-0/+7
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-1/+7
functional as long as items not stored as individual items.
2008-10-27Compile fixes and warning fixes.Bjørn Lindeijer1-0/+1
2008-10-27Added changing player's character and account level (game-server commit to ↵David Athay1-3/+19
come at a later date)
2008-10-24Fixed a bug when trying to change password or mailaddress via client, caused ↵Andreas Habel1-1/+6
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-8/+25
2008-09-19* Doxygen now writes all warnings into a separate fileAndreas Habel1-0/+11
* 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-28/+19
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/+32
* 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-1/+21
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-7/+0
2008-08-28Added checking for expired bans.David Athay1-0/+12
2008-08-18Changed guilds to use character id.David Athay1-3/+3
2008-07-22Save guild member permissions to dbDavid Athay1-2/+8
2008-06-03stop storing channels in the db, send channel announcementsRoderic Morris1-24/+1
2008-04-18Fixed 'Password changes' and 'Unregistering'.Yohann Ferreira1-5/+5
2008-02-28Work in Progress commit of guilds.David Athay1-2/+0
2007-08-31Implemented "ban" remote command.Guillaume Melquiond1-0/+8
2007-08-31Plugged several account leaks on error. Prevented banned players from ↵Guillaume Melquiond1-2/+8
logging in.
2007-08-30Fixed or removed obsolete comments.Guillaume Melquiond1-6/+2
2007-08-30Got rid of abstract storage and reference-counted pointers. Fixed lifetime ↵Guillaume Melquiond1-42/+40
of accounts and characters in server memory. Cleaned some code.
2007-08-28Implemented quest variables.Guillaume Melquiond1-0/+11
2007-07-28Replaced user names by client pointers when handling channels, in order to ↵Guillaume Melquiond1-2/+2
reduce lookups in ChatHandler::sendInChannel.
2007-07-02Cleaned prototypes and factored out duplicate code.Guillaume Melquiond1-8/+24
2007-06-26Merged guilds-and-parties branch to trunkDavid Athay1-0/+46
2007-03-05Added an abstrart base class for characterdata, in order to use the same ↵Rogier Polak1-1/+12
serialize and deserialize functions on both the accountserver and the gameserver.
2007-02-04Added support for switching character by reconnecting to the account server andBjørn Lindeijer1-0/+10
fixed the issue where a client is not logged in after registering (patch by Rogier Polak).
2006-12-31Finished implementation for warping players around servers. Thoroughly untested.Guillaume Melquiond1-0/+8
2006-12-29Physically split the server into one tmwserv-acount program (account +Guillaume Melquiond1-0/+177
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.