From 9efda1d60352ee30a1a48cfa544510337a672275 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Tue, 23 Nov 2010 19:13:49 +0100 Subject: [PATCH] Fix updating coordinates. --- kronolith/lib/Geo/Mysql.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/kronolith/lib/Geo/Mysql.php b/kronolith/lib/Geo/Mysql.php index ab5e65109..dd99e414a 100644 --- a/kronolith/lib/Geo/Mysql.php +++ b/kronolith/lib/Geo/Mysql.php @@ -50,11 +50,12 @@ class Kronolith_Geo_Mysql extends Kronolith_Geo_Sql /* INSERT or UPDATE */ if ($count) { - $sql = sprintf('UPDATE kronolith_events_geo SET event_coordinates = GeomFromText(\'POINT(%F %F)\'), event_zoom = ? WHERE event_id = ?', $point['lat'], $point['lon']); + $sql = 'UPDATE kronolith_events_geo SET event_coordinates = GeomFromText(\'POINT(%F %F)\'), event_zoom = ? WHERE event_id = ?'; } else { - $sql = sprintf('INSERT into kronolith_events_geo (event_id, event_coordinates, event_zoom) VALUES(?, GeomFromText(\'POINT(%F %F)\'), ?)', $point['lat'], $point['lon']); + $sql = 'INSERT into kronolith_events_geo (event_coordinates, event_zoom, event_id) VALUES(GeomFromText(\'POINT(%F %F)\'), ?, ?)'; } - $values = array($event_id, $point['zoom']); + $sql = sprintf($sql, $point['lat'], $point['lon']); + $values = array($point['zoom'], $event_id); Horde::logMessage(sprintf('Kronolith_Geo_Mysql::setLocation(): user = "%s"; query = "%s"; values = "%s"', $GLOBALS['registry']->getAuth(), $sql, implode(',', $values)), 'DEBUG'); $result = $this->_write_db->query($sql, $values); -- 2.11.0