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!

robdj · #**232** 07-02-2002, 12:47 PM

OK, I had a similar problem to nafae -
"whenever I add a sponsor to a forum, the category just dissapears! Then when I remove the sponsorship fields, the categories reeapear again!"
The problem was that I had the template name incorrect. Make sure it is "forumhome_forumbit_level1_nopost_sponsor" exactly (Version 2.2.6)
Great hack - five stars!

Duke Of Lion · #**233** 07-11-2002, 02:48 PM

Quote:

Originally posted by FireFly
[B]Works with vBulletin v2.2.0!

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

I want to look there but it doesn't work! says to enter my username and then my registration number, yeah well my usernames on .org and .com are not the same..... I WANT THEM TO BE, I asked for it when i didn't registred right.....
.org = duke of lion
.com = duke of lions

Please help me out! I am a paying customer and I would appreciate your help!

Admin · #**234** 07-12-2002, 05:50 AM

Try https://vborg.vbsupport.ru/showthrea...threadid=26272 ...

Duke Of Lion · #**235** 07-16-2002, 06:49 PM

Works fine on 2.2.6, but....

On my techie style it the forum (Category) dissapears? what do I do wrong? Also where do I add "Proudly sponsored by..." in the category?

FireFly, THANK You, hope you don't want a piece of the money, it'll bring

Admin · #**236** 07-16-2002, 06:55 PM

You need to add the new template to all of your template sets.

Duke Of Lion · #**237** 07-16-2002, 07:35 PM

What about if i have 2 styles and my default image folder for the 2nd style is not /image? what do I fill in when I add the sponsor?
Actually I want to fill in the full path so I don't have the problem? what do I do?

Quote:

FireFly, THANK You, hope you don't want a piece of the money, it'll bring

FireFly r u too rich already?

Sorry, that I am just a poor student...

dieKetzer · #**238** 07-17-2002, 09:56 AM

Use this for your template:

PHP Code:


			
<tr id="cat">

    <td bgcolor="#005628" colspan="6" cellspacing="0" cellpadding="0">

<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">

  <TR>

    <TD width="50%" valign="middle"><A href="forumdisplay.php?s=$session[sessionhash]&forumid=$forum[forumid]"><NORMALFONT color="#FFCC00"><B>$forum[title]</B></NORMALFONT></A><br><smallfont color="{categoryfontcolor}">$forum[description]</smallfont></TD>

    <TD width="50%" valign="top" align="right"><A href="$forum[sponsorurl]" target="_blank"><IMG src="https://vborg.vbsupport.ru/greentek/$forum[sponsorimg]" border="0" alt="Proudly sponsored by $forum[sponsorname]"></A></TD>

  </TR>

</TABLE>

</td>

</tr>

Quote:

Originally posted by bpuetz
A question. I would like to get rid of the line between the category name cell and the sponsor cell. Anyone know a way to do this without losing the rest of the lines? What I would really like to do is colspan the entire row and left justify the category name and right justify the sponsor ad in the resulting cell. I don't suppose anyone knows any tricks to do this?

Thanks!

Bill

bpuetz · #**239** 07-21-2002, 10:42 PM

The problem (a good problem!) I'm running into with this is that I only have four categories, and one in particular is the one that the sponsors want to be on.

What would it take to allow me to have a pool of sponsors and rotate them randomly? I would like to be able to have individual sponsor pools by category although one pool for all categories would be acceptable. I would like to have equal exposure for all sponsors in the same pool.

Firefly, I would certainly step up with some cash if you could make this happen -- and I bet a number of other folks would also.

Admin · #**240** 07-22-2002, 06:03 AM

Have you tried these hacks?
https://vborg.vbsupport.ru/showthrea...&highlight=ads
https://vborg.vbsupport.ru/showthrea...&highlight=ads

carpman · #**241** 07-26-2002, 04:16 PM

Hello, will this hack work ok with this hack?
https://vborg.vbsupport.ru/showthrea...threadid=33961

cheers

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04891 seconds Memory Usage 2,384KB 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 (11)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!