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.

[mholtum]

Awesome! Installed

[lazyseller]

will the sponsor be able to view their stats ? or is it for admins only ?

[TundraSoul]

I have a small error that happens when people click on the banners. Here's the error:

Database error in vBulletin 3.5.1:
Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum`, `date` ) VALUES ( '', 'Toyotaworld.com', 'Engine & Drivetrain', '1135206904');
MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, December 21st 2005 @ 05:15:04 PM
Script : http://www.mysite.com/forums/link.php?f=30
Referrer : http://www.mysite.com/forums/index.php?
IP Address : xxxxxxxx
Username : TundraSoul
Classname : vb_database

What should I change?

[Deviation]

Originally Posted by lazyseller

will the sponsor be able to view their stats ? or is it for admins only ?

Eventually I would like to add that feature. Once I tackle the admin stats, this will be next.

[Deviation]

Originally Posted by TundraSoul

I have a small error that happens when people click on the banners. Here's the error:

Database error in vBulletin 3.5.1:
Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum`, `date` ) VALUES ( '', 'Toyotaworld.com', 'Engine & Drivetrain', '1135206904');
MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, December 21st 2005 @ 05:15:04 PM
Script : http://www.mysite.com/forums/link.php?f=30
Referrer : http://www.mysite.com/forums/index.php?
IP Address : xxxxxxxx
Username : TundraSoul
Classname : vb_database

What should I change?

Problem resolved. That was an oversight on my part. Download the latest version and you should be set.

Anyone who has installed/downloaded this should download the latest version (always posted here).

[TundraSoul]

I upgraded the product and re-uploaded the file. There is still however another error that occurs when you click on the banners.

Database error in vBulletin 3.5.1:
Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Toyotaworld.com', '30', 'Engine & Drivetrain', '1135212937');
MySQL Error : Unknown column 'forum_id' in 'field list'
Error Number : 1054
Date : Wednesday, December 21st 2005 @ 06:55:37 PM
Script : http://www.mysite.com/forums/link.php?f=30?f=30
Referrer : http://www.mysite.com/forums/index.php?
IP Address : xxxxxxxxxxx
Username : TundraSoul
Classname : vb_database

Originally Posted by Deviation

Problem resolved. That was an oversight on my part. Download the latest version and you should be set.

Anyone who has installed/downloaded this should download the latest version (always posted here).

[Deviation]

Originally Posted by TundraSoul

MySQL Error : Unknown column 'forum_id' in 'field list'

It looks like you will need to completely uninstall the product and reinstall it. It didn't create the forum_id column correctly on the upgrade (likely my issue). I will work to correct the upgrade procedure.

Sorry about that.

[TundraSoul]

Very good, no problem, that fixed it.

Can I get the template code so we can use this in a sub forum?

Originally Posted by Deviation

It looks like you will need to completely uninstall the product and reinstall it. It didn't create the forum_id column correctly on the upgrade (likely my issue). I will work to correct the upgrade procedure.

Sorry about that.

[Deviation]

Originally Posted by TundraSoul

Very good, no problem, that fixed it.

Can I get the template code so we can use this in a sub forum?

Sub forum code is now included in the download :glasses: Also updated one of the phrases. If you choose to update, be sure to select the Allow Overwrite option in the product manager

[TundraSoul]

When using the sub category code, forumbit_level1_post, the image aligns to the left, instead of to the right.

Originally Posted by Deviation

Sub forum code is now included in the download :glasses: Also updated one of the phrases. If you choose to update, be sure to select the Allow Overwrite option in the product manager