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.

[Shadowgate]

I was curious if there was a way to allow super moderators to edit the timeslip fields in the user profiles?

Thanks!

[EvilLS1]

Originally Posted by Shadowgate

I was curious if there was a way to allow super moderators to edit the timeslip fields in the user profiles?

Thanks!

The only way would be to give super mods the ability to edit all user options.

[Shadowgate]

Originally Posted by EvilLS1

The only way would be to give super mods the ability to edit all user options.

And that wouldn't be such a good idea...

Bummer! Thanks for the response anyways!

[dominick32]

Installed.
Thank you so much man!
Great hack!

[EvilLS1]

Originally Posted by dominick32

Installed.
Thank you so much man!
Great hack!

Thank you.

[klaattu]

So far this instalation has been a nightmare let me explain:

Foirst I had the old Time Splips on vb2.35. worked perfectly (i even translated it)

But the problem is that I had fileds 57 58 59 used for another profile fields.
So I dropped them in Php my admin then DARN vbulletin had a lot of errors because I cpuld not erase the fields since It kept lloking for the dropped fields on the DB.
I re added the fields 57 58 59 and I deleted them via Cp on Vbulletin.

then I said what the heck Ill erase the whole thing to id 50 so fields from 50 to 65 would be "availiable"

I mede the whole hack (took my time and now I am stuck here:

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO settinggroup (grouptitle,displayorder,volatile) VALUES ('timeslips','900','0')
mysql error: Duplicate entry 'timeslips' for key 1

mysql error number: 1062

I have checked the table settinggroup and there is NO timeslips field so Im stuck there, I have deleted anything that has to do with the original Tslips but to no avail now I have a databse that resembles a Gruyere cheese and no one can register because the user profile fields are scrambled.

(one note I started with the Td installer for upgrades from 1.2 to 2.0 and it sent me an error with fields so thats is why I began erasing custom profile fields)

I think Ill resptore my database but I really like this hack..
any help would be appreciated

[EvilLS1]

klaattu,
That error is due to the TDinstaller being ran more than once. Some of the settings fields were probably created before you got the error about the profile fields, thus the duplicate field error.
Try this: If you haven't already done so, restore your database to the state it was prior to running the installer. Login to your admincp and manually remove fields 50-65 in the profile field manager. Just to be sure, use phpmyadmin to make sure that all fields/columns with IDs from 50-65 have been removed from both the profilefield and userfield tables. Now use the instructions for installing v2.1. The installer should now run flawlessly.

If you still can't get it working I'd be happy to set it up for you. Email me at webmaster@modernmusclecars.net.

[klaattu]

Originally Posted by EvilLS1

klaattu,
That error is due to the TDinstaller being ran more than once. Some of the settings fields were probably created before you got the error about the profile fields, thus the duplicate field error.
Try this: If you haven't already done so, restore your database to the state it was prior to running the installer. Login to your admincp and manually remove fields 50-65 in the profile field manager. Just to be sure, use phpmyadmin to make sure that all fields/columns with IDs from 50-65 have been removed from both the profilefield and userfield tables. Now use the instructions for installing v2.1. The installer should now run flawlessly.

If you still can't get it working I'd be happy to set it up for you. Email me at webmaster@modernmusclecars.net.

thanks a lot will do exactly that today and Ill let you know..

best regards

[klaattu]

ok here is where I am:

on Admin Cp the user fields only go from 1 to 8 (if I try to add a new one it makes it 57!-as that ok?)
well its empty...
On the Database the userfields I have this: (see image 1) I have a field called temp I dont know where it came from and also I saw its empty en ithe database???? does the hack create it, is it safe to delete it?

ok so on cpadmin I dont have any fields from 50 to 65 and the databese has no 50 to 65 on useffierlds table also I ERASED completelly the table timeslipspic or something like it so there wont be any duplicate..

Before I hack de Db should I do something? I remember it gave me a error regarding INSERTO settinggroip (I have cjequed that table but there is no entry or field for timeslips?????? SEE picture.

any help will do because I don t want to rehack the DB to get some other error and be fixing it for 2 hours....

thanks again

[EvilLS1]

Originally Posted by klaattu

ok here is where I am:

on Admin Cp the user fields only go from 1 to 8 (if I try to add a new one it makes it 57!-as that ok?)
well its empty...
On the Database the userfields I have this: (see image 1) I have a field called temp I dont know where it came from and also I saw its empty en ithe database???? does the hack create it, is it safe to delete it?

The temp field is not from this hack.

ok so on cpadmin I dont have any fields from 50 to 65 and the databese has no 50 to 65 on useffierlds table also I ERASED completelly the table timeslipspic or something like it so there wont be any duplicate..

Before I hack de Db should I do something? I remember it gave me a error regarding INSERTO settinggroip (I have cjequed that table but there is no entry or field for timeslips?????? SEE picture.

any help will do because I don t want to rehack the DB to get some other error and be fixing it for 2 hours....

thanks again

If you've restored the backup of DB to the state it was in before you ran the installer all of the settings and anything to do with the new version (2.X) of the timeslip hack should be gone (the previous versions didn't add any settings to the admincp). Once thats done, and fields 50-65 are clear, you should be able to run the script without errors.