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.

[bandit022]

first off, i'd like to thank EvilLS1 for a great hack.. been looking for something that could organize timeslips easily.

i really want to get this working on my board... but i get the following errors:

i get this when i try to view the Who's Online:

Warning: main(.././global.php): failed to open stream: No such file or directory in /home/bandit/public_html/forum/online.php on line 7

i get these when i try to view a member's profile:

Warning: main(.././global.php): failed to open stream: No such file or directory in /home/bandit/public_html/forum/member.php on line 1372

Warning: main(): Failed opening '.././global.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bandit/public_html/forum/member.php on line 1372

Fatal error: Call to undefined function: getpermissions() in /home/bandit/public_html/forum/member.php on line 1374

i get these when i try to edit my vehicle proflie:

Warning: main(.././global.php): failed to open stream: No such file or directory in /home/bandit/public_html/forum/member.php on line 607

Warning: main(): Failed opening '.././global.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bandit/public_html/forum/member.php on line 607

Fatal error: Call to undefined function: show_nopermission() in /home/bandit/public_html/forum/member.php on line 611

any suggestions? seems like there's something wrong with .././global.php but i'm not sure, i'm pretty new at all of this.

thanks for your help,

-jeff

[Josh Combs]

Originally Posted by bandit022

first off, i'd like to thank EvilLS1 for a great hack.. been looking for something that could organize timeslips easily.

i really want to get this working on my board... but i get the following errors:

i get this when i try to view the Who's Online:

Warning: main(.././global.php): failed to open stream: No such file or directory in /home/bandit/public_html/forum/online.php on line 7

i get these when i try to view a member's profile:

Warning: main(.././global.php): failed to open stream: No such file or directory in /home/bandit/public_html/forum/member.php on line 1372

Warning: main(): Failed opening '.././global.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bandit/public_html/forum/member.php on line 1372

Fatal error: Call to undefined function: getpermissions() in /home/bandit/public_html/forum/member.php on line 1374

i get these when i try to edit my vehicle proflie:

Warning: main(.././global.php): failed to open stream: No such file or directory in /home/bandit/public_html/forum/member.php on line 607

Warning: main(): Failed opening '.././global.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bandit/public_html/forum/member.php on line 607

Fatal error: Call to undefined function: show_nopermission() in /home/bandit/public_html/forum/member.php on line 611

any suggestions? seems like there's something wrong with .././global.php but i'm not sure, i'm pretty new at all of this.

thanks for your help,

-jeff

what version of vb are you running?

[bandit022]

Originally Posted by GAGT2NV

what version of vb are you running?

oh crap, forgot to mention that.

2.3.0 with a good list of hacks installed.

[bandit022]

nevermind.. i fixed it

[bandit022]

hey evil,

is there any way you could add a feature to show the dyno chart to prove the WHP, and make it like the 1/4 mile thing so that it would require a dyno chart for WHP over a certain amount?

just wondering cause i think this might be a problem on my board in a while and it might become hard to moderate what's real and what's fake without a dyno chart.

thanks,

-jeff

[EvilLS1]

Bandit,
Go into your admin panel and add the new profile field for the dynosheet link.

Then hold your mouse over the "edit" link for the new field and make a note of the field ID # (at the end of the URL).

Then open timeslips.php and find:

} else if ($action=="username") {
  $cond.=" WHERE userfield.field55>'".intval($number)."'";
  $condition.=" AND userfield.field55>'".intval($number)."'";
  $orderby="user.username";
  $direction=ASC;

Below it add:

} else if ($action=="graph") {
  $condition.=" AND userfield.fieldXX!='' AND userfield.field51>'".intval($number)."'";
  $cond.=" WHERE userfield.fieldXX!=''";
  $orderby="userfield.field51";
  $direction=ASC;
  $bracketA="<b>[</b>";
  $bracketB="<b>]</b>";

In the code above, replace the highlighted Xs with the ID# of the new field you added.

Still in timeslips.php find:

$ride= $userinfo[field50];

Below it add:

if ($userinfo[fieldXX]!=""){
  $graph="<a href=\"$userinfo[fieldXX]\" target=\"_blank\"><img src=\"{imagesfolder}/slipicon.gif\"  border=0></a>";
}else{
  $graph="";
}

Again, replace the highlighted Xs with the ID# of the new field you added.

Now in your "timeslips" template find:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=username">Username</option>

Below it add:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=graph">Dyno Graph</option>

Find:

	<td bgcolor="{categorybackcolor}" colspan="9"><normalfont color="{categoryfontcolor}"><CENTER><b> Timeslip Database</b></CENTER></normalfont></td>

Replace it with:

	<td bgcolor="{categorybackcolor}" colspan="10"><normalfont color="{categoryfontcolor}"><CENTER><b> Timeslip Database</b></CENTER></normalfont></td>

Find:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}">$bracket7<b>WHP</b>$bracket8</smallfont></td>

Below it add:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}">$bracketA<b>Graph</b>$bracketB</smallfont></td>

Find:

<td bgcolor="{categorybackcolor}" colspan="9">

Replace it with:

<td bgcolor="{categorybackcolor}" colspan="10">

In your "timeslipsbit" template find:

<td bgcolor="{secondaltcolor}">$avghp$rwhp</td>

Below it add:

<td bgcolor="{firstaltcolor}">$graph</td>

In member.php and register.php find all instances of this:

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

And replace them with thise:

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

(Change the highlighted XXs to the field ID for the dynograph.)

In your modifytimeslip template find:

<script language="javascript">
<!--
function validate(theform) {
	if ((theform.field55.value<12) && (theform.field57.value=="")) {
		alert("A link to your timeslip is required if your 1/4 mile ET is 11.99 or quicker.");
		return false; }
}
//-->
</script>

Replace it with:

<script language="javascript">
<!--
function validate(theform) {
	if ((theform.field55.value<12) && (theform.field57.value=="")) {
		alert("A link to your timeslip is required if your 1/4 mile ET is 11.99 or quicker.");
		return false; }
	if ((theform.field51.value>0) && (theform.fieldXX.value=="")) {
		alert("A link to your dynosheet is required.");
		return false; }
}
//-->
</script>

Again, replace the highlighted XXs with the dynosheet field ID.

I haven't tested this but it should work if you make all of the changes.

Dewayne

[bandit022]

holy crap! you're the man Dewayne!

didn't realize it would require so many changes... thanks for taking the time to do that for me!

i'll probably make the changes a little later tonight, i'll let you know if it works.

thanks again,

-jeff

[bandit022]

works like a charm.

thanks a million!

-jeff

[PKRWUD]

Wow, a hack thread with unnecessary drama, too!

First off, let me say that I am just blown away by not only this hack, but the support that comes with it. This was probably the easiest hack I've ever installed, and will be a favorite at my site.

That being said, I have one problem. The database page has nothing listed until someone makes an entry, so I entered my info, and submitted it, but it's not listed. I tried changing the Sort By, but it didn't matter, the page still has no one listed. What did I do wrong?

http://www.ricehatersclub.com/vbulletin/timeslips.php

http://www.ricehatersclub.com/vbulle...ails&userid=94

Thanks!

~Chris

[EvilLS1]

@ Jeff,
You're welcome.

@ Chris,
I think maybe you forgot to add the timeslipsbit template.. If not, check the spelling of that template name.

timeslipsbit template:

<tr align="center">
<td bgcolor="{firstaltcolor}">$rank</td>	
<td bgcolor="{secondaltcolor}"><normalfont><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$userinfo[userid]">$username</a></normalfont></td>
<td bgcolor="{firstaltcolor}">$ride</td>
<td bgcolor="{secondaltcolor}">$avghp$rwhp</td>
<td bgcolor="{firstaltcolor}">$avgsf$sixty</td>
<td bgcolor="{secondaltcolor}">$avge$eighth$atmph1$eighthmph$spacer$avgemph</td>
<td bgcolor="{firstaltcolor}">$avgq$quarter$atmph2$quartermph$spacer$avgqmph</td>
<td bgcolor="{secondaltcolor}"><smallfont>$details</smallfont></td>
<td bgcolor="{firstaltcolor}">$slip</td>
</tr>

Let me know if that doesn't fix it.

Dewayne