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.

[Big Kahuna]

So is it working for you now?

[Silver_2000_)!]

The avatars are appearing correctly in the forum after LS1's suggestion helped me find my screw up

Unfortunatly the avatar upload was still broke - So once again thanks to his suggestion reuploaded the unedited version of that file and the uploads worked. So encouraged by finding my own incompetence I re-applied the updated edits from the beta-3.06 file and its all working fine now...

Have to remember to not try to reapply hacks until I have poured my second cup of coffee

Once again - sorry for the fire drill ... everything is OK NOW -
Doug

[EvilLS1]

No problem Doug. Thanks for letting me know. So everything is working properly now (including uploads)?

[Silver_2000_)!]

Originally Posted by EvilLS1

No problem Doug. Thanks for letting me know. So everything is working properly now (including uploads)?

Yep

THANKS SO much for jumping in to try to help

Your prior note helped narrow it down so I could see my errors

[EvilLS1]

Originally Posted by Silver_2000_)!

Yep

THANKS SO much for jumping in to try to help

Your prior note helped narrow it down so I could see my errors

Great! Glad to hear that all is good b/c now I don't have to install a test forum (I'm lazy).

I'll leave the 3.0.6 version tagged as BETA until a couple more people confirm a successful installation (just in-case we've overlooked something).


Dewayne

[Big Kahuna]

I'm testing the 3.0.6 version on my test forum and it appears to be working fine. I'll give a link to the live forum once it is installed there. I think the 3.0.6 people will not have a problem. All went very smooth.

I'd like to be able to display the TOP 10 CONFIRMED (ticket submitted) in my forum index. Any chance of getting a bone rolled to me on the code required?

[Big Kahuna]

Originally Posted by SVTBlackLight01

OK. Here are the instructions and an updated file for displaying the top 5 timeslips in vBindex.

What change would I need to make to add the condition of only including those that submitted the proof?

[EvilLS1]

Originally Posted by Big Kahuna

I'm testing the 3.0.6 version on my test forum and it appears to be working fine. I'll give a link to the live forum once it is installed there. I think the 3.0.6 people will not have a problem. All went very smooth.

I'd like to be able to display the TOP 10 CONFIRMED (ticket submitted) in my forum index. Any chance of getting a bone rolled to me on the code required?

Well, I've never tried it but it should be just as easy to add the top 10 confirmed to your forum index.

Try this..

In forums/index.php find:

	'forumhome_pmloggedin',

replace it with:

	'forumhome_pmloggedin',
	'times',
	'toptimes',

find:

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

above it add:

// Top Times add-on
$pos = 0;
$condition.=" AND (userfield.field57!='' OR customtimeslippic.dateline!='') AND userfield.field55>0";

$users=$DB_site->query("SELECT *
                          FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield
                          LEFT JOIN " . TABLE_PREFIX . "customtimeslippic AS customtimeslippic ON (customtimeslippic.userid = user.userid)
                          WHERE user.userid = userfield.userid
                          $condition   
                          ORDER BY userfield.field55 ASC
                          LIMIT 10");

// Set up vars
while ($userinfo=$DB_site->fetch_array($users)) {
$tdateline = $userinfo[dateline];
$pos++;
$rank= number_format($pos);
$TDusername= $userinfo[username];
$ride= $userinfo[field50];
if ($userinfo[field52]>0){
  $sixty= $userinfo[field52];
}else{
  $sixty="";
}
if ($userinfo[field55]>0){
  $quarter= $userinfo[field55];
}else{
  $quarter="";
}
if ($userinfo[field56]>0){
  $atmph2="@";
}else{
  $atmph2="";
}
if ($userinfo[field56]>0){
  $quartermph= $userinfo[field56];
}else{
  $quartermph="";
}
$userinfo[field57] = trim($userinfo[field57]);
     if ($userinfo[field57]!="")
      {
           $slip="<a href=\"$userinfo[field57]\" target=\"_blank\"><img src=\"$stylevar[imgdir_misc]//slipicon.gif\"  border=0></a>";
      }
      else
      {
           $slip="";
      }
	      eval('$times .= "' . fetch_template('times') . '";');
}  // end while
	      eval('$toptimes .= "' . fetch_template('toptimes') . '";');

Create a new template named "toptimes" and add the HTML below:

		<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<tr id="cat">
	<td colspan="6" class="tcat" width="100%"><span class="smallfont"><b>?Top 10 1/4 Mile ETs</b></span></td>
</tr>
<tr>
<td class="alt2" align="center"><span class="smallfont"><b>#</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>Username</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>Ride</b></span></td>
<td class="alt2" align="center"><span class="smallfont"><b>60'</b></span></td>
	<td class="alt2" align="center"><span class="smallfont"><b>1/4 Mile ET & MPH </b></span></td>
	<td class="alt2" align="center"><span class="smallfont"><b>Slip</b></span></td>
</tr>
$times
<tr>
	<td class="tcat" colspan="6"><span class="smallfont"><CENTER>[<a href=$vboptions[bburl]/timeslips.php>Click here to view the complete list</a>]</CENTER></span></td>
</tr>
</table>
<br />

Create a new template named "times" and add the HTML below:

<tr>
<td class="alt1" align="center"><span class="smallfont">$rank</span></td>
<td class="alt1" align="center"><span class="smallfont"><a href="$vboptions[bburl]/member.php?$session[sessionurl]u=$userinfo[userid]">$TDusername</a></span></td>
<td class="alt1" align="center"><span class="smallfont">$ride</span></td>
<td class="alt1" align="center"><span class="smallfont">$sixty</span></td>
<td class="alt1" align="center"><span class="smallfont">$quarter$atmph2$quartermph</span></td>
<td class="alt1"><if condition="$tdateline!=''">
<a href="image.php?u=$userinfo[userid]&amp;type=timeslip&amp;dateline=$tdateline" target="_blank"><img src="$stylevar[imgdir_misc]/slipicon.gif" border=0></a>
<else />
$slip
</if></td>
</tr>

Then in your forumhome template put $toptimes where ever you want the Top 10 ETs module to show up.


I haven't tested this but it should work.


Dewayne

[Big Kahuna]

Dude -- you is Da man!

I'll play with that in my test forum this afternoon.

[Big Kahuna]

Almost there -- but not quite

I did everything as instructed -- tried twice to make sure -- and I can get the form built on the index page, but no data in it. I have ten test records in the time slip data base (which displays properly on the complete list page) -- three of which have timeslips loaded. It appears to be something in the search for qualifying records criterea. I'm strickly a cut and paster in php and not capable of understanding why the correct records were not selected for the form on the index page.

Any help will be appreciated

Thanx

BK