X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/6867b240d5d23c22ae04c57d65881d54d793da73..5f19b23f49aee9989267ac03b488049f9d681166:/website/deletable.php?ds=sidebyside diff --git a/website/deletable.php b/website/deletable.php old mode 100755 new mode 100644 index 95000032..ac4294ba --- a/website/deletable.php +++ b/website/deletable.php @@ -1,6 +1,5 @@ connect(); -$sSQL = "select placex.place_id, country_code,"; +$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."); +$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); @@ -73,14 +73,14 @@ table td { "; +echo ''; // var_dump($aPolygons[0]); foreach ($aPolygons[0] as $sCol => $sVal) { - echo "".$sCol.""; + echo ''.$sCol.''; } -echo ""; +echo ''; foreach ($aPolygons as $aRow) { - echo ""; + echo ''; foreach ($aRow as $sCol => $sVal) { switch ($sCol) { case 'osm_id': @@ -90,11 +90,11 @@ foreach ($aPolygons as $aRow) { echo ''.detailsLink($aRow).''; break; default: - echo "".($sVal?$sVal:' ').""; + echo ''.($sVal?$sVal:' ').''; break; } } - echo ""; + echo ''; } ?>