X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/2f3e23f6eb2bd571a39486773f0f10d65a2398a1..05e212027339733cf39aa9b7536c3f5f69ba0962:/app/controllers/swf_controller.rb

diff --git a/app/controllers/swf_controller.rb b/app/controllers/swf_controller.rb
index 262662c7a..d989a5e90 100644
--- a/app/controllers/swf_controller.rb
+++ b/app/controllers/swf_controller.rb
@@ -23,6 +23,7 @@ class SwfController < ApplicationController
 		xmax=params['xmax'].to_f;
 		ymin=params['ymin'].to_f;
 		ymax=params['ymax'].to_f;
+		start=params['start'].to_i;
 	
 		# -	Begin movie
 	
@@ -54,7 +55,7 @@ class SwfController < ApplicationController
 			   "  AND "+OSM.sql_for_area(ymin,xmin,ymax,xmax,"gps_points.")+
 			   "  AND (gps_points.timestamp IS NOT NULL) "+
 			   "ORDER BY fileid DESC,ts "+
-			   "LIMIT 10000"
+			   "LIMIT 10000 OFFSET #{start}"
 		  else
 			sql="SELECT latitude*0.0000001 AS lat,longitude*0.0000001 AS lon,gpx_id AS fileid,"+
 			     "      EXTRACT(EPOCH FROM timestamp) AS ts, gps_points.trackid AS trackid "+
@@ -62,7 +63,7 @@ class SwfController < ApplicationController
 				 "WHERE "+OSM.sql_for_area(ymin,xmin,ymax,xmax,"gps_points.")+
 				 "  AND (gps_points.timestamp IS NOT NULL) "+
 				 "ORDER BY fileid DESC,ts "+
-				 "LIMIT 10000"
+				 "LIMIT 10000 OFFSET #{start}"
 		end
 		gpslist=ActiveRecord::Base.connection.select_all sql