From d23fa84471a92664431775fdfa81048180d3f359 Mon Sep 17 00:00:00 2001 From: marc tobias Date: Wed, 14 Mar 2018 16:42:41 +0100 Subject: [PATCH] remove the 2-minute offset hack from data date in HTML output --- website/details.php | 2 +- website/reverse.php | 2 +- website/search.php | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/website/details.php b/website/details.php index 4c4ce578..24e8cd76 100755 --- a/website/details.php +++ b/website/details.php @@ -231,7 +231,7 @@ if ($oParams->getBool('keywords')) { 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; diff --git a/website/reverse.php b/website/reverse.php index 6df90029..2f1e31ee 100755 --- a/website/reverse.php +++ b/website/reverse.php @@ -72,7 +72,7 @@ if (CONST_Debug) { } 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; } diff --git a/website/search.php b/website/search.php index 346f5b57..0dddacce 100755 --- 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') { - $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)); -- 2.45.1