$sql = "INSERT INTO sld_user_layer(fkey_mb_user_id, fkey_layer_id, sld_xml, use_sld, fkey_gui_id) VALUES (\$1, \$2, \$3, 0, \$4);";
$v = array($mb_user_id, $layer_id, $data, $_SESSION["sld_gui_id"]);
$t = array('i', 'i', 's', 's');
$res = @db_prep_query($sql, $v, $t);
//Use the new sld
} else {
$data = db_result($res, 0, "sld_xml");
$use_sld = db_result($res, 0, "use_sld");
}
}
//$file = "sld.xml";
//$data = readSld($file);
$styledlayerdescriptor = parseSld($data);
$_SESSION["sld"] = $data;
/* Check for a related WFS featuretype */
$wfs_conf_id = $dbutils->getLayerWfsConfId($_SESSION["sld_gui_id"], $layer_id);
if ($wfs_conf_id) {
$featuretype_id = $dbutils->getWfsConfFeatureTypeId($wfs_conf_id);
$classWfsConf->getelements($featuretype_id);
$wfs_element = $classWfsConf->elements;
$fts = $styledlayerdescriptor->layers[0]->styles[0]->featuretypestyles[0];
$fts->setElementArray("element_id", $wfs_element->element_id);
$fts->setElementArray("element_name", $wfs_element->element_name);
} else {
$wfs_element = false;
}
/* create getMap-Url for preview with/without sld */
$previewMapUrl = $dbutils->getPreviewMapUrl($_SESSION["sld_gui_id"], $layer_id, $_SESSION["sld_wms_id"]);
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\n";
echo "<html>\n";
echo "<head>\n";
