X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/8a796db3c974c55de8d59f3682a149e3642e6952..275f3b26560a44099dff762776277812ef0f122f:/website/deletable.php diff --git a/website/deletable.php b/website/deletable.php index c55cb20f..6e9178e0 100755 --- a/website/deletable.php +++ b/website/deletable.php @@ -1,66 +1,69 @@ '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; - } ?>
- - - -".$sCol." | "; - } - echo ""; - foreach($aPolygons as $aRow) - { - echo "||
---|---|---|
'.osmLink($aRow).' | '; - break; - case 'place_id': - echo ''.detailsLink($aRow).' | '; - break; - default: - echo "".($sVal?$sVal:' ')." | "; - break; - } - } - echo "
'.$sCol.' | '; +} +echo '||
'.osmLink($aRow).' | '; + break; + case 'place_id': + echo ''.detailsLink($aRow).' | '; + break; + default: + echo ''.($sVal?$sVal:' ').' | '; + break; + } + } + echo '