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:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:

<?php
$filename="index.php";

require("./global.php");

if(isset($_COOKIE['boardvisit'])) $boardvisit=decode_cookie($_COOKIE['boardvisit']);
else $boardvisit=array();

if(isset($_COOKIE['threadvisit'])) $threadvisit=decode_cookie($_COOKIE['threadvisit']);
else $threadvisit=array();

$boardcache=array();
$permissioncache=array();
$modcache=array();

$activtime=time()-60*$useronlinetimeout;

$result = $db->query("
 SELECT
 b.*".ifelse($showlastposttitle==1,", t.topic, i.*")."
 FROM bb".$n."_boards b
 ".ifelse($showlastposttitle==1,"LEFT JOIN bb".$n."_threads t ON (t.threadid=b.lastthreadid)
 LEFT JOIN bb".$n."_icons i USING (iconid)")."
 ORDER by b.parentid ASC, b.boardorder ASC");
while ($row = $db->fetch_array($result)) $boardcache[$row['parentid']][$row['boardorder']][$row['boardid']] = $row;


$result = $db->query("SELECT boardid, threadid, lastposttime FROM bb".$n."_threads WHERE visible = 1 AND lastposttime > '$wbbuserdata[lastvisit]' AND closed <> 3");
while($row=$db->fetch_array($result)) $visitcache[$row['boardid']][$row['threadid']]=$row['lastposttime'];

$result = $db->query("SELECT * FROM bb".$n."_permissions WHERE groupid = '$wbbuserdata[groupid]'");
while ($row = $db->fetch_array($result)) $permissioncache[$row['boardid']] = $row;

$result = $db->query("SELECT bb".$n."_moderators.*, username FROM bb".$n."_moderators LEFT JOIN bb".$n."_users USING (userid) ORDER BY username ASC");
while ($row = $db->fetch_array($result)) $modcache[$row['boardid']][] = $row;

$boardbit = makeboardbit(0);

$index_pms="";
$quicklogin="";
$index_useronline="";
$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")."";");
}
/* ############## USERONLINE ############## */
if($showuseronline==1) {
 $guestcount=0;
 $membercount=0;
 $useronlinebit = '';
 $result = $db->query("SELECT bb".$n."_sessions.userid, username, groupid, invisible, avatarid FROM bb".$n."_sessions LEFT JOIN bb".$n."_users USING (userid) WHERE bb".$n."_sessions.lastactivity >= '".(time()-60*$useronlinetimeout)."' ORDER BY username ASC");
 while($row = $db->fetch_array($result)) {
  if($row['userid']==0) {
   $guestcount++;
   continue;
  }
  $membercount++;
  	if(!$row['invisible']) {
  		if(isset($useronlinebit) && $useronlinebit != '') $useronlinebit .= ', ';
/*UserOnline Hover-Ava*/
 $showava="";
 $avaqry = $db->query_first("SELECT * FROM bb".$n."_avatars WHERE avatarid='$row[avatarid]'");
 if($avaqry['avatarid'] && $showavatar==1 && $wbbuserdata['showavatars']==1) {
 $showava=" onMouseOver="return overlib('<img src=images/avatars/avatar-$avaqry[avatarid].$avaqry[avatarextension]>',RIGHT,ol_fgcolor='{tabletitlecolor}',ol_bgcolor='{tableinbordercolor}',ol_width='$avaqry[width]');" onMouseOut="return nd();"";
 }
 /*UserOnline Hover-Ava*/
  		eval ("\$useronlinebit .= "".$tpl->get("index_useronline")."";");
  	}
 }
 $totaluseronline = $membercount+$guestcount;
 if($totaluseronline>$rekord) {
  $rekord=$totaluseronline;
  $rekordtime=time();
  $db->unbuffered_query("UPDATE bb".$n."_options SET value='$rekord' WHERE varname='rekord'",1);
  $db->unbuffered_query("UPDATE bb".$n."_options SET value='$rekordtime' WHERE varname='rekordtime'",1);
  require ("./acp/lib/class_options.php");
  $option=new options("acp/lib");
  $option->write();
 }
 $rekorddate = formatdate($dateformat,$rekordtime);
 $rekordtime = formatdate($timeformat,$rekordtime);
 eval ("\$index_useronline = "".$tpl->get("index_showuseronline")."";");
}


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>0) eval ("\$new_notnew = "".$tpl->get("index_newpm")."";");
  else eval ("\$new_notnew = "".$tpl->get("index_nonewpm")."";");
  eval ("\$index_pms = "".$tpl->get("index_pms")."";");
 }
}
/* ############## USER HEUTE ############## */
$usertoday=0;
$usertodaybit='';
$result = $db->query("SELECT lastactivity, username, userid, invisible FROM bb".$n."_users ORDER BY lastactivity DESC");
while($row = $db->fetch_array($result)) {
 $zeit = date("dmY", $row['lastactivity']);
 $jetzt = date("dmY");
 $last = date('H:i:s',$row['lastactivity']);
 if(!$row['invisible'] && $zeit==$jetzt) {
  $usertoday++;
  if($usertoday=="1") {
  $war = 'war';
  $reg = 'registrierter';
  } else {
  $war = 'waren';
  $reg = 'registrierte';
  }
  if(isset($usertodaybit) && $usertodaybit != '') $usertodaybit .= ', ';
  eval ("\$usertodaybit .= "".$tpl->get("index_useronline").' (zuletzt um '.$last.')'."";");
 }
}
/* ############## USER HEUTE ############## */
$result = $db->query_first("SELECT * FROM bb".$n."_groups WHERE groupid = '$wbbuserdata[groupid]'");
  if($result['canseesbox']==1) {
    if($result['canusesbox']==1) {
      eval ("\$sbox_input = "".$tpl->get("shoutbox_input")."";");      
      $result = $db->query_first("SELECT * FROM bb".$n."_shoutbox_config");
      if($result['smilies']==1) {
        $bbcode_smilies = getclickysmilies(3,15);
        eval ("\$shoutbox_bbcode = "".$tpl->get("shoutbox_bbcode")."";");
      }
    }
    else {
	$result = $db->query_first("SELECT * FROM bb".$n."_shoutbox_config");
	}
    if($result['status']==1) {
	  eval ("\$shoutbox = "".$tpl->get("shoutbox")."";");
    } 
  }
eval("\$tpl->output("".$tpl->get("index")."");");
?>