<?php
include("$DOCUMENT_ROOT/inc/db_data.inc");
$re15 = mysql_query("SELECT * FROM kunstwerke ODRER BY id DESC Limit 1");
while($ro15 = mysql_fetch_array($re15))
	{
	$nr = $ro15[id]+1;
	}
if($UPLOADPIC == NULL)
	{
	$bild_g = "/img/bild_g/dontknow.gif";
	$bild_k = "/img/bild_k/dontknow.gif";
	$bild_m = "/img/bild_m/dontknow.gif";
	}
else
	{
	// Bild klein
	$K_MB = 138;
	$K_MH = 148;
	// Bild mittel
	$M_MB = 238;
	$M_MH = 248;
	// Bild gross
	$G_MB = 338;
	$G_MH = 348;
	$k_size = getimagesize ("$UPLOADPIC");
	$m_size = getimagesize ("$UPLOADPIC");
	$g_size = getimagesize ("$UPLOADPIC");
	$K_UPLOADPIC = "$UPLOADPIC";
	$M_UPLOADPIC = "$UPLOADPIC";
	$G_UPLOADPIC = "$UPLOADPIC";
    // Verarbeitung kleines Bild
    if ($k_size[0] < $K_MB)
    	{
        $K_NB = $k_size[0];
        $K_NH  = $k_size[1];
    	}
    else
    	{
        $KProportionFaktor = $k_size[0] / $K_MB;
        $K_NB = $K_MB;
        $K_NH  = round($k_size[1] / $KProportionFaktor);
    	}
    // Verarbeitung mittel Bild
    if ($m_size[0] < $M_MB)
    	{
        $M_NB = $m_size[0];
        $M_NH  = $m_size[1];
    	}
    else
    	{
        $MProportionFaktor = $m_size[0] / $M_MB;
        $M_NB = $M_MB;
        $M_NH  = round($m_size[1] / $MProportionFaktor);
    	}
	// Verarbeitung grosses Bild
    if ($g_size[0] < $G_MB)
    	{
        $G_NB = $g_size[0];
        $G_NH  = $g_size[1];
    	}
    else
    	{
        $GProportionFaktor = $g_size[0] / $G_MB;
        $G_NB = $G_MB;
        $G_NH  = round($g_size[1] / $GProportionFaktor);
    	}
	// Verarbeitung kleines Bild
    if ($K_NH < $K_MH)
    	{
    	}
    else
    	{
        $KProportionFaktor = $K_NH / $K_MH;
        $K_NH = $K_MH;
        $K_NB  = round($K_NB / $KProportionFaktor);
    	}
	// Verarbeitung mittelers Bild
    if ($M_NH < $M_MH)
    	{
    	}
    else
    	{
        $MProportionFaktor = $M_NH / $M_MH;
        $M_NH = $M_MH;
        $M_NB  = round($M_NB / $MProportionFaktor);
    	}
    // Verarbeitung grosses Bild
    if ($G_NH < $G_MH)
    	{
    	}
    else
    	{
        $GProportionFaktor = $G_NH / $G_MH;
        $G_NH = $G_MH;
        $G_NB  = round($G_NB / $GProportionFaktor);
    	}
	// Verarbeitung kleines Bild
    if ($k_size[0] == $K_NB && $k_size[1] == $K_NH)
    	{
    	$UPLOADPIC_name = "$UPLOADPIC_name";
    	$bild_k = "/img/bild_k/$UPLOADPIC_name";
        copy ($K_UPLOADPIC, "$DOCUMENT_ROOT/img/bild_k/$UPLOADPIC_name");
    	}
    else
    	{
        $UPLOADPIC_name = "$UPLOADPIC_name";
        $bild_k = "/img/bild_k/$UPLOADPIC_name";
        $td_k=imageCreate($K_NB, $K_NH);
        $ts_k=imageCreateFromJPEG($K_UPLOADPIC);
        imagecopyresized($td_k, $ts_k, 0, 0, 0, 0, $K_NB, $K_NH, $k_size[0], $k_size[1]);
        imagejpeg($td_k,"$DOCUMENT_ROOT/img/bild_k/$UPLOADPIC_name");
    	}
	// Verarbeitung mittlers Bild
    if ($m_size[0] == $M_NB && $m_size[1] == $M_NH)
    	{
    	$UPLOADPIC_name = "$UPLOADPIC_name";
    	$bild_m = "/img/bild_m/$UPLOADPIC_name";
        copy ($M_UPLOADPIC, "$DOCUMENT_ROOT/img/bild_m/$UPLOADPIC_name");
    	}
    else
    	{
        $UPLOADPIC_name = "$UPLOADPIC_name";
        $bild_m = "/img/bild_m/$UPLOADPIC_name";
        $td_m=imageCreate($M_NB, $M_NH);
        $ts_m=imageCreateFromJPEG($M_UPLOADPIC);
        imagecopyresized($td_m, $ts_m, 0, 0, 0, 0, $M_NB, $M_NH, $m_size[0], $m_size[1]);
        imagejpeg($td_m,"$DOCUMENT_ROOT/img/bild_m/$UPLOADPIC_name");
    	}
	// Verarbeitung grosses Bild
    if ($g_size[0] == $G_NB && $g_size[1] == $G_NH)
    	{
    	$UPLOADPIC_name = "$UPLOADPIC_name";
        copy ($G_UPLOADPIC, "$DOCUMENT_ROOT/img/bild_m/$UPLOADPIC_name");
    	}
    else
    	{
        $UPLOADPIC_name = "$UPLOADPIC_name";
        $bild_g = "/img/bild_g/$UPLOADPIC_name";
        $td_g=imageCreate($G_NB, $G_NH);
        $ts_g=imageCreateFromJPEG($G_UPLOADPIC);
        imagecopyresized($td_g, $ts_g, 0, 0, 0, 0, $G_NB, $G_NH, $g_size[0], $g_size[1]);
        imagejpeg($td_g,"$DOCUMENT_ROOT/img/bild_g/$UPLOADPIC_name");
    	}
	}
// Artikel in der Datenbank eintragen.
$res2 = mysql_query("INSERT kunstwerke (id, k_id, bild_g, bild_k, bild_m, titel, preis, format, maltechnik, kauf)
                  VALUES ('$nr', '$k_id', '$bild_g', '$bild_k', '$bild_m', '$title', '$preis', '$format', '$maltechnik', '0')")or die(mysql_error());
$num = mysql_affected_rows();
if ($num>0)
	{
	header("Location: eintragen.kunstwerke.php");
	}
else
	{
	?>
	<html>
	<head>
	<meta http-equiv="Content-Language" content="de">
	<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
	<meta name="GENERATOR" content="PFE 32">
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<title>CMS-Bereich</title>
	</head>
	<body bgcolor="<?php echo"$bgc";?>" link="<?php echo"$sfl";?>" alink="<?php echo"$sfa";?>" vlink="<?php echo"$sfb";?>">
	<font face="<?php echo"$ff";?>" size='2' color="#red">Es ist ein Fehler aufgetretten."<?php echo"mysql_error()";?></font><p></font><p>
	</body>
	</html>
	<?php
	}
?>