vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBgarage (https://vborg.vbsupport.ru/forumdisplay.php?f=104)
-   -   Multiple Cars/Garages for vBGarage (https://vborg.vbsupport.ru/showthread.php?t=75014)

noppid 01-24-2005 04:42 PM

Multiple Cars/Garages for vBGarage
 
I wrote some code today. I'm using some code snippets and the basic logic that magnus sent me. I believe the author was Action-N and magnus. Thanks again to both of them for sharing. We needed some logic, code, and templates to do this addition and again they cheerfully provided them.

vBGarage public release will be an adaptation using the above logic, some edited code, and some edited templates. If you have seen those branchs of the code, you may see some similarities and some differences in the adaptation.

You can see what I have so far at my Computer Rigs Forum. I have two garages set up to view. I really need a few testers to register and login to test using the garage to provide feedback on addition work.

There are database changes, template changes, template additions, and an updated vbgarage.php so far. URL's are also affected by including/passing addition variables.

Comments are needed in this thread, please give us your two sense and we'll see where the chips fall.

Here's the list of changes so far...
Quote:

// New vbgarage.php

// New vB file edits
Who's online instructions will be included

// Database changes

Table: vbgarage_comments
added field `vbgarageid`
added index on field `vbgarageid`

Table: vbgarage_users
dropped Primary Index on field `userid`
added field `garageid` int(10) unsigned NOT NULL auto_increment,
added index PRIMARY KEY (`garageid`),
added index KEY `userid` (`userid`)

Table: vbgarage_images
added field `id` smallint(6) unsigned NOT NULL default '0',
added index KEY `id` (`id`),
added index KEY `userid` (`userid`)

// templates changed

vbgarage_editgarage
vbgarage_editimagebits
vbgarage_imagebits
vbgarage_latestbits
vbgarage_listbits
vbgarage_viewgarage
vbgarage_commentbits
vbgarage_listgarage
vbgarage_popup

// template additions

vbgarage_editparkedbits
vbgarage_parkedbits
vbgarage_parkedlist
vbgarage_randombits
vbgarage_inactive_warning
vbgarage_error

//new settings
vbgwysiwyg
grouptitle = vbgarage
value = 1
default = 1
optioncode = yesno
displayorder = 60
advanced = 0
volatile = 0

// new phrases
Globals
vbgarage_alert_off = The Garage is Currently Turned OFF!!! Only Admins can see the Garage!
vbgarage_parked_cars = Car List
vbgarage_gallery = Photo Gallery
vbgarage_add_edit = (Add/Edit your Car)

Setting Phrases
setting_vbgwysiwyg_desc = Use the WYSIWYG Editor?
setting_vbgwysiwyg_title = Editor Options

// images
Two new images
forums/images/misc/deletegarage.gif
forums/images/misc/editgarage.gif
Thanks for your time.

cinq 01-24-2005 11:32 PM

Here's what I am using for mine ( well not exactly, i changed it quite a bit, but this should present the gist of the table structures. )

Code:

#
# Table structure for table `vbgarage_comments`
#

CREATE TABLE `vbgarage_comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `garageid` int(10) unsigned NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `pagetext` text NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `vbgarage_images`
#

CREATE TABLE `vbgarage_images` (
  `imageid` int(10) unsigned NOT NULL auto_increment,
  `garageid` int(10) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `data` longblob NOT NULL,
  `type` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`imageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `vbgarage_ratings`
#

CREATE TABLE `vbgarage_ratings` (
  `rateid` int(10) NOT NULL auto_increment,
  `garageid` int(10) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `rating` int(10) NOT NULL default '0',
  PRIMARY KEY  (`rateid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `vbgarage_users`
#

CREATE TABLE `vbgarage_users` (
  `garageid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `text` text,
  `lastactivity` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`garageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;


noppid 01-24-2005 11:54 PM

Quote:

Originally Posted by cinq
Here's what I am using for mine ( well not exactly, i changed it quite a bit, but this should present the gist of the table structures. )


Appreciate it, but I'm done. The list above reflects what I did, not intened to do. ;)

In case you're interested, here's what the tables look like...

PHP Code:

CREATE TABLE `vbgarage_users` (
 `
useridint(10unsigned NOT NULL default '0',
 `
yearvarchar(50NOT NULL default '',
 `
makevarchar(50NOT NULL default '',
 `
modelvarchar(50NOT NULL default '',
 `
textmediumtext NOT NULL,
 `
lastactivityint(10unsigned NOT NULL default '0',
 `
garageidint(10unsigned NOT NULL auto_increment,
 
PRIMARY KEY  (`garageid`),
 
KEY `userid` (`userid`)
TYPE=MyISAM



CREATE TABLE 
`vbgarage_images` (
 `
vbgarageidsmallint(6unsigned NOT NULL auto_increment,
 `
useridint(10unsigned NOT NULL default '0',
 `
idsmallint(6unsigned NOT NULL default '0',
 `
namevarchar(50NOT NULL default '',
 `
datalongblob NOT NULL,
 `
typevarchar(50NOT NULL default '',
 `
thumblongblob NOT NULL,
 
PRIMARY KEY  (`vbgarageid`),
 
KEY `id` (`id`),
 
KEY `userid` (`userid`)
TYPE=MyISAM

CREATE TABLE 
`vbgarage_comments` (
 `
idint(10unsigned NOT NULL auto_increment,
 `
vbgarageidint(10unsigned NOT NULL default '0',
 `
usernamevarchar(50NOT NULL default '',
 `
pagetextmediumtext NOT NULL,
 `
datelineint(10unsigned NOT NULL default '0',
 
PRIMARY KEY  (`id`),
 
KEY `vbgarageid` (`vbgarageid`)
TYPE=MyISAM 


cinq 01-25-2005 12:32 AM

Opps.
What kind of comments are you looking for then ?

noppid 01-25-2005 12:47 AM

Quote:

Originally Posted by cinq
Opps.
What kind of comments are you looking for then ?

You're right, I was not very clear. I need some folks to go to my computer site and beat on the garage there for testing.

Thanks

noppid 01-26-2005 04:02 PM

OK folks, I can't call this new code tested till I get some folks to try it out. I'm not ready to let anyone beta test it yet and I have no immediate plans for release, but I need help debugging.

Come on over to http://www.cpurigs.com/forums please and register and test the multicar vBGarage.

P.S. Upgrading to multicar mode will require vBGarage 4.0.0 to have been installed first.

oly51 01-26-2005 11:35 PM

Just uploaded "Multiples" to the test page.
Only issue, After you upload the image, you are taken back to the Submit screen. Hit "Submit' and you remain at that screen. It does not take you to the garage so you don't know if it uploaded or not.

Works great otherwise. I'll give it a shot whenever you are ready! :D

Also noticed that when you click on the thumb, the google ads are in front of the full size image.

noppid 01-27-2005 01:32 AM

Quote:

Originally Posted by oly51
Just uploaded "Multiples" to the test page.
Only issue, After you upload the image, you are taken back to the Submit screen. Hit "Submit' and you remain at that screen. It does not take you to the garage so you don't know if it uploaded or not.

Works great otherwise. I'll give it a shot whenever you are ready! :D

Also noticed that when you click on the thumb, the google ads are in front of the full size image.

You know if the image was uploaded because it appears in the uploaded images list on the edit page you are taken back to. Then I have edited my directions next to that panel to let the users know to click on members garages to exit that page. This way you can upload a few images in a row easily.

What browser are you using when you see the ads in front of the full size image? I cannot duplicate that in IE or Firefox.

Thanks

oly51 01-27-2005 02:16 AM

Quote:

Originally Posted by noppid
What browser are you using when you see the ads in front of the full size image? I cannot duplicate that in IE or Firefox.
Thanks

Opera 7.54 (It does work ok on IE)

noppid 01-27-2005 02:24 AM

Interesting. That may be a show stopper? The script is from 2003. I wonder if there is an update or similar more current version?

oly51 01-27-2005 10:00 AM

Works perfectly now. I like the header changes.

noppid 01-27-2005 04:00 PM

Quote:

Originally Posted by oly51
Works perfectly now. I like the header changes.

Joeychgo and I worked on that till 4:30am. The idea of the title and headers was his and is for SEO optimization.

We also nixed the DHTML popup as it is inconsistant in drawing itself and while it looks cool, without a full frame, it just didn't look right to us.

Joe gave me a long list of to do's that I'm going to address to enhance things before we even consider a release. That time is not going to be too soon.

But let me remind you, the next version will require 4.0.0 to be installed to upgrade to multi garage.

noppid 01-31-2005 07:16 PM

The list of changes has been updated. The first post in this thread is basically what will need to be done to upgrade to multi garage/car mode.

Take a look at that we have so far... http://www.cpurigs.com/forums/vbgarage.php

We need more feedback please.

nexialys 02-04-2005 10:21 PM

feedbacks.. we NEED this, how can we feedback something we can't play with ?!

release that multi-garage hack, we will evaluate and help on coding extensions if needed... ;) ;0)

noppid 02-04-2005 10:36 PM

Quote:

Originally Posted by nexialys
feedbacks.. we NEED this, how can we feedback something we can't play with ?!

release that multi-garage hack, we will evaluate and help on coding extensions if needed... ;) ;0)

Easier said then done. You see how this is going, 30 installs and only an upgrader and converter revision? That's how the next release is supposed to be too. I don't want to be a slave to code that folks need fixed on live sites cause we missed a bug that is hard to work out.

It would be appreciated if folks would go to the computer site in my signature and register and test the new version. We can have problems there and not really effect anyone.

I'm not hawking for membership, I never expect to see you guys again after it works, we need testers.

Thanks

nexialys 02-05-2005 11:16 AM

i never knew you needed us to register to test... btw, i never test on others boards, i take the codes and test it on my own server, because i'm "so intense" .. ;)

i'll wait for the release of the files to test it, so if you want me to test on my side, just shoot me the files... ;)

noppid 02-05-2005 02:47 PM

Quote:

Originally Posted by nexialys
i never knew you needed us to register to test... btw, i never test on others boards, i take the codes and test it on my own server, because i'm "so intense" .. ;)

i'll wait for the release of the files to test it, so if you want me to test on my side, just shoot me the files... ;)

Well, if no one tests it, it won't be debugged. If no one registers, no one can debug the add and edit and wysiwyg.

I would say with the help I have now, it will be another month.

trackpads 02-05-2005 08:48 PM

Ok, done.

Problem #1

How do you edit/remove a photo from your garage once uploaded? I uploaded the wrong pic but cant get it to remove.

Problem #2

Large images break the page. Is there a way to make a certain max width?

Problem #3

How do we completely remove a garage?

Looks good so far!!

noppid 02-05-2005 09:58 PM

Quote:

Originally Posted by trackpads
Ok, done.

Problem #1

How do you edit/remove a photo from your garage once uploaded? I uploaded the wrong pic but cant get it to remove.

Problem #2

Large images break the page. Is there a way to make a certain max width?

Problem #3

How do we completely remove a garage?

Looks good so far!!

1) You need to click edit/add your computer on forumhome or from the menu in your user control panel. Then on the right of the list you will see buttons for delete and edit.

You also found a bug, when you view your garage you should see an edit and delete link, that is fixed.

2) That's gonna take some JAVA I believe. Someone said they could help with Java on popups, maybe we can set some help here too.

Or

We could add resizing of pics on upload. Only larger to Smaller by width is what I'm thinking.

3) See number one.

Thanks for your help, it is appreciated.

4) I don't like what quote and code tags do either.

trackpads 02-05-2005 10:59 PM

Ok, just noticed something else. The comments are displaying backwards, ie. most recent first. Any way to reverse that?

Also, it works perfectly for large JPG uploads:

http://www.cpurigs.com/forums/vbgara...=241&garage=48

But gifs are a problem:

http://www.cpurigs.com/forums/vbgara...=241&garage=47

Is there a way to allow more than one image in the garage when you create it? Right now you have to go back and edit, add a pic, edit again, add another pic etc etc

noppid 02-05-2005 11:30 PM

Quote:

Originally Posted by trackpads
Ok, just noticed something else. The comments are displaying backwards, ie. most recent first. Any way to reverse that?

Also, it works perfectly for large JPG uploads:

http://www.cpurigs.com/forums/vbgara...=241&garage=48

But gifs are a problem:

http://www.cpurigs.com/forums/vbgara...=241&garage=47

Is there a way to allow more than one image in the garage when you create it? Right now you have to go back and edit, add a pic, edit again, add another pic etc etc

If we sort the other way, the first page fills up and looks dead. I know it's the oposite of threads, but at least the garage looks active. It's not for conversation, it's for comments.

Of course there is a way to do multiple uploads, I just don't have the time for
adding it. But it's a cool idea.

The GIF is not the problem, the quotes and code in the text are. I have not decided how to deal with that yet.

Thanks again for taking the time to try things out.

trackpads 02-05-2005 11:45 PM

Quote:

Originally Posted by noppid
If we sort the other way, the first page fills up and looks dead. I know it's the oposite of threads, but at least the garage looks active. It's not for conversation, it's for comments.

Great point. Your right, better this way.

Quote:

The GIF is not the problem, the quotes and code in the text are. I have not decided how to deal with that yet.
Oh okay, because the penguin is humongous, but when you click the pop up to see larger size it is small and normal.

-Jason

noppid 02-06-2005 12:13 AM

Quote:

Originally Posted by trackpads
Oh okay, because the penguin is humongous, but when you click the pop up to see larger size it is small and normal.

-Jason

Yes, that is a problem with browser resizing, smaller pics can be really streched.

Maybe some suggestions will roll in before we just let it be.

I checked the streching of the width of the text side. That is caused by vB php tags. I doubt many will use those.

Quote:

Originally Posted by nexialys
i never knew you needed us to register to test... btw, i never test on others boards, i take the codes and test it on my own server, because i'm "so intense" .. ;)

i'll wait for the release of the files to test it, so if you want me to test on my side, just shoot me the files... ;)

I enabled full size images for guests. How about a comment on the layout on your mac?

Thanks

WhisperPntr 02-06-2005 02:14 PM

Hi there. I'm really happy with what you're doing as I've been anxious to get a gallery for my own forum. Because I know how it can feel "alone" when coding, I'll be happy to help with debugging and whatever needs you may have.

But before I begin... do you prefer we type here or there when we see something? I will type here but may type there under vbgarage if I see something.

Last note, my name will be corapanther and just for clarification's sake I'm a she not he ;)

djjeffa 02-06-2005 02:29 PM

Any I deal when this hack will be released?
Iv been looking for this hack for about 6 months lol
Good luck guys and keep up the good work.
If ya hook me up with the codding ill test it on my site :)

WhisperPntr 02-06-2005 02:30 PM

Hey there. I think the code is awesome but there are a few things I managed to break or noticed needed a teeny bit of fixing. ;)

First, the description on the uploaded images for some reason disfigures the look on mozilla. My resolution is set at 1280x1024 and that may have something to do with it...though I do prefer it to be a wee bit smaller! ;)

Second, I managed to break the model area by including php code.

I'll get on more stuff later. it's already 12:30 here in hong kong so I need a bit of beauty sleep :)

Looks absolutely wonderful thus far and if there's anything else you want us/me to do please don't hesitate to say it!

noppid 02-06-2005 03:27 PM

Quote:

Originally Posted by WhisperPntr
Hey there. I think the code is awesome but there are a few things I managed to break or noticed needed a teeny bit of fixing. ;)

First, the description on the uploaded images for some reason disfigures the look on mozilla. My resolution is set at 1280x1024 and that may have something to do with it...though I do prefer it to be a wee bit smaller! ;)

Second, I managed to break the model area by including php code.

I'll get on more stuff later. it's already 12:30 here in hong kong so I need a bit of beauty sleep :)

Looks absolutely wonderful thus far and if there's anything else you want us/me to do please don't hesitate to say it!

Exactly what version on you running? 3.11? 3.11-3.0.5? 4.0.0? 4.0.1? 4.0.2?

Quote:

Originally Posted by djjeffa
Any I deal when this hack will be released?
Iv been looking for this hack for about 6 months lol
Good luck guys and keep up the good work.
If ya hook me up with the codding ill test it on my site :)

Thanks for the help. However I have no clue as to when I can give out code.

nexialys 02-06-2005 03:31 PM

why everybody on a PC think that the layout on a Mac is completely different and need to be debugged ?! damn.. when it's not working on a Mac, it's not compliant, that's all.. ;)

noppid 02-06-2005 03:41 PM

Quote:

Originally Posted by nexialys
why everybody on a PC think that the layout on a Mac is completely different and need to be debugged ?! damn.. when it's not working on a Mac, it's not compliant, that's all.. ;)

Well I'm trying to be polite since you're giving suggestions and seem to want to help, even though you won't register. ;)

I've implementesd the -1 thing in the phrases you suggested and thought ya may have wanted to give more feedback where possible.

So, having said that. The layout works in IE and FF for me and validates as XHTML valid, so I consider it done.

Thanks.

Rick Sample 02-06-2005 04:02 PM

Very nicely done so far, just noticed when you click on an image, you have to register first! Like that Ideal!

A bit off topic, but if its not to much trouble, how did you get the google ads in their under the users list of modifications on their personal page? I'd like to put a <hr> break in ther like you have, then under that, list some paid links of some sort!

noppid 02-06-2005 04:31 PM

Quote:

Originally Posted by Rick Sample
Very nicely done so far, just noticed when you click on an image, you have to register first! Like that Ideal!

A bit off topic, but if its not to much trouble, how did you get the google ads in their under the users list of modifications on their personal page? I'd like to put a <hr> break in ther like you have, then under that, list some paid links of some sort!

It's just template edits in the correct places, not difficult. My motorcycle site is running 4.0.3 and my computer site is running the upcoming vBGarage (4.1.0?). Depending on which site you are referring to, the google ads do go in different places, but with a little more detail, we could get ya going.

For the upcoming release, I'm considering leaving markers in the code as comments to suggest the google placement. Honestly, the template were rewritten to be specifically more SEO friendly and target the ads. Thanks to JoeyChgo for his time and suggestions doing the optimization!

Rick Sample 02-06-2005 04:47 PM

Quote:

Originally Posted by noppid
It's just template edits in the correct places, not difficult. My motorcycle site is running 4.0.3 and my computer site is running the upcoming vBGarage (4.1.0?). Depending on which site you are referring to, the google ads do go in different places, but with a little more detail, we could get ya going.

For the upcoming release, I'm considering leaving markers in the code as comments to suggest the google placement. Honestly, the template were rewritten to be specifically more SEO friendly and target the ads. Thanks to JoeyChgo for his time and suggestions doing the optimization!


Ah ok, something like this with the google ads, but it will host regular text links instead of the google ads!
http://www.cpurigs.com/forums/vbgara...id=3&garage=46

I've not upgraded to any newer version, so I'm not sure if that will make a difference or not?

noppid 02-06-2005 05:24 PM

In vbgarage_viewgarage find...

$data[text]

add below...

<hr />
<!-- ad here -->

Rick Sample 02-06-2005 07:07 PM

Quote:

Originally Posted by noppid
In vbgarage_viewgarage find...

$data[text]

add below...

<hr />
<!-- ad here -->


THANKS! worked wonderfully: http://www.muscle-mustangs.com/forum...do=view&id=422

noppid 02-06-2005 07:51 PM

You're welcome.

WhisperPntr 02-07-2005 02:13 AM

Hey when you said what version do you mean browser? I'm currently using mozilla firefox 1.0 in specific
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0

noppid 02-07-2005 02:26 AM

Quote:

Originally Posted by WhisperPntr
Hey when you said what version do you mean browser? I'm currently using mozilla firefox 1.0 in specific
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0

I mean what version of vbgarage.

WhisperPntr 02-08-2005 01:45 PM

Quote:

Originally Posted by noppid
I mean what version of vbgarage.

Umm...I'm testing the one on your computer rigs forum and I have not installed my own vbgarage.

also I posted as corapanther and submitted the cookie monster jpg, etc.

noppid 02-08-2005 01:57 PM

Quote:

Originally Posted by WhisperPntr
Umm...I'm testing the one on your computer rigs forum and I have not installed my own vbgarage.

also I posted as corapanther and submitted the cookie monster jpg, etc.

Ah OK, I've dealt with those issues you pointed out... I think. Should be in a previous posts.

Thanks

WhisperPntr 02-09-2005 07:58 AM

Actually thank *you* for the hard work! Oh and I just checked the other fixes. It looks great now that the php and other code tags don't warp the page.

Is there anything in particular on vbgarage you want us to debug? If not I'll just go ahead and test things at random.


All times are GMT. The time now is 04:37 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.03473 seconds
  • Memory Usage 1,887KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (23)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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