summaryrefslogtreecommitdiff
path: root/src/dal
AgeCommit message (Collapse)AuthorFilesLines
2010-02-07Update Copyright date for Manaserv.Bertram13-13/+13
2010-01-10Fixing the mysql backend and the mysql createTables scriptBlue2-1/+167
Implementing the prepared statements in mysql backend
2009-12-06Moved DALStorage documentation into source fileThorbjørn Lindeijer2-21/+6
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.
2009-12-06Removed obsolete commented out code from DALStorageThorbjørn Lindeijer1-17/+0
2009-12-06Fixed name of the project in copyright headersThorbjørn Lindeijer13-171/+170
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-12-06Removed "TMW" and "TMWSERV" from header guardsThorbjørn Lindeijer7-21/+21
2009-12-06A host of code style changesThorbjørn Lindeijer13-275/+130
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.
2009-10-24Rebranding tmwserv to manaservThorbjørn Lindeijer2-4/+4
Includes a database update. Use update_6_to_7.sql to update existing sqlite databases.
2009-09-15Fixed crash when column value is a real NULL value instead of empty string.Andreas Habel1-1/+3
2009-07-10Changed BindInteger and BindString to BindValueDavid Athay3-29/+10
2009-07-10Changed database to using prepared statements, to stop SQL injection attacksDavid Athay4-7/+128
2009-05-24Fixed a few code style issuesBjørn Lindeijer1-2/+2
Also renamed Guild::totalMembers to Guild::memberCount
2009-05-01Mysql backend, lua and NPC handlerBlue1-8/+8
Fix for mysql backend (again) Lua modification for integer and string ask with NPC, and closing fix.
2009-04-19Mysql Backend Update mysql database to version 3 Fixed compile error with ↵Blue1121-0/+1
mysql backend
2008-11-18Fixed spellingDavid Athay1-1/+1
2008-11-16Got rid of CVS/Subversion $Id$ markersBjørn Lindeijer13-33/+0
2008-11-05* Account server now loads item database on startup and synchronizes ↵Andreas Habel3-1/+25
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-10-24Fixed a bug when trying to change password or mailaddress via client, caused ↵Andreas Habel1-0/+2
by nested transactions. Fixed deletion of characters which left over garbage in sqlite.
2008-10-21Add limits.h where needed.Dennis Friis1-0/+1
2008-09-17* Added installation scripts to set up database schemas for mysql, sqlite ↵Andreas Habel5-41/+518
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-01-28Added weapon skill system and leveling system.Philipp Sehmisch1-0/+4
2007-10-27Made it compile with GCC 4.3Guillaume Melquiond1-3/+4
2007-08-13Deleted obsolete files. Cleaned configuration. Removed obsolete SQL tables.Guillaume Melquiond3-8/+4
2007-02-27Implementation of chat channels by Trapdoor.Philipp Sehmisch3-1/+10
2006-08-04Strengthened checks for already existing character name or email address.Guillaume Melquiond1-10/+0
2006-07-27First step toward a restructured class hierarchy for world actors: addGuillaume Melquiond13-58/+0
MovingObject and Player classes.
2006-03-06Cleaned up unnecessary header dependencies and fixed some indentations.Björn Steinbrink9-25/+11
2005-10-23Grammar Corrections, and a little bit of work on getting the name of the Db.Yohann Ferreira5-0/+30
2005-06-30Fixed memory leak, implemented delAccount() + unit tests and now using ↵Huynh Tran1-1/+4
reference-counted smart pointers to facilitate the memory management.
2005-06-29Fixed wrong memory deallocation.Huynh Tran1-2/+2
2005-06-28Fixed bugs and added new unit tests.Huynh Tran1-4/+1
2005-06-28Recommitted changes for new PostgreSQL defines.Aaron Marks1-2/+2
2005-06-21Reorganized unit tests and initial release of the unit tests for the Storage ↵Huynh Tran5-832/+4
class (to be completed).
2005-06-21Fixed memory leak.Huynh Tran1-1/+7
2005-06-21Made sure that pointers are initalized and reset to null after deallocation ↵Huynh Tran6-104/+129
and some reformatting.
2005-06-19Correcting indent and removing obsoleted files.Bjørn Lindeijer3-52/+52
2005-06-19Removed USE_SQLITE define from configure.ac (not used anywhere anymore)Aaron Marks1-3/+3
Fixed problem with PGconn not being cleaned up.
2005-06-19Added PostgreSQL DAL class.Aaron Marks4-1/+273
Updated configure.ac to include PostgreSQL & MySQL. (MySQL needs to be adjusted, and it seems that using --with-sqlite will drop out of configure after check for atexit. I dont know why, as i didn't touch the SQLite stuff) :)
2005-06-19Moved unit tests main from dal to src, rewrote Logger and added Cipher ↵Huynh Tran1-44/+0
(requires libcrypto from OpenSSL) + unit tests.
2005-06-17Updated Makefile.am.Aaron Marks1-0/+7
dataproviderfactory.cpp now conditionally includes related dataprovider header. (A problem exists with instantiating Being in dalstorage.cpp though)
2005-06-16Simplified APIs, change namespace from tmw to tmwserv, implemented MySQL ↵Huynh Tran16-434/+1180
data provider, added unit tests (require CPPUnit) and bug fixes.
2005-06-16Created Storage child which uses DAL (used by default now).Aaron Marks3-5/+5
Updated RecoredSet to allow access to rows() and cols().
2005-06-14Reworked RecordSet and implemented the SQLite Data ProviderHuynh Tran9-180/+421
2005-06-13Initial release of the Database Abstraction LayerHuynh Tran11-0/+1542