diff options
author | Edmund von der Burg <evdb@mysociety.org> | 2011-02-07 21:11:25 +0000 |
---|---|---|
committer | Edmund von der Burg <evdb@mysociety.org> | 2011-02-07 21:11:25 +0000 |
commit | 61f36cfb38ba19943cf911b0fe51a20ad3b55808 (patch) | |
tree | 150ea58c3e8d56ca29771851167857a5f6ee0dd1 /perllib/Problems.pm | |
parent | 575bb55184d5ff4304b4a8e9b70e5cec3266b031 (diff) |
migrate recent_photos and where it is used
Diffstat (limited to 'perllib/Problems.pm')
-rw-r--r-- | perllib/Problems.pm | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/perllib/Problems.pm b/perllib/Problems.pm index 263d58bc9..c81c72fbd 100644 --- a/perllib/Problems.pm +++ b/perllib/Problems.pm @@ -87,18 +87,18 @@ sub recent_new { # Front page recent lists sub recent_photos { - my ($num, $e, $n, $dist) = @_; + my ($num, $lat, $lon, $dist) = @_; my $probs; - if ($e) { - my $key = "recent_photos:$site_key:$num:$e:$n:$dist"; + if (defined $lat) { + my $key = "recent_photos:$site_key:$num:$lat:$lon:$dist"; $probs = Memcached::get($key); unless ($probs) { $probs = select_all("select id, title - from problem_find_nearby_easting_northing(?, ?, ?) as nearby, problem + from problem_find_nearby(?, ?, ?) as nearby, problem where nearby.problem_id = problem.id and state in ('confirmed', 'fixed') and photo is not null $site_restriction - order by confirmed desc limit $num", $e, $n, $dist); + order by confirmed desc limit $num", $lat, $lon, $dist); Memcached::set($key, $probs, 3600); } } else { |