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);
