The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 08-28-2001

Works with vBulletin v2.2.0!

This hack will allow you to add banners to your categories row (like done on SitePointForum.com - use that as a demo

).
You can add / remove sponsors for any category that exists and also on creation (of category) time.
You can specify the name, banner url and the sponsor's site.
Currently it only supports categories from level 1, and only on forum index. -if you want more please tell and I'll see what I can do.
Umm, that's it I think. Installation is fairly easy (and the hack itself didn't take too much time

), so you shouldn't have any problems.

Feedback from any kind is very appreciated!

First of all, run the following query

Code:

ALTER TABLE forum ADD sponsorname VARCHAR(100) not null AFTER cancontainthreads, ADD sponsorimg VARCHAR(100) not null AFTER sponsorname, ADD sponsorurl VARCHAR(255) not null AFTER sponsorimg

For more info about running queries take a look here or here.

Add a custom template, name it forumhome_forumbit_level1_nopost_sponsor and put the following in it:

Code:

<tr id="cat">
	<td bgcolor="{categorybackcolor}" colspan="2"><a href="forumdisplay.php?s=$session[sessionhash]&forumid=$forum[forumid]"><normalfont color="{categoryfontcolor}"><b>$forum[title]</b></normalfont></a>
	<br><smallfont color="{categoryfontcolor}">$forum[description]</smallfont></td>
	<td bgcolor="{categorybackcolor}" colspan="4"><a href="$forum[sponsorurl]" target="_blank"><img src="{imagesfolder}/$forum[sponsorimg]" border="0" alt="Proudly sponsored by $forum[sponsorname]"></a></td>
</tr>

(You can tweak this for your tables. Playing around with the colspans should be enough though. This is for the default table structure)

In forum.php (under your admin folder) add

PHP Code:


			
  maketableheader("Sponsors</b> <i>Only supported by categories</i>","",0);



  makeinputcode("Sponsor name","sponsorname");

  makeinputcode("Sponsor banner file<br>(your default images folder is added, no need in that)","sponsorimg");

  makeinputcode("Sponsor full URL","sponsorurl");

right after

PHP Code:


			
  makeyesnocode("Count posts made in this forum towards user post counts?","countposts",1);

(around line 121)

Still in forum.php, replace

PHP Code:


			
  $DB_site->query("INSERT INTO forum

                      (forumid,styleid,title,description,active,displayorder,parentid,

                       parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,

                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,

                       styleoverride,allowratings,countposts,moderateattach)

                   VALUES

                      (NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',

                       '','$allowposting','$cancontainthreads','$daysprune','".addslashes($newpostemail)."','".addslashes($newthreademail)."',

                       '$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons',

                       '$styleoverride','$allowratings','$countposts','$moderateattach')");

with

PHP Code:


			
  $DB_site->query("INSERT INTO forum

                      (forumid,styleid,title,description,active,displayorder,parentid,

                       parentlist,allowposting,cancontainthreads,sponsorname,sponsorimg,

                       sponsorurl,daysprune,newpostemail,newthreademail,

                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,

                       styleoverride,allowratings,countposts,moderateattach)

                   VALUES

                      (NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',

                       '','$allowposting','$cancontainthreads','".addslashes($sponsorname)."','".addslashes($sponsorimg)."',

                       '".addslashes($sponsorurl)."','$daysprune','".addslashes($newpostemail)."','".addslashes($newthreademail)."',

                       '$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons',

                       '$styleoverride','$allowratings','$countposts','$moderateattach')");

(around lines 136-147)

Still in forum.php, add

PHP Code:


			
  maketableheader("Sponsors</b> <i>Only supported by categories</i>","",0);



  makeinputcode("Sponsor name","sponsorname",$forum[sponsorname]);

  makeinputcode("Sponsor banner file<br>(your default images folder is added, no need in that)","sponsorimg",$forum[sponsorimg]);

  makeinputcode("Sponsor full URL","sponsorurl",$forum[sponsorurl]);

right after

PHP Code:


			
  makeyesnocode("Count posts made in this forum towards user post counts?","countposts",$forum[countposts]);

(around line 230)

Still in forum.php, replace

PHP Code:


			
  $DB_site->query("UPDATE forum

                   SET

                     styleid='$styleset', title='".addslashes($title)."', description='".addslashes($description)."',

                     active='$isactive', displayorder='$displayorder', parentid='$parentid', parentlist=$parentlist,

                     allowposting='$allowposting', cancontainthreads='$cancontainthreads', daysprune='$daysprune',

                     newpostemail='".addslashes($newpostemail)."', newthreademail='".addslashes($newthreademail)."',

                     moderatenew='$moderatenew', allowhtml='$aallowhtmlcode', allowbbcode='$aallowbbcode',

                     allowimages='$aallowimgcode', allowsmilies='$aallowsmilies', allowicons='$aallowicons',

                     styleoverride='$styleoverride', allowratings='$allowratings', countposts='$countposts',

                     moderateattach='$moderateattach'

                   WHERE forumid='$forumid'");

with

PHP Code:


			
  $DB_site->query("UPDATE forum

                   SET

                     styleid='$styleset', title='".addslashes($title)."', description='".addslashes($description)."',

                     active='$isactive', displayorder='$displayorder', parentid='$parentid', parentlist=$parentlist,

                     allowposting='$allowposting', cancontainthreads='$cancontainthreads',

                     sponsorname='".addslashes($sponsorname)."',sponsorimg='".addslashes($sponsorimg)."',

                     sponsorurl='".addslashes($sponsorurl)."',daysprune='$daysprune',

                     newpostemail='".addslashes($newpostemail)."', newthreademail='".addslashes($newthreademail)."',

                     moderatenew='$moderatenew', allowhtml='$aallowhtmlcode', allowbbcode='$aallowbbcode',

                     allowimages='$aallowimgcode', allowsmilies='$aallowsmilies', allowicons='$aallowicons',

                     styleoverride='$styleoverride', allowratings='$allowratings', countposts='$countposts',

                     moderateattach='$moderateattach'

                   WHERE forumid='$forumid'");

(around lines 261-273)
Save and upload forum.php.

In index.php (the main folder) replace this line

PHP Code:


			
        eval("\$forumbits .= \"".gettemplate("forumhome_forumbit_level$depth$tempext")."\";");

with this code

PHP Code:


			
        if ($forum['sponsorimg'] && $forum['cancontainthreads']==0 && $depth==1) {

          eval("\$forumbits .= \"".gettemplate("forumhome_forumbit_level1_nopost_sponsor")."\";");

        } else {

          eval("\$forumbits .= \"".gettemplate("forumhome_forumbit_level$depth$tempext")."\";");

        }

(around line 298)
Save and upload index.php.

That's it.
If you did everything correctly (it wasn't very hard, was it?

) and I didn't do any mistakes (it's tested alright!, but I might have forgot something to post), you can start adding sponsors to your forum!

Littlebit · #**272** 12-06-2002, 05:58 PM

Hi Firefly,
I need to uninstall this hack. What query do I need to run to complete this?
Thanks and hi

A guess:
ALTER TABLE forum REMOVE sponsorname VARCHAR(100) not null AFTER cancontainthreads, REMOVE sponsorimg VARCHAR(100) not null AFTER sponsorname, REMOVE sponsorurl VARCHAR(255) not null AFTER sponsorimg

? lol

SVTBlackLight01 · #**273** 01-14-2003, 06:32 AM

Great mod. Thanks.

Where do I put the "proudly supported by" text to get it to display like on Site Point?

cyc · #**274** 01-17-2003, 08:49 PM

Great hack....very easy to install

Quote:

Where do I put the "proudly supported by" text to get it to display like on Site Point?

It looks like its part of the displayed banner

cheers!

Winky · #**275** 01-19-2003, 12:04 AM

I have the expand contract on forum home hack installed and when I install the banner code it breaks my expand contract. Is there any way around this?

pcoskat · #**276** 02-01-2003, 08:59 PM

What are the specific dimensions for the banner? I assume that the sponsor needs to supply the banner in that size (or I have to create it) - yes?

Also, I'm using 2.2.8...I'm assuming this hack works for that?

I'm somewhat dense on the topics of hacks, so forgive me if these questions seem sophmoric.

Thanks in advance for any replies.

Based on the examples I've viewed, this is a lovely hack. :banana:

PK

cymru2000 · #**277** 02-10-2003, 10:09 PM

Just installed the hack, as per instructions on page one, to a 2.2.9 forum. GREAT work. Changed it a bit so that it would display outside site images such as those from commission junction and added "Proudly Sponsored By" to the left of the banner, and then right aligned the lot.

Very nice hack, those wanting to see it working take a look at www.wweforums.co.uk.

SVTBlackLight01 · #**278** 02-10-2003, 10:26 PM

Quote:

Originally posted by cymru2000
Just installed the hack, as per instructions on page one, to a 2.2.9 forum. GREAT work. Changed it a bit so that it would display outside site images such as those from commission junction and added "Proudly Sponsored By" to the left of the banner, and then right aligned the lot.

Very nice hack, those wanting to see it working take a look at www.wweforums.co.uk.

How did you use the commission junction images?

cymru2000 · #**279** 02-11-2003, 03:26 PM

Quote:

Originally posted by SVTBlackLight01

How did you use the commission junction images?

In

PHP Code:


			
forumhome_forumbit_level1_nopost_sponsor

I Put

PHP Code:


			
<img src="$forum[sponsorimg]" border="0" alt="Proudly sponsored by  $forum[sponsorname]">

in relace of

PHP Code:


			
<img src="{imagesfolder}/$forum[sponsorimg]" border="0" alt="Proudly sponsored by $forum[sponsorname]">

And then in the admin panel just put in the full URL to the image, instead of a partial URL. This image URL can be those given by CJ.

Just make sure you use a small sponsorship image!

retinax · #**280** 02-14-2003, 08:58 PM

Hi, I am installing FireFly's hack on a new Parenting Forum for a customer of mine. I followed the instructions on the original post (and did it twice) but the ads don't show up.. My main forum list page stays the same after I go into the control panel and enter sponsor information to a forum.

I had tried another hack before this one that added a banner anywhere (i put it at bottom) and it worked, but I wanted a hack that allowed banners on each Main Category listing on the main page. So I left the other hack in and installed this one..

The SQL query went through in phpmyadmin with no problems.. I double checked them. I did the code modifications in admin/forum.php and index.php twice, added the template forumhome_forumbit_level1_nopost_sponsor with the correct code, and went into the control panel to add the sponsor info.

I guess my question is, if the script can't find the image for the sponsor does it just not show anything (as if the hack wasnt installed) ? The control panel entry for the image says not to put the images folder in the path.. well is that the images folder in my "Forum" folder or the root of my server? I tried many combinations but it acts as if the hack isn't even there.

Any suggestions??? Please help! Thanks a lot-

BTW the forum is: www.echildshealth.com/Forum

James Johns
Retina-X Studios
www.retinax.com

amykhar · #**281** 02-14-2003, 10:05 PM

ummm retinax, forgive me if I am a wee bit dumb, but I don't see any categories on your forum home. That is where the banners would be - not on the individual forums.

Amy

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05011 seconds Memory Usage 2,385KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (13)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!