function flash_build_allowed_forums_list()
{
$allowed_forums = '';
$forum_types = array(FORUM_POST);
$forums_array = get_forums_ids($forum_types, true, false, true, true);
foreach ($forums_array as $forum) {
$allowed_forums .= (empty($allowed_forums) ? '' : ',') . $forum['forum_id'];
}
return $allowed_forums;
}
function cms_block_forum_list()
{
global $db, $cache, $config, $template, $theme, $images, $table_prefix, $user, $lang, $block_id, $cms_config_vars;
$template->_tpldata['cat_row.'] = array();
$template->_tpldata['forum_row.'] = array();
unset($category_rows);
$category_rows = array();
$forum_types = array(FORUM_CAT);
$forums_array = get_forums_ids($forum_types, false, true, true, true);
foreach ($forums_array as $forum) {
$category_rows[$forum['forum_id']] = $forum;
}
if ($total_categories = sizeof($category_rows)) {
if (!empty($cms_config_vars['md_list_forum_id'][$block_id])) {
$sql_where = 'AND f.forum_id IN (' . $cms_config_vars['md_list_forum_id'][$block_id] . ')';
} else {
$sql_where = 'AND f.main_type = \'c\'';
}
$sql = "SELECT f.* FROM " . FORUMS_TABLE . " f\n\t\t\t\tWHERE f.auth_view = " . AUTH_ALL . "\n\t\t\t\t\tAND f.forum_type <> " . FORUM_CAT . "\n\t\t\t\t\t" . $sql_where . "\n\t\t\t\tORDER BY f.forum_order";
$result = $db->sql_query($sql, 0, 'forums_list_', FORUMS_CACHE_FOLDER);
unset($forum_data);
$forum_data = array();
while ($row = $db->sql_fetchrow($result)) {
$forum_data[] = $row;
}
$db->sql_freeresult($result);
if (!($total_forums = sizeof($forum_data))) {
//message_die(GENERAL_MESSAGE, $lang['No_forums']);
}
$tmp_cat_id = '';
foreach ($forum_data as $menu_cat_item_data) {
if ($menu_cat_item_data['parent_id'] == '' || $menu_cat_item_data['parent_id'] != $tmp_cat_id) {
$tmp_cat_id = $menu_cat_item_data['parent_id'];
if (!empty($category_rows[$tmp_cat_id]['forum_id']) && $menu_cat_item_data['main_type'] == 'c') {
$cat_icon = '<img src="' . $images['nav_menu_sep'] . '" alt="" title="" style="vertical-align: middle;" /> ';
$template->assign_block_vars('cat_row', array('CAT_ID' => $tmp_cat_id, 'CAT_ITEM' => $category_rows[$tmp_cat_id]['forum_name'], 'CAT_ICON' => $cat_icon));
}
}
if (!empty($category_rows[$tmp_cat_id]['forum_id']) && $menu_cat_item_data['main_type'] == 'c') {
$forum_name = stripslashes($menu_cat_item_data['forum_name']);
$forum_link = append_sid(CMS_PAGE_VIEWFORUM . '?' . POST_FORUM_URL . '=' . $menu_cat_item_data['forum_id']);
$forum_icon = '<img src="' . $images['nav_menu_sep'] . '" alt="" title="" style="vertical-align: middle;" />';
$template->assign_block_vars('cat_row.forum_row', array('FORUM_ITEM' => $forum_name, 'FORUM_LINK' => $forum_link, 'FORUM_ICON' => $forum_icon));
}
}
} else {
$template->assign_block_vars('no_forum', array('NO_FORUM' => $lang['No_forums']));
}
$template->assign_vars(array('FL_TITLE' => $lang['cms_block_forum_list']));
}
$sitemap_pages_priority = '1.0';
foreach ($sitemap_pages as $sitemap_page)
{
$xml_sitemap_body .= '
<url>
<loc>' . $server_url . $sitemap_page . '</loc>
<changefreq>' . $sitemap_pages_change . '</changefreq>
<priority>' . $sitemap_pages_priority . '</priority>
</url>';
}
// MG SITEMAP - FORUM - BEGIN
//Get a list of publicly viewable forums
$forumids = '';
$forum_types = array(FORUM_POST);
$forums_array = get_forums_ids($forum_types, true, false, true, true);
foreach ($forums_array as $forum)
{
$forumids .= (empty($forumids) ? '' : ',') . $forum['forum_id'];
}
if($config['sitemap_sort'] == 'ASC')
{
$order = 'DESC';
}
else
{
$order = 'ASC';
}
$sql = "SELECT topic_id FROM " . TOPICS_TABLE . " WHERE forum_id IN (" . $forumids . ") ORDER BY topic_id $order LIMIT 1";
$result = $db->sql_query($sql);
