";
}
//#############################################################################
// Send the actual mail(s)
function send_mail()
{
global $lang_global, $output, $realm_db, $characters_db, $realm_id, $user_name, $from_mail, $mailer_type, $smtp_cfg;
if ( empty($_POST['body']) || empty($_POST['subject']) || empty($_POST['type']) || empty($_POST['group_sign']) || empty($_POST['group_send']) )
{
redirect("mail.php?error=1");
}
$sqlr = new SQL;
$sqlr->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
$sqlc = new SQL;
$sqlc->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
$body = explode("\n",$_POST['body']);
$subject = $sqlc->quote_smart($_POST['subject']);
if(isset($_POST['to'])&&($_POST['to'] != ''))
$to = $sqlc->quote_smart($_POST['to']);
else
{
$to = 0;
if(!isset($_POST['group_value'])||$_POST['group_value'] === '')
{
redirect("mail.php?error=1");
}
else
{
$group_value = $sqlc->quote_smart($_POST['group_value']);
$group_sign = $sqlc->quote_smart($_POST['group_sign']);
$group_send = $sqlc->quote_smart($_POST['group_send']);
}
}
$type = addslashes($_POST['type']);
$att_gold = $sqlc->quote_smart($_POST['money']);
$att_item = $sqlc->quote_smart($_POST['att_item']);
$att_stack = $sqlc->quote_smart($_POST['att_stack']);
switch ($type)
{
case "email":
require_once("libs/mailer/class.phpmailer.php");
$mail = new PHPMailer();
$mail->Mailer = $mailer_type;
if ($mailer_type == "smtp")
{
$mail->Host = $smtp_cfg['host'];
$mail->Port = $smtp_cfg['port'];
if($smtp_cfg['user'] != '')
{
$mail->SMTPAuth = true;
$mail->Username = $smtp_cfg['user'];
$mail->Password = $smtp_cfg['pass'];
}
}
$value = NULL;
for($i=0;$i<(count($body));$i++)
$value .= $body[$i]."\r\n";
$body=$value;
$mail->From = $from_mail;
$mail->FromName = $user_name;
$mail->Subject = $subject;
$mail->IsHTML(true);
$body = str_replace("\n", "
", $body);
$body = str_replace("\r", " ", $body);
$body = str_replace(array("\r\n", "\n", "\r"), '
', $body);
$body = preg_replace( "/([^\/=\"\]])((http|ftp)+(s)?:\/\/[^<>\s]+)/i", "\\1\\2", $body);
$body = preg_replace('/([^\/=\"\]])(www\.)(\S+)/', '\\1\\2\\3', $body);
$mail->Body = $body;
$mail->WordWrap = 50;
if($to)
{
//single Recipient
$mail->AddAddress($to);
if(!$mail->Send())
{
$mail->ClearAddresses();
redirect("mail.php?error=3&mail_err=".$mail->ErrorInfo);
}
else
{
$mail->ClearAddresses();
redirect("mail.php?error=2");
}
}
elseif (isset($group_value))
{
//group send
$email_array = array();
switch ($group_send)
{
case "gm_level":
$result = $sqlr->query("SELECT email FROM account WHERE gmlevel $group_sign '$group_value'");
while($user = $sql->fetch_row($result))
{
if($user[0] != "") array_push($email_array, $user[0]);
}
break;
case "locked":
$result = $sql->query("SELECT email FROM account WHERE locked $group_sign '$group_value'");
while($user = $sql->fetch_row($result))
{
if($user[0] != "")
array_push($email_array, $user[0]);
}
break;
case "banned":
$que = $sqlr->query("SELECT id FROM account_banned");
while ($banned = $sql->fetch_row($que))
{
$result = $sqlr->query("SELECT email FROM account WHERE id = '$banned[0]'");
if($sqlr->result($result, 0, 'email'))
array_push($email_array, $sql->result($result, 0, 'email'));
}
break;
default:
redirect("mail.php?error=5");
break;
}
foreach ($email_array as $mail_addr)
{
$mail->AddAddress($mail_addr);
if(!$mail->Send())
{
$mail->ClearAddresses();
redirect("mail.php?error=3&mail_err=".$mail->ErrorInfo);
}
else
{
$mail->ClearAddresses();
}
}
redirect("mail.php?error=2");
}
else
redirect("mail.php?error=1");
break;
case "ingame_mail":
$value = NULL;
for($i=0;$i<(count($body));$i++)
$value .= $body[$i]." ";
$body=$value;
$body = str_replace("\r", " ", $body);
if($to)
{
//single Recipient
$result = $sqlc->query("SELECT name FROM characters WHERE name = '$to'");
if ($sqlc->num_rows($result) == 1)
{
$receiver = $sqlc->result($result, 0, 'name');
$mails = array();
array_push($mails, array($receiver, $subject, $body, $att_gold, $att_item, $att_stack));
send_ingame_mail($realm_id, $mails);
}
else
{
redirect("mail.php?error=4");
}
redirect("mail.php?error=2");
break;
}
elseif(isset($group_value))
{
//group send
$char_array = array();
switch ($group_send)
{
case "gm_level":
$result = $sqlr->query("SELECT id FROM account WHERE gmlevel $group_sign '$group_value'");
while($acc = $sqlc->fetch_row($result))
{
$result_2 = $sqlc->query("SELECT name FROM `characters` WHERE account = '$acc[0]'");
while($char = $sqlc->fetch_row($result_2))
array_push($char_array, $char[0]);
}
break;
case "online":
$result = $sqlc->query("SELECT name FROM `characters` WHERE online $group_sign '$group_value'");
while($user = $sqlc->fetch_row($result))
array_push($char_array, $user[0]);
break;
case "char_level":
$result = $sqlc->query("SELECT name FROM `characters` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) $group_sign '$group_value'");
while($user = $sqlc->fetch_row($result))
array_push($char_array, $user[0]);
break;
default:
redirect("mail.php?error=5");
}
$mails = array();
foreach ($char_array as $receiver)
{
array_push($mails, array($receiver, $subject, $body, $att_gold, $att_item, $att_stack));
}
send_ingame_mail($realm_id, $mails);
redirect("mail.php?error=2");
}
break;
default:
redirect("mail.php?error=1");
}
}
//##########################################################################################
//SEND INGAME MAIL BY TELNET
//
// Xiong Guoy
// 2009-08-08
function send_ingame_mail($realm_id, $massmails)
{
require_once 'libs/telnet_lib.php';
global $server, $lang_telnet;
$telnet = new telnet_lib();
//$massmails array format
//($to, $subject, $body, $gold = 0, $item = 0, $stack = 1)
$result = $telnet->Connect($server[$realm_id]['addr'], $server[$realm_id]['telnet_port'], $server[$realm_id]['telnet_user'], $server[$realm_id]['telnet_pass']);
if (0 == $result)
{
$mess_str = '';
$result = '';
foreach($massmails as $mails)
{
if ($mails[3] && $mails[4])
{
$mess_str1 = "send money ".$mails[0]." \"".$mails[1]."\" \"".$mails[2]."\" ".$mails[3]."";
$telnet->DoCommand($mess_str1, $result1);
$mess_str .= $mess_str1."
";
$result .= $result1."";
$mess_str1 = "send item ".$mails[0]." \"".$mails[1]."\" \"".$mails[2]."\" ".$mails[4].(($mails[5] > 1) ? "[:count".$mails[5]."]" : " ");
$telnet->DoCommand($mess_str1, $result1);
$mess_str .= $mess_str1."
";
$result .= $result1."";
}
elseif ($mails[3])
{
$mess_str1 = "send money ".$mails[0]." \"".$mails[1]."\" \"".$mails[2]."\" ".$mails[3]."";
$telnet->DoCommand($mess_str1, $result1);
$mess_str .= $mess_str1."
";
$result .= $result1."";
}
elseif ($mails[4])
{
$mess_str1 = "send item ".$mails[0]." \"".$mails[1]."\" \"".$mails[2]."\" ".$mails[4].(($mails[5] > 1) ? "[:count".$mails[5]."]" : " ");
$telnet->DoCommand($mess_str1, $result1);
$mess_str .= $mess_str1."
";
$result .= $result1."";
}
else
{
$mess_str1 = "send mail ".$mails[0]." \"".$mails[1]."\" \"".$mails[2]."\"";
$telnet->DoCommand($mess_str1, $result1);
$mess_str .= $mess_str1."
";
$result .= $result1."";
}
}
$result = str_replace("mangos>","",$result);
$result = str_replace(array("\r\n", "\n", "\r"), '
', $result);
$mess_str .= "
".$result;
$telnet->Disconnect();
}
elseif (1 == $result)
$mess_str = $lang_telnet['unable'];
elseif (2 == $result)
$mess_str = $lang_telnet['unknown_host'];
elseif (3 == $result)
$mess_str = $lang_telnet['login_failed'];
elseif (4 == $result)
$mess_str = $lang_telnet['not_supported'];
redirect("mail.php?action=result&error=6&mess=$mess_str");
}
//########################################################################################################################
// InGame Mail Result
//########################################################################################################################
//
// Xiong Guoy
// 2009-08-08
// report page for send_ingame_mail
function result()
{
global $lang_global, $output;
$mess = (isset($_GET['mess'])) ? $_GET['mess'] : NULL;
$output .= '
'.$mess.'
';
unset($mess);
$output .= '
|
| ';
makebutton($lang_global['back'], 'javascript:window.history.back()', 130);
$output .= '
|
';
}
//########################################################################################################################
// MAIN
//########################################################################################################################
$err = (isset($_GET['error'])) ? $_GET['error'] : NULL;
$output .= "
";
$lang_mail = lang_mail();
$lang_telnet = lang_telnet();
switch ($err)
{
case 1:
$output .= "
{$lang_global['empty_fields']}
";
break;
case 2:
$output .= "
{$lang_mail['mail_sent']}
";
break;
case 3:
$mail_err = (isset($_GET['mail_err'])) ? $_GET['mail_err'] : NULL;
$output .= "
{$lang_mail['mail_err']}: $mail_err
";
break;
case 4:
$output .= "
{$lang_mail['no_recipient_found']}
{$lang_mail['use_name_or_email']}";
break;
case 5:
$output .= "
{$lang_mail['option_unavailable']}
{$lang_mail['use_currect_option']}";
break;
case 6:
$output .= "
{$lang_mail['result']}
";
break;
default: //no error
$output .= "
{$lang_mail['send_mail']}
";
}
unset($err);
$output .= "
";
$action = (isset($_GET['action'])) ? $_GET['action'] : NULL;
switch ($action)
{
case "send_mail":
send_mail();
break;
case "result":
result();
break;
default:
print_mail_form();
}
unset($action);
unset($action_permission);
unset($lang_telnet);
unset($lang_mail);
require_once("footer.php");
?>