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>