Changeset 149 for trunk/src/shared/Database/DatabaseEnv.h

Timestamp:

11/19/08 13:40:46 (17 years ago)

Author:

yumileroy

Message:

[svn] *Implement new player conditions CONDITION_NO_AURA, CONDITION_ACTIVE_EVENT
* Default behaviour of pets for creatures changed to REACT_DEFENSIVE
* Disallowed sending wrapped items as COD
* Prevent loading and saving single target auras for pet in same way as already implemented for player
* Correctly limit use some flask types to zones.
* Fixed extracting common.MPQ under *nix
* Many small xleanups and fixes.
** mangos merge rev.

TEST REV so be careful of creepy crawly bugs!

Original author: KingPin?
Date: 2008-11-02 16:53:46-06:00

Files:

• trunk/src/shared/Database/DatabaseEnv.h (modified) (2 diffs)

trunk/src/shared/Database/DatabaseEnv.h

@@ -35 +35 @@
 #include "Database/DatabasePostgre.h"
 typedef DatabasePostgre DatabaseType;
-#define _LIKE_          "ILIKE"
-#define _TABLE_SIM_     "\""
+#define _LIKE_           "ILIKE"
+#define _TABLE_SIM_      "\""
 #define _CONCAT3_(A,B,C) "( " A " || " B " || " C " )"
+#define _OFFSET_         "LIMIT 1 OFFSET %d"
 #else
 #include "Database/QueryResultMysql.h"
@@ -45 +46 @@
 #include "Database/DatabaseSqlite.h"
 typedef DatabaseMysql DatabaseType;
-#define _LIKE_          "LIKE"
-#define _TABLE_SIM_     "`"
+#define _LIKE_           "LIKE"
+#define _TABLE_SIM_      "`"
 #define _CONCAT3_(A,B,C) "CONCAT( " A " , " B " , " C " )"
+#define _OFFSET_         "LIMIT %d,1"
 #endif