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:
|
/* ############## Top 5 Statistik Mainpage Start ############## */
// Start Top 5 Poster
$posts5 = $db->query("SELECT userid,username,userposts FROM bb".$n."_users ORDER BY userposts DESC LIMIT 5");
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 5 Poster
// Start Letzte 5 Mitglieder
$user = $db->query("SELECT userid,userposts,username,regdate FROM bb".$n."_users WHERE activation='1' ORDER BY regdate DESC LIMIT 5");
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>";
}
// Ende Letzte 5 Mitglieder
// Start Letzte 5 Beiträge
$pop = $db->query("SELECT
bb".$n."_threads.topic,
bb".$n."_threads.threadid,
bb".$n."_threads.lastposttime,
bb".$n."_threads.views,
bb".$n."_users.userid,
bb".$n."_threads.boardid as parentid,
bb".$n."_users.username,
bb".$n."_boards.invisible
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."_boards.invisible=0
ORDER BY bb".$n."_threads.lastposttime DESC LIMIT 5");
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>";
}
// Ende Letzte 5 Beiträge
// Start Top Themen
$pop1 = $db->query("SELECT bb".$n."_threads.topic,
bb".$n."_threads.threadid,
bb".$n."_threads.views,
bb".$n."_threads.boardid,
bb".$n."_boards.invisible
FROM bb".$n."_threads
LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid)
WHERE bb".$n."_boards.invisible=0
ORDER BY bb".$n."_threads.views DESC LIMIT 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]";
}
// Ende Top Themen
// Start Top Bewertung
$voted = $db->query("SELECT bb".$n."_threads.topic,
bb".$n."_threads.threadid,
bb".$n."_threads.voted,
bb".$n."_threads.votepoints,
bb".$n."_threads.boardid,
bb".$n."_boards.invisible
FROM bb".$n."_threads
LEFT JOIN bb".$n."_boards ON (bb".$n."_boards.boardid=bb".$n."_threads.boardid)
WHERE bb".$n."_boards.invisible=0
ORDER BY bb".$n."_threads.voted DESC LIMIT 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[votepoints]";
}
// Ende Top Bewertung
// Start des template aufrufs
eval ("\$top5threadstats = \"".$tpl->get("index_topfive")."\";");
// Ende templates aufruf
|