$query = $sql->prepare("delete from products where upc = ? and description=?");
$args = array($upc, $desc);
//echo $query;
//return;
} else {
$query = $sql->prepare("delete from products where upc = ?");
$args = array($upc);
}
//echo $query;
$result = $sql->execute($query, $args);
$extraQ = $sql->prepare("delete from prodExtra where upc=?");
$extraR = $sql->execute($extraQ, array($upc));
if (isset($_POST["scale_delete"]) && $_POST["scale_delete"] == "on") {
$plu = substr($upc, 3, 4);
include "hobartcsv/parse.php";
deleteitem($plu);
}
echo "<script language=JavaScript>";
// reloading opener works in Firefox, not in Safari (loses POST data)
//echo "opener.location.reload();";
echo "close();";
echo "</script>";
} else {
if (isset($_POST['No'])) {
echo "<script language=JavaScript>";
echo "close();";
echo "</script>";
} else {
$upc = $_GET['upc'];
echo "Are you sure you want to delete item {$upc}";
if (isset($_GET['description'])) {
return $so->idscorm_organization;
}
}
if (isset($GLOBALS['op'])) {
switch ($GLOBALS['op']) {
/*case "display": {
display();
}; break;*/
case "additem":
additem();
break;
case "insitem":
insitem();
break;
case "deleteitem":
deleteitem();
break;
case "dodelete":
dodelete();
break;
case "category":
category();
break;
case "categorysave":
categorysave();
break;
case "play":
play();
break;
case "tree":
require dirname(__FILE__) . '/scorm_page_tree.php';
getprivilages();
break;
case 'getquota':
getquota();
break;
case 'getitems':
getitems($_POST['playlistid']);
break;
case 'uploaditemfile':
uploaditemfile($_FILES['file'], $_POST['playlistid']);
break;
case 'createitementry':
createitementry($_POST['name'], $_POST['title'], $_POST['description'], $_POST['type'], $_POST['playlistid']);
break;
case 'deleteitem':
deleteitem($_POST['itemid']);
break;
case 'getplaylistitems':
getplaylistitems();
break;
case 'uploadplaylistfile':
uploadplaylistfile($_POST['playlistid'], $_FILES['file']);
break;
case 'createplaylistentry':
createplaylistentry($_POST['name'], $_POST['description'], $_POST['thumbname']);
break;
case 'deleteplaylist':
deleteplaylist($_POST['playlistid']);
break;
case 'editplaylistentry':
editplaylistentry($_POST['id'], $_POST['name'], $_POST['description'], $_POST['thumbname']);
include 'parse.php';
if (!class_exists("SQLManager")) {
require_once "../../sql/SQLManager.php";
}
include '../../db.php';
$fetchQ = "select plu from scaleItems where plu='0027985000000'";
$fetchR = $sql->query($fetchQ);
$plus = array();
$i = 0;
while ($fetchW = $sql->fetch_array($fetchR)) {
preg_match("/002(\\d\\d\\d\\d)0/", $fetchW[0], $matches);
$plu = $matches[1];
if (!empty($plu)) {
$plus[$i] = $plu;
$i++;
}
}
deleteitem($plus, $_GET['scale']);
echo "Item delete requested";
} else {
echo "<form action=delete.php method=get>";
echo "<select name=scale>";
$i = 0;
foreach ($scale_ips as $s) {
echo "<option value={$i}>{$s}</option>";
$i++;
}
echo "</select>";
echo "<input type=submit value=Delete />";
echo "</form>";
}
