Subforums on Forumhome (no extra queries Version)

Well, i think most of you know the hack already but with a great ammount of additional queries.

This hack shows on every forum on forumhome (also on categories if you want it so) all it's Subforums.
It works dynamically so whenever you add a forum, it will be added to the list

One disadvantage on having it queryless is, that if you have private subforums below nonprivate mainforums that these will be seen so (not accesable but seen)

Hope it fits in what some of you need

[Xenon]

which error did you get?

that would help enourmously ^^

[vB-Host.com]

different ones about char undfined or not expected.. different ones as i tried to move the coding around to make it work. I don't know custom php coding well yet so I put something in wrong somewhere... what i am trying to do is put an image before the word "subforums" of course doing so in the forum home template places the image even if there isn't sub forums.

[Xenon]

hmm you have this code:

SET subforums=CONCAT(subforums,IF(subforums='', '<br>Subforums: ', ', ')

just change it into that:

SET subforums=CONCAT(subforums,IF(subforums='', '<br><img src=\"arrow.gif\">Subforums: ', ', ')

be carefull not to have an unslashed " in your text

[vB-Host.com]

when I go to update now.. I get Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE forum

SET subforums=CONCAT(subforums,IF(subforums='', '<br><img src="images/arrow.gif">Subforums: ', ', ') '<a href="forumdisplay.php?forumid=17"></A><A HREF=\"http://www.vb-host.com/hangman.php\">Play A Game Of Hangman</a>') WHERE forumid != 17 AND forumid IN (17,7,-1)
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''<a href="forumdisplay.php?forumid=17"></A><A HREF=\"http://www

mysql error number: 1064

Date: Saturday 03rd of May 2003 03:19:18 PM
Script: http://www.vb-host.com/admin/forum.php
Referer: http://www.vb-host.com/admin/forum.p...dit&forumid=47

[Boofo]

I just did it and it works fine here. This is what I used:

PHP Code:

SET subforums=CONCAT(subforums,IF(subforums='', '<br><img src=\"{ imagesfolder}/arrow.gif\"><b>Subforums:</b> ', ', ') 


Take the space out of the imagesfolder variable, though.

[vB-Host.com]

Thanks Bob, but, getting the same error still... It appears it is having the forum as links hack is causing it. It doesn't like the </a><A HREF="http://www.vb-host.com/hangman.php">click here to play hangman</A> in the SQL syntax....

The error reads...

Invalid SQL: UPDATE forum 

SET subforums=CONCAT(subforums,IF(subforums='', '<br><img src="images/
arrow.gif">Subforums: ', ', ') '<a href="forumdisplay.php?forumid=17"></A>
<A HREF=\"http://www.vb-host.com/hangman.php\">Play A Game Of 
Hangman</a>') WHERE forumid != 17 AND forumid IN (17,7,-1)
mysql error: You have an error in your SQL syntax. Check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
''<a href="forumdisplay.php?forumid=17"></A><A HREF=\"http://www

mysql error number: 1064

Date: Saturday 03rd of May 2003 03:19:18 PM
Script: http://www.vb-host.com/admin/forum.php
Referer: http://www.vb-host.com/admin/forum....edit&forumid=47

[Boofo]

It looks like it doesn't like the dash in your site name.

[lifesourcerec]

Hehe still can't get it to work.

I put the $forum[subforums] in forumhome_forumbit_level2_nopost and editted one of my forums; still did nothing.

[FreDy]

It works fine!! Thanks

This is just I needed.

lifesourcerec: I had the same problem when I installed the hack... try to add the $forum[subforums] code in several forumhome_forumbit_levelx_(no)post

I add the code to
forumhome_forumbit_level1_post
forumhome_forumbit_level2_post
forumhome_forumbit_level2_nopost

And all works correctly. Try it.

[lifesourcerec]

Today at 05:51 PM FreDy said this in Post #49
It works fine!! Thanks

This is just I needed.

lifesourcerec: I had the same problem when I installed the hack... try to add the $forum[subforums] code in several forumhome_forumbit_levelx_(no)post

I add the code to
forumhome_forumbit_level1_post
forumhome_forumbit_level2_post
forumhome_forumbit_level2_nopost

And all works correctly. Try it.

Well, I only want it under "forum description".

"<smallfont color="{categoryfontcolor}">$forum[description] <br>$forum[subforums]</smallfont>