"; print ""; print ""; print "

Möchten Sie das Bauteil "". lookup_part_name ($_REQUEST["pid"]) ."" wirklich löschen?

"; print ""; print ""; print "

Der Löschvorgang ist irreversibel!

"; } else if (isset($_REQUEST["del_ok"])) { /* the user said it's OK to delete the part ... */ // no LIMIT here because every part can have multiple datasheets $query = "DELETE FROM datasheets WHERE part_id=". smart_escape($_REQUEST["pid"]) .";"; debug_print ($query); mysql_query ($query); $query = "DELETE FROM parts WHERE id=". smart_escape($_REQUEST["pid"]). " LIMIT 1"; debug_print ($query); mysql_query ($query); $special_dialog = 1; print ""; } } else if ( strcmp ($_REQUEST["action"], "img_mgr") == 0 ) { /* * Set the default ("master") picture. * The master picture is the picture whose thumbnail * is shown in the part list. */ if (isset($_REQUEST["default_img"])) { $query = "UPDATE pictures SET pict_masterpict=0 WHERE part_id=". smart_escape($_REQUEST["pid"]) .";"; debug_print ($query); mysql_query ($query); $query = "UPDATE pictures SET pict_masterpict=1 WHERE id=". smart_escape($_REQUEST["default_img"]) .";"; debug_print ($query); mysql_query ($query); } /* check if the user wants to delete an image */ if (isset($_REQUEST["del_img"])) { $img_del_id_array = $_REQUEST["del_img"]; if ((! isset($_REQUEST["del_ok"])) && (! isset($_REQUEST["del_nok"])) ) { /* print the confirmation text */ $special_dialog = 1; print ""; print ""; print ""; print "

Möchten Sie das ausgewählte Bild/die ausgewählen Bilder wirklich löschen?

"; print "

Der Löschvorgang ist irreversibel!

"; } print "

"; } else if (isset($_REQUEST["del_ok"])) { /* user OK'd the action ...*/ for ($i = 0; $i < count($img_del_id_array); $i++) { // delete only the images, the thumbsnails will expire automatically $query = "DELETE FROM pictures WHERE id=". smart_escape($img_del_id_array[$i]) ." LIMIT 1;"; debug_print ($query); mysql_query ($query); } } } } else if ( strcmp ($_REQUEST["action"], "img_add") == 0 ) { if (is_uploaded_file($_FILES['uploaded_img']['tmp_name'])) { /* * split the file name into its parts and create * a unique filename. */ $a = explode(".",$_FILES['uploaded_img']['name']); $fname = "img_"; $fname .= md5_file($_FILES['uploaded_img']['tmp_name']); if (($a[count($a)-1] == "jpg") || ($a[count($a)-1] == "jpg")) { $fname .= ".jpg"; } else if ($a[count($a)-1] == "gif") { $fname .= ".gif"; } else if ($a[count($a)-1] == "png") { $fname .= ".png"; } // FIXME: Some error handling required (for example: // unknown file type etc. pp. move_uploaded_file($_FILES['uploaded_img']['tmp_name'], "img/".$fname); chmod ("img/" .$fname, 0775); $query = "INSERT INTO pictures (part_id,pict_fname) VALUES (". smart_escape($_REQUEST["pid"]) .",". smart_escape($fname) .")"; debug_print($query); mysql_query($query); } } else if ( strcmp ($_REQUEST["action"], "price_del") == 0 ) { /* * If everythink is OK (DB consistency, no bugs in the * software, ...) every part only has one price "tag". * So we add LIMIT 1 to protect from run-away queries. */ $query = "DELETE FROM preise WHERE part_id=". smart_escape($_REQUEST["pid"]) ." LIMIT 1;"; debug_print($query); mysql_query($query); } else if ( strcmp ($_REQUEST["action"], "price_add") == 0 ) { /* * See if the price is a valid (floating point) number ... * Actually this code snippet only checks for the beginning, * not the entire text. I'm no RegEx expert, so maybe someone * could replace this with a better one! * (http://www.regular-expressions.info/floatingpoint.html) */ if (ereg("^[-+]?[0-9]*\.?[0-9]+", $_REQUEST["price"]) == true) { $_REQUEST["price"] = str_replace(',', '.', $_REQUEST["price"]); /* Before adding the new price, delete the old one! */ $query = "DELETE FROM preise WHERE part_id=". smart_escape($_REQUEST["pid"]) ." LIMIT 1;"; debug_print($query); mysql_query($query); $query = "INSERT INTO preise (part_id,ma,preis,t) VALUES (". smart_escape($_REQUEST["pid"]) .", 1, ". smart_escape($_REQUEST["price"]) .", NOW());"; debug_print($query); mysql_query($query); } } if ($special_dialog == 0) { ?>

Ändere Detailinfos von ""

"> "; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } ?> "; else print ""; // do the same for the next level. buildtree ($d[0], $level + 1, $select); } } // determine category $query = "SELECT id_category FROM parts WHERE id=". $_REQUEST["pid"] .";"; $r = mysql_query($query); if (mysql_num_rows($r) > 0) { $d = mysql_fetch_row($r); $cat = $d[0]; } else $cat = 0; ?>

Name:
Vorhanden:
Min. Bestand:
Footprint:
Lagerort:
Lieferant:
Bestell-Nr.:
Kommentar:	". smart_unescape($d[8]) ."

Kategorie: ">

Preisinfos

0) { /* * There's some information in the table ... * Because we assume that only one entry is possible, * we display the manual entry, if there's one manual * and one automatically added entry entry. */ $d = mysql_fetch_row($r); $d[1] = str_replace('.', ',', $d[1]); print "Preis: ". smart_unescape($d[1]); if ($d[2] == 1) { //print " (manuell)"; print " €"; } } else { print "Keine Preisinfos vorhanden!"; } ?>

Bilder

"; print ""; print ""; print ""; print ""; } ?>

Bilder
">
	"Master-Bild"	Löschen


Hier können Sie Bilder hochladen. Im Moment werden nur JPG Dateien unterstützt. ">

Datenblätter

Hinweis:
Wenn das Datenblatt unter C:\datasheets\foo.pdf zu finden ist, geben Sie als URL file:///C:/datasheets/foo.pdf an! Dies scheint allerdings nicht mit allen Browser-Versionen und Acrobat-Reader-Versionen zu funktionieren.

Bauteiel Löschen

Der Löschvorgang ist nicht rückgängig zu machen!