X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/2a784fa3d4533d11e3227f868085dcee5a9870c6..a796edb9ced6d46c7edf9a8a7d1ccad3564da004:/website/deletable.php?ds=sidebyside diff --git a/website/deletable.php b/website/deletable.php index 1866f890..95000032 100755 --- a/website/deletable.php +++ b/website/deletable.php @@ -1,21 +1,26 @@ '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."); +$oDB =& getDB(); + +$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 = chksql($oDB->getAll($sSQL), "Could not get list of deleted OSM elements."); + +if (CONST_Debug) { + var_dump($aPolygons); + exit; +} - if (CONST_DEBUG) { - var_dump($aPolygons); - exit; - } ?> @@ -66,30 +71,32 @@ table td {
".$sCol." | "; +} +echo ""; +foreach ($aPolygons as $aRow) { echo "|||||
---|---|---|---|---|---|
".$sCol." | "; - } - echo "|||||
'.osmLink($aRow).' | '; - break; - case 'place_id': - echo ''.detailsLink($aRow).' | '; - break; - default: - echo "".($sVal?$sVal:' ')." | "; - break; - } + foreach ($aRow as $sCol => $sVal) { + switch ($sCol) { + case 'osm_id': + echo ''.osmLink($aRow).' | '; + break; + case 'place_id': + echo ''.detailsLink($aRow).' | '; + break; + default: + echo "".($sVal?$sVal:' ')." | "; + break; } - echo "