vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Add-On Releases - vbuserbar for 3.6.x (https://vborg.vbsupport.ru/showthread.php?t=132629)

imported_predatorkill 11-28-2006 07:24 PM

The update was done in less than a minute...Great job stony,again!!:cool: :cool:

Roxie 11-28-2006 09:02 PM

I get this error even using the newest version:

Quote:


Invalid SQL:

CREATE TABLE vb3_`vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) NOT NULL ,
`usergroupid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`createdate` INT( 10 ) NOT NULL ,
`modifieddate` INT( 10 ) NOT NULL ,
`groupid` INT( 10 ) NOT NULL ,
INDEX ( `userid` , `usergroupid`, `name`)
) TYPE = MYISAM;

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 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1
Error Number : 1064
Date : Tuesday, November 28th 2006 @ 05:59:50 PM
Script : http://.......com/admincp/plugin.php?do=productimport
Referrer : http://....../admincp/plugin.php?do=productadd
IP Address : ....
Username : ....
Classname : vb_database

sduckie2k5 11-28-2006 09:45 PM

Same thing here, new version, first time install. Heres mine....

Invalid SQL:

CREATE TABLE vb_`vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) NOT NULL ,
`usergroupid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`createdate` INT( 10 ) NOT NULL ,
`modifieddate` INT( 10 ) NOT NULL ,
`groupid` INT( 10 ) NOT NULL ,
INDEX ( `userid` , `usergroupid`, `name`)
) TYPE = MYISAM;

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 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1
Error Number : 1064
Date : Tuesday, November 28th 2006 @ 06:46:32 PM
Script : ..........plugin.php?do=productimport
Referrer :
IP Address : .......
Username : .......
Classname : vb_database

Would love to know what is wrong, or what Im doing wrong so I can get it to work. Yes I have GD2. Thanks

JD45 11-29-2006 06:38 AM

Quote:

Originally Posted by sduckie2k5 (Post 1127601)
Same thing here, new version, first time install. Heres mine....




Invalid SQL:

CREATE TABLE vb_`vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT( 10 ) NOT NULL ,
`usergroupid` INT( 10 ) NOT NULL ,
`name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`url` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`createdate` INT( 10 ) NOT NULL ,
`modifieddate` INT( 10 ) NOT NULL ,
`groupid` INT( 10 ) NOT NULL ,
INDEX ( `userid` , `usergroupid`, `name`)
) TYPE = MYISAM;

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 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1
Error Number : 1064
Date : Tuesday, November 28th 2006 @ 06:46:32 PM
Script : ..........plugin.php?do=productimport
Referrer :
IP Address : .......
Username : .......
Classname : vb_database


Would love to know what is wrong, or what Im doing wrong so I can get it to work. Yes I have GD2. Thanks

Thritto on the error...

stonyarc 11-29-2006 08:17 AM

Quote:

Originally Posted by Roxie (Post 1127576)
I get this error even using the newest version:

Sorry

It was the old SQL statement typo that got back in.

The version now online is correct and should handle prefix nicely

sduckie2k5 11-29-2006 12:14 PM

Quote:

Originally Posted by stonyarc (Post 1127916)
Sorry

It was the old SQL statement typo that got back in.

The version now online is correct and should handle prefix nicely


Thankyou, that worked, Great addition to my website! ~D

Roxie 11-29-2006 02:52 PM

Works beautifully. Great work Stonyarc. :)

JD45 11-29-2006 02:59 PM

Hmm...I'm still getting this:

Quote:

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 'vbuserbar` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`userid` INT' at line 1

stonyarc 11-29-2006 03:15 PM

Quote:

Originally Posted by JD45 (Post 1128116)
Hmm...I'm still getting this:

JD did you download the latest version again?

The sequence you quoted is no longer in there.

JD45 11-29-2006 03:17 PM

Quote:

Originally Posted by stonyarc (Post 1128124)
JD did you download the latest version again?

The sequence you quoted is no longer in there.

I thought I did :surprised:

I did the sql by hand and everything installed fine, now I just need to test everything. I'll re-download it and make sure I have the updated version.

Ramsesx 11-29-2006 04:32 PM

Thanks for this cool hack.
It would be nice if there could be access only for special usergroups.

stonyarc 11-29-2006 05:53 PM

Quote:

Originally Posted by Ramsesx (Post 1128153)
Thanks for this cool hack.
It would be nice if there could be access only for special usergroups.


Ramsesx,

This will be included in the next major version.

JD45 11-29-2006 06:06 PM

Quote:

Originally Posted by JD45 (Post 1128125)
I thought I did :surprised:

I did the sql by hand and everything installed fine, now I just need to test everything. I'll re-download it and make sure I have the updated version.

Alrighty, the hack is working however, I don't see a preview and no user bar is seen when making/saving one.

I checked the host and I made sure GD2 is installed.

Rian 11-29-2006 06:31 PM

Quote:

Originally Posted by JD45 (Post 1128202)
Alrighty, the hack is working however, I don't see a preview and no user bar is seen when making/saving one.

I checked the host and I made sure GD2 is installed.

Hey guys, I had the very same problem:

1. The base image did not show
2. Once saved, the image also did not show.

---------------------------------------------------------------

I fixed the script by doing the following:

Step 1: Fixing the base image to show

1. Open the uploadImage.php (in folder userbar/designer/actions) file in a text editor. Look for:

$path = '../images/content/'.$_GET['id'].'.png?=wtf'.mt_rand(1,1337);

Change this to:

$path = 'userbar/images/content/'.$_GET['id'].'.png?=wtf'.mt_rand(1,1337);

Upload to userbar/designer/actions and overwrite the original file. You will now see the base image.

Step 2: Fixing the saved image to show

1. FTP into your website root and go to your Userbar folder.

2. Create a new folder called 'show' - show

3. Chmod this folder to 777.

Your script will now work.

Trana 11-29-2006 07:43 PM

Has anyone gotten this to work on Windows 2003 server with ISAPI URL Rewrite instead of mod_rewrite?

MrPHD 11-30-2006 10:49 AM

I canĀ“t make this work, i create a image but not display, why is that? Please help

stonyarc 11-30-2006 11:44 AM

Quote:

Originally Posted by Rian (Post 1128212)
Hey guys, I had the very same problem:

1. The base image did not show
2. Once saved, the image also did not show.

---------------------------------------------------------------

I fixed the script by doing the following:

Step 1: Fixing the base image to show

1. Open the uploadImage.php (in folder userbar/designer/actions) file in a text editor. Look for:

$path = '../images/content/'.$_GET['id'].'.png?=wtf'.mt_rand(1,1337);

Change this to:

$path = 'userbar/images/content/'.$_GET['id'].'.png?=wtf'.mt_rand(1,1337);

Upload to userbar/designer/actions and overwrite the original file. You will now see the base image.

Step 2: Fixing the saved image to show

1. FTP into your website root and go to your Userbar folder.

2. Create a new folder called 'show' - show

3. Chmod this folder to 777.

Your script will now work.

I included a corrected uploadImage.php in the zip currently online.

The show is handled by the .htaccess in the /userbar root. So if modrewrite is working correctly it should be fine.

stonyarc 11-30-2006 07:41 PM

Is this working fine now for all of you?

Roxie 11-30-2006 07:57 PM

Works fine for me.

Tyegurl 11-30-2006 09:19 PM

lol i redownloaded it and the files are in the right spot....they weren't like that before...probably what i used to unzip it....sorry for the problem...imported product fine this time...will let you know about the rest ASAP thanks stonyarc!

Tyegurl 11-30-2006 09:47 PM

nope added

RewriteEngine on

to my php.ini

but i see i have 2 files that did not transfer and will not transfer...pureftp files...do i need them?

rweber93 11-30-2006 10:39 PM

Any way to add the link for this to the Quick Links list? Thanks!

Roxie 11-30-2006 11:03 PM

One thing..the random user info isn't working (at least not on this end).

Trana 12-01-2006 01:25 AM

Quote:

Originally Posted by stonyarc (Post 1128926)
Is this working fine now for all of you?

No, it is still not working for me.

I'd like to request that you give us the option to turn off rewrites in the admincp. I worked with Oleg at VBSeo for a few hours and the ISAPI rewrites are correct, but the files still don't seem to show up. From looking at my httpd.ini it is obvious that it is configured for the rewrites properly.

So if we can manually turn off rewrites, and just use the image name (which currently appears to be a random number) we can at least get some functionality out of this script. I'm not sure what the rewrites buy aside from a slightly nicer SEO design.

Please let us know if this option can be worked into the next release.

Thanks!

Terminatoronly 12-01-2006 04:58 AM

very nice hack

stonyarc 12-01-2006 12:29 PM

Quote:

Originally Posted by Trana (Post 1129118)
No, it is still not working for me.

I'd like to request that you give us the option to turn off rewrites in the admincp. I worked with Oleg at VBSeo for a few hours and the ISAPI rewrites are correct, but the files still don't seem to show up. From looking at my httpd.ini it is obvious that it is configured for the rewrites properly.

So if we can manually turn off rewrites, and just use the image name (which currently appears to be a random number) we can at least get some functionality out of this script. I'm not sure what the rewrites buy aside from a slightly nicer SEO design.

Please let us know if this option can be worked into the next release.

Thanks!

I'll make something workable.

stonyarc 12-01-2006 12:29 PM

Quote:

Originally Posted by Roxie (Post 1129057)
One thing..the random user info isn't working (at least not on this end).

Did you upload the spy.php in the plugin folder?

stonyarc 12-01-2006 12:30 PM

Quote:

Originally Posted by Tyegurl (Post 1129020)
nope added

RewriteEngine on

to my php.ini

but i see i have 2 files that did not transfer and will not transfer...pureftp files...do i need them?

Tye,

Seems like you still have the old version.

Please download again. Those FTP related files should have been gone.

stonyarc 12-01-2006 12:31 PM

Quote:

Originally Posted by Terminatoronly (Post 1129213)
very nice hack


If you installed it please click install!!

Roxie 12-01-2006 01:51 PM

Quote:

Originally Posted by rweber93 (Post 1129041)
Any way to add the link for this to the Quick Links list? Thanks!

I added this to my quick links:

Quote:

<tr><td class="vbmenu_option"><a href="vbuserbar.php">$vbphrase[vbuserbar]</a></td></tr>

Roxie 12-01-2006 01:53 PM

Quote:

Originally Posted by stonyarc (Post 1129382)
Did you upload the spy.php in the plugin folder?

Yes I did. It spits out no image when this option is selected. Not that important as none of my users have requested it.

MrPHD 12-01-2006 09:03 PM

Quote:

Originally Posted by stonyarc (Post 1128926)
Is this working fine now for all of you?

whit me NO the images or userbar not appear i don?t know why.Regards

NOTE: I do it everything all right.:surprised:

ninjamaster 12-01-2006 11:08 PM

thanks nice work

Tyegurl 12-01-2006 11:28 PM

okay 2 questions...i have rereredownloaded the file and uploaded it again. i have also found that the pureftp file is still there lmao i think it must just be me lol and also am i supposed to be uploading the uploadimage.php file?

stonyarc it still doesn't work...what the heck am i doing wrong???????????

okay i noticed even though i created a folder named show and chmodded it....it saves my bars to the bars folder....but anyway even if i move them it still won't show them....

Steelersfan 12-02-2006 01:13 AM

Those FTP files were there when I downloaded this the other day. I just didn't upload them. Other than that it works great for me.

FireFish 12-02-2006 04:17 AM

Okay, I uploaded everything; got it working to the extent that I even see the preview, however, when I save the image & it redirects me to the page w/ the code snippet to use to display it, the image was never saved.

If I browse to the location of where the code states, I get a file not found error.

I chmodded every folder you needed to 777,
what can I possibly be doing wrong? running 3.6.4

stonyarc 12-02-2006 10:34 AM

Quote:

Originally Posted by FireFish (Post 1129815)
Okay, I uploaded everything; got it working to the extent that I even see the preview, however, when I save the image & it redirects me to the page w/ the code snippet to use to display it, the image was never saved.

If I browse to the location of where the code states, I get a file not found error.

I chmodded every folder you needed to 777,
what can I possibly be doing wrong? running 3.6.4

did you check if the file is in the cache folder?

The show folder should contain all configuration files of the individual bars.

Is modrewrite active?


It's important that the following directories exist and are chmod 777

Set the file permissions on the following directories file to 777 (chmod 777)

/bars/
/bars/groups/
/cache/
/cache/groups/
/images/content/
/designer/actions/templates_c/

Tyegurl 12-02-2006 03:44 PM

i double checked and mine exist and are chmodded....i don't think i will be able to use this :(

stonyarc 12-02-2006 05:21 PM

Quote:

Originally Posted by Tyegurl (Post 1130077)
i double checked and mine exist and are chmodded....i don't think i will be able to use this :(


Are you sure the directories are in the right place
I can create one but not save it on your site.


/bars/
/bars/groups/
/cache/
/cache/groups/
/images/content/
/designer/actions/templates_c/

must be subdirs in the userbar.

Did you check the modrewrite?

Tyegurl 12-02-2006 06:06 PM

positive....everything is where it should be and all are chmodded, i can save them they just end up in the bars folder


All times are GMT. The time now is 01:04 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.02045 seconds
  • Memory Usage 1,840KB
  • 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
  • (22)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