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)
-   -   Add "Sponsored by" banners to your forum categories (https://vborg.vbsupport.ru/showthread.php?t=26818)

theironmic 03-15-2002 04:11 AM

where de u put the image link at

Floris 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 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 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 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 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 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 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 :o

mewgood 03-28-2002 04:18 AM

Will this owkr for 2.2.4?

Admin 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?

LouChipher 03-28-2002 10:02 AM

After 15 pages...
FireFly, your hack is only for categories and not specially for forums, correctly?

Admin 03-28-2002 02:25 PM

Yes.

nafae 03-28-2002 04:46 PM

I added the template in the instructions, but not any others, are there other templates I need to add?

Ninth Dimension 04-02-2002 03:15 PM

Hi everyone, does this hack have the ability to display the sponsors banners on pages other than the forumhome yet?

Admin 04-03-2002 05:17 AM

Yeah I think someone posted how to make it show up showthread.php. Browser the thread. :)

Ninth Dimension 04-03-2002 08:30 AM

Ah cool (maybe I should spend some more time reading these messages, but 15 pages is a bit much, and I was so busy yesterday)

dgessler 04-12-2002 02:28 AM

I have a question if someone can be nice enough and show me some light. Would it be possible to run this with something like phpAds, or any similar ad-tracking software? Just so that it can keep track of impressions, etc. Possible?

Thanks a lot,
Dan

hypedave 04-12-2002 02:48 AM

I had this previously installed on my vb 2.2.1 board when vb 2.2.5 came out, I built a whole new board, I cant get this to install on vb 2.2.5 for anything in the world has anybody tryed ?

Wayne2k1.com 04-12-2002 07:31 AM

Yup.

Works with 2.2.5 as well :)

hypedave 04-12-2002 01:55 PM

Quote:

Originally posted by Wayne2k1.com
Yup.

Works with 2.2.5 as well :)

how did you get it to work, since I know its works now, I will try again, and i have a problem again I will let you know

JackG 04-14-2002 06:48 PM

Hi, when I run this in phpMyAdmin:

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

I get this message;

Your SQL-query has been executed successfully


No tables found in database.

And it dosent create the tables.
I am doing it in the correct place and
their is a forum table thier. My vB version
is 2.2.5.

Does anyone know why this is not working?

Thanks in advance.

UPDATE:

I Have Since Manually Added These Tables.

Airwaves 04-19-2002 09:09 PM

http://www.sitepointforum.com/

has a nice 'proudly sponsored by' graphic which isnt tiled, when I put this image into my forum, it tiles.

I know you can fix this with CSS, but I cant remeber the code, can anyone help please.

BTW, nice hack, have it on my forum :D

kbusque 05-08-2002 05:57 PM

I installed the hack, and I think it is working (didn't break anything), where do i go to add sponsors? Sponsor img's etc? Directly in the mysql db?

RDX1 05-28-2002 03:10 AM

i dont have time to read the whole thread, does this work for 2.2.5 and 2.2.6 final

Wayne2k1.com 05-28-2002 05:58 AM

lol :p

I don't have time to install this hack...will you install it for me? :tired:

Admin 05-28-2002 06:59 AM

[QUOTE]Originally posted by NerdNations
i dont have time to read the whole thread, does this work for 2.2.5 and 2.2.6 final

Palyntir 05-29-2002 06:54 PM

has anyone been able to make this work with flash banners?

Demetris 05-31-2002 05:57 PM

Fantastic

Just installed this hack and already have my first paying sponsor.
The only problem i have is that whichever forum headin i add a sponsor to i then loose the link for that forum.

Did i do something wrong

bpuetz 06-20-2002 11:15 PM

I just love this hack! My site (still in development) will be ad free simply because I hate banners. But this hack gives me a way to generate a few dollars for bandwidth while still being very tasteful and subdued. Thanks so much, FireFly! If you ever make it down San Antonio way, I owe you a margarita! :)

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

almightyone 06-27-2002 09:15 PM

Quote:

Originally posted by NerdNations
i dont have time to read the whole thread, does this work for 2.2.5 and 2.2.6 final
if you dont got time to read a few pages wher will you find the time to install this hack? :ermm: :tired:

robdj 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 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 07-12-2002 05:50 AM

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

Duke Of Lion 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 07-16-2002 06:55 PM

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

Duke Of Lion 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 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 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 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 07-26-2002 04:16 PM

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

cheers


All times are GMT. The time now is 11:19 PM.

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.01501 seconds
  • Memory Usage 1,845KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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