summaryrefslogtreecommitdiff
path: root/src/account-server
AgeCommit message (Collapse)AuthorFilesLines
2009-08-17Update table tmw_accounts. Added columns to store secret key and expirationAndreas Habel1-1/+1
time for password recovery via tmwweb/email.
2009-08-14Bugfix for storing transaction messages for new created characters.Andreas Habel1-2/+3
First flush the new character to the database to get it's new DatabaseID. Calling ->getDatabaseID() before flush() will give a wrong, uninitialized value.
2009-07-10Changed BindInteger and BindString to BindValueDavid Athay1-23/+23
2009-07-10Changed database to using prepared statements, to stop SQL injection attacksDavid Athay2-65/+170
2009-07-03Makes Skills non hard codedChuck Miller3-13/+21
It should be noted that Jax still needs to update the client Level calulation seems broken now too
2009-05-24Stopped tmwserv from writing to its configuration fileBjørn Lindeijer1-26/+41
This was confusing, since changes made to the config file while the server is running are lost once the server exists. Also, XML comments were being stripped by the server. The command line option to set the port now only applies to a single run, and isn't saved in the configuration. There shouldn't be a need for the server to write to its configuration file, it might not even have the rights to do so.
2009-05-24More code style fixesBjørn Lindeijer1-2/+1
2009-05-24Made it possible to specify the host to listen onBjørn Lindeijer5-9/+11
Needed when the server has multiple network interfaces and the one you want to use isn't the default one for localhost. The host to listen on can be set in config file with 'net_listenHost'.
2009-05-24Fixed a few code style issuesBjørn Lindeijer2-2/+2
Also renamed Guild::totalMembers to Guild::memberCount
2009-04-26Standardize on the position of the const keywordBjørn Lindeijer10-105/+114
Same as for the client.
2009-04-26Merged MovingObject into the Being classBjørn Lindeijer1-67/+43
Also renamed Object to Actor, to make it sound a little less generic. Cleans up a bit the rather big hierarchy of different object types we have.
2009-03-10Fixes for some compile warningsBjørn Lindeijer1-1/+1
Mostly comparisons between signed and unsigned integers
2009-03-06Added transactional history to game server.David Athay4-51/+18
2009-03-05Added transactions for chat events.David Athay2-9/+19
2009-03-05Added transactional historyDavid Athay5-1/+162
2009-03-02Fixed default values of numHairStyles und numHairColorsPhilipp Sehmisch1-2/+2
2009-02-24Forgot two config key renames and a little style fixPhilipp Sehmisch2-2/+3
2009-02-24Made a lot of hard-coded values configuration optionsPhilipp Sehmisch1-19/+32
2009-01-27Merge branch 'master' of git@gitorious.org:tmwserv/mainlineDavid Athay1-1/+1
2009-01-27Changed guild member permissions. Restricted players to owning only 1 guild.David Athay2-2/+2
2009-01-25Compile without warnings and made getIP() constBjørn Lindeijer1-1/+1
2009-01-12Added getting IP, and restricting time between loginsDavid Athay3-0/+34
2008-12-12Fixed game server crash and code styleBjørn Lindeijer1-2/+2
The game server crashed when it was closed while it still hadn't been able to connect to the account server, due to an uninitialized pointer. Code style fixes. Don't use 'const' for arguments that are passed by value and start variable names with lowercase.
2008-12-06Fixes map warp issues, and has a better starting locationChuck Miller1-2/+2
2008-12-01Added new table to store online users. See mantis #553Andreas Habel4-1/+66
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 Habel4-53/+148
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-21Added bandwidth monitor to account server. Fixes compile errors.David Athay3-2/+9
2008-11-16Got rid of CVS/Subversion $Id$ markersBjørn Lindeijer14-30/+0
2008-11-15Properly handle exceptions when opening databaseBjørn Lindeijer2-21/+17
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.
2008-11-14Added check for database version on startup of Accountserver.Andreas Habel1-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.
2008-11-05Fixed reusage of ostringstream. Now calling clear() before str("") to reset ↵Andreas Habel1-0/+9
stream state.
2008-11-05Splitting image name and dye string of items while synchronizing local ↵Andreas Habel1-2/+11
database from items.xml
2008-11-05* Account server now loads item database on startup and synchronizes ↵Andreas Habel3-14/+83
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 Habel3-0/+80
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 Habel3-4/+127
functional as long as items not stored as individual items.
2008-10-27Compile fixes and warning fixes.Bjørn Lindeijer2-1/+2
2008-10-27Added changing player's character and account level (game-server commit to ↵David Athay3-13/+75
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 Habel3-25/+75
by nested transactions. Fixed deletion of characters which left over garbage in sqlite.
2008-10-21Fixed some compile warnings.Bjørn Lindeijer1-2/+2
2008-10-21Game Server now reconnects to Account Server. Some postal system bugs fixed.David Athay4-20/+42
2008-10-13fixed bug 456: erroneous sql query at character saveAndreas Habel1-6/+6
2008-09-19Added post communication between chat and game servers.David Athay2-0/+99
2008-09-19* Doxygen now writes all warnings into a separate fileAndreas Habel3-48/+120
* 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 Habel3-604/+278
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 Habel4-121/+273
* 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 Habel6-23/+165
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 Athay2-46/+5
2008-08-28Added checking for expired bans.David Athay3-0/+67