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.

[ImportPassion]

in the separate page for to edit timeslip data instructions, there is an error

PHP Code:

###### Replace with:
  $profilefields=$DB_site->query("SELECT profilefieldid,required,title,size,maxlength
                                  FROM profilefield
                                  WHERE editable = 1
                                  AND profilefieldid NOT IN (50,51,52,53,54,55,56,57"); 


should be

PHP Code:

###### Replace with:
  $profilefields=$DB_site->query("SELECT profilefieldid,required,title,size,maxlength
                                  FROM profilefield
                                  WHERE editable = 1
                                  AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)"); 


also, in this section

PHP Code:

  $templatesused = 'redirect_updatethanks,error_fieldmissing,error_emailmismatch,error_emailtaken,error_fieldmissing,error_requiredfieldmissing,error_birthdayfield'; 


I don't think half these templates are actually used?

Still installing all the updates and fixes. Let you know the outcome soon.

One thing I will be adding for admins and possibly mods is a delete button to delete fake crap. It's already starting. :disappointed:

[EvilLS1]

7thgenCivic.Com,
Nice catch on the missing ). The profile fieldID #s on my own site are different than the ones posted in the hack instructions here. So I must have accidentally deleted it when I changed the IDs for the hack.

As for the templates used in the "updatetimeslip" action, those are just left overs from where I copied that bit of code from the original "updateprofile" action. I forgot to remove them, but it wouldn't hurt anything to leave them there. I just updated the instructions and removed them so not to cause any confusion though. Also added the missing ) to the query. Thanks again for pointing it out.

One thing I will be adding for admins and possibly mods is a delete button to delete fake crap. It's already starting.

That sounds like a good idea.

I was thinking about making it possible to ban users from the "edit vehicle profile" page. This should help root out the users who insist on entering false data just to be funny.
If you want, I'll post the instructions for that addon here whenever I get around to making it.

[drumsy]

What's up with my font and table color???

www.honda-acura.net/forums/timeslips.php

[drumsy]

Fixed, had to modify templates.

[drumsy]

Originally Posted by EvilLS1

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:

Do you have instructions on how to do this for a 2.3.2 version? The lines are not matching up on my register.php page and I'm not comfortable trying to manually do it.

[EvilLS1]

drumsy,
Not sure why you had to edit the font and table color. Unless the replacements are different in 2.3.2, the hack should use the same font & table colors as the rest of your board.

I looked at a copy of register.php from 2.3.2, and the code is the same.. 2.3.2 just has some line breaks in different places.

In register.php Find:

	$profilefields = $DB_site->query("
		SELECT * FROM profilefield
		WHERE editable = 1 ORDER BY displayorder
	");

Replace with:

  $profilefields=$DB_site->query("SELECT *
                                  FROM profilefield
                                  WHERE editable = 1
                                  AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)       
                                  ORDER BY displayorder");

Find:

  $profilefields=$DB_site->query("SELECT maxlength,profilefieldid,required,title
                                  FROM profilefield
                                  WHERE editable = 1
                                  ORDER BY displayorder");

Replace with:

  $profilefields=$DB_site->query("SELECT maxlength,profilefieldid,required,title
                                  FROM profilefield
                                  WHERE editable = 1
                                  AND profilefieldid NOT IN (50,51,52,53,54,55,56,57) 
                                  ORDER BY displayorder");

Then follow the rest of the hack instructions for editing member.php.

[SIINSI]

Awesome hack, thanks alot for this... Installed on http://www.jdmuniverse.com

Thanks again

[EvilLS1]

Thanks SIINSI. Glad you like it.

[drumsy]

Gracias senor for the code! :thumbup:

[EvilLS1]

NOTE: This comes standard with version 1.3!

Add-on: Ban users from editing their Vehicle Profile (Timeslip Info)

Description: This add-on will allow you to 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.

I suggest putting a warning at the top of your Edit Vehicle Profile page that says something like "Vehicle Profile privileges will be taken away from users who enter false data". Then if they do it anyway, 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 provile.

To use this add-on you must already have the Vehicle Profile add-on installed.

Instructions attached: