array(
"Back to quotas" => "quotas-main.php",
),
));
# Display delete confirm screen
if ($_POST['frmaction'] == "delete") {
# Check a quota was selected
if (isset($_POST['quota_id'])) {
?>
No quota selected
query("
SELECT
ID
FROM
${DB_TABLE_PREFIX}quotas_limits
WHERE
QuotasID = ".$db->quote($_POST['quota_id'])."
");
$limitIDs = array();
if ($res !== FALSE) {
# Pull in limit ID's
while ($row = $res->fetchObject()) {
array_push($limitIDs,$row->id);
}
$res->closeCursor();
} else {
?>
Error selecting quota limit IDs!
errorInfo()) ?>
beginTransaction();
$stmt = $db->prepare("
DELETE FROM
${DB_TABLE_PREFIX}quotas_tracking
WHERE
QuotasLimitsID = ?
");
# Loop with limit ID's, start off true
$res = true;
foreach ($limitIDs as $id) {
$res = $stmt->execute(array($id));
}
if ($res !== FALSE) {
?>
Quota tracking info deleted
Error deleting quota tracking info!
errorInfo()) ?>
rollBack();
}
}
# Check last query succeeded, if so continue
if ($res !== FALSE) {
$stmt = $db->prepare("
DELETE FROM
${DB_TABLE_PREFIX}quotas_limits
WHERE
QuotasID = ?"
);
$res = $stmt->execute(array($_POST['quota_id']));
if ($res !== FALSE) {
?>
Quota limits deleted
Error deleting quota limits!
errorInfo()) ?>
rollBack();
}
}
# Check last query succeeded, if so continue
if ($res !== FALSE) {
$res = $db->exec("DELETE FROM ${DB_TABLE_PREFIX}quotas WHERE ID = ".$db->quote($_POST['quota_id']));
if ($res) {
?>
Quota deleted
Error deleting quota!
errorInfo()) ?>
rollBack();
}
}
# Commit if last transaction succeeded
if ($res) {
$db->commit();
}
} else {
?>
Quota not deleted, aborted by user
Invocation error, no quota ID
Invalid invocation