aboutsummaryrefslogtreecommitdiff
path: root/src/server/shared/Database/SQLOperation.cpp
AgeCommit message (Collapse)Author
2010-09-19Core/DBLayer: Move QueryHolder and BasicStatement operations to their own ↵Machiavelli
file and remove SQLOperation.cpp from revision control --HG-- branch : trunk
2010-09-19Core/DBLayer:Machiavelli
- Declare the datatypes used to determine transaction element data (prepared statement/adhoc query string) on a generic level in SQLOperation.h - Implement variable SQL element data for SQLQueryHolder class so it can execute both prepared statements and adhoc queries - Make MySQLConnection::Query for adhoc queries return pointer to type instead of an autopointer, the autopointer is now applied on higher level code just like the function for querying prepared statements --HG-- branch : trunk
2010-09-11Core/DBLayer:Machiavelli
* Rename QueryResult class to ResultSet * Rename QueryResult_AutoPtr to QueryResult * Declare ACE refcounted auto pointer for PreparedResultSet class --HG-- branch : trunk
2010-09-02Core/Build: Partial work of fixing non-PCH Linux compilerunningnak3d
--HG-- branch : trunk
2010-09-03Fix Linux buildMachiavelli
--HG-- branch : trunk
2010-08-31Core: Fix more warnings (very few left under linux 32)Spp
--HG-- branch : trunk
2010-08-21Core: Remove lots warnings:Spp
- All "'xxx' will be initialized after 'yyy' when initialized here" - Some "unused variable" - Some "enumeration value 'xxx' not handled in switch" --HG-- branch : trunk
2010-08-21Core: Remove warning-ignores from Common.h, and fix a shitload of retarded ↵click
warnings that was hidden by it - NO MORE HIDING IN CORE THANKYOU! --HG-- branch : trunk
2010-08-21Core: Make shared build happily without PCH (there are still issues with ↵click
game ++) --HG-- branch : trunk
2010-08-21DB Layer:Machiavelli
- Make SQL Transactions actual objects used in code. (Thanks to Derex for the idea) * Uncommitted transactions will be automatically rolled back and cleaned up using ACE_Refcounted_Auto_Ptr, so no need to call Rollback() in the code. * Prevents recursive transactions and makes developers aware of transactions going on. * Gets rid of unneccesary overhead iterating over a concurrent map. - Some cleanups in affected code, including better usage of transaction control in AH / mail related code to prevent data loss. *** Experimental, use at own risk, recommended to backup your DBs. *** --HG-- branch : trunk
2010-08-20Core/Build: Fix non-PCH build, again... :Pclick
--HG-- branch : trunk
2010-08-18DBLayer:Machiavelli
- Use ACE_Future and ACE_Future_Set for async SQL queries with callback * Callbacks will now be executed from the thread and object that scheduled the request, instead of the world runnable thread (and thus are no longer dependent on the 50ms forced sleep time). * This design gets rid of a potential DOS loophole in the resultqueue system - unique requests will be cancelled when re-requested. - Drop now redundant SQLQueryTask, SQLResultQueue, SQLResultQueueTask operations. - Drop now redundant CharacterHandler class - Change static callback functions in WorldSession to normal functions. Thanks to Derex and Zor for advice along the way. --HG-- branch : trunk
2010-08-18Buildsystem/Core: Adjust header locations in CMake for collisions and shared ↵click
+ clean up includes from re26dbe6981 This sorts out issues with non-PCH compiles on supported platforms. --HG-- branch : trunk
2010-08-18* HIGHLY EXPERIMENTAL - USE AT OWN RISK *Machiavelli
Database Layer: - Implement connection pooling: Instead of 1 delay thread per database, you can configure between 1 and 32 worker threads that have a seperate thread in the core and have a seperate connection to the MySQL server (based on raczman/Albator´s database layer for Trinitycore3) - Implement a configurable thread bundle for synchroneous requests from seperate core threads (see worldserver.conf.dist for more info) - Every mapupdate thread now has its seperate MySQL connection to the world and characters database - Drop inconsistent PExecuteLog function - query logging will be implemented CONSISTENTLY later - Drop current prepared statement interface - this will be done *properly* later - You´ll need to update your worldserver.conf and authserver.conf - You´re recommended to make a backup of your databases before using this. * HIGHLY EXPERIMENTAL - USE AT OWN RISK * * HIGHLY EXPERIMENTAL - USE AT OWN RISK * etc. --HG-- branch : trunk