';
include_once '../include/dyn_css.php';
#Error reporting
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
$con = db_connect(DBSERVER,OWNER,PW);
db_select_db(DB,$con);
$adm = new administration();
?>
"")
{
$update_wms_sql .= ", " . "wms_timestamp = " .
"'".guessTimestamp($_REQUEST['wms_timestamp_box'])."' ";
}
$update_wms_sql .= "WHERE wms_id = '".$_REQUEST['wms_id']."'";
$res_update_wms_sql = db_query($update_wms_sql);
while(list($key,$val) = each($_REQUEST))
{
if(preg_match("/___/", $key))
{
$myKey = explode("___", $key);
$layer_id = str_replace("L_","",$myKey[0]);
if($myKey[1]=="layer_abstract")
{
$layer_sql = "UPDATE layer SET layer_abstract = '$val' " .
"WHERE layer_id = $layer_id AND fkey_wms_id = '".$_REQUEST['wms_id']."'";
$res_keyword_sql = db_query($layer_sql);
}
if($myKey[1]=="layer_keywords")
{
#Get all keywords depending on the given layer after user modification
$keywords = explode(",",$val);
#delete all blanks from the keywords list
for($j = 0; $j < count($keywords); $j++)
{
$word = $keywords[$j];
$word = trim($word);
$keywords[$j] = $word;
}
#echo "1: Keywords eines Layers: id des Layers: ", $layer_id, ", �bergebener String: ", $val, ";
";
#Get all keywords depending on this layer from database
$keyword_sql = "SELECT keyword_id, keyword FROM keyword, layer_keyword, layer " .
"WHERE keyword.keyword_id = layer_keyword.fkey_keyword_id " .
"AND layer_keyword.fkey_layer_id = layer.layer_id " .
"AND layer.fkey_wms_id = '".$_REQUEST['wms_id']."'" .
"AND layer.layer_id = $layer_id";
$res_keyword_sql = db_query($keyword_sql);
while($keyword_row = db_fetch_array($res_keyword_sql))
{
$keyword = $keyword_row['keyword'];
$keyword_id = $keyword_row['keyword_id'];
#keyword has been deleted or has been modified
#keyword exists in database but not in user data
$index = -1;
#echo "1a: Abfrage ob DB Keywords in User Liste: Keyword: ", $keyword, ";
";
if(in_array($keyword, $keywords) == false)
{
#echo "1c: Keyword nicht in User Liste: Keyword: ", $keyword, ";
";
#Deleting reference to the keyword from the layer_keyword table.
$keyword_sql = "DELETE FROM layer_keyword " .
"WHERE fkey_layer_id = $layer_id " .
"AND fkey_keyword_id = $keyword_id";
db_query($keyword_sql);
#Checking, if the keyword is in use by any layer
$layer_sql = "SELECT * FROM layer_keyword " .
"WHERE fkey_keyword_id = $keyword_id";
$res_layer_sql = db_query($layer_sql);
if(!($row = db_fetch_array($res_layer_sql)))
{
#If keyword will not longer be in use, delete it from keyword table
$keyword_sql = "DELETE FROM keyword " .
"WHERE keyword_id = $keyword_id";
db_query($keyword_sql);
}
}
#Keyword exists in the database and in the user data
else
{
#echo "1d: Keyword ist in User Liste: Keyword: ", $keyword, ";
";
for($i = 0; $i < count($keywords); $i++)
{
#Delete keyword from the user data list, because the data
#have not to be updated within the database
if($keywords[$i] == $keyword)
{
$keywords[$i] = null;
}
}
}
}
#Inserting keyword, that are not existing in the database
for($i = 0; $i < count($keywords); $i++)
{
#echo "2: Alle Eintr�ge des Keyword arrays: Keyword: ", $keywords[$i], "; Index: ", $i, ";
";
if($keywords[$i] != null)
{
#echo "3: Eintr�ge ungleich null: Keyword: ", $keywords[$i], "; Index: ", $i, ";";
$keyword = trim($keywords[$i]);
#Check, if the keyword is exsiting in the database
$keyword_sql = "SELECT keyword_id FROM keyword " .
"WHERE UPPER(keyword) = UPPER('$keyword')";
$res_keyword_sql = db_query($keyword_sql);
$keyword_row = db_fetch_array($res_keyword_sql);
#Keyword exists in the database
if($keyword_row != null)
{
$keyword_id = $keyword_row[0];
#echo "4: Keyword in Datenbank vorhanden: id des Keywords: ", $keyword_id, ";
";
}
#Keyword does not exist in the database
else
{
$keyword_sql = "INSERT INTO keyword (keyword) VALUES ('$keyword')";
$res_keyword_sql = db_query($keyword_sql);
$keyword_sql = "SELECT keyword_id FROM keyword WHERE keyword = '$keyword'";
$res_keyword_sql = db_query($keyword_sql);
$keyword_row = db_fetch_array($res_keyword_sql);
if($keyword_row != null)
{
$keyword_id = $keyword_row[0];
#echo "4: Keyword in der Datenbank nicht vorhanden: id des Keywords: ", $keyword_id, ";
";
}
}
#Inserting the reference between layer and keyword in the layer_keyword table
$keyword_sql = "INSERT INTO layer_keyword (fkey_layer_id, fkey_keyword_id) " .
"VALUES ('$layer_id', '$keyword_id')";
$res_keyword_sql = db_query($keyword_sql);
}
}
#Delete all elements from array
unset($keywords);
}
}
}
}
unset($update_content);
#delete preview
if(isset($_REQUEST['delete_preview']) && $_REQUEST['delete_preview']=='1'
&& isset($_REQUEST['layer_id']))
{
$preview_sql = "DELETE FROM layer_preview WHERE fkey_layer_id = ".$_REQUEST['layer_id']."";
$res_preview_sql = db_query($preview_sql);
die("Preview has been deleted!