The Arcive of Official vBulletin Modifications Site.

vB Timeslip Database -for Automotive websites · **Released**: 10-20-2003

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.

glo · #32 10-25-2003, 12:57 AM

Hey EvilLS1, good work!

"Clicks Install"

Do you know how i can add an extra field for a drop down menu for "Vehicle Make"

EvilLS1 · #33 10-25-2003, 01:29 AM

Thanks glo.

Yes its easy to add an extra field for a drop down menu. I have one myself.

If you haven't already done so, install this hack (adds ability to make drop down menus in custom profile fields). Look in the last couple of pages of that thread to find updated instructions for later versions of vbulletin.

Anyway, once you've added that hack, go into your admin panel and add the new profile field w/ drop down menu.

Then hold your mouse over the "edit" link for the new field and make a note of the field ID # (at the end of the URL).

Then open timeslips.php and find:

Code:

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

Below it add:

Code:

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

In the code above, replace the red Xs with the ID# of the new field you added.

Still in timeslips.php find:

Code:

$ride= $userinfo[field50];

Below it add:

Code:

$make= $userinfo[fieldXX];

Again, replace the red Xs with the ID# of the new field you added.

Now in your "timeslips" template find:

Code:

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

Below it add:

Code:

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

Find:

Code:

	<td bgcolor="{categorybackcolor}" colspan="8"><normalfont color="{categoryfontcolor}"><CENTER><b> Timeslip Database</b></CENTER></normalfont></td>

Replace it with:

Code:

	<td bgcolor="{categorybackcolor}" colspan="9"><normalfont color="{categoryfontcolor}"><CENTER><b> Timeslip Database</b></CENTER></normalfont></td>

Find:

Code:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>Username</b></smallfont></td>

Below it add:

Code:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>Vehicle Make</b></smallfont></td>

Find:

Code:

<td bgcolor="{categorybackcolor}" colspan="8">

Replace it with:

Code:

<td bgcolor="{categorybackcolor}" colspan="9">

In your "timeslipsbit" template find:

Code:

<td bgcolor="{secondaltcolor}"><normalfont><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$userinfo[userid]">$username</a></normalfont></td>

Below it add:

Code:

<td bgcolor="{firstaltcolor}">$make</td>

That will add the extra vehicle make info to the timeslips page and allow you to sort by it (alphabetically). You can experiment with the code a little and make it sort differently or whatever you want.

Dewayne

corsacrazy · #34 10-25-2003, 03:29 PM

im good at ideas and you are a great hacker, thank you my friend

EvilLS1 · #35 10-25-2003, 04:26 PM

Thanks corsa. That was a nice idea.

BTW, I made a small addition to the hack. Now the timeslips page will put brackets around the catagory that is currently being sorted by.
Example (sorting by 1/4):
Username - Ride - RWHP - 60' - 1/8 mile ET - [1/4 Mile ET] - Slip

I updated the zip in the first post.. To upgrade just replace your timeslips template with the new one, then upload the new timeslips.php.

NickCat · #36 10-25-2003, 05:02 PM

*clicks install*

Thanks EvilLS1... Great Hack.

I just installed it on my board this morning. I had to make a few small modifications though. I changed RWHP to WHP (Subaru website... AWD cars) and I already had car info in the user profiles to I pulled that info instead or the new 'Ride' field.

Teriffic hack though, I hope my members like using it.

The only request I might make would be if it were possible to allow the timeslips to be uploaded like an attachment. Since you know users tend to change image hosts all the time, and or delete stuff.

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

MaxScript · #37 10-25-2003, 05:09 PM

***vb3***?

EvilLS1 · #38 10-25-2003, 09:47 PM

NickCat,
Thanks.

And sorry about the RWHP thing.. I just copied the template from my own site (about 99% of my members have rwd cars).

Anyway, I will probably add the upload feature to v2.0. But for now, you could do what I do.. Next to the timeslip link field I posted a link to a thread in my drag racing forum that says "upload your images here". They can upload the images in that thread and then just put a link to the attachment in the field.

MaxScript,
I'll probably update this hack and a couple of others for VB3 once it goes final. Should be fairly easy to do.

MaxScript · #39 10-25-2003, 09:48 PM

Quote:

Originally Posted by EvilLS1

NickCat,
Thanks.

And sorry about the RWHP thing.. I just copied the template from my own site (about 99% of my members have rwd cars).

Anyway, I will probably add the upload feature to v2.0. But for now, you could do what I do.. Next to the timeslip link field I posted a link to a thread in my drag racing forum that says "upload your images here". They can upload the images in that thread and then just put a link to the attachment in the field.

MaxScript,
I'll probably update this hack and a couple of others for VB3 once it goes final. Should be fairly easy to do.

great thanks

NickCat · #40 10-25-2003, 11:04 PM

Quote:

Originally Posted by EvilLS1

NickCat,
Thanks.

And sorry about the RWHP thing.. I just copied the template from my own site (about 99% of my members have rwd cars).

Anyway, I will probably add the upload feature to v2.0. But for now, you could do what I do.. Next to the timeslip link field I posted a link to a thread in my drag racing forum that says "upload your images here". They can upload the images in that thread and then just put a link to the attachment in the field.

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/

EvilLS1 · #41 10-26-2003, 06:58 PM

NOTE: This comes standard with version 1.3!

Add-on: Separate "Vehicle Profile" page for submitting Timeslip Data.

Description: This add-on will remove the timeslip fields from your edit profle & registration pages and put them in thier own separate catagory called "Vehicle Profile".

This should help cut down the number of users who submit false data when registering or editing their profile since the vehicle info is edited on a completely separate page.

Instructions and screenshot attached:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05229 seconds Memory Usage 2,342KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (14)bbcode_code (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!