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 Trumpetrhapsody

I've been getting all sorts of database errors lately... I've tried repairing the tables, running the mantenance tools, etc. Any insight?

Database error in vBulletin 4.1.8:

Invalid SQL:
SHOW COLUMNS FROM vbgarage_permissions;

MySQL Error   : Incorrect key file for table '/mysql-tmp/#sql_1651_0.MYI';
try to repair it
Error Number  : 126
Request Date  : Friday, January 20th 2012 @ 11:04:58 PM
Error Date    : Friday, January 20th 2012 @ 11:04:58 PM
Script        :
http://www.ozarkautosport.com/showthread.php?630-Rallycross/page16
Referrer      : http://www.ozarkautosport.com/search.php?searchid=109703
IP Address    : xxxxxxxxxx
Username      : xxxxxx
Classname     : vB_Database
MySQL Version :

What version of mysql is it? There are a few errors I see it can be from, the one I saw the most was the diskspace that tmp resides on could be running out of space.

[clutchthese]

Originally Posted by Dylanblitz

Can you post a screenshot? I'm not sure what you mean.

[bposner]

Originally Posted by Dylanblitz

Lets try something else.
In the ACP
ACP -> Styles & Templates -> Style Manager
Whatever your default style is, on the dropdown select Edit Settings.
That will give you the style id, like the default style has an id of 8.

Thank you Dylan, this fixed the issue. I so appreciate the time and effort you put into supporting this great product. Thanks!!
:up:

[Trumpetrhapsody]

Originally Posted by Dylanblitz

What version of mysql is it? There are a few errors I see it can be from, the one I saw the most was the diskspace that tmp resides on could be running out of space.

MySQL Version 5.0.91-log
MySQL Packet Size 32.00 MB

I'm on a hosted system, is the tmp location something I could clear out in my directory access?

[Trumpetrhapsody]

Just started getting these too:

Database error in vBulletin 4.1.8:

Invalid SQL:
SHOW COLUMNS FROM vbgarage_permissions;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Wednesday, February 29th 2012 @ 11:51:57 AM
Error Date    : Wednesday, February 29th 2012 @ 11:51:58 AM
Script        : http://www.ozarkautosport.com/index.php
Referrer      : 
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname     : vB_Database
MySQL Version :

Looks like you may be right about the space issues. I tried tech support and as is usual they weren't very helpful. Told me I wasn't near my space limits, and that everything resets every hour... don't think they knew what they were talking about.

[ExoticAgenda]

This may be a silly question, when I initially installed the mod and imported the makes and models, they are all in upper case, how can I get them to be in lower case (except for the first letter and makes like BMW)

[Dylanblitz]

Originally Posted by Trumpetrhapsody

Just started getting these too:

Database error in vBulletin 4.1.8:

Invalid SQL:
SHOW COLUMNS FROM vbgarage_permissions;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Wednesday, February 29th 2012 @ 11:51:57 AM
Error Date    : Wednesday, February 29th 2012 @ 11:51:58 AM
Script        : http://www.ozarkautosport.com/index.php
Referrer      : 
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname     : vB_Database
MySQL Version :

Looks like you may be right about the space issues. I tried tech support and as is usual they weren't very helpful. Told me I wasn't near my space limits, and that everything resets every hour... don't think they knew what they were talking about.

Error 28 is a space issue. I found a thread about it on vb.com

https://www.vbulletin.com/forum/show...number-1030%29

[Dylanblitz]

Originally Posted by ExoticAgenda

This may be a silly question, when I initially installed the mod and imported the makes and models, they are all in upper case, how can I get them to be in lower case (except for the first letter and makes like BMW)

I can't think of a way to automatically do it. Sorry.

[bposner]

Well seems this little quirk in the postbit keep popping up and I have constantly rebuild the drop down. I have no idea what triggering it.

see pic: http://screencast.com/t/ouVczbEL3bGE

thanks

[cdoyle]

I was wondering, would you know how we could add the Google +1 and Facebook 'Like' button to each members garage?

Thanks!
Chris