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 61bec19a846dcbd4d8f94193c9566fbccdfb0550..d72fcb7c1c91d1cee1625f8730a299e134ce6ac6 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">
                                </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; ?>
                                        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);
 
 
        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');
        
        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;
        }
 
                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');
        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;
        $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);
 
 
        $oGeocode =& new Geocode($oDB);
 


@@ -99,17 +97,17 @@
        {
                if (!(isset($_GET['q']) && $_GET['q']) && isset($_SERVER['PATH_INFO']) && $_SERVER['PATH_INFO'][0] == '/')
                {
        {
                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
                {
                }
                else
                {

-                               $oGeocode->setQueryFromParams($_GET);
+                       $oGeocode->setQueryFromParams($_GET);

                }
        }
 
                }
        }
 


@@ -118,8 +116,12 @@
        $aSearchResults = $oGeocode->lookup();
        if ($aSearchResults === false) $aSearchResults = array();
 
        $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();
        logEnd($oDB, $hLog, sizeof($aSearchResults));
 
        $bAsText = $oGeocode->getIncludePolygonAsText();