forked from jat001/youbbs
-
Notifications
You must be signed in to change notification settings - Fork 0
/
notifications.php
executable file
·55 lines (47 loc) · 1.71 KB
/
notifications.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
<?php
define('IN_SAESPOT', 1);
define('ROOT', dirname(__FILE__));
include_once(ROOT . '/config.php');
include_once(ROOT . '/common.php');
if (!$cur_user) {
include_once(ROOT . '/error/401.php');
exit;
} else {
if ($cur_user['flag'] == 0){
$error_code = 4032;
include_once(ROOT . '/error/403.php');
exit;
}
if ($cur_user['flag'] == 1){
$error_code = 4011;
include_once(ROOT . '/error/403.php');
exit;
}
}
// 获取提醒文章列表
$cur_user = $DBS->fetch_one_array("SELECT * FROM yunbbs_users WHERE id='".$cur_uid."' LIMIT 1");
$MMC->set('u_'.$cur_uid, $cur_user, 0, 600);
if($cur_user['notic']){
$ids = implode(',', array_unique(explode(',', substr($cur_user['notic'], 0, -1))));
$query_sql = "SELECT a.id,a.uid,a.cid,a.ruid,a.title,a.addtime,a.edittime,a.comments,c.name as cname,u.avatar as uavatar,u.name as author,ru.name as rauthor
FROM yunbbs_articles a
LEFT JOIN yunbbs_categories c ON c.id=a.cid
LEFT JOIN yunbbs_users u ON a.uid=u.id
LEFT JOIN yunbbs_users ru ON a.ruid=ru.id
WHERE a.id in(".$ids.")";
$query = $DBS->query($query_sql);
$articledb=array();
while ($article = $DBS->fetch_array($query)) {
// 格式化内容
$article['addtime'] = showtime($article['addtime']);
$article['edittime'] = showtime($article['edittime']);
$articledb[] = $article;
}
unset($article);
$DBS->free_result($query);
}
// 页面变量
$title = '站内提醒 - '.$options['name'];
$pagefile = ROOT . '/templates/default/'.$tpl.'notifications.php';
include_once(ROOT . '/templates/default/'.$tpl.'layout.php');
?>