diff options
Diffstat (limited to 'src/game/WaypointManager.cpp')
| -rw-r--r-- | src/game/WaypointManager.cpp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/game/WaypointManager.cpp b/src/game/WaypointManager.cpp index 3ebbef7fc87..a779641c1c1 100644 --- a/src/game/WaypointManager.cpp +++ b/src/game/WaypointManager.cpp @@ -34,7 +34,7 @@ void WaypointStore::Free() void WaypointStore::Load() { - QueryResult *result = WorldDatabase.PQuery("SELECT COUNT(`id`) FROM `waypoint_data`"); + QueryResult *result = WorldDatabase.PQuery("SELECT COUNT(id) FROM waypoint_data"); if(!result) { sLog.outError("an error occured while loading the table `waypoint_data` (maybe it doesn't exist ?)"); @@ -44,7 +44,7 @@ void WaypointStore::Load() records = (*result)[0].GetUInt32(); delete result; - result = WorldDatabase.PQuery("SELECT `id`,`point`,`position_x`,`position_y`,`position_z`,`move_flag`,`delay`,`action`,`action_chance` FROM `waypoint_data` ORDER BY `id`, `point`"); + result = WorldDatabase.PQuery("SELECT id,point,position_x,position_y,position_z,move_flag,delay,action,action_chance FROM waypoint_data ORDER BY id, point"); if(!result) { sLog.outErrorDb("The table `waypoint_data` is empty or corrupted"); @@ -112,7 +112,7 @@ void WaypointStore::UpdatePath(uint32 id) QueryResult *result; - result = WorldDatabase.PQuery("SELECT `id`,`point`,`position_x`,`position_y`,`position_z`,`move_flag`,`delay`,`action`,`action_chance` FROM `waypoint_data` WHERE id = %u ORDER BY `point`", id); + result = WorldDatabase.PQuery("SELECT id,point,position_x,position_y,position_z,move_flag,delay,action,action_chance FROM waypoint_data WHERE id = %u ORDER BY point", id); if(!result) return; |