<?php
/**
* copyright : (C) 2001-2018 Advanced Internet Designs Inc.
* email : [email protected]
* $Id$
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; version 2 of the License.
**/
function tmpl_create_forum_select($frm_id, $mod)
{
if (!isset($_GET['t']) || ($_GET['t'] != 'thread' && $_GET['t'] != 'threadt')) {
$dest = t_thread_view;
} else {
$dest = $_GET['t'];
}
if ($mod) { /* Admin optimization. */
$c = uq('SELECT f.id, f.name, c.id FROM fud30_fc_view v INNER JOIN fud30_forum f ON f.id=v.f INNER JOIN fud30_cat c ON f.cat_id=c.id WHERE f.url_redirect IS NULL ORDER BY v.id');
} else {
$c = uq('SELECT f.id, f.name, c.id
FROM fud30_fc_view v
INNER JOIN fud30_forum f ON f.id=v.f
INNER JOIN fud30_cat c ON f.cat_id=c.id
INNER JOIN fud30_group_cache g1 ON g1.user_id='. (_uid ? '2147483647' : '0') .' AND g1.resource_id=f.id '.
(_uid ? ' LEFT JOIN fud30_mod mm ON mm.forum_id=f.id AND mm.user_id='. _uid .' LEFT JOIN fud30_group_cache g2 ON g2.user_id='. _uid .' AND g2.resource_id=f.id WHERE mm.id IS NOT NULL OR '. q_bitand('COALESCE(g2.group_cache_opt, g1.group_cache_opt)', 1) .' > 0 ' : ' WHERE '. q_bitand('g1.group_cache_opt', 1) .' > 0 AND f.url_redirect IS NULL ').
'ORDER BY v.id');
}
$f = array($frm_id => 1);
$frmcount = 0;
$oldc = $selection_options = '';
while ($r = db_rowarr($c)) {
if ($oldc != $r[2]) {
foreach ($GLOBALS['cat_cache'] as $k => $i) {
if ($r[2] != $k && $i[0] >= $GLOBALS['cat_cache'][$r[2]][0]) {
continue;
}
$selection_options .= '<option disabled="disabled">- '.($tabw = ($i[0] ? str_repeat(' ', $i[0]) : '')).$i[1].'</option>';
if ($k == $r[2]) {
break;
}
}
$oldc = $r[2];
}
$selection_options .= '<option value="'.$r[0].'"'.(isset($f[$r[0]]) ? ' selected="selected"' : '').'>'.$tabw.' '.$r[1].'</option>';
$frmcount++;
}
unset($c);
return ''.($frmcount > 1 ? '
<span class="SmallText fb">Goto Forum:</span>
<form action="[[relativeurl]]/index.php" id="frmquicksel" method="get">
<input type="hidden" name="t" value="'.$dest.'" />
'._hs.'
<select class="SmallText" name="frm_id">
'.$selection_options.'
</select>
<input type="submit" class="button small" name="frm_goto" value="Go" />
</form>
' : '' ) ;
}
?>
