The Arcive of Official vBulletin Modifications Site.

vB Timeslip Database -for Automotive websites · **Released**: 01-29-2004

This is the newest version of my Timeslip Database hack. If you don't have an automobile related website ya might as well stop reading here because this will probably be of no use to you.. But if you do, read on!

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, engine, tranny, tires, horsepower, best 60' time, 1/8 mile time, 1/4 mile time, upload thier 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 vehicle 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.

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)
-N/A cars only
-Username
-ET brackets
*Show the average ET, MPH, and HP for your site.
*Vehicle Profile (separate from user profile)
*Ability to ban users from editing their vehicle profile
*Users can upload their timeslip in the vehicle profile. (New!)
*Timeslip uploads can be disabled in the admincp. (New!)
*Admin can delete user's uploaded timeslip. (New!)
*Maximum width, height and filesize for timeslip uploads can be set in the admincp. (New!)
*Admin can set an ET for which a timeslip is required if user's ET is quicker. (New!)
*Installer

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

vb.org member sites w/Timeslip Database installed:
http://srtforums.com/forums/timeslips.php
http://www.fordpower.net/forums/timeslips.php
http://www.al-club3g.org/forums/timeslips.php
http://www.gmvsford.com/forums/timeslips.php
http://board.accordtuner.com/timeslips.php
http://www.240sxforums.com/forums/timeslips.php
http://www.tennesspeed.net/forums/timeslips.php
http://www.socalloc.com/forums/timeslips.php
http://www.lincolnvscadillac.com/timeslips.php
http://fordvschevy.com/forum/timeslips.php
http://www.skylinesaustralia.com/forums/timeslips.php
http://www.lonestarstangs.com/forum/timeslips.php
http://www.tallahasseemusclecar.com/forum/timeslips.php
http://www.ricehatersclub.com/vbulletin/timeslips.php
http://www.highertuning.com/forums/timeslips.php4
http://www.mx5roadsters.com/forums/timeslips.php
http://www.stangcountry.com/forums/timeslips.php
http://www.lssix.com/forums/timeslips.php
http://gpfanatix.com/forums/timeslips.php
http://tealnet.com/ipw-web/forum/timeslips.php
http://www.eurotechniks.com/forums/timeslips.php
http://k-series.com/forum/timeslips.php
http://www.ymrforums.com/timeslips.php
http://www.modernengineuity.com/forums/timeslips.php
http://t6p.com/forums/timeslips.php
http://www.turborides.com/forums/timeslips.php
http://www.mr2oc.com/timeslips.php
http://host41.hrwebservices.net/~wac...timeslips.php?
http://www.moparstyle.net/forums/timeslips.php
http://www.fullthrottleforums.com/timeslips.php
http://www.ozhonda.com/forum/timeslips.php
http://www.fordforums.com.au/timeslips.php
http://www.commodorecarclubwa.com/timeslips.php
http://www.forabodiesonly.com/mopar/timeslips.php
http://www.carolinarides.com/forum/timeslips.php
http://www.sicgmtrucks.com/forum/timeslips.php
http://www.micra.org.uk/timeslips.php
http://www.carforums.net/

If you'd like me to add a link to your VB3 Timeslip Database for others to see, please post it in this thread.

I've also attached some screenshots from my test board below so that you can see what the standard VB3 version looks like. The screenshots only show 10 entries, but it does have pagination and will display 25 per page by default.

Screenshots:
Timeslips main page
Vehicle Profile
Edit Vehicle Profile
Upload a timeslip
Admincp settings

Installation overview:
Files to edit: (7)- admincp/user.php, image.php, member.php, includes/functions_user.php, profile.php, includes/functions_upload.php, includes/functions_online.php
Files to upload: (3)- TDinstaller.php, timeslips.php, slipicon.gif
Templates to edit: (2)- USERCP_SHELL, navbar
Templates to add: (5)- timeslips, timeslipsbit, getvehicleinfo, timeslips_customfields, modifytimeslip
Phrases to add: (6) *see instructions

Support: (Updated: 8-6-05)
Due to my busy scedule and the release of vB 3.5 this version of the Timeslip Database will no longer be supported or developed. Please do not PM me with questions about when the next version will be released because I honestly have no idea.. But when I do start working on it I'll be sure to let you guys know.
Read more here:
https://vborg.vbsupport.ru/showpost....&postcount=666

Please search this thread before posting questions. Theres a good chance that your question has already been posted and answered.

Also, reading through the old thread for vB Timeslip Database v1.3 can probably answer some of your questions about adding new features or customizing.

The VB2 version of this hack is located here:
https://vborg.vbsupport.ru/showthread.php?t=58076

Add-ons & How to's:
*Show the Top 5 ETs on your vB Advanced Homepage.
*Show the Top 5 ETs on your vB Advanced CMPS page. (by coolmody)
*Show the Top 5 ETs on your vBindex page. (by SVTBlackLight01)
*Change the default sort method
*Show the ET club that users belong to in the postbit.
*Show the 1/4 mile ET in the postbit only for users who have added it.
*Set permissions for editing the Vehicle Profile per usergroup.
*Require a link to the actual timeslip for all ETs that are 11.99 or quicker (for v2.0 only.. this comes standard in v2.1)

This hack has been confirmed to work with vB versions 3.0.0 - 3.0.8.

Many thanks to my beta testers: 350Chevy and Corsacrazy :up:

Version History:
v2.1: -Added the ability for users to upload timeslips in their vehicle profile. Added the ability for admins to require an actual timeslip for specified ETs. New Timeslip Database settings added to the admincp to control maximum upload sizes and turn the upload feature on & off. (current version)
(Check this post for more info about the new features.)
v2.0: -Ported hack over for VB3 and added a few new fields to the vehicle profile.
v1.3: -Added the ability to sort by ET brackets or "clubs". (ie. show 10 second cars only. 11 second cars only, 13 sec cars, etc).
v1.2: -Added a new action that will show the average ET, trap speed, and horsepower for your site.
v1.1: -Added the seperate vehicle profile page to input timeslip data. 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 clicked.
v1.0: -Initial release. (VB2)

NOTE: If you've recently upgraded your forum software and you're having trouble with timeslips.php showing all users (regardless if they have an ET) or it not sorting correcty, Read This!

If you find this script useful please click install.

EvilLS1 · #**332** 08-09-2004, 10:52 AM

Mark,
Just upload this file to your admincp directory and run it:
https://vborg.vbsupport.ru/attachmen...chmentid=19550

This will set the fields to decimal with the correct parameters for you.

Limey-YMR · #**333** 08-11-2004, 12:48 AM

Quote:

Originally Posted by EvilLS1

Mark,
Just upload this file to your admincp directory and run it:
https://vborg.vbsupport.ru/attachmen...chmentid=19550

This will set the fields to decimal with the correct parameters for you.

Thanks a lot! that worked like a charm.
thankfully I only have two nine second cars on the board, so removing the zeros will be trivial

EvilLS1 · #**334** 08-11-2004, 11:51 AM

Quote:

Originally Posted by Limey-YMR

Thanks a lot! that worked like a charm.
thankfully I only have two nine second cars on the board, so removing the zeros will be trivial

Cool, glad ya got it worked out. At least you have a couple of single digit cars on your site. I think the quickest car @ my forum is 10.70something. Theres a few members who have single digit cars but they haven't bothered to put their times in the database for whatever reason.

coolmody · #**335** 09-05-2004, 10:47 PM

Hey guys,

Not sure if anyone has done this yet, but I modified it to work with vBAdvanced CMPS. Most of the work was done by EvilS1. He was just missing a line at the end which should get it to work.

Code:

Instructions:

1. Upload this NEW toptimes.php file to your modules directory

2. Create a new template named "adv_portal_toptimes" and add the HTML below:

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<tr id="cat">
	<td colspan="5" class="tcat" width="100%"><span class="smallfont"><b>?Top Five 1/4 Mile ETs</b></span></td>
</tr>
<tr>
<td class="alt2" align="center"><span class="smallfont"><b>#</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>Username</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>Ride</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>60'</b></span></td>
	<td class="alt2" align="center"><span class="smallfont"><b>1/4 Mile ET &MPH </b></span></td>
</tr>
$times
</tr>
	<td class="tcat" colspan="5"><span class="smallfont"><CENTER>[<a href=$vboptions[bburl]/timeslips.php>Click here to view the complete list</a>]</CENTER></span></td>
</tr>
</table>
<br />

3. Create a new template named "adv_portal_times" and add the HTML below:

<tr>
<td class="alt1" align="center"><span class="smallfont">$rank</span></td>
<td class="alt1" align="center"><span class="smallfont"><a href="$vboptions[bburl]/member.php?$session[sessionurl]u=$userinfo[userid]">$TDusername</a></span></td>
<td class="alt1" align="center"><span class="smallfont">$ride</span></td>
<td class="alt1" align="center"><span class="smallfont">$sixty</span></td>
<td class="alt1" align="center"><span class="smallfont">$quarter$atmph2$quartermph</span></td>

4. Goto your vBa CMPS menu and select "add module".

5. Enter 'Timeslips' under Module Title.

6. Leave Module Identifier blank (unless you don't want to).

7. Use toptimes.php as your File to Include.

8. Make Active.

9. Put it in the Center Column.

10. Put whichever order you like.

11. Leave templates used blank.

12. Click save.

Hope this works out for you guys.

I got a working demo at my site:

Albertacars.net

EvilLS1 · #**336** 09-05-2004, 11:32 PM

Nice job coolmody! Added a link to your instructions in the first post.

SVTBlackLight01 · #**337** 09-05-2004, 11:39 PM

I am trying to add this to vBindex. What needs to be changed in toptimes.php so it will work outside the modules directory?

joeychgo · #**338** 09-05-2004, 11:47 PM

Hey evil ---

Ive had a problem since the beginning....... I have adcolumns hack running and for some reason, the Adcolumn on the timeslips page doesnt come up on the side, it comes up below. This is the only page this happens on -- can you help?

http://www.lincolnvscadillac.com/timeslips.php

EvilLS1 · #**339** 09-06-2004, 12:24 AM

SVT,
Did you try coolmody's version? He attached a zip file with a new toptimes.php.

Joey,
In your timeslips template find this:

Code:

</table>
</table>
<font size="1"><a href="profile.php?&do=edittimeslip">Submit your timeslip data</a></font>
</td></tr></table>

Replace it with this:

Code:

</table>
<font size="1"><a href="profile.php?&do=edittimeslip">Submit your timeslip data</a></font>
</td></tr></table>

joeychgo · #**340** 09-06-2004, 12:29 AM

You rock dude!

Thanks so much!

SVTBlackLight01 · #**341** 09-06-2004, 12:40 AM

Evil,

vBindex is completely different. Basically you have to make it a stand alone file and then include it in the template.

I have it just about worked out, but it's only returning the first time. Here is what my toptimes.php looks like (the part that matters)

PHP Code:


			
require_once('./global.php');





$pos = 0;

$users=$DB_site->query("SELECT *

                          FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield

                          WHERE user.userid = userfield.userid

                          AND userfield.field55>0

                          ORDER BY userfield.field55 ASC

                          LIMIT 5");



// Set up vars

while($userinfo=$DB_site->fetch_array($users)) {

    $pos++;

    $rank= number_format($pos);

    $TDusername= $userinfo[username];

    $year= $userinfo[field5];

    $model= $userinfo[field8];

    $trim= $userinfo[field9];



    if($userinfo[field52] > 0) {

        $sixty= $userinfo[field52];

        }

    else {

        $sixty="";

        }



    if($userinfo[field55] > 0) {

        $quarter= $userinfo[field55];

        }

    else {

        $quarter="";

        }



    if($userinfo[field56] > 0) {

        $atmph2="@";

        }

    else {

        $atmph2="";

        }



    if($userinfo[field56] > 0) {

        $quartermph= $userinfo[field56];

        }

    else {

        $quartermph="";

    }

    eval('$times .= "' . fetch_template('vbindex_times') . '";');

    eval('print_output("' . fetch_template('vbindex_toptimes') . '");');

}

?>

You can see it on my site: http://www.modernengineuity.com

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08200 seconds Memory Usage 2,361KB Queries Executed 25 (?)
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 (3)bbcode_code (1)bbcode_php (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 (2)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_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!