diff options
| author | leak <leakzx@googlemail.com> | 2011-03-18 18:49:15 +0100 |
|---|---|---|
| committer | leak <leakzx@googlemail.com> | 2011-03-18 18:49:40 +0100 |
| commit | ca027085642c9c1924df136ed1d854c569b2a654 (patch) | |
| tree | 5068887ce1bb80f918bcfbbe0cabe292be149a19 /src | |
| parent | a69f3c7c64172faf0de8c7db82b0d184a6b8704a (diff) | |
Core/GameEventMgr: Forgotten query
Diffstat (limited to 'src')
| -rw-r--r-- | src/server/scripts/Commands/cs_gobject.cpp | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/server/scripts/Commands/cs_gobject.cpp b/src/server/scripts/Commands/cs_gobject.cpp index 56bee295fae..f3f220488ef 100644 --- a/src/server/scripts/Commands/cs_gobject.cpp +++ b/src/server/scripts/Commands/cs_gobject.cpp @@ -250,7 +250,7 @@ public: { if (initString) { - eventFilter << "OR event IN (" <<*itr; + eventFilter << "OR eventEntry IN (" <<*itr; initString =false; } else @@ -264,8 +264,9 @@ public: result = WorldDatabase.PQuery("SELECT gameobject.guid, id, position_x, position_y, position_z, orientation, map, phaseMask, " "(POW(position_x - %f, 2) + POW(position_y - %f, 2) + POW(position_z - %f, 2)) AS order_ FROM gameobject " - "LEFT OUTER JOIN game_event_gameobject on gameobject.guid=game_event_gameobject.guid WHERE map = '%i' %s ORDER BY order_ ASC LIMIT 10", - handler->GetSession()->GetPlayer()->GetPositionX(), handler->GetSession()->GetPlayer()->GetPositionY(), handler->GetSession()->GetPlayer()->GetPositionZ(), handler->GetSession()->GetPlayer()->GetMapId(),eventFilter.str().c_str()); + "LEFT OUTER JOIN game_event_gameobject on gameobject.guid = game_event_gameobject.guid WHERE map = '%i' %s ORDER BY order_ ASC LIMIT 10", + handler->GetSession()->GetPlayer()->GetPositionX(), handler->GetSession()->GetPlayer()->GetPositionY(), handler->GetSession()->GetPlayer()->GetPositionZ(), + handler->GetSession()->GetPlayer()->GetMapId(),eventFilter.str().c_str()); } if (!result) |