query('SELECT f.id, f.last_post FROM '.$db->prefix.'forums AS f LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.last_post>'.$pun_user['last_visit']) or error('Unable to fetch forum list', __FILE__, __LINE__, $db->error()); if ($db->num_rows($result)) { $forums = $new_topics = array(); $tracked_topics = get_tracked_topics(); while ($cur_forum = $db->fetch_assoc($result)) { if (!isset($tracked_topics['forums'][$cur_forum['id']]) || $tracked_topics['forums'][$cur_forum['id']] < $cur_forum['last_post']) $forums[$cur_forum['id']] = $cur_forum['last_post']; } if (!empty($forums)) { if (empty($tracked_topics['topics'])) $new_topics = $forums; else { $result = $db->query('SELECT forum_id, id, last_post FROM '.$db->prefix.'topics WHERE forum_id IN('.implode(',', array_keys($forums)).') AND last_post>'.$pun_user['last_visit'].' AND moved_to IS NULL') or error('Unable to fetch new topics', __FILE__, __LINE__, $db->error()); while ($cur_topic = $db->fetch_assoc($result)) { if (!isset($new_topics[$cur_topic['forum_id']]) && (!isset($tracked_topics['forums'][$cur_topic['forum_id']]) || $tracked_topics['forums'][$cur_topic['forum_id']] < $forums[$cur_topic['forum_id']]) && (!isset($tracked_topics['topics'][$cur_topic['id']]) || $tracked_topics['topics'][$cur_topic['id']] < $cur_topic['last_post'])) $new_topics[$cur_topic['forum_id']] = $forums[$cur_topic['forum_id']]; } } } } } if ($pun_config['o_feed_type'] == '1') $page_head = array('feed' => ''); else if ($pun_config['o_feed_type'] == '2') $page_head = array('feed' => ''); $forum_actions = array(); // Display a "mark all as read" link if (!$pun_user['is_guest']) $forum_actions[] = ''.$lang_common['Mark all as read'].''; $page_title = array(pun_htmlspecialchars($pun_config['o_board_title'])); define('PUN_ALLOW_INDEX', 1); define('PUN_ACTIVE_PAGE', 'index'); require PUN_ROOT.'header.php'; // Print the categories and forums $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 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='.$pun_user['g_id'].') WHERE fp.read_forum IS NULL OR fp.read_forum=1 ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error()); $cur_category = 0; $cat_count = 0; $forum_count = 0; while ($cur_forum = $db->fetch_assoc($result)) { $moderators = ''; if ($cur_forum['cid'] != $cur_category) // A new category since last iteration? { if ($cur_category != 0) echo "\t\t\t".''."\n\t\t\t".''."\n\t\t".''."\n\t".''."\n".''."\n\n"; ++$cat_count; $forum_count = 0; ?>

[ '.$lang_common['New posts'].' ]'; $icon_type = 'icon icon-new'; } // Is this a redirect forum? if ($cur_forum['redirect_url'] != '') { $forum_field = '

'.$lang_index['Link to'].' '.pun_htmlspecialchars($cur_forum['forum_name']).'

'; $num_topics = $num_posts = '-'; $item_status .= ' iredirect'; $icon_type = 'icon'; } else { $forum_field = '

'.pun_htmlspecialchars($cur_forum['forum_name']).''.(!empty($forum_field_new) ? ' '.$forum_field_new : '').'

'; $num_topics = $cur_forum['num_topics']; $num_posts = $cur_forum['num_posts']; } if ($cur_forum['forum_desc'] != '') $forum_field .= "\n\t\t\t\t\t\t\t\t".'

'.$cur_forum['forum_desc'].'

'; // If there is a last_post/last_poster if ($cur_forum['last_post'] != '') $last_post = ''.format_time($cur_forum['last_post']).''.$lang_common['by'].' '.pun_htmlspecialchars($cur_forum['last_poster']).''; else if ($cur_forum['redirect_url'] != '') $last_post = '- - -'; else $last_post = $lang_common['Never']; if ($cur_forum['moderators'] != '') { $mods_array = unserialize($cur_forum['moderators']); $moderators = array(); foreach ($mods_array as $mod_username => $mod_id) { if ($pun_user['g_view_users'] == '1') $moderators[] = ''.pun_htmlspecialchars($mod_username).''; else $moderators[] = pun_htmlspecialchars($mod_username); } $moderators = "\t\t\t\t\t\t\t\t".'

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

'."\n"; } ?> 0) echo "\t\t\t".''."\n\t\t\t".'

'."\n\t\t".'

'."\n\t".'

'."\n".'

'."\n\n"; else echo '

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

'; // Collect some statistics from the database if (file_exists(FORUM_CACHE_DIR.'cache_users_info.php')) include FORUM_CACHE_DIR.'cache_users_info.php'; if (!defined('PUN_USERS_INFO_LOADED')) { if (!defined('FORUM_CACHE_FUNCTIONS_LOADED')) require PUN_ROOT.'include/cache.php'; generate_users_info_cache(); require FORUM_CACHE_DIR.'cache_users_info.php'; } $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']) = array_map('intval', $db->fetch_row($result)); if ($pun_user['g_view_users'] == '1') $stats['newest_user'] = ''.pun_htmlspecialchars($stats['last_user']['username']).''; else $stats['newest_user'] = pun_htmlspecialchars($stats['last_user']['username']); if (!empty($forum_actions)) { ?>

: '.forum_number_format($stats['total_users']).'') ?>; '.forum_number_format($stats['total_topics']).'') ?>; '.forum_number_format($stats['total_posts']).'') ?>

: '.pun_htmlspecialchars($pun_user_online['ident']).''; else $users[] = "\n\t\t\t\t".'; '.pun_htmlspecialchars($pun_user_online['ident']); } else ++$num_guests; } $num_users = count($users); echo "\t\t\t\t".'; '.sprintf($lang_index['Users online'], ''.forum_number_format($num_users).'').'; '.sprintf($lang_index['Guests online'], ''.forum_number_format($num_guests).'').'

'."\n"; if ($num_users > 0) echo "\t\t\t".'

'.$lang_index['Online'].'

'."\n"; else echo "\t\t\t".'

'."\n"; } else echo "\t\t\t".''."\n\t\t\t".'

'."\n"; ?>