mail_title_send.php
2.29 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
require_once(dirname(__FILE__)."/config.php");
require_once(DEDEINC."/datalistcp.class.php");
CheckPurview('plus_Mail');
if(!isset($dopost)) $dopost = '';
if($dopost=="send"){
//邮件发送函数
function sendmail($email, $mailtitle, $mailbody)
{
global $cfg_sendmail_bysmtp, $cfg_smtp_server, $cfg_smtp_port, $cfg_smtp_usermail, $cfg_smtp_user, $cfg_smtp_password, $cfg_adminemail,$cfg_webname;
if($cfg_sendmail_bysmtp == 'Y' && !empty($cfg_smtp_server))
{
$mailtype = 'HTML';
require_once(DEDEINC.'/mail.class.php');
$smtp = new smtp($cfg_smtp_server,$cfg_smtp_port,true,$cfg_smtp_usermail,$cfg_smtp_password);
$smtp->debug = false;
if(!$smtp->smtp_sockopen($cfg_smtp_server)){
ShowMsg('邮件发送失败,请联系管理员','-1');
exit();
}
$smtp->sendmail($email,$cfg_webname,$cfg_smtp_usermail, $mailtitle, $mailbody, $mailtype);
}else{
@mail($email, $mailtitle, $mailbody, $headers);
}
}
$row=$dsql->GetOne("SELECT * FROM `#@__mail_title` WHERE id=$id");
$mailtitle=$row['title'];
$mailbody=$row['content'];
$sql="SELECT m.email FROM `#@__member` AS m LEFT JOIN `#@__mail_order` AS o ON o.mid=m.mid WHERE o.typeid=$typeid";
$db->Execute('me',$sql);
while($row = $db->GetArray()){
$mails[]=$row;
}
$email="";
foreach($mails as $mail){
$email.=$mail['email'].",";
}
$mailto=$email;
sendmail($mailto,$mailtitle,$mailbody);
$sendtime = time();
$inquery = "UPDATE `#@__mail_title` SET count=count+1,sendtime='$sendtime',state='1' WHERE id=$id";
if($dsql->ExecuteNoneQuery($inquery)){
ShowMsg('邮件已成功发送','mail_title_send.php');
exit();
}
}else{
function GetState($state){
if($state=="0") return "<font color='red'>未发送</font>";
else return "已发送";
}
function GetSendTimeMk($mktime){
if($mktime=="0") return "<font color='red'>未发送</font>";
else return MyDate('Y-m-d H:i:s',$mktime);
}
function GetCount($typeid){
global $dsql;
$row=$dsql->GetOne("SELECT COUNT(typeid) as cc FROM `#@__mail_order`");
return $row['cc'];
}
$sql = "SELECT t.*,p.typename FROM `#@__mail_title` AS t LEFT JOIN `#@__mail_type` AS p ON t.typeid=p.id ORDER BY t.id desc";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN."/templets/mail_title_send.htm");
$dlist->SetSource($sql);
$dlist->display();
}
?>