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

[gibgib]

Originally Posted by KTP

tried to install this on 4.2.0

it wont let me install the language xml
and upon importing the garage xml i get this error

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT COUNT(vehicle_id) AS vehicles FROM _vb4garage_user_vehicle WHERE active = '0';

MySQL Error   : Table 'xxx_vb4._vb4garage_user_vehicle' doesn't exist
Error Number  : 1146
Request Date  : Friday, August 10th 2012 @ 06:27:26 PM
Error Date    : Friday, August 10th 2012 @ 06:27:26 PM
Script        : http://www.xxx
Referrer      : http://www.xxx
IP Address    : xx.xxx.xx.xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.5.23-55

it looks like its adding a "." at the end of my database prefix "vb4." when it should just be "vb4"
not sure how to fix this or if this info is of any help to you?

I am also getting this.
I'm doing a fresh install on vB 4.2 & have tried the quoted remedy of changing all TYPE=MyISAM to ENGINE=MyISAM in the xml but no good.

These are the only tables in the database under garage:

garage_blocks 	524 Bytes 	13.0 KB 	0 	Yes
garage_colors 	352 Bytes 	13.0 KB 	0 	Yes
garage_currency 	100 Bytes 	13.0 KB 	0 	Yes
garage_engine_type 	252 Bytes 	3.0 KB 	0 	Yes
garage_generation 	0 	1.0 KB 	0 	Yes
garage_guestbooks 	0 	1.0 KB 	0 	Yes
garage_trims 	0 	1.0 KB 	0 	Yes
garage_vehicle_classes 	792 Bytes 	13.0 KB 	0 	Yes

[Dylanblitz]

Originally Posted by gibgib

I am also getting this.
I'm doing a fresh install on vB 4.2 & have tried the quoted remedy of changing all TYPE=MyISAM to ENGINE=MyISAM in the xml but no good.

These are the only tables in the database under garage:

garage_blocks     524 Bytes     13.0 KB     0     Yes
garage_colors     352 Bytes     13.0 KB     0     Yes
garage_currency     100 Bytes     13.0 KB     0     Yes
garage_engine_type     252 Bytes     3.0 KB     0     Yes
garage_generation     0     1.0 KB     0     Yes
garage_guestbooks     0     1.0 KB     0     Yes
garage_trims     0     1.0 KB     0     Yes
garage_vehicle_classes     792 Bytes     13.0 KB     0     Yes

I'm sorry about that. I'm not sure why it's not creating the tables. If you want to give me temp admin access I'll try and find out why it's not installing all the tables.

[gibgib]

Hi Dylanblitz,
That is very kind of you to offer that.
Enabling the product at the moment will cause the forum to not function so I would need to be working with you at the same time. I also back up just before doing ANYTHING to the database as I have been known to stuff tables.

If it's easier can someone format this below into a query I can run in mysql admin so I can see if the table is added manually?

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "garage_images (
attach_id mediumint(8) unsigned NOT NULL auto_increment,
vehicle_id mediumint(8) unsigned NOT NULL default '0',
sub_id int(11) unsigned default NULL,
attach_type varchar(10) binary default NULL,
attach_location varchar(255) binary NOT NULL default '',
attach_hits mediumint(8) unsigned NOT NULL default '0',
attach_ext varchar(100) binary NOT NULL default '',
attach_file varchar(255) binary NOT NULL default '',
attach_thumb_location varchar(255) binary NOT NULL default '',
attach_is_image tinyint(1) unsigned NOT NULL default '0',
attach_date int(11) unsigned NOT NULL default '0',
attach_filesize int(20) unsigned NOT NULL default '0',
PRIMARY KEY  (attach_id)
) ENGINE=MyISAM  AUTO_INCREMENT=1");

[craigvm]

after installing this my site is just a blank page so had to disable

[Dylanblitz]

Originally Posted by gibgib

Hi Dylanblitz,
That is very kind of you to offer that.
Enabling the product at the moment will cause the forum to not function so I would need to be working with you at the same time. I also back up just before doing ANYTHING to the database as I have been known to stuff tables.

If it's easier can someone format this below into a query I can run in mysql admin so I can see if the table is added manually?

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "garage_images (
attach_id mediumint(8) unsigned NOT NULL auto_increment,
vehicle_id mediumint(8) unsigned NOT NULL default '0',
sub_id int(11) unsigned default NULL,
attach_type varchar(10) binary default NULL,
attach_location varchar(255) binary NOT NULL default '',
attach_hits mediumint(8) unsigned NOT NULL default '0',
attach_ext varchar(100) binary NOT NULL default '',
attach_file varchar(255) binary NOT NULL default '',
attach_thumb_location varchar(255) binary NOT NULL default '',
attach_is_image tinyint(1) unsigned NOT NULL default '0',
attach_date int(11) unsigned NOT NULL default '0',
attach_filesize int(20) unsigned NOT NULL default '0',
PRIMARY KEY  (attach_id)
) ENGINE=MyISAM  AUTO_INCREMENT=1");

The problem is you're missing quite a few tables, it's more then just the one table not being created.

[Noerenberg]

Hi, first, i love this mod, but i want to change some information.
Example, {vb:raw head_title_text} how i can change the information in this raw?
I dont want to show the year and some other stuff, where i can change the text? or how i can show just the owner or the nickname?

[Dylanblitz]

Originally Posted by Noerenberg

Hi, first, i love this mod, but i want to change some information.
Example, {vb:raw head_title_text} how i can change the information in this raw?
I dont want to show the year and some other stuff, where i can change the text? or how i can show just the owner or the nickname?

You still need this? I know you got some of the other stuff figured out, not sure if you figured this one as well.

[gibgib]

Originally Posted by Dylanblitz

I'm sorry about that. I'm not sure why it's not creating the tables. If you want to give me temp admin access I'll try and find out why it's not installing all the tables.

Hi Dylanblitz, did you still want to have a look at this?
Is it just vbulletin admin access you needed with execute sql queries?

[Dylanblitz]

Originally Posted by gibgib

Hi Dylanblitz, did you still want to have a look at this?
Is it just vbulletin admin access you needed with execute sql queries?

Just temp admin is good, I'd rather not have the sql execute

I was going to turn off the error suppression on the installer and see what's causing the problem.

[Dylanblitz]

Originally Posted by gibgib

Hi Dylanblitz, did you still want to have a look at this?
Is it just vbulletin admin access you needed with execute sql queries?

I'm not sure what the problem was unfortunately heh. I turned off the error bypass, deleted the tables you already had and imported and it installed fine.

I also added a fix I just created and added to the top here. It's a product that will add the navigation manager entries and their permissions so you don't have to use the dynamic link.

One problem you're going to have though, your custom style doesn't have an area for submenu items.