query($wpdb->prepare("INSERT INTO ".AMYLITE_ZONES." (name, description, width, height)
VALUES (%s,%s, %d, %d)",
$_REQUEST['name'], $_REQUEST['description'], $_REQUEST['width'], $_REQUEST['height']));
$id=$wpdb->insert_id;
if(!empty($_POST['plan_ids']))
{
foreach($_POST['plan_ids'] as $plan)
{
$wpdb->query($wpdb->prepare("INSERT INTO ".AMYLITE_PRICING_ZONES." (pricing_id, zone_id)
VALUES (%d, %d)", $plan, $id));
}
}
}
if(!empty($_REQUEST['save']))
{
$wpdb->query($wpdb->prepare("UPDATE ".AMYLITE_ZONES."
SET name=%s, description=%s, width=%d, height=%d
WHERE id=%d",
$_REQUEST['name'], $_REQUEST['description'],
$_REQUEST['width'], $_REQUEST['height'], $_REQUEST['id']));
$wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_PRICING_ZONES."
WHERE zone_id=%d", $_REQUEST['id']));
if(!empty($_POST['plan_ids']))
{
foreach($_POST['plan_ids'] as $plan)
{
$wpdb->query($wpdb->prepare("INSERT INTO ".AMYLITE_PRICING_ZONES." (pricing_id, zone_id)
VALUES (%d, %d)", $plan, $_REQUEST['id']));
}
}
}
if(!empty($_REQUEST['del']))
{
$wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_ZONES." WHERE id=%d", $_REQUEST['id']));
$wpdb->query($wpdb->prepare("DELETE FROM ".AMYLITE_PRICING_ZONES."
WHERE zone_id=%d", $_REQUEST['id']));
}
// select zones
$zones=$wpdb->get_results("SELECT * FROM ".AMYLITE_ZONES." ORDER BY name");
// select pricing plans assigned to each zone
foreach($zones as $cnt=>$zone)
{
$plans=$wpdb->get_results($wpdb->prepare("SELECT * FROM ".AMYLITE_PRICING_ZONES."
WHERE zone_id=%d ORDER BY id", $zone->id));
$plan_ids=array();
foreach($plans as $plan) $plan_ids[]=$plan->pricing_id;
$zones[$cnt]->plans=$plan_ids;
}
// slect all pricing plans
$plans=$wpdb->get_results("SELECT * FROM ".AMYLITE_PRICINGS." ORDER BY name");
?>
shortcode in each ad zone. You need to insert it in the place where you want the ads from the zone to appear. In case you are inserting it in the theme file, you have to use the do_shortcode() call.', 'amylite')?>