function send_published_pixels_notification($user_id, $BID)
{
global $label;
$subject = $label['publish_pixels_email_subject'];
$subject = str_replace("%SITE_NAME%", SITE_NAME, $subject);
$sql = "SELECT * from banners where banner_id='{$BID}'";
$result = mysql_query($sql) or die(mysql_error());
$b_row = mysql_fetch_array($result);
$sql = "SELECT * from users where ID='{$user_id}'";
$result = mysql_query($sql) or die(mysql_error());
$u_row = mysql_fetch_array($result);
$sql = "SELECT url, alt_text FROM blocks where user_id='{$user_id}' AND banner_id='{$BID}' GROUP by url ";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$url_list .= $row['url'] . " - " . $row['alt_text'] . "\n";
}
$arr = explode("/", SERVER_PATH_TO_ADMIN);
$admin_folder = array_pop($arr);
$admin_folder = array_pop($arr);
$view_url = BASE_HTTP_PATH . $admin_folder . "/remote_admin.php?key=" . substr(md5(ADMIN_PASSWORD), 1, 15) . "&user_id={$user_id}&BID={$BID}";
$msg = str_replace("%SITE_NAME%", SITE_NAME, $label['publish_pixels_email_template']);
$msg = str_replace("%GRID_NAME%", $b_row['name'], $msg);
$msg = str_replace("%MEMBERID%", $u_row['Username'], $msg);
$msg = str_replace("%URL_LIST%", $url_list, $msg);
$msg = str_replace("%VIEW_URL%", $view_url, $msg);
$html_msg = str_replace("%SITE_NAME%", SITE_NAME, $label['publish_pixels_html_email_template']);
$html_msg = str_replace("%GRID_NAME%", $b_row['name'], $html_msg);
$html_msg = str_replace("%MEMBERID%", $u_row['Username'], $html_msg);
$html_msg = str_replace("%URL_LIST%", $url_list, $html_msg);
$html_msg = str_replace("%VIEW_URL%", $view_url, $html_msg);
if (USE_SMTP == 'YES') {
$mail_id = queue_mail(addslashes(SITE_CONTACT_EMAIL), addslashes('Admin'), addslashes(SITE_CONTACT_EMAIL), addslashes(SITE_NAME), addslashes($subject), addslashes($msg), addslashes($html_msg), 7);
process_mail_queue(2, $mail_id);
} else {
send_email(SITE_CONTACT_EMAIL, 'Admin', SITE_CONTACT_EMAIL, SITE_NAME, $subject, $msg, $html_msg, 7);
}
}
$form_name = SITE_NAME;
//$e_row[EmailFromName];
//$subject = 'Your password on'.SITE_NAME; //$e_row[EmailSubject];
$subject = str_replace("%SITE_NAME%", SITE_NAME, $label["advertiser_forgot_subject"]);
$subject = str_replace("%MEMBERID%", $Username, $subject);
$EmailMessage = str_replace("%FNAME%", $row[FirstName], $EmailMessage);
$EmailMessage = str_replace("%LNAME%", $row[LastName], $EmailMessage);
$EmailMessage = str_replace("%SITE_CONTACT_EMAIL%", SITE_CONTACT_EMAIL, $EmailMessage);
$EmailMessage = str_replace("%SITE_NAME%", SITE_NAME, $EmailMessage);
$EmailMessage = str_replace("%SITE_URL%", BASE_HTTP_PATH, $EmailMessage);
$EmailMessage = str_replace("%MEMBERID%", $row['Username'], $EmailMessage);
$EmailMessage = str_replace("%PASSWORD%", $pass, $EmailMessage);
$to = $email;
$message = $EmailMessage;
if (USE_SMTP == 'YES') {
$mail_id = queue_mail(addslashes($to), addslashes($row[FirstName] . " " . $row[LastName]), addslashes(SITE_CONTACT_EMAIL), addslashes(SITE_NAME), addslashes($subject), addslashes($message), '', 6);
process_mail_queue(2, $mail_id);
} else {
send_email($to, $row[FirstName] . " " . $row[LastName], SITE_CONTACT_EMAIL, SITE_NAME, $subject, $message, '', 6);
}
$str = str_replace("%BASE_HTTP_PATH%", BASE_HTTP_PATH, $label["advertiser_forgot_success1"]);
echo "<p align='center'>" . $str . "</p>";
}
} else {
echo "<center>" . $label["advertiser_forgot_email_notfound"] . "</center>";
}
}
?>
<center><h3><a href="../"><?php
echo $label["advertiser_forgot_go_back"];
