$language_suffix = "en"; //FIXME: there seems to be an error in dyn_css.php concerning php vars. if ($language == "'de'") { $language_suffix = "de"; } $admin = new administration(); $own_gui_id_array = $admin->getGuisByOwner($logged_user_id, true); $own_wms_id_array = array(); $sql = "SELECT wms_id FROM wms WHERE wms_owner = \$1"; $v = array($logged_user_id); $t = array('i'); $res = db_prep_query($sql, $v, $t); while ($row = db_fetch_array($res)) { array_push($own_wms_id_array, $row['wms_id']); } $own_layer_id_array = $admin->getLayerByWms($selected_wms); /*handle remove, update and insert*****************************************************************/ if ($insert) { if (count($selected_topic) > 0) { for ($i = 0; $i < count($selected_topic); $i++) { $exists = false; $sql_insert = "SELECT * FROM layer_md_topic_category WHERE fkey_layer_id = \$1 and fkey_md_topic_category_id = \$2"; $v = array($selected_layer, $selected_topic[$i]); $t = array('i', 'i'); $res_insert = db_prep_query($sql_insert, $v, $t); while (db_fetch_row($res_insert)) { $exists = true; } if ($exists == false) { $sql_insert = "INSERT INTO layer_md_topic_category (fkey_layer_id, fkey_md_topic_category_id) VALUES(\$1, \$2)"; $v = array($selected_layer, $selected_topic[$i]);
echo "[]"; die; } if (!preg_match("/^[a-zA-Z_\\-:0-9 ]+\$/", $srs)) { echo "[]"; die; } $n = new administration(); $myguis = $n->getGuisByPermission($user_id, true); $mywms = $n->getWmsByOwnGuis($myguis); if ($mywms == false) { $mywms = array(); } $mylayer = array(); for ($i = 0; $i < count($mywms); $i++) { $mylayer = array_merge($mylayer, $n->getLayerByWms($mywms[$i])); } $res_container_wms = array(); $res_container_layer = array(); $obj = array(); if (preg_match("/\\*/", $_REQUEST["search"])) { $search = trim(preg_replace("/\\*/i", "", $_REQUEST["search"])); } if (count($mywms) > 0) { $v = array(); $t = array(); $sql_wms = "SELECT DISTINCT layer.layer_id, wms.wms_title, " . "wms.wms_getcapabilities, wms.wms_version, " . "e.minx, e.miny, e.maxx, e.maxy " . "FROM wms LEFT JOIN layer ON wms.wms_id = layer.fkey_wms_id " . "LEFT JOIN layer_epsg e ON layer.layer_id = e.fkey_layer_id " . "AND e.epsg = '{$srs}' " . "WHERE layer.layer_pos = 0 AND wms.wms_id IN ("; for ($i = 0; $i < count($mywms); $i++) { if ($i > 0) { $sql_wms .= ","; }