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.

[pgp2003]

I just get a blank page when I try to Edit the timeslip info... http://www.nostreetracing.org/main/

[EvilLS1]

Originally Posted by pgp2003

I just get a blank page when I try to Edit the timeslip info... http://www.nostreetracing.org/main/

It can only be one of two things, either a missed edit to profile.php or a misspelled template name. First open profile.php and verify that you added this bit of code:

// ############################### EDIT VEHICLE PROFILE #######################
if ($_REQUEST['do'] == 'edittimeslip')
{

  if ($bbuserinfo[userid]==0  or $bbuserinfo[tdban]==0) 
{
	print_no_permission();
  }


	unset($tempcustom);
	exec_switch_bg();
	// Get Custom profile fields
	$customfields = array();
	fetch_timeslipfields(0);

if ($vboptions[allowtimeslipupload]){
		$timeslippic = $DB_site->query_first("
			SELECT userid, dateline
			FROM " . TABLE_PREFIX . "customtimeslippic
			WHERE userid = $bbuserinfo[userid]
		");

		if ($timeslippic)
		{
			$timeslippicchecked[1] = HTML_CHECKED;
			$timeslippicchecked[0] = '';
		}
		else
		{
			$timeslippicchecked[1] = '';
			$timeslippicchecked[0] = HTML_CHECKED;
		}		
}

	// draw cp nav bar
	construct_usercp_nav('vehicleprofile');

	$navbits[''] = $vbphrase['edit_timeslip'];
	$templatename = 'modifytimeslip';
}
// ############################### start update ###############################
if ($_POST['do'] == 'updatevehicleprofile')
{
	
  if ($bbuserinfo[userid]==0  or $bbuserinfo[tdban]==0) 
{
	print_no_permission();
  }
        $userfields = verify_vehiclefields(0);
	// insert custom user fields
	if (!empty($userfields))
	{
		$DB_site->query("UPDATE " . TABLE_PREFIX . "userfield SET userid=$bbuserinfo[userid]$userfields WHERE userid=$bbuserinfo[userid]");
	}
if ($vboptions[allowtimeslipupload]){

	globalize($_POST, array('timeslippic' => INT, 'avatarurl' => STR));

	if ($timeslippic==1)
	{
		require_once('./includes/functions_upload.php');
		process_image_upload('timeslippic', $avatarurl);
	}
	else if ($timeslippic==0)
	{
		$DB_site->query("DELETE FROM " . TABLE_PREFIX . "customtimeslippic WHERE userid = $bbuserinfo[userid]");
	}
}

$url = "timeslips.php?$session[sessionurl]";
	eval(print_standard_redirect('redirect_updatethanks'));

}

If so, check the spelling and contents of your modifytimeslip template.

BTW, I tried to register on your site so that I could see for myself but I just get a blank page when I submit my registration info. This hack makes no edites to register.php so something else is causing that.

[pgp2003]

I already checked both template names and profile.php already... and it seems to be okay.. but I will redo profile.php again..

and as for register.php, thanks for catching that... The only mod that made changes in that file was the award hack... good thing I didn't try it on my other forum

I will let you know how things go as soon as I try it again

[bmx269]

Installed it on K-Series.com. Love it. Thanks.

-Trent

[Sidewindr]

Anyone got the Top 5 Times mod working for vBadvanced CMPS ??

Help!!

[tteal]

Dewayne (EvilLS1),
FYI I just dyno'd last Tuesday ---- 456.9rwhp/388rwtq and ran out of fuel pump/system at only 6k rpm. Going to upgrade.

Quick question actual request. I somehow mucked up my timeslip database... all of the info exists, however, I think I messed up field55 somehow. Anyway that you could tell me the structure of what belongs in there so I can use phpmyadmin to fix it? all of my timeslips won't show now. That will teach me to try and install another tool

Thanks,
Tim

[EvilLS1]

Nice numbers Tim!

To re-add field55, first make sure that field55 has been completely removed from the profilefield and userfield tables. Then upload this script to the admincp directory and run it. Keep in mind that doing this will cause everyone to have to re-enter thier info for that field. If you just want to see the structure open the file and take a look.

Later,
Dewayne

[tteal]

Originally Posted by EvilLS1

Nice numbers Tim!

To re-add field55, first make sure that field55 has been completely removed from the profilefield and userfield tables. Then upload this script to the admincp directory and run it. Keep in mind that doing this will cause everyone to have to re-enter thier info for that field. If you just want to see the structure open the file and take a look.

Later,
Dewayne

DeWayne,
Thanks for teh quick resopnse. I figured it out and just manually input'd all of the data. I had custom fields with the ET in there so I used that. I didn't want to lose all that data Thanks!!!!!!!!

[tbroush]

I just added this to my website, I try to run the td302.php and I got a database error, but it seems to be working correctly, can you please check it out and let me know if there is something missing thanks.

http://www.modernmustangs-na.com/forums

[EvilLS1]

Originally Posted by scroush

I just added this to my website, I try to run the td302.php and I got a database error, but it seems to be working correctly, can you please check it out and let me know if there is something missing thanks.

http://www.modernmustangs-na.com/forums

You don't need to run td302.php since this is a fresh install. Thats only for people who had installed the hack prior to upgrading to VB 3.0.2 or later.

Yours seems to be working just fine.