} elseif (in_array($table[$i], $tab_no_fusion) and $field_and_or[$i] != "" and isset($sql_seach[$operation][$table[$i]])) {
$sql_seach[$operation][$table[$i]][$k] .= $field_and_or[$i] . $field[$i] . $field_compar[$i] . $field_value[$i] . $field_value_complement[$i];
$trait_cache = traitement_cache($sql_temp, $field_modif, $field_value[$i], $field_value_complement[$i]);
$sql_cache[$operation][$table[$i]][$k] .= $field_and_or[$i] . $field[$i] . $field_compar[$i] . $trait_cache['field_value'] . $trait_cache['field_value_complement'];
} else {
//si la requête existe déjà
if (isset($sql_seach[$operation][$table[$i]])) {
//si le champ "AND/OR" est vide, on doit concat des champs différents de la même table
// if ($field_and_or[$i] == "")
// $field_and_or[$i]="AND";
$sql_seach[$operation][$table[$i]][$k] .= $field_and_or[$i] . $field[$i] . $field_compar[$i] . $field_value[$i] . $field_value_complement[$i];
$trait_cache = traitement_cache($sql_temp, $field_modif, $field_value[$i], $field_value_complement[$i]);
$sql_cache[$operation][$table[$i]][$k] .= $field_and_or[$i] . $field[$i] . $field_compar[$i] . $trait_cache['field_value'] . $trait_cache['field_value_complement'];
} else {
//on la crée
$traitement = generate_sql($table[$i]);
$sql_seach[$operation][$table[$i]][$i] = $traitement['sql_temp'] . " ( " . $field[$i] . $field_compar[$i] . $field_value[$i] . $field_value_complement[$i];
$trait_cache = traitement_cache($sql_temp, $field_modif, $field_value[$i], $field_value_complement[$i]);
$sql_cache[$operation][$table[$i]][$i] = $traitement['sql_cache'] . " ( " . $field[$i] . $field_compar[$i] . $trait_cache['field_value'] . $trait_cache['field_value_complement'];
}
}
//stockage de la table sur laquelle on requete
//pour afficher les champs correspondant
$list_tables_request[$table[$i]] = $table[$i];
//si une erreur a été rencontrée
//le traitement est arrêté (gain de temps)
// if (isset($ERROR)){
// echo "ATTENTION: ERREUR ".$ERROR;
// break;
// }
$i++;
include $phpbb_root_path . 'includes/functions_admin.' . $phpEx;
include $phpbb_root_path . 'includes/functions_shoutbox.' . $phpEx;
include $phpbb_root_path . 'install/functions.' . $phpEx;
// Start session management
$user->session_begin(false);
$auth->acl($user->data);
$user->setup('mods/shout');
if ($user->data['user_type'] != USER_FOUNDER) {
trigger_error('NO_FOUNDER');
}
if (isset($config['as_version'])) {
trigger_error('ONLY_INSTALL');
}
$dbms = $db->sql_layer;
$table = '';
generate_sql($table, $dbms);
if (empty($table)) {
// Should never happen.
trigger_error('This error should not happen');
}
$config_items = array('as_interval' => 3600, 'as_prune' => 24 * 14, 'as_max_posts' => 0, 'as_flood_interval' => 15, 'as_version' => VERSION, 'as_ie_nr' => 5, 'as_non_ie_nr' => 20);
$config_items_dyn = array('last_as_run' => 0);
$permissions = array('global' => array('u_as_post', 'u_as_view', 'u_as_info', 'u_as_delete', 'u_as_edit', 'u_as_smilies', 'u_as_bbcode', 'u_as_mod_edit', 'u_as_ignore_flood', 'a_as_manage'));
if (!function_exists('get_available_dbms')) {
global $phpbb_root_path, $phpEx;
include $phpbb_root_path . 'includes/functions_install.' . $phpEx;
}
$available_dbms = get_available_dbms();
if ($dbms == 'mysql4' || $dbms == 'mysql') {
if (version_compare($db->mysql_version, '4.1.3', '>=')) {
$available_dbms['mysql']['SCHEMA'] .= '_41';
$ttop = isset($_GET['ttop']) ? $_GET['ttop'] : '3663787.8365148474';
$selector = isset($_GET['selector']) ? $_GET['selector'] : 'all';
$format = isset($_GET['format']) ? $_GET['format'] : 'xml';
//$access = isset($_GET['access']) ? $_GET['access'] : '0';
//$housename = isset($_GET['housename']) ? $_GET['housename'] : '0';
//$housenumber = isset($_GET['housenumber']) ? $_GET['housenumber'] : '0';
//$admin_level = isset($_GET['admin_level']) ? $_GET['admin_level'] : '0';
//$aerialway = isset($_GET['aerialway']) ? $_GET['aerialway'] : '0';
//echo $format;
$query_array = array("osm_id" => isset($_GET['osm_id']) ? $_GET['osm_id'] : false, "access" => isset($_GET['access']) ? $_GET['access'] : false, "addr:housename" => isset($_GET['addr_housename']) ? $_GET['addr_housename'] : false, "addr:housenumber" => isset($_GET['addr_housenumber']) ? $_GET['addr_housenumber'] : false, "addr:interpolation" => isset($_GET['addr_interpolation']) ? $_GET['addr_interpolation'] : false, "admin_level" => isset($_GET['admin_level']) ? $_GET['admin_level'] : false, "aerialway" => isset($_GET['aerialway']) ? $_GET['aerialway'] : false, "aeroway" => isset($_GET['aeroway']) ? $_GET['aeroway'] : false, "amenity" => isset($_GET['amenity']) ? $_GET['amenity'] : false, "area" => isset($_GET['area']) ? $_GET['area'] : false, "barrier" => isset($_GET['barrier']) ? $_GET['barrier'] : false, "bicycle" => isset($_GET['bicycle']) ? $_GET['bicycle'] : false, "brand" => isset($_GET['brand']) ? $_GET['brand'] : false, "bridge" => isset($_GET['bridge']) ? $_GET['bridge'] : false, "boundary" => isset($_GET['boundary']) ? $_GET['boundary'] : false, "building" => isset($_GET['building']) ? $_GET['building'] : false, "capital" => isset($_GET['capital']) ? $_GET['capital'] : false, "construction" => isset($_GET['construction']) ? $_GET['construction'] : false, "covered" => isset($_GET['covered']) ? $_GET['covered'] : false, "culvert" => isset($_GET['culvert']) ? $_GET['culvert'] : false, "cutting" => isset($_GET['cutting']) ? $_GET['cutting'] : false, "denomination" => isset($_GET['denomination']) ? $_GET['denomination'] : false, "disused" => isset($_GET['disused']) ? $_GET['disused'] : false, "ele" => isset($_GET['ele']) ? $_GET['ele'] : false, "embankment" => isset($_GET['embankment']) ? $_GET['embankment'] : false, "foot" => isset($_GET['foot']) ? $_GET['foot'] : false, "generator:source" => isset($_GET['generator_source']) ? $_GET['generator_source'] : false, "harbour" => isset($_GET['harbour']) ? $_GET['harbour'] : false, "highway" => isset($_GET['highway']) ? $_GET['highway'] : false, "historic" => isset($_GET['historic']) ? $_GET['historic'] : false, "horse" => isset($_GET['horse']) ? $_GET['horse'] : false, "intermittent" => isset($_GET['intermittent']) ? $_GET['intermittent'] : false, "junction" => isset($_GET['junction']) ? $_GET['junction'] : false, "landuse" => isset($_GET['landuse']) ? $_GET['landuse'] : false, "layer" => isset($_GET['layer']) ? $_GET['layer'] : false, "leisure" => isset($_GET['leisure']) ? $_GET['leisure'] : false, "lock" => isset($_GET['lock']) ? $_GET['lock'] : false, "man_made" => isset($_GET['man_made']) ? $_GET['man_made'] : false, "military" => isset($_GET['military']) ? $_GET['military'] : false, "motorcar" => isset($_GET['motorcar']) ? $_GET['motorcar'] : false, "name" => isset($_GET['name']) ? $_GET['name'] : false, "natural" => isset($_GET['natural']) ? $_GET['natural'] : false, "office" => isset($_GET['office']) ? $_GET['office'] : false, "oneway" => isset($_GET['oneway']) ? $_GET['oneway'] : false, "operator" => isset($_GET['operator']) ? $_GET['operator'] : false, "place" => isset($_GET['place']) ? $_GET['place'] : false, "poi" => isset($_GET['poi']) ? $_GET['poi'] : false, "population" => isset($_GET['population']) ? $_GET['population'] : false, "power" => isset($_GET['power']) ? $_GET['power'] : false, "power_source" => isset($_GET['power_source']) ? $_GET['power_source'] : false, "public_transport" => isset($_GET['public_transport']) ? $_GET['public_transport'] : false, "railway" => isset($_GET['railway']) ? $_GET['railway'] : false, "ref" => isset($_GET['ref']) ? $_GET['ref'] : false, "religion" => isset($_GET['religion']) ? $_GET['religion'] : false, "route" => isset($_GET['route']) ? $_GET['route'] : false, "service" => isset($_GET['service']) ? $_GET['service'] : false, "shop" => isset($_GET['shop']) ? $_GET['shop'] : false, "sport" => isset($_GET['sport']) ? $_GET['sport'] : false, "surface" => isset($_GET['surface']) ? $_GET['surface'] : false, "toll" => isset($_GET['toll']) ? $_GET['toll'] : false, "tourism" => isset($_GET['tourism']) ? $_GET['tourism'] : false, "tower:type" => isset($_GET['tower_type']) ? $_GET['tower_type'] : false, "tracktype" => isset($_GET['tracktype']) ? $_GET['tracktype'] : false, "tunnel" => isset($_GET['tunnel']) ? $_GET['tunnel'] : false, "water" => isset($_GET['water']) ? $_GET['water'] : false, "waterway" => isset($_GET['waterway']) ? $_GET['waterway'] : false, "wetland" => isset($_GET['wetland']) ? $_GET['wetland'] : false, "width" => isset($_GET['width']) ? $_GET['width'] : false, "wood" => isset($_GET['wood']) ? $_GET['wood'] : false, "z_order" => isset($_GET['z_order']) ? $_GET['z_order'] : false, "way_area" => isset($_GET['way_area']) ? $_GET['way_area'] : false, "tags" => isset($_GET['tags']) ? $_GET['tags'] : false, "way" => isset($_GET['way']) ? $_GET['way'] : false, "way_area" => isset($_GET['way_area']) ? $_GET['way_area'] : false);
$conn_string = "host=dmb.tongji.edu.cn port=5432 dbname=osm user=postgres password=429jhguan";
$dbconn = pg_connect($conn_string);
if (!$dbconn) {
die(json_encode(array("message" => "failed")));
}
$query = generate_sql($query_array);
if ($selector != 'All') {
$query = $query . "from planet_osm_" . $selector . " Where ST_within(way,ST_MakeEnvelope(" . $left . "," . $bottom . "," . $right . "," . $ttop . ",900913));";
} else {
//echo "coming soon...";
/*此处写所有数据一起导出时的语句*/
}
//$query = "Select * from query_to_xml(Select ST_Astext(way) as point from planet_osm_point Where ST_within(way,ST_MakeEnvelope(".$left.",".$bottom.",".$right.",".$ttop.",900913)),true,false,'')";
//$query = "Select ST_Astext(way) as point from planet_osm_point Where ST_within(way,ST_MakeEnvelope(".$left.",".$bottom.",".$right.",".$ttop.",900913))";
//echo $query;
$result = pg_query($query);
$arr = array();
$data = array();
$Item = array();
$Column = array();
$resultCount = 0;
<?php
include "lib/autoload.php";
if (file_exists("schema.php")) {
include "schema.php";
if (isset($config) && isset($schema)) {
echo "<p>Base de datos <b>{$config['db']}</b></p>";
echo "<ul>";
generate_conection($config);
generate_sql($config, $schema);
foreach ($schema as $tablename => $tabledata) {
generate_form($tablename, $tabledata);
generate_form_edit($tablename, $tabledata);
generate_adder($tablename, $tabledata);
generate_editer($tablename, $tabledata);
generate_list($tablename, $tabledata);
generate_deleter($tablename, $tabledata);
}
echo "<li>Finalizado</li>";
echo "</ul>";
}
}
