Add-On Releases - VB Pro Garage Timeslips

Description
VB Pro Garage Timeslips (formerly CND Garage/Timeslips) is a free vehicle and timeslips add on for vBulletin 4. This is a great way to allow members to show off their rides, whether they are cars, motorcycles, atv's, etc. Site administrators have dozens of options to tailor the way the garage is displayed and the number of vehicles, images and timeslips the user can enter. User vehicle creation is done through a simple screen with dropdowns and simple text fields. Users can enter either miles or km and system will automatically calculate differences for front page statistics.

** New Features **
* SEO Friendly URLs (htaccess only)
* Page Caching - physical html files which make a HUGE reduction in sql queries
* Front Categories - a category system as an alternate front page to the block layout. I believe it will increase the garage ranking in search engines greatly when used with SEO URL's and the included dynamic meta tags.
* Thread Creation - Automatically create new threads in the forum of your choosing with the text of your choosing when a new vehicle is created in the garage.

Main Features

* No vb template modification needed
* Ajax driven menu's to keep load time down if you have a very large lists of makes/models
* Usergroup level permissions to set the amount of vehicles, images, timeslips allowed
* 99.9% of the text is phrased so that it can be translated for multinational sites
* On the fly image/text watermarking ability to make sure images are tied to your site
* Lytebox image presentation

Installation
Instructions, tips and more are now in the included chm file. If you have problems with the chm I have the document published at:
http://www.vbprogarage.com/forums/docs/html_vb4_ts_300/

The quick and dirty install:
1) Upload all files in the upload folder
2) Import vb_pro_garage.xml into Product Manager
3) Import vb_pro_garage_language_english.xml into Languages & Phrases
4) If you want all makes and models I've collected, import vb_pro_garage_vehicles^^new_install_only.xml into Product Manager

Post Installation
So you don't have to find it in the instructions. After install, there is a button up top in the navbar. This button by default is admin only. This is so you can configure and test without having to close the garage. When you are ready to deploy to the community:
ACP->Settings->Options->Garage General Settings - Set Garage Menu Button to Enabled.

The garage is developed on vb 4.0.7 and tested back to 4.0.0. The garage will run on PHP 5.x+ compiled with GD/GD2 and MySQL 5.x+

Additional options for the garage like adding featured businesses that support your site, fuel tracking, dyno charts, modifications and lots more are included in the commercial version.

Many thanks to Coroner for his stylebridge which led me on a path that saved me hours and hours of template editing

There are a few bugs that you might run into on this version. Instead of working on correcting them in the files and working on getting a new package up here, I'm working on the next version and including the posts that fix the errors here.

Change Log:
v3.0.9 - 09/29/2012
-----------------------------
Fixed sql injection problem
Replaced depreciated split function usage
Fixed sql error on image comments
Fixed Make/Model count on front page resetting to 1
Fixed extra unlabeled field on vehicle create/edit (Timeslips only)
Fixed postbit dropdown showing character code
Fixed tables incorrectly set with TYPE instead of ENGINE
Added navigation manager links to product xml

v3.0.8 - 12/9/2010
-----------------------------
Fixed missing vehicle comment code

v3.0.7 - 12/1/2010
-----------------------------
Fixed error with non existant garage_special_track table

v3.0.6 - 11/21/2010
-----------------------------
Fixed who's online error
Fixed map infowindow colors

v3.0.5 - 11/15/2010
-----------------------------
Fixed error with member profile vehicle block
Fixed member tab url path
Fixed error on vehicle map with apostrophes in title

v3.0.4a - 11/12/2010
-----------------------------
Corrected package error

v3.0.4 - 11/11/2010
-----------------------------
Fixed error with front blocks
Fixed style error with vB4.0.8 changes

v3.0.3 - 11/2/2010
-----------------------------
Fixed duplicate countries
Fixed vehicle view slideshow image size
Fixed username browse error
Fixed geocode error on missing zip
Fixed postbit error with vehicles that have a apostrophe in the name

v3.0.2 - 10/25/2010
-----------------------------
Fixed missing add vehicle button on member profile
Added bbcode capabilities to welcome box on garage front page
Moved vehicle count to db table to ease db queries
Added notification scheduled task to send message to new users about adding a garage entry
Added default clear image for watermark
Fixed code to disregard watermark option if image is missing
Fixed search username error
Updated obsolete data queries
Added SEO Friendly URLS
Added page caching capabilities
Fixed sql error with moving vehicle class and color to new selection on deletion in ACP
Added function to replace non english characters with english characters in ajax selection lists
Added image comments
Added notification for image and vehicle comments
Added option to add page title
Added zip code to vehicle and googlemap
Added ability to disable and ability to hide info for googlemap

[Dylanblitz]

Originally Posted by cdoyle

Turning the cache off, fixes the latest image block. Also on forum home, is the 'random image' using the same query as the 'latest image'? because I noticed that the images appear to be the same ones that are displayed in the Latest Image block.

I would really like forumhome to just randomly select any image from any garage in the database. Seeing the same images over and over, is not making users want to click.

Thanks for the fix on the comments too, that's all working now.

On the forumhome, you only have 8 vehicles with images. The block will only show 1 image from each vehicle and it's the vehicles primary image. So you really only have 8 images to cycle through right now. When you have more vehicles in there it will start showing a bigger range of images.

[cdoyle]

Originally Posted by Dylanblitz

On the forumhome, you only have 8 vehicles with images. The block will only show 1 image from each vehicle and it's the vehicles primary image. So you really only have 8 images to cycle through right now. When you have more vehicles in there it will start showing a bigger range of images.

Is there anyway to make it pick a random image from the db, not just the primary images?

[BajaBoatOwners]

Is there a setting or template change to allow for # of engines option? We have mainly boats on our forum most have 2 engines

[cdoyle]

Originally Posted by Dylanblitz

On the forumhome, you only have 8 vehicles with images. The block will only show 1 image from each vehicle and it's the vehicles primary image. So you really only have 8 images to cycle through right now. When you have more vehicles in there it will start showing a bigger range of images.

Also, I changed my primary image and it's still showing the last image I uploaded.
Is there any way, to make it just select a random image from the db?

[Dylanblitz]

Originally Posted by BajaBoatOwners

Is there a setting or template change to allow for # of engines option? We have mainly boats on our forum most have 2 engines

No real setting for that, if you want a basic 2 engines, 3 engines type field it can be done through a plugin though.

[Dylanblitz]

Originally Posted by cdoyle

Also, I changed my primary image and it's still showing the last image I uploaded.
Is there any way, to make it just select a random image from the db?

ACP -> Plugins&Products -> Plugin Manager
Edit the plugin
VB Pro Garage Forum Home Pictures

Find

PHP Code:

$pic_query = $vbulletin->db->query("SELECT gi.vehicle_id, gi.attach_thumb_location, guv.user_id FROM " . TABLE_PREFIX . "garage_images gi LEFT JOIN " .TABLE_PREFIX . "garage_user_vehicle guv ON gi.vehicle_id = guv.vehicle_id WHERE guv.active = '1' GROUP BY gi.vehicle_id" . $orpic); 


replace with

PHP Code:

$pic_query = $vbulletin->db->query("SELECT gi.vehicle_id, gi.attach_thumb_location, guv.user_id FROM " . TABLE_PREFIX . "garage_images gi LEFT JOIN " .TABLE_PREFIX . "garage_user_vehicle guv ON gi.vehicle_id = guv.vehicle_id WHERE guv.active = '1' ORDER BY rand(NOW()) LIMIT " . $displayrecords); 


That should do it

[BajaBoatOwners]

Originally Posted by Dylanblitz

No real setting for that, if you want a basic 2 engines, 3 engines type field it can be done through a plugin though.

Where would I find that or how would I add that? I'd like to have choices of 1,2,3 engines.

[cdoyle]

Originally Posted by Dylanblitz

ACP -> Plugins&Products -> Plugin Manager
Edit the plugin
VB Pro Garage Forum Home Pictures

Find

PHP Code:

$pic_query = $vbulletin->db->query("SELECT gi.vehicle_id, gi.attach_thumb_location, guv.user_id FROM " . TABLE_PREFIX . "garage_images gi LEFT JOIN " .TABLE_PREFIX . "garage_user_vehicle guv ON gi.vehicle_id = guv.vehicle_id WHERE guv.active = '1' GROUP BY gi.vehicle_id" . $orpic); 


replace with

PHP Code:

$pic_query = $vbulletin->db->query("SELECT gi.vehicle_id, gi.attach_thumb_location, guv.user_id FROM " . TABLE_PREFIX . "garage_images gi LEFT JOIN " .TABLE_PREFIX . "garage_user_vehicle guv ON gi.vehicle_id = guv.vehicle_id WHERE guv.active = '1' ORDER BY rand(NOW()) LIMIT " . $displayrecords); 


That should do it

that worked perfectly thank you!

One last question, and I think I'll have this exactly like I want.
The latest image within the garage, does not seem to be updating. I just added an image, and it's not appearing there.

Where is this query for this located?

[Dylanblitz]

Originally Posted by BajaBoatOwners

Where would I find that or how would I add that? I'd like to have choices of 1,2,3 engines.

I can create it for you. Do you just want a select dropdown with 1 2 and 3 as the options with the text for it "# of engines"?

[Dylanblitz]

Originally Posted by cdoyle

that worked perfectly thank you!

One last question, and I think I'll have this exactly like I want.
The latest image within the garage, does not seem to be updating. I just added an image, and it's not appearing there.

Where is this query for this located?

Is it a vehicle image? It is in the order of the last updated date for the images, or do you want to open it to all images, not just vehicle images?
I restricted it to vehicle images because the timeslip images are usually just a scan of the timeslip, and those aren't too exciting to display in the blocks heh