//echo $error; display_ad_form(1, $mode, ''); } else { insert_ad_data(true); // admin mode $prams = load_ad_values($_REQUEST['ad_id']); update_blocks_with_ad($_REQUEST['ad_id'], $prams['user_id']); display_ad_form(1, "edit", $prams); // disapprove the pixels because the ad was modified.. if (AUTO_APPROVE != 'Y') { // to be approved by the admin disapprove_modified_order($prams['order_id'], $BID); } if (AUTO_PUBLISH == 'Y') { process_image($BID); publish_image($BID); process_map($BID); //echo 'published.'; } echo 'Ad Saved. <A href="ads.php?BID=' . $prams['banner_id'] . '"><< Go to the Ad List</a>'; echo "<hr>"; } } else { $prams = load_ad_values($_REQUEST['ad_id']); display_ad_form(1, 'edit', $prams); } $prams = load_ad_values($_REQUEST['ad_id']); $sql = "select * FROM users where ID='" . $prams['user_id'] . "' "; $result = mysql_query($sql); $u_row = mysql_fetch_array($result); $b_row = load_banner_row($prams['banner_id']);
function complete_renew_order($order_id) { global $label; $sql = "SELECT * from orders where order_id='{$order_id}' and status='renew_paid' "; $result = mysql_query($sql) or die(mysql_error() . $sql); $order_row = mysql_fetch_array($result); if ($order_row['status'] != 'completed') { $now = gmdate("Y-m-d H:i:s"); $sql = "UPDATE orders set status='completed', date_published=NULL, date_stamp='{$now}' WHERE order_id=" . $order_id; mysql_query($sql) or die(mysql_error() . $sql); // update pixel's order_id $sql = "UPDATE blocks SET order_id='" . $order_row['order_id'] . "' WHERE order_id='" . $order_row['original_order_id'] . "' AND banner_id='" . $row['banner_id'] . "' "; mysql_query($sql) or die(mysql_error() . $sql); // update ads' order id $sql = "UPDATE ads SET order_id='" . $order_row['order_id'] . "' WHERE order_id='" . $order_row['original_order_id'] . "' AND banner_id='" . $row['banner_id'] . "' "; mysql_query($sql) or die(mysql_error() . $sql); // mark pixels as sold. $sql = "SELECT * from orders where order_id='{$order_id}' "; $result = mysql_query($sql) or die(mysql_error() . $sql); $order_row = mysql_fetch_array($result); $blocks = explode(",", $order_row['blocks']); foreach ($blocks as $key => $val) { $sql = "UPDATE blocks set status='sold' where block_id='{$val}' and banner_id=" . $order_row['banner_id']; mysql_query($sql) or die(mysql_error() . $sql); } $sql = "SELECT * from users where ID='{$user_id}' "; $result = mysql_query($sql) or die(mysql_error() . $sql); $user_row = mysql_fetch_array($result); if ($order_row['days_expire'] == 0) { $order_row['days_expire'] = $label['advertiser_ord_never']; } $label["order_completed_renewal_email_template"] = str_replace("%SITE_NAME%", SITE_NAME, $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%FNAME%", $user_row[FirstName], $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%LNAME%", $user_row[LastName], $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%ORDER_ID%", $order_row[order_id], $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%ORIGINAL_ORDER_ID%", $order_row[original_order_id], $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%PIXEL_COUNT%", $order_row[quantity], $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%PIXEL_DAYS%", $order_row[days_expire], $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%PRICE%", convert_to_default_currency_formatted($order_row[currency], $order_row[price]), $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%SITE_CONTACT_EMAIL%", SITE_CONTACT_EMAIL, $label["order_completed_renewal_email_template"]); $label["order_completed_renewal_email_template"] = str_replace("%SITE_URL%", BASE_HTTP_PATH, $label["order_completed_renewal_email_template"]); $message = $label["order_completed_renewal_email_template"]; $to = trim($user_row['Email']); $subject = $label['order_completed_email_subject']; if (EMAIL_USER_ORDER_COMPLETED == 'YES') { if (USE_SMTP == 'YES') { $mail_id = queue_mail(addslashes($to), addslashes($user_row[FirstName] . " " . $user_row[LastName]), addslashes(SITE_CONTACT_EMAIL), addslashes(SITE_NAME), addslashes($subject), addslashes($message), '', 8); process_mail_queue(2, $mail_id); } else { send_email($to, $user_row[FirstName] . " " . $user_row[LastName], SITE_CONTACT_EMAIL, SITE_NAME, $subject, $message, '', 1); } } // send a copy to admin if (EMAIL_ADMIN_ORDER_COMPLETED == 'YES') { if (USE_SMTP == 'YES') { $mail_id = queue_mail(addslashes(SITE_CONTACT_EMAIL), addslashes($user_row[FirstName] . " " . $user_row[LastName]), addslashes(SITE_CONTACT_EMAIL), addslashes(SITE_NAME), addslashes($subject), addslashes($message), '', 8); process_mail_queue(2, $mail_id); } else { send_email(SITE_CONTACT_EMAIL, $user_row[FirstName] . " " . $user_row[LastName], SITE_CONTACT_EMAIL, SITE_NAME, $subject, $message, '', 1); } } // process the grid, if auto_publish is on $b_row = load_banner_row($order_row['banner_id']); if ($b_row['auto_publish'] == 'Y') { process_image($order_row['banner_id']); publish_image($order_row['banner_id']); process_map($order_row['banner_id']); } } }
# Banner ID. if ($_REQUEST['process'] == '1') { if ($_REQUEST['banner_list'][0] == 'all') { // process all $sql = "select * from banners "; $result = mysql_query($sql) or die(mysql_error() . $sql); while ($row = mysql_fetch_array($result)) { echo process_image($row['banner_id']); publish_image($row['banner_id']); process_map($row['banner_id']); } } else { // process selected foreach ($_REQUEST['banner_list'] as $key => $banner_id) { echo process_image($banner_id); publish_image($banner_id); process_map($banner_id); } } echo "<br>Finished.<hr>"; } ####################### # Process images ?> <script language="JavaScript" type="text/javascript"> function confirmLink(theLink, theConfirmMsg) { if (theConfirmMsg == '' || typeof(window.opera) != 'undefined') { return true; }
foreach ($_REQUEST['users'] as $user_id) { $sql = "UPDATE blocks set approved='N' WHERE user_id=" . $user_id . " {$bid_sql}"; mysql_query($sql) or die(mysql_error() . $sql); $sql = "UPDATE orders set approved='N' WHERE user_id=" . $user_id . " {$bid_sql}"; mysql_query($sql) or die(mysql_error() . $sql); } echo "Advertiser(s) Disapproved.<br>"; } } if ($_REQUEST['do_it_now'] == 'true') { // process all grids $sql = "select * from banners "; $result = mysql_query($sql) or die(mysql_error() . $sql); while ($row = mysql_fetch_array($result)) { echo process_image($row['banner_id']); publish_image($row['banner_id']); process_map($row['banner_id']); } } /* if ($_REQUEST['all_go']!='') { $sql = "UPDATE blocks set approved='Y' "; mysql_query ($sql) or die (mysql_error().$sql); $sql = "select * from banners "; $result = mysql_query ($sql) or die (mysql_error().$sql); while ($row = mysql_fetch_array($result)) { process_image($row['banner_id']); publish_image($row['banner_id']); process_map($row['banner_id']); } }