X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/7a50d2f9964421e932313b15f5d7d3b05ded4c45..c611d49941e8a097116dfb6f6d08e5491a85dcee:/website/deletable.php?ds=inline diff --git a/website/deletable.php b/website/deletable.php old mode 100755 new mode 100644 index 6521e774..ac4294ba --- a/website/deletable.php +++ b/website/deletable.php @@ -1,65 +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 = $oDB->getAll($sSQL); - if (PEAR::isError($aPolygons)) - { - failInternalError("Could not get list of deleted OSM elements.", $sSQL, $aPolygons); - } +$oDB = new Nominatim\DB(); +$oDB->connect(); + +$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.'); + +if (CONST_Debug) { + var_dump($aPolygons); + exit; +} -//var_dump($aPolygons); ?> - - - - Nominatim Deleted Data - - + + + + Nominatim Deleted Data + + @@ -67,34 +71,32 @@ table td { "; -//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; - } - } - echo ""; - } + +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': + echo ''; + break; + case 'place_id': + echo ''; + break; + default: + echo ''; + break; + } + } + echo ''; +} + ?>
".$sCol."
'.osmLink($aRow).''.detailsLink($aRow).'".($sVal?$sVal:' ')."
'.$sCol.'
'.osmLink($aRow).''.detailsLink($aRow).''.($sVal?$sVal:' ').'