function update_item($picture_small, $picture_large)
{
global $_TABLES;
global $_CONF;
$error = check_data();
if ($error == "") {
//Upload file check to see if a file needs to be deleted
$picture_res = DB_query("SELECT ecom_item_picture_small, ecom_item_picture_large FROM {$_TABLES['ecom_item']} WHERE ecom_item_id = " . $_GET['id'] . "");
$picture_row = DB_fetchArray($picture_res);
//Small picture
if ($picture_row['ecom_item_picture_small'] != "" && $picture_small != "") {
$old_picture = $_CONF['path_html'] . "ecommerce/images/item/" . $picture_row['ecom_item_picture_small'];
unlink($old_picture);
//delete old picture
}
if ($picture_small != "") {
$error .= upload_picture(&$picture_small, false);
//Update database
DB_query("UPDATE {$_TABLES['ecom_item']} SET ecom_item_picture_small = '" . $picture_small . "' WHERE ecom_item_id = " . $_GET['id'] . "");
}
//Large Picture
if ($picture_row['ecom_item_picture_large'] != "" && $picture_large != "") {
$old_picture = $_CONF['path_html'] . "ecommerce/images/item/" . $picture_row['ecom_item_picture_large'];
unlink($old_picture);
//delete old picture
}
if ($picture_large != "") {
$error .= upload_picture(&$picture_large, true);
//Update database
DB_query("UPDATE {$_TABLES['ecom_item']} SET ecom_item_picture_large = '" . $picture_large . "' WHERE ecom_item_id = " . $_GET['id'] . "");
}
if ($_POST['fixxedPrice'] == "") {
$fPrice = false;
} else {
$fPrice = true;
}
if ($_POST['ship_printed'] == "") {
$ship_printed = false;
} else {
$ship_printed = true;
}
if ($_POST['ship_media'] == "") {
$ship_media = false;
} else {
$ship_media = true;
}
if ($_POST['ship_library'] == "") {
$ship_library = false;
} else {
$ship_library = true;
}
if ($_POST['free_shipping'] == "") {
$free_shipping = false;
} else {
$free_shipping = true;
}
DB_query("UPDATE {$_TABLES['ecom_item']} SET ecom_item_name = '" . $_POST['name'] . "', ecom_item_description_short = '" . $_POST['description_short'] . "', ecom_item_description_long = '" . $_POST['description_long'] . "', ecom_item_ship_printed = '" . $ship_printed . "', ecom_ship_media = '" . $ship_media . "', ecom_ship_library = '" . $ship_library . "', ecom_item_url = '" . $_POST['item_url'] . "', ecom_item_price = '" . $_POST['price'] . "', ecom_item_instock = '" . $_POST['inStock'] . "', ecom_item_priceFixxed = '" . $fPrice . "', ecom_item_weight_ounces = '" . $_POST['weight_ounces'] . "', ecom_item_weight_pounds = '" . $_POST['weight_pounds'] . "', ecom_item_width = '" . $_POST['dem_width'] . "', ecom_item_height = '" . $_POST['dem_height'] . "', ecom_item_length = '" . $_POST['dem_length'] . "', ecom_free_shipping = '" . $free_shipping . "' WHERE ecom_item_id = " . $_GET['id'] . "");
echo "<SCRIPT language=\"JavaScript\"> window.location='?op=item&view=list' </SCRIPT>";
}
return $error;
}
<script src="..js/caption.js"></script>
<script src="..js/modal.js"></script>
<script type="text/javascript" src="http://js.nicedit.com/nicEdit-latest.js"></script>
<script src="js/jquery.js"></script>
<script src="../js/bootstrap-datepicker.js"></script>
<script type="text/javascript">
$(window).load(function(){
$('#automodal').modal('show');
});
</script>
</head>
<body>
<?php
echo upload_picture();
echo update_ket();
echo add_post();
echo add_dana();
echo add_acara();
echo add_rapat();
echo add_donasi();
?>
<div id="wrapper">
<!-- Navigation -->
<nav class="navbar navbar-default navbar-fixed-top" role="navigation">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<a class="navbar-brand" href="index.php" id="nav-pandan">KATAR 06</a>
