X-Git-Url: https://git.openstreetmap.org/nominatim.git/blobdiff_plain/f05ea577f42c5ad4a62ff25ec62fbb60c550ee26..6238ae6032c6f8005dad34d3369df2d280d1e5df:/website/deletable.php diff --git a/website/deletable.php b/website/deletable.php index d96d989c..90eb40c8 100755 --- a/website/deletable.php +++ b/website/deletable.php @@ -1,22 +1,23 @@ '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, 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."); + +if (CONST_DEBUG) { + var_dump($aPolygons); + exit; +} - if (CONST_DEBUG) { - var_dump($aPolygons); - exit; - } ?> @@ -67,30 +68,32 @@ table td { "; +// var_dump($aPolygons[0]); +foreach ($aPolygons[0] as $sCol => $sVal) { + echo ""; +} +echo ""; +foreach ($aPolygons as $aRow) { 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': - echo ''; - break; - case 'place_id': - echo ''; - break; - default: - echo ""; - break; - } + foreach ($aRow as $sCol => $sVal) { + switch ($sCol) { + case 'osm_id': + echo ''; + break; + case 'place_id': + echo ''; + break; + default: + echo ""; + break; } - echo ""; } + echo ""; +} + ?>
".$sCol."
".$sCol."
'.osmLink($aRow).''.detailsLink($aRow).'".($sVal?$sVal:' ')."'.osmLink($aRow).''.detailsLink($aRow).'".($sVal?$sVal:' ')."