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.

[djmini]

Ok...

No Screen shots...

but I can explain the settings.

Enable Sponsor YES
Sponsor Name TMMZ
Use Sponsor Banner NO
Sponsor Banner
Sponsor URL http://www.teammightyminiz.com


_________________

So, that is set..

then when clicking on the "sponsored by TMMZ" text in the newly sponsored froum

Not Found



The requested URL /forum/vB.Sponsors/link.php was not found on this server.

the hyperlink = http://www.teammightyminiz.com/forum.../link.php?f=12

BTW it doesn't matter what sponsor name or url I add in the cp, it always hotlinks it ... http://www.teammightyminiz.com/forum.../link.php?f=12

Everytime.

[Deviation]

Originally Posted by djmini

Ok...
the hyperlink = http://www.teammightyminiz.com/forum.../link.php?f=12

BTW it doesn't matter what sponsor name or url I add in the cp, it always hotlinks it ... http://www.teammightyminiz.com/forum.../link.php?f=12

So http://www.teammightyminiz.com/forum is your site, correct?

From what I can tell, the directory /vB.Sponsors doesn't exist on that server. You did upload the items in the zip file to the server, correct? Also be sure the case is EXACTLY the same. Linux/Unix servers are sensitive to case (e.g. - vB is not equal to vb). So to recap, the vB.Sponsors directory should be uploaded to http://www.teammightyminiz.com/forum/vB.Sponsors/ .

If your testing it one specific forum, it will always be that forum's id (from vBulletin). It won't change the link the users click on. Only the site they are redirected to. The only time the "f=" part changes is when its a different forum/category.

[djmini]

ugh

I dunno

Warning: chdir(): No such file or directory (errno 2) in /var/www/html/forum/vB.Sponsors/link.php on line 27

Warning: main(./global.php): failed to open stream: No such file or directory in /var/www/html/forum/vB.Sponsors/link.php on line 29

Fatal error: main(): Failed opening required './global.php' (include_path='.:/php/includes:/usr/share/php') in /var/www/html/forum/vB.Sponsors/link.php on line 29

[Deviation]

Originally Posted by djmini

ugh

I dunno

Warning: chdir(): No such file or directory (errno 2) in /var/www/html/forum/vB.Sponsors/link.php on line 27

Warning: main(./global.php): failed to open stream: No such file or directory in /var/www/html/forum/vB.Sponsors/link.php on line 29

Fatal error: main(): Failed opening required './global.php' (include_path='.:/php/includes:/usr/share/php') in /var/www/html/forum/vB.Sponsors/link.php on line 29

The path you entered on line 27 isn't correct. It should point to the root of your forum. Example:
chdir('/var/www/html/forum/');

The trailing slash is important.

Getting closer. Don't give up yet.

[Deviation]

Originally Posted by Zilvia

This is the code I get from PHPMyAdmin after entering the query. The other error was from mysql.com when I looked up error #1064. Thanks!

MySQL said: Documentation

#1064 - 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 'ALTER TABLE Zilvia2K3_forum ADD (sponsor_banner_enabled INT(6) U

Didn't forget about you.

I just got MySQL 5.0 installed. The only issue I ran into was that I didn't specify a default value for some of the values. I've updated the zip file.

Try this (replace prefix with your table prefix):
First, drop the columns:

ALTER TABLE `PREFIX_forum` DROP `sponsor_enabled` ,
DROP `sponsor_banner_enabled` ,
DROP `sponsor_name` ,
DROP `sponsor_banner` ,
DROP `sponsor_url` ;

Now manually add the tables back:

ALTER TABLE `PREFIX_forum` ADD (sponsor_enabled INT(6) UNSIGNED NOT NULL DEFAULT '0');
ALTER TABLE `PREFIX_forum` ADD (sponsor_banner_enabled INT(6) UNSIGNED NOT NULL DEFAULT '0');
ALTER TABLE `PREFIX_forum` ADD (sponsor_name VARCHAR(250) NOT NULL DEFAULT '');
ALTER TABLE `PREFIX_forum` ADD (sponsor_banner VARCHAR(250) NOT NULL DEFAULT '');
ALTER TABLE `PREFIX_forum` ADD (sponsor_url VARCHAR(250) NOT NULL DEFAULT '');

Let me know if this works for you.

[djmini]

Hmmm I just can't figure it out.

I get this
The requested URL /forum/vB.Sponsors/link.php was not found on this server.

Is this normal???

/var/www/html/forum/

Is that ^ wrong?

What should it read if it is wrong?

So out of my element, but still seeking the answers.

[Deviation]

djmini,
I've attached a file called settings-check.php. Upload this to the vB.Sponsors directory on your server. Run the file. It will show you what the forum directory should be. Enter this on line 27 of link.php. Remember to delete the file from your server when you're done with it.

This file is now included in the zip package to help with the installation.

[djmini]

Awesome, that worked fine.

/var/www/html/forum/vB.Sponsors
was the one.

Thank You!

[djmini]

shoot spoke too soon... it worked Once...

now the error is

Database error in vBulletin 3.5.2:

Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum`, `date` ) VALUES ( '', 'TEST', 'TMMZ Archives', '1135973173');

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Friday, December 30th 2005 @ 03:06:13 PM
Script : http://www.teammightyminiz.com/forum.../link.php?f=12
Referrer : http://www.teammightyminiz.com/forum/
IP Address : XXXXXXXXX
Username : XXXXX
Classname : vb_database

[Deviation]

Originally Posted by djmini

shoot spoke too soon... it worked Once...

You have an older version. That bug has been fixed.

Uninstall via product manager, download the latest version, upload new files (overwriting old ones) and reinstall via product manager. Make sure you edit the link.php again (since it will be overwritten).