vb.org Archive - vB.Sponsors - Forum and Category Sponsorship with Statistics

Page 1 of 9

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vB.Sponsors - Forum and Category Sponsorship with Statistics (https://vborg.vbsupport.ru/showthread.php?t=103327)

Deviation

12-18-2005 10:00 PM

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.
https://vborg.vbsupport.ru/external/2010/07/4.gif

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.

-=Sniper=-

12-19-2005 09:59 PM

excellent, will be using it soon :)

jugo	12-19-2005 11:05 PM

Finally, someone went the extra mile. Thanks bro. Iwas This close (puts finger in "this close" position) to starting on a hack myself.

Thanks for saving me the trouble.

Daniel

12-19-2005 11:18 PM

Great job. :)

dsotmoon

12-20-2005 01:13 AM

where does the category sponsorship show up?, I just see the forum sponsor spot

The Chief

12-20-2005 01:56 AM

was looking for this, thanks for releasing it!

Will install as soon as my new version loads up ;)

Hornstar

12-20-2005 02:31 AM

I dont see the hack in the admincp, I found the part where you can turn it on and off in the admincp but not the main part from this one https://vborg.vbsupport.ru/attachmen...chmentid=39677

THanks

sensimilla

12-20-2005 06:15 AM

looks like a handy hack ! thanks

Snake

12-20-2005 08:30 AM

Nice one!

Deviation

12-20-2005 10:43 AM

Quote:

Originally Posted by dsotmoon

where does the category sponsorship show up?, I just see the forum sponsor spot

Since categories behave like forums, you follow the same steps in the readme. Only instead of choosing "Edit Forum" next to the forum name, you choose "Edit Forum" next to the category. The template changes are teh same regardless. Hopefully that makes sense to you.

Quote:

Originally Posted by hornstar1337

I dont see the hack in the admincp, I found the part where you can turn it on and off in the admincp but not the main part from this one https://vborg.vbsupport.ru/attachmen...chmentid=39677

THanks

After you click "Edit Forum" (under Forum Manager in the Admin CP), you will see the option to enter the information towards the bottom of the forum options.

I've attached a couple screenshots showing what I'm talking about. Hopefully that helps you guys out.

mholtum

12-20-2005 01:45 PM

Awesome! Installed

lazyseller

12-21-2005 03:58 PM

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

TundraSoul

12-21-2005 09:25 PM

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

12-21-2005 10:03 PM

Quote:

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

12-21-2005 10:42 PM

Quote:

Originally Posted by TundraSoul

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

12-21-2005 11:00 PM

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

Quote:

Originally Posted by Deviation

Deviation

12-21-2005 11:21 PM

Quote:

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

12-21-2005 11:56 PM

Very good, no problem, that fixed it.

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

Quote:

Originally Posted by Deviation

Deviation

12-21-2005 11:58 PM

Quote:

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

12-22-2005 12:31 AM

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

Quote:

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

Deviation

12-22-2005 01:11 AM

Quote:

Originally Posted by TundraSoul

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

Template code has been fixed. :)

Zilvia

12-24-2005 04:37 AM

I am getting this when I try to save the sponsor info in the catagory. Any ideas? Thanks!

PHP Code:


		
			
Database error in vBulletin 3.5.2:



Invalid SQL:

UPDATE forum SET

    title_clean = 'Administration',

    title = 'Administration',

    description_clean = '',

    description = '',

    link = '',

    displayorder = 5,

    daysprune = 1,

    parentid = -1,

    newpostemail = '',

    newthreademail = '',

    ### Bitfield: forum.options ###

        options = IF(options & 8, options - 8, options),

        options = IF(options & 16, options - 16, options),

        options = IF(options & 32, options - 32, options),

        options = IF(options & 131072, options - 131072, options),

        options = IF(options & 32768, options, options + 32768),

        options = IF(options & 8192, options, options + 8192),

        options = IF(options & 4, options - 4, options),

        options = IF(options & 1, options, options + 1),

        options = IF(options & 2, options - 2, options),

        options = IF(options & 16384, options, options + 16384),

        options = IF(options & 256, options - 256, options),

        options = IF(options & 64, options - 64, options),

        options = IF(options & 128, options - 128, options),

        options = IF(options & 512, options - 512, options),

        options = IF(options & 1024, options - 1024, options),

        options = IF(options & 2048, options - 2048, options),

        options = IF(options & 4096, options, options + 4096),

        options = IF(options & 65536, options, options + 65536),

    styleid = 0,

    password = '',

    sponsor_enabled = '1',

    sponsor_name = 'Zilvia.net',

    sponsor_banner_enabled = '1',

    sponsor_banner = 'http://www.zilvia.net/images/forumsp1.gif',

    sponsor_url = 'http://www.zilvia.net'

WHERE forumid = 5;



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

Error Number : 1054

Date         : Friday, December 23rd 2005 @ 11:36:25 PM

Script       : [url]http://www.zilvia.net/f/admincp/forum.php[/url]

Referrer     : [url]http://www.zilvia.net/f/admincp/forum.php?do=edit&f=5&s=[/url]

IP Address   : 

Username     : WeST

Classname    : vb_database

kommuni

12-24-2005 08:37 AM

Quote:

Originally Posted by Zilvia

I am getting this when I try to save the sponsor info in the catagory. Any ideas? Thanks!

PHP Code:


		
			
Database error in vBulletin 3.5.2:



Invalid SQL:

UPDATE forum SET

    title_clean = 'Administration',

    title = 'Administration',

    description_clean = '',

    description = '',

    link = '',

    displayorder = 5,

    daysprune = 1,

    parentid = -1,

    newpostemail = '',

    newthreademail = '',

    ### Bitfield: forum.options ###

        options = IF(options & 8, options - 8, options),

        options = IF(options & 16, options - 16, options),

        options = IF(options & 32, options - 32, options),

        options = IF(options & 131072, options - 131072, options),

        options = IF(options & 32768, options, options + 32768),

        options = IF(options & 8192, options, options + 8192),

        options = IF(options & 4, options - 4, options),

        options = IF(options & 1, options, options + 1),

        options = IF(options & 2, options - 2, options),

        options = IF(options & 16384, options, options + 16384),

        options = IF(options & 256, options - 256, options),

        options = IF(options & 64, options - 64, options),

        options = IF(options & 128, options - 128, options),

        options = IF(options & 512, options - 512, options),

        options = IF(options & 1024, options - 1024, options),

        options = IF(options & 2048, options - 2048, options),

        options = IF(options & 4096, options, options + 4096),

        options = IF(options & 65536, options, options + 65536),

    styleid = 0,

    password = '',

    sponsor_enabled = '1',

    sponsor_name = 'Zilvia.net',

    sponsor_banner_enabled = '1',

    sponsor_banner = 'http://www.zilvia.net/images/forumsp1.gif',

    sponsor_url = 'http://www.zilvia.net'

WHERE forumid = 5;



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

Error Number : 1054

Date         : Friday, December 23rd 2005 @ 11:36:25 PM

Script       : [url]http://www.zilvia.net/f/admincp/forum.php[/url]

Referrer     : [url]http://www.zilvia.net/f/admincp/forum.php?do=edit&f=5&s=[/url]

IP Address   : 

Username     : WeST

Classname    : vb_database

Hi Deviation,

you did a great approach there. Love this idea and surely will implement it after holidays. I hope you will keep it in development and add further features. I'm just implementing some more sponsoring-features and this one will surely be loved by the sponsors.

Did you think about placing another sponsor image or text inside the forums? Would be good to have it additionally on top or bottom of the forumdisplay page or in the threads.

Great thing - keep up the good work.

Frank

Deviation

12-24-2005 12:24 PM

Quote:

Originally Posted by Zilvia

I am getting this when I try to save the sponsor info in the catagory. Any ideas? Thanks!

PHP Code:


		
			
Database error in vBulletin 3.5.2:



Invalid SQL:



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

It looks the columns didn't get added to the _forum table. Did you receive any errors when installing this? Do you have access to your database via phpMyAdmin (or some other tool)? If so, check the _forum table structure to see if it created the columns. You will need access to create & modify tables with the account used by vBulletin.

Try uninstalling the product and reinstalling. When reinstalling, be sure to choose Allow Overwrite. Make sure you are using the latest version (posted here).

Just want to check the basics first.

Deviation

12-24-2005 12:30 PM

Quote:

Originally Posted by kommuni

Thanks for the kind words. I hope to keep this around for some time. I find it enjoyable doing these types of things. Especially when I receive a warm welcome on my first release. :classic:

Do you mean a banner from the same sponsor on the top and/or bottom of the forum they sponsored? Sounds like a great idea to me. I'll add it to the feature requests list.

Zilvia

12-24-2005 02:30 PM

Installed without any errors, the product uploads fine and I have tried uninstalling it and reinstalling it about 5x now with no luck.

within the Table vbsponsors are these coulums

id
sponsor_name
forum_id
forum
date

as for the table forum:

it looks like its missing...

sponsor_enabled & sponsor_banner_enabled

Also, I donno if there are normal but within the forum table there coulums called...

sponsorname
sponsorimg
sponsorurl

Im pretty sure I dont have any simular hacks installed, although about two years ago I had a simular kind of hack installed. Should I remove those coulums? EDIT: I removed them and didnt seem to help.

Any ideas? Thanks!!

Merry Xmas too!

Deviation

12-24-2005 03:02 PM

Quote:

Originally Posted by Zilvia

vB.Sponsors should contain the following columns:
id
sponsor_name
forum_id
forum
date

So that one looks OK.

_forum should have the following added to it:
sponsor_enabled
sponsor_banner_enabled
sponsor_name
sponsor_banner
sponsor_url

I'm not sure what the other columns are, but they aren't mine. ;) If the old hack you had isn't in use, I would drop those columns. Try dropping those columns, uninstalling, verifying everything is gone from the table _forum and reinstalling.

Let me know if this works for you. If it still doesn't create the columns, I'll post up the manual SQL you can try.

...and a Merry X-Mas to you too!

Zilvia

12-24-2005 03:09 PM

Tried that just before you replied I guess, I edited my post. Your to quick to reply! :)

I tried to pull a manual SQL query from the xml file, but I figured I better not as Im not sure what im doing exactly.

If you could give me the manual sql to try. Thanks so much!

Deviation

12-25-2005 01:13 PM

PHP Code:


		
			
ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_enabled INT(6) UNSIGNED NOT NULL DEFAULT '')



ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_banner_enabled INT(6) UNSIGNED NOT NULL DEFAULT '')



ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_name VARCHAR(250) NOT NULL DEFAULT '')



ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_banner VARCHAR(250) NOT NULL DEFAULT '')



ALTER TABLE TABLE_PREFIX_forum ADD (sponsor_url VARCHAR(250) NOT NULL DEFAULT '')

Replace TABLE_PREFIX with the prefix of your vB tables. Let me know the results.

Hornstar

12-25-2005 08:06 PM

thanks for the reply, I didnt think of that lol.

Also I just noticed you added your link on the bottom of the forum lol, very sly lol

Powered by vBulletin Version 3.5.2
Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.
vB.Sponsors 0.1.0

Zilvia

12-25-2005 09:00 PM

Im getting an error. I am running MySQL 5, donno if thats a problem.

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

That error say this in the docs.

Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)

Message: %s near '%s' at line %d

Deviation

12-26-2005 02:37 PM

Quote:

Originally Posted by hornstar1337

Also I just noticed you added your link on the bottom of the forum lol, very sly lol

Powered by vBulletin Version 3.5.2
Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.
vB.Sponsors 0.1.0

;) I figured its a freebie, so that wouldn't be a huge deal ;) THough it loos like you may be using the older version. Be sure to update.

Quote:

Originally Posted by Zilvia

Is this the full error from vB? Looks like it doesn't like the SQL string I'm using. I'll have to look into this one some more and get back to you. I've not used mysql 5 yet.

Ole_Chilli

12-27-2005 02:30 AM

worked perfectly no problems .... I havetried many of these sponsor programs all hurt my head .. this was flawless

Hornstar

12-27-2005 08:37 AM

Yeah i updated and changed the link to one of my other sites as i still dont know how to remove phases only edit them lol, but its cool. I guess its just more sponsorship for that site :D

Zilvia

12-28-2005 02:24 AM

Quote:

Is this the full error from vB? Looks like it doesn't like the SQL string I'm using. I'll have to look into this one some more and get back to you. I've not used mysql 5 yet.

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

djmini

12-28-2005 06:38 AM

I installed and have tried to use.

I can add the sponsors easily enough, but for some reason the actual links are not correct when clicked on.

Sponsored by - ThatGuy (http://www.thatguy.com) But when clicked the url = http://www.thatguy.com/forum/vB.Sponsors/link.php?f=12

So how do I remove the /forum/vB.Sponsors/link.php?f=12 part???

PennylessZ28

12-28-2005 07:45 AM

works great on my end

Deviation

12-28-2005 10:47 AM

Quote:

Originally Posted by Zilvia

I'm still looking into this one. I haven't had a chance to sit down and disect it yet though. I should have some time tonight.

Quote:

Originally Posted by djmini

The sponsorship links will always appear in the following format:

Code:

http://www.yoursite.com/yourforum/vB.Sponsors/link.php?f=#

# being the id of your forum (automatically generated).

So if your forum is in fact thatguy.com, its appearing correctly. You do not need to add the actual URL after the sponsor's name. In fact, I would suggest you not do that. Its more beneficial to use the link generated by vB.Sponsors as it tracks the hits.

Hope that helps.

djmini

12-28-2005 04:57 PM

Quote:

Originally Posted by Deviation

I'm still looking into this one. I haven't had a chance to sit down and disect it yet though. I should have some time tonight.

The sponsorship links will always appear in the following format:

Code:

http://www.yoursite.com/yourforum/vB.Sponsors/link.php?f=#

ThatGuy.com was an example, not my forum.
I did not add the actual URL when adding the sponsor name, I placed the url in the space that asks for it in the CP.

It is clickable but this is the address, http://www.thatguy.com/forum/vB.Sponsors/link.php?f=12 , which does nto take a visitor to the Sponsor's site at all.

Still confused.

Deviation

12-28-2005 06:40 PM

Quote:

Originally Posted by djmini

Does it just not do anything (blank page)? Or does it error out? Can you show me a screenshot of the settings your entering as well as the actual address (either by PM or here)?

Has to be something simple that's been overlooked. :ermm:

All times are GMT. The time now is 06:06 AM.

Page 1 of 9

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01763 seconds Memory Usage 1,970KB 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 (4)bbcode_php_printable (21)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)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
Messages: