root/trunk/gui/admin/hosting_plan_delete.php

<?php
/**
 * ispCP ω (OMEGA) a Virtual Hosting Control System
 *
 * @copyright     2001-2006 by moleSoftware GmbH
 * @copyright     2006-2008 by ispCP | http://isp-control.net
 * @version     SVN: $Id$
 * @link         http://isp-control.net
 * @author         ispCP Team
 *
 * @license
 *   This program is free software; you can redistribute it and/or modify it under
 *   the terms of the MPL General Public License as published by the Free Software
 *   Foundation; either version 1.1 of the License, or (at your option) any later
 *   version.
 *   You should have received a copy of the MPL Mozilla Public License along with
 *   this program; if not, write to the Open Source Initiative (OSI)
 *   http://opensource.org | osi@opensource.org
 */

require '../include/ispcp-lib.php';

check_login(__FILE__);

if (strtolower(Config::get('HOSTING_PLANS_LEVEL')) != 'admin') {
    header('Location: index.php');
    die();
}


if(isset($_GET['hpid']) && is_numeric($_GET['hpid']))
    $hpid = $_GET['hpid'];
else {
    $_SESSION['hp_deleted'] = '_no_';
    Header('Location: hosting_plan.php');
    die();
}

// Check if there is no order for this plan
$res = exec_query($sql, "SELECT COUNT(id) FROM `orders` WHERE `plan_id`=? AND `status`='new'", array($hpid));
$data = $res->FetchRow();
if ($data['0'] > 0) {
    $_SESSION['hp_deleted_ordererror'] = '_yes_';
    header("Location: hosting_plan.php");
    die();
}

// Try to delete hosting plan from db
$query = 'delete from hosting_plans where id = ?';
$res = exec_query($sql, $query, array($hpid));

$_SESSION['hp_deleted'] = '_yes_';

header('Location: hosting_plan.php');
die();

?>