forumnav.php
2.88 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
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: forumnav.php 34314 2014-02-20 01:04:24Z nemohou $
*/
if(!defined('IN_MOBILE_API')) {
exit('Access Denied');
}
include_once 'forum.php';
class mobile_api {
function common() {
global $_G;
$forums = array();
$sql = !empty($_G['member']['accessmasks']) ?
"SELECT f.fid, f.type, f.name, f.fup, f.status, ff.password, ff.redirect, ff.viewperm, ff.postperm, ff.threadtypes, ff.threadsorts
FROM ".DB::table('forum_forum')." f
LEFT JOIN ".DB::table('forum_forumfield')." ff ON ff.fid=f.fid
LEFT JOIN ".DB::table('forum_access')." a ON a.uid='$_G[uid]' AND a.allowview>'0' AND a.fid=f.fid
WHERE f.status='1' ORDER BY f.type, f.displayorder"
: "SELECT f.fid, f.type, f.name, f.fup, f.status, ff.password, ff.redirect, ff.viewperm, ff.postperm, ff.threadtypes, ff.threadsorts
FROM ".DB::table('forum_forum')." f
LEFT JOIN ".DB::table('forum_forumfield')." ff USING(fid)
WHERE f.status='1' ORDER BY f.type, f.displayorder";
$query = DB::query($sql);
while($forum = DB::fetch($query)) {
if($forum['redirect'] || $forum['password']) {
continue;
}
if(!$forum['viewperm'] || ($forum['viewperm'] && forumperm($forum['viewperm']))) {
$forum['name'] = strip_tags($forum['name']);
if($forum['threadsorts']) {
$forum['threadsorts'] = unserialize($forum['threadsorts']);
foreach($forum['threadsorts']['types'] as $k => $v) {
$forum['threadsorts']['types'][$k] = strip_tags($v);
}
$forum['threadsorts'] = mobile_core::getvalues($forum['threadsorts'], array('required', 'types'));
}
if($forum['threadtypes']) {
$forum['threadtypes'] = unserialize($forum['threadtypes']);
$unsetthreadtype = false;
if($_G['adminid'] == 3 && strpos($forum['moderators'], $_G['username']) === false) {
$unsetthreadtype = true;
}
if($_G['adminid'] == 0) {
$unsetthreadtype = true;
}
if($unsetthreadtype) {
foreach ($forum['threadtypes']['moderators'] AS $k => $v) {
if(!empty($v)) {
unset($forum['threadtypes']['types'][$k]);
}
}
}
$flag = 0;
foreach($forum['threadtypes']['types'] as $k => $v) {
$forum['threadtypes']['types'][$k] = strip_tags($v);
if($k == 0) {
$flag = 1;
}
}
if($flag == 1) {
krsort($forum['threadtypes']['types']);
}
$forum['threadtypes'] = mobile_core::getvalues($forum['threadtypes'], array('required', 'types'));
}
$forums[] = mobile_core::getvalues($forum, array('fid', 'type', 'name', 'fup', 'viewperm', 'postperm', 'status', 'threadsorts', 'threadtypes'));
}
}
$variable['forums'] = $forums;
mobile_core::result(mobile_core::variable($variable));
}
function output() {}
}
?>