function send_circular(&$tpl, &$sql)
{
if (isset($_POST['uaction']) && $_POST['uaction'] === 'send_circular') {
if (check_user_data($tpl)) {
send_reseller_users_message(&$sql, $_SESSION['user_id']);
unset($_POST['uaction']);
gen_page_data($tpl, $sql);
}
}
}
function send_reseller_message()
{
$sql = EasySCP_Registry::get('Db');
$user_id = $_SESSION['user_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`admin_id`, `fname`, `lname`, `email`\n\t\tFROM\n\t\t\t`admin`\n\t\tWHERE\n\t\t\t`admin_type` = 'reseller' AND `created_by` = ?\n\t\tGROUP BY\n\t\t\t`email`\n\t";
$rs = exec_query($sql, $query, $user_id);
while (!$rs->EOF) {
if ($_POST['rcpt_to'] == 'rslrs' || $_POST['rcpt_to'] == 'usrs_rslrs') {
$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);
}
if ($_POST['rcpt_to'] == 'usrs' || $_POST['rcpt_to'] == 'usrs_rslrs') {
send_reseller_users_message($sql, $rs->fields['admin_id']);
}
$rs->moveNext();
}
set_page_message(tr('You send email to your users successfully!'), 'success');
write_log('Mass email was sent from ' . tohtml($sender_name) . '<' . $sender_email . '>!');
}
function send_reseller_message(&$sql)
{
$user_id = $_SESSION['user_id'];
$msg_subject = stripslashes($_POST['msg_subject']);
$msg_text = $_POST['msg_text'];
$sender_email = $_POST['sender_email'];
$sender_name = $_POST['sender_name'];
$query = <<<SQL_QUERY
select
admin_id, fname, lname, email
from
admin
where
admin_type = 'reseller' and created_by = ?
group by
email
SQL_QUERY;
$rs = exec_query($sql, $query, array($user_id));
while (!$rs->EOF) {
if ($_POST['rcpt_to'] == 'rslrs' || $_POST['rcpt_to'] == 'usrs_rslrs') {
$to = $rs->fields['fname'] . " " . $rs->fields['lname'] . " <" . $rs->fields['email'] . ">";
send_circular_email($to, "{$sender_name} <{$sender_email}>", stripslashes($msg_subject), stripslashes($msg_text));
}
if ($_POST['rcpt_to'] == 'usrs' || $_POST['rcpt_to'] == 'usrs_rslrs') {
send_reseller_users_message($sql, $rs->fields['admin_id']);
}
$rs->MoveNext();
}
set_page_message(tr('You send email to your users successfully!'));
write_log('Mass email was sended from ' . $sender_name . '<' . $sender_email . '>');
}
