//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']);
}
}
