vB.Sponsors - Forum and Category Sponsorship with Statistics

vB.Sponsors
Forum and Category Sponsorship Ads with Statistics

Add sponsor's ads to forums & categories

INTRO:
This extension will allow you to add sponsors to you forums and categories. You can also track the hits to each sponsor by date as well. See below for more features.

FEATURES:
-Enable sponsorship on forums and categories
-Use a banner or a text link
-Supports large banners for the top of the sponsored forum, large banners at the top of the thread and small banners for the forum listing
-Tracks hits for each sponsor
-Statistics viewable inside Admin CP
-Easy to use and install

THANKS:
...to vBulletin.org and its members.
...to the people who have installed this mod, suggested improvements and found bugs.

FEEDBACK:
Feedback Forums: http://www.DigitalDeviation.com/forums/
Feedback is always welcomed! Good or bad. Post all feedback and feature requests in this thread or in the forums above. Trust me, I'll be reading it even if I don't respond to every post.

SUPPORT:
Support Forums: http://www.DigitalDeviation.com/forums/
Should you need any assistance with this, you can reach me via the link above or by posting in this thread.

In either case, please post as much detail as possible with any code or screenshots pertaining to the issue. MySQL, PHP and web server software versions are helpful. You can obtain these from the Admin CP in vBulletin.

DONATE:
If you like this product, a donation would be appreciated. But of course its not required.



INSTALLATION:
Documentation is located here. I've found it's easier to maintain an online version rather than files included in the download.

DEMO SITES: If you'd like your forum added here, PM me.
Sites listed at http://www.digitaldeviation.com/proj...referencesites

VERSION HISTORY:
1.1.0 - Code Cleanup/Bugfix/Feature Added
Big banner display now works
Added the ability to change the Forum Sponsored By text
Updated example template code (added SHOWTHREAD template code)
Cleaned up code (XML, vBSponsors.php, link.php)
Code now more closely matches the vBulletin 3.6.x version (here)
Updated the documentation
1.0.5 - Feature Added/Bug Fix/Code Cleanup
Added a large banner option for the forum that's sponsored by the sponsor
Added FORUMDISPLAY template code
Cleaned up code (link.php, vBSponsors.php)
1.0.4 - Bug Fix
Corrected statistics database error.
Template code updated.
1.0.3 - Bug Fix
Corrected issue with settings. Now saves settings.
Fixed parser error.
1.0.2 - Features Added
Added Admin CP block
Stats are now viewable in the Admin CP by administrators
Minor template changes (please verify your code if upgrading)`
1.0.1 - Bug Fix
Corrected issue with vBSponsors table. Now correctly adds statstics.
1.0.0 - Initial Release

---FEATURE REQUEST LIST---
-Stats viewable by the sponsors in the User CP of their account
-Option to use Adsense code instead of link
-Ability to change the "Forum Sponsored By" text on a per forum basis
-Ability to hide sponsors based on user groups
-Multiple sponsors per forum/category
-Option to remove the branding copyright

---KNOWN BUGS---
-NONE

Don't forget to click the install link below if you use it.

[mattyk72]

Nice job, I was looking for something like this.

clicks install

[mtha]

Nice job.

FEATURE REQUEST:

01. In AdminCP, option to view statistic by sponsorshipID (with sponsor name)

02. Big sponsor banner (image and/or text) on top of sponsored forum (when view that forum), with option to turn on/off

[sam anders]

installed and working great thanks

[BrandiDup]

This would be absolutely perfect if I could turn it off for certain usergroups (my paid members). If that was possible, I'd definitely install asap!

[BLazeD1]

Originally Posted by GrantHorizons

Hi,

Great hack, working well except for one glitch no one else seems to have, so I probably screwed up somewhere, but for the life of me can't figure it out.

When you click on the sponsors image, it goes to a redirect page, BUT the page says:

----------------------
Redirecting...

Can't find phrase ''

If your browser etc...
Proceed button
------------------------

and then redirects just fine.

err, what phrase? It works, but this looks bad!

any ideas?

Thanks, Grant

Ditto. Shame this isnt fixed.

[jaymzz]

Awsome hack. But when you click on the sponsors image, it brings up error 404 this page cannot be found. Did I do something wrong? As soon as this is fixxed, I will gladly click installed.

[jaymzz]

Anyone?

[directprint]

Originally Posted by jaymzz

Awsome hack. But when you click on the sponsors image, it brings up error 404 this page cannot be found. Did I do something wrong? As soon as this is fixxed, I will gladly click installed.

I would say the link address that you have put in is incorrect.
It must be the full address http://www.domain_name.com


1. From the Admin CP -> Forums & Moderators -> Forum Manager
2. Choose Edit Forum next to the forum/category you wish to add a sponsor for
3. Under vB.Sponsors, choose Enable Sponsor YES
4. Enter the Sponsor's name
5. Choose whether or not to enable the sponsor's banner (a text link is displayed if set to NO)
6. Enter the path to the sponsor's banner
7. Enter the link to the sponsor's site

[jaymzz]

Thanks, but I did put in the full address. And I tried it a few different ways also. I am wondering if I did something wrong on the install.

[Spika]

Originally Posted by designBox

Sorry for the double post but this is concerning another error.
It came to my attention that if the forum name had a ' in its name then vbSponsor is generating an error when clicking to the sponsor's link.

I pasted here this error:

Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Your link here', '97', 'Programmer's Alley', '1140258987');

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Alley', '1140258987')' at line 1
Error Number : 1064
Date		 : Saturday, February 18th 2006 @ 11:36:27 AM
Script	   : http://www.hostnode.com/vB.Sponsors/link.php?f=97
Referrer	 : http://www.hostnode.com/forum.php
IP Address   : XXXXXXXXXXXXX
Username	 : XXXXXXXXXXXXX
Classname	: vb_database

I changed the name of the forum, but i reported this error at it may help some others.

Hello I have similar error:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO `vbulletin_vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Encuentro BMWRIDERS '06', '12', 'Kedadas', '1154175656');

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '06', '12', 'Kedadas', '1154175656')' at line 1
Error Number : 1064
Date         : Saturday, July 29th 2006 @ 12:20:56 PM
Script       : http://www.gstrail.es/foro/vB.Sponsors/link.php?f=12
Referrer     : http://www.gstrail.es/foro/forumdisplay.php?f=3
IP Address   : xxx.xxx.xxx.xxx
Username     : Nickname
Classname    : vb_database

I don?t have ' in the name of the forum, help please


Solved, Reinstalling