0) {
if(!file_exists(DATEIPFAD . "images/dbimages/slider")) {
mkdir(DATEIPFAD . "images/dbimages/slider");
chmod(DATEIPFAD . "images/dbimages/slider", 0777);
}
$NewImageName = sprintf("%07d", $SliderID);
// altes Bild löschen
unlink_wc(DATEIPFAD . "images/dbimages/slider/", $NewImageName . ".*");
// temporäre Datei kopieren
$TempNameArray = explode(".", $ImageArray["name"]);
$NewImageName = $NewImageName . "." . $TempNameArray[count($TempNameArray) - 1];
move_uploaded_file($ImageArray["tmp_name"], DATEIPFAD . "images/dbimages/slider/" . $NewImageName);
chmod(DATEIPFAD . "images/dbimages/slider/" . $NewImageName, 0777);
// Datenbank updaten
$SQLString = "UPDATE " . TABLE_SLIDER . " SET ";
$SQLString .= TABLE_SLIDER . ".bigImage = '" . $NewImageName . "' ";
$SQLString .= " WHERE ";
$SQLString .= TABLE_SLIDER . ".sliderid = '" . $SliderID . "' ";
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
}
}
function GetSliderDetail($SliderID) {
$SQLString = "SELECT ";
$SQLString .= TABLE_SLIDER . ".sliderid, ";
$SQLString .= TABLE_SLIDER . ".kategorieid, ";
$SQLString .= TABLE_SLIDER . ".url, ";
$SQLString .= TABLE_SLIDER . ".bigImage ";
$SQLString .= "FROM ";
$SQLString .= TABLE_SLIDER . " ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_SLIDER . ".sliderid = '" . $SliderID . "' ";
$SliderObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
if (($SliderObject->bigImage != "") && (file_exists(DATEIPFAD . "images/dbimages/slider/" . $SliderObject->bigImage))) {
$ImageSizeArray = getimagesize(DATEIPFAD . "images/dbimages/slider/" . $SliderObject->bigImage);
$SliderObject->image_string = "![](\"")
bigImage . "\" border=\"1\" width=\"" . $ImageSizeArray[0] . "\" height=\"" . $ImageSizeArray[1] . "\">\n";
$SliderObject->image_admin_string = "bigImage . "\" border=\"1\" width=\"150\">\n";
}
// echo '';
// var_dump($SliderObject);
// echo '
';
return $SliderObject;
}
function DeleteSlider($SliderID = "") {
// Slider
if ($SliderID) {
$SQLString = "SELECT ";
$SQLString .= TABLE_SLIDER . ".sliderid ";
$SQLString .= "FROM ";
$SQLString .= TABLE_SLIDER . " ";
$SQLString .= "WHERE ";
$SQLString .= TABLE_SLIDER . ".sliderid = '" . $SliderID . "' ";
$TempSliderObject = mysql_fetch_object(errorlogged_mysql_query($SQLString));
$SliderID = $TempSliderObject->sliderid;
}
$SQLString = "DELETE FROM " . TABLE_SLIDER . " WHERE sliderid = '" . $SliderID . "'";
$MySQLQuerryReferenz = errorlogged_mysql_query($SQLString);
// Bilder loeschen
$ImageName = sprintf("%07d", $SliderID) . "*";
unlink_wc(DATEIPFAD . "images/dbimages/slider/", $ImageName . ".*");
}
function GetSliderDataArray($KategorieID = "") {
$SQLString = "SELECT ";
$SQLString .= TABLE_SLIDER . ".sliderid, ";
$SQLString .= TABLE_SLIDER . ".url, ";
$SQLString .= TABLE_SLIDER . ".kategorieid, ";
$SQLString .= TABLE_SLIDER . ".bigImage ";
$SQLString .= "FROM ";
$SQLString .= TABLE_SLIDER . " ";
if($KategorieID != "") {
$SQLString .= "WHERE " . TABLE_SLIDER . ".kategorieid = '" . $KategorieID . "' ";
} else {
$SQLString .= "WHERE " . TABLE_SLIDER . ".kategorieid = '0' ";
}
$MySQLQueryReference = errorlogged_mysql_query($SQLString);
$SliderDataArray = array();
$SliderDataCounter = 0;
while ($SliderRow = mysql_fetch_array($MySQLQueryReference)) {
$SliderDataArray[$SliderDataCounter] = $SliderRow;
if (($SliderRow["bigImage"] != "") && (file_exists(DATEIPFAD . "images/dbimages/slider/" . $SliderRow["bigImage"]))) {
$ImageSizeArray = getimagesize(DATEIPFAD . "images/dbimages/slider/" . $SliderRow["bigImage"]);
$SliderDataArray[$SliderDataCounter]["image_string"] = "\n";
$SliderDataArray[$SliderDataCounter]["admin_image_string"] = "\n";
}
$SliderDataCounter++;
}
return $SliderDataArray;
}