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.

[PKRWUD]

Damn, you're good. I forgot the second "s" in the name of the timeslipsbit template.

*clicks Install with immense pleasure!*

Please tell me you have other hacks, yours work great, and your instructions are excellent, especially to a know-nothing like me. I really like this hack, and the ease with which I installed it.

Thanks again!

Take care,
~Chris

[EvilLS1]

Thanks Chris. Glad its working for you now.

[SVTOA]

Originally Posted by EvilLS1

I also added this to the Timeslip Database hack. Check the demo (my site) to see it. Thanks to brendonm and SVTOA for the idea.

I don't know what all the drama in this thread is about, and I don't want anyone speaking for me. I know that EvilLS1 has done a GREAT job with his hack. I do not see what he has done as "copying" my idea, and I think the level of support he has offered to those who want to use his creation is A-1 TOP NOTCH and he should be commended for same.

He thanked me and brendonm for ideas, that's an indication of a stand-up guy. I have had some people on other boards accuse me of copying HIS idea, such is life I guess. The bottom line is, when people take the time to help others improve their forums, it's all good.

My version of this hack is nowhere near as comprehensive as Evil's is...
I have made some changes to it, so it loads faster with less draw on the database...

http://www.mach-1.org/vbulletin/quartermileranking.php?s=&action=getall&what=&ltr= &perpage=25&orderby=field6&ausername=&=&direction= ASC&fields[6]=.&pagenumber=1


You have to copy and paste the link to have it work for you...

EvilLS1- take a bow, you have done a GREAT job on this and that is all there is to it. Only thing I can say is, I wish that you had done all this back when I was asking for something like this.. NOBODY replied to my hack request, so I kinda started one of my own... In hindsight, it kind of forced me to learn more about PHP and that's a good thing.

Peace and Happy Holidays!

Greg

[SVTOA]

Originally Posted by EvilLS1

sunrunner_pei,

In admin/functions.php find:

$jointime = (time() - $post[joindate]) / 86400; // Days Joined

Above it add:

if ($post[field55]>0){
  $postquarter= $post[field55];
}else{
  $postquarter="";
}
if ($post[field56]>0){
  $postatmph= "@";
  $postmph= $post[field56];
}else{
  $postatmph="";
  $postmph="";
}

Then in your postbit template put this where you want the 1/4 mile ET to show up.:

$postquarter$postatmph$postmph

This way it will only show up if an ET has been entered by the user.

That's awesome- to add: The way that is written, it will only display the ET/MPH. If you want to add some text such as "Best ET" to display along with the stats, add:

$posttext= "Best ET";

to the line above

$postatmph= "@";

Then add:

$posttext$postquarter$postatmph$postmph

to your postbit in the area where you want this to display.

[Imprezer]

Great hack!

Installed.

My peeps will like it.

Alex
www.i-club.com

[Carnage Media]

Installed and awesome!

what if you wanted to add another category getting people to tell what kind of suspension they have

like:
stock
tubbed
etc.

maybe in a drop down box?

also, how do you edit in case somebody puts something false in?

Thanks again Evil, I love this one.

[SVTBlackLight01]

Hey Evil,

Have you looked into making this hack for vb3?

[EvilLS1]

Carnage,
Thank you.
To add other fields check these two posts:
https://vborg.vbsupport.ru/showpost....0&postcount=32
https://vborg.vbsupport.ru/showpost....&postcount=136

also, how do you edit in case somebody puts something false in?

You simply go into your admin panel and edit that user as you normally would. His timeslip info will be listed there.

Have you looked into making this hack for vb3?

I plan to within the next few weeks.. I just haven't had enough time to look into it yet (still using VB2).

[SVTBlackLight01]

Sounds great. Still using VB2 here too. I probably won't be upgrading for a while.

[sticky]

I can't believe I just found this, I wanted something just like this a few months ago on my forum but I thought it would be too complicated for anyone to ever do. This is the greatest hack in the world.