X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/051998dd80b0def50058266b7adbdf2e971032eb..832547f192904a9ec92e173c27a91e0874fcc757:/website/deletable.php?ds=sidebyside diff --git a/website/deletable.php b/website/deletable.php index 3283bb83..6d57262d 100755 --- a/website/deletable.php +++ b/website/deletable.php @@ -1,64 +1,66 @@ '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); - } + $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 = chksql($oDB->getAll($sSQL), + "Could not get list of deleted OSM elements."); -//var_dump($aPolygons); + if (CONST_DEBUG) + { + var_dump($aPolygons); + exit; + } ?> - - - - Nominatim Deleted Data - - + + + + Nominatim Deleted Data + + @@ -66,34 +68,34 @@ table td { "; + if (!$aPolygons) exit; + echo ""; //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 ""; - } + foreach($aPolygons[0] as $sCol => $sVal) + { + echo ""; + } + echo ""; + foreach($aPolygons as $aRow) + { + echo ""; + foreach($aRow as $sCol => $sVal) + { + switch($sCol) + { + case 'osm_id': + echo ''; + break; + case 'place_id': + echo ''; + break; + default: + echo ""; + break; + } + } + echo ""; + } ?>
".$sCol."
'.$sVal.''.$sVal.'".($sVal?$sVal:' ')."
".$sCol."
'.osmLink($aRow).''.detailsLink($aRow).'".($sVal?$sVal:' ')."