function lidtonfid($lid, $templateID) { global $_TABLES; $sql = "SELECT id FROM {$_TABLES['nf_templatedata']} WHERE nf_templateid={$templateID} AND logicalID={$lid}"; $result = DB_Query($sql); $A = DB_FetchArray($result); if ($A[0] == NULL) { $retval = NULL; } else { $retval = $A[0]; } return $retval; }
$viewnewpostslink = true; } else { $forumlisting->clear_var('newpostslink'); } } else { $forumlisting->clear_var('newpostslink'); $forumlisting->clear_var('markreadlink'); } $forumlisting->set_var(array('LANGGF91_forum' => $LANG_GF91['forum'], 'LANGGF01_TOPICS' => $LANG_GF01['TOPICS'], 'LANGGF01_POSTS' => $LANG_GF01['POSTS'], 'LANGGF01_LASTPOST' => $LANG_GF01['LASTPOST'])); //Display all forums under each cat $sql = "SELECT * FROM {$_TABLES['ff_forums']} AS f " . "LEFT JOIN {$_TABLES['ff_topic']} AS t ON f.last_post_rec=t.id " . "WHERE forum_cat=" . (int) $A['id'] . " " . "AND grp_id IN ({$groupAccessList}) AND is_hidden=0 ORDER BY forum_order ASC"; $forumQuery = DB_query($sql); $numForums = DB_numRows($forumQuery); $numForumsDisplayed = 0; $forumlisting->set_block('forumlisting', 'forumrows', 'frow'); while ($B = DB_FetchArray($forumQuery)) { if (_ff_canUserViewRating($B['forum_id'])) { $lastforum_noaccess = false; $topicCount = $B['topic_count']; $postCount = $B['post_count']; if ($_FF_CONF['show_moderators']) { $modsql = DB_query("SELECT * FROM {$_TABLES['ff_moderators']} WHERE mod_forum=" . (int) $B['forum_id']); $moderatorcnt = 1; if (DB_numRows($modsql) > 0) { while ($showmods = DB_fetchArray($modsql, false)) { if ($showmods['mod_uid'] == '0') { if ($showmods['mod_groupid'] > 0) { $showmods['mod_username'] = _ff_getGroup($showmods['mod_groupid']); } if ($moderatorcnt == 1 or $moderators == '') { $moderators = $showmods['mod_username'];
$boards->set_var('description', $LANG_GF01['DESCRIPTION']); $boards->set_var('resync', $LANG_GF01['RESYNC']); $boards->set_var('edit', $LANG_GF01['EDIT']); $boards->set_var('resync_cat', $LANG_GF01['RESYNCCAT']); $boards->set_var('submit', $LANG_GF01['SUBMIT']); /* Display each Forum Category */ $asql = DB_query("SELECT * FROM {$_TABLES['forum_categories']} ORDER BY cat_order"); while ($A = DB_FetchArray($asql)) { $boards->set_var('catid', $A['id']); $boards->set_var('catname', $A['cat_name']); $boards->set_var('order', $A['cat_order']); /* Display each forum within this category */ $bsql = DB_query("SELECT * FROM {$_TABLES['forum_forums']} WHERE forum_cat={$A['id']} ORDER BY forum_order"); $bnrows = DB_numRows($bsql); for ($j = 1; $j <= $bnrows; $j++) { $B = DB_FetchArray($bsql); $boards->set_var('forumname', $B['forum_name']); $boards->set_var('forumid', $B['forum_id']); $boards->set_var('messagecount', $B['post_count']); /* Check if this is a private forum */ if ($B['grp_id'] != '2') { $grp_name = DB_getItem($_TABLES['groups'], 'grp_name', "grp_id='{$B['grp_id']}'"); $boards->set_var('forumdscp', "[{$LANG_GF93['private']} - {$grp_name}]<br" . XHTML . ">{$B['forum_dscp']}"); } else { $boards->set_var('forumdscp', $B['forum_dscp']); } $boards->set_var('forumorder', $B['forum_order']); if ($j == 1) { $boards->parse('forum_records', 'forums'); } else { $boards->parse('forum_records', 'forums', true);