vb.org Archive
Page 3 of 9 12 3 45 Last »
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)

kompakt 01-11-2006 04:09 AM
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 :)

kompakt 01-11-2006 04:36 AM
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

kommuni 01-11-2006 08:09 AM
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".

lawahdy 01-11-2006 11:19 AM
Quote:
Originally Posted by kommuni
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".

i'm having the same problem.

trying to work around it.. oncei manage to do so i will let you guys know..

Deviation 01-11-2006 11:33 AM
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.

lawahdy 01-11-2006 11:41 AM
Quote:
Originally Posted by Deviation
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.
i did a reinstall, uninstall - reinstall, complete remove of even template changes and files and reinstall... nothing.. same problems..

PHP Version 4.4.1
mySQL 4.1.11

lifesourcerec 01-11-2006 05:52 PM
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.

Deviation 01-11-2006 11:21 PM
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:

lawahdy 01-11-2006 11:38 PM
Quote:
Originally Posted by Deviation
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:

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
and in the statistics it gives me this error.
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
i'm i not lucky or what..?

Devil Woman 01-12-2006 07:11 AM
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:
Warning: main(/global.php): failed to open stream: No such file or directory in /home/content/d/a/r/darksidemedia/html/board/vB.Sponsors/link.php on line 29

Fatal error: main(): Failed opening required '/global.php' (include_path='.:/usr/local/lib/php') in /home/content/d/a/r/darksidemedia/html/board/vB.Sponsors/link.php on line 29
Am i doing anything wrong?

Thanks

Deviation 01-12-2006 11:19 AM
Quote:
Originally Posted by lawahdy
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..
Uninstall the product from the Admin CP and re-install. If this does not solve your issue, PM me and I will send you the manual uninstall (you will need access to phpMyAdmin or similar).

Quote:
Originally Posted by Devil Woman
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

Am i doing anything wrong?

Thanks
Double check your template code, the forum sponsor settings (in Forum Manager) and the vB.Sponsors settings (in vB.Sponsors Manager) to make sure banners are enabled. Also double check the URL you entered for the banner image.

From the error, I'd say the path you entered on line 27 of link.php is incorrect. There is a directory called do not upload. If you look in there you will find a file called settings-check.php. Upload this to the vB.Sponsors directory on your server. Access the file directly from a web browser (i.e. - http://www.yoursite.com/forum/vB.Spo...ngs-check.php). This will show you the correct path to enter on line 27.

NDRPrelude 01-12-2006 01:44 PM
Everything looks great, but I have ran into a small problem/bug:

When I click on the banner, instead of going to the url I entered in the adminCP, it appends the url to the end of the vb.sponsors directory on the server, which naturally returns a file not found error...

IE - "http://alabamaracingscene.net/forum/vB.Sponsors/www.summitracing.com"

Any ideas?

Deviation 01-12-2006 03:38 PM
Quote:
Originally Posted by NDRPrelude
Everything looks great, but I have ran into a small problem/bug:

When I click on the banner, instead of going to the url I entered in the adminCP, it appends the url to the end of the vb.sponsors directory on the server, which naturally returns a file not found error...

IE - "http://alabamaracingscene.net/forum/vB.Sponsors/www.summitracing.com"

Any ideas?
Double check your template code. That would be the most likely cause. Also, the URL for the sponsor should always begin with http://.

CSS59 01-13-2006 02:07 AM
subscribed

djmini 01-16-2006 08:10 PM
I've installed and it works GREAT with the Catagories...

But I can't get it to work on the forums.

I'll click install as soon as it works

THANKS!

Deviation 01-16-2006 11:22 PM
Quote:
Originally Posted by djmini
I've installed and it works GREAT with the Catagories...

But I can't get it to work on the forums.

I'll click install as soon as it works

THANKS!
Check your template code. The template code has been updated in 1.0.4.

JonnyQuest 01-17-2006 04:31 AM
Quote:
Originally Posted by Deviation
Check your template code. The template code has been updated in 1.0.4.
This is a great start. The ultimate addition to this pack which would make it a truly revolutionary addition is if you allow any registered user to purchase sponsorship of a given forum using the paid subscriptions functionality. A user could purchase a sponsorship for a given period of time, manage the banner and see their stats. Getting the timing part to function correctly would be challenging but this would be a dream (and worth paying for).

djmini 01-17-2006 06:03 AM
the template code... I just replaced the templates with the new ones...

Thanks!

Working now

::Clicks Install::

Deviation 01-17-2006 10:36 AM
Quote:
Originally Posted by djmini
the template code... I just replaced the templates with the new ones...

Thanks!

Working now

::Clicks Install::
Thought that might be it. glad its finally working for you.
Quote:
Originally Posted by JonnyQuest
This is a great start. The ultimate addition to this pack which would make it a truly revolutionary addition is if you allow any registered user to purchase sponsorship of a given forum using the paid subscriptions functionality. A user could purchase a sponsorship for a given period of time, manage the banner and see their stats. Getting the timing part to function correctly would be challenging but this would be a dream (and worth paying for).
Interesting ideas. I'll be keeping those in mind. ;)

There's a lot that I want to add to this. It's just a matter of getting the time to do so. This actually got a little bigger than what I thought it would. I originally did this out of neccessity for myself. :classic:

NDRPrelude 01-23-2006 03:28 AM
You were right on the http:// part. That fixed that problem. I am having another issue and I don't know what to do. I have two skins installed on the forum. I have three sponsor banners but they only show up on one skin. It's the skin I use and probably the skin it was on when I set up the banners. Black and Gold is my default skin. The banners won't show up on the default vb skin or on the brushed blue skin I have installed. Has anyone else had this problem?

VB Sponsors 1.0.4
CMPS v2.0.0 (vB 3.5.2)
Apache v2.0.51

Deviation 01-23-2006 10:07 AM
Quote:
Originally Posted by NDRPrelude
You were right on the http:// part. That fixed that problem. I am having another issue and I don't know what to do. I have two skins installed on the forum. I have three sponsor banners but they only show up on one skin. It's the skin I use and probably the skin it was on when I set up the banners. Black and Gold is my default skin. The banners won't show up on the default vb skin or on the brushed blue skin I have installed. Has anyone else had this problem?

VB Sponsors 1.0.4
CMPS v2.0.0 (vB 3.5.2)
Apache v2.0.51
That depends on the template you modified for vB.Sponsors. You need to modify each template for this to function. If you just edit the child style (assuming you are using child styles), only that child will see the changes.

NDRPrelude 01-23-2006 04:41 PM
Quote:
Originally Posted by Deviation
That depends on the template you modified for vB.Sponsors. You need to modify each template for this to function. If you just edit the child style (assuming you are using child styles), only that child will see the changes.

I see now. Everything is working great. Thanks for all of your help.

icare 01-31-2006 06:04 AM
PHP Code:
Warning: chdir(): No such file or directory (errno 2) in /home/horny/public_html/vB.Sponsors/link.php on line 27 

I am getting this message when i click the sponser banner. Can anybody please help me.

icare 01-31-2006 06:08 AM
PHP Code:
Warning: chdir(): No such file or directory (errno 2) in /home/horny/public_html/vB.Sponsors/link.php on line 27

Warning: main(./global.php): failed to open stream: No such file or directory in /home/horny/public_html/vB.Sponsors/link.php on line 29

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/horny/public_html/vB.Sponsors/link.php on line 29 

This the error I get. Please advise. Did I do something wrong whith the path in link.php fiel. My forum is in root directry. Please help me with this erorr.

thanks

Deviation 01-31-2006 07:35 PM
Quote:
Originally Posted by icare
PHP Code:
Warning: chdir(): No such file or directory (errno 2) in /home/horny/public_html/vB.Sponsors/link.php on line 27 
This the error I get. Please advise. Did I do something wrong whith the path in link.php fiel. My forum is in root directry. Please help me with this erorr.

thanks
The path you entered on line 27 in link.php isn't valid. Either:
a)Double check the path for typos
b)Upload the settings-check.php file from the "do not upload" directory to the "vB.Sponsors" directory. This file will tell you the path you should enter. Remove this file when you are done.

icare 02-01-2006 06:36 AM
PHP Code:
Warning: 
Warning: chdir(): No such file or directory (errno 2) in /home/horny/public_html/vBSponsors/link.php on line 27

Warning: main(./global.php): failed to open stream: No such file or directory in /home/horny/public_html/vBSponsors/link.php on line 29

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/horny/public_html/vBSponsors/link.php on line 29 
Please help I am getting this error.

I tried everything. My path in link.php is correct. I even tried changng the folder name from
Vb.sponsors to vbsponsers but didnt work

Deviation 02-01-2006 06:24 PM
Quote:
Originally Posted by icare
PHP Code:
Warning: 
Warning: chdir(): No such file or directory (errno 2) in /home/horny/public_html/vBSponsors/link.php on line 27

Warning: main(./global.php): failed to open stream: No such file or directory in /home/horny/public_html/vBSponsors/link.php on line 29

Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/horny/public_html/vBSponsors/link.php on line 29 
Please help I am getting this error.

I tried everything. My path in link.php is correct. I even tried changng the folder name from
Vb.sponsors to vbsponsers but didnt work
This HAS to be a path issue. PM me your link.php file and a screenshot of the output from the settings-check.php file and I'll look it over for you.

Hornstar 02-04-2006 10:27 PM
Everything has gone good except for when i click on the sponsor banner or sponsor link then i get this database error

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO `vb3_vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Rapid GfX', '153', 'GfX', '1139099113');

MySQL Error  : Unknown column 'forum_id' in 'field list'
Error Number : 1054
Date        : Saturday, February 4th 2006 @ 06:25:13 PM
Script      : http://www.gamerzneeds.net/forums/vB.Sponsors/link.php?f=153
Referrer    : http://www.gamerzneeds.net/forums/index.php
IP Address  :
Username    : Hornstar6969
Classname    : vb_databaseDatabase error in vBulletin 3.5.3:
I have now fixed this by uninstalling the product then installing it again. I think this error is happening when people upgrade the product you need to uninstall it first before installing it again for some reason.

But everything seems to be working right now.

Thanks for this great hack.

djmini 02-15-2006 09:45 AM
is there a way to change, per forum, the "Forum Sponsored By:" to anything else?


By the way,

I create banners for my sponsors to fit ...

See how I use this HERE . I don't have many sponsors but have only just begun offering it.

Deviation 02-15-2006 12:44 PM
Quote:
Originally Posted by djmini
is there a way to change, per forum, the "Forum Sponsored By:" to anything else?

By the way,

I create banners for my sponsors to fit ...

See how I use this HERE . I don't have many sponsors but have only just begun offering it.
There's no way to change the text per forum. You can change it overall by editing the phrases. I'll add this idea to the feature requests list.

Nice work on the banners and the placement. :)

CupraSi 02-15-2006 04:45 PM
I would love to do this as I need it on my site as I have companies asking about these types of banners

Would anyone be able to help me add this please?

Cheers

Deviation 02-15-2006 04:47 PM
Quote:
Originally Posted by CupraSi
I would love to do this as I need it on my site as I have companies asking about these types of banners

Would anyone be able to help me add this please?

Cheers
It's a fairly simple install. Download the zip and take a look at the readme. If you get hung up somewhere, feel free to ask here.

CupraSi 02-15-2006 04:48 PM
I had a look mate I am not a webmaster, I have managed to do my first plugins today and change some code but thats it :(

designBox 02-16-2006 06:04 PM
Thank you very much for this useful hack.
I was just looking for something like this.

Anyway, i still have 2 comments:
1)- I am getting an "Unknown Location /vB.Sponsors/link.php?f=4" into the WOL interface.
2)- Will it be possible to integrate into the user control panel the stats of its link when the sponsor is registered member ?

I am aslo impatiently waiting the ability to have the sponsor link at the top of each sponsored thread.

Thanks again for this awesome contribution.
INSTALL Clicked.

Deviation 02-16-2006 07:50 PM
Quote:
Originally Posted by designBox
Thank you very much for this useful hack.
I was just looking for something like this.
Thanks. Glad you like it. :)
Quote:
Anyway, i still have 2 comments:
1)- I am getting an "Unknown Location /vB.Sponsors/link.php?f=4" into the WOL interface.
WOL interface? Can you post a screenshot?
Quote:
2)- Will it be possible to integrate into the user control panel the stats of its link when the sponsor is registered member ?
That's a good idea. There was a suggestion to have the sponsors able to view their own stats. Adding to the User CP is a great idea. (adding to the list)
Quote:
I am aslo impatiently waiting the ability to have the sponsor link at the top of each sponsored thread.

Thanks again for this awesome contribution.
INSTALL Clicked.
Patience grasshopper. ;) I've slowed down the development on this as I have to tend to some other things in life. I'll be resuming soon enough though.:D

Mu5icMan 02-17-2006 10:13 AM
When adding a banner to a category the banner and wording is justified to the left and looks out of place. If you change the justification to centre or right the category name moves aswel. How can i put the sponser banner in it's own table?

Deviation 02-17-2006 10:26 AM
Quote:
Originally Posted by Mu5icMan
When adding a banner to a category the banner and wording is justified to the left and looks out of place. If you change the justification to centre or right the category name moves aswel. How can i put the sponser banner in it's own table?
You would just need to play with the templates. Check out djmini's site a couple posts up. You can really add the banners anywhere you like. Just be sure to use the <if> conditions within your html code. I'd suggest making a copy of your style and playing with that.

designBox 02-17-2006 07:55 PM
Quote:
Originally Posted by Deviation
Thanks. Glad you like it. :)

WOL interface? Can you post a screenshot?

That's a good idea. There was a suggestion to have the sponsors able to view their own stats. Adding to the User CP is a great idea. (adding to the list)

Patience grasshopper. ;) I've slowed down the development on this as I have to tend to some other things in life. I'll be resuming soon enough though.:D
I attached a screenshot here.

i also tried to insert in ma FORUMDISPLAY Template the following code but it seems that your variables are not global as nothing appears.

I know you also have a real life and of course i respect this (we have all one ;) ) but i tried my luck without chance to get a bit advanced on your future release.... :ninja:

designBox 02-18-2006 08:41 AM
Sorry for the double post but this is concerning another error.
It came to my attention that if the forum name had a ' in its name then vbSponsor is generating an error when clicking to the sponsor's link.

I pasted here this error:
Code:
Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Your link here', '97', 'Programmer's Alley', '1140258987');

MySQL Error  : 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 's Alley', '1140258987')' at line 1
Error Number : 1064
Date                : Saturday, February 18th 2006 @ 11:36:27 AM
Script          : http://www.hostnode.com/vB.Sponsors/link.php?f=97
Referrer        : http://www.hostnode.com/forum.php
IP Address  : XXXXXXXXXXXXX
Username        : XXXXXXXXXXXXX
Classname        : vb_database
I changed the name of the forum, but i reported this error at it may help some others.

Deviation 02-18-2006 11:32 AM
Quote:
Originally Posted by designBox
Sorry for the double post but this is concerning another error.
It came to my attention that if the forum name had a ' in its name then vbSponsor is generating an error when clicking to the sponsor's link.

I changed the name of the forum, but i reported this error at it may help some others.
Good catch! I'll get that fixed up in the next release. Thanks.


All times are GMT. The time now is 06:12 PM.
Page 3 of 9 12 3 45 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01711 seconds
  • Memory Usage 1,899KB
  • 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
  • (5)bbcode_code_printable
  • (5)bbcode_php_printable
  • (24)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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