yourWBB | [WBB Lite 1.0.x] Allg. Fragen und Probleme | "Statistik" und "User online" nicht nur im Index anzeigen lassen

$index_stats=""; /* ############## STATS ############## */ if($showstats==1) { $members=$db->query_first("SELECT COUNT(*) AS members, MAX(userid) AS userid FROM bb".$n."_users WHERE activation = 1"); $newestmember=$db->query_first("SELECT userid, username FROM bb".$n."_users WHERE userid = '$members[userid]'"); $posts=$db->query_first("SELECT COUNT(*) AS posts FROM bb".$n."_posts"); $threads=$db->query_first("SELECT COUNT(*) AS threads FROM bb".$n."_threads"); $installdays = (time() - $installdate) / 86400; if ($installdays < 1) $postperday = $posts['posts']; else $postperday = sprintf("%.2f",($posts['posts'] / $installdays)); eval ("\$index_stats = \"".$tpl->get("index_stats")."\";"); }

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:
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:

$index_stats="";
$welcome="";
$index_pms="";
if(!$wbbuserdata['userid']) {
 eval ("\$welcome = \"".$tpl->get("index_welcome")."\";");
 eval ("\$quicklogin = \"".$tpl->get("index_quicklogin")."\";");
}
else {
 $currenttime=formatdate($timeformat,time());
 $toffset=ifelse($default_timezoneoffset>=0,"+").$default_timezoneoffset;
 $lastvisitdate = formatdate($dateformat,$wbbuserdata['lastvisit']);
 $lastvisittime = formatdate($timeformat,$wbbuserdata['lastvisit']);
 eval ("\$welcome = \"".$tpl->get("index_hello")."\";");
 if($wbbuserdata['canusepms']==1 && $showpmonindex==1) {
  $counttotal=0; $countunread=0; $countnew=0;
  $result = $db->query("SELECT view, sendtime FROM bb".$n."_privatemessage WHERE deletepm <> 1 AND recipientid = '$wbbuserdata[userid]'");
  while($row=$db->fetch_array($result)) {
   $counttotal++;
   if($row['view']==0) {
    $countunread++;
    if($row['sendtime']>$wbbuserdata['lastvisit']) $countnew++;
   }
  }
if($countnew==1) $countnew2="1 neue Nachricht";
   else $countnew2="$countnew neue Nachrichten";

  if($counttotal==1) $counttotal2="1 Nachricht";
   else $counttotal2="$counttotal Nachrichten";
  if($countnew>0) eval ("\$new_notnew = \"".$tpl->get("index_newpm")."\";");
  else eval ("\$new_notnew = \"".$tpl->get("index_nonewpm")."\";");
  $result=mysql_query("SELECT * FROM bb".$n."_users WHERE userid='$wbbuserdata[userid]' AND parentid != '0'") or die(mysql_error());
if(mysql_num_rows($result)>='1'){
        $check_ca=mysql_fetch_array($result);
        $parentid=$check_ca[parentid];
                $result2=mysql_query("SELECT * FROM bb".$n."_privatemessage WHERE recipientid='$parentid' AND view = '0' AND deletepm='0'") or die(mysql_error());
                $anzahl_pm=mysql_num_rows($result2);
                        if($anzahl_pm=='1'){
                                $result3=mysql_query("SELECT username FROM bb".$n."_users WHERE userid='$parentid'") or die(mysql_error());
                                $which_account=mysql_fetch_array($result3);
                                $mainaccount=$which_account[username];
                                $new_pm_info="Du hast auf dem Account von <b>$mainaccount</b> eine neue Nachricht!<br>";
                                eval ("\$new_pms_zm = \"".$tpl->get("index_pms_zm")."\";");
                        }
                        if($anzahl_pm>'1'){
                                $result3=mysql_query("SELECT username FROM bb".$n."_users WHERE userid='$parentid'") or die(mysql_error());
                                $which_account=mysql_fetch_array($result3);
                                $mainaccount=$which_account[username];
                                $new_pm_info="Du hast auf dem Account von <b>$mainaccount</b> $anzahl_pm neue Nachrichten!<br>";
                                eval ("\$new_pms_zm = \"".$tpl->get("index_pms_zm")."\";");
                }
        $result3=mysql_query("SELECT * FROM bb".$n."_users WHERE parentid='$parentid' ORDER BY username ASC") or die(mysql_error());
        if(mysql_num_rows($result3)>'1'){
                while($check_c2a=mysql_fetch_array($result3)){
                $which_username=$check_c2a[username];
                $which_userid=$check_c2a[userid];
                        if($which_userid != $wbbuserdata[userid]){
                                $result4=mysql_query("SELECT * FROM bb".$n."_privatemessage WHERE recipientid='$which_userid' AND view = '0' AND deletepm='0'") or die(mysql_error());
                                $anzahl_pm=mysql_num_rows($result4);
                                        if($anzahl_pm=='1'){
                                                $new_pm_info="Du hast auf dem Account von <b>$which_username</b> eine neue Nachricht!<br>";
                                        }
                                        elseif($anzahl_pm>'1'){
                                                $new_pm_info="Du hast auf dem Account von <b>$which_username</b> $anzahl_pm neue Nachrichten!<br>";
                                        }
                                        else{
                                                $new_pm_info='';
                                        }
                        eval ("\$new_pms_zz .= \"".$tpl->get("index_pms_zz")."\";");
                        }
                }
        }
}
$result2=mysql_query("SELECT * FROM bb".$n."_users WHERE parentid='$wbbuserdata[userid]'") or die(mysql_error());
if(mysql_num_rows($result2)>='1'){
                while($check_sa=$db->fetch_array($result2)){
                        $other_userid=$check_sa[userid];
                        $other_username=$check_sa[username];
                                $result3=mysql_query("SELECT * FROM bb".$n."_privatemessage WHERE recipientid='$other_userid' AND view = '0' AND deletepm='0'") or die(mysql_error());
                                $anzahl_pm=mysql_num_rows($result3);
                                        if($anzahl_pm=='1'){
                                                $new_pm_info="Du hast auf dem Account von <b>$other_username</b> eine neue Nachricht!<br>";
                                        }
                                        elseif($anzahl_pm>'1'){
                                                $new_pm_info="Du hast auf dem Account von <b>$other_username</b> $anzahl_pm neue Nachrichten!<br>";
                                        }
                                        else{
                                                $new_pm_info='';
                                        }
                eval ("\$new_pms_mz .= \"".$tpl->get("index_pms_mz")."\";");
                }
}
  eval ("\$index_pms = \"".$tpl->get("index_pms")."\";");
 }
}
/* ############## STATS ############## */
if($showstats==1) {
 $members=$db->query_first("SELECT COUNT(*) AS members, MAX(userid) AS userid FROM bb".$n."_users WHERE activation = 1");
 $newestmember=$db->query_first("SELECT userid, username FROM bb".$n."_users WHERE userid = '$members[userid]'");
 $posts=$db->query_first("SELECT COUNT(*) AS posts FROM bb".$n."_posts");
 $threads=$db->query_first("SELECT COUNT(*) AS threads FROM bb".$n."_threads");

 $installdays = (time() - $installdate) / 86400;
 if ($installdays < 1) $postperday = $posts['posts'];
 else $postperday = sprintf("%.2f",($posts['posts'] / $installdays));

 eval ("\$index_stats = \"".$tpl->get("index_stats")."\";");
}