function getGuis() { $adm = new administration(); $guiList = $adm->getGuisByOwner(Mapbender::session()->get("mb_user_id"), 1); if (count($guiList) > 0) { return $guiList; } return false; }
document.getElementById("metadatalink").href = "mod_layerMetadata.php?id="+wmsData[2]; document.getElementById("metadatatext").firstChild.nodeValue = "WMS-ID: "+wmsData[0]; //end *** } </script> </head> <body> <form name='form1' action='<?php echo $self; ?> ' method='POST'> <?php require_once dirname(__FILE__) . "/../classes/class_administration.php"; $admin = new administration(); $ownguis = $admin->getGuisByOwner(Mapbender::session()->get("mb_user_id"), true); $permguis = $admin->getGuisByPermission(Mapbender::session()->get("mb_user_id"), true); $wms_id_own = $admin->getWmsByOwnGuis($ownguis); if (count($wms_id_own) > 0 and count($ownguis) > 0 and count($permguis) > 0) { $v = array(); $t = array(); $c = 1; //$sql = "SELECT wms_id, wms_title, wms_getcapabilities, wms_upload_url FROM wms "; $sql = "SELECT wms.wms_id, wms.wms_title, wms.wms_getcapabilities, wms.wms_upload_url, layer.layer_id FROM wms, layer "; $sql .= "WHERE wms_id IN("; for ($i = 0; $i < count($wms_id_own); $i++) { if ($wms_id_own[$i] != '') { if ($i > 0) { $sql .= ","; } $sql .= "\$" . $c;
echo $urlParameters; ?> '; document.form1.submit(); } } } </script> </head> <body> <?php //Get GUIs for present user require_once dirname(__FILE__) . "/../classes/class_administration.php"; $admin = new administration(); $ownguis = $admin->getGuisByOwner($_SESSION["mb_user_id"], true); echo "<form name='form1' action='" . $self . "' method='post'>"; echo "<fieldset name=form1_field1><legend>GUI Catalogs</legend>"; echo "<table cellpadding='0' cellspacing='0' border='0'>"; echo "<tr>"; echo "<td>"; if (count($ownguis) > 0) { echo "GUI"; echo "<br>"; $v = array(); $t = array(); $sql = "SELECT * FROM gui WHERE gui_id IN ("; for ($i = 0; $i < count($ownguis); $i++) { if ($i > 0) { $sql .= ","; }
document.form1.submit(); } } } </script> </head> <body> <?php $fieldHeight = 20; $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";
} } } } if ($remove) { if (count($remove_gui) > 0) { for ($i = 0; $i < count($remove_gui); $i++) { $sql_remove = "DELETE FROM gui_gui_category WHERE fkey_gui_id = \$1 and fkey_gui_category_id = \$2"; $v = array($remove_gui[$i], $selected_category); $t = array('s', 'i'); db_prep_query($sql_remove, $v, $t); } } } /*get owner guis *******************************************************************************/ $guisByOwner = $admin->getGuisByOwner($logged_user_id, false); for ($i = 0; $i < count($guisByOwner); $i++) { $gui_id[$cnt_gui] = $guisByOwner[$i]; $gui_name[$cnt_gui] = $guisByOwner[$i]; $cnt_gui++; } /*get categories **********************************************************************************/ $sql_category = "SELECT * FROM gui_category order by category_id;"; $res_category = db_query($sql_category); while ($row = db_fetch_array($res_category)) { $category_id[$cnt_category] = $row["category_id"]; $category_name[$cnt_category] = $row["category_name"]; $category_description[$cnt_category] = $row["category_description"]; $cnt_category++; } $guiCategories = $admin->getGuiCategories();