query the last updated timestamp only if output format is HTML

diff --git a/lib/template/includes/html-top-navigation.php b/lib/template/includes/html-top-navigation.php
index e0b367b420b74a57a5c98324b8bbefe463dfc618..1857d82c35a4e57413aef6076b8d5cf727be3a1d 100644 (file)
--- a/lib/template/includes/html-top-navigation.php
+++ b/lib/template/includes/html-top-navigation.php
@@ -9,7 +9,7 @@
         </div>
       </div>
       <div id="last-updated" class="col-xs-4 text-center">
-        <?php if ($sDataDate){ ?>
+        <?php if (isset($sDataDate)){ ?>
           Data last updated:
           <br>
           <?php echo $sDataDate; ?>

diff --git a/website/details.php b/website/details.php
index ad753a82a5bb93075deb5bf466287e3bb4bb6304..3a0fee82a29fb2d70dc9e0b2138dc15e6671a71b 100755 (executable)
--- a/website/details.php
+++ b/website/details.php
@@ -159,7 +159,12 @@
 
        logEnd($oDB, $hLog, 1);
 
-       $sTileURL = CONST_Map_Tile_URL;
-       $sTileAttribution = CONST_Map_Tile_Attribution;
+       if ($sOutputFormat=='html')
+       {
+               $sDataDate = $oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1");
+               $sTileURL = CONST_Map_Tile_URL;
+               $sTileAttribution = CONST_Map_Tile_Attribution;
+       }
+
        
        include(CONST_BasePath.'/lib/template/details-'.$sOutputFormat.'.php');

diff --git a/website/reverse.php b/website/reverse.php
index e2dfaef80eeccdadae886f0611ba575e8a789584..f760dc09043e588e920bc8538efefdaca0c1cb8b 100755 (executable)
--- a/website/reverse.php
+++ b/website/reverse.php
@@ -76,6 +76,10 @@
                exit;
        }
 
-       $sTileURL = CONST_Map_Tile_URL;
-       $sTileAttribution = CONST_Map_Tile_Attribution;
+       if ($sOutputFormat=='html')
+       {
+               $sDataDate = $oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1");
+               $sTileURL = CONST_Map_Tile_URL;
+               $sTileAttribution = CONST_Map_Tile_Attribution;
+       }
        include(CONST_BasePath.'/lib/template/address-'.$sOutputFormat.'.php');

diff --git a/website/search.php b/website/search.php
index f2c327c07fefe6760d5c51426d588c0c214c4c56..c216c8848c3a07063fd448e92d1a2222ba1da2fa 100755 (executable)
--- a/website/search.php
+++ b/website/search.php
@@ -13,8 +13,6 @@
        $fLat = CONST_Default_Lat;
        $fLon = CONST_Default_Lon;
        $iZoom = CONST_Default_Zoom;
-       $sTileURL = CONST_Map_Tile_URL;
-       $sTileAttribution = CONST_Map_Tile_Attribution;
 
        $oGeocode =& new Geocode($oDB);
 
@@ -99,17 +97,17 @@
        {
                if (!(isset($_GET['q']) && $_GET['q']) && isset($_SERVER['PATH_INFO']) && $_SERVER['PATH_INFO'][0] == '/')
                {
-                               $sQuery = substr(rawurldecode($_SERVER['PATH_INFO']), 1);
+                       $sQuery = substr(rawurldecode($_SERVER['PATH_INFO']), 1);
 
-                               // reverse order of '/' separated string
-                               $aPhrases = explode('/', $sQuery);
-                               $aPhrases = array_reverse($aPhrases);
-                               $sQuery = join(', ',$aPhrases);
-                               $oGeocode->setQuery($sQuery);
+                       // reverse order of '/' separated string
+                       $aPhrases = explode('/', $sQuery);
+                       $aPhrases = array_reverse($aPhrases);
+                       $sQuery = join(', ',$aPhrases);
+                       $oGeocode->setQuery($sQuery);
                }
                else
                {
-                               $oGeocode->setQueryFromParams($_GET);
+                       $oGeocode->setQueryFromParams($_GET);
                }
        }
 
@@ -118,8 +116,12 @@
        $aSearchResults = $oGeocode->lookup();
        if ($aSearchResults === false) $aSearchResults = array();
 
-       $sDataDate = $oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1");
-
+       if ($sOutputFormat=='html')
+       {
+               $sDataDate = $oDB->getOne("select TO_CHAR(lastimportdate - '2 minutes'::interval,'YYYY/MM/DD HH24:MI')||' GMT' from import_status limit 1");
+               $sTileURL = CONST_Map_Tile_URL;
+               $sTileAttribution = CONST_Map_Tile_Attribution;
+       }
        logEnd($oDB, $hLog, sizeof($aSearchResults));
 
        $bAsText = $oGeocode->getIncludePolygonAsText();