From 72fc234c502703a7acc64f2e6760fe2667a289ed Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Sun, 18 Nov 2012 14:58:46 +0000 Subject: [PATCH] Include the Last Updated timestamp in details --- lib/template/details-html.php | 1 + website/details.php | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/template/details-html.php b/lib/template/details-html.php index e7328b3a..4cacb307 100644 --- a/lib/template/details-html.php +++ b/lib/template/details-html.php @@ -79,6 +79,7 @@ } echo ' '; echo '
Type: '.$aPointDetails['class'].':'.$aPointDetails['type'].'
'; + echo '
Last Updated: '.$aPointDetails['indexed_date'].'
'; echo '
Admin Level: '.$aPointDetails['admin_level'].'
'; echo '
Rank: '.$aPointDetails['rank_search_label'].'
'; if ($aPointDetails['importance']) echo '
Importance: '.$aPointDetails['importance'].'
'; diff --git a/website/details.php b/website/details.php index ad6da237..3d80ea5f 100755 --- a/website/details.php +++ b/website/details.php @@ -59,7 +59,7 @@ // Get the details for this point $sSQL = "select place_id, osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, importance, wikipedia,"; - $sSQL .= " parent_place_id, rank_address, rank_search, get_searchrank_label(rank_search) as rank_search_label, get_name_by_language(name,$sLanguagePrefArraySQL) as localname, "; + $sSQL .= " to_char(indexed_date, 'YYYY-MM-DD HH24:MI') as indexed_date, parent_place_id, rank_address, rank_search, get_searchrank_label(rank_search) as rank_search_label, get_name_by_language(name,$sLanguagePrefArraySQL) as localname, "; $sSQL .= " ST_GeometryType(geometry) in ('ST_Polygon','ST_MultiPolygon') as isarea, "; $sSQL .= " ST_AsText(CASE WHEN ST_NPoints(geometry) > 5000 THEN ST_SimplifyPreserveTopology(geometry, 0.0001) ELSE geometry END) as outlinestring"; $sSQL .= " from placex where place_id = $iPlaceID"; -- 2.39.5