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!

theironmic · #**202** 03-15-2002, 04:11 AM

where de u put the image link at

Floris · #**203** 03-15-2002, 11:51 AM

I just applied the hack and everything went fine.
I guess this works on vBulletin 2.2.4

The only thing I have at the moment is the following:
I have applied my own 'Category background image' template hack, and it looks like the categorie is now a default colour instead of a given background.

I fixed this by adding:

Code:

background="{imagesfolder}/catbgtitle.gif"

to the newly added forumhome_forumbit_level1_nopost_sponsor template (in the <td> tags)

I also noticed that the categories that had the banner set to them, no longer were devided from the other categories (I have applied my 'Split categories from eachother' template hack.)

So I re-applied that hack, just only to the new template, take a look at my site if you wonder what i mean, this is how my template looks now:

Code:

</table>
</td></tr></table><br>
<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr id="cat">
	<td background="{imagesfolder}/catbgtitle.gif" 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 background="{imagesfolder}/catbgtitle.gif" bgcolor="{categorybackcolor}" colspan="4"><a href="$forum[sponsorurl]" target="_blank"><img src="{imagesfolder}/banners/$forum[sponsorimg]" border="0" alt="Proudly sponsored by $forum[sponsorname]"></a></td>
</tr>
<tr align="center" >
  <td background="{imagesfolder}/catbgindex.jpg" bgcolor="{tableheadbgcolor}"><smallfont>&nbsp;</smallfont></td>
  <td background="{imagesfolder}/catbgindex.jpg" bgcolor="{tableheadbgcolor}" width="80%" align="left"><smallfont color="{tableheadtextcolor}"><b>Forum</b></smallfont></td>
  <td background="{imagesfolder}/catbgindex.jpg" bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Posts</b></smallfont></td>
  <td background="{imagesfolder}/catbgindex.jpg" bgcolor="{tableheadbgcolor}"><smallfont color="{tableheadtextcolor}"><b>Threads</b></smallfont></td>
  <td background="{imagesfolder}/catbgindex.jpg" bgcolor="{tableheadbgcolor}" nowrap><smallfont color="{tableheadtextcolor}"><b>Last Post</b></smallfont></td>
  <td background="{imagesfolder}/catbgindex.jpg" bgcolor="{tableheadbgcolor}" width="20%"><smallfont color="{tableheadtextcolor}"><b>Moderator</b></smallfont></td>
</tr>

Please notice that I have my banners in imagedir/banners/ directory! And that I use category & indexing background images!So do not forget to edit that to your liking

Now,
Isn't there any way of removing that line in the middle ?

Additional question:
Is there any way of making this only show up for unregistered members?
Guests > get the banners in category
Registered members > dont. they get normal view

forumuser · #**204** 03-15-2002, 08:30 PM

Once you have installed this hack, which I have done, where do you add the sponsors? I cannot seem to find that, thanks a lot, this hack is awesome by the way

Ninth Dimension · #**205** 03-15-2002, 10:36 PM

you add the sponser information in the admin panel, just choose to modify the categories, and it should ask you for some information regarding that particular cat.

Good Luck.

B16MCC · #**206** 03-18-2002, 10:16 PM

ok I applied the hack and I have the new fields in my CP.

When I click save I get an error detailed below..

There seems to have been a slight problem with the PS2 HOUSE database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

OK Standard Stuff..

Here's my detail..

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: UPDATE forum
SET
styleid='1', title='General', description='General Discussion',
active='1', displayorder='1', parentid='-1', parentlist='1,-1',
allowposting='0', cancontainthreads='0',
sponsorname='Morning Norman',sponsorimg='www.morningnorman.com/photos/Stella.jpg',
sponsorurl='http://www.morningnorman.com/ubb',daysprune='0',
newpostemail='', newthreademail='',
moderatenew='0', allowhtml='1', allowbbcode='1',
allowimages='1', allowsmilies='1', allowicons='1',
styleoverride='0', allowratings='1', countposts='1',
moderateattach='0'
WHERE forumid='1'
mysql error: Unknown column 'sponsorname' in 'field list'

mysql error number: 1054

Date: Tuesday 19th of March 2002 12:03:42 AM
Script: http://www.morningnorman.com/vbb/vbb/admin/forum.php3
Referer: http://www.morningnorman.com/vbb/adm...edit&forumid=1

Can someone help me with this please.. I am somewhat of a dummy when it comes to scripting..

Admin · #**207** 03-19-2002, 05:12 AM

Run the three queries I tell you to run in my first post, they'll add the required fields to your table.

tanman · #**208** 03-19-2002, 02:02 PM

This sponsored by hack is cool.

You said you wanted to know if we wanted more

Our site is ad supported. I need to make sure the page top banners are not ignored.... Need to run the banners past some eyeballs, inside the forum threads.

How about a hack that adds a "sponsored by" banner or message with graphic INSIDE a forum thread, automatically, every X posts or so (where x could be set by admin to 10 or 12 or ???)?

One of our competitors has this on a phBB or some such...

Would that be hard?

nafae · #**209** 03-28-2002, 03:49 AM

Hmm Ok I installed this (Exactly) and made sure by going back and checking all the modified files, however whenever I add a sponsor to a forum, the category just dissapears! Then when I remove the sponsorship fields, the categories reeapear again!

I am unsure of what this is, firefly or anyone else any sort of help you could offer would be appreciated

mewgood · #**210** 03-28-2002, 04:18 AM

Will this owkr for 2.2.4?

Admin · #**211** 03-28-2002, 08:33 AM

Yes mewgood, and nafae did you add the template I told you to add? And made sure you added it to all template sets?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06132 seconds Memory Usage 2,378KB 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 (4)bbcode_code (10)bbcode_php (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 (2)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!