".__("Banner Updated!", "admangler")."

"; if (isset($_GET['action'])) { if( 0 == strcmp('new', $_GET['action'])) { $list = false; if (isset($_POST['save'])) { $table = $adMangler->adsTable; $data = array('width' => $_POST['width'],'height' => $_POST['height'],'active' => $_POST['active'],'approved' => $_POST['approved'],'type' => $_POST['type'],'code' => $_POST['code'],'href' => $_POST['href'],'advertiser' => $_POST['advertiser'],'base' => $_POST['base'],'src' => $_POST['src']); $format = array('%d','%d','%d','%d','%s','%s','%s','%s','%d','%s'); $wpdb->insert($table, $data, $format); $insert_id = $wpdb->insert_id; echo $message; $sql = "SELECT * FROM $adMangler->adsTable WHERE id=$insert_id"; $banner = $wpdb->get_row($sql); echo $adMangler->format_ad($banner); // This is a bug fix to prevent duplicate ads being created $action = str_replace("new", "edit", $action); $action .= "&id=$insert_id"; $assoc = array(); $i=0; if (is_array($_POST['pageID'])) { foreach ($_POST['pageID'] as $id) { $assoc[] = array('ad_ID'=>$insert_id, 'page_id'=>$id, 'page_exclusive'=>$_POST['pagex'][$i], 'custom_slot'=>$_POST['cslot'][$i], 'slot'=>$_POST['slot'][$i], 'slot_exclusive'=>$_POST['slotx'][0] ); $i++; } } $table = $adMangler->positionsTable; $format = array('%d','%d','%d','%d','%d','%d'); foreach ($assoc as $data) $wpdb->insert($table, $data, $format); $sql = "SELECT * FROM $adMangler->positionsTable WHERE ad_id=".intval($insert_id)." ORDER BY page_id ASC"; $banner->positions = $wpdb->get_results($sql); } } else if (0 == strcmp('delete', $_GET['action']) && isset($_GET['id'])) { $sql = "DELETE FROM $adMangler->adsTable WHERE id=".intval($_GET['id']); $wpdb->query($sql); $list = true; } else if (0 == strcmp('edit', $_GET['action']) && isset($_GET['id'])) { $list = false; if (isset($_POST['save'])) { $table = $adMangler->adsTable; $data = array('width' => $_POST['width'],'height' => $_POST['height'],'active' => $_POST['active'],'approved' => $_POST['approved'],'type' => $_POST['type'],'code' => $_POST['code'],'href' => $_POST['href'],'advertiser' => $_POST['advertiser'],'base' => $_POST['base'],'src' => $_POST['src']); $format = array('%d','%d','%d','%d','%s','%s','%s','%s','%d','%s'); $where = array('id' => $_GET['id']); $where_format = array('%d'); $wpdb->update($table, $data, $where, $format, $where_format); $wpdb->query("DELETE FROM $adMangler->positionsTable WHERE ad_id={$_GET['id']}"); $assoc = array(); $i=0; if (is_array($_POST['pageID'])) { foreach ($_POST['pageID'] as $id) { $assoc[] = array('ad_ID'=>$_GET['id'], 'page_id'=>$id, 'page_exclusive'=>$_POST['pagex'][$i], 'custom_slot'=>$_POST['cslot'][$i], 'slot'=>$_POST['slot'][$i], 'slot_exclusive'=>$_POST['slotx'][0] ); $i++; } } $table = $adMangler->positionsTable; $format = array('%d','%d','%d','%d','%d','%d'); foreach ($assoc as $data) $wpdb->insert($table, $data, $format); echo $message; } } if (isset($_GET['id'])) { $sql = "SELECT * FROM $adMangler->adsTable WHERE id=".intval($_GET['id']); $banner = $wpdb->get_row($sql); $sql = "SELECT * FROM $adMangler->positionsTable WHERE ad_id=".intval($_GET['id'])." ORDER BY page_id ASC"; $banner->positions = $wpdb->get_results($sql); echo $adMangler->format_ad($banner); } } if (!$list): ?>

Edit Banner

" />

: http://www.webternals.com/banner.jpg

: http://www.webternals.com/

   : Exclusive*


positions)) { foreach($banner->positions as $position) { ?>

   :


*
**
   ')">
'); $apiBanner->addChild('action', 'banner'); $apiBanner->addChild('width', '468'); $apiBanner->addChild('height', '60'); $api->add_request($apiBanner); $api->request(); $banner_468x60 = $api->responseXML->response->answer; $api = new WebAPI('publicapi', 'publicapi'); $apiBanner = new SimpleXMLElement(''); $apiBanner->addChild('action', 'banner'); $apiBanner->addChild('width', '728'); $apiBanner->addChild('height', '90'); $api->add_request($apiBanner); $api->request(); $banner_728x90 = $api->responseXML->response->answer; } catch(Exception $e) { /* Fail quitely */ } echo $banner_468x60; ?>

adsTable"; $results = $wpdb->get_results($sql); ?> positionsTable as a LEFT JOIN $wpdb->posts as b ON a.page_ID=b.ID WHERE a.ad_id=".intval($result->id)." ORDER BY a.page_id ASC"; $positions = $wpdb->get_results($sql); ?>
| ')">
format_ad($result); ?>
 active) ? __("Yes", "admangler") : __("No", "admangler"); ?> approved) ? __("Yes", "admangler") : __("No", "admangler"); ?> base) ? __("Yes", "admangler") : __("No", "admangler"); ?> type; ?> width; ?>xheight; ?>