Add "Sponsored by" banners to your forum categories

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

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:

<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!

[TheComputerGuy]

Nice Hack FireFly works great

Well I tried to add this to PHP include, then use it on the forums

PHP Code:

$sp1 = include("http://blahblah.com/cgi-bin/blah/clickcount.cgi?URL=http://blahblah.com"); 


then place $sp1 where I wanted their number of click to show up..
Well this only placed the number of clicks above the logo , and return the number "1" were the correct number was sup.. to be..

I just* got vBulletin and have not had time to read all the information on it, nor do I understand how it works at all (heh)

But I woud have figure you add that to phpinclude and then use it..


anyone have any ideas?

Originally posted by FireFly
ForzaGrifo:
Can you please paste the complete error message here?
This function is used on almost all files, you really shouldn't have a problem with it.
Is this the only place you get this error?

Everyone seems to have no problem but I'm having tons of problem!

Here's the error message when I tried to add a forum in vb's cpanel:

Fatal error: Call to undefined function: makeinputcode() in /home/everyone/public_html/forum/admin/forum.php on line 123

Line 123 is this line:

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

In the cpanel I would see the add forum screen but after the "Sponsor(only supported by categories)" header, it gets cut off and the rest of the input fields are not shown.

And I'm getting this error when I try to show my forums:

Parse error: parse error in /home/everyone/public_html/forum/index.php on line 365


Line 365 in my index.php is this:

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


Which doesn't make any sense. It seems it's not regconizing the fact that I have added the new fields in the forum tables, and I'm sure that I have added them to the table.
Please help!!!

[Admin]

MarkB:

PHP Code:

if ($forum['sponsorimg']) {
  eval("\$sponsoredby = \"".gettemplate('forumdisplay_sponsoredby')."\";");
} else {
  $sponsoredby = '';
} 


ForzaGrifo:
Well, the first error I have NO idea what is all about.
That function is used on ALL admin pages, can't understand what it's producing an error here.

About the second error:
Can you paste a line or two BEFORE line 365?
Maybe you deleted a ; or }, I dunno.

[SirSteve]

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

Shouldn't that be "sponsoring" ?

Also, I would like all my sponsor images in a subfolder under images. Can you help me with this?

Also, I would like all my sponsor images in a subfolder under images. Can you help me with this?

when you enter the path to the image just enter:

/images/sponsors/blahblah.gif

or what folder you create and sponsors image name...

[Admin]

[QUOTE]Originally posted by SirSteve
makeinputcode("Sponsor banner file<br>(your default images folder is added, no need in that)","sponsorimg");

Shouldn't that be "sponsoring" ?

Also, I would like all my sponsor images in a subfolder under images. Can you help me with this?

[Admin]

[QUOTE]Originally posted by YourHostSucks
when you enter the path to the image just enter:

/images/sponsors/blahblah.gif

or what folder you create and sponsors image name...

doh, yea i have mine setup in the /sponsor folder..

and /sponsors/blah.jpg

just a brain fart -=/

[SirSteve]

Originally posted by FireFly

No, sponsorimg = sponsor image.

I seen that afterwards.

Thanks.