Subversion Repositories Transart

Compare Revisions

Ignore whitespace Rev 1 → Rev 2

/admin/benutzer_bearbeiten.php
0,0 → 1,86
<?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?php
//Cachen verhindern 2323
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
$colname_benutzer = "-1";
if (isset($_GET['search'])) {
$colname_benutzer = $_GET['search'];
}
mysql_select_db($database_Transart, $Transart);
$query_benutzer = sprintf("SELECT * FROM benutzer WHERE benutzer_nachname LIKE %s ORDER BY $_GET[sorter] ASC", GetSQLValueString("%" . $colname_benutzer . "%", "text"));
$benutzer = mysql_query($query_benutzer, $Transart) or die(mysql_error());
$row_benutzer = mysql_fetch_assoc($benutzer);
$totalRows_benutzer = mysql_num_rows($benutzer);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<span class="stil1"><?php echo $totalRows_benutzer ?> Einträge</span>
<?php if ($totalRows_benutzer > 0) { // Show if recordset not empty ?>
<table width="400" border="0" cellpadding="2" cellspacing="2" class="tabelle1">
<?php do { ?>
<tr>
<td class="stil12"><a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('benutzer_bearbeiten_detail.php?benutzer_id=<?php echo $row_benutzer['benutzer_id'];?>','data');getData('benutzer_bearbeiten_detail_optionen.php','optionen')"><?php echo $row_benutzer['benutzer_nachname']; ?></a></td>
<td class="stil1"><?php echo $row_benutzer['benutzer_vorname']; ?></td>
</tr>
<?php } while ($row_benutzer = mysql_fetch_assoc($benutzer)); ?>
</table>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_benutzer == 0) { // Show if recordset empty ?>
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Suche nach.......</td>
</tr>
</table>
<?php } // Show if recordset empty ?>
</body>
</html>
<?php
mysql_free_result($benutzer);
?>
/admin/benutzer_bearbeiten_detail.php
0,0 → 1,182
<?
session_start();
?>
<?
//include("session_seite_include.php");
?>
<?
include("../main/session_status_include.php");
?>
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST['benutzer_id'])) && ($_POST['benutzer_id'] != "") && (isset($_POST['delete']))) {
$deleteSQL = sprintf("DELETE FROM benutzer WHERE benutzer_id=%s",
GetSQLValueString($_POST['benutzer_id'], "int"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($deleteSQL, $Transart) or die(mysql_error());
 
$deleteGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}
 
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE benutzer SET benutzer_vorname=%s, benutzer_nachname=%s, benutzer_telefon=%s, benutzer_email=%s, benutzer_level=%s, benutzer_login=%s, benutzer_passwort=%s WHERE benutzer_id=%s",
GetSQLValueString($_POST['benutzer_vorname'], "text"),
GetSQLValueString($_POST['benutzer_nachname'], "text"),
GetSQLValueString($_POST['benutzer_telefon'], "text"),
GetSQLValueString($_POST['benutzer_email'], "text"),
GetSQLValueString($_POST['benutzer_level'], "int"),
GetSQLValueString($_POST['benutzer_login'], "text"),
GetSQLValueString(md5($_POST['benutzer_passwort']), "text"),
GetSQLValueString($_POST['benutzer_id'], "int"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($updateSQL, $Transart) or die(mysql_error());
 
$updateGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
 
$colname_benutzer = "-1";
if (isset($_GET['benutzer_id'])) {
$colname_benutzer = $_GET['benutzer_id'];
}
mysql_select_db($database_Transart, $Transart);
$query_benutzer = sprintf("SELECT * FROM benutzer WHERE benutzer_id = %s", GetSQLValueString($colname_benutzer, "int"));
$benutzer = mysql_query($query_benutzer, $Transart) or die(mysql_error());
$row_benutzer = mysql_fetch_assoc($benutzer);
$totalRows_benutzer = mysql_num_rows($benutzer);
 
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form action="<?php echo $editFormAction; ?>" id="form1" name="form1" method="POST">
<table width="400" class="tabelle1">
<tr>
<td class="stil11">Vorname</td>
<td class="stil1"><label>
<input name="benutzer_vorname" type="text" class="stil2" id="benutzer_vorname" value="<?php echo $row_benutzer['benutzer_vorname']; ?>" />
</label></td>
</tr>
<tr>
<td class="stil11">Nachname</td>
<td class="stil1"><input name="benutzer_nachname" type="text" class="stil2" id="benutzer_nachname" value="<?php echo $row_benutzer['benutzer_nachname']; ?>" /></td>
</tr>
<tr>
<td class="stil11">Telefon</td>
<td class="stil1"><input name="benutzer_telefon" type="text" class="stil2" id="benutzer_telefon" value="<?php echo $row_benutzer['benutzer_telefon']; ?>" /></td>
</tr>
<tr>
<td class="stil11">Email</td>
<td class="stil1"><input name="benutzer_email" type="text" class="stil2" id="benutzer_email" value="<?php echo $row_benutzer['benutzer_email']; ?>" /></td>
</tr>
<tr>
<td class="stil11">Level</td>
<td class="stil1"><select name="benutzer_level" class="stil2" id="benutzer_level">
<option value="1" <?php if (!(strcmp(1, $row_benutzer['benutzer_level']))) {echo "selected=\"selected\"";} ?>>Benutzer</option>
<option value="2" <?php if (!(strcmp(2, $row_benutzer['benutzer_level']))) {echo "selected=\"selected\"";} ?>>Globaler Administrator</option>
<option value="3" <?php if (!(strcmp(3, $row_benutzer['benutzer_level']))) {echo "selected=\"selected\"";} ?>>Poweruser Offerte</option>
<option value="4" <?php if (!(strcmp(4, $row_benutzer['benutzer_level']))) {echo "selected=\"selected\"";} ?>>Poweruser Auswertungen</option>
<option value="5" <?php if (!(strcmp(5, $row_benutzer['benutzer_level']))) {echo "selected=\"selected\"";} ?>>Poweruser Offerte/Auswertungen</option>
</select></td>
</tr>
<tr>
<td class="stil11">Login</td>
<td class="stil1">
<input name="benutzer_login" type="hidden" id="benutzer_login" value="<?php echo $row_benutzer['benutzer_login']; ?>" /></td>
</tr>
<tr>
<td class="stil11">Passwort</td>
<td class="stil1"><input name="benutzer_passwort" type="password" class="stil2" id="benutzer_passwort" value="<?php echo $row_benutzer['benutzer_passwort']; ?>" /></td>
</tr>
<tr>
<td class="stil11">Benutzer löschen?</td>
<td class="stil1">
<?
$in_use = mysql_fetch_object(mysql_query("SELECT projekte_id FROM projekte WHERE projekte_sachbearbeiter = '$row_benutzer[benutzer_login]'"));
if (!$in_use->projekte_id){
?>
<label>
<input name="delete" type="checkbox" class="stil2" id="delete" value="1" onCLick="if(this.checked==true)status_alert(4);if(this.checked==false)status_alert(1)" />
</label>
<?
}
?>
</td>
</tr>
<tr>
<td class="stil11"><input name="benutzer_id" type="hidden" id="benutzer_id" value="<?php echo $row_benutzer['benutzer_id'];?>" /></td>
<td class="stil1"><label>
<input name="button" type="submit" class="stil2" id="button" value="Updaten" />
</label></td>
</tr>
<tr>
<td class="stil11">&nbsp;</td>
<td class="stil1"><label></label></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1" />
</form>
</body>
</html>
<?php
mysql_free_result($benutzer);
?>
/admin/benutzer_bearbeiten_detail_optionen.php
0,0 → 1,26
<?
session_start();
?>
<?
//include("session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
Benutzer bearbeiten
</body>
</html>
/admin/benutzer_bearbeiten_optionen.php
0,0 → 1,43
<?
session_start();
?>
<?
include("../main/session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form id="form1" name="form1" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">Suche</div></td>
<td><input name="search" type="text" class="optionen_box" id="search" onblur ="var search = encodeURI(this.value);getData('benutzer_bearbeiten.php?search='+search+'&sorter='+document.form1.sorter.value,'data');" />
<input type="image" name="imageField" id="imageField" src="../img/button01.png" onfocus = "document.form1.search.focus()"/></td>
<td>Sortieren</td>
<td><label>
<input name="radio" type="radio" id="radio1" value="benutzer_nachname" checked="checked" onCLick="if(this.checked) {document.form1.sorter.value = this.value;var search = encodeURI(document.form1.search.value);getData('benutzer_bearbeiten.php?search='+search+'&sorter='+document.form1.sorter.value,'data');}" />
Nachname
<input type="radio" name="radio" id="radio2" value="benutzer_vorname" onCLick="if(this.checked) {document.form1.sorter.value = this.value;var search = encodeURI(document.form1.search.value);getData('benutzer_bearbeiten.php?search='+search+'&sorter='+document.form1.sorter.value,'data');}"/>
Vorname
<input name="sorter" type="hidden" id="sorter" value="benutzer_nachname" />
</label></td>
</tr>
</table>
</form>
</body>
</html>
/admin/benutzer_neu.php
0,0 → 1,135
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "benutzer_neu")) {
$insertSQL = sprintf("INSERT INTO benutzer (benutzer_vorname, benutzer_nachname, benutzer_telefon, benutzer_email, benutzer_level, benutzer_login, benutzer_passwort) VALUES (%s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['benutzer_vorname'], "text"),
GetSQLValueString($_POST['benutzer_nachname'], "text"),
GetSQLValueString($_POST['benutzer_telefon'], "text"),
GetSQLValueString($_POST['benutzer_email'], "text"),
GetSQLValueString($_POST['benutzer_level'], "int"),
GetSQLValueString($_POST['benutzer_login'], "text"),
GetSQLValueString(md5($_POST['benutzer_passwort']), "text"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($insertSQL, $Transart) or die(mysql_error());
 
$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?>
<?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?
include("../main/session_status_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form action="<?php echo $editFormAction; ?>" id="benutzer_neu" name="benutzer_neu" method="POST">
<table width="400" cellpadding="2" cellspacing="2" class="tabelle1">
<tr>
<td class="stil11">Vorname</td>
<td class="stil1"><label>
<input name="benutzer_vorname" type="text" class="stil2" id="benutzer_vorname" />
</label></td>
</tr>
<tr>
<td class="stil11">Nachname</td>
<td class="stil1"><input name="benutzer_nachname" type="text" class="stil2" id="benutzer_nachname" /></td>
</tr>
<tr>
<td class="stil11">Telefon</td>
<td class="stil1"><input name="benutzer_telefon" type="text" class="stil2" id="benutzer_telefon" /></td>
</tr>
<tr>
<td class="stil11">Email</td>
<td class="stil1"><input name="benutzer_email" type="text" class="stil2" id="benutzer_email" /></td>
</tr>
<tr>
<td class="stil11">Level</td>
<td class="stil1"><label>
<select name="benutzer_level" class="stil2" id="benutzer_level">
<option value="1">Benutzer</option>
<option value="2">Globaler Administrator</option>
<option value="3">Poweruser Offerte</option>
<option value="4">Poweruser Auswertungen</option>
<option value="5">Poweruser Offerte/Auswertungen</option>
</select>
</label></td>
</tr>
<tr>
<td class="stil11">Login</td>
<td class="stil1"><input name="benutzer_login" type="text" class="stil2" id="benutzer_login" /></td>
</tr>
<tr>
<td class="stil11">Passwort</td>
<td class="stil1"><input name="benutzer_passwort" type="password" class="stil2" id="benutzer_passwort" /></td>
</tr>
<tr>
<td class="stil11">&nbsp;</td>
<td class="stil1"><label>
<input name="button" type="submit" class="stil2" id="button" value="Anlegen" />
</label></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="benutzer_neu" />
</form>
</body>
</html>
/admin/benutzer_neu_optionen.php
0,0 → 1,26
<?
session_start();
?>
<?
include("../main/session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
Neuer Benutzer
</body>
</html>
/admin/index.php
0,0 → 1,113
<?
session_start();
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<?
//if ($_SESSION['MM_Username']=="GeorgBreidler"){
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ADMIN</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
<script src="../scripts/SpryEffects.js" type="text/javascript" ></script>
<script type="text/javascript" src="../scripts/ajax.js"></script>
<script type="text/javascript" src="../scripts/scripts.js"></script>
<script type="text/javascript" src="../scripts/jquery.js"></script>
<script type="text/javascript" src="../scripts/jquery.autosize.js"></script>
<script type="text/javascript" src="../scripts/jquery-ui/ui/jquery-ui.js"></script>
<script src="../SpryAssets/SpryTabbedPanels.js" type="text/javascript"></script>
<link href="../SpryAssets/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
</head>
<?
//////Wenn eine Seitenanfrage kommt, diese laden
if ($_SESSION['seite']) {
?>
<body onload="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('<? echo $_SESSION['seite']; ?>','data');getData('<? echo $_SESSION['optionen']; ?>','optionen');TabbedPanels1.showPanel('<? echo $_SESSION['menue']; ?>');">
<?
}
else {
?>
 
<body>
 
<?
}
/////// Ende LAden
?>
<table class="master_tabelle">
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0">
<tr>
<td><div id="TabbedPanels1" class="TabbedPanels">
<ul class="TabbedPanelsTabGroup">
<li class="TabbedPanelsTab01" tabindex="0" id="admin_benutzer">Benutzer</li>
<li class="TabbedPanelsTab01" tabindex="0" id="admin_standort">Standort</li>
<li class="TabbedPanelsTab01" tabindex="0">Kundenimport</li>
<li class="TabbedPanelsTab01" tabindex="0">Projektverwaltung</li>
<li class="TabbedPanelsTab01" tabindex="0">Allgemein</li>
</ul>
<div class="TabbedPanelsContentGroup">
<div class="TabbedPanelsContent"> <a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('benutzer_neu.php','data');getData('benutzer_neu_optionen.php','optionen')">Neu</a> | <a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false});getData('benutzer_bearbeiten.php?sorter=benutzer_nachname','data');getData('benutzer_bearbeiten_optionen.php','optionen')">Bearbeiten</a></div>
<div class="TabbedPanelsContent"><a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('standort_neu.php','data');getData('standort_neu_optionen.php','optionen')">Neu</a> | <a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false});getData('standort_bearbeiten.php?sorter=standort_name','data');getData('standort_bearbeiten_optionen.php','optionen')">Bearbeiten</a></div>
<div class="TabbedPanelsContent"><a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('kunden_sync.php','data');getData('kunden_sync_optionen.php','optionen')">Synchronisierung BH</a></div>
<div class="TabbedPanelsContent"><a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('projekte_bearbeiten.php','data');getData('projekte_bearbeiten_optionen.php','optionen')">Projekt bearbeiten</a></div>
<div class="TabbedPanelsContent">Inhalt 2</div>
</div>
</div></td>
</tr>
<tr>
<td><div class="optionen" id="optionen">Raum für den Inhalt von id "optionen"</div></td>
</tr>
<tr>
<td><div class="div1" id="data">Raum für den Inhalt von id "data"</div></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div class="status" id="status">Letzte Aktion: <? echo $_SESSION['status']; ?></div></td>
<td><div class="status" id="lader_status">Raum für den Inhalt von id &quot;lader_status&quot;</div></td>
</tr>
</table></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td><?
echo $_SESSION['seite'];
?> &nbsp;</td>
</tr>
<tr>
<td>
<?
echo $_SESSION['optionen'];
?>
&nbsp;</td>
</tr>
</table> </td>
</tr>
</table>
 
<script type="text/javascript">
<!--
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
//-->
</script>
</body>
</html>
<?
//}
?>
/admin/kunden_sync.php
0,0 → 1,127
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
mysql_select_db($database_Transart, $Transart);
$query_kunden_import = "SELECT * FROM kunden_import ORDER BY kunden_import_kundennummer ASC";
$kunden_import = mysql_query($query_kunden_import, $Transart) or die(mysql_error());
$row_kunden_import = mysql_fetch_assoc($kunden_import);
$totalRows_kunden_import = mysql_num_rows($kunden_import);
?>
<?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?
include("../main/session_status_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<?
do {
$kunden_exist = mysql_fetch_object(mysql_query("SELECT kunden_kundennummer from kunden WHERE kunden_kundennummer = '$row_kunden_import[kunden_import_kundennummer]'"));
if ($kunden_exist->kunden_kundennummer) {
echo "Kunde existiert bereits! Update der Einträge</br>";
///// Update Tel, Fax, UID, etc
$row_kunden_import['kunden_import_name'] = utf8_encode(addslashes($row_kunden_import['kunden_import_name']));
$row_kunden_import['kunden_import_adresse'] = utf8_encode(addslashes($row_kunden_import['kunden_import_adresse']));
$row_kunden_import['kunden_import_plz'] = utf8_encode(addslashes($row_kunden_import['kunden_import_plz']));
$row_kunden_import['kunden_import_ort'] = utf8_encode(addslashes($row_kunden_import['kunden_import_ort']));
$row_kunden_import['kunden_import_telefon'] = utf8_encode(addslashes($row_kunden_import['kunden_import_telefon']));
$row_kunden_import['kunden_import_fax'] = utf8_encode(addslashes($row_kunden_import['kunden_import_fax']));
$row_kunden_import['kunden_import_email'] = utf8_encode(addslashes($row_kunden_import['kunden_import_email']));
$row_kunden_import['kunden_import_uid'] = utf8_encode(addslashes($row_kunden_import['kunden_import_uid']));
mysql_select_db($database_Transart, $Transart);
$data_update = "UPDATE kunden SET
kunden_name = '$row_kunden_import[kunden_import_name]',
kunden_adresse = '$row_kunden_import[kunden_import_adresse]',
kunden_plz = '$row_kunden_import[kunden_import_plz]',
kunden_ort = '$row_kunden_import[kunden_import_ort]',
kunden_land = '$row_kunden_import[kunden_import_land]',
kunden_telefon = '$row_kunden_import[kunden_import_telefon]',
kunden_fax = '$row_kunden_import[kunden_import_fax]',
kunden_email = '$row_kunden_import[kunden_import_email]',
kunden_uid = '$row_kunden_import[kunden_import_uid]'
WHERE kunden_kundennummer = '$row_kunden_import[kunden_import_kundennummer]'";
$data_update_sql = mysql_query($data_update) OR die(mysql_error());
///
}
else {
echo "Neuer Kunde! </br>";
$row_kunden_import['kunden_import_name'] = utf8_encode(addslashes($row_kunden_import['kunden_import_name']));
$row_kunden_import['kunden_import_adresse'] = utf8_encode(addslashes($row_kunden_import['kunden_import_adresse']));
$row_kunden_import['kunden_import_plz'] = utf8_encode(addslashes($row_kunden_import['kunden_import_plz']));
$row_kunden_import['kunden_import_ort'] = utf8_encode(addslashes($row_kunden_import['kunden_import_ort']));
$kunden_insert = "INSERT INTO kunden (kunden_kundennummer, kunden_name, kunden_adresse, kunden_plz, kunden_ort, kunden_land, kunden_telefon, kunden_fax, kunden_email, kunden_uid, kunden_konto, kunden_blz, kunden_bic, kunden_swift)
VALUES
(
'$row_kunden_import[kunden_import_kundennummer]',
'$row_kunden_import[kunden_import_name]',
'$row_kunden_import[kunden_import_adresse]',
'$row_kunden_import[kunden_import_plz]',
'$row_kunden_import[kunden_import_ort]',
'$row_kunden_import[kunden_import_land]',
'$row_kunden_import[kunden_import_telefon]',
'$row_kunden_import[kunden_import_fax]',
'$row_kunden_import[kunden_import_email]',
'$row_kunden_import[kunden_import_uid]',
'-',
'0',
'-',
'-')";
$kunden_insert_sql = mysql_query($kunden_insert) OR die(mysql_error());
}
} while ($row_kunden_import = mysql_fetch_assoc($kunden_import));
?>
</body>
</html>
<?php
mysql_free_result($kunden_import);
?>
/admin/kunden_sync_optionen.php
0,0 → 1,26
<?
session_start();
?>
<?
include("../main/session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
Kunden Sync
</body>
</html>
/admin/projekte_bearbeiten.php
0,0 → 1,94
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
mysql_select_db($database_Transart, $Transart);
$query_projekte = "SELECT projekte.*,auftraggeber.kunden_name AS auftraggeber,rechnungsempfaenger.kunden_name AS rechnungsempfaenger FROM `projekte` LEFT JOIN `kunden` AS auftraggeber ON (projekte.projekte_auftraggeber_id=auftraggeber.kunden_id) LEFT JOIN `kunden` AS rechnungsempfaenger ON (projekte.projekte_rechnungsempfaenger_id=rechnungsempfaenger.kunden_id) ORDER BY projekte_projektnummer ASC";
$projekte = mysql_query($query_projekte, $Transart) or die(mysql_error());
$row_projekte = mysql_fetch_assoc($projekte);
$totalRows_projekte = mysql_num_rows($projekte);
?>
<?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<span class="stil1"> Einträge</span>
<table width="800" border="0" cellpadding="2" cellspacing="2" class="tabelle1">
<?php do { ?>
<tr>
<td class="stil12">&nbsp;</td>
<td class="stil12">&nbsp;</td>
<td class="stil1">&nbsp;</td>
<td class="stil1">&nbsp;</td>
<td class="stil1">&nbsp;</td>
<td class="stil1"></td>
<td class="stil1">&nbsp;</td>
</tr>
<tr>
<td class="stil12"><?php echo $row_projekte['projekte_id']; ?></td>
<td class="stil12"><a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('projekte_bearbeiten_detail.php?projekte_id=<?php echo $row_projekte['projekte_id']; ?>','data')"><?php echo $row_projekte['projekte_projektnummer']; ?></a></td>
<td class="stil1"><?php echo $row_projekte['projekte_name']; ?></td>
<td class="stil1"><?php echo $row_projekte['auftraggeber']; ?></td>
<td class="stil1"><?php echo $row_projekte['rechnungsempfaenger']; ?></td>
<td class="stil1"></td>
<td class="stil1"><a href="<? //echo "projekte_bearbeiten_detail.php?delete=true&jump_to=projekte_bearbeiten.php&projekte_id=$row_projekte[projekte_id]";?>" onclick="return datei_loeschen_chkFormular('<? echo $row_projekte['projekte_id']; ?>')"><img src="../img/status/83.png" alt="LÖSCHEN" width="16" height="16" border="0" /></a></td>
</tr>
<?php } while ($row_projekte = mysql_fetch_assoc($projekte)); ?>
</table>
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Suche nach.......</td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($projekte);
?>
/admin/projekte_bearbeiten_detail.php
0,0 → 1,172
<?php require_once('../Connections/Transart.php'); ?>
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
if ((isset($_GET['projekte_id'])) && ($_GET['projekte_id'] != "") && (isset($_GET['delete']))) {
$deleteSQL = sprintf("DELETE
projekte.*,
arbeitsscheine.*,
arbeitsscheine_objekte.*,
arbeitsscheine_packliste.*,
fakturen.*,
fakturen_data.*,
fakturen_data_positionen.*,
fakturen_data_textbausteine.*,
offerte.*,
offerte_data.*,
offerte_data_positionen.*,
offerte_data_textbausteine.*,
proformarechnungen.*,
projekte_dateien.*,
projekte_kalkulation.*,
projekte_objektliste.*,
shipping.*,
shipping_objekte.*,
shipping_packliste.*,
verpackungen_auftraege.*,
verpackungen_auftraege_data.*,
verpackungen_auftraege_data_objekte.*
FROM projekte
LEFT JOIN arbeitsscheine ON (projekte.projekte_id = arbeitsscheine.projekte_id)
LEFT JOIN arbeitsscheine_objekte ON (arbeitsscheine.arbeitsscheine_id = arbeitsscheine_objekte.arbeitsscheine_id)
LEFT JOIN arbeitsscheine_packliste ON (arbeitsscheine.arbeitsscheine_id = arbeitsscheine_packliste.arbeitsscheine_id)
LEFT JOIN fakturen ON (projekte.projekte_id = fakturen.projekte_id)
LEFT JOIN fakturen_data ON (fakturen.fakturen_id = fakturen_data.fakturen_id)
LEFT JOIN fakturen_data_positionen ON (fakturen_data.fakturen_data_positionen_id = fakturen_data_positionen.fakturen_data_positionen_id)
LEFT JOIN fakturen_data_textbausteine ON (fakturen_data.fakturen_data_textbausteine_id = fakturen_data_textbausteine.fakturen_data_textbausteine_id)
LEFT JOIN offerte ON (projekte.projekte_id = offerte.projekte_id)
LEFT JOIN offerte_data ON (offerte.offerte_id = offerte_data.offerte_id)
LEFT JOIN offerte_data_positionen ON (offerte_data.offerte_data_positionen_id = offerte_data_positionen.offerte_data_positionen_id)
LEFT JOIN offerte_data_textbausteine ON (offerte_data.offerte_data_textbausteine_id = offerte_data_textbausteine.offerte_data_textbausteine_id)
LEFT JOIN proformarechnungen ON (projekte.projekte_id = proformarechnungen.projekte_id)
LEFT JOIN projekte_dateien ON (projekte.projekte_id = projekte_dateien.projekte_id)
LEFT JOIN projekte_kalkulation ON (projekte.projekte_id = projekte_kalkulation.projekte_id)
LEFT JOIN projekte_objektliste ON (projekte.projekte_id = projekte_objektliste.projekte_id)
LEFT JOIN shipping ON (projekte.projekte_id = shipping.projekte_id)
LEFT JOIN shipping_objekte ON (shipping.shipping_id = shipping_objekte.shipping_id)
LEFT JOIN shipping_packliste ON (shipping.shipping_id = shipping_packliste.shipping_id)
LEFT JOIN verpackungen_auftraege ON (projekte.projekte_id = verpackungen_auftraege.projekte_id)
LEFT JOIN verpackungen_auftraege_data ON (verpackungen_auftraege.verpackungen_auftraege_id = verpackungen_auftraege_data.verpackungen_auftraege_id)
LEFT JOIN verpackungen_auftraege_data_objekte ON (verpackungen_auftraege_data.verpackungen_auftraege_data_id = verpackungen_auftraege_data_objekte.verpackungen_auftraege_data_id)
WHERE projekte.projekte_id=%s",
GetSQLValueString($_GET['projekte_id'], "int"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($deleteSQL, $Transart) or die(mysql_error());
$deleteGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}
 
mysql_select_db($database_Transart, $Transart);
$query_projekte = "SELECT projekte.*,auftraggeber.kunden_name AS auftraggeber,rechnungsempfaenger.kunden_name AS rechnungsempfaenger FROM `projekte` LEFT JOIN `kunden` AS auftraggeber ON (projekte.projekte_auftraggeber_id=auftraggeber.kunden_id) LEFT JOIN `kunden` AS rechnungsempfaenger ON (projekte.projekte_rechnungsempfaenger_id=rechnungsempfaenger.kunden_id) WHERE projekte_id = '$_GET[projekte_id]'";
$projekte = mysql_query($query_projekte, $Transart) or die(mysql_error());
$row_projekte = mysql_fetch_assoc($projekte);
$totalRows_projekte = mysql_num_rows($projekte);
?>
<?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<table width="800" border="0" cellpadding="2" cellspacing="2" class="tabelle1">
<tr>
<td class="stil12"><a href="javascript:void(0)" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('projekte_bearbeiten_detail.php?projekte_id=<?php echo $row_projekte['projekte_id']; ?>','data')"><?php echo $row_projekte['projekte_projektnummer']; ?></a></td>
<td class="stil1"><?php echo $row_projekte['auftraggeber']; ?></td>
<td class="stil1"><?php echo $row_projekte['rechnungsempfaenger']; ?></td>
<td class="stil1"><a href="<? echo "$_SERVER[PHP_SELF]?delete=true&jump_to=projekte_bearbeiten.php&projekte_id=$row_projekte[projekte_id]";?>" onClick="return datei_loeschen_chkFormular('<? echo $row_projekte['projekte_id']; ?>')"><img src="../img/status/83.png" alt="LÖSCHEN" width="16" height="16" border="0" /></a></td>
<td class="stil1"></td>
</tr>
</table>
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Suche nach.......</td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($projekte);
?>
/admin/projekte_bearbeiten_optionen.php
0,0 → 1,26
<?
session_start();
?>
<?
include("../main/session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
Projekte bearbeiten
</body>
</html>
/admin/standort_bearbeiten.php
0,0 → 1,86
<?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
$colname_standort = "-1";
if (isset($_GET['search'])) {
$colname_standort = $_GET['search'];
}
mysql_select_db($database_Transart, $Transart);
$query_standort = sprintf("SELECT * FROM standort WHERE standort_name LIKE %s ORDER BY $_GET[sorter] ASC", GetSQLValueString("%" . $colname_standort . "%", "text"));
$standort = mysql_query($query_standort, $Transart) or die(mysql_error());
$row_standort = mysql_fetch_assoc($standort);
$totalRows_standort = mysql_num_rows($standort);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<span class="stil1"><?php echo $totalRows_standort ?> Einträge</span>
<?php if ($totalRows_standort > 0) { // Show if recordset not empty ?>
<table width="400" border="0" cellpadding="2" cellspacing="2">
<?php do { ?>
<tr>
<td class="stil1"><a href="javascript:void(0)" class="stil12" onclick="Spry.Effect.DoFade('data', {duration:500,from:0,to:100,toggle:false}); getData('standort_bearbeiten_detail.php?standort_id=<?php echo $row_standort['standort_id'];?>','data');getData('standort_bearbeiten_detail_optionen.php','optionen')"><?php echo $row_standort['standort_name']; ?></a></td>
<td class="stil1"><?php echo $row_standort['standort_name']; ?></td>
</tr>
<?php } while ($row_standort = mysql_fetch_assoc($standort)); ?>
</table>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_standort == 0) { // Show if recordset empty ?>
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Suche nach.......</td>
</tr>
</table>
<?php } // Show if recordset empty ?>
</body>
</html>
<?php
mysql_free_result($standort);
?>
/admin/standort_bearbeiten_detail.php
0,0 → 1,366
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "standort_update")) {
$updateSQL = sprintf("UPDATE standort SET standort_name=%s, standort_adresse=%s, standort_plz=%s, standort_ort=%s, standort_land=%s, standort_telefon=%s, standort_fax=%s, standort_email=%s, standort_uid=%s WHERE standort_id=%s",
GetSQLValueString($_POST['standort_name'], "text"),
GetSQLValueString($_POST['standort_adresse'], "text"),
GetSQLValueString($_POST['standort_plz'], "int"),
GetSQLValueString($_POST['standort_ort'], "text"),
GetSQLValueString($_POST['standort_land'], "text"),
GetSQLValueString($_POST['standort_telefon'], "text"),
GetSQLValueString($_POST['standort_fax'], "text"),
GetSQLValueString($_POST['standort_email'], "text"),
GetSQLValueString($_POST['standort_uid'], "text"),
GetSQLValueString($_POST['standort_id'], "int"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($updateSQL, $Transart) or die(mysql_error());
 
$updateGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
 
if ((isset($_POST['standort_id'])) && ($_POST['standort_id'] != "") && (isset($_POST['delete']))) {
$deleteSQL = sprintf("DELETE FROM standort WHERE standort_id=%s",
GetSQLValueString($_POST['standort_id'], "int"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($deleteSQL, $Transart) or die(mysql_error());
 
$deleteGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
$deleteGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $deleteGoTo));
}
 
$colname_standort = "-1";
if (isset($_GET['standort_id'])) {
$colname_standort = $_GET['standort_id'];
}
mysql_select_db($database_Transart, $Transart);
$query_standort = sprintf("SELECT * FROM standort WHERE standort_id = %s", GetSQLValueString($colname_standort, "int"));
$standort = mysql_query($query_standort, $Transart) or die(mysql_error());
$row_standort = mysql_fetch_assoc($standort);
$totalRows_standort = mysql_num_rows($standort);
?><?
session_start();
?>
<?
//include("session_seite_include.php");
?>
<?
include("../main/session_status_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form action="<?php echo $editFormAction; ?>" id="standort_update" name="standort_update" method="POST">
<table width="400" class="tabelle1">
<tr>
<td class="stil1">Name</td>
<td class="stil1"><label>
<input name="standort_name" type="text" class="stil2" id="standort_name" value="<?php echo $row_standort['standort_name']; ?>" />
</label></td>
</tr>
<tr>
<td class="stil1">Adresse</td>
<td class="stil1"><input name="standort_adresse" type="text" class="stil2" id="standort_adresse" value="<?php echo $row_standort['standort_adresse']; ?>" /></td>
</tr>
<tr>
<td class="stil1">PLZ</td>
<td class="stil1"><label>
<input name="standort_plz" type="text" class="stil2" id="standort_plz" value="<?php echo $row_standort['standort_plz']; ?>" />
</label></td>
</tr>
<tr>
<td class="stil1">Ort</td>
<td class="stil1"><input name="standort_ort" type="text" class="stil2" id="standort_ort" value="<?php echo $row_standort['standort_ort']; ?>" /></td>
</tr>
<tr>
<td class="stil1">Land</td>
<td class="stil1"><select name="standort_land" class="stil2" id="standort_land">
<option value="A" <?php if (!(strcmp("A", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Österreich</option>
<option value="D" <?php if (!(strcmp("D", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Deutschland</option>
<option value="CH" <?php if (!(strcmp("CH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Schweiz</option>
<option value="AFG" <?php if (!(strcmp("AFG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Afghanistan</option>
<option value="ET" <?php if (!(strcmp("ET", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Ägypten</option>
<option value="AL" <?php if (!(strcmp("AL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Albanien</option>
<option value="GBA" <?php if (!(strcmp("GBA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Alderney</option>
<option value="DZ" <?php if (!(strcmp("DZ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Algerien</option>
<option value="AND" <?php if (!(strcmp("AND", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Andorra</option>
<option value="AN" <?php if (!(strcmp("AN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Angola</option>
<option value="AQ" <?php if (!(strcmp("AQ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Anquilla</option>
<option value="ANT" <?php if (!(strcmp("ANT", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Antigua</option>
<option value="RA" <?php if (!(strcmp("RA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Argentinien</option>
<option value="ETH" <?php if (!(strcmp("ETH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Äthiopien</option>
<option value="AUS" <?php if (!(strcmp("AUS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Australien</option>
<option value="BS" <?php if (!(strcmp("BS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bahamas</option>
<option value="BRN" <?php if (!(strcmp("BRN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bahrain</option>
<option value="BD" <?php if (!(strcmp("BD", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bangladesch</option>
<option value="BDS" <?php if (!(strcmp("BDS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Barbados</option>
<option value="BY" <?php if (!(strcmp("BY", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Belarus (Weißrussland)</option>
<option value="B" <?php if (!(strcmp("B", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Belgien</option>
<option value="RPB" <?php if (!(strcmp("RPB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Benin</option>
<option value="BT" <?php if (!(strcmp("BT", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bhutan</option>
<option value="BUR" <?php if (!(strcmp("BUR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Birma</option>
<option value="BOL" <?php if (!(strcmp("BOL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bolivien</option>
<option value="BA" <?php if (!(strcmp("BA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bosnien-Herzegovina</option>
<option value="RB" <?php if (!(strcmp("RB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Botsuana</option>
<option value="BR" <?php if (!(strcmp("BR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Brasilien</option>
<option value="BRU" <?php if (!(strcmp("BRU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Brunei</option>
<option value="BG" <?php if (!(strcmp("BG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Bulgarien</option>
<option value="HV" <?php if (!(strcmp("HV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Burkina Faso</option>
<option value="BU" <?php if (!(strcmp("BU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Burundi</option>
<option value="GY" <?php if (!(strcmp("GY", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Chanal Islands</option>
<option value="RCH" <?php if (!(strcmp("RCH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Chile</option>
<option value="TJ" <?php if (!(strcmp("TJ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Chin. Volksrepublik</option>
<option value="CR" <?php if (!(strcmp("CR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Costa Rica</option>
<option value="DK" <?php if (!(strcmp("DK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Dänemark</option>
<option value="D" <?php if (!(strcmp("D", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Deutschland</option>
<option value="DJ" <?php if (!(strcmp("DJ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Djibouti</option>
<option value="WD" <?php if (!(strcmp("WD", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Dominica</option>
<option value="DOM" <?php if (!(strcmp("DOM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Dominikanische Rep.</option>
<option value="EC" <?php if (!(strcmp("EC", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Ecuador</option>
<option value="ES" <?php if (!(strcmp("ES", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>El Salvador</option>
<option value="CI" <?php if (!(strcmp("CI", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Elfenbeinküste</option>
<option value="EW" <?php if (!(strcmp("EW", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Estland</option>
<option value="FJI" <?php if (!(strcmp("FJI", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Fidschi</option>
<option value="SF" <?php if (!(strcmp("SF", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Finnland</option>
<option value="F" <?php if (!(strcmp("F", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Frankreich</option>
<option value="GA" <?php if (!(strcmp("GA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Gabun</option>
<option value="WAG" <?php if (!(strcmp("WAG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Gambia</option>
<option value="GE" <?php if (!(strcmp("GE", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Georgien</option>
<option value="GH" <?php if (!(strcmp("GH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Ghana</option>
<option value="WG" <?php if (!(strcmp("WG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Grenada</option>
<option value="GR" <?php if (!(strcmp("GR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Griechenland</option>
<option value="GB" <?php if (!(strcmp("GB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Großbritannien</option>
<option value="GCA" <?php if (!(strcmp("GCA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Guatemala</option>
<option value="GBG" <?php if (!(strcmp("GBG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Guernsey</option>
<option value="GU" <?php if (!(strcmp("GU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Guinea</option>
<option value="GUB" <?php if (!(strcmp("GUB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Guinea-Bissau</option>
<option value="GUY" <?php if (!(strcmp("GUY", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Guyana</option>
<option value="RH" <?php if (!(strcmp("RH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Haiti</option>
<option value="BH" <?php if (!(strcmp("BH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Honduras</option>
<option value="HK" <?php if (!(strcmp("HK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Hongkong</option>
<option value="IND" <?php if (!(strcmp("IND", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Indien</option>
<option value="RI" <?php if (!(strcmp("RI", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Indonesien</option>
<option value="IRQ" <?php if (!(strcmp("IRQ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Irak</option>
<option value="IR" <?php if (!(strcmp("IR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Iran</option>
<option value="IRL" <?php if (!(strcmp("IRL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Irland</option>
<option value="IS" <?php if (!(strcmp("IS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Island</option>
<option value="IL" <?php if (!(strcmp("IL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Israel</option>
<option value="I" <?php if (!(strcmp("I", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Italien</option>
<option value="JA" <?php if (!(strcmp("JA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Jamaika</option>
<option value="J" <?php if (!(strcmp("J", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Japan</option>
<option value="ADN" <?php if (!(strcmp("ADN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Jemen</option>
<option value="GBJ" <?php if (!(strcmp("GBJ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Jersey</option>
<option value="HKJ" <?php if (!(strcmp("HKJ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Jordanien</option>
<option value="JOR" <?php if (!(strcmp("JOR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Jordanien</option>
<option value="YU" <?php if (!(strcmp("YU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Jugoslawien</option>
<option value="K" <?php if (!(strcmp("K", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kambodscha</option>
<option value="RFC" <?php if (!(strcmp("RFC", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kamerun</option>
<option value="CDN" <?php if (!(strcmp("CDN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kanada</option>
<option value="KV" <?php if (!(strcmp("KV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kap Verde</option>
<option value="KZ" <?php if (!(strcmp("KZ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kasachstan</option>
<option value="Q" <?php if (!(strcmp("Q", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Katar</option>
<option value="EAK" <?php if (!(strcmp("EAK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kenia</option>
<option value="CO" <?php if (!(strcmp("CO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kolumbien</option>
<option value="KO" <?php if (!(strcmp("KO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Komoren</option>
<option value="RCB" <?php if (!(strcmp("RCB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kongo</option>
<option value="HR" <?php if (!(strcmp("HR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kroatien</option>
<option value="C" <?php if (!(strcmp("C", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kuba</option>
<option value="KT" <?php if (!(strcmp("KT", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Kuwait</option>
<option value="LAO" <?php if (!(strcmp("LAO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Laos</option>
<option value="LS" <?php if (!(strcmp("LS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Lesotho</option>
<option value="LV" <?php if (!(strcmp("LV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Lettland</option>
<option value="RL" <?php if (!(strcmp("RL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Libanon</option>
<option value="LB" <?php if (!(strcmp("LB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Liberia</option>
<option value="LAR" <?php if (!(strcmp("LAR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Libyen</option>
<option value="FL" <?php if (!(strcmp("FL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Liechtenstein</option>
<option value="LT" <?php if (!(strcmp("LT", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Litauen</option>
<option value="L" <?php if (!(strcmp("L", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Luxemburg</option>
<option value="RDM" <?php if (!(strcmp("RDM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Madagaskar</option>
<option value="MW" <?php if (!(strcmp("MW", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Malawi</option>
<option value="MAL" <?php if (!(strcmp("MAL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Malaysia</option>
<option value="MAD" <?php if (!(strcmp("MAD", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Malediven</option>
<option value="RNN" <?php if (!(strcmp("RNN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mali</option>
<option value="M" <?php if (!(strcmp("M", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Malta</option>
<option value="MA" <?php if (!(strcmp("MA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Marokko</option>
<option value="RIM" <?php if (!(strcmp("RIM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mauretanien</option>
<option value="MS" <?php if (!(strcmp("MS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mauritius</option>
<option value="MK" <?php if (!(strcmp("MK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mazedonien</option>
<option value="MEX" <?php if (!(strcmp("MEX", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mexico</option>
<option value="MD" <?php if (!(strcmp("MD", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Moldawien</option>
<option value="MC" <?php if (!(strcmp("MC", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Monaco</option>
<option value="MV" <?php if (!(strcmp("MV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mongolische Volksrep</option>
<option value="MOS" <?php if (!(strcmp("MOS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Mosambik</option>
<option value="NAM" <?php if (!(strcmp("NAM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Namibia</option>
<option value="NAU" <?php if (!(strcmp("NAU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Nauru</option>
<option value="NE" <?php if (!(strcmp("NE", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Nepal</option>
<option value="NZ" <?php if (!(strcmp("NZ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Neuseeland</option>
<option value="NIC" <?php if (!(strcmp("NIC", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Nicaragua</option>
<option value="NA" <?php if (!(strcmp("NA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Niederl.Antillen</option>
<option value="NL" <?php if (!(strcmp("NL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Niederlande</option>
<option value="RN" <?php if (!(strcmp("RN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Niger</option>
<option value="WAN" <?php if (!(strcmp("WAN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Nigeria</option>
<option value="NKO" <?php if (!(strcmp("NKO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Nordkorea</option>
<option value="N" <?php if (!(strcmp("N", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Norwegen</option>
<option value="OM" <?php if (!(strcmp("OM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Oman</option>
<option value="A" <?php if (!(strcmp("A", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Österreich</option>
<option value="PAK" <?php if (!(strcmp("PAK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Pakistan</option>
<option value="PA" <?php if (!(strcmp("PA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Panama</option>
<option value="PNG" <?php if (!(strcmp("PNG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Papua-Neuguinea</option>
<option value="PY" <?php if (!(strcmp("PY", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Paraguay</option>
<option value="PE" <?php if (!(strcmp("PE", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Peru</option>
<option value="PI" <?php if (!(strcmp("PI", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Philippinen</option>
<option value="PL" <?php if (!(strcmp("PL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Polen</option>
<option value="P" <?php if (!(strcmp("P", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Portugal</option>
<option value="PR" <?php if (!(strcmp("PR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Puerto Rico</option>
<option value="RWA" <?php if (!(strcmp("RWA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Ruanda</option>
<option value="RO" <?php if (!(strcmp("RO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Rumänien</option>
<option value="RUS" <?php if (!(strcmp("RUS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Rußland</option>
<option value="WL" <?php if (!(strcmp("WL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Saint Lucia</option>
<option value="WV" <?php if (!(strcmp("WV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Saint Vincent</option>
<option value="SAL" <?php if (!(strcmp("SAL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Salomonen</option>
<option value="Z" <?php if (!(strcmp("Z", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sambia</option>
<option value="WS" <?php if (!(strcmp("WS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Samoa</option>
<option value="RSM" <?php if (!(strcmp("RSM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>San Marino</option>
<option value="EAZ" <?php if (!(strcmp("EAZ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sansibar</option>
<option value="STP" <?php if (!(strcmp("STP", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sao Tome u. Principe</option>
<option value="SA" <?php if (!(strcmp("SA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Saudi-Arabien</option>
<option value="S" <?php if (!(strcmp("S", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Schweden</option>
<option value="CH" <?php if (!(strcmp("CH", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Schweiz</option>
<option value="SN" <?php if (!(strcmp("SN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Senegal</option>
<option value="SCG" <?php if (!(strcmp("SCG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Serbien und Montenegro</option>
<option value="SY" <?php if (!(strcmp("SY", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Seychellen</option>
<option value="WAL" <?php if (!(strcmp("WAL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sierra Leone</option>
<option value="ZW" <?php if (!(strcmp("ZW", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Simbabwe</option>
<option value="SGP" <?php if (!(strcmp("SGP", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Singapore</option>
<option value="SI" <?php if (!(strcmp("SI", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Slovenija</option>
<option value="SK" <?php if (!(strcmp("SK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Slowakische Republik</option>
<option value="SLO" <?php if (!(strcmp("SLO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Slowenien</option>
<option value="SP" <?php if (!(strcmp("SP", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Somalia</option>
<option value="SU" <?php if (!(strcmp("SU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sowjetunion</option>
<option value="E" <?php if (!(strcmp("E", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Spanien</option>
<option value="CL" <?php if (!(strcmp("CL", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sri Lanka</option>
<option value="ZA" <?php if (!(strcmp("ZA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Südafrika</option>
<option value="SUD" <?php if (!(strcmp("SUD", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Sudan</option>
<option value="ROK" <?php if (!(strcmp("ROK", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Südkorea-Republik</option>
<option value="SNE" <?php if (!(strcmp("SNE", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Surinam</option>
<option value="SD" <?php if (!(strcmp("SD", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Swasiland</option>
<option value="SYR" <?php if (!(strcmp("SYR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Syrien</option>
<option value="RC" <?php if (!(strcmp("RC", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Taiwan</option>
<option value="EAT" <?php if (!(strcmp("EAT", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Tansania</option>
<option value="T" <?php if (!(strcmp("T", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Thailand</option>
<option value="TG" <?php if (!(strcmp("TG", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Togo</option>
<option value="TO" <?php if (!(strcmp("TO", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Tonga</option>
<option value="TT" <?php if (!(strcmp("TT", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Trinidad</option>
<option value="TS" <?php if (!(strcmp("TS", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Tschad</option>
<option value="CZ" <?php if (!(strcmp("CZ", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Tschechische Republik</option>
<option value="TN" <?php if (!(strcmp("TN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Tunesien</option>
<option value="TR" <?php if (!(strcmp("TR", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Türkei</option>
<option value="TMN" <?php if (!(strcmp("TMN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Turkmenistan</option>
<option value="TU" <?php if (!(strcmp("TU", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Tuvalu</option>
<option value="UA" <?php if (!(strcmp("UA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Ukraine</option>
<option value="H" <?php if (!(strcmp("H", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Ungarn</option>
<option value="U" <?php if (!(strcmp("U", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Uruguay</option>
<option value="USB" <?php if (!(strcmp("USB", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Usbekistan</option>
<option value="VA" <?php if (!(strcmp("VA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Vanuatu</option>
<option value="SCV" <?php if (!(strcmp("SCV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Vatikanstadt</option>
<option value="YV" <?php if (!(strcmp("YV", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Venezuela</option>
<option value="EM" <?php if (!(strcmp("EM", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Verein.Arab.Emirate</option>
<option value="USA" <?php if (!(strcmp("USA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Vereinigte Staaten</option>
<option value="VN" <?php if (!(strcmp("VN", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Vietnam</option>
<option value="ZRE" <?php if (!(strcmp("ZRE", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Zaire</option>
<option value="RCA" <?php if (!(strcmp("RCA", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Zentralafr.Republik</option>
<option value="CY" <?php if (!(strcmp("CY", $row_standort['standort_land']))) {echo "selected=\"selected\"";} ?>>Zypern</option>
</select></td>
</tr>
<tr>
<td class="stil1">Telefon</td>
<td class="stil1"><input name="standort_telefon" type="text" class="stil2" id="standort_telefon" value="<?php echo $row_standort['standort_telefon']; ?>" /></td>
</tr>
<tr>
<td class="stil1">Fax</td>
<td class="stil1"><input name="standort_fax" type="text" class="stil2" id="standort_fax" value="<?php echo $row_standort['standort_fax']; ?>" /></td>
</tr>
<tr>
<td class="stil1">Email</td>
<td class="stil1"><input name="standort_email" type="text" class="stil2" id="standort_email" value="<?php echo $row_standort['standort_email']; ?>" /></td>
</tr>
<tr>
<td class="stil1">UID</td>
<td class="stil1"><input name="standort_uid" type="text" class="stil2" id="standort_uid" value="<?php echo $row_standort['standort_uid']; ?>" /></td>
</tr>
<tr>
<td class="stil1">Standort löschen ?</td>
<td class="stil1"><input name="delete" type="checkbox" class="stil2" id="delete" value="1" onclick="if(this.checked==true)status_alert(4);if(this.checked==false)status_alert(1)" /></td>
</tr>
<tr>
<td class="stil1"><input name="standort_id" type="hidden" id="standort_id" value="<?php echo $row_standort['standort_id']; ?>" /></td>
<td class="stil1"><label>
<input name="button" type="submit" class="stil1" id="button" value="Updaten" />
</label></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="standort_update" />
</form>
</body>
</html>
<?php
mysql_free_result($standort);
?>
/admin/standort_bearbeiten_detail_optionen.php
0,0 → 1,26
<?
session_start();
?>
<?
//include("session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
Standort bearbeiten
</body>
</html>
/admin/standort_bearbeiten_optionen.php
0,0 → 1,43
<?
session_start();
?>
<?
include("../main/session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form id="form1" name="form1" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">Suche</div></td>
<td><input name="search" type="text" class="optionen_box" id="search" onblur ="var search = encodeURI(this.value);getData('standort_bearbeiten.php?search='+search+'&sorter='+document.form1.sorter.value,'data');" />
<input type="image" name="imageField" id="imageField" src="../img/button01.png" onfocus = "document.form1.search.focus()"/></td>
<td>Sortieren</td>
<td><label>
<input name="radio" type="radio" id="radio1" value="standort_name" checked="checked" onCLick="if(this.checked) {document.form1.sorter.value = this.value;var search = encodeURI(document.form1.search.value);getData('standort_bearbeiten.php?search='+search+'&sorter='+document.form1.sorter.value,'data');}" />
Name
<input name="sorter" type="hidden" id="sorter" value="standort_name" />
</label></td>
</tr>
</table>
</form>
</body>
</html>
/admin/standort_neu.php
0,0 → 1,334
<?php require_once('../Connections/Transart.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
 
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
 
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "standort_neu")) {
$insertSQL = sprintf("INSERT INTO standort (standort_name, standort_adresse, standort_plz, standort_ort, standort_land, standort_telefon, standort_fax, standort_email, standort_uid) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['standort_name'], "text"),
GetSQLValueString($_POST['standort_adresse'], "text"),
GetSQLValueString($_POST['standort_plz'], "int"),
GetSQLValueString($_POST['standort_ort'], "text"),
GetSQLValueString($_POST['standort_land'], "text"),
GetSQLValueString($_POST['standort_telefon'], "text"),
GetSQLValueString($_POST['standort_fax'], "text"),
GetSQLValueString($_POST['standort_email'], "text"),
GetSQLValueString($_POST['standort_uid'], "text"));
 
mysql_select_db($database_Transart, $Transart);
$Result1 = mysql_query($insertSQL, $Transart) or die(mysql_error());
 
$insertGoTo = "index.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}
?><?
session_start();
?>
<?
include("../main/session_seite_include.php");
?>
<?
include("../main/session_status_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
<form action="<?php echo $editFormAction; ?>" id="standort_neu" name="standort_neu" method="POST" onsubmit="return standort_neu_chkFormular()">
<table width="400" class="tabelle1">
<tr>
<td class="stil1">Name</td>
<td class="stil1"><label>
<input name="standort_name" type="text" class="stil2" id="standort_name" />
</label></td>
</tr>
<tr>
<td class="stil1">Adresse</td>
<td class="stil1"><input name="standort_adresse" type="text" class="stil2" id="standort_adresse" /></td>
</tr>
<tr>
<td class="stil1">PLZ</td>
<td class="stil1"><label>
<input name="standort_plz" type="text" class="stil2" id="standort_plz" />
</label></td>
</tr>
<tr>
<td class="stil1">Ort</td>
<td class="stil1"><input name="standort_ort" type="text" class="stil2" id="standort_ort" /></td>
</tr>
<tr>
<td class="stil1">Land</td>
<td class="stil1"><select name="standort_land" class="stil2" id="standort_land">
<option value="A">Österreich</option>
<option value="D">Deutschland</option>
<option value="CH">Schweiz</option>
<option value="AFG">Afghanistan</option>
<option value="ET">Ägypten</option>
<option value="AL">Albanien</option>
<option value="GBA">Alderney</option>
<option value="DZ">Algerien</option>
<option value="AND">Andorra</option>
<option value="AN">Angola</option>
<option value="AQ">Anquilla</option>
<option value="ANT">Antigua</option>
<option value="RA">Argentinien</option>
<option value="ETH">Äthiopien</option>
<option value="AUS">Australien</option>
<option value="BS">Bahamas</option>
<option value="BRN">Bahrain</option>
<option value="BD">Bangladesch</option>
<option value="BDS">Barbados</option>
<option value="BY">Belarus (Weißrussland)</option>
<option value="B">Belgien</option>
<option value="RPB">Benin</option>
<option value="BT">Bhutan</option>
<option value="BUR">Birma</option>
<option value="BOL">Bolivien</option>
<option value="BA">Bosnien-Herzegovina</option>
<option value="RB">Botsuana</option>
<option value="BR">Brasilien</option>
<option value="BRU">Brunei</option>
<option value="BG">Bulgarien</option>
<option value="HV">Burkina Faso</option>
<option value="BU">Burundi</option>
<option value="GY">Chanal Islands</option>
<option value="RCH">Chile</option>
<option value="TJ">Chin. Volksrepublik</option>
<option value="CR">Costa Rica</option>
<option value="DK">Dänemark</option>
<option value="D">Deutschland</option>
<option value="DJ">Djibouti</option>
<option value="WD">Dominica</option>
<option value="DOM">Dominikanische Rep.</option>
<option value="EC">Ecuador</option>
<option value="ES">El Salvador</option>
<option value="CI">Elfenbeinküste</option>
<option value="EW">Estland</option>
<option value="FJI">Fidschi</option>
<option value="SF">Finnland</option>
<option value="F">Frankreich</option>
<option value="GA">Gabun</option>
<option value="WAG">Gambia</option>
<option value="GE">Georgien</option>
<option value="GH">Ghana</option>
<option value="WG">Grenada</option>
<option value="GR">Griechenland</option>
<option value="GB">Großbritannien</option>
<option value="GCA">Guatemala</option>
<option value="GBG">Guernsey</option>
<option value="GU">Guinea</option>
<option value="GUB">Guinea-Bissau</option>
<option value="GUY">Guyana</option>
<option value="RH">Haiti</option>
<option value="BH">Honduras</option>
<option value="HK">Hongkong</option>
<option value="IND">Indien</option>
<option value="RI">Indonesien</option>
<option value="IRQ">Irak</option>
<option value="IR">Iran</option>
<option value="IRL">Irland</option>
<option value="IS">Island</option>
<option value="IL">Israel</option>
<option value="I">Italien</option>
<option value="JA">Jamaika</option>
<option value="J">Japan</option>
<option value="ADN">Jemen</option>
<option value="GBJ">Jersey</option>
<option value="HKJ">Jordanien</option>
<option value="JOR">Jordanien</option>
<option value="YU">Jugoslawien</option>
<option value="K">Kambodscha</option>
<option value="RFC">Kamerun</option>
<option value="CDN">Kanada</option>
<option value="KV">Kap Verde</option>
<option value="KZ">Kasachstan</option>
<option value="Q">Katar</option>
<option value="EAK">Kenia</option>
<option value="CO">Kolumbien</option>
<option value="KO">Komoren</option>
<option value="RCB">Kongo</option>
<option value="HR">Kroatien</option>
<option value="C">Kuba</option>
<option value="KT">Kuwait</option>
<option value="LAO">Laos</option>
<option value="LS">Lesotho</option>
<option value="LV">Lettland</option>
<option value="RL">Libanon</option>
<option value="LB">Liberia</option>
<option value="LAR">Libyen</option>
<option value="FL">Liechtenstein</option>
<option value="LT">Litauen</option>
<option value="L">Luxemburg</option>
<option value="RDM">Madagaskar</option>
<option value="MW">Malawi</option>
<option value="MAL">Malaysia</option>
<option value="MAD">Malediven</option>
<option value="RNN">Mali</option>
<option value="M">Malta</option>
<option value="MA">Marokko</option>
<option value="RIM">Mauretanien</option>
<option value="MS">Mauritius</option>
<option value="MK">Mazedonien</option>
<option value="MEX">Mexico</option>
<option value="MD">Moldawien</option>
<option value="MC">Monaco</option>
<option value="MV">Mongolische Volksrep</option>
<option value="MOS">Mosambik</option>
<option value="NAM">Namibia</option>
<option value="NAU">Nauru</option>
<option value="NE">Nepal</option>
<option value="NZ">Neuseeland</option>
<option value="NIC">Nicaragua</option>
<option value="NA">Niederl.Antillen</option>
<option value="NL">Niederlande</option>
<option value="RN">Niger</option>
<option value="WAN">Nigeria</option>
<option value="NKO">Nordkorea</option>
<option value="N">Norwegen</option>
<option value="OM">Oman</option>
<option value="A">Österreich</option>
<option value="PAK">Pakistan</option>
<option value="PA">Panama</option>
<option value="PNG">Papua-Neuguinea</option>
<option value="PY">Paraguay</option>
<option value="PE">Peru</option>
<option value="PI">Philippinen</option>
<option value="PL">Polen</option>
<option value="P">Portugal</option>
<option value="PR">Puerto Rico</option>
<option value="RWA">Ruanda</option>
<option value="RO">Rumänien</option>
<option value="RUS">Rußland</option>
<option value="WL">Saint Lucia</option>
<option value="WV">Saint Vincent</option>
<option value="SAL">Salomonen</option>
<option value="Z">Sambia</option>
<option value="WS">Samoa</option>
<option value="RSM">San Marino</option>
<option value="EAZ">Sansibar</option>
<option value="STP">Sao Tome u. Principe</option>
<option value="SA">Saudi-Arabien</option>
<option value="S">Schweden</option>
<option value="CH">Schweiz</option>
<option value="SN">Senegal</option>
<option value="SCG">Serbien und Montenegro</option>
<option value="SY">Seychellen</option>
<option value="WAL">Sierra Leone</option>
<option value="ZW">Simbabwe</option>
<option value="SGP">Singapore</option>
<option value="SI">Slovenija</option>
<option value="SK">Slowakische Republik</option>
<option value="SLO">Slowenien</option>
<option value="SP">Somalia</option>
<option value="SU">Sowjetunion</option>
<option value="E">Spanien</option>
<option value="CL">Sri Lanka</option>
<option value="ZA">Südafrika</option>
<option value="SUD">Sudan</option>
<option value="ROK">Südkorea-Republik</option>
<option value="SNE">Surinam</option>
<option value="SD">Swasiland</option>
<option value="SYR">Syrien</option>
<option value="RC">Taiwan</option>
<option value="EAT">Tansania</option>
<option value="T">Thailand</option>
<option value="TG">Togo</option>
<option value="TO">Tonga</option>
<option value="TT">Trinidad</option>
<option value="TS">Tschad</option>
<option value="CZ">Tschechische Republik</option>
<option value="TN">Tunesien</option>
<option value="TR">Türkei</option>
<option value="TMN">Turkmenistan</option>
<option value="TU">Tuvalu</option>
<option value="UA">Ukraine</option>
<option value="H">Ungarn</option>
<option value="U">Uruguay</option>
<option value="USB">Usbekistan</option>
<option value="VA">Vanuatu</option>
<option value="SCV">Vatikanstadt</option>
<option value="YV">Venezuela</option>
<option value="EM">Verein.Arab.Emirate</option>
<option value="USA">Vereinigte Staaten</option>
<option value="VN">Vietnam</option>
<option value="ZRE">Zaire</option>
<option value="RCA">Zentralafr.Republik</option>
<option value="CY">Zypern</option>
</select></td>
</tr>
<tr>
<td class="stil1">Telefon</td>
<td class="stil1"><input name="standort_telefon" type="text" class="stil2" id="standort_telefon" /></td>
</tr>
<tr>
<td class="stil1">Fax</td>
<td class="stil1"><input name="standort_fax" type="text" class="stil2" id="standort_fax" /></td>
</tr>
<tr>
<td class="stil1">Email</td>
<td class="stil1"><input name="standort_email" type="text" class="stil2" id="standort_email" /></td>
</tr>
<tr>
<td class="stil1">UID</td>
<td class="stil1"><input name="standort_uid" type="text" class="stil2" id="standort_uid" /></td>
</tr>
<tr>
<td class="stil1">&nbsp;</td>
<td class="stil1"><label>
<input name="button" type="submit" class="stil1" id="button" value="Anlegen" />
</label></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="standort_neu" />
</form>
</body>
</html>
/admin/standort_neu_optionen.php
0,0 → 1,26
<?
session_start();
?>
<?
include("../main/session_optionen_include.php");
?>
<?php
//Cachen verhindern
header("Expires: Sat, 05 Nov 2005 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Unbenanntes Dokument</title>
<link href="../stil.css" rel="stylesheet" type="text/css" />
</head>
 
<body>
Neuer Standort
</body>
</html>