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';
?>
|
|
|
|
'.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 = '';
else $forum_field = '';
$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".'
'."\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";
}
?>