![]() |
which error did you get?
that would help enourmously ^^ |
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.
|
hmm you have this code:
Code:
SET subforums=CONCAT(subforums,IF(subforums='', '<br>Subforums: ', ', ') Code:
SET subforums=CONCAT(subforums,IF(subforums='', '<br><img src=\"arrow.gif\">Subforums: ', ', ') |
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 |
I just did it and it works fine here. This is what I used:
PHP Code:
|
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... Code:
Invalid SQL: UPDATE forum |
It looks like it doesn't like the dash in your site name.
|
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. |
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. |
Quote:
Quote:
|
Quote:
"<smallfont color="{categoryfontcolor}">$forum[description] <br>$forum[subforums]</smallfont> Doesn't show anything. |
Hmm...
I added the code to 'forumhome_forumbit_level2_nopost' template only (under forum description) and it doesn't work for me too. Then I added the same code to several templates (under forum description too) and it works. I think that 'forumhome_forumbit_level2_nopost' isn't the correct template to show the subforums. Try adding the code to more forumhome_forumbit_levelx_(no)post templates. Good luck |
Quote:
|
Find in these templates $forum[description] and add $forum[subforum] under it.
|
as an description for the templatenames:
level1 is over level2 on forumhome _nopost is for categorie forums _post ist for normal forums if you add it to _nopost and your forums on forumhome are no categories, you obviously won't see anything. standart vb template system, i'd advise you to get familiar with it apart from my hack, because it's usefull to know everywhere :) |
Hmm...this may seem simple but how to you get the "Subforums" to appear in bold? I tried changing it in the forum.php file and nothing happened. Then I totally removed the <br>Subforums part and Subforums STILL stayed. What's the part that needs to be changed?
Also note I don't want the subforum links in bold... |
Quote:
I know that, but I can only find $forum[description] in level2_nopost. |
Quote:
The way I believe it is: forumhome_forumbit_level2_post for REGULAR forum forumdisplay_forumbit_level2_post for SUB-FORUMS Editing those files should result in what you're looking for. |
I got it :)... now to getting the "subforums:" to be bold...
|
@WE and life:
To get the subforums bold you have to edit the part in forum.php and after that, you have to edit a forum to update the cache like you have to do when you first install the hack. |
Quote:
|
Thankyou!
/me hits install button |
I would really like to install this nice little hack, but sadly, I'm getting an error:
Quote:
|
you must have made an error while runing the alter table query.
do it again, i can't help any further.... |
Is there another method that I could use to update the cache? Like a query that I could run myself.
|
to update the cache yourself you have to run a lot of queries yourself, so i don't suggest you'd do that ^^
also the problem you reported above is not because of the caching, but because you haven't installed the hack correctly |
I knew I followed instructions correctly. After running repair.php, it finally started working. Thanks for the hack. :)
|
ah, ok a db problem could always produce unknown bugs ^^
:) |
Working like a charm, as always Xenon :)
|
Can't get it to work on v2.3.0
|
i don't know of any problems with 2.3.0 as i've written it with 2.3.0.
follow the instructions carefully and it'll work |
I re-did it step by step twice and no go. Added
Quote:
|
then i can't help, as it's not reproducable on my testboards...
are you sure you've uploaded the files correctly? |
Its level1_nopost and level2_nopost templates not level2_post. Could that be your problem?
Quote:
|
Now I have a problem. Did the hack 100% working fine but every sub forum I have is showing up as a link under the main section header?
How can I only show the sub forums I need? |
the realist, sorry but this feature isn't included right now. you'd have to exclude every forumid you don't want yourself in the code
|
sory Xenon,
can you make it as dropdown ? |
nope, as i hate dropdowns :)
but all you have to do is to change the html code the function generates for yourself and you can make a dropdown out of it, shouldn't be hard i think. |
Took me a day or 2, but i got it.
Thanks for the awsome hack |
Works fine for VB 2.3.2??
|
All times are GMT. The time now is 01:02 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|