summaryrefslogtreecommitdiffstats
path: root/src/account-server/dalstorage.cpp
Commit message (Collapse)AuthorAgeFilesLines
* Renamed DALStorage to StorageThorbjørn Lindeijer2009-12-061-1997/+0
| | | | | The only reason it was a DALStorage was because it used to implement the Storage interface, but that interface got removed a long time ago.
* Moved DALStorage documentation into source fileThorbjørn Lindeijer2009-12-061-12/+196
| | | | | | | | | Some methods were documented twice. Stuff moved to source file since this keeps the header more readable, and makes it easier to keep the documentation up to date with the implementation. Also, my IDE jumps to the definition when navigating. Removed two methods that were without an implementation.
* Removed obsolete commented out code from DALStorageThorbjørn Lindeijer2009-12-061-79/+6
|
* Fixed name of the project in copyright headersThorbjørn Lindeijer2009-12-061-13/+13
| | | | | | Also updated the headers to refer to the GPL by URL instead of suggesting to contact the FSF by snail mail, as per the latest GPL usage instructions.
* A host of code style changesThorbjørn Lindeijer2009-12-061-34/+27
| | | | | | Removed pointless void in method parameter lists, fixed methods and variables that started with upper case, removed pointless 'const' for stuff passed by value, made some getters const, etc.
* Rebranding tmwserv to manaservThorbjørn Lindeijer2009-10-241-1/+1
| | | | | Includes a database update. Use update_6_to_7.sql to update existing sqlite databases.
* Adds code for saving and getting status effects from the databaseChuck Miller2009-10-011-0/+77
|
* Adds tmw_char_status_effects tables to mySQL and SQLiteChuck Miller2009-09-301-1/+1
|
* Added table and view to prepare reporting of transaction log.Andreas Habel2009-08-231-1/+1
| | | | | | | | Fixed database update "3 to 4". Added database update "4 to 5". Added indexes to table tmw_transaction for faster search when it gets bigger. Refactored layout of sqlite database script.
* Update table tmw_accounts. Added columns to store secret key and expirationAndreas Habel2009-08-171-1/+1
| | | | time for password recovery via tmwweb/email.
* Changed BindInteger and BindString to BindValueDavid Athay2009-07-101-23/+23
|
* Changed database to using prepared statements, to stop SQL injection attacksDavid Athay2009-07-101-57/+165
|
* Makes Skills non hard codedChuck Miller2009-07-031-7/+9
| | | | | It should be noted that Jax still needs to update the client Level calulation seems broken now too
* Fixed a few code style issuesBjørn Lindeijer2009-05-241-1/+1
| | | | Also renamed Guild::totalMembers to Guild::memberCount
* Standardize on the position of the const keywordBjørn Lindeijer2009-04-261-49/+49
| | | | Same as for the client.
* Fixes for some compile warningsBjørn Lindeijer2009-03-101-1/+1
| | | | Mostly comparisons between signed and unsigned integers
* Added transactions for chat events.David Athay2009-03-051-7/+7
|
* Added transactional historyDavid Athay2009-03-051-1/+78
|
* Changed guild member permissions. Restricted players to owning only 1 guild.David Athay2009-01-271-1/+1
|
* Added new table to store online users. See mantis #553Andreas Habel2008-12-011-1/+43
| | | | | | | | 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.
* Add sync Buffer according to mantis #550Andreas Habel2008-11-301-52/+79
| | | | | | | | 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...
* Added bandwidth monitor to account server. Fixes compile errors.David Athay2008-11-211-1/+1
|
* Got rid of CVS/Subversion $Id$ markersBjørn Lindeijer2008-11-161-2/+0
|
* Properly handle exceptions when opening databaseBjørn Lindeijer2008-11-151-17/+9
| | | | | | It was throwing a std::string but nobody was dealing with it. The actual problem still needs to be fixed. It seems to be having problems with getting some database version.
* Added check for database version on startup of Accountserver.Andreas Habel2008-11-141-13/+18
| | | | | The provided CreateTable.sql scripts store their versions inline of a database table. The account server checks this version number with its known compatible version. If the numbers don't match, the account server raises an error and shuts down.
* Fixed reusage of ostringstream. Now calling clear() before str("") to reset ↵Andreas Habel2008-11-051-0/+9
| | | | stream state.
* Splitting image name and dye string of items while synchronizing local ↵Andreas Habel2008-11-051-2/+11
| | | | database from items.xml
* * Account server now loads item database on startup and synchronizes ↵Andreas Habel2008-11-051-13/+65
| | | | | | tmw_items table in the database. * Added method to DataProvider to escape quotes in strings so that they can be used in SQL statements.
* Added version information to item database. Gameserver reports its local ↵Andreas Habel2008-11-051-0/+53
| | | | version to account server during registration and gets notified if the version is up-to-date or outdated to prevent inconsistencies.
* Added tables and statements to store and retrieve letters. Attachments not ↵Andreas Habel2008-11-031-3/+108
| | | | functional as long as items not stored as individual items.
* Added changing player's character and account level (game-server commit to ↵David Athay2008-10-271-9/+35
| | | | come at a later date)
* Some cleanup and an unsuccesful attempt at fixing a crash on map server exitBjørn Lindeijer2008-10-261-2/+6
| | | | | when there is no connection the account server (a different one surfaced).
* Added post callback for getting post.David Athay2008-10-241-0/+13
| | | | | | Added GM command for changing player attributes. Changed GM command to @ as '/' was already being used by client for local commands.
* Fixed a bug when trying to change password or mailaddress via client, caused ↵Andreas Habel2008-10-241-24/+61
| | | | | | by nested transactions. Fixed deletion of characters which left over garbage in sqlite.
* Game Server now reconnects to Account Server. Some postal system bugs fixed.David Athay2008-10-211-5/+1
|
* fixed bug 456: erroneous sql query at character saveAndreas Habel2008-10-131-6/+6
|
* * Doxygen now writes all warnings into a separate fileAndreas Habel2008-09-191-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.
* * Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel2008-09-171-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
* * Added doxygen file, docu will be generated under docs/api/htmlAndreas Habel2008-09-151-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
* * Extended tmw_accounts table with columns for lastlogin and registration ↵Andreas Habel2008-09-101-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.
* Better SQL query used for expired bans.David Athay2008-08-281-39/+5
|
* Added checking for expired bans.David Athay2008-08-281-0/+52
|
* Set banned user's level to AL_BANNEDDavid Athay2008-08-281-1/+2
|
* Changed guilds to use character id.David Athay2008-08-181-22/+17
|
* Misc fixes with guildDavid Athay2008-08-181-1/+1
|
* fix crash from last commit, guild fixes, damage calculation fixRoderic Morris2008-07-281-7/+7
|
* Save guild member permissions to dbDavid Athay2008-07-221-3/+23
|
* work around for members not being added to their guildsRoderic Morris2008-06-151-1/+9
|
* stop storing channels in the db, send channel announcementsRoderic Morris2008-06-031-96/+0
|
* Fixed some compiler errors/warnings.Bjørn Lindeijer2008-04-201-1/+2
|
generated by cgit (git 2.34.1) at 2026-04-05 21:06:01 +0000