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

[KTP]

my table is xxx_vb4
i had done a fresh install of vb 4.2.0 so its not from an upgrade, i dont know if that matters

i remember having vhoist on a previous forum and loved it, guessing this is the same but for vb4.x

[Dylanblitz]

Originally Posted by KTP

my table is xxx_vb4
i had done a fresh install of vb 4.2.0 so its not from an upgrade, i dont know if that matters

i remember having vhoist on a previous forum and loved it, guessing this is the same but for vb4.x

Do you mean your database or your prefix is xxx_vb4?
I'm still not sure what would be causing that problem. I checked the code and there's not an extra _ in there. There's only 2 places where that query would be running.

Do you see the table garage_user_vehicle in your database?

[ssoc]

You may remember a while back, I posted a bug report here: https://vborg.vbsupport.ru/showpost....&postcount=785

I fixed the profile that was showing the error at the time, but that was clearly a temp fix. I never got to the bottom of what actually caused it to happen as I'm reluctant to edit any of the core plugin files.

Anyway, a couple of months on and it's happened again. This time to three users.
Not sure if this is just coincidence, but two out of the three users currently have " (quote) signs in their garage titles. See below:

Attachment 140807

Attachment 140806

It's possible that the other user did at some stage too, so perhaps this is what's causing this problem to crop up? Just a suggestion.

Anyway hopefully you can find out what the issue is and rectify it in your next update.


-----------------------------

In the meantime, anyone else having this problem; it's quite time consuming but here's how to repair each user:

1. Goes without saying.. backup the database first!
2. Login to PhpMyAdmin and locate the 'Userfield' table.

Some important notes: You'll find the next steps easier if you sort them by 'user id'. Remember, 'userid' is just that - the forum user id. This is different from the garage id, which you'll need to change in a later step.

To find the 'user id', hover the users name on the forums and the user id is listed at the end of the URL.

To find the 'garage id', go to that users garage and look in your browser address bar. The number at the end of the URL is the garage ID.

3. First open up a user who has a garage, and does NOT have the error displaying on the front end, in a new tab (by clicking 'edit').
Now scroll to the bottom and you'll see some code like this:

Attachment 140804

^This is good code.. how it should look. However every users' code is a little different, since they have different garage ID's, garage names, and obviously different car images (in this case, the thumbnail that appears when you click the 'vehicles' drop-down link from the users postbit).

4. Highlight, right click, and 'copy' that good code.
5. Now open another user in phpmyadmin (one who's got the error on the front end).. again, by opening in a new tab clicking the 'edit' link. Scroll to the bottom and you'll see 'bad code', like so:

Attachment 140803


6. Now delete that bad code and paste the good code in its place.
7. We then need to edit three things, as pointed out in this pic:

Attachment 140805

Here's how to get them:

The garage ID - as I described earlier in this post.
The thumbnail url - go to the users garage, and the image that's under their username is the one which is used as the thumbnail, so open it in a new tab and copy the URL from the browser address bar. You don't need the first part of it, just from images/ ...onwards.
The garage title - get this from the users garage. It's at the top.

8. Double check the code you're able to save and make sure you're editing the correct user
9. Click save

Now check the front end to make sure you've done it correctly. If you have, give yourself a pat on the head :up:

[Dylanblitz]

Did you check the user profile field and increase the size on it? It defaults to 100 but you need to have it quite a bit larger to hold all the data. The problem usually happens when you modify the user for some reason inside the ACP. It saves all fields and crops the text down to the field limit.

[ssoc]

Originally Posted by Dylanblitz

Did you check the user profile field and increase the size on it? It defaults to 100 but you need to have it quite a bit larger to hold all the data. The problem usually happens when you modify the user for some reason inside the ACP. It saves all fields and crops the text down to the field limit.

Hi Dylan,

Which one is it using (or do I change the limit elsewhere)?

Attachment 140849

Thanks

[Dylanblitz]

Originally Posted by ssoc

Hi Dylan,

Which one is it using (or do I change the limit elsewhere)?

Attachment 140849

Thanks

It's the field43 one. Edit that and check the length

[ssoc]

Originally Posted by Dylanblitz

It's the field43 one. Edit that and check the length

It looks to already be set to 250 (this hasn't been edited).. I don't see any that are defaulted to 100?

Or do you mean the one that's set to 25?

Attachment 140874

[Dylanblitz]

Originally Posted by ssoc

It looks to already be set to 250 (this hasn't been edited).. I don't see any that are defaulted to 100?

Or do you mean the one that's set to 25?

Attachment 140874

Where it says
Max length of allowed user input
I would change that to something larger, like 10000.
Then edit a users record that you know has a dropdown and see if their dropdown gets screwed up after. Might be a good idea to copy the data from that field out first in phpmyadmin so you can paste it back in

[ssoc]

Originally Posted by Dylanblitz

Where it says
Max length of allowed user input
I would change that to something larger, like 10000.
Then edit a users record that you know has a dropdown and see if their dropdown gets screwed up after. Might be a good idea to copy the data from that field out first in phpmyadmin so you can paste it back in

Unable to edit it

Attachment 140884

[Dylanblitz]

Originally Posted by ssoc

Unable to edit it

Attachment 140884

Yeah, you need to add a title to the field. Can call it Garage Postbit or whatever you want. It's just the name you'll use to keep track of it in the ACP