";
$BestellstatusLanguageDataArray[$LanguageCounter]["language_id"] = $BestellstatusLanguageRow["language_id"];
$LanguageCounter++;
}
return $BestellstatusLanguageDataArray;
}
function SaveKundenanrede($KundenanredeID, $Anrede, $BriefAnrede, $Sort, $LanguageID, $geschlecht = '') {
// ********************************************************************************
// ** Daten speichern
// ********************************************************************************
if (!$KundenanredeID) {
$MaxArray = mysql_fetch_array(errorlogged_mysql_query("SELECT MAX(kundenanredeid) as maxid FROM " . TABLE_KUNDENANREDE_LANGU));
$Maxid = $MaxArray["maxid"];
$KundenanredeID = $Maxid + 1;
$SQLString = "INSERT INTO " . TABLE_KUNDENANREDE_LANGU . " SET ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".anrede = '" . $Anrede . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".briefanrede = '" . $BriefAnrede . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".kundenanredeid = '" . $KundenanredeID . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".language_id = '" . $LanguageID . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
$SQLString = "INSERT INTO " . TABLE_KUNDENANREDE . " SET ";
$SQLString .= TABLE_KUNDENANREDE . ".kundenanredeid = '" . $KundenanredeID . "', ";
$SQLString .= TABLE_KUNDENANREDE . ".sort = '" . $Sort . "', ";
$SQLString .= TABLE_KUNDENANREDE . ".geschlecht = '" . $geschlecht . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
else {
// Sprachabhängige Daten
$SQLString = "SELECT ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".kundenanredeid ";
$SQLString .= "FROM ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . " ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".kundenanredeid = '" . $KundenanredeID . "' AND ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".language_id = '" . $LanguageID . "' ";
$KundenaredeLanguageObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
//11.08.09, C.H.
//falls es die Anrede* in der �bergebenen Sprache($LanguageID)
// schon gibt und diese nun editiert werden soll
//*Anrede = Anrede und Briefanrede
if ($KundenaredeLanguageObject) {
$SQLString = "UPDATE " . TABLE_KUNDENANREDE_LANGU . " SET ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".anrede = '" . $Anrede . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".briefanrede = '" . $BriefAnrede . "' ";
$SQLString .= " WHERE ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".kundenanredeid = '" . $KundenanredeID . "' AND ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".language_id = '" . $LanguageID . "' ";
//11.08.09, C.H.
//falls es die Anrede* in einer anderen Sprache schon
//gibt und nun in der �bergebenen Sprache($LanguageID) die �bersetzung
//geliefert werden soll
//*Anrede = Anrede und Briefanrede
}else if ($LanguageID) {
$SQLString = "INSERT INTO " . TABLE_KUNDENANREDE_LANGU . " SET ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".anrede = '" . $Anrede . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".briefanrede = '" . $BriefAnrede . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".language_id = '" . $LanguageID . "', ";
$SQLString .= TABLE_KUNDENANREDE_LANGU . ".kundenanredeid = '" . $KundenanredeID . "' ";
}
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
//11.08.09, C.H.
//Zum Aktualisieren der Sortierung einer bereits vorhandenen Anrede
$SQLString = "UPDATE " . TABLE_KUNDENANREDE . " SET ";
$SQLString .= TABLE_KUNDENANREDE . ".sort = '" . $Sort . "', ";
$SQLString .= TABLE_KUNDENANREDE . ".geschlecht = '" . $geschlecht . "' ";
$SQLString .= " WHERE ";
$SQLString .= TABLE_KUNDENANREDE . ".kundenanredeid = '" . $KundenanredeID . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
}
function SaveBestellstatus($BestellstatusID, $Name, $NameKunde, $Beschreibung, $Sort, $LanguageID, $zahlungserinnerungTage, $DocumentID) {
// ********************************************************************************
// ** Daten speichern
// ********************************************************************************
if($BestellstatusID == null)
{
$SQLString = "INSERT INTO ";
$SQLString .= TABLE_BESTELLEN_STATUS;
$SQLString .= " SET ";
$SQLString .= TABLE_BESTELLEN_STATUS . ".sort = '" . $Sort . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS . ".document_id = '" . $DocumentID . "' ";
$SQLString .= ", " . TABLE_BESTELLEN_STATUS . ".zahlungserinnerung_tage = '" . $zahlungserinnerungTage ."' ";
errorlogged_mysql_query($SQLString) or die(mysql_error());
$BestellstatusID = mysql_insert_id();
}
else
{
$SQLString = "UPDATE ";
$SQLString .= TABLE_BESTELLEN_STATUS;
$SQLString .= " SET ";
$SQLString .= TABLE_BESTELLEN_STATUS . ".sort = '" . $Sort ."', ";
$SQLString .= TABLE_BESTELLEN_STATUS . ".document_id = '" . $DocumentID . "' ";
$SQLString .= ", " . TABLE_BESTELLEN_STATUS . ".zahlungserinnerung_tage = '" . $zahlungserinnerungTage ."' ";
$SQLString .= " WHERE ";
$SQLString .= TABLE_BESTELLEN_STATUS . ".id = '" . $BestellstatusID ."'";
errorlogged_mysql_query($SQLString) or die(mysql_error());
}
// Sprachabhängige Daten
$SQLString = "SELECT ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".bestellen_status_id ";
$SQLString .= "FROM ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . " ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".bestellen_status_id = '" . $BestellstatusID . "' AND ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".language_id = '" . $LanguageID . "' ";
$BestellstatusLanguageObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
if ($BestellstatusLanguageObject) {
$SQLString = "UPDATE " . TABLE_BESTELLEN_STATUS_LANGU . " SET ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".name = '" . $Name . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".name_kunde = '" . $NameKunde . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".beschreibung = '" . $Beschreibung . "' ";
$SQLString .= " WHERE ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".bestellen_status_id = '" . $BestellstatusID . "' AND ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".language_id = '" . $LanguageID . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
} else {
$SQLString = "INSERT INTO " . TABLE_BESTELLEN_STATUS_LANGU . " SET ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".name = '" . $Name . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".name_kunde = '" . $NameKunde . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".beschreibung = '" . $Beschreibung . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".bestellen_status_id = '" . $BestellstatusID . "', ";
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . ".language_id = '" . $LanguageID . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
return $BestellstatusID;
}
function GetKundenanredeDetail($KundenanredeID, $LanguageID = 0) {
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
}
$SQLString = 'SELECT ';
$SQLString .= TABLE_KUNDENANREDE . '.kundenanredeid, ';
$SQLString .= TABLE_KUNDENANREDE . '.sort, ';
$SQLString .= TABLE_KUNDENANREDE . '.geschlecht, ';
$SQLString .= TABLE_KUNDENANREDE_LANGU . '.anrede, ';
$SQLString .= TABLE_KUNDENANREDE_LANGU . '.briefanrede ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_KUNDENANREDE . ' ';
$SQLString .= 'LEFT JOIN ' . TABLE_KUNDENANREDE_LANGU . ' ON ((' . TABLE_KUNDENANREDE . '.kundenanredeid = ' . TABLE_KUNDENANREDE_LANGU . '.kundenanredeid) AND (' . TABLE_KUNDENANREDE_LANGU . '.language_id = ' . $LanguageID . ')) ';
$SQLString .= 'WHERE ';
$SQLString .= TABLE_KUNDENANREDE . '.kundenanredeid = \'' . $KundenanredeID . '\'';
$KundenanredeObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
return $KundenanredeObject;
}
function GetBestellstatusDetail($BestellstatusID, $LanguageID = 0) {
if($BestellstatusID == null)
return null;
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
}
$SQLString = 'SELECT ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.id, ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.zahlungserinnerung_tage, ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.sort, ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.document_id, ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.standard, ';
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . '.name, ';
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . '.name_kunde, ';
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . '.beschreibung ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_BESTELLEN_STATUS . ' ';
$SQLString .= 'LEFT JOIN ' . TABLE_BESTELLEN_STATUS_LANGU . ' ON ((' . TABLE_BESTELLEN_STATUS . '.id = ' . TABLE_BESTELLEN_STATUS_LANGU . '.bestellen_status_id) AND (' . TABLE_BESTELLEN_STATUS_LANGU . '.language_id = ' . $LanguageID . ')) ';
$SQLString .= 'WHERE ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.id = \'' . $BestellstatusID . '\'';
$BestellstatusObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
return $BestellstatusObject;
}
function GetKundenanredeLanguageDataArray($KundenanredeID) {
// Sprachen Abfragen
$SQLString = "SELECT ";
$SQLString .= TABLE_LANGUAGE . ".language_id, ";
$SQLString .= "IF(ISNULL(" . TABLE_KUNDENANREDE_LANGU . ".anrede), " . TABLE_LANGUAGE . ".language_image_admintool_inactive, " . TABLE_LANGUAGE . ".language_image_admintool_active) AS language_image_admintool ";
$SQLString .= "FROM ";
$SQLString .= TABLE_LANGUAGE . " ";
$SQLString .= "LEFT JOIN " . TABLE_KUNDENANREDE_LANGU . " ON ((" . TABLE_LANGUAGE . ".language_id = " . TABLE_KUNDENANREDE_LANGU . ".language_id) AND (" . TABLE_KUNDENANREDE_LANGU . ".kundenanredeid = '" . $KundenanredeID . "')) ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
$LanguageCounter = 0;
while ($KundenanredeLanguageRow = mysql_fetch_array($MySQLQueryReference)) {
$KundenanredeLanguageDataArray[$LanguageCounter]["language_image_admintool_imagestring"] = "![](\"")
";
$KundenanredeLanguageDataArray[$LanguageCounter]["language_id"] = $KundenanredeLanguageRow["language_id"];
$LanguageCounter++;
}
return $KundenanredeLanguageDataArray;
}
function GetKundenanredeDataArray($LanguageID = 0) {
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
}
$SQLString = 'SELECT ';
$SQLString .= TABLE_KUNDENANREDE . '.kundenanredeid, ';
$SQLString .= TABLE_KUNDENANREDE_LANGU . '.anrede, ';
$SQLString .= TABLE_KUNDENANREDE_LANGU . '.briefanrede ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_KUNDENANREDE . ' ';
$SQLString .= 'LEFT JOIN ' . TABLE_KUNDENANREDE_LANGU . ' ON ((' . TABLE_KUNDENANREDE . '.kundenanredeid = ' . TABLE_KUNDENANREDE_LANGU . '.kundenanredeid) AND (' . TABLE_KUNDENANREDE_LANGU . '.language_id = ' . $LanguageID . ')) ';
$SQLString .= 'ORDER BY ' . TABLE_KUNDENANREDE . ".sort ASC";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
$KundenanredeDataArray = array();
$KundenanredeCounter = 0;
while ($KundenanredeRow = mysql_fetch_array($MySQLQueryReference)) {
$KundenanredeDataArray[$KundenanredeCounter] = $KundenanredeRow;
$KundenanredeDataArray[$KundenanredeCounter]["languagearray"] = GetKundenanredeLanguageDataArray($KundenanredeRow["kundenanredeid"]);
$KundenanredeCounter++;
}
return $KundenanredeDataArray;
}
function GetBestellstatusDataArray($LanguageID = 0, $DocumentID = 0) {
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
}
$SQLString = 'SELECT ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.id, ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.standard, ';
$SQLString .= TABLE_BESTELLEN_STATUS_LANGU . '.name ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_BESTELLEN_STATUS . ' ';
$SQLString .= 'LEFT JOIN ' . TABLE_BESTELLEN_STATUS_LANGU . ' ON ((' . TABLE_BESTELLEN_STATUS . '.id = ' . TABLE_BESTELLEN_STATUS_LANGU . '.bestellen_status_id) AND (' . TABLE_BESTELLEN_STATUS_LANGU . '.language_id = ' . $LanguageID . ')) ';
$SQLString .= 'WHERE ';
$SQLString .= TABLE_BESTELLEN_STATUS . '.document_id = \'' . $DocumentID . '\' ';
$SQLString .= 'ORDER BY ' . TABLE_BESTELLEN_STATUS . ".sort ASC";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
// echo $SQLString;
$BestellstatusDataArray = array();
$BestellstatusCounter = 0;
while ($BestellstatusRow = mysql_fetch_array($MySQLQueryReference)) {
$BestellstatusDataArray[$BestellstatusCounter] = $BestellstatusRow;
$BestellstatusDataArray[$BestellstatusCounter]["languagearray"] = GetBestellstatusLanguageDataArray($BestellstatusRow["id"]);
$BestellstatusCounter++;
}
return $BestellstatusDataArray;
}
function GetDefaultLanguageID() {
static $language_id;
if (!isset($language_id)) {
$SQLString = 'SELECT ';
$SQLString .= TABLE_LANGUAGE . '.language_id ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_LANGUAGE . ' ';
$SQLString .= 'WHERE ';
$SQLString .= TABLE_LANGUAGE . '.language_standard = 1 ';
$LanguageObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
$language_id = $LanguageObject->language_id;
}
return $language_id;
}
function CheckLanguageID($LanguageID = "", $LanguageISOCode = "") {
if ($LanguageID) {
$LanguageObject = GetLanguageDetail($LanguageID);
if (!$LanguageObject || !$LanguageObject->language_active) {
$LanguageObject = GetLanguageDetail();
}
} else {
$LanguageObject = GetLanguageDetail("", $LanguageISOCode);
if (!$LanguageObject || !$LanguageObject->language_active) {
$LanguageObject = GetLanguageDetail();
}
}
return $LanguageObject;
}
//function CheckLanguageISOCode($LanguageISOCode) {
//
// $SQLString = 'SELECT ';
// $SQLString .= TABLE_LANGUAGE . '.language_id, ';
// $SQLString .= TABLE_LANGUAGE . '.language_isocode ';
// $SQLString .= 'FROM ';
// $SQLString .= TABLE_LANGUAGE . ' ';
// $SQLString .= 'WHERE ';
// $SQLString .= TABLE_LANGUAGE . '.language_isocode = \'' . $LanguageISOCode . '\' ';
//
// $LanguageObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
//
// if ($LanguageObject) {
//
// return $LanguageObject->language_id;
//
// } else {
//
// $SQLString = 'SELECT ';
// $SQLString .= TABLE_LANGUAGE . '.language_id ';
// $SQLString .= 'FROM ';
// $SQLString .= TABLE_LANGUAGE . ' ';
// $SQLString .= 'WHERE ';
// $SQLString .= TABLE_LANGUAGE . '.language_standard = 1 ';
//
// $LanguageObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
//
// return $LanguageObject->language_id;
//
// }
//
//}
function GetLanguageDetail($LanguageID = "", $LanguageISOCoder = "") {
$SQLString = 'SELECT ';
$SQLString .= TABLE_LANGUAGE . '.language_id, ';
$SQLString .= TABLE_LANGUAGE . '.language_isocode, ';
$SQLString .= TABLE_LANGUAGE . '.language_name, ';
$SQLString .= TABLE_LANGUAGE . '.url_name_vorgabe, ';
$SQLString .= TABLE_LANGUAGE . '.url_name, ';
$SQLString .= TABLE_LANGUAGE . '.language_active, ';
$SQLString .= TABLE_LANGUAGE . '.language_standard, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_shop, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_active, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_inactive, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_active_width, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_active_height, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_inactive_width, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_inactive_height, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_shop_width, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_shop_height, ';
$SQLString .= TABLE_LANGUAGE . '.locale ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_LANGUAGE . ' ';
$SQLString .= 'WHERE ';
if ($LanguageISOCoder) {
$SQLString .= TABLE_LANGUAGE . '.language_isocode = \'' . $LanguageISOCoder . '\' ';
} elseif (!$LanguageID) {
$SQLString .= TABLE_LANGUAGE . '.language_standard = 1 ';
} else {
$SQLString .= TABLE_LANGUAGE . '.language_id = \'' . $LanguageID . '\' ';
}
//echo '$SQLString: ' . $SQLString . '
';
// die Sprache einlesen
$LanguageObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
// Bild für den Shop
if ($LanguageObject->language_image_shop && file_exists(DATEIPFAD . 'images/dbimages/' . $LanguageObject->language_image_shop)) {
$LanguageObject->language_image_shop_imagestring = "language_image_shop . "?ts=" . time(). "\" width=\"" . $LanguageObject->language_image_shop_width . "\" height=\"" . $LanguageObject->language_image_shop_height . "\" border=\"0\">";
}
// Bild für das Admintool - Aktiv
if ($LanguageObject->language_image_admintool_active && file_exists(DATEIPFAD . 'images/dbimages/' . $LanguageObject->language_image_admintool_active)) {
$LanguageObject->language_image_admintool_active_imagestring = "language_image_admintool_active . "?ts=" . time(). "\" width=\"" . $LanguageObject->language_image_admintool_active_width . "\" height=\"" . $LanguageObject->language_image_admintool_active_height . "\" border=\"0\">";
}
// Bild für das Admintool - Inaktiv
if ($LanguageObject->language_image_admintool_inactive && file_exists(DATEIPFAD . 'images/dbimages/' . $LanguageObject->language_image_admintool_inactive)) {
$LanguageObject->language_image_admintool_inactive_imagestring = "language_image_admintool_inactive . "?ts=" . time(). "\" width=\"" . $LanguageObject->language_image_admintool_inactive_width . "\" height=\"" . $LanguageObject->language_image_admintool_inactive_height . "\" border=\"0\">";
}
// echo '';
// var_dump($LanguageObject);
// echo '
';
return $LanguageObject;
}
function GetLanguageDataArray($SortField = "", $SortOrder = "", $LanguageID = 0, $ZusatzString = "", $UseBlacklist = true, $FilterAktiv = false) {
$SQLString = 'SELECT ';
$SQLString .= TABLE_LANGUAGE . '.language_id, ';
$SQLString .= TABLE_LANGUAGE . '.language_isocode, ';
$SQLString .= TABLE_LANGUAGE . '.language_name, ';
$SQLString .= TABLE_LANGUAGE . '.language_active, ';
$SQLString .= TABLE_LANGUAGE . '.language_standard, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_shop, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_shop_width, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_shop_height, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_active, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_active_width, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_active_height, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_inactive, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_inactive_width, ';
$SQLString .= TABLE_LANGUAGE . '.language_image_admintool_inactive_height ';
$SQLString .= 'FROM ';
$SQLString .= TABLE_LANGUAGE . ' ';
if ($FilterAktiv) {
$SQLString .= 'WHERE ';
$SQLString .= TABLE_LANGUAGE . '.language_active = 1 ';
}
if ($SortField && $SortOrder) {
$SQLString .= 'ORDER BY ' . $SortField . " " . $SortOrder;
}
//echo '$SQLString: ' . $SQLString . '
';
$MySQLQueryReferenz = errorlogged_mysql_query($SQLString);
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
//11.8.09, C.H. Testzweck
//echo "Hier: " . $LanguageID;
}
$LanguageDataArray = array();
$URLQueryParameterArray = array();
$LanguageCounter = 0;
// echo '';
// var_dump($_SERVER);
// echo '
';
// URL zur aktuellen Seite
$URLArray = parse_url(URLPFAD);
$RequestURIArray = parse_url($_SERVER["REQUEST_URI"]);
$QueryParameterBlacklistArray = array();
$QueryParameterBlacklistArray[] = "languageid";
if ($UseBlacklist) {
$QueryParameterBlacklistArray[] = "formaction";
$QueryParameterBlacklistArray[] = "action";
}
if (isset($RequestURIArray["query"])) {
$QueryArray = explode("&", $RequestURIArray["query"]);
foreach ($QueryArray as $Query) {
$QueryParameterArray = explode("=", $Query);
if (array_search($QueryParameterArray[0], $QueryParameterBlacklistArray) === false) {
$URLQueryParameterArray[$QueryParameterArray[0]] = $QueryParameterArray[1];
}
}
}
if (count($URLQueryParameterArray) > 0) {
foreach ($URLQueryParameterArray as $URLQueryParameterKey => $URLQueryParameterValue) {
if(!isset($URLQueryParameterString)) { $URLQueryParameterString = null; }
$URLQueryParameterString .= $URLQueryParameterKey . "=" . $URLQueryParameterValue . "&";
}
$URLQueryParameterString = "?" . substr($URLQueryParameterString, 0, strlen($URLQueryParameterString) - 5);
}
if (substr($_SERVER["REQUEST_URI"], strlen($_SERVER["REQUEST_URI"]) - 1, 1) == "/") {
if($_SERVER["SERVER_PORT"] != 80){
$ActualURL = $URLArray["scheme"] . ":" . "//" . $URLArray["host"] . ":" . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"] . "index.php";
}else{
$ActualURL = $URLArray["scheme"] . "://" . $URLArray["host"] . $_SERVER["REQUEST_URI"] . "index.php";
}
} else {
if(!isset($URLQueryParameterString)) { $URLQueryParameterString = ""; }
// $ActualURL = $URLArray["scheme"] . "://" . $URLArray["host"] . preg_replace("/[&?]languageid=./", "", $_SERVER["REQUEST_URI"]);
if($_SERVER["SERVER_PORT"] != 80){
$ActualURL = $URLArray["scheme"] . ":" . "//" . $URLArray["host"] . ":" . $_SERVER["SERVER_PORT"] . $RequestURIArray["path"] . $URLQueryParameterString;
}else{
$ActualURL = $URLArray["scheme"] . "://" . $URLArray["host"] . $RequestURIArray["path"] . $URLQueryParameterString;
}
if (!strpos($ActualURL, "?")) {
$ActualURL = str_replace("&", "?", $ActualURL);
}
}
while ($LanguageRowArray = mysql_fetch_array($MySQLQueryReferenz, MYSQL_ASSOC)) {
$LanguageDataArray[$LanguageCounter] = $LanguageRowArray;
// Bild für den Shop
if ($LanguageRowArray["language_image_shop"] && file_exists(DATEIPFAD . 'images/dbimages/' . $LanguageRowArray["language_image_shop"])) {
$LanguageDataArray[$LanguageCounter]["language_image_shop_imagestring"] = "";
}
// Bild für das Admintool - Aktiv
if ($LanguageRowArray["language_image_admintool_active"] && file_exists(DATEIPFAD . 'images/dbimages/' . $LanguageRowArray["language_image_admintool_active"])) {
$LanguageDataArray[$LanguageCounter]["language_image_admintool_active_imagestring"] = "";
}
// Bild für das Admintool - Inaktiv
if ($LanguageRowArray["language_image_admintool_inactive"] && file_exists(DATEIPFAD . 'images/dbimages/' . $LanguageRowArray["language_image_admintool_inactive"])) {
$LanguageDataArray[$LanguageCounter]["language_image_admintool_inactive_imagestring"] = "";
}
// Bild für das Admintool - Aktuelle
if ($LanguageRowArray["language_id"] == $LanguageID) {
$LanguageDataArray[$LanguageCounter]["language_image_admintool_imagestring"] = $LanguageDataArray[$LanguageCounter]["language_image_admintool_active_imagestring"];
$LanguageDataArray[$LanguageCounter]["language_image_admintool_image"] = URLPFAD . "images/dbimages/" . $LanguageRowArray["language_image_admintool_active"];
} else {
$LanguageDataArray[$LanguageCounter]["language_image_admintool_imagestring"] = $LanguageDataArray[$LanguageCounter]["language_image_admintool_inactive_imagestring"];
$LanguageDataArray[$LanguageCounter]["language_image_admintool_image"] = URLPFAD . "images/dbimages/" . $LanguageRowArray["language_image_admintool_inactive"];
}
// Aktivimage
if ($LanguageRowArray["language_active"]) {
$LanguageDataArray[$LanguageCounter]["language_active_imagestring"] = "";
} else {
$LanguageDataArray[$LanguageCounter]["language_active_imagestring"] = "";
}
// Standardimage
if ($LanguageRowArray["language_standard"]) {
$LanguageDataArray[$LanguageCounter]["language_standard_imagestring"] = "";
} else {
$LanguageDataArray[$LanguageCounter]["language_stanard_imagestring"] = "";
}
// Sprachauswahlurl
if (strpos($ActualURL, "?")) {
//11.8.09, C.H. Testzweck
//echo "
Jetzt12.1: " . $LanguageRowArray["language_id"];
$LanguageDataArray[$LanguageCounter]["language_select_url"] = $ActualURL . "&languageid=" . $LanguageRowArray["language_id"];
//11.8.09, C.H. Testzweck
//echo "
Jetzt13: " . $LanguageRowArray["language_id"];
} else {
$LanguageDataArray[$LanguageCounter]["language_select_url"] = $ActualURL . "?languageid=" . $LanguageRowArray["language_id"];
}
// echo '$LanguageDataArray[$LanguageCounter]["language_select_url"]: ' . $LanguageDataArray[$LanguageCounter]["language_select_url"] . '
';
// if (!strpos($LanguageDataArray[$LanguageCounter]["language_select_url"], "languageid=")) {
//
// if (strpos($ActualURL, "?")) {
// $LanguageDataArray[$LanguageCounter]["language_select_url"] = $ActualURL . "&languageid=" . $LanguageRowArray["language_id"];
// } else {
// $LanguageDataArray[$LanguageCounter]["language_select_url"] = $ActualURL . "?languageid=" . $LanguageRowArray["language_id"];
// }
//
// }
// Zusatztext
if ($ZusatzString) {
$LanguageDataArray[$LanguageCounter]["language_select_url"] = $LanguageDataArray[$LanguageCounter]["language_select_url"] . "&" . $ZusatzString;
}
$LanguageCounter++;
}
//11.8.09, C.H. Testzweck
//echo "
Jetzt2: " . $LanguageDataArray["language_id"];
return $LanguageDataArray;
}
function SetLanguageOnlinestatus($LanguageID) {
// aktuellen Onlinestatus ermitteln
$LanguageObject = GetLanguageDetail($LanguageID);
// neuen Onlinestatus ermitteln
if ($LanguageObject->language_active == 1) {
$NewOnlinestatus = 0;
} else {
$NewOnlinestatus = 1;
}
// neuen Onlinestatus setzen
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_active = '" . $NewOnlinestatus . "' ";
$SQLString .= "WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQuerryReferenz = errorlogged_mysql_query($SQLString);
// SEO URL löschen oder eintragen
if ($NewOnlinestatus) {
ActivateLanguageSEOURL($LanguageID);
} else {
DeactivateLanguageSEOURL($LanguageID);
}
}
function DeleteLanguage($LanguageID) {
// Sprachdaten löschen
$SQLString = "DELETE FROM " . TABLE_LANGUAGE . " WHERE language_id = '" . $LanguageID . "'";
$MySQLQuerryReferenz = errorlogged_mysql_query($SQLString);
// Bilder löschen
$ImageName = "language_" . sprintf("%07d", $LanguageID) . "_s";
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
$ImageName = "language_" . sprintf("%07d", $LanguageID) . "_aa";
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
$ImageName = "language_" . sprintf("%07d", $LanguageID) . "_ai";
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
// Sprache löschen
$SQLString = "DELETE FROM " . TABLE_KATEGORIE_LANGU . " WHERE language_id = '" . $LanguageID . "'";
$MySQLQuerryReferenz = errorlogged_mysql_query($SQLString);
// SEO Einträge löschen
// TODO: Hier müsste man noch eine SIcherheitsabfrage einbauen, da die URLs in diesem Fall gelöscht
// und nicht umgeleitet werden
DeactivateLanguageSEOURL($LanguageID);
}
function SaveLanguage($LanguageID, $LanguageName, $LanguageISOCode, $LanguageActive, $LanguageStandard, $LanguageImageShopArray, $LanguageImageShopDelete, $LanguageImageAdmintoolActiveArray, $LanguageImageAdmintoolActiveDelete, $LanguageImageAdmintoolInactiveArray, $LanguageImageAdmintoolInactiveDelete, $URLNameVorgabe, $Locale) {
// alte Werte einlesen
$LanguageObject = GetLanguageDetail($LanguageID);
$DefaultLanguageID = GetDefaultLanguageID();
if ($LanguageStandard) {
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_standard = 0 ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
if ($URLNameVorgabe) {
$URLName = DecodeLanguageName($URLNameVorgabe);
} else {
$URLName = DecodeLanguageName($LanguageISOCode);
}
$LanguageAktivated = false;
$LanguageDeaktivated = false;
$ResetLanguage = false;
$ResetOldLanguage = false;
// Aktiv Status geändert
if ($LanguageObject->language_active != $LanguageActive) {
if ($LanguageActive == 1) {
$LanguageAktivated = true;
} else {
$LanguageDeaktivated = true;
}
}
// SEO Name geändert
if ($LanguageObject->url_name != $URLName) {
$ResetLanguage = true;
}
if ($LanguageStandard && ($LanguageID != $DefaultLanguageID)) {
$Einstellungen = GetEinstellungen('', 'seo');
if ($Einstellungen->seo->sprechende_urls_kein_sprachname_bei_standardsprache) {
$ResetLanguage = true;
$ResetOldLanguage = true;
}
}
// ********************************************************************************
// ** Daten speichern
// ********************************************************************************
// Sprache schon vorhanden
if ($LanguageID) {
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_name = '" . $LanguageName . "', ";
$SQLString .= TABLE_LANGUAGE . ".url_name_vorgabe = '" . $URLNameVorgabe . "', ";
$SQLString .= TABLE_LANGUAGE . ".url_name = '" . $URLName . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_isocode = '" . $LanguageISOCode . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_active = '" . $LanguageActive . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_standard = '" . $LanguageStandard . "', ";
$SQLString .= TABLE_LANGUAGE . ".locale = '" . $Locale . "' ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
// Sprache neu anlegen
} else {
$SQLString = "INSERT INTO " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_name = '" . $LanguageName . "', ";
$SQLString .= TABLE_LANGUAGE . ".url_name_vorgabe = '" . $URLNameVorgabe . "', ";
$SQLString .= TABLE_LANGUAGE . ".url_name = '" . $URLName . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_isocode = '" . $LanguageISOCode . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_active = '" . $LanguageActive . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_standard = '" . $LanguageStandard . "', ";
$SQLString .= TABLE_LANGUAGE . ".locale = '" . $Locale . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
$LanguageID = mysql_insert_id();
}
// echo '$SQLString: ' . $SQLString . '
';
// SEO URLs
if ($LanguageDeaktivated || $ResetLanguage) {
DeactivateLanguageSEOURL($LanguageID);
}
if ($LanguageAktivated || $ResetLanguage) {
ActivateLanguageSEOURL($LanguageID);
}
if ($ResetOldLanguage) {
DeactivateLanguageSEOURL($DefaultLanguageID);
ActivateLanguageSEOURL($LanguageID);
}
// ********************************************************************************
// ** Bilder löschen
// ********************************************************************************
if ($LanguageImageShopDelete) {
$ImageName = "language_" . sprintf("%07d", $LanguageID) . "_s";
// altes Bild löschen
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_image_shop = '', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_shop_width = 0, ";
$SQLString .= TABLE_LANGUAGE . ".language_image_shop_height = 0 ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
if ($LanguageImageAdmintoolActiveDelete) {
$ImageName = "language_" . sprintf("%07d", $LanguageID) . "_aa";
// altes Bild l�schen
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_active = '', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_active_width = 0, ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_active_height = 0 ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
if ($LanguageImageAdmintoolInactiveDelete) {
$ImageName = "language_" . sprintf("%07d", $LanguageID) . "_ai";
// altes Bild löschen
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_inactive = '', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_inactive_width = 0, ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_inactive_height = 0 ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
// ********************************************************************************
// ** Bilder auswerten
// ********************************************************************************
// Shopbild
if (($LanguageImageShopArray["size"] > 0) && !$LanguageImageShopDelete) {
$NewImageName = "language_" . sprintf("%07d", $LanguageID) . "_s";
// altes Bild l�schen
unlink_wc(DATEIPFAD . "images/dbimages/", $NewImageName . ".*");
// temporäre Datei kopieren
$TempNameArray = explode(".", $LanguageImageShopArray["name"]);
$NewImageName = $NewImageName . "." . $TempNameArray[count($TempNameArray) - 1];
move_uploaded_file($LanguageImageShopArray["tmp_name"], DATEIPFAD . "images/dbimages/" . $NewImageName);
chmod(DATEIPFAD . "images/dbimages/" . $NewImageName, 0644);
$ImageSizeArray = getimagesize(DATEIPFAD . 'images/dbimages/' . $NewImageName);
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_image_shop = '" . $NewImageName . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_shop_width = '" . $ImageSizeArray[0] . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_shop_height = '" . $ImageSizeArray[1] . "' ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
// Admintoolbild - Aktiv
if (($LanguageImageAdmintoolActiveArray["size"] > 0) && !$LanguageImageAdmintoolActiveDelete) {
$NewImageName = "language_" . sprintf("%07d", $LanguageID) . "_aa";
// altes Bild löschen
unlink_wc(DATEIPFAD . "images/dbimages/", $NewImageName . ".*");
// temporäre Datei kopieren
$TempNameArray = explode(".", $LanguageImageAdmintoolActiveArray["name"]);
$NewImageName = $NewImageName . "." . $TempNameArray[count($TempNameArray) - 1];
move_uploaded_file($LanguageImageAdmintoolActiveArray["tmp_name"], DATEIPFAD . "images/dbimages/" . $NewImageName);
chmod(DATEIPFAD . "images/dbimages/" . $NewImageName, 0644);
$ImageSizeArray = getimagesize(DATEIPFAD . 'images/dbimages/' . $NewImageName);
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_active = '" . $NewImageName . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_active_width = '" . $ImageSizeArray[0] . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_active_height = '" . $ImageSizeArray[1] . "' ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
// Admintoolbild - Inaktiv
if (($LanguageImageAdmintoolInactiveArray["size"] > 0) && !$LanguageImageAdmintoolInactiveDelete) {
$NewImageName = "language_" . sprintf("%07d", $LanguageID) . "_ai";
// altes Bild löschen
unlink_wc(DATEIPFAD . "images/dbimages/", $NewImageName . ".*");
// tempor�re Datei kopieren
$TempNameArray = explode(".", $LanguageImageAdmintoolInactiveArray["name"]);
$NewImageName = $NewImageName . "." . $TempNameArray[count($TempNameArray) - 1];
move_uploaded_file($LanguageImageAdmintoolInactiveArray["tmp_name"], DATEIPFAD . "images/dbimages/" . $NewImageName);
chmod(DATEIPFAD . "images/dbimages/" . $NewImageName, 0644);
$ImageSizeArray = getimagesize(DATEIPFAD . 'images/dbimages/' . $NewImageName);
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_LANGUAGE . " SET ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_inactive = '" . $NewImageName . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_inactive_width = '" . $ImageSizeArray[0] . "', ";
$SQLString .= TABLE_LANGUAGE . ".language_image_admintool_inactive_height = '" . $ImageSizeArray[1] . "' ";
$SQLString .= " WHERE " . TABLE_LANGUAGE . ".language_id = '" . $LanguageID . "'";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
return $LanguageID;
}
function DeleteBestellstatus($BestellstatusID) {
$SQLString = "DELETE FROM " . TABLE_BESTELLEN_STATUS;
$SQLString .= " WHERE " . TABLE_BESTELLEN_STATUS . ".id = " . $BestellstatusID;
errorlogged_mysql_query($SQLString);
$SQLString = "DELETE FROM " . TABLE_BESTELLEN_STATUS_LANGU;
$SQLString .= " WHERE " . TABLE_BESTELLEN_STATUS_LANGU . ".bestellen_status_id = " . $BestellstatusID;
errorlogged_mysql_query($SQLString);
}
function SetStandardBestellStatus($BestellstatusID) {
$SQLString = 'SELECT document_id FROM ' . TABLE_BESTELLEN_STATUS . ' WHERE id = \'' . $BestellstatusID . '\'';
$row = mysql_fetch_row(errorlogged_mysql_query($SQLString));
$SQLString = 'UPDATE ' . TABLE_BESTELLEN_STATUS . ' SET standard = (id = \'' . $BestellstatusID . '\') WHERE ' . TABLE_BESTELLEN_STATUS . '.document_id = ' . $row[0];
errorlogged_mysql_query($SQLString);
}
function GetStandardBestellStatus($DocumentID = false) {
if(!$DocumentID) {
$DocumentID = DOCUMENT_ID_BESTELLUNG;
}
$SQLString = 'SELECT id FROM ' . TABLE_BESTELLEN_STATUS . ' WHERE standard <> 0 AND document_id = \'' . $DocumentID . '\'';
$result = errorlogged_mysql_query($SQLString);
$row = mysql_fetch_row($result);
return $row[0];
}