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:
|
<?php
require ("./global.php");
isAdmin();
$db->unbuffered_query("DELETE FROM bb".$n."_sessions WHERE lastactivity<".(time()-$sessiontimeout),1);
$db->unbuffered_query("DELETE FROM bb".$n."_searchs WHERE searchtime<".(time()-86400*7),1);
$install_date=formatdate($dateformat." ".$timeformat,$installdate);
list($usercount)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_users");
list($useronlinecount)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_sessions WHERE lastactivity >= '".(time()-60*$useronlinetimeout)."'");
list($postcount)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_posts");
list($threadcount)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_threads");
$installdays = (time() - $installdate) / 86400;
if($installdays < 1) {
$postsperday = $postcount;
$threadsperday = $threadcount;
}
else {
$postsperday = sprintf("%.2f",($postcount / $installdays));
$threadsperday = sprintf("%.2f",($threadcount / $installdays));
}
list($waiting4Activation)=$db->query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE activation<>1");
eval("print(\"".gettemplate("welcome")."\");");
if($action=="stat") {
$username = $wbbuserdata[username];
$inaktiv = $db->query_first("SELECT COUNT(userid) FROM bb".$n."_users WHERE activation = 0");
$blocked = $db->query_first("SELECT COUNT(userid) FROM bb".$n."_users WHERE blocked = 1");
$invisible = $db->query_first("SELECT COUNT(userid) FROM bb".$n."_users WHERE invisible = 1");
$pms_count = $db->query_first("SELECT COUNT(*) FROM bb".$n."_privatemessage");
$newestuser = $db->query_first("SELECT userid,username FROM bb".$n."_users WHERE activation='1' ORDER by regdate DESC LIMIT 1");
$newestuser = "<a href=\"../profile.php?userid=$newestuser[userid]\" target=\"_blank\">$newestuser[username]</a>";
$male = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE (gender=1)");
$male = $male[0];
$female = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE (gender=2)");
$female = $female[0];
$keineangabe = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE (gender=0)");
$keineangabe = $keineangabe[0];
$admin_count = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE (groupid=1)");
$admin_count = $admin_count[0];
$s_mod_count = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE (groupid=2)");
$s_mod_count = $s_mod_count[0];
$mod_count = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_users WHERE (groupid=3)");
$mod_count = $mod_count[0];
$avatars = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_avatars");
$avatars = $avatars[0];
$smilies = $db -> query_first("SELECT COUNT(*) FROM bb".$n."_smilies");
$smilies = $smilies[0];
$invisible = $invisible[0];
$inaktiv = $inaktiv[0];
$blocked = $blocked[0];
$pms_count = $pms_count[0];
//Versionsnummern
$result = $db->query_first("show variables like 'version'");
$mysqlver = $result[1];
$serverinfo = getenv("SERVER_SOFTWARE");
//
//belegter Mysql Speicher
$table_data = 0;
$table_idx = 0;
$db_all = 0;
$result = $db->query("SHOW TABLE STATUS");
while ($row = $db->fetch_array($result)) {
$table_data += $row['Data_length'];
$table_idx += $row['Index_length'];
}
$db_all = $table_data + $table_idx;
$mysqlmem = round($db_all/1048576,2);
//
$threadsperuser = sprintf("%.2f",($threadcount / $usercount));
$postsperuser = sprintf("%.2f",($postcount / $usercount));
$db->free_result($result);
$in_count = $db->query_first("SELECT COUNT(boardid) FROM bb".$n."_boards WHERE invisible <> 0");
$in_count = $in_count[0];
$important = $db->query_first("SELECT COUNT(boardid) FROM bb".$n."_threads WHERE important <> 0");
$important = $important[0];
$ank_count = $db->query_first("SELECT COUNT(*) FROM bb".$n."_announcements");
$ank_count = $ank_count[0];
$bb_count = $db->query_first("SELECT COUNT(*) FROM bb".$n."_bbcodes");
$bb_count = $bb_count[0];
$gr_count = $db->query_first("SELECT COUNT(*) FROM bb".$n."_groups");
$gr_count = $gr_count[0];
$rk_count = $db->query_first("SELECT COUNT(*) FROM bb".$n."_ranks");
$rk_count = $rk_count[0];
$st_count = $db->query_first("SELECT COUNT(*) FROM bb".$n."_styles");
$st_count = $st_count[0];
$fo_count = $db->query_first("SELECT COUNT(isboard) FROM bb".$n."_boards WHERE isboard <> 0");
$fo_count = $fo_count[0];
$closed_th = $db->query_first("SELECT COUNT(boardid) FROM bb".$n."_threads WHERE closed <> 0");
$closed_th = $closed_th[0];
$ka_count = $db->query_first("SELECT COUNT(isboard) FROM bb".$n."_boards WHERE isboard <> 1");
$ka_count = $ka_count[0];
$in_ka_count = $db->query_first("SELECT COUNT(isboard) FROM bb".$n."_boards WHERE isboard <> 1 AND invisible ='1'");
$in_ka_count = $in_ka_count[0];
$polls = $db->query_first("SELECT COUNT(*) FROM bb".$n."_polls WHERE pollid <> 0");
$polls = $polls[0];
$admins01 = $db->query ("SELECT userid,username,groupid FROM bb".$n."_users WHERE groupid ='1' ORDER BY username DESC");
$admins = "";
while ($row01 = $db->fetch_array ($admins01)) {
$admins .= "<smallfont><a href=\"../profile.php?userid=$row01[userid]\" target=\"_blank\">$row01[username]</a>, </font>";
}
$mods01 = $db->query ("SELECT userid,username,groupid FROM bb".$n."_users WHERE groupid ='3' ORDER BY username DESC");
$mods = "";
while ($row02 = $db->fetch_array ($mods01)) {
$mods .= "<smallfont><a href=\"../profile.php?userid=$row02[userid]\" target=\"_blank\">$row02[username]</a>, </font>";
}
$s_mod01 = $db->query ("SELECT userid,username,groupid FROM bb".$n."_users WHERE groupid ='2' ORDER BY username DESC");
$s_mods = "";
while ($row03 = $db->fetch_array ($s_mod01)) {
$s_mods .= "<smallfont><a href=\"../profile.php?userid=$row03[userid]\" target=\"_blank\">$row03[username]</a>, </font>";
}
eval("print(\"".gettemplate("welcome2")."\");");
}
?>
|
