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:
|
/* ############## Top 5 Statistik Start ############## */
if ($top5show == 1 && ($top5showgast == 1 || $wbbuserdata['userid'])){
function getBoards()
{
global $db,$n,$wbbuserdata,$boardcache,$top5excludedboards;
if(isset($top5excludedboards) && $top5excludedboards != ''){
//$result=$db->query("SELECT boardid,boardorder,parentid,parentlist FROM bb".$n."_boards WHERE password='' AND invisible!='2' AND boardid NOT IN(".$top5excludedboards.") ORDER BY parentid ASC, boardorder ASC");
$result=$db->query("SELECT boardid FROM bb".$n."_boards WHERE password = '' AND invisible != '2' AND boardid NOT IN(".$top5excludedboards.")");
} else {
//$result=$db->query("SELECT boardid,boardorder,parentid,parentlist FROM bb".$n."_boards WHERE password='' AND invisible!='2' ORDER BY parentid ASC, boardorder ASC");
$result=$db->query("SELECT boardid FROM bb".$n."_boards WHERE password = '' AND invisible != '2'");
}
$boardpermissions=getPermissions();
$boardids='0';
if ( $wbbuserdata['userid'] == '') {
while($row=$db->fetch_array($result)) {
$can_view_board = false;
$can_enter_board = false;
$can_read_thread = false;
if (isset($boardpermissions[$row['boardid']]['can_view_board']) && $boardpermissions[$row['boardid']]['can_view_board'] == 1){
$can_view_board = true;
}
if (isset($boardpermissions[$row['boardid']]['can_enter_board']) && $boardpermissions[$row['boardid']]['can_enter_board'] == 1){
$can_enter_board = true;
}
if (isset($boardpermissions[$row['boardid']]['can_read_thread']) && $boardpermissions[$row['boardid']]['can_read_thread'] == 1){
$can_read_thread = true;
}
if ($can_view_board == true && $can_enter_board == true && $can_read_thread == true) {
$boardids.=",".$row['boardid'];
}
}
} else {
while($row=$db->fetch_array($result)) {
$can_view_board = false;
$can_enter_board = false;
$can_read_thread = false;
if (!isset($boardpermissions[$row['boardid']]['can_view_board']) || $boardpermissions[$row['boardid']]['can_view_board'] == 1){
$can_view_board = true;
}
if (!isset($boardpermissions[$row['boardid']]['can_enter_board']) || $boardpermissions[$row['boardid']]['can_enter_board'] == 1){
$can_enter_board = true;
}
if (!isset($boardpermissions[$row['boardid']]['can_read_thread']) || $boardpermissions[$row['boardid']]['can_read_thread'] == 1){
$can_read_thread = true;
}
if ($can_view_board == true && $can_enter_board == true && $can_read_thread == true) {
$boardids.=",".$row['boardid'];
}
}
}
return $boardids;
}
if ( isset($top5view) && is_numeric($top5view) ){
$top5limit = $top5view;
} else {
$top5limit = 5;
}
// Start Top Poster
$posts5 = $db->query("SELECT userid,username,userposts FROM bb".$n."_users ORDER BY userposts DESC LIMIT ".$top5limit);
$posts5name = '';
$posts5post = '';
while ($posts5top = $db->fetch_array($posts5)){
$posts5name .= '» <a href="profile.php?userid='.$posts5top['userid'].'&sid='.$session['hash'].'">'.$posts5top['username'].'</a><br />';
$posts5post .= $posts5top['userposts'].'<br />';
}
// Ende Top Poster
// Start letzte Mitglieder
$user = $db->query("SELECT userid,userposts,username,regdate FROM bb".$n."_users WHERE activation='1' ORDER BY regdate DESC LIMIT ".$top5limit);
$username = '';
$userposts = '';
$userdays = '';
while ($usertop = $db->fetch_array($user)){
$username .= '» <a href="profile.php?userid='.$usertop['userid'].'&sid='.$session['hash'].'">'.$usertop['username'].'</a><br />';
$userposts .= $usertop['userposts'].'<br />';
$tage = round( (mktime() - $usertop['regdate'])/86400 );
if($tage == 1){
$userdays .= $tage.' Tag<br />';
} else {
$userdays .= $tage.' Tagen<br />';
}
//$userdays .= round( (mktime() - $usertop['regdate'])/86400 ).' Tagen<br />';
}
// Ende letzte Mitglieder
// Start letzte Beiträge
$pop = $db->query("SELECT bb".$n."_threads.threadid, bb".$n."_threads.boardid as parentid, bb".$n."_threads.topic, bb".$n."_threads.lastposttime, bb".$n."_threads.replycount, bb".$n."_threads.views, bb".$n."_users.userid, bb".$n."_users.username FROM bb".$n."_threads LEFT JOIN bb".$n."_users ON (bb".$n."_users.userid=bb".$n."_threads.lastposterid) LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid) WHERE bb".$n."_threads.boardid IN (".getBoards().") ORDER BY bb".$n."_threads.lastposttime DESC LIMIT ".$top5limit);
$popthread = '';
$lastposter = '';
$popviews = '';
$popposts = '';
while ($poptop = $db->fetch_array($pop)){
if(strlen($poptop['topic']) > '37') $poptop['topic'] = "".substr($poptop['topic'], 0, 34)."...";
$popthread .= '» <a href="thread.php?goto=lastpost&threadid='.$poptop['threadid'].'&sid='.$session['hash'].'">'.$poptop['topic'].'</a><br />';
$lastposter .= '<a href="profile.php?userid='.$poptop['userid'].'&sid='.$session['hash'].'">'.$poptop['username'].'</a><br />';
$popviews .= $poptop['views'].'<br />';
$popposts .= $poptop['replycount'].'<br />';
}
// Ende letzte Beiträge
if ( isset($top5view2) && is_numeric($top5view2) ){
$top5limit = $top5view2;
} else {
$top5limit = 1;
}
// Start Top Themen
$pop1title = '';
$pop1views = '';
$pop1 = $db->query("SELECT bb".$n."_threads.topic, bb".$n."_threads.threadid, bb".$n."_threads.views, bb".$n."_threads.boardid FROM bb".$n."_threads LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid) ORDER BY bb".$n."_threads.views DESC LIMIT ".$top5limit);
if ($top5limit == 1){
while ($pop1top = $db->fetch_array($pop1)){
$pop1title = '<a href="thread.php?threadid='.$pop1top['threadid'].'&boardid='.$pop1top['boardid'].'&sid='.$session['hash'].'">'.$pop1top['topic'].'</a>';
$pop1views = $pop1top['views'];
}
} else {
while ($pop1top = $db->fetch_array($pop1)){
$pop1title .= '<a href="thread.php?threadid='.$pop1top['threadid'].'&boardid='.$pop1top['boardid'].'&sid='.$session['hash'].'">'.$pop1top['topic'].'</a><br />';
$pop1views .= $pop1top['views'].'<br />';
}
}
// Ende Top Themen
// Start Top Bewertung
$voted = $db->query("SELECT bb".$n."_threads.topic, bb".$n."_threads.threadid, bb".$n."_threads.votepoints/bb".$n."_threads.voted AS vote, bb".$n."_threads.boardid FROM bb".$n."_threads LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid) ORDER BY vote DESC LIMIT ".$top5limit);
$votedthread = '';
$votedrating = '';
if ($top5limit == 1){
while ($votedtop = $db->fetch_array($voted)){
$votedthread = '<a href="thread.php?threadid='.$votedtop['threadid'].'&boardid='.$votedtop['boardid'].'&sid='.$session['hash'].'">'.$votedtop['topic'].'</a>';
$votedrating = $votedtop['vote'];
}
} else {
while ($votedtop = $db->fetch_array($voted)){
$votedthread .= '<a href="thread.php?threadid='.$votedtop['threadid'].'&boardid='.$votedtop['boardid'].'&sid='.$session['hash'].'">'.$votedtop['topic'].'</a><br />';
$votedrating .= $votedtop['vote'].'<br />';
}
}
// Ende Top Bewertung
// Start Template
eval ("\$top5threadstats = "".$tpl->get("index_topfive")."";");
// Ende Template
} else {
$top5threadstats = '';
}
/* ############## Top 5 Statistik Ende ############## *//* ############## USERONLINE ############## */ |
