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.

[EvilLS1]

Originally Posted by NickCat

Thanks for the update. I added a few more tweaks of my own today. I used the custom dropdown to add a list of tracks and type of induction. My users were concerned about elevation effects on the 1/4 times in the registry so I figure as an alternative to trying to add elevation, temp, and humidity (which most users would leave blank anyway) I just added the track name field with a drop down of the most popular tracks.

And good idea on the image attachment thread.

I'll anxiously be awaiting the release of V2.0 with the built in attachment upload!

-Nick
http://www.nasioc.com/

Looks nice Nick. I like the new track name field.

[corsacrazy]

hehe i made ur addon a while ago for myself but you version is alot neater :P


evil please can you read https://vborg.vbsupport.ru/showthread.php?t=58203 ? thanks

[Drowned]

:bowdown: :bowdown: :bowdown: :bowdown: :bowdown:

Best hack EVER!!!!!!!!! :surprised: Are you planning on working a version for vb3? Please say yes! :nervous: hehehehe...

[EvilLS1]

corsacrazy,
I would take a look at what Zed has offered if I were you.. His hacks are usually great and it can probably be altered to do exactly what you want. Something like that would require some time to make and right now my own "to do" list is pretty long.

Drowned,
Thanks. I don't plan on upgrading my own forum to VB3 but I do have it running on my PC. So I'll probably port over this hack and a couple of others whenever it goes final. That is if they release it before my membership expires.

[SVTOA]

Yea, it figures... I have been asking about this for a LONG time, nobody would help me. So I did my own version. Yours is obviously much better. I just kinda hacked up memberlist.php and added Chen's custom profile search hack. You can see it here:
http://www.mustangcentral.net/mcforu...trmilelist.php


Great job, awesome hack...

[EvilLS1]

SVTOA,
Thanks. I think your version looks great too.

I had been wanting this hack for a while also but was just too lazy to make it. Previously we just had a thread in our drag racing forum where members posted their best ETs and were ranked on a list (manually).. But our ET thread got deleted a couple of weeks ago so I decided to go ahead and make the timeslips script rather than start a new one.

[oly51]

Great hack, EvilLS1. Very clean!!

I'm trying to tweak it to be a VIN and car info registry so we can end up with a page that will list by VIN when in the production cycle certain changes were introduced.

How can it be set up so a member can have multiple cars listed?

Also, could I create a user called say, 'Unknown' and enter data that I have gathered from 150 or so cars?

[SVTOA]

Originally Posted by EvilLS1

SVTOA,
Thanks. I think your version looks great too.

I had been wanting this hack for a while also but was just too lazy to make it. Previously we just had a thread in our drag racing forum where members posted their best ETs and were ranked on a list (manually).. But our ET thread got deleted a couple of weeks ago so I decided to go ahead and make the timeslips script rather than start a new one.

The "static" 1/4 mile list is a staple all over the place. Some person has to be put in charge of it and then the members have to wait/rely on that person to post updates. That is what prompted me to do mine. It just kinda sucks because as I said, I had asked all around if anyone had a script like this and got a pretty lukewarm response to my inquiries.
I got the idea that I could probably make something out of the member list, but you have no idea how long I played with this thing to get it work like it does now. Chen was kind enough to point me to the "search custom profile fields" hack, and that was key in getting what I visualized in my minds eye to appear onscreen.

I just happened to pop in here and your subject caught my eye. I am sure there are plenty of people who will want that feature and make use of your hard work. Props are in order sir, nice going...!

[EvilLS1]

oly51,
Adding new fields to sort by is easy. Just add the new field in your admin control panel as usual, then make a note of the field ID#..

Then add a new section of code below where it says "// Do sorting methods" in timeslips.php something like this:

} else if ($action=="VIN") {
  $cond.=" WHERE userfield.fieldXX>'".intval($number)."'";
  $condition.=" AND userfield.fieldXX>'".intval($number)."'";
  $orderby="userfield.fieldXX";
  $direction=ASC;

Just replace the fieldXX with the correct IDs for the new VIN field you added.

Then add the new URL to the drop down menu for sorting:
$bburl/timeslips.php?action=vin

If you wanted to show the VIN # on the page you would just add this below to the "// Set up vars" section of code:

$vin= $userinfo[fieldXX];

Replace the XX with the ID for your field, then add $vin to your timeslipsbit template and it'll show up..

It works the same way for adding more fields for multiple cars.

I'm not sure what you mean about adding the "unknown" user and all that info. But hopefully this helps with the other stuff. Good luck with customizing it.

[oly51]

Thanks for the quick reply and the code and sorting help.

As for the multiple cars...
Some of my members have 3 or more cars they would enter the info on. (I have 6) Plus I have VIN and other info from 150 or so cars that I have gathered over the years whose owners are not members. Could these be entered on the "Vehicle Profile" page?