-
Notifications
You must be signed in to change notification settings - Fork 0
/
white_vmail_setting.php
127 lines (113 loc) · 5.95 KB
/
white_vmail_setting.php
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
if (!defined("SYSTEM_ROOT")) {
msg("Insufficient Permissions");
}
if (ROLE != 'admin') {
msg('无权访问！');
}
if(isset($_GET['msg'])){
echo '<script>alert(\''.$_REQUEST['msg'].'\');</script>';
}
/**
* 变量名称
* @param $verifyKey 发送邮件中的key，用于验证用户身份是否与$verifyCode匹配
* @param $query SQL查询语句
* @param $url 验证链接地址
* @param $verifyCode 验证码
* @param $pluginName 插件名
*/
function sendMail($userMail, $uid) {
global $m;
global $today;
$pluginName = 'white_vmail';
// 获取8位数的随机验证码并加密
$verifyCode = rand_int(8);
$verifyKey = sha1(md5($verifyCode));
$url = SYSTEM_URL.'?plugin='.$pluginName.'&key='.$verifyKey;
$title = '邮箱验证 -- '.SYSTEM_NAME;
$text = '亲爱的用户：<br><br>您好！<br><br>这是来自学园百度贴吧云签到平台的验证邮件，用来验证您的用户邮箱。<br><br>请登录学园百度贴吧云签到平台后点击该链接，以便验证你的邮箱。<br><br>提示：必须登录后点击！必须登录后点击！必须登录后点击！ 否则无法验证！谢谢合作！<br><br>系统将会自动清除注册一定时间后没验证邮箱的用户！<hr/>验证链接：'.$url.'<br>（如果您无法点击此链接，请将它复制到浏览器地址栏后访问）<br><br><br>'.SYSTEM_NAME.'<br><br>（本邮件为系统自动发送，请勿回复）';
$mailResult = misc::mail($userMail, $title, $text);
if ($mailResult != TRUE) {
msg("向".$userMail."发送邮件失败。");
}
$m->query("UPDATE ".DB_PREFIX."users SET white_vmail_send = 1, white_vmail_code = ".$verifyCode." WHERE id = ".$uid);
Redirect(SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail");
}
function del($id,$name) {
global $m;
$result = $m->query("SELECT * FROM `".DB_PREFIX."users` WHERE `id`=".$id."");
$row = $m->fetch_array($result);
$tieba = $row['t'];
$m->query("DELETE FROM `".DB_PREFIX."users` WHERE `id`=".$id);
$m->query("DELETE FROM `".DB_PREFIX."baiduid` WHERE `uid`=".$id);
$m->query("DELETE FROM `".DB_PREFIX."users_options` WHERE `uid`=".$id);
$m->query("DELETE FROM `".DB_PREFIX.$tieba."` WHERE `uid`=".$id);
Redirect(SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&msg=已删除用户[".$name."]相关数据！");
}
function set($id,$mail) {
global $m;
$m->query("UPDATE `".DB_PREFIX."users` SET `white_vmail_verify`=1 WHERE `id`=".$id);
Redirect(SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&msg=已激活邮箱[".$mail."]");
}
function revoke($id,$mail) {
global $m;
$m->query("UPDATE `".DB_PREFIX."users` SET `white_vmail_verify`=0 WHERE `id`=".$id);
Redirect(SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&msg=已取消邮箱[".$mail."]的激活状态。");
}
function showUsers() {
global $m;
$query = "SELECT id, name, email, white_vmail_send, white_vmail_verify FROM `".DB_PREFIX."users` ORDER BY id ASC";
$result = $m->query($query);
echo '
<div class="panel panel-primary">
<div class="panel-heading">邮箱有效性验证</div>
<div class="table-responsive">
<table class="table" style="margin-bottom:0">
<thead>
<tr>
<th style="width:10%">UID</th>
<th style="width:15%">用户名</th>
<th style="width:25%">Email</th>
<th style="width:10%">发送状态</th>
<th style="width:10%">验证状态</th>
<th style="width:10%">验证</th>
<th style="width:10%">操作</th>
<th style="width:10%">设置状态</th>
</tr>
</thead>';
while ($row = $m->fetch_array($result)) {
if ($row['white_vmail_verify'] == 0) {
$verifyStatus = '<td style="padding:5px 0px 0px 0px;"><a class="btn btn-sm btn-danger">未验证</a></td>';
$setUser = "<td style='padding:5px 0px 0px 0px;'><a href='".SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&action=set&email=".$row['email']."&uid=".$row['id']."' class='btn btn-sm btn-primary'".$Ban.">设为已验证</a></td>";
} else {
$verifyStatus = '<td style="padding:5px 0px 0px 0px;"><a class="btn btn-sm btn-success">已验证</a></td>';
$setUser = "<td style='padding:5px 0px 0px 0px;'><a href='".SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&action=revoke&email=".$row['email']."&uid=".$row['id']."' class='btn btn-sm btn-warning'".$Ban.">设为未验证</a></td>";
$Ban = ' disabled';
}
if ($row['white_vmail_send'] == 0) {
$sendStatus = '<td style="padding:5px 0px 0px 0px;"><a class="btn btn-sm btn-danger">未发送</a></td>';
} else {
$sendStatus = '<td style="padding:5px 0px 0px 0px;"><a class="btn btn-sm btn-success">已发送</a></td>';
}
$sendMail = "<td style='padding:5px 0px 0px 0px;'><a href='".SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&action=send&email=".$row['email']."&uid=".$row['id']."' class='btn btn-sm btn-primary'".$Ban.">发送邮件</a></td>";
$delUser = "<td style='padding:5px 0px 0px 0px;'><a href='".SYSTEM_URL."index.php?mod=admin:setplug&plug=white_vmail&action=del&email=".$row['email']."&uid=".$row['id']."&name=".$row['name']."' class='btn btn-sm btn-primary' onclick='return confirm(\"确认删除？\");'>删除用户</a></td>";
$Ban = '';
echo "<tbody><tr><tr><td>".$row['id']."</td><td>".$row['name']."</td><td>".$row['email']."</td>".$sendStatus.$verifyStatus.$sendMail.$delUser.$setUser."</tr>";
}
echo '</tbody></table></div></div>';
}
showUsers();
if (isset($_GET['action']) && $_GET['action'] == 'send' && isset($_GET['email']) && isset($_GET['uid'])) {
sendMail($_GET['email'], $_GET['uid']);
}
if (isset($_GET['action']) && $_GET['action'] == 'del' && isset($_GET['email']) && isset($_GET['uid']) && isset($_GET['name'])) {
del($_GET['uid'],$_GET['name']);
}
if (isset($_GET['action']) && $_GET['action'] == 'set' && isset($_GET['email']) && isset($_GET['uid'])) {
set($_GET['uid'],$_GET['email']);
}
if (isset($_GET['action']) && $_GET['action'] == 'revoke' && isset($_GET['email']) && isset($_GET['uid'])) {
revoke($_GET['uid'],$_GET['email']);
}
echo '<link rel="stylesheet" href="css/main.css" type="text/css" />';
?>