manaserv.git/src/sql/postgresql, branch abilities Unnamed repository; edit this file 'description' to name the repository. Fixed the version in the createTables.sql scripts 2012-03-16T14:54:18+00:00 Thorbjørn Lindeijer thorbjorn@lindeijer.nl 2012-03-15T21:13:30+00:00 6ba4653e1c0e7ee2315f57d0bb1363ab03db4496 Forgot this in 1afbfb7e5fb5c133924ed8d376c6064575fc1c36. Reviewed-by: Bertram, Ablu. 
Forgot this in 1afbfb7e5fb5c133924ed8d376c6064575fc1c36.

Reviewed-by: Bertram, Ablu.
Fixed problems with map-bound world state variables 2012-03-13T20:53:25+00:00 Thorbjørn Lindeijer thorbjorn@lindeijer.nl 2012-03-12T21:18:22+00:00 1afbfb7e5fb5c133924ed8d376c6064575fc1c36 Due to a wrong primary key, which covered only the state name, it was impossible to use the same state name on different maps. This has now been fixed. Another problem was that the map variables were being included in the global variables, because the related database query did not filter on the map_id column properly. While fixing that, the map_id column now allows explicitly marking a state variable as global (with the value 0) or system variables (with the value -1). System variables are currently not accessible from scripts, but that could be changed later. Reviewed-by: Yohann Ferreira Reviewed-by: Erik Schilling 
Due to a wrong primary key, which covered only the state name, it was
impossible to use the same state name on different maps. This has now
been fixed.

Another problem was that the map variables were being included in the
global variables, because the related database query did not filter on
the map_id column properly. While fixing that, the map_id column now
allows explicitly marking a state variable as global (with the value 0)
or system variables (with the value -1).

System variables are currently not accessible from scripts, but that
could be changed later.

Reviewed-by: Yohann Ferreira
Reviewed-by: Erik Schilling
Fixed name of the project in copyright headers 2009-12-06T19:04:16+00:00 Thorbjørn Lindeijer thorbjorn@lindeijer.nl 2009-12-06T18:48:10+00:00 b402f8218b4c1fdc0225187de2e422387a95b149 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. 
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.
Rebranding tmwserv to manaserv 2009-10-24T18:54:43+00:00 Thorbjørn Lindeijer bjorn@lindeijer.nl 2009-10-24T18:54:43+00:00 9eeb927b991aef81bdc954be92cd061a835516e2 Includes a database update. Use update_6_to_7.sql to update existing sqlite databases. 
Includes a database update. Use update_6_to_7.sql to update existing
sqlite databases.
* Added installation scripts to set up database schemas for mysql, sqlite 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. 2008-09-17T11:32:45+00:00 Andreas Habel mail@exceptionfault.de 2008-09-17T11:32:45+00:00 a2af298fd993a129b657671a41f20e3975baf0ef * 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 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