/** * Parses the capabilities document for the WFS * version number and returns it. * * @return String * @param $xml String */ private function getVersionFromXml($xml) { $admin = new administration(); $values = $admin->parseXml($xml); foreach ($values as $element) { if ($this->sepNameSpace(strtoupper($element[tag])) == "WFS_CAPABILITIES" && $element[type] == "open") { return $element[attributes][version]; } } throw new Exception("WFS version could not be determined from XML."); }
private function readConfig($jsonConfFile) { $admin = new administration(); $mbjson = new Mapbender_JSON(); $jsonStr = file_get_contents(dirname(__FILE__) . "/../" . $jsonConfFile); if ($jsonStr == false) { $e = new mb_exception("mbPdfFactory: config file could not be read."); die("config not found."); } $jsonConf = $mbjson->decode($admin->char_encode($jsonStr)); return $jsonConf; }
function getWfsConfData($wfsID) { global $con; // re-check permission $adm = new administration(); $serviceList = $adm->getWfsByOwner(Mapbender::session()->get("mb_user_id")); if (in_array($wfsID, $serviceList)) { $wfsConf = array(); $wfsConf['id'] = array(); $wfsConf['abstract'] = array(); $sql = "SELECT * FROM wfs_conf WHERE fkey_wfs_id = \$1 ORDER BY wfs_conf_abstract"; $v = array($wfsID); $t = array('i'); $res = db_prep_query($sql, $v, $t); $cnt = 0; while ($row = db_fetch_array($res)) { array_push($wfsConf['id'], $row['wfs_conf_id']); array_push($wfsConf['abstract'], $row['wfs_conf_abstract']); $cnt++; } if ($cnt == 0) { return false; } else { return $wfsConf; } } // else if($wfsID==="gui_confs"){ // $wfsConf = array(); // $wfsConf['id'] = array(); // $wfsConf['abstract'] = array(); // $wfsConf['id'] = $adm->getWfsConfByPermission(Mapbender::session()->get("mb_user_id")); // $cnt = 0; // foreach($wfsConf['id'] as $wfscid){ // $sql = "SELECT wfs_conf_abstract FROM wfs_conf WHERE wfs_conf_id = $1"; // $v = array($wfscid); // $t = array('i'); // $res = db_prep_query($sql,$v,$t); // while($row = db_fetch_array($res)){ // array_push($wfsConf['abstract'], $row['wfs_conf_abstract']); // } // $cnt++; // } // if($cnt == 0){ // return false; // } // else{ // return $wfsConf; // } // } }
function __construct() { parent::__construct(); $this->load->model('reception/reception_model'); $this->load->model('reports_model'); $this->load->model('accounts/accounts_model'); }
function forgotten_password() { if (!isset($_REQUEST["Benutzername"]) || !isset($_REQUEST["EMail"]) || $_REQUEST["Benutzername"] == 'guest' || empty($_REQUEST["Benutzername"]) || empty($_REQUEST["EMail"]) || !(bool) trim($_REQUEST["Benutzername"]) || !(bool) trim($_REQUEST["EMail"])) { return -1; } if (!USE_PHP_MAILING) { return -4; } $administration = new administration(); define("USER_NAME", trim($_REQUEST["Benutzername"])); define("USER_EMAIL", trim($_REQUEST["EMail"])); if (!$administration->getUserIdByUserName(USER_NAME) || USER_EMAIL != $administration->getEmailByUserId($administration->getUserIdByUserName(USER_NAME))) { return -2; } $new_password = $administration->getRandomPassword(); $sql_update = "UPDATE mb_user SET mb_user_password = \$1, mb_user_digest = \$3 WHERE mb_user_id = \$2"; $v = array(md5($new_password), $administration->getUserIdByUserName(USER_NAME), md5(USER_NAME . ";" . USER_EMAIL . ":" . REALM . ":" . $new_password)); $t = array("s", "i"); if (!db_prep_query($sql_update, $v, $t)) { return -3; } $email_subject = "New GeoPortal.rlp Password"; $email_body = sprintf("Your new GeoPortal.rlp password is: %s", $new_password); if (!$administration->sendEmail(NULL, NULL, USER_EMAIL, USER_NAME, $email_subject, $email_body, $error_msg)) { return -4; } return 1; }
public function __construct() { parent::__construct(); $version = administration::getCurrentVersion(); require '_upgrade.php'; }
//new for showing metadata - 30.05.2008 AR 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 .= ","; }
document.form1.insert.value = 'true'; 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;
/** * Creates WFS 1.0 objects from a capabilities documents. * * @return Wfs_1_0 * @param $xml String */ public function createFromXml($xml) { try { $myWfs = new Wfs_1_0(); $admin = new administration(); $values = $admin->parseXml($xml); $myWfs->getCapabilitiesDoc = $admin->char_encode($xml); $myWfs->id = $this->createId(); foreach ($values as $element) { $tag = strtoupper($element[tag]); if ($tag == "WFS_CAPABILITIES" && $element[type] == "open") { $myWfs->version = $element[attributes][version]; if ($myWfs->version !== "1.0.0") { throw new Exception("Not a WFS 1.0.0 capabilities document."); } } if ($tag == "NAME" && $element[level] == '3') { $myWfs->name = $element[value]; } if ($tag == "TITLE" && $element[level] == '3') { $myWfs->title = $this->stripEndlineAndCarriageReturn($element[value]); } if ($tag == "ABSTRACT" && $element[level] == '3') { $myWfs->summary = $this->stripEndlineAndCarriageReturn($element[value]); } if ($tag == "FEES") { $myWfs->fees = $element[value]; } if ($tag == "ACCESSCONSTRAINTS") { $myWfs->accessconstraints = $element[value]; } # getCapabilities if ($tag == "GETCAPABILITIES" && $element[type] == "open") { $section = "getcapabilities"; } if ($section == "getcapabilities" && $tag == "GET") { $myWfs->getCapabilities = $element[attributes][onlineResource]; } # descriptFeatureType if ($tag == "DESCRIBEFEATURETYPE" && $element[type] == "open") { $section = "describefeaturetype"; $myWfs->describeFeatureType = $element[attributes][onlineResource]; } if ($section == "describefeaturetype" && $tag == "POST") { $myWfs->describeFeatureType = $element[attributes][onlineResource]; } # getFeature if ($tag == "GETFEATURE" && $element[type] == "open") { $section = "getfeature"; } if ($section == "getfeature" && $tag == "POST") { $myWfs->getFeature = $element[attributes][onlineResource]; } if ($tag == "GETFEATURE" && $element[type] == "close") { $section = ""; } # transaction if ($tag == "TRANSACTION" && $element[type] == "open") { $section = "transaction"; } if ($section == "transaction" && $tag == "POST") { $myWfs->transaction = $element[attributes][onlineResource]; } if ($tag == "TRANSACTION" && $element[type] == "close") { $section = ""; } if ($tag == "FEATURETYPE" && $element[type] == "open") { $section = "featuretype"; } if ($section == "featuretype" && $tag == "NAME") { $featuretype_name = $element[value]; } if ($section == "featuretype" && $tag == "TITLE") { $featuretype_title = $this->stripEndlineAndCarriageReturn($element[value]); } if ($section == "featuretype" && $tag == "ABSTRACT") { $featuretype_abstract = $element[value]; } if ($section == "featuretype" && $tag == "SRS") { $featuretype_srs = $element[value]; // Do not add defective featuretypes try { $currentFeatureType = $this->createFeatureTypeFromUrl($myWfs, $featuretype_name); if ($currentFeatureType !== null) { $currentFeatureType->name = $featuretype_name; $currentFeatureType->title = $featuretype_title; $currentFeatureType->summary = $featuretype_abstract; $currentFeatureType->srs = $featuretype_srs; $myWfs->addFeatureType($currentFeatureType); } } catch (Exception $e) { new mb_exception("Failed to load featuretype " . $featuretype_name); } } } return $myWfs; } catch (Exception $e) { $e = new mb_exception($e); return null; } }
/** * updateObjFromXML * * this function regets the information from the xml (update) * @return boolean true if successful, false otherwise */ function updateObjFromXML($url) { $x = new connector($url); $data = $x->file; #$data = implode("",file($url)); if (!$data) { $e = new mb_exception("Unable to open document: " . $url); return false; } $values = null; $tags = null; $admin = new administration(); $this->wfs_getcapabilities_doc = $admin->char_encode($data); $this->wfs_featuretype = array(); $this->wfs_upload_url = $url; # for temporary wfs a id has to be created... //$this->wfs_id = "id_" . substr(md5(rand()),0,6); $parser = xml_parser_create(CHARSET); xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0); xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1); xml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, CHARSET); xml_parse_into_struct($parser, $this->wfs_getcapabilities_doc, $values, $tags); //xml_parse_into_struct($parser,$data,$values,$tags); xml_parser_free($parser); $section = false; $request = false; $featuretype_name = false; $featuretype_title = false; $featuretype_abstract = false; $featuretype_srs = false; foreach ($values as $element) { if (strtoupper($element[tag]) == "WFS_CAPABILITIES" && $element[type] == "open") { $this->wfs_version = $element[attributes][version]; } if (strtoupper($element[tag]) == "NAME" && $element[level] == '3') { $this->wfs_name = $element[value]; } /* if(strtoupper($element[tag]) == "TITLE" && $element[level] == '3'){ $this->wfs_title = $this->stripEndlineAndCarriageReturn($element[value]); } if(strtoupper($element[tag]) == "ABSTRACT" && $element[level] == '3'){ $this->wfs_abstract = $this->stripEndlineAndCarriageReturn($element[value]); } //new WFS 1.0.0 -- SB 2007-08-06 if(strtolower($element[tag]) == "fees"){ $this->fees = $element[value]; } if(strtolower($element[tag]) == "accessconstraints"){ $this->accessconstraints = $element[value]; } */ /*capability section*/ if ($this->wfs_version == "1.0.0") { # getCapabilities if (strtoupper($element[tag]) == "GETCAPABILITIES" && $element[type] == "open") { $section = "getcapabilities"; } if ($section == "getcapabilities" && strtoupper($element[tag]) == "POST") { $this->wfs_getcapabilities = $element[attributes][onlineResource]; } # descriptFeatureType if (strtoupper($element[tag]) == "DESCRIBEFEATURETYPE" && $element[type] == "open") { $section = "describefeaturetype"; $this->wfs_describefeaturetype = $element[attributes][onlineResource]; } if ($section == "describefeaturetype" && strtoupper($element[tag]) == "POST") { $this->wfs_describefeaturetype = $element[attributes][onlineResource]; } # getFeature if (strtoupper($element[tag]) == "GETFEATURE" && $element[type] == "open") { $section = "getfeature"; } if ($section == "getfeature" && strtoupper($element[tag]) == "POST") { $this->wfs_getfeature = $element[attributes][onlineResource]; } if (strtoupper($element[tag]) == "GETFEATURE" && $element[type] == "close") { $section = ""; } # transaction if (strtoupper($element[tag]) == "TRANSACTION" && $element[type] == "open") { $section = "transaction"; } if ($section == "transaction" && strtoupper($element[tag]) == "POST") { $this->wfs_transaction = $element[attributes][onlineResource]; } if (strtoupper($element[tag]) == "TRANSACTION" && $element[type] == "close") { $section = ""; } } if (strtoupper($element[tag]) == "FEATURETYPE" && $element[type] == "open") { $section = "featuretype"; } if ($section == "featuretype" && strtoupper($element[tag]) == "NAME") { $featuretype_name = $element[value]; } if ($section == "featuretype" && strtoupper($element[tag]) == "TITLE") { $featuretype_title = $this->stripEndlineAndCarriageReturn($element[value]); } if ($section == "featuretype" && strtoupper($element[tag]) == "ABSTRACT") { $featuretype_abstract = $this->{$element}[value]; } if ($section == "featuretype" && strtoupper($element[tag]) == "SRS") { $featuretype_srs = $element[value]; $this->addFeaturetype($featuretype_name, $featuretype_title, $featuretype_abstract, $featuretype_srs, $this->wfs_describefeaturetype, $this->wfs_version); } } return true; }
} else { $resultObj["data"] = array("wmsArray" => array()); } break; case 'getCustomTreeByApplication': $applicationId = $queryObj->parameters->applicationId; // get all of the users applications $allowedApplicationArray = $user->getApplicationsByPermission(0); if (in_array($applicationId, $allowedApplicationArray)) { $sql = "SELECT lft, rgt, my_layer_title, wms_id " . "FROM gui_treegde " . "WHERE fkey_gui_id = \$1 ORDER BY lft"; $v = array($applicationId); $t = array("s"); $res = db_prep_query($sql, $v, $t); $nodeArray = array(); //check if wms exists in gui $n = new administration(); $applicationArray = array($applicationId); $mywms = $n->getWmsByOwnGuis($applicationArray); while ($row = db_fetch_array($res)) { $wmsIdArray = explode(",", $row["wms_id"]); $wmsArray = array(); foreach ($wmsIdArray as $wmsId) { if (in_array($wmsId, $mywms)) { if (is_numeric($wmsId)) { $sqlWms = "SELECT wms_title FROM wms WHERE wms_id = \$1"; $vWms = array($wmsId); $tWms = array("i"); $resWms = db_prep_query($sqlWms, $vWms, $tWms); $rowWms = db_fetch_array($resWms); $wmsArray[$wmsId] = $rowWms[0]; }
# it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2, or (at your option) # any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. ob_start(); include_once dirname(__FILE__) . "/../../conf/mapbender.conf"; include dirname(__FILE__) . "/../classes/class_administration.php"; $adm = new administration(); $con = db_connect(DBSERVER, OWNER, PW); db_select_db(DB, $con); $id = $_GET['id']; $sql = "SELECT * FROM mb_meetingpoint WHERE mb_meetingpoint_id = \$1"; $v = array($id); $t = array('s'); $res = db_prep_query($sql, $v, $t); if ($row = db_fetch_array($res)) { $user = $adm->getUserNameByUserId($row['fkey_mb_user_id']); $password = $row['mb_user_password']; $gui_id = $row['fkey_gui_id']; } else { exit; } $url = "http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['SCRIPT_NAME']) . "/login.php?";
return strcmp($apiToken, $_POST['token']) == 0 ? true : false; } else { return false; } } if (is_ajax() && is_valid()) { if ($_SERVER['REQUEST_METHOD'] === 'POST') { } if (isset($_GET['type']) && isset($_GET['action'])) { /* * TODO * Ajotuer ici un control pour savoir si l'utilisateur en cours a le droit d'appeler les fonctions suivantes */ switch ($_GET['type']) { case "admin": $a = new administration(); switch ($_GET['action']) { case "getFileFromChaudiere": $a->getFileFromChaudiere(); break; case "getHeaderFromOkoCsv": $a->getHeaderFromOkoCsv(); break; case "getSaisons": $a->getSaisons(); break; case "checkUpdate": $a->checkUpdate(); break; case "getVersion": $a->getVersion();
$sql_owner = "Update mb_user SET mb_user_owner = \$1 "; $sql_owner .= " WHERE mb_user_name = \$2 "; $v = array(1, $name); #$selected_user; $t = array('i', 's'); $res_owner = db_prep_query($sql_owner, $v, $t); # removed, because a new user may be inserted in a group with too many privileges $sql_group = "Insert INTO mb_user_mb_group (fkey_mb_user_id, fkey_mb_group_id) VALUES "; $sql_group .= "(\$1, \$2) "; $v = array($selected_user, 20); $t = array('i', 'i'); $res_group = db_prep_query($sql_group, $v, $t); // CB (begin) // adding new GUIs for new user (copies of gui and gui1 with owner rights) $gui = new gui(); $admin = new administration(); //create new name for gui $gui_id1 = $admin->getGuiIdByGuiName("gui"); $gui_id2 = $admin->getGuiIdByGuiName("gui1"); $gui_id3 = $admin->getGuiIdByGuiName("gui2"); $gui_id4 = $admin->getGuiIdByGuiName("gui_digitize"); $gui_newName1 = $name . "_gui"; $gui_newName2 = $name . "_gui1"; $gui_newName3 = $name . "_gui2"; $gui_newName4 = $name . "_gui_digitize"; //check if new gui names are already taken while ($gui->guiExists($gui_newName1)) { $gui_newName1 .= "_1"; } while ($gui->guiExists($gui_newName2)) { $gui_newName2 .= "_1";
$caps = $capabilitiesURL; #$e = new mb_exception("mod_createJSObjFromXML: CapUrl decodes to load: ".$caps); $caps = html_entity_decode($_REQUEST['caps']); //$caps = html_entity_decode(base64_decode($_REQUEST['caps'])); $mywms->createObjFromXML($caps); $errorMessage = _mb("Error: The Capabilities Document could not be accessed. " . "Please check whether the server is responding and accessible to " . "Mapbender."); if (!$mywms->wms_status) { $output .= "try {" . "Mapbender.Modules.dialogManager.openDialog({" . "content: '" . $errorMessage . "<br><br><b>" . $capabilitiesURL . "', modal: false, effectShow: 'puff'});" . "} catch (e) {" . "prompt('" . $errorMessage . "', '" . $capabilitiesURL . "');" . "}"; } else { if ($noHtml) { $output .= $mywms->createJsObjFromWMS_(false); } else { $output .= $mywms->createJsObjFromWMS_(true); } } $js = administration::convertOutgoingString($output); unset($output); if ($noHtml) { echo $js; } else { /* $js .= "parent.mod_addWMS_refresh();"; echo <<<HTML <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Load WMS</title> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="Content-Type" content="text/html; charset='$charset'">
# but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. require_once dirname(__FILE__) . "/../php/mb_validateSession.php"; require_once dirname(__FILE__) . "/../classes/class_wms.php"; require_once dirname(__FILE__) . "/../classes/class_administration.php"; require_once dirname(__FILE__) . "/../classes/class_json.php"; $userId = Mapbender::session()->get("mb_user_id"); $command = $_GET["command"]; $guiId = $_GET["guiId"]; $groupId = $_GET["groupId"]; $admin = new administration(); $guiIdArray = $admin->getGuisByPermission($userId, false); $resultObj = array(); if ($command == "getGroups") { $resultObj["group"] = array(); $sql = "SELECT mb_group_id, mb_group_name, gettext(\$1, mb_group_description) as mb_group_description "; $sql .= "FROM mb_group, mb_user_mb_group "; $sql .= "WHERE fkey_mb_group_id = mb_group_id AND fkey_mb_user_id = \$2 "; $sql .= "ORDER BY mb_group_name"; $v = array(Mapbender::session()->get("mb_lang"), $userId); $t = array("s", "i"); $res = db_prep_query($sql, $v, $t); while ($row = db_fetch_array($res)) { $resultArray = array("description" => $row["mb_group_description"], "name" => $row["mb_group_name"], "id" => $row["mb_group_id"]); array_push($resultObj["group"], $resultArray); }
var permission = confirm("A mail will be sent to the owners of '" + document.form1.wmsList.options[ind].text + "', suggesting its deletion."); if(permission === true) { document.form2.suggest.value = 1; document.form2.wms_name.value = document.form1.wmsList.options[ind].text; document.form2.owners.value = email_str; document.form2.submit(); } } } --> </script> </head> <body> <?php require_once dirname(__FILE__) . "/../classes/class_administration.php"; $admin = new administration(); $error_msg = ''; //if mail form has been filled in and sent if ($_POST["mail"]) { if (!$admin->isValidEmail($_POST["replyto"])) { $error_msg .= "The reply-to address is not valid! Please correct it."; } else { $toAddr = array(); $toName = array(); $namesAndAddresses = explode(":::", $_POST["owners"]); for ($i = 0; $i < count($namesAndAddresses) - 1; $i++) { $nameAndAddress = explode(";;;", $namesAndAddresses[$i]); $toAddr[$i] = $nameAndAddress[0]; $toName[$i] = $nameAndAddress[1]; } $error = '';
db_select_db(DB, $con); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="expires" content="0"> <?php echo '<meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '">'; ?> </head> <body> <?php $admin = new administration(); //Test if ID was valid if ($_REQUEST['wmsid']) { $wms_id = intval($_GET['wmsid']); } else { echo "Invalid WMS ID."; die; } //Test if userid was valid if ($_REQUEST['userid']) { $userid = intval($_REQUEST['userid']); } //else { // echo "Invalid User ID."; // die; //}
function removeOwsproxy($obj) { $n = new administration(); if ($obj->wfs == "gui_confs") { return false; } return $n->setWfsOwsproxyString($obj->wfs, false); }
require_once dirname(__FILE__) . "/../classes/class_wms.php"; require_once dirname(__FILE__) . "/../classes/class_mb_exception.php"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="expires" content="0"> <?php echo '<meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '">'; ?> </head> <body> <?php $admin = new administration(); $user = new User(); // update selected wms $checkboxes = intval($_POST['cbs']); for ($i = 0; $i < $checkboxes; $i++) { echo $i; if (!isset($_POST['cb' . $i]) || !isset($_POST['upl_id' . $i])) { continue; } $upd_wmsid = intval($_POST['cb' . $i]); $upload_id = intval($_POST['upl_id' . $i]); if ($upd_wmsid) { // get upload URL $sql = "SELECT wms_upload_url, wms_owner FROM wms WHERE wms_id = \$1"; $v = array($upd_wmsid); $t = array("i");
<body> <?php if (isset($_REQUEST["languageCode"]) & $_REQUEST["languageCode"] != "") { //validate to csv integer list $testMatch = $_REQUEST["languageCode"]; if (!($testMatch == 'de' or $testMatch == 'fr' or $testMatch == 'en')) { echo 'languageCode: <b>' . $testMatch . '</b> is not valid.<br/>'; die; } $languageCode = $testMatch; $testMatch = NULL; Mapbender::session()->set("mb_lang", $languageCode); //set session var to languageCode $localeObj = new Mb_locale(Mapbender::session()->get("mb_lang")); } $admin = new administration(); $user = new User(); //echo $user->id."<br>"; //only logged in user can see their subscribed services $sql = "SELECT DISTINCT mb_wms_availability.fkey_wms_id FROM mb_wms_availability,mb_user_abo_ows WHERE mb_wms_availability.fkey_wms_id=mb_user_abo_ows.fkey_wms_id AND mb_user_abo_ows.fkey_mb_user_id=\$1"; $res = db_prep_query($sql, array($user->id), array("i")); $cnt = 0; $wms = array(); while (db_fetch_row($res)) { $wms[$cnt] = db_result($res, $cnt, "fkey_wms_id"); $cnt++; } $status = array(); $upload_id = array(); for ($i = 0; $i < count($wms); $i++) { $wms_id[$wms[$i]] = $wms[$i];
public function saveAsFile() { if (func_num_args() === 1) { $pathAndFilename = func_get_arg(0); } else { if ($this->filename) { $pathAndFilename = $this->filename; } else { new mb_exception(__FILE__ . ": saveAsFile(): must specify a filename!"); return false; } } //delete all entries which are more than MAX_ENTRIES from RSS! return administration::saveFile($pathAndFilename, $this->__toString()); }
function createObjFromDBNoGui($wms_id, $withProxyUrls = true) { $sql = "Select * from wms where wms_id = \$1 "; $v = array($wms_id); $t = array('i'); $res_wms = db_prep_query($sql, $v, $t); $count_wms = 0; while ($row2 = db_fetch_array($res_wms)) { $this->wms_id = $row2["wms_id"]; $this->wms_version = $row2["wms_version"]; $this->wms_title = administration::convertIncomingString($this->stripEndlineAndCarriageReturn($row2["wms_title"])); $this->wms_abstract = administration::convertIncomingString($this->stripEndlineAndCarriageReturn($row2["wms_abstract"])); $wmsowsproxy = $row2["wms_owsproxy"]; #$wmsowsproxy = "test"; //exchange the method urls with owsproxy urls if needed - default is to do it, but sometimes this is not usefull! if ($wmsowsproxy != "" && $withProxyUrls) { $owsproxyurl = OWSPROXY . "/" . session_id() . "/" . $wmsowsproxy . "?"; $this->wms_getmap = $owsproxyurl; $this->wms_getcapabilities = $owsproxyurl; $this->wms_getfeatureinfo = $owsproxyurl; $this->wms_getlegendurl = $owsproxyurl; } else { $this->wms_getmap = $row2["wms_getmap"]; $this->wms_getcapabilities = $row2["wms_getcapabilities"]; $this->wms_getfeatureinfo = $row2["wms_getfeatureinfo"]; $this->wms_getlegendurl = $row2["wms_getlegendurl"]; } // TO DO: Capabilities document needs to // be encoded to the original encoding // if different from the database encoding $this->wms_getcapabilities_doc = $row2["wms_getcapabilities_doc"]; $this->wms_upload_url = $row2["wms_upload_url"]; $this->wms_filter = $row2["wms_filter"]; $this->wms_supportsld = $row2["wms_supportsld"]; $this->wms_userlayer = $row2["wms_userlayer"]; $this->wms_userstyle = $row2["wms_userstyle"]; $this->wms_remotewfs = $row2["wms_remotewfs"]; $this->wms_timestamp = $row2["wms_timestamp"]; $this->wms_timestamp_create = $row2["wms_timestamp_create"]; $this->fees = $row2["fees"]; $this->accessconstraints = $row2["accessconstraints"]; $this->contactperson = $row2["contactperson"]; $this->contactposition = $row2["contactposition"]; $this->contactvoicetelephone = $row2["contactvoicetelephone"]; $this->contactfacsimiletelephone = $row2["contactfacsimiletelephone"]; $this->contactorganization = $row2["contactorganization"]; $this->address = $row2["address"]; $this->city = $row2["city"]; $this->stateorprovince = $row2["stateorprovince"]; $this->postcode = $row2["postcode"]; $this->country = $row2["country"]; $this->contactelectronicmailaddress = $row2["contactelectronicmailaddress"]; $this->wms_network_access = $row2["wms_network_access"]; $this->fkey_mb_group_id = $row2["fkey_mb_group_id"]; $this->uuid = $row2["uuid"]; #some default $this->gui_wms_visible = 1; $this->gui_wms_opacity = 100; $this->gui_wms_epsg = $row["gui_wms_epsg"]; $this->gui_wms_sldurl = $row["gui_wms_sldurl"]; if ($this->wms_version == "1.0.0") { $this->gui_wms_mapformat = "PNG"; $this->gui_wms_featureinfoformat = "MIME"; $this->gui_wms_exceptionformat = "INIMAGE"; } else { $this->gui_wms_mapformat = "image/png"; $this->gui_wms_featureinfoformat = "text/html"; $this->gui_wms_exceptionformat = "application/vnd.ogc.se_inimage"; } $count_wms++; } ### formats $sql = "SELECT * FROM wms_format WHERE fkey_wms_id = \$1 "; $v = array($wms_id); $t = array('i'); $res_wms = db_prep_query($sql, $v, $t); $count_format = 0; while ($row3 = db_fetch_array($res_wms)) { $this->data_type[$count_format] = $row3["data_type"]; $this->data_format[$count_format] = $row3["data_format"]; $count_format++; } $sql = "Select * from layer where fkey_wms_id = \$1 ORDER BY layer_pos"; $v = array($wms_id); $t = array('i'); $res_layer = db_prep_query($sql, $v, $t); $count_layer = 0; while ($row2 = db_fetch_array($res_layer)) { $this->addLayer($row2["layer_pos"], $row2["layer_parent"]); $layer_cnt = count($this->objLayer) - 1; $this->objLayer[$layer_cnt]->layer_uid = $row2["layer_id"]; $this->objLayer[$layer_cnt]->layer_name = administration::convertIncomingString($row2["layer_name"]); $this->objLayer[$layer_cnt]->layer_title = administration::convertIncomingString($row2["layer_title"]); $this->objLayer[$layer_cnt]->layer_abstract = administration::convertIncomingString($row2["layer_abstract"]); $this->objLayer[$layer_cnt]->gui_layer_title = $this->objLayer[$layer_cnt]->layer_title; $this->objLayer[$layer_cnt]->layer_dataurl[0]->href = $row2["layer_dataurl"]; //load all metadataUrl elements from mb_metadata $sql = "SELECT metadata_id, link, linktype, md_format FROM mb_metadata INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id = \$1) as relation ON mb_metadata.metadata_id = relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'"; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_metadataUrl = db_prep_query($sql, $v, $t); $count_metadataUrl = 0; while ($row4 = db_fetch_array($res_metadataUrl)) { $this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->href = $row4["link"]; $e = new mb_notice("nogui layer_metadataurl: " . $row4["link"]); $this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->type = $row4["linktype"]; $this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->format = $row4["md_format"]; $count_metadataUrl++; } //old one: //$this->objLayer[$layer_cnt]->layer_metadataurl[0]->href = $row2["layer_metadataurl"]; $this->objLayer[$layer_cnt]->layer_searchable = $row2["layer_searchable"]; $this->objLayer[$layer_cnt]->layer_pos = $row2["layer_pos"]; $this->objLayer[$layer_cnt]->layer_queryable = $row2["layer_queryable"]; $this->objLayer[$layer_cnt]->layer_minscale = $row2["layer_minscale"]; $this->objLayer[$layer_cnt]->layer_maxscale = $row2["layer_maxscale"]; $this->objLayer[$layer_cnt]->uuid = $row2["uuid"]; if ($this->objLayer[$layer_cnt]->layer_minscale == "") { $this->objLayer[$layer_cnt]->layer_minscale = 0; } if ($this->objLayer[$layer_cnt]->layer_maxscale == "") { $this->objLayer[$layer_cnt]->layer_maxscale = 0; } $this->objLayer[$layer_cnt]->gui_layer_minscale = $this->objLayer[$layer_cnt]->layer_minscale; $this->objLayer[$layer_cnt]->gui_layer_maxscale = $this->objLayer[$layer_cnt]->layer_maxscale; $this->objLayer[$layer_cnt]->gui_layer_queryable = $this->objLayer[$layer_cnt]->layer_queryable; $this->objLayer[$layer_cnt]->gui_layer_wms_id = $this->wms_id; $sql = "Select * from layer_epsg where fkey_layer_id = \$1 ORDER BY fkey_layer_id"; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_layer_epsg = db_prep_query($sql, $v, $t); $count_layer_epsg = 0; while ($row2 = db_fetch_array($res_layer_epsg)) { $this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["epsg"] = $row2["epsg"]; $this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["minx"] = $row2["minx"]; $this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["miny"] = $row2["miny"]; $this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["maxx"] = $row2["maxx"]; $this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["maxy"] = $row2["maxy"]; $count_layer_epsg++; } ### read out keywords $sql = "SELECT keyword FROM keyword, layer_keyword \nWHERE keyword_id = fkey_keyword_id AND fkey_layer_id = \$1"; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_layer_keywords = db_prep_query($sql, $v, $t); $count_layer_keywords = 0; while ($row2 = db_fetch_array($res_layer_keywords)) { $this->objLayer[$layer_cnt]->layer_keyword[$count_layer_keywords] = $row2["keyword"]; $count_layer_keywords++; } ### read out layer_md_topic_category_id $sql = "SELECT fkey_md_topic_category_id FROM layer_md_topic_category WHERE fkey_layer_id = \$1"; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_layer_md_topic_category = db_prep_query($sql, $v, $t); $count_layer_md_topic_category = 0; while ($row2 = db_fetch_array($res_layer_md_topic_category)) { $this->objLayer[$layer_cnt]->layer_md_topic_category_id[$count_layer_md_topic_category] = $row2["fkey_md_topic_category_id"]; $count_layer_md_topic_category++; } ### read out layer_inspire_category_id $sql = "SELECT fkey_inspire_category_id FROM layer_inspire_category WHERE fkey_layer_id = \$1"; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_layer_inspire_category = db_prep_query($sql, $v, $t); $count_layer_inspire_category = 0; while ($row2 = db_fetch_array($res_layer_inspire_category)) { $this->objLayer[$layer_cnt]->layer_inspire_category_id[$count_layer_inspire_category] = $row2["fkey_inspire_category_id"]; $count_layer_inspire_category++; } ### read out layer_custom_category_id $sql = "SELECT fkey_custom_category_id FROM layer_custom_category WHERE fkey_layer_id = \$1"; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_layer_custom_category = db_prep_query($sql, $v, $t); $count_layer_custom_category = 0; while ($row2 = db_fetch_array($res_layer_custom_category)) { $this->objLayer[$layer_cnt]->layer_custom_category_id[$count_layer_custom_category] = $row2["fkey_custom_category_id"]; $count_layer_custom_category++; } ### handle styles $sql = "SELECT * FROM layer_style WHERE fkey_layer_id = \$1 "; $v = array($this->objLayer[$layer_cnt]->layer_uid); $t = array('i'); $res_style = db_prep_query($sql, $v, $t); $count_layer_style = 0; while ($row2 = db_fetch_array($res_style)) { $this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["name"] = $row2["name"]; $this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["title"] = $row2["title"]; if ($wmsowsproxy != "") { if ($row2["legendurl"] != '') { $this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"] = $owsproxyurl . "REQUEST=getlegendgraphic&VERSION=" . $this->wms_version . "&LAYER=" . $this->objLayer[$layer_cnt]->layer_name . "&FORMAT=" . $row2["legendurlformat"] . "&STYLE=" . $row2["name"]; } } else { if ($row2["legendurl"] != '') { $this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"] = $row2["legendurl"]; #$e = new mb_exception("legendurl = ".$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"]); } } $this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurlformat"] = $row2["legendurlformat"]; $count_layer_style++; } $count_layer++; } }
# # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. require_once dirname(__FILE__) . "/../core/globalSettings.php"; require_once dirname(__FILE__) . "/../http/classes/class_administration.php"; require_once dirname(__FILE__) . "/../tools/mod_monitorCapabilities_defineGetMapBbox.php"; require_once dirname(__FILE__) . "/../http/classes/class_bbox.php"; require_once dirname(__FILE__) . "/../http/classes/class_mb_exception.php"; #do db close at the most reasonable point $admin = new administration(); $user = null; $group = null; $application = null; $cl = false; // can be replaced by existing functionality function getConjunctionCharacter($onlineresource) { if (strstr($onlineresource, "?")) { $lastChar = substr($onlineresource, strlen($onlineresource) - 1, 1); if ($lastChar == "?" || $lastChar == "&") { return ""; } else { return "&"; } } else {
# This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2, or (at your option) # any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. include dirname(__FILE__) . "/../php/mb_validateSession.php"; include dirname(__FILE__) . "/../classes/class_administration.php"; $admin = new administration(); $ownwms = $admin->getWmsByWmsOwner($_SESSION["mb_user_id"]); #need admin functions: getWmsLogTag, getWmsPrice, setWmsLogTag, setWmsPrice #can set log only when proxy on, can set price only when log on #read out the request function array2str($array, $pre = '', $pad = '', $sep = ', ') { $str = ''; if (is_array($array)) { if (count($array)) { foreach ($array as $v) { $str .= $pre . $v . $pad . $sep; } $str = substr($str, 0, -strlen($sep)); } } else {
/** * Write catalog object to persistent storage * @param $gui * @return unknown_type */ public function setCatObjToDB($gui) { global $con; $admin = new administration(); //to char_encode XML db_begin(); # INSERT INTO TABLE cat - auto insert cat_id $sql = "INSERT INTO cat( "; $sql .= "cat_version, cat_title, cat_abstract, "; $sql .= "cat_upload_url, fees, accessconstraints, providername, providersite, "; $sql .= "individualname, positionname, voice, facsimile, deliverypoint, "; $sql .= "city, administrativearea, postalcode, country, electronicmailaddress, "; $sql .= "cat_getcapabilities_doc, cat_owner, cat_timestamp) "; $sql .= "VALUES(\$1,\$2,\$3,\$4,\$5,\$6,\$7,\$8,\$9,\$10,\$11,\$12,\$13,\$14,\$15,\$16,\$17,\$18,\$19,\$20,\$21)"; $v = array($this->cat_version, $this->cat_title, $this->cat_abstract, $this->cat_upload_url, $this->fees, $this->accessconstraints, $this->providername, $this->providersite, $this->contactperson, $this->contactposition, $this->contactvoicetelephone, $this->contactfacsimiletelephone, $this->delivery, $this->city, $this->address, $this->postcode, $this->country, $this->contactelectronicmailaddress, $admin->char_encode($this->cat_getcapabilities_doc), $_SESSION['mb_user_id'], strtotime("now")); $t = array('s', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 's', 'i', 'i'); $res = db_prep_query($sql, $v, $t); if (!$res) { db_rollback(); } $cat_insert_id = db_insert_id($con, 'cat', 'cat_id'); //GUI_CAT $sql = "INSERT INTO gui_cat (fkey_gui_id, fkey_cat_id) "; $sql .= "VALUES(\$1,\$2)"; $v = array($gui, $cat_insert_id); $t = array('s', 'i'); $res = db_prep_query($sql, $v, $t); if (!$res) { db_rollback(); } //Insert operational values into cat_op_conf //CAT_OP_CONF foreach ($this->cat_op_values as $op_category => $op_name_array) { foreach ($op_name_array as $op_type => $op_value_array) { foreach ($op_value_array as $op_sub_type => $value) { $op_type_value = $op_type; if ($op_sub_type != 'dflt') { //If not dflt, then it is either soap or xml - store this info as post_xml etc $op_type_value .= '_' . $op_sub_type; } if (!isset($value)) { $value = ''; } //Store values $sql = " INSERT INTO cat_op_conf(fk_cat_id, param_type, param_name, param_value) "; $sql .= " VALUES (\$1, \$2, \$3, \$4)"; $v = array($cat_insert_id, $op_category, $op_type_value, $value); $t = array('i', 's', 's', 's'); $res = db_prep_query($sql, $v, $t); if (!$res) { db_rollback(); } } } } //Commit Changes db_commit(); $this->cat_id = $cat_insert_id; }
var permission = confirm("export: " + document.form1.guiList.options[ind].text + " ?"); if(permission == true){ document.form1.del.value = 1; document.form1.submit(); } } } // --> </script> </head> <body> <?php require_once dirname(__FILE__) . "/../classes/class_administration.php"; require_once dirname(__FILE__) . "/../classes/class_gui.php"; $admin = new administration(); $permguis = $admin->getGuisByPermission(Mapbender::session()->get("mb_user_id"), true); ###export if ($guiList) { $gui = gui::byName($guiList); try { $insert = $gui->toSql(); } catch (Exception $e) { $insert = $e->message; } echo "<textarea rows=40 cols=80>"; echo htmlentities($insert, ENT_QUOTES, CHARSET); echo "</textarea>"; } ### if (!$guiList) {
$admin = new administration(); $req = urldecode($url) . urlencode($admin->char_decode(stripslashes($filter))); $mygml = new gml2(); $mygml->parseFile($req); if (!empty($exportToShape)) { $filenamePrefix = md5(microtime()); $mygml->toShape($filenamePrefix); header("Content-Type: application/json; charset=utf-8"); echo '{"filename": "' . $filenamePrefix . '.zip"}'; } else { header("Content-Type: application/json; charset=utf-8"); echo $mygml->toGeoJSON(); } } else { if ($command == "getFeature") { $admin = new administration(); $wfsGetFeature = $admin->checkURL($wfsGetFeature); $url = $wfsGetFeature . "REQUEST=getFeature&VERSION=1.0.0&SERVICE=WFS&MAXFEATURES=20" . "&typename=" . $wfsFeatureTypeName; //."&propertyname=".$wfsGetFeatureAttr; //"&filter=<ogc:Filter><ogc:Not><ogc:PropertyIsNull><ogc:PropertyName>".$wfsGetFeatureAttr."</ogc:PropertyName></ogc:PropertyIsNull></ogc:Not></ogc:Filter>"; #echo $url; $e = new mb_exception("URL: " . $url); $x = new connector($url); $data = $x->file; //$data = file_get_contents($url); $parser = xml_parser_create(); xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0); xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1); xml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, "UTF-8"); xml_parse_into_struct($parser, $data, $values, $tags); $code = xml_get_error_code($parser);
db_select_db(DB, $con); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="expires" content="0"> <?php echo '<meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '">'; ?> </head> <body> <?php $admin = new administration(); if ($_GET['wmsid']) { $wms_id = intval($_GET['wmsid']); } else { echo "Invalid WMS ID."; die; } $sql = "SELECT upload_id, status, status_comment, timestamp_begin, timestamp_end, upload_url, updated FROM mb_monitor "; $sql .= "WHERE fkey_wms_id = \$1 AND NOT status = '-2' ORDER BY upload_id DESC"; $v = array($wms_id); $t = array('i'); $res = db_prep_query($sql, $v, $t); $cnt = 0; while ($row = db_fetch_array($res)) { $upload_id[$cnt] = db_result($res, $cnt, "upload_id"); $status[$cnt] = intval(db_result($res, $cnt, "status"));
else{ var gui_id=document.form1.guiList.options[listIndex].value; document.form1.action='../php/mod_loadwfs.php?<?php echo $urlParameters; ?> '; document.form1.submit(); } } } </script> </head> <body> <?php $admin = new administration(); $ownguis = $admin->getGuisByOwner(Mapbender::session()->get("mb_user_id"), true); echo count($ownguis) . "<br>"; echo "<form name='form1' action='" . $self . "' method='post'>"; echo "<table cellpadding='0' cellspacing='0' border='0'>"; echo "<tr>"; echo "<td>"; echo "GUI"; echo "<br>"; $gui_id = array(); if (count($ownguis) > 0) { for ($i = 0; $i < count($ownguis); $i++) { $gui_id[$i] = $ownguis[$i]; } } echo "<select size='8' name='guiList' style='width:200px' onClick='submit()'>";