-
Notifications
You must be signed in to change notification settings - Fork 9
/
notification.php
52 lines (40 loc) · 1.19 KB
/
notification.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
<?php
if (empty($user)) {
header("Location: /");
exit();
}
if ($urlparts[1] == 'clearall') {
$con->Execute("update notification set `read`=1 where userid=?", array($user['userid']));
header("Location: /");
exit();
}
$not = $con->getRow("select * from notification where notificationid=?", array($urlparts[1]));
if (empty($not)) {
header("Location: /");
exit();
}
$con->Execute("update notification set `read`=1 where notificationid=? and userid=?", array($not['notificationid'], $user['userid']));
if ($not['type'] == "newrelease") {
$row = $con->getRow("
select
`mod`.assetid,
`mod`.urlalias as modalias
from
`mod`
where modid=?
", array($not['recordid']));
$url = $row['modalias'] ? "/" . $row['modalias'] : "show/mod/" . $row['assetid'];
header("Location: {$url}#tab-files");
} else {
$cmt = $con->getRow("
select
commentid,
`mod`.urlalias as modalias
from
comment
join `mod` on (comment.assetid = `mod`.assetid)
where commentid=?
", array($not['recordid']));
$url = $cmt['modalias'] ? "/" . $cmt['modalias'] : "show/mod/" . $cmt['assetid'];
header("Location: {$url}#cmt-{$cmt['commentid']}");
}