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

// 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]

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

#
# 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]

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` (
 `userid` int(10) unsigned NOT NULL default '0',
 `year` varchar(50) NOT NULL default '',
 `make` varchar(50) NOT NULL default '',
 `model` varchar(50) NOT NULL default '',
 `text` mediumtext NOT NULL,
 `lastactivity` int(10) unsigned NOT NULL default '0',
 `garageid` int(10) unsigned NOT NULL auto_increment,
 PRIMARY KEY  (`garageid`),
 KEY `userid` (`userid`)
) TYPE=MyISAM



CREATE TABLE `vbgarage_images` (
 `vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
 `userid` int(10) unsigned NOT NULL default '0',
 `id` smallint(6) unsigned NOT NULL default '0',
 `name` varchar(50) NOT NULL default '',
 `data` longblob NOT NULL,
 `type` varchar(50) NOT NULL default '',
 `thumb` longblob NOT NULL,
 PRIMARY KEY  (`vbgarageid`),
 KEY `id` (`id`),
 KEY `userid` (`userid`)
) TYPE=MyISAM

CREATE TABLE `vbgarage_comments` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `vbgarageid` int(10) unsigned NOT NULL default '0',
 `username` varchar(50) NOT NULL default '',
 `pagetext` mediumtext NOT NULL,
 `dateline` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `vbgarageid` (`vbgarageid`)
) TYPE=MyISAM 


[cinq]

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

[noppid]

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]

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]

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!

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

[noppid]

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!

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]

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]

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