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)
-   -   Forum Headers Hack (https://vborg.vbsupport.ru/showthread.php?t=42745)

thedvs 08-26-2002 03:26 PM

followed it to the letter (including the sanity bit heh)
got this error... from the admin panel...

Invalid SQL: UPDATE forum
SET
styleid='1', title='Chit Chat', description='General Discussion, board news, news, discuss anything you want in here.',
active='1', displayorder='3', iconimg='', parentid='6', parentlist='8,6,-1',
allowposting='1', cancontainthreads='1', daysprune='30',
newpostemail='', newthreademail='',
moderatenew='0', allowhtml='1', allowbbcode='1',
allowimages='1', allowsmilies='0', allowicons='0',
styleoverride='1', allowratings='1', countposts='1',
moderateattach='0',forumnewsid='',
enableheader='1',guestonlyheader='0',forumheader=' THIS IS A TEST HEADER'

WHERE forumid='8'
mysql error: Unknown column 'iconimg' in 'field list'

mysql error number: 1054

FASherman 08-26-2002 04:20 PM

If you don't have the forum icons hack, you won't have the iconimg field in your forums table.

Thats why I mentioned that line would need som sanity checking to make sure it was consistant with your site.

Smoothie 08-26-2002 04:31 PM

step 9 says: In forumdisplay.php
FIND:
-----------
updateuserforum($forumid);
-----------
Then your code. Does it go before or after?

FASherman 08-26-2002 05:20 PM

Quote:

Originally posted by Smoothie
step 9 says: In forumdisplay.php
FIND:
-----------
updateuserforum($forumid);
-----------
Then your code. Does it go before or after?

Add after. I fixed the install file. Thanks for the feedback!

thedvs 08-26-2002 08:33 PM

installed perfectly!
ive been waiting for a hack like this all damn year

Vinney 08-26-2002 09:02 PM

amazing ! cant wait too install it !

Neo 08-27-2002 01:10 PM

look at this

https://vborg.vbsupport.ru/showthrea...threadid=36093


Quote:

Originally posted by FASherman
I don't think so. Remember, this isn't designed for banner ads. You can use it that way, but the HTML code will have to handle aging, rotating, etc.

All this hack does is add a customer header and footer to each forum. I just updated the install file to include adding footers too.

It gives anyone the ability to do what http://www.sitepointforums.com/ has done without having to do it as a template hack that makes each forum the same.


FASherman 08-27-2002 07:49 PM

Not even close to being the same. Why would you create a template per forum when you can just enter HTML directly into a text box via the ACP, keep the data in the database and have it protecting with backups?

Also nothing about footer or restricting the headers and footers individually to just guests.

Would you suggest two additional templates per forum to have both a header and a footer? Not to mention the headache of having to check forumid's before modifying a template if you have several forums. Or having to remember to delete templates if a forum gets deleted.

This is a much more managable, elegant solution. You want to edit the header/footer of a particular forum, you edit the forum. You want to limit either the header or footer to just guests, select that option as you edit the forum. You delete the forum, the header/footer info goes away at the same time. Whats the cost? One SQL querie, same as adding a new thread.

What exactly are you objecting to?

FASherman 08-27-2002 08:12 PM

Here is one that is actually quite similar in approach but more limited in functionality. I came up in the list as I was checking this thread.

https://vborg.vbsupport.ru/showthrea...threadid=26818

I'm going to link to is because if all you want is banners and the ability to set time limits, this is a better approach. You display a picture, not actual HTML.

If you want HTML headers and footers and would rather have control based on user level, this is the better approach.

Smoothie 08-27-2002 08:46 PM

Question. Step 5:
Quote:

The following FIND/REPLACE will require some sanity checking,
depending if you have installed hacks that have added fields.
Still in admin/forums.php
Here:
Quote:

FIND:
-----------
$DB_site->query("INSERT INTO forum
This: iconimg, and this: forumnewsid are not in my code. I know they are in your's because of hacks you have installed that I don't. Do I eliminate them from the code that I replace? Wouldn't it have been better to supply the clean code to find and replace? It's a bit confusing. :(


All times are GMT. The time now is 08:43 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.01204 seconds
  • Memory Usage 1,740KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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