remove the 2-minute offset hack from data date in HTML output

diff --git a/website/details.php b/website/details.php
index 4c4ce578a149151d1263b98c3dbe136e57e61495..24e8cd76a2d70217b23ca9c074f24d0bd75c4392 100755 (executable)
--- a/website/details.php
+++ b/website/details.php
@@ -231,7 +231,7 @@ if ($oParams->getBool('keywords')) {
 logEnd($oDB, $hLog, 1);
 
 if ($sOutputFormat=='html') {
 logEnd($oDB, $hLog, 1);
 
 if ($sOutputFormat=='html') {

-    $sSQL = "SELECT TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' FROM import_status LIMIT 1";
+    $sSQL = "SELECT TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' FROM import_status LIMIT 1";

     $sDataDate = chksql($oDB->getOne($sSQL));
     $sTileURL = CONST_Map_Tile_URL;
     $sTileAttribution = CONST_Map_Tile_Attribution;
     $sDataDate = chksql($oDB->getOne($sSQL));
     $sTileURL = CONST_Map_Tile_URL;
     $sTileAttribution = CONST_Map_Tile_Attribution;

diff --git a/website/reverse.php b/website/reverse.php
index 6df90029052bdf6c00443384d6e55f93672da485..2f1e31eeb369cbfa1a1f7c892194f01db2e4fd1d 100755 (executable)
--- a/website/reverse.php
+++ b/website/reverse.php
@@ -72,7 +72,7 @@ if (CONST_Debug) {
 }
 
 if ($sOutputFormat == 'html') {
 }
 
 if ($sOutputFormat == 'html') {

-    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));
+    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));

     $sTileURL = CONST_Map_Tile_URL;
     $sTileAttribution = CONST_Map_Tile_Attribution;
 }
     $sTileURL = CONST_Map_Tile_URL;
     $sTileAttribution = CONST_Map_Tile_Attribution;
 }

diff --git a/website/search.php b/website/search.php
index 346f5b5740a1f96380fb3518ec9b03cb7c259e1a..0dddaccec9cf2dc2a2cec98236bea128b16b4dcd 100755 (executable)
--- a/website/search.php
+++ b/website/search.php
@@ -66,7 +66,7 @@ $hLog = logStart($oDB, 'search', $oGeocode->getQueryString(), $aLangPrefOrder);
 $aSearchResults = $oGeocode->lookup();
 
 if ($sOutputFormat=='html') {
 $aSearchResults = $oGeocode->lookup();
 
 if ($sOutputFormat=='html') {

-    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));
+    $sDataDate = chksql($oDB->getOne("select TO_CHAR(lastimportdate,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1"));

 }
 logEnd($oDB, $hLog, sizeof($aSearchResults));
 
 }
 logEnd($oDB, $hLog, sizeof($aSearchResults));