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.

[Mobo]

Great Hack!! Just installed it with the ET&Trap in the postbit with no probs at all!! Well done.

I do have one question. Would it be possible to make it were only users or a certain User group should show up on the main list (timeslip.php)? My site has normal users and paid members, and I'd like for this to be an extra feature that the paid members have.

Thanks for the great Hack!

[Mobo]

Okay, I ran into a problem. When I tried to put a link to the timeslip.php file on my forum, ithe page is not found. I added a button int the Head section (forum styles). This what I added...

<a href="timeslips.php?s=$session[sessionhash]"><img src="{imagesfolder}/top_carinfo.gif" alt="Timeslips, Mods and HP!!" border="0"></a>

[EvilLS1]

Originally Posted by Mobo

Great Hack!! Just installed it with the ET&Trap in the postbit with no probs at all!! Well done.

I do have one question. Would it be possible to make it were only users or a certain User group should show up on the main list (timeslip.php)? My site has normal users and paid members, and I'd like for this to be an extra feature that the paid members have.

Thanks for the great Hack!

Just change the queries in timeslips.php so that it only selects from your specified usergroup like this:

Find:

// Get total number of users
  $userscount=$DB_site->query_first("SELECT COUNT(*) AS users
                                     FROM user,userfield
                                     $cond 
                                     AND user.userid = userfield.userid");

Replace it with:

// Get total number of users
  $userscount=$DB_site->query_first("SELECT COUNT(*) AS users
                                     FROM user,userfield
                                     $cond 
                                     AND user.userid = userfield.userid AND user.usergroupid = X");

Change the X to the usergroupid in this bit of code: user.usergroupid = X

Then find:

// Get users
$users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE user.userid = userfield.userid
                          $condition   
                          ORDER BY $orderby $direction
                          LIMIT $pos,$perpage");

Replace it with:

// Get users
$users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE user.userid = userfield.userid
                          AND user.usergroupid = X
                          $condition   
                          ORDER BY $orderby $direction
                          LIMIT $pos,$perpage");

Again, change the X in the code above to the usergroupid.

Okay, I ran into a problem. When I tried to put a link to the timeslip.php file on my forum, ithe page is not found. I added a button int the Head section (forum styles). This what I added...

<a href="timeslips.php?s=$session[sessionhash]"><img src="{imagesfolder}/top_carinfo.gif" alt="Timeslips, Mods and HP!!" border="0"></a>

Is this in your forum directory? Try adding $bburl/ before timeslips.php. If that doesn't work just add the full url. If you can go to the page manually its gotta be just a typo in the URL or timeslips.php isn't in that directory.

[Mobo]

Originally Posted by EvilLS1

Just change the queries in timeslips.php so that it only selects from your specified usergroup like this:

Find:

// Get total number of users
  $userscount=$DB_site->query_first("SELECT COUNT(*) AS users
                                     FROM user,userfield
                                     $cond 
                                     AND user.userid = userfield.userid");

Replace it with:

// Get total number of users
  $userscount=$DB_site->query_first("SELECT COUNT(*) AS users
                                     FROM user,userfield
                                     $cond 
                                     AND user.userid = userfield.userid AND user.usergroupid = X");

Change the X to the usergroupid in this bit of code: user.usergroupid = X

Then find:

// Get users
$users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE user.userid = userfield.userid
                          $condition   
                          ORDER BY $orderby $direction
                          LIMIT $pos,$perpage");

Replace it with:

// Get users
$users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE user.userid = userfield.userid
                          AND user.usergroupid = X
                          $condition   
                          ORDER BY $orderby $direction
                          LIMIT $pos,$perpage");

Again, change the X in the code above to the usergroupid.


Is this in your forum directory? Try adding $bburl/ before timeslips.php. If that doesn't work just add the full url. If you can go to the page manually its gotta be just a typo in the URL or timeslips.php isn't in that directory.

EvilLS1 great support for a great hack. Thanks for the quick replies and help. I'll give them a shot.

[Mobo]

Adding $bburl/ in front of it made it work thanks! Also, the paid members only thing worked as well. Is it possible to add more then one usergroupid to it? So that say paid members and club officers could have their stats show up? Or can you assign a user to more then on usergroup?

[EvilLS1]

n/p.

Is it possible to add more then one usergroupid to it?

Yes, just use this instead of the other code:

AND user.usergroupid IN (X,X,X)

Replace the X's with the usergroupids. You can add as many as you'd like.. Just separate each one with a comma.

[Mobo]

Cool, thanks a million!

[EvilLS1]

Anytime.

[Tungsten]

This is an excellent add-on, EvilLS1. Check your PM, I'd like to slide a little something into your PayPal account for sharing this with everyone. We've been trying unsuccessfully to code a timeslip db for our site for a while now and you just took a major load off of our non-programming asses.

[EvilLS1]

Tungsten,
I'm glad you like it. And thank you very much for offering a donation, but thats not necessary. A simple "thanks" is enough payment for me. I use alot of hacks that others have released here, so sharing my own hacks is my way of saying thanks to the vb.org community. Plus, I'm always happy to help out a fellow car enthusiast.

Enjoy the hack, my friend.