vB Timeslip Database -for Automotive websites

[EvilLS1]

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/~wacostr/forums/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 (https://vborg.vbsupport.ru/attachment.php?attachmentid=18975)
Vehicle Profile (https://vborg.vbsupport.ru/attachment.php?attachmentid=16363)
Edit Vehicle Profile (https://vborg.vbsupport.ru/attachment.php?attachmentid=23909)
Upload a timeslip (https://vborg.vbsupport.ru/attachment.php?attachmentid=18977)
Admincp settings (https://vborg.vbsupport.ru/attachment.php?attachmentid=18976)


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.php?p=793917&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. (https://vborg.vbsupport.ru/showpost.php?p=502749&postcount=162)
*Show the Top 5 ETs on your vB Advanced CMPS page. (https://vborg.vbsupport.ru/showpost.php?p=549962&postcount=334) (by coolmody)
*Show the Top 5 ETs on your vBindex page. (https://vborg.vbsupport.ru/showpost.php?p=550023&postcount=348) (by SVTBlackLight01)
*Change the default sort method (https://vborg.vbsupport.ru/showpost.php?p=477525&postcount=54)
*Show the ET club that users belong to in the postbit. (https://vborg.vbsupport.ru/showpost.php?p=485744&postcount=76)
*Show the 1/4 mile ET in the postbit only for users who have added it. (https://vborg.vbsupport.ru/showpost.php?p=520300&postcount=239)
*Set permissions for editing the Vehicle Profile per usergroup. (https://vborg.vbsupport.ru/showpost.php?p=529235&postcount=270)
*Require a link to the actual timeslip for all ETs that are 11.99 or quicker (https://vborg.vbsupport.ru/showpost.php?p=470681&postcount=3) (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 (https://vborg.vbsupport.ru/showpost.php?p=519735&postcount=234) 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! (https://vborg.vbsupport.ru/showpost.php?p=529402&postcount=274)


If you find this script useful please click install. :)

[EvilLS1]

One more screenshot:

[EvilLS1]

Add-on (for v2.0 only.. this comes standard in v2.1)

Require a link to the actual timeslip for all ETs that are 11.99 or quicker.

This bit of javascript will check the 1/4 mile ET field and the timeslip link field. If the 1/4 mile ET is less than 12.00 and the timeslip link field is empty, users will get a small pop-up box when they click the submit button telling them that a timeslip is required for ETs that are 11.99 or quicker.

Of coarse you can easily change it to any ET for the slip requirement.

In your modifytimeslip template find:

<form action="profile.php" method="post" id="profileform">


Replace it with:

<script language="javascript">
<!--
function validate(theform) {
if ((theform.field55.value<12) && (theform.field55.value>0) && (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>

<form action="profile.php" method="post" id="profileform" onSubmit="return validate(this)">

[PranK]

I LOVE YOU!!!

I have been hanging for this to come out for VB3!!!

/me clicks install 10,000 times!

Thanks heaps,

Christian

[SIINSI]

Awesome man... How do I just upgrade from your first version?

Thanks,
Miguel

[PranK]

got problemo's...

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: INSERT INTO profilefield (profilefieldid,title,description,required,hidden, maxlength,size,displayorder,editable,type,data,hei ght,def,optional,searchable,memberlist,regex,form, html) VALUES (50,'Ride','What do you drive?',0,0,'20','20','50','1','input','','0','0', '0','0','0','0','','0')
mysql error: Duplicate entry '50' for key 1


any suggestions?

Christian

[EvilLS1]

Thanks fellas.

Miguel,
If you still have some of the old timeslip fields from version 1.X, you can edit the installer and remove the queries which add the fields that you already have. Then it will only add the new fields. Just go into your admin panel and looks under user profile fields and make a note of the IDs.

PranK,
You still have some of the old profile fields in your database.

From the instructions:

// IMPORTANT: If you've previously installed vB Timeslip Database version 1.X on your VB2 board you'll need to go to your admincp, click "user profile fields manager" and make sure that no profile fields with IDs from 50-65 exist.. If they do, you'll need to remove them before running the installer..
Or if you want to keep the values from your old Timeslip Database fields you can simply edit the TDinstaller file and remove ONLY the fields that you want to keep.


I will make an upgrade script when I get some free time.

[EvilLS1]

.................................................. ....

[PranK]

cheeers - thanks mate!

(I did check the user profile manager, but none of the ones you listed were in there).

[PranK]

i deleted the fields from the db, ran the installer and got;

Invalid SQL: ALTER TABLE user ADD tdban smallint(5) unsigned DEFAULT 1 NOT NULL
mysql error: Duplicate column name 'tdban'


any help?

Thanks!

[PixelFx]

this looks killer, could you make a version for people that own boats? :P

[PranK]

PixelFx, it'd be damn easy to change the fields and take out the ones you dont want.

If you need any help, let me know. (I'm a boat person myself. :) )

[EvilLS1]

PixelFx,
You can easily change this version to suit your needs. Once installed, you can edit all of the timeslip fields in your admincp because they're just regular profile fields.

Prank,
You're getting that error because you've already ran the installer once. Open up TDinstaller.php and remove this section of code:

$DB_site->query("ALTER TABLE " . TABLE_PREFIX . "user ADD tdban smallint(5) unsigned DEFAULT 1 NOT NULL");

Then before running the installer, login to your admin panel and double check that no profile fields with IDs between 50-65 exist.. If they do, remove them. The run then installer again.

[PranK]

thanks EvilS1, i'll give it a go - but i removed the fields from the db manually and tried installing.. ?

oh well, will let you know! thanks again!

Christian

[FastAttack]

Man you beat me to it.. I had a working function but I am a slow ass coder :) anyhow thanks for releasing it.. I will try it tonight on my beta site!

[PranK]

nope...

Invalid SQL: ALTER TABLE userfield ADD field50 CHAR(250) NOT NULL
mysql error: Duplicate column name 'field50'

I deleted everything from the 'profilefield' table that wasn't one of my 7 fields... ie, everything to do with the vbtimeslips, i ran it again - same as above except changes to field51 or 52 etc ...

do you have the sql that i can just manually insert?

its strange, because all the fields seem to add fine, its not until you try to add your car details that it gives you an error....

Christian

[EvilLS1]

Prank,
Do you have phpmyadmin? If so, look under the userfield and profilefield tables and you'll see that the old fields or columns are still there. Thats whats causing the 'duplicate entry error'. If you will remove all old feilds/columns with IDs from 50-65 from both your userfield and profilefield tables, then run the new installer it will work. If you still can't get it I'll help you with it when I get home from work this afternoon.

[FastAttack]

Ok its up and running:

http://srtforums.com/forums/timeslips.php

the only thing I am going to do to it, when I have time is modify it so that it goes into a moderation queue since I didn't see this on this hack.. this will allow me to sort out the bogus time slips.. and allow my fastest time list mod to have an easier time than sorting out through random time slips.

[FastAttack]

the other thing I am going to change probably is make it so that you have the option to upload it ( if in the right membership group) or link it :D

[magnus]

Nice work, I had ported over the vB2 version and I have been using it since Gamma. I'll check out the new one -- thanks for updating! ;)

[EvilLS1]

FastAttack,
Looks nice!

magnus,
Thanks. :)

[EvilLS1]

@ Prank (or anyone else who's getting the 'duplicate field or column' error when running the installer):

Replace your timeslips.php & TDinstaller.php files with the ones attached to this post. Run the new installer, then follow the new instructions. If you've already done the file edits from the instructions in the first post of this thread, you'll need to start over and use the code in the attached instructions (all of the field IDs are different in this version). This will solve your problem.

[PranK]

Hey Evil,

Invalid SQL: INSERT INTO profilefield (profilefieldid,title,description,required,hidden, maxlength,size,displayorder,editable,type,data,hei ght,def,optional,searchable,memberlist,regex,form, html) VALUES (80,'Ride','What do you drive?',0,0,'20','20','80','1','input','','0','0', '0','0','0','0','','0')
mysql error: Duplicate entry '80' for key 1

Sorry to be such a pain! :(

How do i remove the fields from userfield? i can remove them from profilefield...

Thanks,

Christian

[EvilLS1]

Prank,
Do you have Yahoo IM? If not email me at EvilLS1TA@AOL.com

[0ptima]

Awseome job EvilS1!!! Im still on VB2, but once I install VB3, Im going to install your hack!!!

[Drowned]

WOOOHOOOOOOOOOOOOOOOOO... I have been waiting for this!

:bowdown: :bowdown: :bowdown: :bowdown: :bowdown:

My forum members LOVE YOUUUU!!! :nervous:

[EvilLS1]

Thanks fellas. :)

[gmarik]

Interesting ...

[94DROPTOPZ]

I have been waiting very patiently for this because this hack is awesome!!

This will work on my 3.0 Beta5 right?

[EvilLS1]

I have been waiting very patiently for this because this hack is awesome!!

This will work on my 3.0 Beta5 right?
I don't know what all has changed since beta5 so I'm not sure. Its only been tested on RC1-RC3.

[94DROPTOPZ]

I don't know what all has changed since beta5 so I'm not sure. Its only been tested on RC1-RC3.

Hmmm just when I got my hopes up :ermm:

[EvilLS1]

Hmmm just when I got my hopes up :ermm:
You could always upgrade. RC3 looks and runs smoother than the older betas anyway, so it would be worth it. ;)

[94DROPTOPZ]

You could always upgrade. RC3 looks and runs smoother than the older betas anyway, so it would be worth it. ;)

I might try to upgrade but Im just afraid to lose all of my posts and members. Maybe in the future. Thanks for the awesome hack

[BarryA]

Installed and works great...

http://www.fordpower.net/forums/timeslips.php?

[EvilLS1]

Looks great Barry. I added your link to the first post. :)

[EvilLS1]

Minor bug fix:

Open timeslips.php and find:

$pagenav = construct_page_nav($userscount[users],"timeslips.php?$session[sessionurl]do= $_REQUEST[do]&perpage=$perpage");

Replace it with:

$pagenav = construct_page_nav($userscount[users],"timeslips.php?$session[sessionurl]do=$_REQUEST[do]&perpage=$perpage");

It fixes an unneeded space in the page navigation links (between do= and $_REQUEST[do]) which was causing the sort by method to be lost when viewing pages other than the first one.

First post has been updated.

[BarryA]

After playing with it for a while I have a few suggestions.

Add Torque (We all know thats really what wins races)... :)

It would be nice if the timeslips were attachments instead of links. We all know 6 months from now half of the links will be dead.

And thanks for making this, it saved me a lot of time from having to do it myself.

On Edit: I just re-read your post and saw that you are not adding any more features so I will take a shot at this myself.

[DigitalEclipse]

<a href="http://www.al-club3g.org/forums/timeslips.php" target="_blank">http://www.al-club3g.org/forums/timeslips.php</a>

Just added it, thanks!

[EvilLS1]

I do have a small problem...I am running VBadvanced Home page. The link on the navbar doesnt work on there. Its trying to send me to http://www.al-club3g.org/timeslips.php, leaving out the /forums.


In your navbar template find:

<td class="vbmenu_control"><a href="timeslips.php?$session[sessionurl]">$vbphrase[timeslips]</a></td>


Replace it with:

<td class="vbmenu_control"><a href="$vboptions[bburl]/timeslips.php?$session[sessionurl]">$vbphrase[timeslips]</a></td>


That should fix it. :)

[EvilLS1]

After playing with it for a while I have a few suggestions.

Add Torque (We all know thats really what wins races)... :)

It would be nice if the timeslips were attachments instead of links. We all know 6 months from now half of the links will be dead.

And thanks for making this, it saved me a lot of time from having to do it myself.

On Edit: I just re-read your post and saw that you are not adding any more features so I will take a shot at this myself.
Good suggestions. The v1.3 thread explains how to add extra fields (for torque or whatever you want). Its pretty easy. As for the upload feature, I might look into adding it when I upgrade to vb3.. That could be a while though, so if you guys want to add it yourself go for it. :)

[DigitalEclipse]

Actually I fixed it myself after I posted, but thanks :up:

[BarryA]

Im not sure if I installed the hack incorrectly or what, but it has destroyed my ability to edit users from the control panel. Can someone verify that they are able to edit users after installing the hack.

This is the error I get;

Database error in vBulletin 3.0.0 Release Candidate 3:

Invalid SQL: UPDATE user SET tdban= WHERE userid=65
mysql error: You have an error in your SQL syntax near 'WHERE userid=65' at line 1

mysql error number: 1064

Date: Monday 02nd of February 2004 07:01:19 PM
Script: http://www.fordpower.net/forums/admin/user.php
Referer: http://www.fordpower.net/forums/admin/user.php?do=edit&userid=65
Username: Barry
IP Address: 65.124.87.345

[EvilLS1]

Barry,
Re-check your code edits to admincp/user.php . Theres 3 edits to that file. I think maybe you missed one of them. I just re-added the code from the instructions to my test board and its working fine.

[FastAttack]

new suggestions.. allow users to upload multiple time slips.. ie one with the fastest trap speed and the other with the actual elapsed time.. I am not sure how hard that would be :)
as it well beyond my knowledge of programming vb :)

[BarryA]

Barry,
Re-check your code edits to admincp/user.php . Theres 3 edits to that file. I think maybe you missed one of them. I just re-added the code from the instructions to my test board and its working fine.

Thanks man... :) I wasnt for sure if it was something I did or if everyone was having the problem...

new suggestions.. allow users to upload multiple time slips.. ie one with the fastest trap speed and the other with the actual elapsed time.. I am not sure how hard that would be :)
as it well beyond my knowledge of programming vb :)

You could just have them put both slips in one image. This would be the easy way around it. Like EvilLS1 said he is not taking any reqests for new features. It would however be easy to do it yourself.

[EvilLS1]

Adding the upload feature shouldn't be too difficult since VB3 already has the ability to upload pictures to your profile. You can probably use that same function for the timeslips. When (if?) I upgrade to VB3 I will look into it.

[94DROPTOPZ]

I finally added it yesterday and this is an awesome hack & it works great thanks alot...

http://www.gmvsford.com/forums/timeslips.php?

[EvilLS1]

Looks great 94DROPTOP.

[DigitalEclipse]

Just FYI. I upgraded to RC4 and it still works like a charm from what I can tell.

[higabyte]

great hack!!!!!! added it with no problems!!

also, if you could please add mine... thanks!

http://board.accordtuner.com/timeslips.php

[EvilLS1]

DigitalEclipse,
Thanks for confirming that it works with RC4.

higabyte,
Looks nice! Added your link.

[DeeperImage]

I am using RC4 as well, I just added it tonight. I love it. It was easy to install. Thanks a bunch.

http://www.240sxforums.com/forums/timeslips.php

[Tungsten]

Hey Evil... how would I modify the code in this latest version for vB3 so that it sorts by 60' times by default? :)

And thanks again for this hack. You rock, man.

[EvilLS1]

Hey Evil... how would I modify the code in this latest version for vB3 so that it sorts by 60' times by default? :)

And thanks again for this hack. You rock, man.

In timeslips.php find:

// If no action is set order by quarter
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] ='quarter';
}


Replace it with:

// If no action is set order by sixty
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] ='sixty';
}


Find:

}
else
{
$cond.=" WHERE userfield.field55>'".intval($number)."'";
$condition.=" AND userfield.field55>'".intval($number)."'";
$orderby="userfield.field55";
$direction=ASC;
$bracket3="<b>[</b>";
$bracket4="<b>]</b>";


Replace it with:

}
else
{
$cond.=" WHERE userfield.field52>'".intval($number)."'";
$condition.=" AND userfield.field52>'".intval($number)."'";
$orderby="userfield.field52";
$direction=ASC;
$bracket1="<b>[</b>";
$bracket2="<b>]</b>";


That should do it. :)


DeeperImage,
Looks great! Added your link.

[Tungsten]

That should do it. :)

Excellent... thanks! We're running it here:

http://www.tennesspeed.net/forums/timeslips.php

[EvilLS1]

Excellent... thanks! We're running it here:

http://www.tennesspeed.net/forums/timeslips.php
Looks great! Link added. :)

[DeeperImage]

DeeperImage,
Looks great! Added your link.

Thank you for this excellent hack. One question I had, I am not very familiar with php. When the new RC of VB3 comes out, and I upgraed it, which files do I need to not replace so that they dont erase the hack? thanks again.

[EvilLS1]

Thank you for this excellent hack. One question I had, I am not very familiar with php. When the new RC of VB3 comes out, and I upgraed it, which files do I need to not replace so that they dont erase the hack? thanks again.
Well, you really should replace all the files with the newer ones when you upgrade.. Then just re-apply the hack to the new files. You won't need to run the installer again or add/edit the templates. Just do the file edites.

BTW, just noticed that you're from Kennesaw GA.. I'm only a few miles from you (Rome GA). :)

[cteselle]

Great Hack!

Is there a way to add the top 5 (or whatever) to a non-vb page?

[DeeperImage]

Well, you really should replace all the files with the newer ones when you upgrade.. Then just re-apply the hack to the new files. You won't need to run the installer again or add/edit the templates. Just do the file edites.

BTW, just noticed that you're from Kennesaw GA.. I'm only a few miles from you (Rome GA). :)
I guess thats not to bad. That is to funny that you live in Rome. We are just minutes away :nervous:

[EvilLS1]

Great Hack!

Is there a way to add the top 5 (or whatever) to a non-vb page?
Thanks. I don't have any of the VB3 portals installed on my test site, but it should be pretty easy to do. In the old v1.3 Timeslip Database thread I posted instructions on how to add it (for VB2). You can probably figure out how to add it to your VB3 portal by looking at that code.

[cteselle]

Here's mine: http://www.socalloc.com/forums/timeslips.php

I modified and added to it a bit. I also wrote my own script to display the stats on the first page, since I'm not using a vB portal.

thanks again for your work on this! My users love it!

[corsacrazy]

all we need is this hack intergrated with a vb garage hack and all car sites will be sorted

[EvilLS1]

cteselle,
Looks great! Added your link. I like what you did with the mod list too. :)

[joeychgo]

Hack installed pretty easily...
(especially considering im learning all this as I go along - one whole week now-)
thanks for your hard work!

One strange thing. My navbar does not show Timeslips it shows Tineslips

LOL Please someone take pity on me and tell me how to fix!!!!! Ive looked EVERYWHERE I can think of and couldnt find it.


Second problem... After completing the Vehicle Profile Data form and clicking "save changes" it takes me to the New Subscribed Threads screen?


Third, the instructions say this should add a "Vehicle Profile" page to my forum - but I cant find anything

Im running vBulletin Version 3.0.0 Release Candidate 4--

www.lincolnvscadillac.com

[EvilLS1]

One strange thing. My navbar does not show Timeslips it shows Tineslips


In your admincp under languages & phrases click "phrase manager" then click the "search in phrases" button. Search for "tineslips".. Then click edit and fix the spelling mistake.


Second problem... After completing the Vehicle Profile Data form and clicking "save changes" it takes me to the New Subscribed Threads screen?

Thats the main page of your userCP. Thats not an error. Its supposed to go there (goes to the same page after editing your regular profile aswell).. But you can easily change it so that it redirects to somewhere else if you want..

Find this code in profile.php:

// ############################### 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]");
}
$url = "usercp.php?$session[sessionurl]";
eval(print_standard_redirect('redirect_updatethank s'));

}


In the code above, find this:

$url = "usercp.php?$session[sessionurl]";


if you want it to redirect to the timeslip database just replace it with this:

$url = "timeslips.php?$session[sessionurl]";

..or change it to whatever file that you want to be redirected to.



Third, the instructions say this should add a "Vehicle Profile" page to my forum - but I cant find anything


Once you've added your ET to the timeslip database, go to the timeslips page (timeslips.php) and click "Details" next to the username and you'll see the vehicle profile page.

Or you can even add a link to your user's vehicle profile from their regular profile. Just put this link in the memberinfo template:

<a href="member.php?$session[sessionurl]&do=vehicledetails&userid=$userinfo[userid]">Vehicle Profile</a>

[joeychgo]

Thanks! But the second one didnt do anything......... ???

[joeychgo]

Got a problem~~~~

After installing this, I went to my user manager and tried to change info on a member. When I clicked save I got this.......

[COLOR=Red]There seems to have been a slight problem with the Lincoln vs Cadillac database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET tdban= WHERE userid=6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=6' at line 1

mysql error number: 1064

[EvilLS1]

Thanks! But the second one didnt do anything......... ???

Make sure you changed the code in the right place. Theres a few places that have that same code. The one you want to change is a few lines below this code:

if ($_POST['do'] == 'updatevehicleprofile')

[EvilLS1]

Got a problem~~~~

After installing this, I went to my user manager and tried to change info on a member. When I clicked save I got this.......

[COLOR=Red]There seems to have been a slight problem with the Lincoln vs Cadillac database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: UPDATE user SET tdban= WHERE userid=6
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userid=6' at line 1

mysql error number: 1064
You missed something when you edited admincp/user.php. Theres 3 changes in that file. Go back and make sure you did all 3 edits (I think you forgot the second one).

[joeychgo]

Yup, you were right. I missed one change..... got it fixed....thanks! GUess I shouldnt do these things at 4:00am while wired on nothing but coffee!

[EvilLS1]

Glad ya got it workin'. :)

[joeychgo]

Thanks alot --- for the hack and your help.

[EvilLS1]

You're welcome.

[BfB]

all we need is this hack intergrated with a vb garage hack and all car sites will be sorted

YEAA!!!!!

[EvilLS1]

Add on:
This will show the ET club that each user belongs to in the postbit. For example, if a user has a 12 second ET it will display "12 Second Club Member" in the postbit below his username.

##### In includes/functions_showthread.php find:


$show['reputationlink'] = iif($vboptions['reputationenable'] AND $bbuserinfo['userid'] AND $post['userid'] AND !($usergroupcache["$post[usergroupid]"]['genericoptions'] & ISBANNEDGROUP), true, false);
break;
}



Below it add:


if ($post[field55]>=14 && $post[field55]<15)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=14seccars\" STYLE=\"text-decoration: none\">14 Second Club Member</a></font>";
}
else if ($post[field55]>=13 && $post[field55]<14)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=13seccars\" STYLE=\"text-decoration: none\">13 Second Club Member</a></font>";
}
else if ($post[field55]>=12 && $post[field55]<13)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=12seccars\" STYLE=\"text-decoration: none\">12 Second Club Member</a></font>";
}
else if ($post[field55]>=11 && $post[field55]<12)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=11seccars\" STYLE=\"text-decoration: none\">11 Second Club Member</a></font>";
}
else if ($post[field55]>=10 && $post[field55]<11)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=10seccars\" STYLE=\"text-decoration: none\">10 Second Club Member</a></font>";
}
else if ($post[field55]>0 && $post[field55]<10)
{
$poop = "<font size=\"1\"><a href=\"timeslips.php?$session[sessionurl]&do=singledigitcars\" STYLE=\"text-decoration: none\">Single Digit Club Member</a></font>";
}
else
{
$poop = "";
}


Then put $poop in your postbit & postbit_legacy templates where you want it to show up.

[Boofo]

There you go again, pooping in the postbit. LOL

[EvilLS1]

There you go again, pooping in the postbit. LOL

Yeah I'm not very creative when it comes to thinking of variable names. I just use the first thing that comes to mind. :D
$poop ---> https://vborg.vbsupport.ru/external/2004/03/3.gif

[joeychgo]

Hey evil - are you going to update when gold comes out?

[EvilLS1]

Hey evil - are you going to update when gold comes out?
I dunno.. I'm happy with my VB2 board so I'm not sure when I'll upgrade.

{Edit} Do you mean update the hack? Only if it needs to be updated. I'm not sure if any of the code changes from RC4 - Gold will effect this hack.

[bandit022]

hey dewayne,

i decided to update to vb3 (rc4) so i had to re-install this hack..

and i'm having a slight problem. everything looked fine untill i tried to submit my timeslip data. the "Save Changes" and "Reset Fields" buttons on the bottom of modifytimeslips don't work. you can click on them but they do nothing.

i've re-installed the hack twice now and still doesn't fix the problem. what could this problem be?

thanks for you help,

-jeff

[EvilLS1]

Jeff,
It appears that you've missed some code when you added the slip requirement add-on.

In your modifytimeslip template find:

</script>


Below it add:

<form action="profile.php" method="post" id="profileform" onSubmit="return validate(this)">


That should fix it.


Dewayne

[bandit022]

yup. that did it!

*scratches head* i'm not sure how i missed that part of the code...

thanks for the fast reply, as always!

-jeff

[bqleague]

When i click edit user, i get

Parse error: parse error in /home/mustangn/public_html/admincp/user.php on line 442

[bqleague]

I got that fixed, what i want to know is there a way by default it will show all users that have created an account weather they have put in times or anything, instead of choosing somthing from the drop menu?

[EvilLS1]

I got that fixed, what i want to know is there a way by default it will show all users that have created an account weather they have put in times or anything, instead of choosing somthing from the drop menu?
Yeah its possible but I'm not sure what the purpose would be. Thats what the memberlist is for. ;)

Anyway, open timeslips.php and find:

else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE userfield.field55>'".intval($number)."'";
$condition.=" AND userfield.field55>'".intval($number)."'";
$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";
}


Replace it with:

else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE user.userid>'".intval($number)."'";
$condition.="";
$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";
}


Then if you want it to show everyone by default just follow the example posted here (you'll need to use "username" instead of "sixty"):
https://vborg.vbsupport.ru/showpost.php?p=477525&postcount=54

[bqleague]

the purpose would be so not only is it a timeslip database but also a "car" database, listing all users with cars.

[bqleague]

no i didnt mean that have created an account (memberlist) i meant all users that have subbmitted there car data.... blah

[EvilLS1]

no i didnt mean that have created an account (memberlist) i meant all users that have subbmitted there car data.... blah
Using this code (instead of the code above) will display all users who have entered something into the vehicle field:


else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE userfield.field50!=''";
$condition.="";
$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";
}

[PranK]

EvilS1 - wanna add my site to your list?

www.skylinesaustralia.com

Christian

[joeychgo]

I MADE A GOOF WHEN I INSTALLED

I had a typo spellin TIMESLIPS as tineslips. I thought I fixed it in the templates, but I have a place where it keeps coming up --- How do I fix this? (see screenshot)

[EvilLS1]

EvilS1 - wanna add my site to your list?

www.skylinesaustralia.com

Christian
Added. :)

[EvilLS1]

I MADE A GOOF WHEN I INSTALLED

I had a typo spellin TIMESLIPS as tineslips. I thought I fixed it in the templates, but I have a place where it keeps coming up --- How do I fix this? (see screenshot)
Joey,
In your admincp under languages & phrases click "phrase manager" then click the "search in phrases" button. Search for "tineslips".. Then click edit and fix the spelling mistake. Do the same for "Tineslip Database".

[joeychgo]

thanks evil --- i didnt search for tineslips database before- thats where it was


How about addin gmy site -- ill add yours to mine if oyu like

www.lincolnvscadillac.com

[alfaowner]

hi there, I just wonderd, ive buggered up my DB, its okay but since i deleted a profile field, it has a db error is user admin cp.

Id like a script i could rum in phpmy admin that would remove all of this db changese ive applied through TDinastaller.php.

Can anyone help?

To recap.

Id like to remove the database changes that tdinstaller makes so that i can start again,

thank you.

[EvilLS1]

hi there, I just wonderd, ive buggered up my DB, its okay but since i deleted a profile field, it has a db error is user admin cp.

Id like a script i could rum in phpmy admin that would remove all of this db changese ive applied through TDinastaller.php.

Can anyone help?

To recap.

Id like to remove the database changes that tdinstaller makes so that i can start again,

thank you.

Alfaowner,
I made an uninstaller for you (attached). Just upload it to your admin directory and run the script.

[EvilLS1]

How about addin gmy site -- ill add yours to mine if oyu like

www.lincolnvscadillac.com

Do you mean add it to this thread or to my site? I've already added your link to the first post, and if you want to add it to my site just go here and submit it:
http://modernmusclecars.net/links/links.php

Once you've submitted your link let me know and I'll validate it.

[bandit022]

dewayne,

you can add my site to this thread:

http://www.lonestarstangs.com/forum/timeslips.php?

thanks man... can't wait till you release the next version with the attachment option.

-jeff

[EvilLS1]

dewayne,

you can add my site to this thread:

http://www.lonestarstangs.com/forum/timeslips.php?

thanks man... can't wait till you release the next version with the attachment option.

-jeff
done. :)

[PKRWUD]

I am running Gold, and when I tried to run the 1.3 upgrade installer, I get this:

Fatal error: Call to undefined function: can_administer() in /home/pkrwud/public_html/vbulletin/TDinstaller.php on line 10

I'm not having a great week. lol.

[EvilLS1]

I am running Gold, and when I tried to run the 1.3 upgrade installer, I get this:

Fatal error: Call to undefined function: can_administer() in /home/pkrwud/public_html/vbulletin/TDinstaller.php on line 10

I'm not having a great week. lol.
Hmm.. I guess that function no longer exists in 3.0 Gold. Try this:

Open TDinstaller and find:

// ######################## CHECK ADMIN PERMISSIONS #######################
if (!can_administer('canadminusers'))
{
print_cp_no_permission();
}


Delete it and run the installer again.

[PKRWUD]

Okay, everything has been done, I believe, but when I click on the link in the navbar, I get this message:

Invalid SQL: SELECT COUNT(*) AS users
FROM user, userfield
WHERE userfield.field55>'0'
AND user.userid = userfield.userid
mysql error: Unknown column 'userfield.field55' in 'where clause'

[EvilLS1]

Okay, everything has been done, I believe, but when I click on the link in the navbar, I get this message:

Invalid SQL: SELECT COUNT(*) AS users
FROM user, userfield
WHERE userfield.field55>'0'
AND user.userid = userfield.userid
mysql error: Unknown column 'userfield.field55' in 'where clause'
You're getting that error b/c field55 no longer exists. You didn't remove the old fields from v1.3 when you upgraded to GOLD did ya?

If you did, you'll need to download version 2.0 and run the uninstaller, then start the new TDinstaller from v2.0 (not the upgrade script).

If you still can't get it to work you can email me at evills1ta@aol.com and I'll help you.

[alfaowner]

ok, i am sorry, but how do i remove the database entries as i cannot get this to work, thank you, also can i just delete them in cp as i get an error if i do

[EvilLS1]

ok, i am sorry, but how do i remove the database entries as i cannot get this to work, thank you, also can i just delete them in cp as i get an error if i do
The script I attached above removes all of the database entries. The changes to the database most likely aren't the cause of the error. If you're getting an error its because one or more of the files you edited still have some code from the hack in them. Reupload the backup of all the files you edited.

If you can tell me exactly what error you're getting and from which file I can help you fix it.

PS: All of the profile fields can be removed in your admincp under custom profile fields.. The only other thing this script adds to your database is a column called tdban to your user table.

You can remove it with phpmyadmin by running this query:

ALTER TABLE user DROP tdban

Then make sure that you uploaded an unmodified copy of all the files you edited.

[Gt-358]

http://www.tallahasseemusclecar.com/forum/timeslips.php?

Great mod! Thanks!!!

Tony Whetstone
http://www.tallahasseemusclecar.com/

[EvilLS1]

Thank you. Link added. :)

Has anyone installed this on vb3 gold yet? Just want to verify that none of the effected code has changed.

[Gt-358]

I installed it on TMCA after upgradeing to vb3 Gold, so yes it is running fine on vb3 gold :)

Tony

[PKRWUD]

Evil, thank you again for such a great piece of software. This was very popular on my website prior to the release of Gold, and I'm sure it will be again. I screwed up somewhere, but it's installed now. I lost all the info from the users, but hey, they all know how to enter it again. :)

Thanks so much!

BTW, you can add us to your list, but you might want to give me a day or two to get some entries. :)

http://www.RiceHatersClub.com

Take care,
~Chris

[PKRWUD]

Okay, I guess not. People are entering info, but it doesn't show up on the page.

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

[EvilLS1]

Gt-358,
Thanks for verifying that it works with Gold.

PKRWUD,
Check and make sure you added the html to the timeslipsbit template. Then go into your admin panel and look under the custom profile fields section and make sure that the timeslip fields are there and that the IDs are 50-65. If thats not it, let me know and we'll figure it out. I'm sure its something simple.

[SVTBlackLight01]

Hey EvilL,

Is there a way to upgrade from vb2 and be able to use the info from that Timeslip Database, or did I overlook that somewhere? :confused:

[EvilLS1]

Hey EvilL,

Is there a way to upgrade from vb2 and be able to use the info from that Timeslip Database, or did I overlook that somewhere? :confused:
SVT,
In your admin cp under custom profile fields check and make sure that your old timeslip fields from VB2 still have the correct IDs (50-63 I think).. If so, the upgrade instructions in this post should work:
https://vborg.vbsupport.ru/showpost.php?p=470722&postcount=8

[gearshifter47]

ok.. for my users who have not been at a 1/4 mile track.. They leave the 1/4 mile inputs blank and only fill in the 1/8 mile.. I notice that they do not display on the main timslip sort and even if they have N/A selected, they do not show up there either, also Username sort... Might be more sorts that does not display them that i do not know about..

anyone know whats wrong?

[SVTBlackLight01]

EvilL, how did I miss that? :ermm:

Thanks. I knew it had to be here somewhere. I'll give it a try. :)

[EvilLS1]

ok.. for my users who have not been at a 1/4 mile track.. They leave the 1/4 mile inputs blank and only fill in the 1/8 mile.. I notice that they do not display on the main timslip sort and even if they have N/A selected, they do not show up there either, also Username sort... Might be more sorts that does not display them that i do not know about..

anyone know whats wrong?
Nothing is wrong. Thats the way it was designed to work. The Timeslip Database is mostly geared toward 1/4 mile ETs since thats the most popular track length.

By default it sorts by 1/4 mile ETs.. So it only shows times of those who have entered something into the 1/4 mile ET field..

If you select "sort by username" it displays the usernames alphabetically of everyone who has entered something into the 1/4 mile ET field. Same with showing naturally aspirated cars only. If the 1/4 mile ET field is left blank, they will not show on the list. Everything is based on the 1/4 mile ET. Of coarse you can easily change it so that it sorts by other things if you want. But thats the way its meant to work.

It will show the 1/8 mile ETs for everyone who has entered them only when sorting by 1/8 mile ET.

[EvilLS1]

EvilL, how did I miss that? :ermm:

Thanks. I knew it had to be here somewhere. I'll give it a try. :)
Cool, let me know if it works for ya. :)

[PranK]

EvilS1, I am having issues with mine since I upgraded to gold... everythings there and working, but people dont have any fields in the 'edit vehicle profile' section - nothing is displayed except for the form buttons... i tried uninstalling it and reinstalling it and found myself with double the fields, so deleted some and errrgh/....

any help would be great! Thanks mate!

Christian

[EvilLS1]

Prank,
Now that you've upgraded to gold, you'll need to re-apply all the file edits to admincp/user.php, member.php, includes/functions_user.php, profile.php, and includes/functions_online.php.

Dewayne

[PranK]

Dewayne,

I did this, when I had 2 lots of profile fields, i was able to add/edit etc, but now that i have deleted the lot that i added last (without any entries) the old profile fields cannot be accessed.

Thanks,

Christian

[EvilLS1]

Dewayne,

I did this, when I had 2 lots of profile fields, i was able to add/edit etc, but now that i have deleted the lot that i added last (without any entries) the old profile fields cannot be accessed.

Thanks,

Christian
Do this, go to your admincp, click modify custom profile fields, and tell me the field IDs for the timeslip fields.

[gibgib]

This hack is a good idea.

Is there something similar that will allow the user to add say 4 images via an upload button, some custom fields & a 500 character description field?

I run an automotive site. This is our current member gallery:
http://www.aussiefrogs.com/gallery/usergallery.htm
It is cluttered & requires a lot of maintenence. If the members could update their own page within the forum software it would be really good :classic:

[PranK]

Do this, go to your admincp, click modify custom profile fields, and tell me the field IDs for the timeslip fields.

Fields are 80-95, the ones it created the 2nd time were 50-65 (i think).

Christian

[PKRWUD]

PKRWUD,
Check and make sure you added the html to the timeslipsbit template. Then go into your admin panel and look under the custom profile fields section and make sure that the timeslip fields are there and that the IDs are 50-65. If thats not it, let me know and we'll figure it out. I'm sure its something simple.

This is what's in my timeslipbit template:

<tr align="center">
<td class="alt1">$rank</td>
<td class="alt2""><a href="member.php?$session[sessionurl]u=$userinfo[userid]">$username</a></td>
<td class="alt1">$ride</td>
<td class="alt2">$induction</td>
<td class="alt1"">$avghp$rwhp</td>
<td class="alt2">$avgsf$sixty</td>
<td class="alt1"">$avge$eighth$atmph1$eighthmph$spacer$avgemph</td>
<td class="alt2">$avgq$quarter$atmph2$quartermph$spacer$avgqmph</td>
<td class="alt1"">$details</td>
<td class="alt2">$slip</td>
</tr>



And my user fields include 1-10 and 50-65.

[gearshifter47]

Nothing is wrong. Thats the way it was designed to work. The Timeslip Database is mostly geared toward 1/4 mile ETs since thats the most popular track length.

By default it sorts by 1/4 mile ETs.. So it only shows times of those who have entered something into the 1/4 mile ET field..

If you select "sort by username" it displays the usernames alphabetically of everyone who has entered something into the 1/4 mile ET field. Same with showing naturally aspirated cars only. If the 1/4 mile ET field is left blank, they will not show on the list. Everything is based on the 1/4 mile ET. Of coarse you can easily change it so that it sorts by other things if you want. But thats the way its meant to work.

It will show the 1/8 mile ETs for everyone who has entered them only when sorting by 1/8 mile ET.

how do i go about fixing the sort by username, NA, and those to not require the 1/4 mile time?

[SVTBlackLight01]

This hack is a good idea.

Is there something similar that will allow the user to add say 4 images via an upload button, some custom fields & a 500 character description field?

I run an automotive site. This is our current member gallery:
http://www.aussiefrogs.com/gallery/usergallery.htm
It is cluttered & requires a lot of maintenence. If the members could update their own page within the forum software it would be really good :classic:

I think what your asking for is a vB Garage that every car site owner here has been asking for forever.

If you just need a good gallery, there are a few free ones that are good. Coppermine is good. Or if you want to pay for a gallery, check out PhotoPost.

[EvilLS1]

gibgib,
Yeah what you want is the vbgarage that everyone keeps requesting.. Not sure if anyone is developing it or not.. Theres a thread in the request forum about it.

PranK,
So the fields that are still in your database are 80-95 and fields 50-65 no longer exist correct? If so, in member.php, includes/functions_user.php, and profile.php you'll need to make sure the field ID#s match the field IDs that you have in your database.

In those files, find all instances of this (there will be several):

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


And replace it with this:

(80,81,82,83,84,85,86,88,89,90,91,92,93,94,95)

Or if I'm misunderstanding you and you're saying that you still have fields 50-65, then you'll need to do just the opposite. Also, make sure you have the correct field #s in timeslips.php.

PKRWUD,
For some reason your timeslipsbit template isn't being displayed. Make sure the template name is spelled correctly (its timeslipsbit not timeslipbit).. If thats not it send me a copy of your timeslips.php file and I'll take a look.


gearshifter47,
This will make it show everyone who has entered something into the ride field when sorting by username:

In timeslips.php find:

else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE userfield.field55>'".intval($number)."'";
$condition.=" AND userfield.field55>'".intval($number)."'";
$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";
}


Replace it with:

else if ($_REQUEST['do'] == 'username')
{
$cond.=" WHERE userfield.field50!=''";
$condition.=" AND userfield.field50!=''";
$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";
}



To make it show all N/A cars (when sorting by N/A) regardless if 1/4 mile ET has been entered find:

else if ($_REQUEST['do'] == 'na')
{
$condition.=" AND userfield.field65='$natasp' AND userfield.field55>'".intval($number)."'";
$cond.=" WHERE userfield.field55!=''";
$orderby="userfield.field55";
$direction=ASC;
$bracket13="<b>[</b>";
$bracket14="<b>]</b>";


Replace it with:

else if ($_REQUEST['do'] == 'na')
{
$condition.=" AND userfield.field65='$natasp' AND userfield.field50!=''";
$cond.=" WHERE userfield.field50!=''";
$orderby="userfield.field55";
$direction=ASC;
$bracket13="<b>[</b>";
$bracket14="<b>]</b>";

[magnus]

Heh, my scripts name has surpassed the script itself. vBGarage was short lived, the "powers that be" yanked it, because I used a portion of code from a coder who is no longer around to give consent. /shrug

It was for vB2, anyway. I've been developing a vB3 version, but unfortunately I started a new job and don't have the time to beat on it full time, so I can't really guestimate a release date.

FOCUS: EvilLS1, as always, still diggin' the hack.. the users love it. ;)

[gearshifter47]

this will still keep them in order right?

and how could i make username the default sort when i start up..

[EvilLS1]

It was for vB2, anyway. I've been developing a vB3 version, but unfortunately I started a new job and don't have the time to beat on it full time, so I can't really guestimate a release date.

I remember your garage for vb2. Looked pretty nice! I'm sure a vb3 version would be very popular with the automotive sites.. I'm in the same boat as you though... Due to work I don't have much spare time to try and make anything like that.

this will still keep them in order right?

and how could i make username the default sort when i start up..

Yes, they'll still be sorted by username alphabetically.

To make username the default sort method open timeslips.php and find:

// If no action is set order by quarter
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] ='quarter';
}


Replace it with:

// If no action is set order by username
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] ='username';
}


Find:

}
else
{
$cond.=" WHERE userfield.field55>'".intval($number)."'";
$condition.=" AND userfield.field55>'".intval($number)."'";
$orderby="userfield.field55";
$direction=ASC;
$bracket3="<b>[</b>";
$bracket4="<b>]</b>";


Replace it with:

}
else
{
$cond.=" WHERE userfield.field50!=''";
$condition.=" AND userfield.field50!=''";
$orderby="user.username";
$direction=ASC;
$bracket11="<b>[</b>";
$bracket12="<b>]</b>";

[PKRWUD]

PKRWUD,
For some reason your timeslipsbit template isn't being displayed. Make sure the template name is spelled correctly (its timeslipsbit not timeslipbit).. If thats not it send me a copy of your timeslips.php file and I'll take a look.


You know what? I think that's the exact same mistake I made when I installed the first version on my old board. I guess it's true what they say about teaching an old dog new tricks.

Evil- You really are a credit to programmers everywhere, especially the way you offer so much assistance. Most people would be sick of it, I'm sure. Thank you again for your patience and your help.

Take care,
~Chris

P.S. It's now available if you want to link to it...

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

[oly51]

...Evil- You really are a credit to programmers everywhere, especially the way you offer so much assistance. Most people would be sick of it, I'm sure. Thank you again for your patience and your help. [/url] I have been following this hack off and on for a while and am really impressed with the degree of support EvilLS1 has shown for this hack! Everytime I come back, Evil is here helping! Great job :up:

Now if we can only find a way to allow users or Admins/Mods to add multiple car listings or non-members info (maybe something in addition to using the member list??) with a few mods, we could end up with a vBgarage type hack.

[EvilLS1]

Thanks for the kind words guys, and glad to hear its working for you now Chris. :)

Added your link btw.

[gibgib]

Thanks for your responses.

I am pleading my case here (https://vborg.vbsupport.ru/showthread.php?t=59581&page=4&pp=15) now I know the name of the hack I need!

gibgib

[SNovotn2]

I dont know if I missed a step or something is just not right.. but:

The hack is working perfectly, except I want it to show the custom profile fields(ride, mods...) when you click on a member under the "additional information". It did it on one of the installs I did, but this time no luck.

In my admin CP I have them set as able to be seen in the member list. My timeslip profile fields are the standard 50-*.

I can call $post[field50] and it will show the users 'ride', but for some reason inside my memberinfo_customfields template it wants $profilefield[value].


Anyone? :)

Steve

[EvilLS1]

SNovotn2,
In the earlier versions the vehicle info was displayed in the user's regular profile (there was no vehicle profile).. With version 1.3 or later all vehicle details are displayed separately. But if you want to show the vehicle details in the user's regular profile (aswell as the vehicle profile) you can do it like this:

In member.php find:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $DB_site->query("
SELECT profilefieldid, required, title, type, data, def, height
FROM " . TABLE_PREFIX . "profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0 " . iif(!can_moderate(), "
AND hidden = 0") . "
ORDER BY displayorder
");


Replace it with:

// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $DB_site->query("
SELECT profilefieldid, required, title, type, data, def, height
FROM " . TABLE_PREFIX . "profilefield
WHERE form = 0 " . iif(!can_moderate(), "
AND hidden = 0") . "
ORDER BY displayorder
");

[PranK]

PranK,
So the fields that are still in your database are 80-95 and fields 50-65 no longer exist correct? If so, in member.php, includes/functions_user.php, and profile.php you'll need to make sure the field ID#s match the field IDs that you have in your database.

In those files, find all instances of this (there will be several):

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


And replace it with this:

(80,81,82,83,84,85,86,88,89,90,91,92,93,94,95)

Or if I'm misunderstanding you and you're saying that you still have fields 50-65, then you'll need to do just the opposite. Also, make sure you have the correct field #s in timeslips.php.


Champion Effort!

Thanks mate, all fixed!

Christian

[Dj22]

Just installed.. Killer!!

How hard would it for someone to modify it for users to have multiple car listings :speechless:

[EvilLS1]

Just installed.. Killer!!

How hard would it for someone to modify it for users to have multiple car listings :speechless:
Adding multiple cars to the vehicle profile page is easy.. But it would only be possible to sort by one car on the timeslips page.

To add a field for another car just go to your admincp, add a new custom profile field for the extra vehicle, make a note of the field ID, then in member.php, includes/functions_user.php, and profile.php find all instances of this:

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


and add the field ID for your extra vehicle field to it.

[Gt-358]

Adding multiple cars to the vehicle profile page is easy.. But it would only be possible to sort by one car on the timeslips page.

To add a field for another car just go to your admincp, add a new custom profile field for the extra vehicle, make a note of the field ID, then in member.php, includes/functions_user.php, and profile.php find all instances of this:

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


and add the field ID for your extra vehicle field to it.
So we can add a second vehicle to the profile, but can not add a second timeslip?

[EvilLS1]

So we can add a second vehicle to the profile, but can not add a second timeslip?
Exactly.

[Dsmed]

would this work with my forum running on php4 extensions?

thanks
-Brian

[EvilLS1]

would this work with my forum running on php4 extensions?

thanks
-Brian
Yep, it should. Just change all of the extensions to php4. Look through the templates too, 'cause theres a couple of places in there that will need to be changed.

[Dsmed]

well its all up and working now (somewhat) but it doesnt seem to save the data you enter

any idea what i could have missed or done wrong?

i tried this already
https://vborg.vbsupport.ru/showpost.php?p=493689&postcount=111

http://www.highertuning.com/forums/timeslips.php4?

[Dsmed]

oh,

in the top 5 hack you posted up, i cant find a couple of things you mentioned..

"In the $templatesused section"

and

"eval("dooutput(\"".gettemplate('index')."\");");"

thanks for the help

-Brian

[EvilLS1]

well its all up and working now (somewhat) but it doesnt seem to save the data you enter

any idea what i could have missed or done wrong?

http://www.highertuning.com/forums/timeslips.php4?
I think you either forgot to add or mis-spelled the name of your timeslipsbit template. Make sure its spelled timeslipsbit and not timeslipbit.

As for the top 5 addon, thats for VB2 and will not work with VB3 portals.

[EvilLS1]

Brian,
Its working fine. I just entered my data and its there.

Keep in mind that the default sort method is 1/4 mile ET and will only display users who have entered something into that field.

[Dsmed]

I think you either forgot to add or mis-spelled the name of your timeslipsbit template. Make sure its spelled timeslipsbit and not timeslipbit..


just checked and it is spelled correctly, it works on my test forum just fine which is just a php extension, so i must of messed something up in the conversion..

As for the top 5 addon, thats for VB2 and will not work with VB3 portals.

LOL well that explains alot! thanks you tons for your quick reply's

-Brian

[Dsmed]

Brian,
Its working fine. I just entered my data and its there.

Keep in mind that the default sort method is 1/4 mile ET and will only display users who have entered something into that field.


maybe it just needed your touch? LOL seems to be working fine now

thanks a ton!

[EvilLS1]

Alrgihty, glad its working for ya now. :)

[White Knight]

Nice work. I accually customized it for my Sportbike website. Had to change a few things in the database and code but otherwise the setup is the same.. Mostly the detail information needed to be suited for sportbikes but after i found out where your installed put the entries it was pretty simple. Thanks for sharing!

[EvilLS1]

Nice work. I accually customized it for my Sportbike website. Had to change a few things in the database and code but otherwise the setup is the same.. Mostly the detail information needed to be suited for sportbikes but after i found out where your installed put the entries it was pretty simple. Thanks for sharing!
Thanks. Nice to see that its useful for the two wheeled bunch aswell. :)

I guess I should mention (for everyone else who hasn't noticed) that all of the fields can be easily edited or customized in the admincp under custom profile fields once the hack is installed.

[VBDev]

I've installed this for someone but there are small bugs in timeslips.php file

You need to rename tables name in your query coz if there is a prefix, the table's name will not be correct

Replace

// Get total number of users
$userscount=$DB_site->query_first("SELECT COUNT(*) AS users
FROM " . TABLE_PREFIX . "user, " . TABLE_PREFIX . "userfield
$cond
AND user.userid = userfield.userid");

with

// Get total number of users
$userscount=$DB_site->query_first("SELECT COUNT(*) AS users
FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield
$cond
AND user.userid = userfield.userid");


And

// Get users
$users=$DB_site->query("SELECT *
FROM " . TABLE_PREFIX . "user, " . TABLE_PREFIX . "userfield
WHERE user.userid = userfield.userid
$condition
ORDER BY $orderby $direction
LIMIT $pos,$perpage");


with :

// Get users
$users=$DB_site->query("SELECT *
FROM " . TABLE_PREFIX . "user AS user, " . TABLE_PREFIX . "userfield AS userfield
WHERE user.userid = userfield.userid
$condition
ORDER BY $orderby $direction
LIMIT $pos,$perpage");

Now corrected and it works fine :)

[EvilLS1]

Good catch VBDev. Thanks. :) I'll change that in the next update. That didn't even cross my mind. I never paid much attention to the table prefix stuff b/c I don't use them.

[SVTBlackLight01]

I searched the thread, but didn't see this question. How hard would it be to display the user's rank by ET in the postbit?

[EvilLS1]

I searched the thread, but didn't see this question. How hard would it be to display the user's rank by ET in the postbit?
That would be really easy. Take a look at this post:
https://vborg.vbsupport.ru/showpost.php?p=485744&postcount=76

That shows the user's ET club in the postbit, but it would be really simple to change it so that it displays a rank image based on the ET. All you would need to do is change what the variable displays to an image instead of showing the club. For example:

If the member has a 10 second car,

$poop = "<img src=\"rankimage1.jpg\">";

else if the member has an 11 second car show:

$poop = "<img src=\"rankimage2.jpg\">";

etc, etc.

[SVTOA]

Has anyone installed this with 3.0.1 yet? Any issues?

[SVTBlackLight01]

Thanks for pointing out that post. That gives me a few ideas I might try. What I was thinking of though was having something like this in the postbit.

Join Date: Nov 2002
Location: Houston, TX
Age: XX
Posts: 1247

Best Time: 12.984@104.39
Ranked: #8

using their placement on the the timeslips list sorted by ET.

(I'm liking the rank image thing though :D )

[EvilLS1]

Has anyone installed this with 3.0.1 yet? Any issues?
Yes, I've installed it on 3.0.1 with no problems.

SVT,
That should be fairly easy to do also. If you can't get it I'll look into it after I finish upgrading my site.

[SVTBlackLight01]

You finally decided to take the plunge huh? I can't wait to check it out.

I may be able to figure the rank issue out. I just need to spend a little more time digging through the code. Thanks!

[EvilLS1]

You finally decided to take the plunge huh? I can't wait to check it out.


Yeah I've been putting it off for a while but I just can't stand not having the latest greatest thing. :)

Its up and running if ya wanna check it out. I still need to fine tune a few things but the hard part is done.

[EvilLS1]

<font size="4">Top 5 ETs Add-on for vB Advanced Homepage</font>

This adds a module to your Vb Advanced Homepage that shows the top five ETs from your Timeslip Database (see screenshot).

It should work with most other portals aswell.

[Rick Sample]

Ok all you car fans, who wants to help me install this hack? I tried for a few hours then I gave up. To difficult for my knowledge. If anyone can help, that would be awsome!

Thanks,

[SVTOA]

What steps have you done so far? What are you having trouble with?

[Rick Sample]

What steps have you done so far? What are you having trouble with?

I'm having trouble with it all. After I ran the install script, and edited all the files and stuff, it just got way to confusing. I'm very causiouse. Some of those lines and stuff you have to add are huge. When I paste them in and stuff, I don't know if I did it right or not because their not small little bits of info. Then it talked about creating templates and such and such. I was like: :confused: So I went back and undid all the changes. The only thing I didn't undo was the install script. I'm new to this stuff, the only hack I installed so far is Vbgarage. That wasn't to bad.

Do you think you could help me out any?

[EvilLS1]

muscle-mustangs,
I'm at work right now and can't do anything from here, but I'll help you install it when I get home tonight (11:30pm EST). Or maybe SVTOA can give you a hand with it before then.

Dewayne

[SVTOA]

I'm having trouble with it all. After I ran the install script, and edited all the files and stuff, it just got way to confusing. I'm very causiouse. Some of those lines and stuff you have to add are huge. When I paste them in and stuff, I don't know if I did it right or not because their not small little bits of info. Then it talked about creating templates and such and such. I was like: :confused: So I went back and undid all the changes. The only thing I didn't undo was the install script. I'm new to this stuff, the only hack I installed so far is Vbgarage. That wasn't to bad.

Do you think you could help me out any?


Sure, but I will need server access and cpanel access to be able to do this for you.

[Rick Sample]

Sure, but I will need server access and cpanel access to be able to do this for you.

Thats no prob. However, I don't use any Cpanel. I use Pcanywhere to connect to the server. The other admin has the server at his house. Will this be a problem? if so, if you want I could just send you the files that need edited if you would like. Let me know, maybe we can do it sometime soon over AIM.

Thanks man for helping! Cheers!

[SVTOA]

I'm talking about your forum CPANEL. For root access all I need is the IP address and login and I can edit the PHP files from a program I have. It's easier if I can work with the edited and unedited files for testing and such- If I make a mistake I can restore the correct working file in seconds, know what I mean?

[Rick Sample]

I'm talking about your forum CPANEL. For root access all I need is the IP address and login and I can edit the PHP files from a program I have. It's easier if I can work with the edited and unedited files for testing and such- If I make a mistake I can restore the correct working file in seconds, know what I mean?

Cool, so you just want me to set you up an admin account? I have a few I set up for testing, if you want I could send you the user id and password. As long as your sure you know what your doing, thats cool. Um how long should it take, and would you be able to do it anytime soon?

Thanks man,

[SVTOA]

Cool, so you just want me to set you up an admin account? I have a few I set up for testing, if you want I could send you the user id and password. As long as your sure you know what your doing, thats cool. Um how long should it take, and would you be able to do it anytime soon?

Thanks man,


As long as I am sure I know what I'm doing. I like that! :D

Since your website name is "Muscle Mustangs" I take it that you have read the well known publication of the same name? (with "AND FAST FORDS" tacked onto the end of course!) Assuming you have, in the last 12 months I have had 4 websites I have coded in full end up in Jeff Bauer's column. ;)
I am an administrator for the largest and oldest mustang website known to the Ford Fanatics in the audience. Do I qualify as worthy? https://vborg.vbsupport.ru/external/2004/04/2.gif

Shoot me an e-mail with the info I need, we'll see what we can do to help you.

[Rick Sample]

As long as I am sure I know what I'm doing. I like that! :D

Since your website name is "Muscle Mustangs" I take it that you have read the well known publication of the same name? (with "AND FAST FORDS" tacked onto the end of course!) Assuming you have, in the last 12 months I have had 4 websites I have coded in full end up in Jeff Bauer's column. ;)
I am an administrator for the largest and oldest mustang website known to the Ford Fanatics in the audience. Do I qualify as worthy? https://vborg.vbsupport.ru/external/2004/04/2.gif

Shoot me an e-mail with the info I need, we'll see what we can do to help you.

LOL...yeah I know that magazine, but unfortunetly I didn't name the site. The site was orriginaly just a plain black background with bright colored text links, someone came to me from stangnet and I went in and made the design and set up VB. Just wondering what did you mean when you said: "I have had 4 websites I have coded in full end up in jeff bauer's column." Is that a good thing or bad LOL. We have an "-" in ours so its not exactly the same. I'm sure your the best when it comes to coding and stuff, I mean you do have a nice layout on your site.

[SVTOA]

Check your PMs.

[SVTOA]

I screwed up Ricky's forum. It's all gone. :(

If I can help you with anything else Ricky, let me know. It turned out great. DeWayne writes good hacks. :)

[Rick Sample]

Thanks Greg you did a wonderfull job! Love the new feature you added to Vbgarage also! :banana: :banana: :banana:

[SVTOA]

At least someone's happy. :D

Like I said Ricky, if you need help with anything else, let me know...

[SVTOA]

NOTICE! Just incase you did not get Dewayne's e-mail- If you run Vb 3.0.1, you will have problems when manually editing user profiles (the e-mail mentions the timeslip fields, but you will not be able to reset passwords and other user functions). The fix in the e-mail says to download the latest version on the hack and re-apply the SECOND edit to admincp/user.php

After looking at the code, just do this:
In your EDITED version of admincp/user.php

Find:

if ($_POST['do'] == 'update')
{
globalize($_POST, array(
'password',
'user',
'membergroup',
'modifyavatar',
'birthday',
'signature',
'modifyprofilepic',
'joindate',
'lastvisit',
'lastactivity',
'lastpost',
'options',
'referrer',
'tdban',
'threaddisplaymode' => INT
));


Replace with:


if ($_POST['do'] == 'update')
{
globalize($_POST, array(
'password',
'user',
'membergroup',
'modifyavatar',
'birthday',
'signature',
'modifyprofilepic',
'joindate',
'lastvisit',
'lastactivity',
'lastpost',
'options',
'referrer',
'tdban',
'threaddisplaymode' => INT,
'profile'
));


That's all. Now you will again be able to edit user profiles from your admin cpanel.

Thanks for the update DeWayne. I noticed these problems but figured I messed up the file when I edited it and didn't even think to ask about it. DOH!!
Was very relieved when I got your update e-mail. :)

[0ptima]

I updated from version 1 to version 2 without a problem! Thanks EvilLS1

[EvilLS1]

Glad to hear the upgrade went smoothly Optima.

Greg,
Thanks for posting the update. :)

[SVTOA]

No problem DeWayne. Some people don't click the INSTALL button or they don't get the e-mails because of spam filters and such.

[joeychgo]

Evil, whats the difference from the 1st version to the new version?

[0ptima]

Evil, whats the difference from the 1st version to the new version?
Version 1.0 is for VB2 and Version 2.0 is for VB3

[hooolala]

hi.. i'm getting this error message, hope anybody can help me



Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: SELECT COUNT(*) AS users
FROM user AS user, userfield AS userfield
WHERE userfield.field55>'0'
AND user.userid = userfield.userid
mysql error: Unknown column 'userfield.field55' in 'where clause'

mysql error number: 1054

Date: Tuesday 04th of May 2004 09:31:38 PM
Script: http://vvti.net/forums/timeslips.php?
Referer: http://vvti.net/forums/
Username: hooolala
IP Address: 64.170.121.240

[EvilLS1]

Did you sucessfully run the TDinstaller.php script before doing the file edits?

[dmark101]

hmm.

installed it on my board. uploaded the edited files before running the TDinstaller, but the installer ran just fine.

i'm able to add the profile info, but when i click on the timeslip link in the navbar, i'm not able to see the test data i entered. what's up?

[EvilLS1]

dmark101,
I'm getting this error when viewing your timeslips.php page:
Unknown column 'userfield.field55' in 'where clause'

Do you have phpmyadmin? If so, can you verify that field55 exists in your userfield table?

[dmark101]

i went and removed the added columns and the edited files, then re-ran the installer and re-uploaded the files.

i didn't remove the timeslips file nor did i remove the changed templates only because i didn't think that would matter.

i'm going to test the install right now.

[EvilLS1]

Also, did you use the instructions & installer from the first post, or did you use one of the upgrade scripts?

[dmark101]

i used the one from the first post.

still not coming up at all. odd. :(

[EvilLS1]

i went and removed the added columns and the edited files, then re-ran the installer and re-uploaded the files.

i didn't remove the timeslips file nor did i remove the changed templates only because i didn't think that would matter.

i'm going to test the install right now.
Use the uninstaller to remove them.. Then run the installer again.

[EvilLS1]

Did you verify (with phpmyadmin) that field55 exists in the userfield table? Also, do you use table prefixes?

[dmark101]

yes, the field exists. already checked via phpmyadmin. what sort of prefix are you thinking of?

uninstaller? from the admin cp?

[EvilLS1]

yes, the field exists. already checked via phpmyadmin. what sort of prefix are you thinking of?

uninstaller? from the admin cp?
I just visited your site and it seems to be working now (for me).. Try re-entering your data in the vehicle profile and see if it shows on the timeslips page. Let me know.

[dmark101]

ok. ran the uninstaller, ran the installer again, uploaded all the files, entered some data and still nothing.

argh!

[EvilLS1]

It appears that your timeslipsbit template doesn't exists. Either that or you misspelled the name. Check the spelling of that template name. Its timeslipsbit, not timeslipbit.

BTW, I registered at your site and submitted timeslip data to test it, so you might wanna remove my info when we get it working for ya.

[dmark101]

LOL. okay, let me check that. thanks for helping me out, even if i also own an SVT.

;)

[dmark101]

ok, got it to work. :)

i've got another question. does this hack allow multiple entries?

[EvilLS1]

Glad ya got it workin. :) You could add a field for a second ride, but the timeslips page can only sort one vehicle per user.

[joeychgo]

One problem I have --

I also have AdColumns by magnus installed --- WIth every other page, my adcolumn does fine, displaying a right hand column. But with my timeslips page the column actually goes below the timeslips -- How do I get it so the column is on the right?

Link to my timeslips page (http://www.lincolnvscadillac.com/timeslips.php?)

[EvilLS1]

Looks like some table tags are misaligned. I think Magnus has this hack installed and I know he has adcolumns, so you could ask him to let you have a copy if his timeslips template with the adcolumns added to it. Then just replace your template with his and it should be aligned right.

[razer]

Is it possible to make the timeslip available only to certain usergroups ? And a function to enable/disable the whole function would be nice.

[EvilLS1]

Is it possible to make the timeslip available only to certain usergroups ? And a function to enable/disable the whole function would be nice.

You want to stop certian user groups from adding timeslip info but they can still see the timeslips page right?

If so, in profile.php find this:

if ($_REQUEST['do'] == 'edittimeslip')
{


Add this below it:
(change the x's in array(x,x,x) to the group IDs that you don't want to have access).

if (in_array($bbuserinfo['membergroupids'], array(x,x,x)))
{
print_no_permission();
}

[razer]

You want to stop certian user groups from adding timeslip info but they can still see the timeslips page right?

If so, in profile.php find this:

if ($_REQUEST['do'] == 'edittimeslip')
{


Add this below it:
(change the x's in array(x,x,x) to the group IDs that you don't want to have access).

if (in_array($bbuserinfo['membergroupids'], array(x,x,x)))
{
print_no_permission();
}



Thats exactly what i want, thanks! :)

[dmark101]

i had a small problem with the add on for timeslips if 12sec or lower, but i figured it out.

forgot that i had to change the variable <12 to whatever i wanted it to be. :mad:

awesome hack. :tup:

[paul_r]

installed it and when i ran timeslips.php
here what it threw up

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL: SELECT COUNT(*) AS users
FROM vb3_user, vb3_userfield
WHERE userfield.field55>'0'
AND user.userid = userfield.userid
mysql error: Unknown table 'userfield' in where clause

mysql error number: 1109

any ideas please ? id really like to get this working :)

[EvilLS1]

Paul,
Are you using the instructions from the first post of this thread? If so, did you download them recently or are you using a version that you downloaded some time ago? The reason I ask is because vbdev pointed out that the old version would give such an error if someone has table prefixes. I've updated the hack since then, so try redownloading the zip in the first post and replace timeslips.php with the new one. Also, re-apply the file edits to admincp/user.php as their was an update in that file aswell. Let me know if that doesn't solve your problem and we'll go from there.

[paul_r]

Paul,
Are you using the instructions from the first post of this thread? If so, did you download them recently or are you using a version that you downloaded some time ago? The reason I ask is because vbdev pointed out that the old version would give such an error if someone has table prefixes. I've updated the hack since then, so try redownloading the zip in the first post and replace timeslips.php with the new one. Also, re-apply the file edits to admincp/user.php as their was an update in that file aswell. Let me know if that doesn't solve your problem and we'll go from there.

you are right :) i d/l them a while ago and tried to install :ermm:

thanks for the update and a great hack :D

http://www.mx5roadsters.com/forums/timeslips.php?

[EvilLS1]

Glad its workin' for ya now. :)

[Silverstangs]

I have it installed on Stang Country (http://www.stangcountry.com/vb34sc/timeslips.php?) , works well, and we are running VB 3.0.1.
I did some minor adjusting for our needs, plus a conflick with another item that was installed, so I hope you don't mind.

[EvilLS1]

Looks good Silverstangs. :)

[350Chevy]

Installed at http://www.lssix.com/forums/timeslips.php? :)

[Frank Peterson]

Hello....We recently installed this at my website, http://www.stangcrazy.com This is a nice addition! We are still going to customize and add some things.

One thing I searched but haven't found was whether anybody had the set-up to allow for the timeslip to be uploaded, rather than the link?

Thanks, Great Mod!!

[Silverstangs]

Hello....We recently installed this at my website, http://www.stangcrazy.com This is a nice addition! We are still going to customize and add some things.

One thing I searched but haven't found was whether anybody had the set-up to allow for the timeslip to be uploaded, rather than the link?

Thanks, Great Mod!!

Good idea --- maybe when I get borred I'll try that. It can't be much harder than adding a Torque colum...

[EvilLS1]

Hello....We recently installed this at my website, http://www.stangcrazy.com This is a nice addition! We are still going to customize and add some things.

One thing I searched but haven't found was whether anybody had the set-up to allow for the timeslip to be uploaded, rather than the link?

Thanks, Great Mod!!
Yeah I need to add that. One of these days I'll start working on v2.1 which will include that feature.

<---- Very lazy :)

[SVTOA]

Lazy??? That hardly describes you Dewayne...

Frank, does your site have "Photopost"? Just create a cat for timeslips... Takes two secs to paste the URL to a timeslip from the PP gallery...

[EvilLS1]

Lazy??? That hardly describes you Dewayne...


Yeah, I'm just motivationally challenged. :p

It should be fairly easy to add uploads though.. That is definitely on my to-do list for 2.1.

[Frank Peterson]

Thanks for the quick responses, I most certainly look forward to this. We do not have photopost but perhaps that is something I should look into...so much going on though.

[EvilLS1]

I've started working on v2.1 which will include the ability to upload timeslips. Its turning out to be a little more work than I expected but I should be able to post it within the next week or two.. I'm about half way through it now but I still have to beta test it on my site for a while, update the original instructions to 2.1, and create an upgrade script.

I'll send an email update when its posted. :)

[0ptima]

I've started working on v2.1 which will include the ability to upload timeslips. Its turning out to be a little more work than I expected but I should be able to post it within the next week or two.. I'm about half way through it now but I still have to beta test it on my site for a while, update the original instructions to 2.1, and create an upgrade script.

I'll send an email update when its posted. :)
Sounds kewl! I will definetly upgrade form version 2.

[joeychgo]

thanks evil, its a great hack

[443dds]

You want to stop certian user groups from adding timeslip info but they can still see the timeslips page right?

If so, in profile.php find this:

if ($_REQUEST['do'] == 'edittimeslip')
{


Add this below it:
(change the x's in array(x,x,x) to the group IDs that you don't want to have access).

if (in_array($bbuserinfo['membergroupids'], array(x,x,x)))
{
print_no_permission();
}


This doesn't seem to work for me. I had a line existing, so I just added the membergroupids thing after it.


if ($_REQUEST['do'] == 'edittimeslip')
{
if ($bbuserinfo[userid]==0 or $bbuserinfo[tdban]==0 or in_array($bbuserinfo['membergroupids'], array(1,2,3,4,5,6,7,8,9,10)))
{
print_no_permission();
}
unset($tempcustom);
...


When I login as anybody, it still allows me to edit the Vehicle Profile. I have added all the groupids, but still I seem to be missing something.

Any ideas?

[EvilLS1]

Try this on a seperate line:

if (in_array($bbuserinfo['usergroupid'], array(x,x,x)))
{
print_no_permission();
}

[Boofo]

Try this on a seperate line:

if (in_array($bbuserinfo['usergroupid'], array(x,x,x)))
{
print_no_permission();
}

The first one you had here will work if you have merk's change for the is_member_of installed. ;)

[EvilLS1]

The first one you had here will work if you have merk's change for the is_member_of installed. ;)
I wasn't sure... I've never used the is_member_of function so I figured I'd better stick with what I know.

[EvilLS1]

BTW, I have v2.1 with the upload feature running on my site right now.. So far it seems to be working flawlessly but I wanna test it for a few more days and then I'll start working on the upgrade script & instructions. :)

[r6xual]

added to my website at

http://gpfanatix.com/forums/timeslips.php?

[tteal]

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, a link to 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.
*Vehcile Profile (separate from user profile)
*Ability to ban users from editing their vehicle profile
*Installer
*Uninstaller


Demo:
http://modernmusclecars.net/forums/timeslips.php

vb.org member sites w/Timeslip Database v2.0 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/vb34sc/timeslips.php
http://www.lssix.com/forums/timeslips.php
http://gpfanatix.com/forums/timeslips.php

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 (https://vborg.vbsupport.ru/attachment.php?attachmentid=16362)
Vehicle Profile (https://vborg.vbsupport.ru/attachment.php?attachmentid=16363)
Edit Vehicle Profile (https://vborg.vbsupport.ru/attachment.php?attachmentid=16368)


Installation overview:
Files to edit: (5)- admincp/user.php, member.php, includes/functions_user.php, profile.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:
I will support basic installation and troubleshooting only. Since I don't use VB3 on my own site, I will not be offering support for customizing or adding new features.
Instead, I urge those of you who install it to share your customizations & add-ons with others. If you have a useful addition to this hack, post it here and I'll add a link to your post in the add-ons section below.

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 front page portal (vb Advanced Homepage) (https://vborg.vbsupport.ru/showpost.php?p=502749&postcount=162)
*Require a link to the actual timeslip for all ETs that are 11.99 or quicker (https://vborg.vbsupport.ru/showpost.php?p=470681&postcount=3)
*Change the default sort method (https://vborg.vbsupport.ru/showpost.php?p=477525&postcount=54)
*Show the ET club that users belong to in the postbit. (https://vborg.vbsupport.ru/showpost.php?p=485744&postcount=76)


This has been confirmed to work with vB 3.0.0, 3.0.1, and all RC versions.

Thanks to Corsacrazy for beta testing this for me.

Download vB Timeslip Database v2.0 (https://vborg.vbsupport.ru/attachment.php?attachmentid=18459)


If you find this script useful please click install. :)
Could you add my site to the list please? http://www.tealnet.com/forum

Thanks,
Tim

P.S. Thank you for making this available for those of us with car related sites!!!!

[tteal]

EvilLS1,
Thanks again for this modification!!!! It is awesome! Just one suggestion possibly if you don't mind?

Some folks like myself really keep track of our timeslips and the way this database is currently setup it only allows for one timeslip. Possibility in the future that you'll allow one user to have multiple slips so they can compare mods vs times? :) You know my supercharged Mustang is very slow so I have to keep up with what mod works vs doesn't...

Cheers,
Tim

[EvilLS1]

Added gpfanatix and tealnet.com. :)

Tim,
Nice site. I used to visit tealnet back when I had my 92 GT. :) Anyway, adding the ability for users to show the data from a second timeslip in the vehicle profile shouldn't be too difficult. But I'm pretty sure that adding the ability for the timeslips database page to sort more than one timeslip per user would require a re-write of the entire hack. :( I'll think on it more and maybe I can come up with something by the time v2.2 is released.

@ everyone else,
350Chevy and I are currently beta testing v2.1 and so far its running smoothly. If we don't find anymore bugs within the next few days I'll release it.

[tteal]

Added gpfanatix and tealnet.com. :)

Tim,
Nice site. I used to visit tealnet back when I had my 92 GT. :) Anyway, adding the ability for users to show the data from a second timeslip in the vehicle profile shouldn't be too difficult. But I'm pretty sure that adding the ability for the timeslips database page to sort more than one timeslip per user would require a re-write of the entire hack. :( I'll think on it more and maybe I can come up with something by the time v2.2 is released.

@ everyone else,
350Chevy and I are currently beta testing v2.1 and so far its running smoothly. If we don't find anymore bugs within the next few days I'll release it.

Thanks! I used to really keep up with my site back in the day when I was doing a lot of custom scripting (*.asp / SQL) but I don't know much about *.php / MySQL / Perl or I'd offer to help you. My knowledge is very limited so I have a big learning curve. You got rid of the 92? LOL.... I've had my 98 GT for over 6 years now and just got new forged 284 ci to run a lot of boost... we'll see how it goes.

No rush on the modification that I requested (multiple timeslips for one person) just a suggestion.

Thanks!!!!
Tim

[EvilLS1]

You got rid of the 92? LOL.... I've had my 98 GT for over 6 years now and just got new forged 284 ci to run a lot of boost... we'll see how it goes.

Tim

Yeah I sold it shortly after purchasing the T/A. I do miss it.. That car was alot of fun! I can't complain about the T/A's performance though considering it went high 11s N/A with only boltons. I just wish it was a little easier to work on. :)

[tteal]

Yeah I sold it shortly after purchasing the T/A. I do miss it.. That car was alot of fun! I can't complain about the T/A's performance though considering it went high 11s N/A with only boltons. I just wish it was a little easier to work on. :)
I almost traded the 98 in for a 99 WS6 but already had thousands of $$$ in it and couldn't justify it to myself. I"m not in 11's yet but hope to be in 11's if not better with the new combination... only time will tell though. I had the mph with my previous combination but only made 2 passes before changing over to forged internals and cranking up the boost. So we'll see what this season brings.

By the way, what chat program are you running on your board? I'd like to integrate some kind of chat that already knows usernames, etc on my forums in the chat.

[EvilLS1]

I almost traded the 98 in for a 99 WS6 but already had thousands of $$$ in it and couldn't justify it to myself. I"m not in 11's yet but hope to be in 11's if not better with the new combination... only time will tell though. I had the mph with my previous combination but only made 2 passes before changing over to forged internals and cranking up the boost. So we'll see what this season brings.

By the way, what chat program are you running on your board? I'd like to integrate some kind of chat that already knows usernames, etc on my forums in the chat.
Sounds cool! I bet your car will run pretty hard if you can get it to hook up. :)

I'm using jpilot IRC chat on my site. Check out this link:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=65099
There you'll find a hack to show whos in chat on your forum home and also a link to get the jpilot chat software.

[EvilLS1]

v2.1 released!

New features:
* Users can upload their timeslip in the vehicle profile.
* Timeslip uploads can be disabled in the admincp (switches to link mode when disabled).
* Admin can delete user's uploaded timeslip.
* Maximum width, height and filesize for timeslip uploads can be set in the admincp.
* Admin can set an ET for which an actual timeslip is required if the user's ET is quicker.

A few notes about this version:
When upload mode is enabled, old linked timeslips that may have been added in the previous version will still be visible until the user updates his vehicle profile. When a slip is uploaded the old linked slip is automatically removed.

When uploads are disabled it will automatically switch to the link mode. Previously uploaded timeslips will still be visible unless the admin deletes them.

To see the new admincp settings go to admincp + vboptions + Timeslip Database Settings.

You can delete a user's uploaded slip by clicking "user options" on the 'view vehicle profile' page.

[0ptima]

Ill upgrade to 2.1 after the grandprix weekend. Thanks EvilLS1!

[tteal]

Ill upgrade to 2.1 after the grandprix weekend. Thanks EvilLS1!
EvilLS1,
Awesome upgrade! I just did it and it works great.

Couple of recommendations:

1. Multiple timeslips for single user :) hahahaha...
2. Admin ability to delete the actual timeslip (just in case someone put a bogus one in there).

That's all I can think of right now. Thanks again for making this available!!!!

Thanks,
Tim

[EvilLS1]

2. Admin ability to delete the actual timeslip (just in case someone put a bogus one in there).


Thats already in there. When viewing a user's vehicle details page click "user options" & scroll down to where it says "Delete Uploaded Timeslip?". ;)

[BamaStangGuy]

How do I make the My Best Et not appear in post bit if they dont have anything entered.

See this: http://www.mustang-forums.com/forums/showthread.php?t=6937

It says My Best ET: 00.00 if they dont have one entered.

I want to make it where it just doesnt appear

[EvilLS1]

How do I make the My Best Et not appear in post bit if they dont have anything entered.

See this: http://www.mustang-forums.com/forums/showthread.php?t=6937

It says My Best ET: 00.00 if they dont have one entered.

I want to make it where it just doesnt appear
Put this in your postbit template where you want the ET to show up:


<if condition="$post[field55]>0">
<span class="smallfont">1/4 Mile ET: $post[field55]</span>
</if>

[dcevoclub]

anyone willing to help me? i'd like to add classes, like drag class, street class, ect. to better catigorize the different times, and display them on the timeslips.php page,

i just need to know where to edit to add these features.... but i'd really like another column on the main page showing "Class"

[Dj22]

i could be wrong but when i installed this users were able to upload avatars as big as timeslips..

its seems to be the graphic type it enables it for a larger size in the functions_upload file?

i turned it back to the original one and it worked for the avatars

[EvilLS1]

i could be wrong but when i installed this users were able to upload avatars as big as timeslips..

its seems to be the graphic type it enables it for a larger size in the functions_upload file?

i turned it back to the original one and it worked for the avatars

Ah, I know what the problem is. At some point the $permissions variable was changed to $imagepermissions in the functions_upload.php file. I copied that bit from my test board which is running RC1.. I believe this was changed in RC2 or RC3.

Anyway, heres the fix (only needed if you have v2.1):

In includes/functions_upload.php find:

if ($type=="timeslippic") {
$maxwidth=$vboptions[tdmaxwidth];
$maxheight=$vboptions[tdmaxheight];
$maxsize=$vboptions[tdmaxsize];
} else {
// get maximum filesize/dimensions etc.
$maxwidth = &$permissions[$type . 'maxwidth'];
$maxheight = &$permissions[$type . 'maxheight'];
$maxsize = &$permissions[$type . 'maxsize'];
}


Replace it with:

if ($type=="timeslippic") {
$maxwidth=$vboptions[tdmaxwidth];
$maxheight=$vboptions[tdmaxheight];
$maxsize=$vboptions[tdmaxsize];
} else {
// get maximum filesize/dimensions etc.
$maxwidth = &$imagepermissions[$type . 'maxwidth'];
$maxheight = &$imagepermissions[$type . 'maxheight'];
$maxsize = &$imagepermissions[$type . 'maxsize'];
}


I updated the hack instructions. Thanks for pointing this out. :)

[dcevoclub]

ok i added a new column to the userfield database, however i can't seem to find where this adds the variables, or inserts them to the database? this is for the "classing" addon that i asked for help 2 days ago.

i added 1 line to profilefields, and now

Warning: Invalid argument supplied for foreach() in /home/dsmdragtimes/includes/functions_user.php on line 575

[EvilLS1]

ok i added a new column to the userfield database, however i can't seem to find where this adds the variables, or inserts them to the database?

dcevoclub,
I'm still not clear on exactly what you're trying to do. If you can give me a better description I'll try to help you when I get time.

If I'm understanding correctly, you want to add a drop down menu to the edit vehicle profile page which allows the user to select a class. Then you want to add the ability to sort by classes to timeslips.php? If so, tell me the name of each class that can be selected.

Also, it would be much easier for me to just add this myself rather than trying to explain how to add it. If you'll set me up a temporary admin account and FTP account I'll add it for you.


this is for the "classing" addon that i asked for help 2 days ago.

I do appologize and I wasn't trying to ignore your request, but as I stated in the first post of this thread:

"Support:
I will support basic installation and troubleshooting only. I will not be offering support for customizing or adding new features."

It would be nearly impossible for me to help customize this hack for everyone who installs it. I work 6 days per week and simply don't have time.

[dcevoclub]

dcevoclub,
I'm still not clear on exactly what you're trying to do. If you can give me a better description I'll try to help you when I get time.

If I'm understanding correctly, you want to add a drop down menu to the edit vehicle profile page which allows the user to select a class. Then you want to add the ability to sort by classes to timeslips.php? If so, tell me the name of each class that can be selected.

Also, it would be much easier for me to just add this myself rather than trying to explain how to add it. If you'll set me up a temporary admin account and FTP account I'll add it for you.


I do appologize and I wasn't trying to ignore your request, but as I stated in the first post of this thread:

"Support:
I will support basic installation and troubleshooting only. I will not be offering support for customizing or adding new features."

It would be nearly impossible for me to help customize this hack for everyone who installs it. I work 6 days per week and simply don't have time.


sorry... what files do you need to edit so i can arrange for them to be "editable" but yes, thats all i want, is to have different classing, for lets say, street, and full drag or whatever.

[EvilLS1]

sorry... what files do you need to edit so i can arrange for them to be "editable" but yes, thats all i want, is to have different classing, for lets say, street, and full drag or whatever.
member.php, includes/functions_user.php, and timeslips.php.

Also, I need to know the exact name of all classes that you want availible in the drop down menu.

You can email me at webmaster@modernmusclecars.net

[EvilLS1]

dcevoclub,

First go to your admincp and add a new custom profile field. The names of the classes must be exactly as I list them or it won't work when sorting on the timeslips page.

Go to: admincp >> User Profile Fields >> Add New User Profile Field

Profile Field Type: Single Selection Menu

Click Continue.

Title: Class
Description: whatever you want

Options:
Street
Outlaw
Full Drag

Set Default: Yes, include a first blank option.

Display Order: Whatever you want

Field Required: No

Field Editable by User? Yes

Field Hidden on Profile? No

Field Searchable on Members List? No

Show on Members List? No

Allow user to input their own value for this option? No

Max length of allowed user input: 15

Display Size: 15

Regular Expression: 0

Which page displays this option? Edit Profile

Click Save.


Now on the next screen (the user profile field manager screen) find the new field that you just added. Over to the right of the new field you'll see a link that says [Edit]. Hold your mouse over that link (don't click it) and look at the bottom of your browser where it shows the url. Make a note of the field ID # for the field you just added.

Assuming that you're still using v2.0 in member.php and includes/functions_user.php find all instances of this (there will be several):


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


Now in the code below replace the XX with the field ID of the new class field.. Then copy the code below and replace ALL instances of the code above in member.php and includes/functions_user.php:

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


Save & upload.

Now open timeslips.php and find this:


$natasp='N/A';


Below it add this:

$street = 'Street';
$outlaw = 'Outlaw';
$drag = 'Full Drag';


Still in timeslips.php find:


}
else if ($_REQUEST['do'] == 'na')
{
$condition.=" AND userfield.field65='$natasp' AND userfield.field55>'".intval($number)."'";
$cond.=" WHERE userfield.field55!=''";
$orderby="userfield.field55";
$direction=ASC;
$bracket13="<b>[</b>";
$bracket14="<b>]</b>";


Below it add:

}
else if ($_REQUEST['do'] == 'street')
{
$condition.=" AND userfield.fieldXX='$street' AND userfield.field55>'".intval($number)."'";
$cond.=" WHERE userfield.field55!=''";
$orderby="userfield.field55";
$direction=ASC;
$bracket133="<b>[</b>";
$bracket143="<b>]</b>";
}
else if ($_REQUEST['do'] == 'outlaw')
{
$condition.=" AND userfield.fieldXX='$outlaw' AND userfield.field55>'".intval($number)."'";
$cond.=" WHERE userfield.field55!=''";
$orderby="userfield.field55";
$direction=ASC;
$bracket133="<b>[</b>";
$bracket143="<b>]</b>";
}
else if ($_REQUEST['do'] == 'drag')
{
$condition.=" AND userfield.fieldXX='$drag' AND userfield.field55>'".intval($number)."'";
$cond.=" WHERE userfield.field55!=''";
$orderby="userfield.field55";
$direction=ASC;
$bracket133="<b>[</b>";
$bracket143="<b>]</b>";


Now in the chunk of code above find all 3 instances of XX and replace it with the field ID for the new class field.


Still in timeslips.php find:

$spacer=" - ";


Below it add:

$class = "---";


Find:

$pos++;


Below it add:

$class = $userinfo[fieldXX];

Again, replace the XX in the code above with the field ID for the class field.


Save and upload timeslips.php

In your timeslips template find:

<td bgcolor="{categorybackcolor}" colspan="5" class="tcat"><b> Timeslip Database


Replace it with:

<td bgcolor="{categorybackcolor}" colspan="6" class="tcat"><b> Timeslip Database


Find:

<option value="timeslips.php?$session[sessionurl]&do=na">N/A cars only</option>


Below it add:

<option value="timeslips.php?$session[sessionurl]&do=street">Street Class</option>
<option value="timeslips.php?$session[sessionurl]&do=outlaw">Outlaw Class</option>
<option value="timeslips.php?$session[sessionurl]&do=drag">Full Drag Class</option>


Find:

<td class="thead" align="center">$bracket13<b>Induction</b>$bracket14</td>


Below it add:

<td class="thead" align="center">$bracket133<b>Class</b>$bracket143</td>


Find:

<td class="tfoot" colspan="10">


Replace it with:

<td class="tfoot" colspan="11">



In your timeslipsbit template find:

<td class="alt2">$induction</td>


Below it add:

<td class="alt1">$class</td>


Thats it! If you added the profile field class names exactly as I said and you replaced all of the XXs with the correct field ID it will work.


Now you know why I said it would be much easier if I just do it myself. ;)

[dcevoclub]

ok thanks man, i got it in, but when you go to submit time slip it doesn't show, on the main page it shows the "class" column... do i need to edit profile.php?

[EvilLS1]

ok thanks man, i got it in, but when you go to submit time slip it doesn't show, on the main page it shows the "class" column... do i need to edit profile.php?
No edits to profile.php are needed. Also this has no effect on showing the timeslips. Did you make other changes earlier that need to be removed? If not, go back and re-check all of the edits to make sure they're correct. If you didn't miss anything it will work.

[dcevoclub]

No edits to profile.php are needed. Also this has no effect on showing the timeslips. Did you make other changes earlier that need to be removed? If not, go back and re-check all of the edits to make sure they're correct. If you didn't miss anything it will work.

i wiped everything out and re-installed from scratch, and follwed the instructions there is still not dropbox in the edit profile for the class under induction which is where is suppose to be right?