function send_reseller_users_message(&$sql, $admin_id)
{
$msg_subject = $_POST['msg_subject'];
$msg_text = $_POST['msg_text'];
$sender_email = $_POST['sender_email'];
$sender_name = $_POST['sender_name'];
$query = <<<SQL_QUERY
select
fname, lname, email
from
admin
where
admin_type = 'user' and created_by = ?
group by
email
SQL_QUERY;
$rs = exec_query($sql, $query, array($admin_id));
while (!$rs->EOF) {
$to = $rs->fields['fname'] . " " . $rs->fields['lname'] . " <" . $rs->fields['email'] . ">";
send_circular_email($to, "{$sender_name} <{$sender_email}>", stripslashes($msg_subject), stripslashes($msg_text));
$rs->MoveNext();
}
set_page_message(tr('You send email to your users successfully!'));
write_log('Mass email was sended from Reseller' . $sender_name . '<' . $sender_email . '>');
}
function send_reseller_users_message($sql, $admin_id)
{
$msg_subject = clean_input($_POST['msg_subject'], false);
$msg_text = clean_input($_POST['msg_text'], false);
$sender_email = clean_input($_POST['sender_email'], false);
$sender_name = clean_input($_POST['sender_name'], false);
$query = "\n\t\tSELECT\n\t\t\t`fname`, `lname`, `email`\n\t\tFROM\n\t\t\t`admin`\n\t\tWHERE\n\t\t\t`admin_type` = 'user' AND `created_by` = ?\n\t\tGROUP BY\n\t\t\t`email`\n\t";
$rs = exec_query($sql, $query, $admin_id);
while (!$rs->EOF) {
$to = "\"" . mb_encode_mimeheader($rs->fields['fname'] . " " . $rs->fields['lname'], 'UTF-8') . "\" <" . $rs->fields['email'] . ">";
send_circular_email($to, "\"" . mb_encode_mimeheader($sender_name, 'UTF-8') . "\" <" . $sender_email . ">", $msg_subject, $msg_text);
$rs->moveNext();
}
}
function send_reseller_users_message($sql, $admin_id)
{
$msg_subject = clean_input($_POST['msg_subject'], false);
$msg_text = clean_input($_POST['msg_text'], false);
$sender_email = clean_input($_POST['sender_email'], false);
$sender_name = clean_input($_POST['sender_name'], false);
$query = "\n\t\tSELECT\n\t\t\t`fname`, `lname`, `email`\n\t\tFROM\n\t\t\t`admin`\n\t\tWHERE\n\t\t\t`admin_type` = 'user' AND `created_by` = ?\n\t\tGROUP BY\n\t\t\t`email`\n\t";
$rs = exec_query($sql, $query, $admin_id);
while (!$rs->EOF) {
$to = "\"" . mb_encode_mimeheader($rs->fields['fname'] . " " . $rs->fields['lname'], 'UTF-8') . "\" <" . $rs->fields['email'] . ">";
send_circular_email($to, "\"" . mb_encode_mimeheader($sender_name, 'UTF-8') . "\" <" . $sender_email . ">", $msg_subject, $msg_text);
$rs->moveNext();
}
$sender_name = tohtml($sender_name);
set_page_message(tr('You send email to your users successfully!'), 'success');
write_log("Mass email was sent from Reseller " . $sender_name . " <" . $sender_email . ">");
}
function send_reseller_users_message(&$sql, $admin_id)
{
$msg_subject = $_POST['msg_subject'];
$msg_text = $_POST['msg_text'];
$sender_email = $_POST['sender_email'];
$sender_name = $_POST['sender_name'];
$query = <<<SQL_QUERY
select
fname, lname, email
from
admin
where
admin_type = 'user' and created_by = ?
group by
email
SQL_QUERY;
$rs = exec_query($sql, $query, array($admin_id));
while (!$rs->EOF) {
$to = $rs->fields['fname'] . " " . $rs->fields['lname'] . " <" . $rs->fields['email'] . ">";
send_circular_email($to, "{$sender_name} <{$sender_email}>", stripslashes($msg_subject), stripslashes($msg_text));
$rs->MoveNext();
}
}
