-
Notifications
You must be signed in to change notification settings - Fork 16
Expand file tree
/
Copy pathleaving.php
More file actions
251 lines (231 loc) · 12.5 KB
/
Copy pathleaving.php
File metadata and controls
251 lines (231 loc) · 12.5 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
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
<?php
include_once 'admin/connect.php';
include_once 'admin/Database.php';
$nub = "select count(id) as shu from leaving";
$res = mysqli_query($connect, $nub);
$leav = mysqli_fetch_array($res);
$shu = $leav['shu'];
$leavset = "select * from leavset order by id desc";
$Set = mysqli_query($connect, $leavset);
$Setinfo = mysqli_fetch_array($Set);
$jiequ = $Setinfo['jiequ'];
$liuyan = "SELECT * FROM leaving order by id desc limit ?";
$stmt = $conn->prepare($liuyan);
$stmt->bind_param("i", $jiequ);
$jiequ = $Setinfo['jiequ'];
$stmt->bind_result($id, $name, $qq, $text, $time, $ip, $city);
$result = $stmt->execute();
if (!$result)
echo "错误信息：" . $stmt->error;
include_once 'head.php';
?>
<head>
<meta charset="utf-8" />
<title><?php echo $text['title'] ?> — <?php echo $text['card2'] ?></title>
</head>
<body>
<div id="pjax-container">
<div class="MessageButtonCard" id="MessageBtn">
<svg t="1730880204691" class="Message-Icon icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="13875" width="200" height="200"><path d="M512 96C229.2 96 0 282.3 0 512c0 92.1 36.8 177.1 99.1 246 4 4.5 5.3 10.9 3.1 16.5-5.7 14.7-12 29.2-19 43.3-12.9 26.3-28.2 51.7-45.3 75.5-6.2 8.6-7.7 19.7-4.1 29.6 3.6 10 11.9 17.5 22.2 20.1 9.4 2.4 25.2 5.4 44.8 5.4 26 0 58.7-5.4 91.5-25 21.4-12.8 37.5-28.6 49.3-44 4.5-5.9 12.5-7.9 19.3-4.8 74.2 34 159.8 53.4 251 53.4 282.8 0 512-186.3 512-416S794.8 96 512 96z m192 464c-30.9 0-56-25.1-56-56s25.1-56 56-56 56 25.1 56 56-25.1 56-56 56z m-440-56c0-30.9 25.1-56 56-56s56 25.1 56 56-25.1 56-56 56-56-25.1-56-56z m192 0c0-30.9 25.1-56 56-56s56 25.1 56 56-25.1 56-56 56-56-25.1-56-56z" p-id="13876"></path></svg>
</div>
<div class="central central-800 bg">
<div class="title mt-2rem">
<h1><?php echo $text['deci2'] ?></h1>
</div>
<h3>已收到 <b><?php echo $leav['shu'] ?></b> 条祝福留言<i class="jiequ">（显示最新 <?php echo $jiequ ?>条）</i></h3>
<div class="row">
<div class="card col-lg-12 col-md-12 col-sm-12 col-sm-x-12">
<?php
while ($stmt->fetch()) {
?>
<div class="leavform <?php if ($Animation == "1") { ?>animated fadeInUp delay-03s<?php } ?>">
<div class="textinfo">
<div class="MsgTopInfo">
<i class="time" data-tip="<?php echo $datetime = date('Y-m-d H:i:s', $time); ?>" data-tip-position="top">
<?php echo time_tran($time) ?> <b class="yuan"></b>
<?php echo $city ? $city : '未知'; ?>
</i>
</div>
<div class="user_info">
<img src="https://q1.qlogo.cn/g?b=qq&nk=<?php echo $qq ?>&s=100">
<div class="head_content">
<div class="level">
访客 <b>#<?php echo $id ?></b>
</div>
<span class="name"><?php echo $name ?></span>
</div>
</div>
<div class="text"><?php echo escapeXSS($text) ?></div>
</div>
</div>
<?php
}
?>
<form action="admin/leavingPost.php" method="post">
<div class="inputbox" id="MessageArea">
<img src="https://q1.qlogo.cn/g?b=qq&nk=1234567&s=100" alt="" class="avatar">
<input id="QQ" type="text" name="qq" placeholder="请输入QQ号码" class="rig">
<input id="nickname" type="text" name="name" placeholder="输入QQ号码后自动获取" class="let">
</div>
<textarea name="text" id="wenben" rows="8" placeholder="请输入您的留言内容..."></textarea>
<div class="input-sub">
<button type="button" id="leavingPost" class="tijiao">提交留言
<svg style="width:1.3em;height: 1.3em;" t="1717899795089" class="icon"
viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg"
p-id="28276" width="200" height="200">
<path
d="M620.8 179.2c12.8 12.8 6.4 32-6.4 44.8-19.2 6.4-38.4 6.4-44.8-12.8-44.8-70.4-128-115.2-217.6-115.2-140.8 0-256 115.2-256 256 0 89.6 44.8 166.4 115.2 217.6 19.2 6.4 19.2 25.6 12.8 38.4-12.8 19.2-32 19.2-44.8 12.8C89.6 563.2 32 460.8 32 352c0-179.2 140.8-320 320-320 108.8 0 211.2 57.6 268.8 147.2zM326.4 332.8l243.2 601.6 83.2-243.2c6.4-19.2 19.2-32 38.4-38.4L934.4 576 326.4 332.8z m25.6-57.6L960 518.4c32 12.8 51.2 51.2 38.4 83.2-6.4 19.2-19.2 32-38.4 38.4l-243.2 83.2L633.6 960c-12.8 32-44.8 51.2-83.2 38.4-19.2-6.4-32-19.2-38.4-38.4L268.8 358.4c-12.8-32 6.4-70.4 38.4-83.2 12.8-6.4 32-6.4 44.8 0z"
fill="#ffffff" p-id="28277"></path>
</svg></button>
</div>
</form>
</div>
</div>
</div>
<script>
$('#QQ').blur(function () {
let QQ = $("#QQ").val();
if (QQ.length <= 0) {
return false
}
$.ajax({
url: "https://api.cenguigui.cn/api/qq/name.php?qq=" + QQ,
type: "GET",
timeout: 5000,
dataType: "json",
statusCode: {
500: function (response) {
loadingname();
setTimeout(function () {
removeLoading('test');
toastr["warning"]("获取QQ头像失败 API请求超时 请联系小站管理员！", "Like_Girl");
}, 2000);
}
},
success: function (result) {
if (result.code == 500) {
removeLoading('test');
toastr["warning"](result.msg, "Like_Girl");
} else if (result.code == 200) {
loadingname();
$("#nickname").val(result.data.name);
$(".avatar").attr("src", result.data.imgurl);
setTimeout(function () {
removeLoading('test');
toastr["success"]("获取昵称头像成功", "Like_Girl");
}, 1200);
}
},
error: function (xhr, status, error) {
removeLoading('test');
toastr["error"]("Request failed: " + error, "Like_Girl");
}
});
});
$("#leavingPost").click(function () {
let qq = $("input[name='qq']").val().trim();
let name = $("input[name='name']").val().trim();
if (qq.length == 0) {
toastr["warning"]("请填写QQ号码！", "Like_Girl");
return false;
} else if (name.length == 0) {
toastr["warning"]("请填写恁的昵称！", "Like_Girl");
return false;
}
let qqlength = /^[0-9]{6,10}$/;
if (!qqlength.test(qq)) {
toastr["warning"]("您的QQ号码格式错误 <br/> 请输入由6-10位的数字 <br/>组成的QQ号码！", "Like_Girl");
return false;
}
if ((qq == 123456) || (qq == 100000) || (qq == 1234567)) {
toastr["warning"]("我想也许这并不是您的QQ号码...", "Like_Girl");
return false;
}
let text = $("textarea[name='text']").val().trim();
if (text.length == 0) {
toastr["warning"]("请填写您要留言的内容！", "Like_Girl");
return false;
} else if (text.length <= 2) {
toastr["warning"]("请填写两个字符以上的内容！", "Like_Girl");
return false;
}
let nonub = /^[0-9]+$/;
// let filter = new RegExp("[<?php echo $Setinfo['lanjie'] ?>]");
let weifan = new RegExp("[<?php echo $Setinfo['lanjiezf'] ?>]");
if (nonub.test(text)) {
toastr["warning"]("内容为纯数字 已被拦截！", "Like_Girl");
return false;
} else if (weifan.test(text)) {
toastr["warning"]("您输入的内容是违禁词 <br/>请注意您的发言不文明的留言 <br/>会被管理员拉进小黑屋喔", "Like_Girl");
return false;
}
if (!(qq && name && text)) {
toastr["warning"]("表单信息不能为空 请先填写完整！", "Like_Girl");
return false
}
$('#leavingPost').text('留言提交中...');
$("#leavingPost").attr("disabled", "disabled");
$.ajax({
url: "admin/leavingPost.php",
data: {
qq: qq,
name: name,
text: text,
},
type: "POST",
dataType: "text",
success: function (res) {
setInterval(() => {
$('#leavingPost').removeAttr("disabled");
}, 5000);
if (res == 1) {
toastr["success"]("留言提交成功 请刷新本页查看！", "Like_Girl");
$('#leavingPost').text('留言成功');
} else if (res == 0) {
toastr["error"]("留言提交失败！", "Like_Girl");
$('#leavingPost').text('留言失败');
} else if (res == 3 || res == 30) {
toastr["error"]("留言失败——QQ号码格式错", "Like_Girl");
$('#leavingPost').text('留言失败');
} else if (res == 4 || res == 40) {
toastr["error"]("留言失败——IP格式错误", "Like_Girl");
$('#leavingPost').text('留言失败');
} else if (res == 5 || res == 50) {
toastr["error"]("留言失败——参数错误", "Like_Girl");
$('#leavingPost').text('留言失败');
} else if (res == 8) {
toastr["error"]("留言失败——你今天已经留言过了~", "Like_Girl");
$('#leavingPost').text('留言失败');
} else {
toastr["error"]("未知错误！", "Like_Girl");
}
},
error: function (err) {
toastr["error"]("网络错误 请稍后重试！", "Like_Girl");
}
}
)
})
function loadingname() {
$('body').loading({
loadingWidth: 240,
title: '获取昵称头像中',
name: 'test',
discription: '请稍等片刻',
direction: 'column',
type: 'origin',
originDivWidth: 40,
originDivHeight: 40,
originWidth: 6,
originHeight: 6,
smallLoading: false,
loadingMaskBg: 'rgba(0,0,0,0.2)'
});
}
</script>
</div>
<?php
include_once 'footer.php';
?>
</body>
</html>