vB Timeslip Database -for Automotive websites

I doubt this will be used by many people since its designed specifically for automotive websites.. But it has been requested here several times, so here ya go.

What does it do? This hack does a few things. First, it will add a separate Vehicle Profile page to your forum where your users can enter their type of vehicle, horsepower, best 60' time, 1/8 mile time, 1/4 mile time, a link to their timeslip and more. Once the data is entered the timeslips.php page will display the info sorted by the best times, highest trap speeds, highest horsepower #s, proof of ET, or ET brackets (user selectable).

You can also ban users from editing their Vehicle Profile. This comes in handy if you have some users who insist on entering false data into the Timeslip Database just to be funny. To use this feature, just click on the user's profile, then click "user options" and set "Can edit vehicle profile" to no. The user will still be able to edit his regular profile, but not his vehicle profile.


Demo: http://modernmusclecars.net/forums/timeslips.php

(Note: I just added this to my board a couple of days ago so there's only a few entries right now.. It does have pagination and will display 25 per page by default once more ETs are entered.)

Screenshot1: Vehcile Profile page
Screenshot2: Edit Vehcile Profile page


Features include:
*The ability to sort by:
-1/4 Mile ET
-1/4 Mile MPH
-1/8 Mile ET
-1/8 Mile MPH
-60' Time
-Horsepower
-Cars with proof of ET (actual timeslip)
-Username
-ET brackets (New!)
*Show the average ET, MPH, and HP for your site. (New!)
*Vehcile Profile (separate from user profile) (New!)
*Ability to ban users from editing their vehicle profile (New!)
*Installer


Installation is easy:
1. Upload TDinstaller.php to your admin directory & run the installer.
2. Follow the hack instructions to edit the 4 php files.
3. Edit two templates.
4. Add five new templates.
5. Upload timeslips.php to your forum directory and slipicon.gif to your image directory.

This has been tested on 2.2.8 - 2.3.2 and should work fine with any 2.X.X version.

Note: I don't use vb 2.X anymore so this hack is no longer supported

Download vB Timeslip Database v1.3

(Version 2.0 is availible for VB3 users here.)

Add-ons:
*Add-on: Display the Top Five 1/4 mile ETs on your front page portal
*Add-on: Require a link to the actual timeslip for all ETs that are 11.99 or quicker.
*Add-on: A "timeslips" button for your header (PSD and GIF). -by Optima
*Add-on: Show the ET club that users belong to in the postbit.
*How to: Add a "select" field & sort by it in the timeslip database.
*How to: Change the default sort method



Updated 10-29-03 to add new features: - Added the ability to sort by ET brackets. (ie. show 10 second cars only. 11 second cars only, 13 sec cars, etc). Requested by BrendonM
Check the demo page to see it in action.

Updated 10-31-03 (new feature): -Added a new action that will show the average ET, trap speed, and horsepower for your site.
Go to the demo page and select "Site Averages" from the drop down menu to see what I mean.

Updated 11-10-03: -Added the vehicle profile addon to the hack instructions. Added a few new fields to the vehicle profile page (race weight, track, D/A, mods, tranny type, etc). Added a "details" column to the Timeslip Database page which lets you view all vehicle profile fields when the details link is clicked (see demo).

Instructions for upgrading all previous versions to v1.3.

If you find this script useful please click install.

[sticky]

Question: Would it be possible to sort by make? I could really use that feature so a user could see what the fastest car in each make was.

Another thing, with the whp column, would you be able to make it so someone can link to their dyno run the same way you do it with the slip?

Edit: What if a person has more than one car?

[EvilLS1]

Thanks for the kind words.

Question: Would it be possible to sort by make? I could really use that feature so a user could see what the fastest car in each make was.

It is possible but would require alot of work. As it is right now your users can add their vehicle in a regular text input field.. Since its not fool-proof they could enter several different things which would not sort correctly.. For example, if one user enters "Mustang" and another user enters "Ford Mustang" and yet another user enters "stang" they will not be sorted together.

In order to make it possible to sort by vehicles you would need separate select box input fields for vehicle make, model, and year. This would take some time to add, and unfortunately I don't have alot of free time right now. However, if you feel comfortable editing a little php code you could do it yourself. If you'll read back through this thread I've posted instructions on how to add select box input fields and sort by them.

Another thing, with the whp column, would you be able to make it so someone can link to their dyno run the same way you do it with the slip?

Yes, its all explained in this post:
https://vborg.vbsupport.ru/showpost....&postcount=136

Edit: What if a person has more than one car?

You could add an extra field to list other cars, but the timeslips page can only show/sort the info for one car per user.

[Carnage Media]

Evil, I've been searching but can't find it.

My members would like for the timeslips to be able to show what engine size instead of WHP.

How can I do that?

Thanks.

[sticky]

Evil, if necessary, I will pay you to have a custom version of this made for my site to compensate for your time.

[EvilLS1]

Originally Posted by Carnage Media

Evil, I've been searching but can't find it.

My members would like for the timeslips to be able to show what engine size instead of WHP.

How can I do that?

Thanks.

In timeslips.php find:

} else if ($action=="rwhp") {
  $cond.=" WHERE userfield.field51>'".intval($number)."'";
  $condition.=" AND userfield.field51>'".intval($number)."'";
  $orderby="userfield.field51";
  $direction=DESC;
  $bracket7="<b>[</b>";
  $bracket8="<b>]</b>";

Replace it with:

} else if ($action=="cubes") {
  $cond.=" WHERE userfield.field61>'".intval($number)."'";
  $condition.=" AND userfield.field61>'".intval($number)."'";
  $orderby="userfield.field61";
  $direction=DESC;
  $bracket7="<b>[</b>";
  $bracket8="<b>]</b>";

Find:

if ($userinfo[field51]>0){
  $rwhp= $userinfo[field51];
}else{
  $rwhp="";
}

Replace it with:

if ($userinfo[field61]!=""){
  $cubes= $userinfo[field61];
}else{
  $cubes="";
}

In your timeslips template find:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=rwhp">Horsepower</option>

Replace it with:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=cubes">Displacement</option>

Find:

<b>WHP</b>

Replace it with:

<b>C.I.</b>

In your timeslipsbit template find:

<td bgcolor="{secondaltcolor}">$avghp$rwhp</td>

Replace it with:

<td bgcolor="{secondaltcolor}">$cubes</td>

[EvilLS1]

Originally Posted by sticky

Evil, if necessary, I will pay you to have a custom version of this made for my site to compensate for your time.

Thanks for the offer, but $$ is not really the issue. I'm just so busy with other things right now that I don't have time to do any custom work. I haven't even got around to upgrading my own site yet.

Maybe after I finish with all of my own projects.. But that'll probably be a while.

[Carnage Media]

thank you for the fast response and it worked perfect

[EvilLS1]

You're welcome.

[EvilLS1]

For those interested, I've started working on a new version of this for VB3. I can only work on it in my spare time (and my spare time is limited) so its probably gonna be a few weeks before I release it. Should be pretty nice though.

Dewayne

[0ptima]

Originally Posted by EvilLS1

For those interested, I've started working on a new version of this for VB3. I can only work on it in my spare time (and my spare time is limited) so its probably gonna be a few weeks before I release it. Should be pretty nice though.

Dewayne

Woohoo !!! Thanks!!!