vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Subforums on Forumhome (no extra queries Version) (https://vborg.vbsupport.ru/showthread.php?t=49037)

Xenon 02-16-2003 10:00 PM

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 02-17-2003 07:13 PM

For all of you a screenie of the hack.

JulianD 02-17-2003 07:24 PM

Hey thanks Xenon... I will surely install this hack in a near future!

N9ne 02-17-2003 07:26 PM

Xenon, THANKYOU VERY MUCH! This hack is something i've wanted for about 9 months now, I didn't want to add any queries to my precious forumhome! Thankyou very much for this, this is truly a masterpiece, no queries at all, brilliant.

Xanthine 02-17-2003 08:36 PM

Thanks working good for me

Xenon 02-17-2003 08:52 PM

Thx for kind words :)

@N9ne: you know how i hate additional queries ^^

N9ne 02-17-2003 09:30 PM

@Xenon: you know how much I too hate additional queries ;).

dnd 02-18-2003 12:30 AM

Quote:

Originally posted by Xenon


This hack shows on every forum on forumhome (also on categories if you want it so) all it's Subforums.



hi xenon

i don't want the subforums to show on main categories how can i change this?

Highlander 02-18-2003 02:47 AM

got a parse error .. on the beginnig of

find...

got a way out ?

Highlander 02-18-2003 02:47 AM

ok sorry..m<y mistake..

edit:

thought it was my mistkae..but.. really.. i did altered the table..added the changes to forum.php and on line 52 i got an parse error.. whats wrong?

msn:lolo@okay.net

Logician 02-18-2003 07:31 AM

great hack pal!

Dean C 02-18-2003 08:59 AM

Hey Xenon, you said you were reading about hacks. Not having an orgasm release of 'em ;)

Good job buddy :)!

- miSt

Xenon 02-18-2003 10:01 AM

@dnd: well take out $forum[subforums] from the templates where you don't need em.

personally i just have added it to forumhome_level2_post template, but it depends on you where you want it to show up.

@highlander: well without the exact error i can't say anything.
but most likely you've done an mistake while installing it works as you can see...

@Logician: thx pal.

@Mist: :p ;)

Link14716 02-18-2003 04:52 PM

I guess it's time to move my staff forum, heh.

I'll install this one. :)

Dean C 02-18-2003 05:11 PM

Hey just checking. If you have a private sub-forum. Will it appear on the list of subforums on index.php?

Regards

- miSt

Martin64 02-18-2003 06:28 PM

Excellent idea Xenon! :)

Xenon 02-18-2003 06:33 PM

@Martin: thx

@Mist: maybe you should read the info's i posted :P

yes, private subforums would also be listed public (except the main forum is also private of course ;))

Erwin 02-19-2003 05:10 AM

Stefan - you are a legend. :)

Xenon 02-19-2003 10:45 AM

Thx Erwin :)
hmm, should i feel old now? (legends most are ^^)

Seby 02-19-2003 12:34 PM

very nice hack Xenon, I maybe use it. Now please fix the vb home uptimization hack ;))

PiotrasG 02-21-2003 07:28 PM

I installed your hack but cant get it to work. i checked the forum.php if something was misising its there, i run the db query its there, i posted $forum(subforums) in my forumhome_forumbits2_nopost and it doesnt how up any idea im on 2.29

also i checked in db and it added the subforums table i have my sub forum text in there

Xenon 02-21-2003 10:54 PM

it's not:
$forum(subforums)

it is
$forum[subforums]

Boofo 02-21-2003 11:48 PM

Great hack, Stefan. Excellent addition. Thank you. :)

And it didn't even mess anything up on my forums. ;)

Dark Jim 02-22-2003 11:12 AM

Thank you. :) Is it possible to show post markers next to each subforum so you can see if it has new posts? (See attachment)

Xenon 02-22-2003 12:05 PM

nope, not with 0 extra queries.....

Kars10 02-22-2003 12:52 PM

Cool Hack, i install it right now!!
Thank you Stefan ;)

squawell 03-08-2003 09:05 AM

Xenon i already use ur another hack call Delete/Revert multiple templates at once than i install this hack but it dont work the subforum do not show up ?so how should i do when i already install this hackDelete/Revert multiple templates at once


thankz~

Xenon 03-08-2003 10:03 AM

the two hacks don't make problems to the other.
you must have made an mistae while installing this hack. retry it again and read the install file carefulle.

especially the last step (edit a forum) is important

squawell 03-08-2003 10:35 AM

Quote:

Originally posted by Xenon
especially the last step (edit a forum) is important
thankz Xenon u point that for me~~

now it works~~ :cool:

Xenon 03-08-2003 11:05 AM

:)

you're welcome :)

smartwork 03-13-2003 04:09 AM

Xenon -

Please excuse my ignorance - where do we run the initial query before going ahead with the code replacement?

Thanks!

Xenon 03-13-2003 09:55 AM

phpmyadmin for example

lifesourcerec 03-13-2003 04:45 PM

I'm just having bad luck. Installed it and nothing happened.

Xenon 03-13-2003 04:51 PM

have you done the last step and edited a forum and saved?

lifesourcerec 03-13-2003 05:40 PM

Yep. Did that also. Still nothing.

Xenon 03-13-2003 05:48 PM

hmm, have you editet the right templates?

as noone else has any problems, you must have made an mistake, so read the instructions carefully to be sure you haven't forgotten a single instruction...

lifesourcerec 03-13-2003 06:06 PM

In forumhome_forumbit_level2_nopost, I added:

Quote:

<br><smallfont>$forum[subforums]</smallfont>
after:

Quote:

<smallfont color="{categoryfontcolor}">$forum[description]</smallfont>
and I'll triple check the code, but everything was done as instructed, but nothing happens.

Xenon 03-13-2003 06:11 PM

as said, the code is correct, you must have done something wrong....

the thing in forum.php sometimes make problems, if you haven't added it to the right positions.

if everything doesn't help, you may have an interfering hack in index.php which changes the get forum part to strong...
then i can't help

N.B. 04-20-2003 08:37 PM

Thanks Xenon !
Nice hack ! Installed it, and works like a charm !
www.cdrbase.com if anybody wants to take a look :>

vB-Host.com 05-02-2003 10:15 AM

Stefan,

Works great! But I went one step further, trying to add an image in front of "subforums: but I get errors... ideas?

PHP Code:

SET subforums=CONCAT(subforums,IF(subforums='''<br><IMG SRC=\"images/arrow.gif"\">" 
Subforums: '
', '), '<a href=\"forumdisplay.php?forumid=" . $forum['forumid'] . "\">".addslashes($forum['title'])."
</a>'
WHERE forumid != $forum[forumid] AND forumid IN ($forum[parentlist])"); 



All times are GMT. The time now is 03:50 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01294 seconds
  • Memory Usage 1,790KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete