query('SELECT MAX(id) FROM '.$db->prefix.'forums') or error('Unable to fetch sub forum info',__FILE__,__LINE__,$db->error()); $_count = $db->result($subforum)+1; for ($i = 0; $i < $_count; $i++) { $forums_info = $db->query('SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM '.$db->prefix.'forums WHERE id='.$i) or error('Unable to fetch sub forum info',__FILE__,__LINE__,$db->error()); $current = $db->fetch_assoc($forums_info); $sfdb[$i][0] = $current['parent_forum_id']; $sfdb[$i][1] = $current['num_topics']; $sfdb[$i][2] = $current['num_posts']; $sfdb[$i][3] = $current['last_post_id']; $sfdb[$i][4] = $current['last_poster']; $sfdb[$i][5] = $current['last_post']; $subject = $db->query('SELECT subject FROM '.$db->prefix.'topics WHERE last_post_id='.$current['last_post_id']); $sfdb[$i][6] = $db->result($subject); $sfdb[$i][7] = $current['forum_name']; } $new_topics = get_all_new_topics(); $result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, t.question, f.parent_forum_id FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$forum_user['g_id'].') LEFT JOIN '.$db->prefix.'topics AS t ON f.last_post=t.last_post AND f.last_post_id=t.last_post_id WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND (f.parent_forum_id IS NULL OR f.parent_forum_id=0) ORDER BY c.disp_position, c.id, f.disp_position') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error()); $cur_category = 0; $cat_count = 0; $cat_ids = (isset($_COOKIE['collapseprefs']))? $_COOKIE['collapseprefs'].',': FALSE; while ($cur_forum = $db->fetch_assoc($result)) { $moderators = ''; if ($cur_forum['cid'] != $cur_category) { if ($cur_category != 0) echo "\t\t\t".''."\n\t\t\t".''."\n\t\t".''."\n\t".''."\n".''."\n\n"; ++$cat_count; if ($configuration['o_coll_cat'] == '1') { if (strstr($cat_ids, $cat_count.',')) { $div_ido = "Block"; $div_idx = "none"; } else { $div_ido = "none"; $div_idx = "block"; } $exp_up = (is_file(FORUM_ROOT.'img/general/exp_up.png'))? 'general/exp_up.png': 'exp_up.png'; $exp_down = (is_file(FORUM_ROOT.'img/general/exp_down.png'))? 'general/exp_down.png': 'exp_down.png'; ?>

Expand

RSS feeds  Collapse

'.convert_htmlspecialchars($cur_forum['forum_name']).''; $num_topics = $num_posts = ' '; $item_status = 'iredirect'; $icon_text = $lang_common['Redirect icon']; $icon_type = 'icon'; } else { if ($configuration['o_rewrite_urls'] == '1') $forum_field = '

'.convert_htmlspecialchars($cur_forum['forum_name']).'

'; else $forum_field = '

'.convert_htmlspecialchars($cur_forum['forum_name']).'

'; $n_t = 0; $n_p = 0; $l_pid = $cur_forum['last_post_id']; $l_pr = $cur_forum['last_poster']; $l_post = $cur_forum['last_post']; for ($i = 0; $i < $_count; ++$i) { if (($cur_forum['forum_name'] == $sfdb[$i][7])) { $_subject_ = $sfdb[$i][6]; } } for ($i = 0; $i < $_count; $i++) { if ($sfdb[$i][0] == $cur_forum['fid']) { $n_t = $n_t + $sfdb[$i][1]; $n_p = $n_p + $sfdb[$i][2]; if ($l_pid < $sfdb[$i][3]) { $l_pid = $sfdb[$i][3]; $l_pr = $sfdb[$i][4]; $l_post = $sfdb[$i][5]; $_subject_ = $sfdb[$i][6]; } } } $num_topics = $n_t + $cur_forum['num_topics']; $num_posts = $n_p + $cur_forum['num_posts']; } if ($cur_forum['forum_desc'] != '') $forum_field .= "\n\t\t\t\t\t\t\t\t".$cur_forum['forum_desc']; $queryid = $db->query('SELECT topic_id FROM '.$db->prefix.'posts WHERE id='.$cur_forum['last_post_id']); $idm = $db->result($queryid); $queryid = $db->query('SELECT subject FROM '.$db->prefix.'topics WHERE id='.$idm); $idm = $db->result($queryid); if(strlen($idm) > 30) { $idmComp = str_replace('"', "''", $idm); $idm = substr($idm, 0, 30).'...'; } else $idmComp = ''; if ($cur_forum['last_post'] != '') { $idmT = (isset($idmComp)) ? ' title="'.$idmComp.'"' : ''; if ($configuration['o_rewrite_urls'] == '1') { if ($cur_forum['question'] != '')''.$_subject_.'  ' .$lang_common['by'].' '.convert_htmlspecialchars($l_pr); else $last_post = ''.$cur_forum['subject'].' '.$lang_common['by'].' '.convert_htmlspecialchars($l_pr); } else { if ($cur_forum['question'] != '') $last_post = ''.$_subject_.' '.$lang_common['by'].' '.convert_htmlspecialchars($l_pr); else $last_post = ''.$_subject_.' '.$lang_common['by'].' '.convert_htmlspecialchars($l_pr); } } else $last_post = ' '; $moderators = array(); if ($cur_forum['moderators'] != '') { $mods_array = unserialize($cur_forum['moderators']); while (list($mod_username, $mod_id) = @each($mods_array)) $moderators[] = '['.convert_htmlspecialchars($mod_username).']'; $moderators = "\t\t\t\t\t\t\t\t".'

'.$lang_common['Moderated by'].': '.implode(', ', $moderators).'

'."\n"; } $results = $db->query('SELECT forum_name, id FROM '.$db->prefix.'forums WHERE parent_forum_id ='.$cur_forum['fid']) or error('Unable to fetch subforums count', __FILE__, __LINE__, $db->error()); $subs_name = NULL;$subs_id = NULL; while($results2 = mysql_fetch_array($results)) { $subs_name[] = $results2['forum_name']; $subs_id[] = $results2['id']; } if (is_array($subs_name)) { $subforums = array(); for ($i=0; $i < count($subs_name);$i++) { $subforums[] = '['.convert_htmlspecialchars($subs_name[$i]).']'; } $subforumsp = "\t\t\t\t\t\t\t\t".'

'.$lang_common['Subforums'].': '.implode(', ', $subforums).'

'."\n"; } else $subforumsp = ""; if ($configuration['o_click_row'] == '1') { $link = "view_forum.php?id=".$cur_forum['fid']; if ($configuration['o_rewrite_urls']){ $link = replace_for_mod_rewrite2($link); } ?> onclick="window.location.href=''"> > 0) echo "\t\t\t".''."\n\t\t\t".'
0) echo $moderators; ?>
'."\n\t\t".'
'."\n\t".'
'."\n".'
'."\n\n"; else echo '

'.$lang_index['Empty board'].'

'; $ak_limit = $configuration['o_active_topics_nr']; if ($ak_limit != '0') include('include/modules/mod_active_topics.php'); if ($configuration['o_boardstats_enable'] == '1') { $result = $db->query('SELECT COUNT(id)-1 FROM '.$db->prefix.'users') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error()); $stats['total_users'] = $db->result($result); $result = $db->query('SELECT id, username FROM '.$db->prefix.'users ORDER BY registered DESC LIMIT 1') or error('Unable to fetch newest registered user', __FILE__, __LINE__, $db->error()); $stats['last_user'] = $db->fetch_assoc($result); $result = $db->query('SELECT SUM(num_topics), SUM(num_posts) FROM '.$db->prefix.'forums') or error('Unable to fetch topic/post count', __FILE__, __LINE__, $db->error()); list($stats['total_topics'], $stats['total_posts']) = $db->fetch_row($result); ?>

'. $stats['total_users'] ?>
'.$stats['total_topics'] ?>
'.$stats['total_posts'] ?>
query("SELECT COUNT(*) FROM ".$db->prefix."posts WHERE posted > ".(time()-7*24*3600)) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error()); $posts_week = $db->result($result); $result = $db->query("SELECT COUNT(*) FROM ".$db->prefix."posts WHERE posted > ".(time()-24*3600)) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error()); $posts_day = $db->result($result); $posts_h = $posts_day/24; ?>
'.$posts_week . ''; else echo $lang_index['number day'].': '.$posts_day . ''; else echo $lang_index['average h'].': '.number_format($posts_h,1) . ''; ?>
:
query('SELECT user_id, ident, color FROM '.$db->prefix.'online WHERE idle=0 ORDER BY ident', true) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error()); while ($forum_user_online = $db->fetch_assoc($result)) { if ($forum_user_online['color'] == '' ) $forum_user_online['color'] = '#000000'; if ($forum_user_online['user_id'] > 1) $users[] = "\n\t\t\t\t".'
'.convert_htmlspecialchars($forum_user_online['ident']).''; else ++$num_guests; } $num_users = count($users); $date = getdate(time()); $todaystamp = mktime(0,0,0, $date['mon'], $date['mday'], $date['year']); $result = $db->query('SELECT username, id, last_visit from '.$db->prefix.'users WHERE last_visit >= \''.$todaystamp.'\' ORDER by last_visit DESC') or error('Cannot retrieve the list of today visitors', __FILE__, __LINE__, $db->error()); $users_today = array(); while ($user_online_today = $db->fetch_assoc($result)) $users_today[] .= "\n\t\t\t\t".''.$user_online_today['username'].''; $num_users_today = count($users_today); echo "\t\t\t\t".'
'. $lang_index['Users online'].': '.$num_users.'
'."\n\t\t\t\t".'
'.$lang_index['Users today'].': '.$num_users_today.'
'."\n\t\t\t\t".'
'.$lang_index['Guests online'].': '.$num_guests.'
'."\n\t\t\t".'
'."\n"; $botStatus = isBotOnline(); if ($num_users > 0 || $botStatus != '') { echo "\t\t\t".'
'."\n\t\t\t\t".'
'.$lang_index['Online'].': 
'."\t\t\t\t".implode(', ', $users); if($botStatus != '' & $num_users == 0) echo substr($botStatus, 1); else echo $botStatus; echo ''."\n\t\t\t".'
'."\n"; } echo "\t\t\t".'
'."\n"; echo "\t\t\t".'
'."\n\t\t\t\t".'
'.$lang_index['Online today'].': '; if ($num_users_today > 0) echo implode(', ', $users_today).''."\n\t\t\t".'
'."\n"; else echo 'none'."\n\t\t\t".''."\n"; } else echo "\t\t".''."\n\t\t\t".'
'."\n"; ?>

query('SELECT id, group_id, username, num_posts FROM '.$db->prefix.'users WHERE (num_posts != 0) && (group_id != 3) ORDER BY num_posts DESC LIMIT '.$configuration['o_most_active']) or error('Unable to fetch user data', __FILE__, __LINE__, $db->error()); while ($data = $db->fetch_assoc($result)) { echo "\t\t\t\t\t\t".''.convert_htmlspecialchars($data['username']).' ('.$data['num_posts'].') '."\n"; } ?>