query($wpdb->prepare("UPDATE ".AMYLITE_PACKAGES." SET is_pending=0 WHERE id=%d", $_GET['package_id'])); amylite_redirect("admin.php?page=amylite_packages&id=".$_GET['id']); } if(!empty($_REQUEST['add'])) { // select pricing $pricing=$wpdb->get_row($wpdb->prepare("SELECT * FROM ".AMYLITE_PRICINGS." WHERE id=%d", $_REQUEST['pricing_id'])); $is_pending = $is_admin ? 0 : 1; $wpdb->query($wpdb->prepare("INSERT INTO ".AMYLITE_PACKAGES." (campaign_id, zone_id, pricing_id, date_start, date_end, amount, is_pending) VALUES (%d,%d, %d, %s, %s, %d, %d)", $_REQUEST['id'], $_REQUEST['zone_id'], $_REQUEST['pricing_id'], date("Y-m-d"), date("Y-m-d",strtotime("+ ".$pricing->code." days")), $pricing->price, $is_pending)); } if(!empty($_REQUEST['del'])) { $wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_PACKAGES." WHERE id=%d", $_REQUEST['del_id'])); } // select campaign $campaign=$wpdb->get_row($wpdb->prepare("SELECT * FROM ".AMYLITE_CAMPAIGNS." WHERE id=%d", $_REQUEST['id'])); // select pricing plans $pricings=$wpdb->get_results("SELECT * FROM ".AMYLITE_PRICINGS." ORDER BY name"); // select ad zones $zones=$wpdb->get_results("SELECT * FROM ".AMYLITE_ZONES." ORDER BY name"); // select packages $packages=$wpdb->get_results("SELECT tPa.id as id, DATE_FORMAT(tPa.date_start, '%M %e, %Y') as date_start, DATE_FORMAT(tPa.date_end,'%M %e, %Y') as date_end, tP.name as pricing, tZ.name as zone, tPa.is_pending as is_pending FROM ".AMYLITE_PRICINGS." tP, ".AMYLITE_ZONES." tZ, ".AMYLITE_PACKAGES." tPa WHERE tPa.campaign_id='{$campaign->id}' AND tPa.pricing_id=tP.id AND tPa.zone_id=tZ.id ORDER BY tPa.date_end DESC, tPa.id DESC"); ?>

"name?>"