Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.5 > vBulletin 3.5 Add-ons
Reload this Page vB.Sponsors - Forum and Category Sponsorship with Statistics
FAQ Community Calendar Today's Posts Search

Reply
Page 3 of 34 12 3 4513 Last »
 
Thread Tools
vB.Sponsors - Forum and Category Sponsorship with Statistics Details »»
vB.Sponsors - Forum and Category Sponsorship with Statistics
Version: 1.1.0, by Deviation Deviation is offline
Developer Last Online: Jun 2016 Show Printable Version Email this Page
Version: 3.5.8 Rating:
Released: 12-18-2005 Last Update: 05-24-2007 Installs: 235
DB Changes Uses Plugins Template Edits
Additional Files  
No support by the author.

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.

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #22  
Old 12-22-2005, 01:11 AM
Deviation Deviation is offline
 
Join Date: Sep 2005
Location: Ohio
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #23  
Old 12-24-2005, 04:37 AM
Zilvia's Avatar
Zilvia Zilvia is offline
 
Join Date: Apr 2002
Location: Denver, CO
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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 
Reply With Quote
  #24  
Old 12-24-2005, 08:37 AM
kommuni kommuni is offline
 
Join Date: Apr 2004
Posts: 58
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #25  
Old 12-24-2005, 12:24 PM
Deviation Deviation is offline
 
Join Date: Sep 2005
Location: Ohio
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #26  
Old 12-24-2005, 12:30 PM
Deviation Deviation is offline
 
Join Date: Sep 2005
Location: Ohio
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by kommuni
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
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.
Reply With Quote
  #27  
Old 12-24-2005, 02:30 PM
Zilvia's Avatar
Zilvia Zilvia is offline
 
Join Date: Apr 2002
Location: Denver, CO
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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!
Reply With Quote
  #28  
Old 12-24-2005, 03:02 PM
Deviation Deviation is offline
 
Join Date: Sep 2005
Location: Ohio
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Zilvia
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!
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!
Reply With Quote
  #29  
Old 12-24-2005, 03:09 PM
Zilvia's Avatar
Zilvia Zilvia is offline
 
Join Date: Apr 2002
Location: Denver, CO
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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!
Reply With Quote
  #30  
Old 12-25-2005, 01:13 PM
Deviation Deviation is offline
 
Join Date: Sep 2005
Location: Ohio
Posts: 226
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #31  
Old 12-25-2005, 08:06 PM
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Location: Australia
Posts: 2,469
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
Reply
Page 3 of 34 12 3 4513 Last »

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 08:25 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05176 seconds
  • Memory Usage 2,401KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_php
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete