<?php
include("../inc/db.inc");
if (file_exists($bild)) {
$bild_small = $bild . "_small.jpg";
$isize = getimagesize($bild);
if($isize['2'] == 2)
{
$typ = "image/jpeg";
$width = $isize['0'];
$height = $isize['1'];
//if($isize['0'] > $isize['1'])
// {
if($isize['0'] > 190)
exec("djpeg -pnm $bild | pnmscale -xsize 190 | pnmalias | cjpeg -smooth 1 >$bild_small");
else
$bild_small = $bild;
//}
// else
// {
// if($isize['1'] > 190)
// exec("djpeg -pnm $bild | pnmscale -ysize 190 | pnmalias | cjpeg -smooth 1 >$bild_small");
//
// else
// $bild_small = $bild;
//
// }
$fsizesmall=filesize($bild_small);
$bild_small_2=addslashes(fread(fopen($bild_small,"r"),$fsizesmall));
if (file_exists($bild)) {
unlink($bild);
}
if (file_exists($bild_small)) {
unlink($bild_small);
}
}
else
{
$info = "<span class=\"text-titel\">Achtung! Sie haben keine JPEG Datei übertragen! Das Bild wurde nicht gespeichert</SPAN><BR>\n";
$bild = "none";}
}
$kat = mysql_query("SELECT * FROM kategorie WHERE kategorie_de = '$kategorie_de'");
if (mysql_numrows($kat) == 1)
{
$kategorie_de = mysql_result($kat, 0, "kategorie_de");
$kategorie_en = mysql_result($kat, 0, "kategorie_en");
$kategorie_fr = mysql_result($kat, 0, "kategorie_fr");
}
if (($number == 0) || ($number == ""))
{
$result = mysql_query("insert into produkt VALUES('$number','$produktname_de','$produktname_en','$produktname_fr','$sort_id','$artikel_nr','$kategorie_de','$kategorie_en','$kategorie_fr','$beschreibung_de','$beschreibung_en','$beschreibung_fr','$zubehoer_de','$zubehoer_en','$zubehoerfr','$masse','$gewicht','$preis_de','$preis_en','$preis_fr','$bild_small_2')");
}
else
{
if($bild == "none")
{
$result = mysql_query("update produkt set number='$number',produktname_de='$produktname_de',produktname_en='$produktname_en',produktname_fr='$produktname_fr',sort_id='$sort_id',artikel_nr='$artikel_nr',kategorie_de='$kategorie_de',kategorie_en='$kategorie_en',kategorie_fr='$kategorie_fr',beschreibung_de='$beschreibung_de',beschreibung_en='$beschreibung_en',beschreibung_fr='$beschreibung_fr',zubehoer_de='$zubehoer_de',zubehoer_en='$zubehoer_en',zubehoer_fr='$zubehoerfr',masse='$masse',gewicht='$gewicht',preis_de='$preis_de',preis_en='$preis_en',preis_fr='$preis_fr' WHERE number='$number'");
}
else
$result = mysql_query("update produkt set number='$number',produktname_de='$produktname_de',produktname_en='$produktname_en',produktname_fr='$produktname_fr',sort_id='$sort_id',artikel_nr='$artikel_nr',kategorie_de='$kategorie_de',kategorie_en='$kategorie_en',kategorie_fr='$kategorie_fr',beschreibung_de='$beschreibung_de',beschreibung_en='$beschreibung_en',beschreibung_fr='$beschreibung_fr',zubehoer_de='$zubehoer_de',zubehoer_en='$zubehoer_en',zubehoer_fr='$zubehoerfr',masse='$masse',gewicht='$gewicht',preis_de='$preis_de',preis_en='$preis_en',preis_fr='$preis_fr',bild='$bild_small_2' WHERE number='$number'");
}
if ($result == 0)
fail("Der Datensatz enthþlt einen Fehler und konnte NICHT eingefŸgt werden.");
?>
<html>
<head>
<title>MS PROTECT AG</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="daten/font.css">
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v3.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#1F3664" vlink="#1F3664" alink="#1F3664" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" background="images/hintergrund.gif" onLoad="MM_preloadImages('images/hn-home-2.gif','images/hn-info-2.gif','images/hn-datenbanken-2.gif')">
<table width="890" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="50"><img src="images/transparent.gif" width="50" height="20"></td>
<td width="160"> </td>
<td width="680"> </td>
</tr>
<tr valign="top">
<td width="50"> </td>
<td colspan="2"><a href="de/home.html" target="_self"><img src="images/logo-head.gif" width="230" height="41" border="0" alt="Home"></a></td>
</tr>
<tr valign="top">
<td width="50"> </td>
<td colspan="2"><img src="images/linie-840.gif" width="840" height="1"></td>
</tr>
<tr valign="top">
<td height="30"><img src="images/transparent.gif" width="50" height="30"></td>
<td height="30"> </td>
<td width="680"> </td>
</tr>
<tr valign="top">
<td colspan="2">
<table width="195" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td height="30"><img src="images/transparent.gif" width="20" height="30"></td>
<td height="30"> </td>
</tr>
<tr valign="top">
<td height="40" width="20"><img src="images/transparent.gif" width="20" height="40"></td>
<td height="40" width="175"><a href="index.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('HOME','','images/hn-home-2.gif',1)" target="_self"><img name="HOME" border="0" src="images/hn-home-1.gif" width="175" height="30" alt="HOME"></a></td>
</tr>
<tr valign="top">
<td height="40" width="20"><img src="images/transparent.gif" width="20" height="40"></td>
<td height="40" width="175"><a href="info-flowchart.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Info','','images/hn-info-2.gif',1)" target="_self"><img name="Info" border="0" src="images/hn-info-1.gif" width="175" height="30" alt="INFO'S"></a></td>
</tr>
<tr valign="top">
<td height="40" width="20"><img src="images/transparent.gif" width="20" height="40"></td>
<td height="40" width="175"><a href="news-liste.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Datenbanken','','images/hn-datenbanken-2.gif',1)" target="_self"><img name="Datenbanken" border="0" src="images/hn-datenbanken-1.gif" width="175" height="30" alt="DATENBANKEN"></a></td>
</tr>
<tr valign="top">
<td height="20" width="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20" width="175">
<div align="right"><a href="news-liste.php" target="_self"><img src="images/un-editnews.gif" width="160" height="20" border="0" alt="Edit News"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20" width="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20" width="175">
<div align="right"><a href="kategorien-liste.php" target="_self"><img src="images/un-editkategorien.gif" width="160" height="20" border="0" alt="Edit Kategorien"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20" width="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20" width="175">
<div align="right"><a href="produkte-liste.php" target="_self"><img src="images/un-editprodukte.gif" width="160" height="20" border="0" alt="Edit Kategorien"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20" width="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20" width="175">
<div align="right"><a href="occasionen-liste.php" target="_self"><img src="images/un-editoccasionen.gif" width="160" height="20" alt="Edit Occasionen" border="0"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20"><div align="right"><a href="spezial-liste.php" target="_self"><img src="images/un-editspezialangebote.gif" alt="Edit Spezialangebot" width="160" height="20" border="0"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20" width="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20" width="175">
<div align="right"><a href="pdf-liste.php" target="_self"><img src="images/un-editpdfarchiv.gif" width="160" height="20" border="0" alt="Edit PDF-Archiv"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20">
<div align="right"><a href="anleitungen.php" target="_self"><img src="images/un-editanleitungen.gif" width="160" height="20" border="0" alt="Edit Gebrauchsanleitungen"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20" width="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20" width="175">
<div align="right"><a href="galerie-liste.php" target="_self"><img src="images/un-editgalerie.gif" width="160" height="20" border="0" alt="Edit Fotogalerie"></a></div>
</td>
</tr>
<tr valign="top">
<td height="20"><img src="images/transparent.gif" width="20" height="20"></td>
<td height="20">
<div align="right"><a href="angebot.php" target="_self"><img src="images/un-angebot.gif" width="160" height="20" border="0" alt="Edit Angebot"></a></div>
</td>
</tr>
</table>
</td>
<td width="680">
<table width="680" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td colspan="19" height="30"><img src="images/ht-datenbanken.gif" width="680" height="30"></td>
</tr>
<tr valign="top">
<td height="30"> </td>
<td colspan="18" height="30"><img src="images/ut-editprodukt.gif" width="630" height="30"></td>
</tr>
<tr valign="top">
<td width="50"><img src="images/transparent.gif" width="50" height="20"></td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr valign="top">
<td width="50"> </td>
<td width="20"> </td>
<td colspan="17" class="text">
<div align="left">Der Eintrag wurde eingefügt/übernommen.<br>
<br>
</div>
</td>
</tr>
<tr valign="top">
<td width="50"> </td>
<td width="20"> </td>
<td colspan="5" class="text"><a href="produkte-liste.php" class="text-link">zurück</a></td>
<td class="text"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td class="text"> </td>
<td class="text"> </td>
<td class="text"> </td>
<td class="text"> </td>
<td class="text"> </td>
<td class="text"> </td>
</tr>
<tr valign="top">
<td width="50"><img src="images/transparent.gif" width="50" height="20"></td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
</tr>
<tr valign="top">
<td width="50"> </td>
<td colspan="18"><img src="images/linie-630.gif" width="630" height="1"></td>
</tr>
<tr valign="top">
<td width="50"><img src="images/transparent.gif" width="50" height="10"></td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
<td width="20"> </td>
<td width="50"> </td>
</tr>
<tr>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
<td width="20"><img src="images/transparent.gif" width="20" height="1"></td>
<td width="50"><img src="images/transparent.gif" width="50" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>