The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
vB.Sponsors - Forum and Category Sponsorship with Statistics Details »» | |||||||||||||||||||||||||||
vB.Sponsors - Forum and Category Sponsorship with Statistics
Developer Last Online: Jun 2016
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
|
Comments |
#82
|
||||
|
||||
While in the middle of installing and editing the 1.02 version I got the email for the new one 1.03. So I installed that version. The main problem now seems to be that its not saving the settings for vB.Sponsors. For further testing, I went and edited the forumhome templates to assume the sponsors are always enabled and it worked fine.
Also, for lawahdy .. Mannak lawahdak, I got the same error when checking statistics |
#83
|
||||
|
||||
Ok, Now I got a new error trying to reinstall it. Any tips how to completely uninstall it with parts from the installation file?
Code:
Database error in vBulletin 3.5.2: Invalid SQL: INSERT INTO productcode (productid, version, installcode, uninstallcode) VALUES ('vB.Sponsors', '1.0.0', '\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_enabled INT(6) UNSIGNED NOT NULL DEFAULT \'0\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_banner_enabled INT(6) UNSIGNED NOT NULL DEFAULT \'0\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_name VARCHAR(250) NOT NULL DEFAULT \'\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_banner VARCHAR(250) NOT NULL DEFAULT \'\')\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum ADD (sponsor_url VARCHAR(250) NOT NULL DEFAULT \'\')\");\r\n$db->query_write(\"CREATE TABLE \" . TABLE_PREFIX . \"vBSponsors (id INT NOT NULL, sponsor_name VARCHAR(255) NOT NULL, forum TEXT NOT NULL, date TEXT NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM\");\r\n ', '\r\n$db->hide_errors();\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_enabled\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_banner_enabled\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_name\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_banner\");\r\n$db->query_write(\"ALTER TABLE \" . TABLE_PREFIX . \"forum DROP sponsor_url\");\r\n$db->query_write(\"DROP TABLE \" . TABLE_PREFIX . \"vBSponsors\");\r\n$db->show_errors();\r\n '); MySQL Error : Duplicate entry '16' for key 1 Error Number : 1062 |
#84
|
|||
|
|||
hey,
just to be completed: the import of the xml is working now, but there's still no sponsor shown in the index.php next to the forums. also i see the sql error when having a look at the stats. there doesn't seem to be a table "vbSponsors". |
#85
|
|||
|
|||
Quote:
i'm having the same problem. trying to work around it.. oncei manage to do so i will let you guys know.. |
#86
|
|||
|
|||
I'll check this out when I get home tonight. Please be sure to post your PHP & MySQL versions with your errors (just edit the posts you made). I've been developing this on MySQL 5.0.17 and PHP 5.1.1, so there's bound to be some differences.
The common issue is the missing table. Since this is a fresh install for most of you, please uninstall the product. Then try reinstalling. Let me know what the results are. |
#87
|
|||
|
|||
Quote:
PHP Version 4.4.1 mySQL 4.1.11 |
#88
|
||||
|
||||
Only if I can get the templates to add. Modifying them and when I click save.. it just sits there. I see the bar moving at the bottom as it is trying to save, but it never goes to the next screen.
It happens when I add it to the "forumhome_forumbit_level1_post" template. But when I remove that part of the code, it saves fine. |
#89
|
|||
|
|||
A new version has been released. 1.0.4. Please upgrade.
lifesourcerc, your template errors have been corrected. The included template code has been updated. Thanks for the patience. I rushed the 1.0.2 release thinking that this might happen. Hopefully this is the end of the bugs for now. :nervous: |
#90
|
|||
|
|||
Quote:
okay .. cool work.. bless.. it is showing now in the forum.. yepppy.. but when you click on the "Forum Sponsored By: XXXX" as text it give me this error.. Code:
Database error in vBulletin 3.5.2: Invalid SQL: INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'La7oon', '14', 'Arabic', '1137029793'); MySQL Error : Unknown column 'forum_id' in 'field list' Error Number : 1054 Date : Wednesday, January 11th 2006 @ 05:36:33 PM Script : http://www.dubaidjs.com/forums/vB.Sponsors/link.php?f=14 Referrer : http://www.dubaidjs.com/forums/index.php IP Address : xxxxxxxxxx Username : lawahdy Classname : vb_database Code:
Database error in vBulletin 3.5.2: Invalid SQL: SELECT COUNT(*) AS hits, FROM_UNIXTIME(date, '%m-%d-%Y') AS fdate FROM vBSponsors WHERE forum_id = '14' GROUP BY fdate; MySQL Error : Unknown column 'forum_id' in 'where clause' Error Number : 1054 Date : Wednesday, January 11th 2006 @ 05:34:59 PM Script : http://www.dubaidjs.com/forums/admincp/vBSponsors.php Referrer : http://www.dubaidjs.com/forums/admincp/vBSponsors.php?do=statistics IP Address : xxxxxxxxxxxxxxxxxxx Username : lawahdy Classname : vb_database |
#91
|
|||
|
|||
I have installed this and added a banner, the picture of the banner doesn't even show up and when I click on where the picture is supposed to be I get this
Quote:
Thanks |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|