diff options
| author | n0n4m3 <none@none> | 2010-04-14 13:02:05 +0400 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2010-04-14 13:02:05 +0400 |
| commit | 8b6005666dc10ba6acb423c7ad936b8b290fd6ee (patch) | |
| tree | 16ef262dbc4513f34a8cdeb2921b629a8e9f1a7a /src/game/GlobalEvents.cpp | |
| parent | e3e5ca62270f010d5dbc2c160db22cbffa6dc94b (diff) | |
Add index for some tables in characters DB. by AlexDereka.
--HG--
branch : trunk
Diffstat (limited to 'src/game/GlobalEvents.cpp')
| -rw-r--r-- | src/game/GlobalEvents.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/game/GlobalEvents.cpp b/src/game/GlobalEvents.cpp index 9f72e96936c..300527aad73 100644 --- a/src/game/GlobalEvents.cpp +++ b/src/game/GlobalEvents.cpp @@ -75,7 +75,7 @@ static void CorpsesErase(bool bones,uint32 delay) { ///- Get the list of eligible corpses/bones to be removed //No SQL injection (uint32 and enum) - CharacterDatabase.AsyncPQuery(&CorpsesEraseCallBack, bones, "SELECT guid,position_x,position_y,map,player FROM corpse WHERE UNIX_TIMESTAMP()-time > '%u' AND corpse_type %s '0'", delay, (bones ? "=" : "<>")); + CharacterDatabase.AsyncPQuery(&CorpsesEraseCallBack, bones, "SELECT guid,position_x,position_y,map,player FROM corpse WHERE time < (UNIX_TIMESTAMP()+'%u') AND corpse_type %s '0'", delay, (bones ? "=" : "<>")); } /// not thread guarded variant for call from other thread |