0) {
$NewImageName = "banner_" . sprintf("%07d", $BannerID) . "_" . $LanguageID;
// altes Bild löschen
unlink_wc(DATEIPFAD . "images/dbimages/", $NewImageName . ".*");
if($ImageArray["type"] == "image/jpeg" || $ImageArray["type"] == "image/pjpeg" || $ImageArray["type"] == "image/gif" || $ImageArray["type"] == "image/png" || $ImageArray["type"] == "application/pdf"){
// temporäre Datei kopieren
$TempNameArray = explode(".", $ImageArray["name"]);
$NewImageName = $NewImageName . "." . $TempNameArray[count($TempNameArray) - 1];
move_uploaded_file($ImageArray["tmp_name"], DATEIPFAD . "images/dbimages/" . $NewImageName);
chmod(DATEIPFAD . "images/dbimages/" . $NewImageName, 0777);
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_BANNER_LANGU . " SET ";
$SQLString .= TABLE_BANNER_LANGU . ".bigImage = '" . $NewImageName . "' ";
$SQLString .= " WHERE ";
$SQLString .= TABLE_BANNER_LANGU . ".banner_id = '" . $BannerID . "' AND ";
$SQLString .= TABLE_BANNER_LANGU . ".language_id = '" . $LanguageID . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
} else {
echo "FEHLER: Bitte laden Sie nur JPG-, PNG- oder GIF-Dateien hoch.
zurück";
die;
}
}
}
function GetBannerDetail($BannerID, $LanguageID = 0) {
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
}
$StandardLanguageID = GetDefaultLanguageID();
$SQLString = "SELECT ";
$SQLString .= TABLE_BANNER . ".id AS banner_id, ";
$SQLString .= TABLE_BANNER . ".artikel_id, ";
$SQLString .= TABLE_BANNER . ".language_independent, ";
$SQLString .= "IF(" . TABLE_BANNER . ".language_independent, table_banner_langu_standard.bigImage, " . TABLE_BANNER_LANGU . ".bigImage) AS bigImage, ";
$SQLString .= TABLE_BANNER_LANGU . ".url ";
$SQLString .= "FROM ";
$SQLString .= TABLE_BANNER . " ";
$SQLString .= "LEFT JOIN " . TABLE_BANNER_LANGU . " ON ((" . TABLE_BANNER . ".id = " . TABLE_BANNER_LANGU . ".banner_id) AND (" . TABLE_BANNER_LANGU . ".language_id = " . $LanguageID . ")) ";
$SQLString .= "LEFT JOIN " . TABLE_BANNER_LANGU . " table_banner_langu_standard ON ((" . TABLE_BANNER . ".id = table_banner_langu_standard.banner_id) AND (table_banner_langu_standard.language_id = " . $StandardLanguageID . ")) ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_BANNER . ".id = '" . $BannerID . "' ";
$BannerObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
if (($BannerObject->bigImage != "") && (file_exists(DATEIPFAD . "images/dbimages/" . $BannerObject->bigImage))) {
$ImageSizeArray = getimagesize(DATEIPFAD . "images/dbimages/" . $BannerObject->bigImage);
$BannerObject->image_string = "![](\"")
bigImage . "\" border=\"1\" width=\"" . $ImageSizeArray[0] . "\" height=\"" . $ImageSizeArray[1] . "\">\n";
}
// echo '';
// var_dump($BannerObject);
// echo '
';
return $BannerObject;
}
function AddBanner($ArtikelID, $LanguageID) {
$SQLString = "SELECT ";
$SQLString .= TABLE_BANNER . ".id ";
$SQLString .= "FROM ";
$SQLString .= TABLE_BANNER . " ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_BANNER . ".artikel_id = '" . $ArtikelID . "' ";
$ArtikelObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
if ($ArtikelObject) {
return false;
}
$SQLString = "INSERT INTO " . TABLE_BANNER . " SET ";
$SQLString .= TABLE_BANNER . ".artikel_id = '" . $ArtikelID . "' ";
$MySQLQueryRefernce = errorlogged_mysql_query($SQLString);
$BannerID = mysql_insert_id();
$SQLString = "INSERT INTO " . TABLE_BANNER_LANGU . " SET ";
$SQLString .= TABLE_BANNER_LANGU . ".banner_id = '" . $BannerID . "', ";
$SQLString .= TABLE_BANNER_LANGU . ".language_id = '" . $LanguageID . "' ";
$MySQLQueryRefernce = errorlogged_mysql_query($SQLString);
}
function DeleteBanner($BannerID = "", $ArtikelID = "") {
// Banner
if ($ArtikelID) {
$SQLString = "SELECT ";
$SQLString .= TABLE_BANNER . ".id ";
$SQLString .= "FROM ";
$SQLString .= TABLE_BANNER . " ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_BANNER . ".artikel_id = '" . $ArtikelID . "' ";
$TempBannerObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
$BannerID = $TempBannerObject->id;
}
$SQLString = "DELETE FROM " . TABLE_BANNER . " WHERE id = '" . $BannerID . "'";
$MySQLQuerryReferenz = errorlogged_mysql_query($SQLString);
$SQLString = "DELETE FROM " . TABLE_BANNER_LANGU . " WHERE banner_id = '" . $BannerID . "'";
$MySQLQuerryReferenz = errorlogged_mysql_query($SQLString);
// Bilder loeschen
$ImageName = "banner_" . sprintf("%07d", $BannerID) . "*";
unlink_wc(DATEIPFAD . "images/dbimages/", $ImageName . ".*");
}
function SetBannerTime($BannerTime) {
$SQLString = "UPDATE " . TABLE_ALLGEMEIN . " SET ";
$SQLString .= TABLE_ALLGEMEIN . ".banner_time = '" . $BannerTime . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
function GetBannerDataArray($LanguageID) {
// Sprache ermitteln
if (!$LanguageID) {
$LanguageID = GetDefaultLanguageID();
}
$StandardLanguageID = GetDefaultLanguageID();
$SQLString = "SELECT ";
$SQLString .= TABLE_BANNER . ".id AS banner_id, ";
$SQLString .= TABLE_BANNER . ".artikel_id, ";
$SQLString .= "IF(" . TABLE_BANNER . ".language_independent, table_banner_langu_standard.bigImage, " . TABLE_BANNER_LANGU . ".bigImage) AS bigImage, ";
$SQLString .= TABLE_ARTIKEL_LANGU . ".artikel_name, ";
$SQLString .= TABLE_ARTIKEL . ".artikel_nr, ";
$SQLString .= TABLE_ARTIKEL . ".id ";
$SQLString .= "FROM ";
$SQLString .= TABLE_BANNER . " ";
$SQLString .= "LEFT JOIN " . TABLE_ARTIKEL . " ON " . TABLE_BANNER . ".artikel_id = " . TABLE_ARTIKEL . ".id ";
$SQLString .= "LEFT JOIN " . TABLE_ARTIKEL_LANGU . " ON ((IF(" . TABLE_ARTIKEL . ".merkmalkombinationparentid, " . TABLE_ARTIKEL . ".merkmalkombinationparentid, " . TABLE_ARTIKEL . ".id) = " . TABLE_ARTIKEL_LANGU . ".artikel_id) AND (" . TABLE_ARTIKEL_LANGU . ".language_id = " . $LanguageID . ")) ";
$SQLString .= "LEFT JOIN " . TABLE_BANNER_LANGU . " ON ((" . TABLE_BANNER . ".id = " . TABLE_BANNER_LANGU . ".banner_id) AND (" . TABLE_BANNER_LANGU . ".language_id = " . $LanguageID . ")) ";
$SQLString .= "LEFT JOIN " . TABLE_BANNER_LANGU . " table_banner_langu_standard ON ((" . TABLE_BANNER . ".id = table_banner_langu_standard.banner_id) AND (table_banner_langu_standard.language_id = " . $StandardLanguageID . ")) ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
$BannerDataArray = array();
$BannerDataCounter = 0;
while ($BannerRow = mysql_fetch_array($MySQLQueryReference)) {
$BannerDataArray[$BannerDataCounter] = $BannerRow;
if (($BannerRow["bigImage"] != "") && (file_exists(DATEIPFAD . "images/dbimages/" . $BannerRow["bigImage"]))) {
$ImageSizeArray = getimagesize(DATEIPFAD . "images/dbimages/" . $BannerRow["bigImage"]);
$BannerDataArray[$BannerDataCounter]["image_string"] = "\n";
}
$BannerDataCounter++;
}
return $BannerDataArray;
}