\n"; } opentable($locale['400']); renderNav(false,false,array(FORUM."index.php", $locale['fb916'])); $forum_list = ""; $current_cat = ""; $result = dbquery( "SELECT f.*, f3.forum_icon, f4.forum_collapsed, f2.forum_name AS forum_cat_name, u.user_id, u.user_name FROM ".DB_FORUMS." f LEFT JOIN ".DB_FORUMS." f2 ON f.forum_cat = f2.forum_id LEFT JOIN ".DB_USERS." u ON f.forum_lastuser = u.user_id LEFT JOIN ".DB_PREFIX."fb_forums f3 on f3.forum_id=f.forum_id LEFT JOIN ".DB_PREFIX."fb_forums f4 on f4.forum_id=f2.forum_id WHERE ".groupaccess('f.forum_access')." AND f.forum_cat!='0' AND f3.forum_parent='0' GROUP BY forum_id ORDER BY f2.forum_order ASC, f.forum_order ASC" ); $rows = dbrows($result); $i=0; if (dbrows($result) != 0) { while ($data = dbarray($result)) { if ($data['forum_cat_name'] != $current_cat) { if($i > 0) echo "".($collapsible ? "" : "")."
\n"; $current_cat = $data['forum_cat_name']; echo "\n"; $state = ($data['forum_collapsed'] ? "off" : "on"); $boxname = "forum".$data['forum_id']; if($fb4['forum_icons']){ echo "\n\n\n"; echo ($collapsible ? "

".($collapsible ? panelbutton($state,$boxname) : "")."

\n ".$data['forum_cat_name']."

".panelstate($state, $boxname)."\n" : ""); echo "\n"; } else { echo "\n\n\n"; echo ($collapsible ? "

".$locale['401']."
".($collapsible ? panelbutton($state,$boxname) : "")." \n ".$data['forum_cat_name']."

".panelstate($state, $boxname)."\n" : ""); echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; } $i++; $moderators = ""; if ($data['forum_moderators']) { $mod_groups = explode(".", $data['forum_moderators']); foreach ($mod_groups as $mod_group) { if ($moderators) $moderators .= ", "; $moderators .= $mod_group<101 ? "".getgroupname($mod_group)."" : getgroupname($mod_group); } } $forum_match = "\|".$data['forum_lastpost']."\|".$data['forum_id']; if ($data['forum_lastpost'] > $lastvisited) { if (iMEMBER && preg_match("({$forum_match}\.|{$forum_match}$)", $userdata['user_threads'])) { $fim = " ".$locale[

"; } else { $fim = " ".$locale[

"; } } else { $fim = " ".$locale[

"; } echo "\n"; echo "\n"; if($data['forum_icon']){ $ficon = ($data['forum_icon'] !== "" ? $data['forum_icon'] : "folder.png"); } else { $ficon = "folder.png"; } if($fb4['forum_icons']){ $ficon = "

"; echo "\n"; } echo "\n"; ////////////////////naujausi forumo pranesimai////////////////////////////////////////////////// echo "\n"; } else { echo "".trimlink($childrenData['thread_subject'], 30)."
"; echo "".$locale['406']."".showLabel($childrenData['user_id'], false, "index")."

".timePassed($childrenData['thread_lastpost'], false)." ť

\n"; } } else { if ($data['forum_lastpost'] == 0) { echo $locale['405']."\n"; } else { $threadData = dbarray(dbquery("select * from ".$db_prefix."threads t left join ".$db_prefix."posts p on p.post_id=t.thread_lastpostid left join ".DB_USERS." u on u.user_id=p.post_author where t.thread_lastpost='".$data['forum_lastpost']."'")); echo "".trimlink($threadData['thread_subject'], 30)."
"; echo "".$locale['406']."".showLabel($threadData['user_id'], false, "index")."

".timePassed($data['forum_lastpost'], false)." ť

\n"; } } /////////////////////////////BAIGIASI////////////////////////////////////////////////////////////////// echo "\n"; echo "\n"; echo "\n"; } } else { echo "\n\n\n"; } echo "

".$locale['401']."

".$locale['404']."

".$locale['402']."

".$locale['403']."

$fim

$ficon

".$data['forum_name']."
\n"; if ($data['forum_description'] || $moderators) { echo "".$data['forum_description'].($data['forum_description'] && $moderators ? "
\n" : ""); echo ($moderators ? "".$locale['411']."".$moderators."\n" : "\n")."\n"; } $c_res = dbquery("select * from ".DB_PREFIX."forums f left join ".DB_PREFIX."fb_forums f2 on f2.forum_id=f.forum_id where ".groupaccess("f.forum_access")." AND f2.forum_parent='".$data['forum_id']."'"); if(dbrows($c_res)){ if($fb4['subforum_view']){ echo "
".$locale['fb552']." "; $i = dbrows($c_res); while($c_data = dbarray($c_res)){ $i--; echo "".$c_data['forum_name'].""; if($i > 0) echo ", "; } echo ""; } else { $counter = 0; $rows = 3; $sfimage1 = (file_exists(THEME."images/folder_open.png") ? THEME."images/folder_open.png" : INFUSIONS."fusionboard4/images/folder_open.png"); $sfimage2 = (file_exists(THEME."images/subforum.png") ? THEME."images/subforum.png" : INFUSIONS."fusionboard4/images/subforum.png"); echo "

".$locale['fb552']."
"; echo "

"; while($c_data = dbarray($c_res)){ if ($counter != 0 && ($counter % $rows == 0)) { echo "

\n"; } echo "

".$c_data['forum_name']."
"; $counter++; } echo "

"; } } echo "

"; $sql = dbquery("select * from ".DB_PREFIX."forums f left join ".DB_PREFIX."fb_forums f2 on f2.forum_id=f.forum_id where ".groupaccess("f.forum_access")." AND f2.forum_parent='".$data['forum_id']."'"); $posts = $data['forum_postcount']; $threads = $data['forum_threadcount']; $children = array(); if(dbrows($sql)){ while($child_data = dbarray($sql)){ array_push($children, $child_data['forum_id']); findChildren($child_data['forum_id']); } } if(count($children)){ $where = ""; $counter = count($children); $normalWhere = ""; foreach($children as $child){ $where .= "t.forum_id='$child' ".($counter > 1 ? "OR " : ""); $normalWhere .= "forum_id='$child' ".($counter > 1 ? "OR " : ""); $counter--; } $posts = $posts + dbcount("(post_id)", DB_POSTS, $normalWhere); $threads = $threads + dbcount("(thread_id)", DB_THREADS, $normalWhere); $childrenForums = dbquery("select * from ".$db_prefix."threads t left join ".$db_prefix."users u on u.user_id=t.thread_lastuser left join ".$db_prefix."posts p on p.post_id=t.thread_lastpostid where ($where OR t.forum_id='".$data['forum_id']."') order by t.thread_lastpost desc limit 1"); $childrenData = dbarray($childrenForums); if (!dbrows($childrenForums) && !$data['forum_lastpost']) { echo $locale['405']."

".$threads."

".$posts."

".$locale['407']."

\n\n\n"; echo "\n\n"; echo "\n\n

\n"; echo "

- ".$locale['409']."
\n"; echo "

- ".$locale['410']."\n"; echo "

\n"; echo "\n

\n"; $newest = dbarray(dbquery("select * from ".DB_USERS." order by user_id desc limit 1")); $search = array( "{POSTS}", "{THREADS}", "{USERS}", "{NEW}", "{ONLINE}", "{COUNT}", "{DATE}", "{RATINGS}" ); $replace = array( "".number_format(dbrows(dbquery("SELECT * FROM ".DB_POSTS)))."", "".number_format(dbrows(dbquery("SELECT * FROM ".DB_THREADS)))."", "".number_format(dbrows(dbquery("SELECT * FROM ".DB_USERS)))."", "".$newest['user_name']."", "".number_format(dbrows(dbquery("SELECT * FROM ".DB_PREFIX."online")))."", "".number_format($fb4['stat_moau'])."", "".strftime("%B %d %Y, %I:%M %p", $fb4['stat_moau_date'])."", "".number_format(dbrows(dbquery("SELECT * FROM ".DB_PREFIX."fb_rate")))."" ); $result = dbquery( "SELECT ton.*, tu.user_id,user_name,user_level FROM ".DB_ONLINE." ton LEFT JOIN ".DB_USERS." tu ON ton.online_user=tu.user_id" ); $guests = 0; $members = array(); while ($data = dbarray($result)) { if ($data['online_user'] !== "0") { array_push($members, array($data['user_id'], $data['user_name'], $data['user_level'])); } } $state="on"; $boxname="statistics"; echo "

".panelbutton($state,$boxname)."

\n".$locale['fb554']."

".panelstate($state, $boxname)." \n"; $levels = dbquery("select * from ".DB_PREFIX."fb_labels where (label_group > 100 and label_group < 104) or (label_group=0 and label_user=0) order by label_group desc"); $groups = dbquery("select * from ".DB_PREFIX."fb_labels l left join ".DB_USER_GROUPS." g on g.group_id=l.label_group where l.label_user='0' and (l.label_group != '0' and l.label_group != '101' and l.label_group != '102' and l.label_group !='103') order by g.group_name asc"); $counter = dbrows($levels)+dbrows($groups); $labels = ""; if(dbrows($levels)){ while($level_data = dbarray($levels)){ $labels .= "".getgroupname($level_data['label_group'])."".($counter > 1 ? ", " : ""); $counter--; } } if(dbrows($groups)){ while($group_data = dbarray($groups)){ $labels .= "".$group_data['group_name']."".($counter > 1 ? ", " : ""); $counter--; } } echo "\n"; echo "\n"; if($fb4['stat_bday'] > 0){ echo "\n"; } echo "

".str_replace($search,$replace,$locale['fb559'])."
	"; if($labels) echo $labels."
"; if (count($members)) { $i = 1; while (list($key, $member) = each($members)) { echo "".showLabel($member[0]).""; if ($i != count($members)) { echo ",\n"; } $i++; } } $guests = dbquery("select * from ".DB_ONLINE." where online_user='0'"); $i = dbrows($guests); if (dbrows($guests) && $fb4['stat_guests']){ if(count($members)) echo ", "; while($guest = dbarray($guests)){ $ip = explode(".", $guest['online_ip']); $label_res = dbquery("select * from ".DB_PREFIX."fb_labels where label_user='0' and label_group='0' limit 1"); if(dbrows($label_res)){ $label_data = dbarray($label_res); echo "".(iADMIN ? $guest['online_ip'] : ($ip[0].".".$ip[1].".xxx.xxx")).""; } else { echo (iADMIN ? $guest['online_ip'] : ($ip[0].".".$ip[1].".xxx.xxx")); } if($i > 1) echo ", "; $i--; } } echo "
\n"; if($fb4['stat_visitor']){ echo $locale['fb560']." \n"; $todayOnline = explode(".", $fb4['stat_today_users']); $i = (count($todayOnline)-1); foreach($todayOnline as $user){ if($user){ echo "".showLabel($user).""; if($i > 1) echo ", "; $i--; } } echo " "; } echo $locale['fb566']; $topPosters = dbquery("select * from ".DB_USERS." where user_posts>0 order by user_posts desc limit 5"); $i = 0; while($topPoster = dbarray($topPosters)){ if($i > 0) echo " \| "; echo "".showLabel($topPoster['user_id'])." (".number_format($topPoster['user_posts']).")"; $i++; } echo "
".($fb4['stat_bday'] == "1" ? $locale['fb562'] : $locale['fb564'].strftime("%B"))."
	"; if($fb4['stat_bday'] == "1"){ $today = strftime("%m-%d", time()); $result = dbquery("select * from ".DB_USERS." where user_birthdate like '%$today'"); } else { $today = strftime("%m", time()); $result = dbquery("select * from ".DB_USERS." where user_birthdate like '%-$today-%'"); } if(dbrows($result)){ $i = dbrows($result); while($data = dbarray($result)){ echo "".showLabel($data['user_id'])." ["; $birthday = explode("-", $data['user_birthdate']); $thisYear = strftime("%Y", time()); echo $thisYear-$birthday[0]; echo "]".($i > 1 ? ", " : ""); $i--; } } else { echo ($fb4['stat_bday'] == "1" ? $locale['fb563'] : $locale['fb565']); } echo "
".$locale['fb558']."
	".str_replace($search,$replace,$locale['fb555'])." \n"; if($fb4['show_ratings']) echo str_replace($search,$replace,$locale['fb569'])." \n"; echo str_replace($search,$replace,$locale['fb556'])." ".str_replace($search,$replace,$locale['fb557'])." ".str_replace($search,$replace,$locale['fb561'])."

\n"; echo "

".showPoweredBy()."

"; closetable(); ?>