[release vb2b3] subscribed forums select anywhere

[Dream]

warning: this hack will add an addicional query to every page of the bb!

This hack will prepare a variable called "$favforumselect", that can be inserted in any page of the vb, and will show the subscribed (favorites) forums of the user.

http://banco.jogosonline.com.br/vbmods/favforumselect.jpg

>>>> in "phpinclude" template, add this:

if ($bbuserinfo['userid']!=0) {
$favforums=$DB_site->query("SELECT forum.title,forum.forumid FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=$bbuserinfo[userid] ORDER BY title");

$totalforums=$DB_site->num_rows($favforums);

if ($totalforums>0) {
$favforumselect = "<form name=\"subsforumform\"><select name=\"sforum\" onchange=\"JavaScript:subsforum()\" class=\"smallselect\"><option value=\"0\">select";

while ($favforum=$DB_site->fetch_array($favforums)) {

$forumperms=getpermissions($favforum[forumid]);
if (!$hideprivateforums) {
$forumperms[canview]=1;
}
if ($forumperms[canview]) {

$favforumselect = $favforumselect . "<option value=\"$favforum[forumid]\"> $favforum[title]";
}
}

$favforumselect = $favforumselect . "</select></form>";
} else {
$favforumselect = "";
}


} else {
$favforumselect = "";
}

>>>>>>> in the "header", add this:

<script name="JavaScript">
function subsforum () {
if (document.subsforumform.sforum.value != '0') {
gourl="forumdisplay.php?s=$session[sessionhash]&&forumid=" + document.subsforumform.sforum.value;
document.location.href=gourl;}
}
</script>


>>>>>>> in "headinclude", add this:

.smallselect {
font-family : verdana;
font-size : xx-small;
}


Now you can add the variable "$favforumselect" anywhere in the templates where you want it to appear. It wont show forums that the user does not have permission to see, but will show non-active forums, the same way the subscribed forums list in the profile shows them. Hope you like it :).

hmmm...
that's not a bad idea. this way ppl can get to their favourites easily rather then clicking profile then show all.....

[vanye]

Is there an easy way to adapt some of this code to present either:-

- An option somewhere that will allow any user to see a list of all the users & the Forums (& maybe threads) that they have subscribed to)

-An option within a Forum to allow a user to see who else has subscribed to that Forum (& possibly threads within that Forum?)

This would be a great help! My users are concerned as to whether they are getting to their audience, ie. have the correct people subsribed to the correct Forums/Threads

Many thanks

kev :D