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.

[Silver_2000_)!]

It seems that the settings for "Can edit Vehicle Profile?" and "Can View Private Custom Fields" options are linked - The ONLY way i can get both to says YES is to ONLY check the top one.


Also if I try to make the RIDES field required it drops off the http://www.url/forum/profile.php?do=edittimeslip page - it just disappears...

Actually ANY field I try to make required disappears - BUT when you try to submit it tells you "You have not completed the required field "Track Name" and of course you cant see the field ... LOL

Doug

[EvilLS1]

Doug,
Is the "Can view custom private fields" something you added with another hack? The reason I ask is because I can't seem to find that option in my usergroup manager. Let me know and I'll try to fix it for you.

{edit} Nevermind, it seems that the "Can View Private Custom Fields" option is fairly new and isn't in my version (3.0.1).. I'm looking into it now.

Also if I try to make the RIDES field required it drops off the http://www.url/forum/profile.php?do=edittimeslip page - it just disappears...

Actually ANY field I try to make required disappears - BUT when you try to submit it tells you "You have not completed the required field "Track Name" and of course you cant see the field ... LOL

Thats because the vehicle profile is meant to be completely separate and the fields were not intended to be used on the register page or made required.

[EvilLS1]

Originally Posted by Silver_2000_)!

The edit vehicle profiole and view custom threads options are linked - it is NOT possible to set edit to NO and voew to yes....

Any ideas ??

Ok, I think I found the problem. It seems that the "can view custom private fields" option is fairly new and isn't in the version I'm using.

To fix it, undo the changes you made to includes/init.php

Then find this:

	'canseehiddencustomfields' => 262144,

Replace it with this:

	'canseehiddencustomfields' => 262144,
	'cantimeslip'              => 16777216,

[Godzilla MR2]

great hack!

http://www.mr2oc.com/timeslips.php?

Is there a way to upload times from years gone by?
http://www.mr2ownersclub.com/quartermile/
We have guys that have run in the 9s in Japan, and have proof, but they are not members of our forum. Also some of the slips and cars are either dead or sold. So it would be great if we could add those cars and times.
Also how would I be able to add a column for videos. We are finding that Photoshop is a great quarter mile editor. Video is a bit harder to fake. So we have been thinking of requiring video proof of super~duper fast times.

Bill Strong
www.V8MR2.com

[EvilLS1]

Bill,
Its not possible for the timeslips page to sort more than one timeslip per user. You could add an extra input area on the edit timeslip page (like the area for listing mods) so that your users can mention other vehicles/timeslips. It would be shown on the "details" page but not the main timeslips page.

As for the video, you could add an input box where users can post a link to a video, and then have a clickable icon on the timeslips page and vehicle profile page so that people can download it.

If you have basic knowledge of php you can get an idea of how to add extra fields to the timeslip page from the example in this post:
https://vborg.vbsupport.ru/showpost....&postcount=247

That ^ shows how to add a select box and sort by it, so you wouldn't want to actually use those exact instructions since you want an input field.. but looking at it should give you an idea of how to do it.

[Silver_2000_)!]

Originally Posted by EvilLS1

Ok, I think I found the problem. It seems that the "can view custom private fields" option is fairly new and isn't in the version I'm using.

To fix it, undo the changes you made to includes/init.php

Then find this:

	'canseehiddencustomfields' => 262144,

Replace it with this:

	'canseehiddencustomfields' => 262144,
	'cantimeslip'              => 16777216,

Thanks Evil that seems to have fixed the profile issue .. two more questions....

When I set the options to require a timeslip under 11.99 it doenst seem to work. I can post a 10.000 second time and it doenst prompt for anything

When the options to upload a timeslip is set to yes the field to enter a link to a time slip disappears .. I figure this is normal BUT how is a user supposed to upload a slip ? There is no prompt - I have a separate photo gallery they can upload to, so its not an urgent issue - just wondering.

Edit - After setting "Allow users to upload timeslips?" back to NO Uploads NOW you are prompted for timeslip for times under 11.99. It appears that the upload is broke and the prompt only occurs for links to timeslips...

Could this have been broken by the new version as well ???
Doug

PS- I may have jacked something up because I think I had the 2.0 version and didnt run the upgrade I did the 2.1 install because I a few months ago I had replaced all the files with Virgin VB files and had to reapply the worthy hacks.. I had to go back and run the upgrade script to get it working. The upgrade script had a couple errors

[EvilLS1]

Originally Posted by Silver_2000_)!

Thanks Evil that seems to have fixed the profile issue .. One more question....

When I set the options to require a timeslip under 11.99 it doenst seem to work. I can post a 10.000 second time and it doenst prompt for anything

Could this have been broken by the new version as well ???

DOug

What browser are you using? Its most likely something to do with the browser since the prompt is done with javascript. Can you give me a link to try it out for myself?

[EvilLS1]

Originally Posted by Silver_2000_)!

Wghen the options to upload a timeslip is set to yes the field to enter a link to a time slip disappears .. I figure this is normal BUT how is a user supposed to upload a slip ? There is no prompt - I have a separate photo gallery thety can upload to, so its not an urgent issue - just wondering

Doug

Yeah when its set to upload mode the links input field should disappear. Thats normal. But once upload mode is enabled you should see the option to upload a slip in the edit vehicle profile page (at the bottom) like this:
https://vborg.vbsupport.ru/attachmen...chmentid=18977

[EvilLS1]

Edit - After setting "Allow users to upload timeslips?" back to NO Uploads NOW you are prompted for timeslip for times under 11.99. It appears that the upload is broke and the prompt only occurs for links to timeslips...

Could this have been broken by the new version as well ???
Doug

PS- I may have jacked something up because I think I had the 2.0 version and didnt run the upgrade I did the 2.1 install because I a few months ago I had replaced all the files with Virgin VB files and had to reapply the worthy hacks.. I had to go back and run the upgrade script to get it working. The upgrade script had a couple errors

That would explain it. In order for the new features in v2.1 to work (uploading, etc) you'd have to run the upgrade script successfully.

[Silver_2000_)!]

Originally Posted by EvilLS1

That would explain it. In order for the new features in v2.1 to work (uploading, etc) you'd have to run the upgrade script successfully.

The error is

mysql error: Table 'customtimeslippic' already exists

I guess I could try to back out the hack including deleting the table BUT that would eliminate the users data that have uploaded so far.

Im running both IE 6 and Firefox - The timeslips are here
http://www.talonclub.com/forum/timeslips.php?

I pm'ed a username and password so you can try it