$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 .= ",";
}
