vB Timeslip Database -for Automotive websites

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.

[Dj22]

i could be wrong but when i installed this users were able to upload avatars as big as timeslips..

its seems to be the graphic type it enables it for a larger size in the functions_upload file?

i turned it back to the original one and it worked for the avatars

[EvilLS1]

Originally Posted by Dj22

i could be wrong but when i installed this users were able to upload avatars as big as timeslips..

its seems to be the graphic type it enables it for a larger size in the functions_upload file?

i turned it back to the original one and it worked for the avatars

Ah, I know what the problem is. At some point the $permissions variable was changed to $imagepermissions in the functions_upload.php file. I copied that bit from my test board which is running RC1.. I believe this was changed in RC2 or RC3.

Anyway, heres the fix (only needed if you have v2.1):

In includes/functions_upload.php find:

    if ($type=="timeslippic") {
        $maxwidth=$vboptions[tdmaxwidth];
        $maxheight=$vboptions[tdmaxheight];
        $maxsize=$vboptions[tdmaxsize];
    } else {
        // get maximum filesize/dimensions etc.
        $maxwidth = &$permissions[$type . 'maxwidth'];
        $maxheight = &$permissions[$type . 'maxheight'];
        $maxsize = &$permissions[$type . 'maxsize'];
    }

Replace it with:

    if ($type=="timeslippic") {
        $maxwidth=$vboptions[tdmaxwidth];
        $maxheight=$vboptions[tdmaxheight];
        $maxsize=$vboptions[tdmaxsize];
    } else {
        // get maximum filesize/dimensions etc.
        $maxwidth = &$imagepermissions[$type . 'maxwidth'];
        $maxheight = &$imagepermissions[$type . 'maxheight'];
        $maxsize = &$imagepermissions[$type . 'maxsize'];
    }

I updated the hack instructions. Thanks for pointing this out.

[dcevoclub]

ok i added a new column to the userfield database, however i can't seem to find where this adds the variables, or inserts them to the database? this is for the "classing" addon that i asked for help 2 days ago.

i added 1 line to profilefields, and now

Warning: Invalid argument supplied for foreach() in /home/dsmdragtimes/includes/functions_user.php on line 575

[EvilLS1]

Originally Posted by dcevoclub

ok i added a new column to the userfield database, however i can't seem to find where this adds the variables, or inserts them to the database?

dcevoclub,
I'm still not clear on exactly what you're trying to do. If you can give me a better description I'll try to help you when I get time.

If I'm understanding correctly, you want to add a drop down menu to the edit vehicle profile page which allows the user to select a class. Then you want to add the ability to sort by classes to timeslips.php? If so, tell me the name of each class that can be selected.

Also, it would be much easier for me to just add this myself rather than trying to explain how to add it. If you'll set me up a temporary admin account and FTP account I'll add it for you.

Originally Posted by dcevoclub

this is for the "classing" addon that i asked for help 2 days ago.

I do appologize and I wasn't trying to ignore your request, but as I stated in the first post of this thread:

"Support:
I will support basic installation and troubleshooting only. I will not be offering support for customizing or adding new features."

It would be nearly impossible for me to help customize this hack for everyone who installs it. I work 6 days per week and simply don't have time.

[dcevoclub]

Originally Posted by EvilLS1

dcevoclub,
I'm still not clear on exactly what you're trying to do. If you can give me a better description I'll try to help you when I get time.

If I'm understanding correctly, you want to add a drop down menu to the edit vehicle profile page which allows the user to select a class. Then you want to add the ability to sort by classes to timeslips.php? If so, tell me the name of each class that can be selected.

Also, it would be much easier for me to just add this myself rather than trying to explain how to add it. If you'll set me up a temporary admin account and FTP account I'll add it for you.


I do appologize and I wasn't trying to ignore your request, but as I stated in the first post of this thread:

"Support:
I will support basic installation and troubleshooting only. I will not be offering support for customizing or adding new features."

It would be nearly impossible for me to help customize this hack for everyone who installs it. I work 6 days per week and simply don't have time.

sorry... what files do you need to edit so i can arrange for them to be "editable" but yes, thats all i want, is to have different classing, for lets say, street, and full drag or whatever.

[EvilLS1]

Originally Posted by dcevoclub

sorry... what files do you need to edit so i can arrange for them to be "editable" but yes, thats all i want, is to have different classing, for lets say, street, and full drag or whatever.

member.php, includes/functions_user.php, and timeslips.php.

Also, I need to know the exact name of all classes that you want availible in the drop down menu.

You can email me at webmaster@modernmusclecars.net

[EvilLS1]

dcevoclub,

First go to your admincp and add a new custom profile field. The names of the classes must be exactly as I list them or it won't work when sorting on the timeslips page.

Go to: admincp >> User Profile Fields >> Add New User Profile Field

Profile Field Type: Single Selection Menu

Click Continue.

Title: Class
Description: whatever you want

Options:
Street
Outlaw
Full Drag

Set Default: Yes, include a first blank option.

Display Order: Whatever you want

Field Required: No

Field Editable by User? Yes

Field Hidden on Profile? No

Field Searchable on Members List? No

Show on Members List? No

Allow user to input their own value for this option? No

Max length of allowed user input: 15

Display Size: 15

Regular Expression: 0

Which page displays this option? Edit Profile

Click Save.


Now on the next screen (the user profile field manager screen) find the new field that you just added. Over to the right of the new field you'll see a link that says [Edit]. Hold your mouse over that link (don't click it) and look at the bottom of your browser where it shows the url. Make a note of the field ID # for the field you just added.

Assuming that you're still using v2.0 in member.php and includes/functions_user.php find all instances of this (there will be several):

(50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65)

Now in the code below replace the XX with the field ID of the new class field.. Then copy the code below and replace ALL instances of the code above in member.php and includes/functions_user.php:

(50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,XX)

Save & upload.

Now open timeslips.php and find this:

$natasp='N/A';

Below it add this:

$street = 'Street';
$outlaw = 'Outlaw';
$drag = 'Full Drag';

Still in timeslips.php find:

   }
    else if ($_REQUEST['do'] == 'na') 
   {
        $condition.=" AND userfield.field65='$natasp' AND userfield.field55>'".intval($number)."'";
        $cond.=" WHERE userfield.field55!=''";
        $orderby="userfield.field55";
        $direction=ASC;
        $bracket13="<b>[</b>";
        $bracket14="<b>]</b>";

Below it add:

   }
    else if ($_REQUEST['do'] == 'street') 
   {
        $condition.=" AND userfield.fieldXX='$street' AND userfield.field55>'".intval($number)."'";
        $cond.=" WHERE userfield.field55!=''";
        $orderby="userfield.field55";
        $direction=ASC;
        $bracket133="<b>[</b>";
        $bracket143="<b>]</b>";
   }
    else if ($_REQUEST['do'] == 'outlaw') 
   {
        $condition.=" AND userfield.fieldXX='$outlaw' AND userfield.field55>'".intval($number)."'";
        $cond.=" WHERE userfield.field55!=''";
        $orderby="userfield.field55";
        $direction=ASC;
        $bracket133="<b>[</b>";
        $bracket143="<b>]</b>";
   }
    else if ($_REQUEST['do'] == 'drag') 
   {
        $condition.=" AND userfield.fieldXX='$drag' AND userfield.field55>'".intval($number)."'";
        $cond.=" WHERE userfield.field55!=''";
        $orderby="userfield.field55";
        $direction=ASC;
        $bracket133="<b>[</b>";
        $bracket143="<b>]</b>";

Now in the chunk of code above find all 3 instances of XX and replace it with the field ID for the new class field.


Still in timeslips.php find:

$spacer=" - ";

Below it add:

$class = "---";

Find:

$pos++;

Below it add:

$class = $userinfo[fieldXX];

Again, replace the XX in the code above with the field ID for the class field.


Save and upload timeslips.php

In your timeslips template find:

<td bgcolor="{categorybackcolor}" colspan="5" class="tcat"><b> Timeslip Database

Replace it with:

<td bgcolor="{categorybackcolor}" colspan="6" class="tcat"><b> Timeslip Database

Find:

<option value="timeslips.php?$session[sessionurl]&do=na">N/A cars only</option>

Below it add:

<option value="timeslips.php?$session[sessionurl]&do=street">Street Class</option>
<option value="timeslips.php?$session[sessionurl]&do=outlaw">Outlaw Class</option>
<option value="timeslips.php?$session[sessionurl]&do=drag">Full Drag Class</option>

Find:

<td class="thead" align="center">$bracket13<b>Induction</b>$bracket14</td>

Below it add:

<td class="thead" align="center">$bracket133<b>Class</b>$bracket143</td>

Find:

<td class="tfoot" colspan="10">

Replace it with:

<td class="tfoot" colspan="11">

In your timeslipsbit template find:

<td class="alt2">$induction</td>

Below it add:

<td class="alt1">$class</td>

Thats it! If you added the profile field class names exactly as I said and you replaced all of the XXs with the correct field ID it will work.


Now you know why I said it would be much easier if I just do it myself.

[dcevoclub]

ok thanks man, i got it in, but when you go to submit time slip it doesn't show, on the main page it shows the "class" column... do i need to edit profile.php?

[EvilLS1]

Originally Posted by dcevoclub

ok thanks man, i got it in, but when you go to submit time slip it doesn't show, on the main page it shows the "class" column... do i need to edit profile.php?

No edits to profile.php are needed. Also this has no effect on showing the timeslips. Did you make other changes earlier that need to be removed? If not, go back and re-check all of the edits to make sure they're correct. If you didn't miss anything it will work.

[dcevoclub]

Originally Posted by EvilLS1

No edits to profile.php are needed. Also this has no effect on showing the timeslips. Did you make other changes earlier that need to be removed? If not, go back and re-check all of the edits to make sure they're correct. If you didn't miss anything it will work.

i wiped everything out and re-installed from scratch, and follwed the instructions there is still not dropbox in the edit profile for the class under induction which is where is suppose to be right?