The Arcive of Official vBulletin Modifications Site.

VB Pro Garage Timeslips · **Released**: 02-24-2010

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

BlackJacket · #**132** 03-01-2010, 12:37 AM

Thought of a cool feature -

If the person has not added a vehicle to the garage, a PM, or notification could show up reminding them to add a vehicle.

It could be on a time delay. x number of days after registering they see a notification that they have not yet added their vehicle to the garage.

Dylanblitz · #**133** 03-01-2010, 04:50 AM

Quote:

Originally Posted by BlackJacket

Thought of a cool feature -

If the person has not added a vehicle to the garage, a PM, or notification could show up reminding them to add a vehicle.

It could be on a time delay. x number of days after registering they see a notification that they have not yet added their vehicle to the garage.

Yeah, I can put that in 2.2.x
I'll just create a disabled scheduled task to do it, if an admin wants to turn it on then it'll do the work.

BlackJacket · #**134** 03-01-2010, 11:42 AM

Quote:

Originally Posted by Dylanblitz

Yeah, I can put that in 2.2.x
I'll just create a disabled scheduled task to do it, if an admin wants to turn it on then it'll do the work.

Thanks. I think that would be a great feature.

BlackJacket · #**135** 03-01-2010, 04:32 PM

Also - For the menu tab, we currently have Enabled and Admin Only available. Could you add a "Disabled" option? I use a tab plugin so i see 2 garage tabs lol.

Thanks again!

BlackJacket · #**136** 03-01-2010, 04:49 PM

Just got a report from some users that they are getting a Database error when adding a vehicle. I tested this to verify. Here is the error -

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('3', '2009', '7', '', 'Black', '20000', '1', '', '', '', 'Test', '0', '0', '0', '1267469241', '1267469241', '57', '1124', '696', '0', '', '03', '01', '2010', '1');

MySQL Error   : Unknown column 'money_spent' in 'field list'
Error Number  : 1054
Request Date  : Monday, March 1st 2010 @ 11:47:18 AM
Error Date    : Monday, March 1st 2010 @ 11:47:21 AM
Script        : http://www.*edited*.com/community/garage_vehicle.php
Referrer      : http://www.*edited*.com/community/garage_vehicle.php?do=add_vehicle
IP Address    : *edited*
Username      : *edited*
Classname     : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log

Dylanblitz · #**137** 03-01-2010, 07:41 PM

Quote:

Originally Posted by BlackJacket

Just got a report from some users that they are getting a Database error when adding a vehicle. I tested this to verify. Here is the error -

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('3', '2009', '7', '', 'Black', '20000', '1', '', '', '', 'Test', '0', '0', '0', '1267469241', '1267469241', '57', '1124', '696', '0', '', '03', '01', '2010', '1');

MySQL Error   : Unknown column 'money_spent' in 'field list'
Error Number  : 1054
Request Date  : Monday, March 1st 2010 @ 11:47:18 AM
Error Date    : Monday, March 1st 2010 @ 11:47:21 AM
Script        : http://www.*edited*.com/community/garage_vehicle.php
Referrer      : http://www.*edited*.com/community/garage_vehicle.php?do=add_vehicle
IP Address    : *edited*
Username      : *edited*
Classname     : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log

Dang, thought I got that cleaned out.
I'll fix it in the next update. For a manual fix for now

Open includes/garage_func_var.php
At line 1392 Find

PHP Code:


			
$adding = $db->query_write("INSERT INTO " . TABLE_PREFIX . "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[money_spent]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')");

Replace with

PHP Code:


			
$adding = $db->query_write("INSERT INTO " . TABLE_PREFIX . "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')");

Dylanblitz · #**138** 03-01-2010, 07:42 PM

Quote:

Originally Posted by BlackJacket

Also - For the menu tab, we currently have Enabled and Admin Only available. Could you add a "Disabled" option? I use a tab plugin so i see 2 garage tabs lol.

Thanks again!

Yeah I'll fix that in the next update.

BlackJacket · #**139** 03-01-2010, 10:16 PM

Quote:

Originally Posted by Dylanblitz

Dang, thought I got that cleaned out.
I'll fix it in the next update. For a manual fix for now

Open includes/garage_func_var.php
At line 1392 Find

PHP Code:


			
$adding = $db->query_write("INSERT INTO " . TABLE_PREFIX . "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[money_spent]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')");

Replace with

PHP Code:


			
$adding = $db->query_write("INSERT INTO " . TABLE_PREFIX . "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')");

That fixed it. Thanks!

Quote:

Originally Posted by Dylanblitz

Yeah I'll fix that in the next update.

Thanks again for your hard work.

venom2124 · #**140** 03-02-2010, 12:49 AM

Okay just was playing with the vehicle options and I went to select a featured vehicle and got the following database error.

Quote:

Database error in vBulletin 4.0.1:

Invalid SQL:
INSERT INTO garage_special_track (vehicle_id, track_type, date_created) VALUES ('11', 'featured', '1267497876');

MySQL Error : Table 'coloradohpj.garage_special_track' doesn't exist
Error Number : 1146
Request Date : Monday, March 1st 2010 @ 07:44:36 PM
Error Date : Monday, March 1st 2010 @ 07:44:36 PM
Script : http://www.coloradohpjunkies.com/for..._vehicle&id=11
Referrer : http://www.coloradohpjunkies.com/for..._vehicle&id=11
IP Address :
Username : fox_body_stang
Classname : vB_Database
MySQL Version : 4.1.22-max-log

When I select VOTM nomination is get the following database error.

Quote:

Database error in vBulletin 4.0.1:

Invalid SQL:
INSERT INTO garage_special_track (vehicle_id, track_type, date_created) VALUES ('11', 'votm', '1267497985');

MySQL Error : Table 'coloradohpj.garage_special_track' doesn't exist
Error Number : 1146
Request Date : Monday, March 1st 2010 @ 07:46:25 PM
Error Date : Monday, March 1st 2010 @ 07:46:25 PM
Script : http://www.coloradohpjunkies.com/for..._vehicle&id=11
Referrer : http://www.coloradohpjunkies.com/for..._vehicle&id=11
IP Address :
Username : fox_body_stang
Classname : vB_Database
MySQL Version : 4.1.22-max-log

So not sure what's missing or causing the error but any help would be great. Now after i get the error if I refresh the previous page it will show me that the vehicle I was trying to make the VOTM is the VOTM.

ChopSuey · #**141** 03-02-2010, 02:53 AM

To get the links to show in custom styles add this

HTML Code:

<vb:if condition="THIS_SCRIPT != 'garage'">
		<li><a href="http://www.pgtrackandsled.ca/forum/garage.php">Garage</a></li>
</vb:if>
<vb:if condition="THIS_SCRIPT == 'garage'">
		<li><a href="#">Garage</a>
			<ul class="drop">
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php" title="Main">Main</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage_vehicle.php?do=add_vehicle" title="Add Vehicle">New Entry</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php?do=browse" title="Browse">Browse</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php?do=search" title="Search">Search</a></li>
<li><a href="http://www.pgtrackandsled.ca/forum/garage.php?do=timeslip" title="Timeslips">Timeslips</a></li>
</ul>
</li>
</vb:if>
</li>

Of course change the links to yours.
It drops down on hover, its a drop down menu
view here http://www.pgtrackandsled.ca/forum/garage.php

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.16211 seconds Memory Usage 2,437KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)bbcode_html (4)bbcode_php (8)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (11)post_thanks_box (3)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (9)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

3 благодарности(ей) от:
brishi, iiioroh, kyroxj

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!