vb.org Archive

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)

djmini 12-29-2005 03:18 AM

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

Quote:

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 12-29-2005 10:54 AM

Quote:

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 12-29-2005 06:01 PM

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 12-29-2005 09:33 PM

Quote:

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 12-29-2005 10:37 PM

Quote:

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:
Code:

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:
Code:

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 12-30-2005 01:40 AM

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 12-30-2005 11:07 AM

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 12-30-2005 04:45 PM

Awesome, that worked fine.

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

Thank You!

djmini 12-30-2005 04:49 PM

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 12-30-2005 05:27 PM

Quote:

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).

djmini 12-30-2005 07:55 PM

hmmm

It's still not working for me.

===
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
===

Am I getting closer or further?

TundraSoul 12-30-2005 10:55 PM

Here's a small suggestion. Update it so we can place an adsense java code in there, instead of a url image and url link.

Thanks!

Deviation 12-31-2005 12:56 AM

Quote:

Originally Posted by djmini
hmmm

It's still not working for me.

===
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
===

Am I getting closer or further?

Check line 27 in link.php again. Looks like its incorrect. From that error it looks like it should be:
Code:

/var/www/html/forum/
Quote:

Originally Posted by TundraSoul
Here's a small suggestion. Update it so we can place an adsense java code in there, instead of a url image and url link.

Thanks!

Excellent suggestion. Added to the list. :squareeyed:

djmini 12-31-2005 06:14 PM

So it should be

/var/www/html/forum/

no other variation?

I have it set at

/var/www/html/forum/vB.Sponsors

AndyA 12-31-2005 07:15 PM

Great extension, will this work with vb 3.5.0 ?

Deviation 01-01-2006 03:30 PM

Quote:

Originally Posted by djmini
So it should be

/var/www/html/forum/

no other variation?

I have it set at

/var/www/html/forum/vB.Sponsors

It should be:
/var/www/html/forum/

Quote:

Originally Posted by AndyA
Great extension, will this work with vb 3.5.0 ?

It should. I started this on 3.5.0. I've just upgraded since then. ;)

PennylessZ28 01-01-2006 05:22 PM

Clicks Install

blitzburgh 01-01-2006 07:58 PM

Is there a way to change the Sponsor By text to Affiliated with?

Thanks

I found it under Phrases thanks.

Deviation 01-09-2006 12:05 AM

Check the first post for details. The most notable addition is the ability to view the stats in the Admin CP.

Looking forward to the feedback. :glasses:

lawahdy 01-09-2006 12:34 AM

i'm facing a problem..

when i go to activate global vB.Sponsors settings.. i set both options to yes.. click save.. tells me it saved.. then redirects me to the main page.. and nothing is saved.. the two radio buttons are set to NO??!! what is going on.. where did i go wrong this time.?

Ten94Tuner 01-09-2006 04:08 AM

does this work for 3.5.1 ?

Hornstar 01-09-2006 07:14 AM

yes it will work for all of vb 3.5.x correct me if im wrong anyone, but i've been using this through all the updates and works fine.

Deviation 01-09-2006 08:46 PM

Quote:

Originally Posted by lawahdy
i'm facing a problem..

when i go to activate global vB.Sponsors settings.. i set both options to yes.. click save.. tells me it saved.. then redirects me to the main page.. and nothing is saved.. the two radio buttons are set to NO??!! what is going on.. where did i go wrong this time.?

Interesting. Did you do an upgrade or fresh install (wasn't sure if you had the older version installed)? If its an upgrade, make sure you choose "Allow Overwrite" in the Import Product area. Did you receive any errors installing this?

Anyone else experiencing this?

Quote:

Originally Posted by hornstar1337
yes it will work for all of vb 3.5.x correct me if im wrong anyone, but i've been using this through all the updates and works fine.

You are correct. :classic:

tcs 01-09-2006 10:20 PM

Quote:

Originally Posted by Deviation
Interesting. Did you do an upgrade or fresh install (wasn't sure if you had the older version installed)? If its an upgrade, make sure you choose "Allow Overwrite" in the Import Product area. Did you receive any errors installing this?

Anyone else experiencing this?


You are correct. :classic:

I am having this problem. I have not looked at why it is doing it yet.

I upgraded from the last version. I have also tried un-install and re-install of both versions.

Is the installer suppose to make some custom templates?

lawahdy 01-10-2006 12:32 AM

Quote:

Originally Posted by tcs
I am having this problem. I have not looked at why it is doing it yet.

I upgraded from the last version. I have also tried un-install and re-install of both versions.

Is the installer suppose to make some custom templates?

for you it is an upgrade.. and for me it is a fresh install.. didn't know about this from before...

don't know why is it happening.. but everything went smooth while installing.. no errors .. no nothing..

:surprised:

tcs 01-10-2006 01:27 AM

Thanks, It is an awesome hack. Going to be one of my favorites. The issue is it is not installing all the DB stuff. (I think) Still have not had anytime to look at it deep.

Deviation 01-10-2006 01:38 AM

The issue should be resolved now. An oversight on my part. (yes tcs, I missed some db inserts

Download the latest zip in the first post.....

kommuni 01-10-2006 09:37 AM

Quote:

Originally Posted by Deviation
The issue should be resolved now. An oversight on my part. (yes tcs, I missed some db inserts

Download the latest zip in the first post.....

Quote:

Download the latest zip in the first post.....
and do what? :)

Reupload files? reinstall XML?

Same problem here...

EDIT: Would be good to upgrade to a newer version on fixes... makes it a bit easier for me to find out if something really got updated and what (eventually got fixed). Thanks

EDIT: did the full update (upload and reimport xml) but that didn't fix that bug with enabling vb.Sponsors. After enabling they are still disabled.

Deviation 01-10-2006 11:10 AM

Quote:

Originally Posted by kommuni
and do what? :)

Reupload files? reinstall XML?

Same problem here...

EDIT: Would be good to upgrade to a newer version on fixes... makes it a bit easier for me to find out if something really got updated and what (eventually got fixed). Thanks

EDIT: did the full update (upload and reimport xml) but that didn't fix that bug with enabling vb.Sponsors. After enabling they are still disabled.

Re-upload. Reinstall the XML making sure your choose "Allow Overwrite". It's been incremented to 1.0.3 (just did that this morning; I was a little tired last night). The XML has changed, so be sure to grab the latest zip.

As of last night, this was working for me. Tonight I'll be doing a fresh install of vBulletin 3.5.3 to remove any changes I may have made in my testing.

kommuni 01-10-2006 12:29 PM

Quote:

Originally Posted by Deviation
Re-upload. Reinstall the XML making sure your choose "Allow Overwrite". It's been incremented to 1.0.3 (just did that this morning; I was a little tired last night). The XML has changed, so be sure to grab the latest zip.

As of last night, this was working for me. Tonight I'll be doing a fresh install of vBulletin 3.5.3 to remove any changes I may have made in my testing.

seem's like you're still a bit tired :)

now i get a parse error with the actual included product-xml. and yes i'm sure i already used overwrite when reimporting the one wich was online a few hours ago.

Sorry i can't paste the parse error from the import - it redirects me back too fast.

gibhut 01-10-2006 12:40 PM

Parse error: parse error, unexpected ';' in admincp\plugin.php(1228) : eval()'d code on line 3

there ya go

kommuni 01-10-2006 01:44 PM

Quote:

Originally Posted by gibhut
Parse error: parse error, unexpected ';' in admincp\plugin.php(1228) : eval()'d code on line 3


there ya go

thanks - you must be younger or even faster than me :D

gibhut 01-10-2006 02:19 PM

33 and not faster . just bored heh (and had the error saved to ask the same question)

fonzie11 01-10-2006 03:16 PM

im kinda new 2 alll this stuff, i downloaded ur thing
but online 27 wat do i write in?
i have not a clue in the world, im such a noobie lol

//modify this to reflect the path to your forums
chdir('/your/path/forum/');

i change that 2 wat?
my website url is www.pbontario.com/forums
...

kommuni 01-10-2006 03:56 PM

Quote:

//modify this to reflect the path to your forums
chdir('/your/path/forum/');

i change that 2 wat?
my website url is www.pbontario.com/forums
the path to your forums on the server

probably /home/pages/customer/fonzie/... anything like that...

fonzie11 01-10-2006 06:42 PM

like my ftp?
where my forums are
cuz this is what i use 2 get 2 my upload server and the forums page
ftp://pbontario.com/forums/

then my username is joedono (2 access the ftp)

Deviation 01-10-2006 09:24 PM

Quote:

Originally Posted by gibhut
Parse error: parse error, unexpected ';' in admincp\plugin.php(1228) : eval()'d code on line 3


there ya go

This is during the install right? You uploaded all the files from the latest zip right? Just asking the easy questions... ;)

Quote:

Originally Posted by fonzie11
im kinda new 2 alll this stuff, i downloaded ur thing
but online 27 wat do i write in?
i have not a clue in the world, im such a noobie lol

//modify this to reflect the path to your forums
chdir('/your/path/forum/');

i change that 2 wat?
my website url is www.pbontario.com/forums
...

The file, settings-check.php, in the do not upload directory can find this path for you. Upload it to the vB.Sponsors directory on your web server and access it directly (i.e. - http://www.pbontario.com/forums/vB.S...ings-check.php). DELETE this file after you're done.

Skaterscafe.com 01-11-2006 12:15 AM

Quote:

Originally Posted by gibhut
Parse error: parse error, unexpected ';' in admincp\plugin.php(1228) : eval()'d code on line 3

I'm getting the same error when installing. Any ideas what is wrong? I just downloaded and installed so I assume it is the new one.

Deviation 01-11-2006 01:33 AM

New release..... yet again :nervous:

Download the new zip. Install choosing "Allow Overwrite". I didn't increment the version on this one.

lawahdy 01-11-2006 01:54 AM

Quote:

Originally Posted by Deviation
New release..... yet again :nervous:

Download the new zip. Install choosing "Allow Overwrite". I didn't increment the version on this one.

am i not lucky or what..

new errors.. (besides the fact that the "sponsored by XXX"not showing on my froum..)

when i click on view stats.. it give 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  : Table 'XXXX.vbsponsors' doesn't exist
Error Number : 1146
Date        : Tuesday, January 10th 2006 @ 07:50:35 PM
Script      : http://www.dubaidjs.com/forums/admincp/vBSponsors.php
Referrer    : http://www.dubaidjs.com/forums/admincp/vBSponsors.php?do=statistics
IP Address  :
Username    : lawahdy
Classname    : vb_database

shouldn't the tables be withen the xml files..?


All times are GMT. The time now is 10:06 PM.

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.01642 seconds
  • Memory Usage 1,852KB
  • 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
  • (4)bbcode_code_printable
  • (23)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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