From d5beb2bbe97afa0e50df8a2cef49bcac4a607f4a Mon Sep 17 00:00:00 2001 From: KingPin Date: Sun, 2 Nov 2008 16:53:46 -0600 Subject: [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! --HG-- branch : trunk --- src/shared/Database/DatabaseEnv.h | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'src/shared/Database') diff --git a/src/shared/Database/DatabaseEnv.h b/src/shared/Database/DatabaseEnv.h index 0e6b1607aa5..7491464285d 100644 --- a/src/shared/Database/DatabaseEnv.h +++ b/src/shared/Database/DatabaseEnv.h @@ -34,9 +34,10 @@ #include "Database/Database.h" #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" #include "Database/QueryResultSqlite.h" @@ -44,9 +45,10 @@ typedef DatabasePostgre DatabaseType; #include "Database/DatabaseMysql.h" #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 extern DatabaseType WorldDatabase; -- cgit v1.2.3