The Arcive of Official vBulletin Modifications Site.

vB Timeslip Database -for Automotive websites · **Released**: 10-20-2003

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.

Sadie Frost · #**182** 02-16-2004, 01:46 AM

Great hack hon

Installed and working perfectly - just having a little problem getting the select boxes to show up on the Edit Timeslip page? I installed the hack and followed ES1's directions, but I just get a normal text box. Select fields work fine on my regular edit profile page. Anyone have any suggestions? Thanks

EvilLS1 · #**183** 02-16-2004, 02:03 AM

Hey Sadia!

Version 1.3 doesn't have select boxes by default (v2.0 for VB3 does).. But its really easy to add them. Its all explained here:
https://vborg.vbsupport.ru/showpost....0&postcount=32

Dewayne

Sadie Frost · #**184** 02-16-2004, 02:46 AM

See I did that, but I still don't get select boxes - I'll go through and try again, maybe I missed something

EvilLS1 · #**185** 02-16-2004, 02:58 AM

Quote:

Originally Posted by Sadie Frost

See I did that, but I still don't get select boxes - I'll go through and try again, maybe I missed something

Have you installed this hack?
https://vborg.vbsupport.ru/showthread.php?t=21833

And are you adding a new select box field? If so, you'll need to find all instances of this (in member.php & register.php):

Code:

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

And add the field ID # for the new field you added. For example, if the new field ID is 64, then you would replace the above code with this:

Code:

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

You'd need to make 2 edits to register.php and 6 edits to member.php. If ya still can't get it to work let me know and I'll help.

Sadie Frost · #**186** 02-16-2004, 03:45 AM

I know I'm doing something stupid...just can't figure out what it is...

I have the select field hack installed, and it works fine on the regular edit profile page. (I tried it with the same field I am then trying to add to the edit timeslip page). I also tried to just change an existing field to a select box and that's not working either. I added the field number to member and register like you suggested, and I still get a field, but a regular text field. I can't think of any reason it would show up on Edit Profile and not on Edit Timeslip

EvilLS1 · #**187** 02-16-2004, 04:14 AM

Ah, I know why its not working for you.. There's a couple more steps that I forgot to mention.

###### In member.php find:

Code:

// ############################### start modify Timeslip Data #######################
if ($action=="edittimeslip") {
  $templatesused = 'timeslips_customfields,usercpnav,modifytimeslip';
  include("./global.php");
  // do modify profile form

  if ($bbuserinfo[userid]==0  or $bbuserinfo[vpban]==0 or $permissions['canmodifyprofile']==0) {
    show_nopermission();
  }

  // get extra profile fields
  $customfields = '';
  $profilefields=$DB_site->query("SELECT *
                                  FROM profilefield
                                  WHERE editable = 1
                                  AND profilefieldid IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63)
                                  ORDER BY displayorder");
  while ($profilefield=$DB_site->fetch_array($profilefields)) {
    $profilefieldname="field$profilefield[profilefieldid]";
    
if ($bgcolor=="{firstaltcolor}") {
      $bgcolor="{secondaltcolor}";
    } else {
      $bgcolor="{firstaltcolor}";
    }


    eval("\$customfields .= \"".gettemplate("timeslips_customfields")."\";");
  }

  if ($allowhtml) {
    $htmlonoff=$ontext;
  } else {
    $htmlonoff=$offtext;
  }
  if ($allowbbcode) {
    $bbcodeonoff=$ontext;
  } else {
    $bbcodeonoff=$offtext;
  }
  if ($allowbbimagecode) {
    $imgcodeonoff=$ontext;
  } else {
    $imgcodeonoff=$offtext;
  }
  if ($allowsmilies) {
    $smiliesonoff=$ontext;
  } else {
    $smiliesonoff=$offtext;
  }

  // draw cp nav bar
  $cpnav[1]="{secondaltcolor}";
  $cpnav[2]="{firstaltcolor}";
  $cpmenu[2]="class=\"fjsel\" selected";
  $cpnav[3]="{secondaltcolor}";
  $cpnav[4]="{secondaltcolor}";
  $cpnav[5]="{secondaltcolor}";
  $cpnav[6]="{secondaltcolor}";
  $cpnav[7]="{secondaltcolor}";
  eval("\$cpnav = \"".gettemplate("usercpnav")."\";");

  eval("dooutput(\"".gettemplate("modifytimeslip")."\");");
}

###### Replace it with:

Code:

// ############################### start modify Timeslip Data #######################
if ($action=="edittimeslip") {
  $templatesused = 'timeslips_customfields,usercpnav,modifytimeslip';
  include("./global.php");
  // do modify profile form

  if ($bbuserinfo[userid]==0  or $bbuserinfo[vpban]==0 or $permissions['canmodifyprofile']==0) {
    show_nopermission();
  }

  // get extra profile fields
  $customfields = '';
  $profilefields=$DB_site->query("SELECT *
                                  FROM profilefield
                                  WHERE editable = 1
                                  AND profilefieldid IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63)
                                  ORDER BY displayorder");
  while ($profilefield=$DB_site->fetch_array($profilefields)) {
    $profilefieldname="field$profilefield[profilefieldid]";
    
if ($bgcolor=="{firstaltcolor}") {
      $bgcolor="{secondaltcolor}";
    } else {
      $bgcolor="{firstaltcolor}";
    }
    	// new options
	$TheField="";
	$optionlines = explode(',', $profilefield[options]);
	$option_bit=$optionlines[0];
	if ($profilefield[type]==1) {
		// radio
		while ($option_bit) {
			$option_bit=trim($option_bit);
			if ($option_bit == $bbuserinfo[$profilefieldname]) { $LocOn = "checked"; } else { $LocOn = ""; }
			$TheField .= "<input type=\"radio\" name=\"$profilefieldname\" value=\"$option_bit\" $LocOn> $option_bit ";
    		$option_bit=next($optionlines);
		}
	} elseif ($profilefield[type]==2) {
		// select
		$TheField = "<select size=\"$profilefield[size]\" name=\"$profilefieldname\">";
		while ($option_bit) {
			$option_bit=trim($option_bit);
			if ($option_bit == $bbuserinfo[$profilefieldname]) { $LocOn = "selected"; } else { $LocOn = ""; }
			$TheField .= "<option value=\"$option_bit\" $LocOn>$option_bit</option>";
			$option_bit=next($optionlines);
		}
		$TheField .= "</select>";	
	} elseif ($profilefield[type]==3) {
		// textarea
		$bbuserinfo[$profilefieldname]=htmlspecialchars($bbuserinfo[$profilefieldname] );
		$TheField = "<textarea name=\"$profilefieldname\" rows=\"6\" cols=\"40\" wrap=\"physical\">$bbuserinfo[$profilefieldname]</textarea>";
	} else {
    	$TheField="<input type=\"text\" class=\"bginput\" name=\"$profilefieldname\" value=\"$bbuserinfo[$profilefieldname]\" size=\"$profilefield[size]\" maxlength=\"$profilefield[maxlength]\">";
 	}
	if ($profilefield[required] == 1) {
	  $TheField .= " <b><font size=1>* Required</font></b>";
	}
	// new options

    eval("\$customfields .= \"".gettemplate("timeslips_customfields")."\";");
  }

  if ($allowhtml) {
    $htmlonoff=$ontext;
  } else {
    $htmlonoff=$offtext;
  }
  if ($allowbbcode) {
    $bbcodeonoff=$ontext;
  } else {
    $bbcodeonoff=$offtext;
  }
  if ($allowbbimagecode) {
    $imgcodeonoff=$ontext;
  } else {
    $imgcodeonoff=$offtext;
  }
  if ($allowsmilies) {
    $smiliesonoff=$ontext;
  } else {
    $smiliesonoff=$offtext;
  }

  // draw cp nav bar
  $cpnav[1]="{secondaltcolor}";
  $cpnav[2]="{firstaltcolor}";
  $cpmenu[2]="class=\"fjsel\" selected";
  $cpnav[3]="{secondaltcolor}";
  $cpnav[4]="{secondaltcolor}";
  $cpnav[5]="{secondaltcolor}";
  $cpnav[6]="{secondaltcolor}";
  $cpnav[7]="{secondaltcolor}";
  eval("\$cpnav = \"".gettemplate("usercpnav")."\";");

  eval("dooutput(\"".gettemplate("modifytimeslip")."\");");
}

###### Replace the entire contents of your timeslips_customfields template with this:

Code:

<tr>
	<td bgcolor="$bgcolor"><normalfont><b>$profilefield[title]:</b></normalfont><br>
	<smallfont>$profilefield[description]</smallfont></td>
	<td bgcolor="$bgcolor"><normalfont>$TheField</normalfont></td>
</tr>

That should do it.

Sadie Frost · #**188** 02-16-2004, 04:32 AM

YES! It works lol

Thanks for helping me out

EvilLS1 · #**189** 02-16-2004, 04:41 AM

Anytime. Glad ya got it workin'.

Carnage Media · #**190** 02-24-2004, 05:48 AM

hey Evil, what would cause this to happen, you submit your info. but it does not show up? thanks.

EvilLS1 · #**191** 02-24-2004, 06:02 AM

Quote:

Originally Posted by Carnage Media

hey Evil, what would cause this to happen, you submit your info. but it does not show up? thanks.

Is it not showing any info at all? If not, make sure that the timeslipsbit template has been added and the spelling of the template name is correct.

If thats not it, what info was submitted and what sort method? Keep in mind that by default it only shows user's that have entered something in the 1/4 mile ET field when sorting by usernames.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06877 seconds Memory Usage 2,336KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (5)bbcode_code (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!