summaryrefslogtreecommitdiff
path: root/src/sql/mysql
AgeCommit message (Collapse)AuthorFilesLines
2010-07-09Added LUA script bindings for manipulating the specials available to a ↵Philipp Sehmisch2-1/+30
character. Added script call for getting the cost of a special (recharge only for now) Deleting specials works server-sided but the client isn't informed about it properly. Specials without recharge cost don't appear for the player. Both of these features require an additional netcode message. Reviewed-by: Freeyorp
2010-03-18Fixed a typo in mysql database update script for v7 to v8.Philipp Sehmisch1-1/+1
(trivial change)
2010-01-23Fix a syntax error in MYSQL createTable scriptBlue Sans Douze1-4/+4
Introduced in commit bb7866f0
2010-01-16Updates mysql to database version 8Chuck Miller2-2/+31
2010-01-10Fixing the mysql backend and the mysql createTables scriptBlue1-19/+63
Implementing the prepared statements in mysql backend
2009-12-06Fixed name of the project in copyright headersThorbjørn Lindeijer1-12/+12
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.
2009-10-24Rebranding tmwserv to manaservThorbjørn Lindeijer2-71/+69
Includes a database update. Use update_6_to_7.sql to update existing sqlite databases.
2009-09-30Adds tmw_char_status_effects tables to mySQL and SQLiteChuck Miller1-1/+19
2009-04-20Mysql update fileblue1122-15/+18
Update file... updated ^^' You can execute it a second time, there's no problem.
2009-04-19Update script mysql 2 to 3Blue1121-0/+16
2009-04-19Mysql Backend Update mysql database to version 3 Fixed compile error with ↵Blue1121-2/+10
mysql backend
2008-12-01Added new table to store online users. See mantis #553Andreas Habel2-3/+67
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-18Fixed a bug in tmw_world_states table script reported by YellowShadow. ↵Andreas Habel1-1/+1
Modified column value to be nullable according to the sqlite table specification.
2008-11-14Added check for database version on startup of Accountserver.Andreas Habel1-0/+4
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-06Added table tmw_item_instances and tmw_item_attributes for mySQL and SQLite ↵Andreas Habel1-25/+48
as preparation for unique item attributes. Fixed some formatting issues in mySQL Script.
2008-11-03Added tables and statements to store and retrieve letters. Attachments not ↵Andreas Habel1-1/+55
functional as long as items not stored as individual items.
2008-10-17Added SQL table definitions for item auctions.Andreas Habel1-0/+69
2008-09-19* Doxygen now writes all warnings into a separate fileAndreas Habel1-13/+17
* 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-17fixed CHARSET parameter to utf8Andreas Habel1-7/+7
2008-09-17* Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel2-0/+187
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