query('SELECT t.forum_id, t.id, t.last_post FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_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) AND t.last_post>'.$pun_user['last_visit'].' AND t.moved_to IS NULL') or error('Unable to fetch new topics', __FILE__, __LINE__, $db->error()); // // $new_topics = array(); // while ($cur_topic = $db->fetch_assoc($result)) // $new_topics[$cur_topic['forum_id']][$cur_topic['id']] = $cur_topic['last_post']; // // $tracked_topics = get_tracked_topics(); //} 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'; require PUN_ROOT.'include/subforums_view.php'; // MOD subforums - Visman // 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)) { ?>