X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/fa7730d4af7c330d5443c6ae32f5ab73c48bf7a3..c02edeb30fcc3d4ff05bc452d0fb97517a507848:/website/deletable.php?ds=sidebyside diff --git a/website/deletable.php b/website/deletable.php old mode 100755 new mode 100644 index 5d6ee15d..2d7ee7e9 --- a/website/deletable.php +++ b/website/deletable.php @@ -1,102 +1,30 @@ getSet('format', array('html', 'json'), 'html'); +set_exception_handler_by_format($sOutputFormat); - $sSQL = "select placex.place_id, calculated_country_code as country_code, name->'name' as name, i.* from placex, import_polygon_delete i where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type and placex.class = i.class and placex.type = i.type"; - $aPolygons = $oDB->getAll($sSQL); - if (PEAR::isError($aPolygons)) - { - failInternalError("Could not get list of deleted OSM elements.", $sSQL, $aPolygons); - } +$oDB = new Nominatim\DB(); +$oDB->connect(); -//var_dump($aPolygons); -?> - - - - - - - Nominatim Deleted Data - - +$sSQL = 'select placex.place_id, country_code,'; +$sSQL .= " name->'name' as name, i.* from placex, import_polygon_delete i"; +$sSQL .= ' where placex.osm_id = i.osm_id and placex.osm_type = i.osm_type'; +$sSQL .= ' and placex.class = i.class and placex.type = i.type'; +$aPolygons = $oDB->getAll($sSQL, null, 'Could not get list of deleted OSM elements.'); - - - - -

Objects in this table have been deleted in OSM but are still in the Nominatim database.

- - -"; -//var_dump($aPolygons[0]); - foreach($aPolygons[0] as $sCol => $sVal) - { - echo ""; - } - echo ""; - foreach($aPolygons as $aRow) - { - echo ""; - foreach($aRow as $sCol => $sVal) - { - switch($sCol) - { - case 'osm_id': - $sOSMType = ($aRow['osm_type'] == 'N'?'node':($aRow['osm_type'] == 'W'?'way':($aRow['osm_type'] == 'R'?'relation':''))); - echo ''; - break; - case 'place_id': - echo ''; - break; - default: - echo ""; - break; - } - } - echo ""; - } -?> -
".$sCol."
'.$sVal.''.$sVal.'".($sVal?$sVal:' ')."
- - - - - +if ($sOutputFormat == 'json') { + echo javascript_renderData($aPolygons); +} else { + include(CONST_BasePath.'/lib/template/deletable-html.php'); +}