vB Timeslip Database -for Automotive websites [Archive]

EvilLS1

10-20-2003, 10:00 PM

I doubt this will be used by many people since its designed specifically for automotive websites.. But it has been requested here several times, so here ya go.

What does it do? This hack does a few things. First, it will add a separate Vehicle Profile page to your forum where your users can enter their type of vehicle, horsepower, best 60' time, 1/8 mile time, 1/4 mile time, a link to their timeslip and more. Once the data is entered the timeslips.php page will display the info sorted by the best times, highest trap speeds, highest horsepower #s, proof of ET, or ET brackets (user selectable).

You can also ban users from editing their Vehicle Profile. This comes in handy if you have some users who insist on entering false data into the Timeslip Database just to be funny. To use this feature, just click on the user's profile, then click "user options" and set "Can edit vehicle profile" to no. The user will still be able to edit his regular profile, but not his vehicle profile.

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

(Note: I just added this to my board a couple of days ago so there's only a few entries right now.. It does have pagination and will display 25 per page by default once more ETs are entered.)

Screenshot1: Vehcile Profile page (https://vborg.vbsupport.ru/attachment.php?attachmentid=15022)
Screenshot2: Edit Vehcile Profile page (https://vborg.vbsupport.ru/attachment.php?attachmentid=15021)

Features include:
*The ability to sort by:
-1/4 Mile ET
-1/4 Mile MPH
-1/8 Mile ET
-1/8 Mile MPH
-60' Time
-Horsepower
-Cars with proof of ET (actual timeslip)
-Username
-ET brackets (New!)
*Show the average ET, MPH, and HP for your site. (New!)
*Vehcile Profile (separate from user profile) (New!)
*Ability to ban users from editing their vehicle profile (New!)
*Installer

Installation is easy:
1. Upload TDinstaller.php to your admin directory & run the installer.
2. Follow the hack instructions to edit the 4 php files.
3. Edit two templates.
4. Add five new templates.
5. Upload timeslips.php to your forum directory and slipicon.gif to your image directory.

This has been tested on 2.2.8 - 2.3.2 and should work fine with any 2.X.X version.

Note: I don't use vb 2.X anymore so this hack is no longer supported

Download vB Timeslip Database v1.3 (https://vborg.vbsupport.ru/attachment.php?attachmentid=15044)

(Version 2.0 is availible for VB3 users here (https://vborg.vbsupport.ru/showthread.php?s=&threadid=60945).)

Add-ons:
*Add-on: Display the Top Five 1/4 mile ETs on your front page portal (https://vborg.vbsupport.ru/showpost.php?p=442810&postcount=30)
*Add-on: Require a link to the actual timeslip for all ETs that are 11.99 or quicker. (https://vborg.vbsupport.ru/showpost.php?p=448817&postcount=126)
*Add-on: A "timeslips" button for your header (PSD and GIF). (https://vborg.vbsupport.ru/showpost.php?p=447141&postcount=117) -by Optima
*Add-on: Show the ET club that users belong to in the postbit. (https://vborg.vbsupport.ru/showpost.php?p=485742&postcount=196)
*How to: Add a "select" field & sort by it in the timeslip database. (https://vborg.vbsupport.ru/showpost.php?p=442840&postcount=32)
*How to: Change the default sort method (https://vborg.vbsupport.ru/showpost.php?p=442298&postcount=15)

Updated 10-29-03 to add new features: - Added the ability to sort by ET brackets. (ie. show 10 second cars only. 11 second cars only, 13 sec cars, etc). Requested by BrendonM
Check the demo page to see it in action.

Updated 10-31-03 (new feature): -Added a new action that will show the average ET, trap speed, and horsepower for your site.
Go to the demo page and select "Site Averages" from the drop down menu to see what I mean.

Updated 11-10-03: -Added the vehicle profile addon to the hack instructions. Added a few new fields to the vehicle profile page (race weight, track, D/A, mods, tranny type, etc). Added a "details" column to the Timeslip Database page which lets you view all vehicle profile fields when the details link is clicked (see demo).

Instructions (https://vborg.vbsupport.ru/attachment.php?attachmentid=15043) for upgrading all previous versions to v1.3.

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

corsacrazy

10-21-2003, 09:28 PM

im the 1st to congratulate you and install NICE ONE

corsacrazy

10-21-2003, 09:44 PM

i have made these fields required to suit the design of my modify profile page BUT how can i hide these profile fields on register?

drumsy

10-21-2003, 09:56 PM

Looks good. I plan on using it in the future. In the meantime, how do I remove the installation?

EvilLS1

10-21-2003, 10:01 PM

corsacrazy,
You would have to exclude those fields from $customfields in register.php. I'll check it out for you later.

drumsy,
In your admin panel go to modify profile fields & remove them.

corsacrazy

10-21-2003, 10:40 PM

corsacrazy,
You would have to exclude those fields from $customfields in register.php. I'll check it out for you later.

thanks for being helpfullm where abouts and how wouldi exlude the fields

i like the way u managed to make these fiels id's like 50 + ;) clever

EvilLS1

10-21-2003, 11:23 PM

Corsa,

In register.php find:

// get extra profile fields
$profilefields=$DB_site->query("SELECT *
FROM profilefield
WHERE editable = 1
ORDER BY displayorder");

Replace it with:

// get extra profile fields
$profilefields=$DB_site->query("SELECT *
FROM profilefield
WHERE editable = 1
AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)
ORDER BY displayorder");

That should do it.

corsacrazy

10-21-2003, 11:31 PM

i got it werking now

MindTrix

10-22-2003, 03:44 PM

Nice work here sure it would benifit alot of people, unfortunatly not me but hey, seems a nice idea to me. Well done

corsacrazy

10-22-2003, 03:47 PM

how to chnage it so that a user doesnt have to fill in EVERY field for it to appear on timeslips.php ?

EvilLS1

10-22-2003, 03:57 PM

how to chnage it so that a user doesnt have to fill in EVERY field for it to appear on timeslips.php ?

They don't have to fill in every field for it to appear.. The default sort method is by 1/4 mile ET, so it will only show users who have entered something into the 1/4 mile ET field.. But if someone only posts an 1/8 mile ET, it will show them if you select "sort by 1/8 mile ET" from the drop down menu. Same with horsepower, mph, and 60' times. The username method sorts by username AND 1/4 mile ET. So if the 1/4 mile ET field is left blank, they won't show up. You can change the default sort method to something else, if thats what you mean.

Josh Combs

10-22-2003, 06:54 PM

Has anyone installed it on 2.3.2??? Thanks

corsacrazy

10-22-2003, 07:22 PM

The default sort method is by 1/4 mile ET,

You can change the default sort method to something else

ok how can i change the default to 60 foot times ? cheers

drumsy

10-22-2003, 09:44 PM

Has anyone installed it on 2.3.2??? Thanks

I installed it and it works fine for me! :)

EvilLS1

10-22-2003, 11:13 PM

ok how can i change the default to 60 foot times ? cheers

In timeslips.php find:

// If no action is set order by quarter
if (!isset($action) or $action=="") {
$action="quarter";
}

Replace it with:

// If no action is set order by sixty
if (!isset($action) or $action=="") {
$action="sixty";
}

Find:

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

Replace it with:

} else {
$cond.=" WHERE userfield.field52>'".intval($number)."'";
$condition.=" AND userfield.field52>'".intval($number)."'";
$orderby="userfield.field52";
$direction=ASC;
}

Josh Combs

10-23-2003, 12:43 AM

I have it running on my forums also now :) thanks for the great hack.

Josh
http://www.gmperformancetuning.com

EvilLS1

10-23-2003, 03:31 AM

y/w Josh. Glad you like it. :)

corsacrazy

10-23-2003, 06:20 AM

perfect :) i see good things in the future for this one and car sites :)

SVTBlackLight01

10-23-2003, 07:34 AM

Great Hack!! :up:

This has been out for phpBB for a while. I was waiting on someone to make one for VB.

Good Job!

EvilLS1

10-23-2003, 11:13 AM

Thanks.

This has been out for phpBB for a while. I was waiting on someone to make one for VB.

Do you mean this one?
http://phpbbhacks.com/viewhack.php?id=546

Thats my hack also. I made it about a year and a half ago when I was using phpBB. :)

Dewayne

VampireMan

10-23-2003, 11:18 AM

I gotta thank you for this , my site is totaly not to do with cars. But wedding forums. Im adapting the timeslips database for my needs.

It's easy to understand the code , and so it's easy for me to adapt. Im allready 50% along the way of changing the feilds over all ready. Good code is easy to edit. And the code in this is very good , thanks. :)

EvilLS1

10-23-2003, 03:00 PM

You're welcome. Good luck w/ converting it to suit your needs. :)

corsacrazy

10-23-2003, 04:04 PM

is it possible to produce addons for homepages ? ie top 5 cars sorted by XXX ?

gmarik

10-23-2003, 04:17 PM

A good hack, could add more features in the future!

VampireMan

10-23-2003, 07:53 PM

Done the conversion , must say i really enjoyed doing this.
Going to add more as i go , but thanks for the base :)

Pic included of finished conversion

Chris

SVTBlackLight01

10-24-2003, 12:26 PM

Thanks.

Do you mean this one?
http://phpbbhacks.com/viewhack.php?id=546

Thats my hack also. I made it about a year and a half ago when I was using phpBB. :)

Dewayne

Yep. Same one!

SpeedStreet

10-24-2003, 01:34 PM

Very nice....someone from the car communities actually sharing their hacks for once :)

Nice job!

ImportPassion

10-24-2003, 02:33 PM

Looks cool. Installing now.

One thing I noticed is that you hardcoded id's in there

$DB_site->query("INSERT INTO profilefield (profilefieldid,title,description,required,hidden, maxlength,size,displayorder,editable) VALUES (50,'".addslashes($aa)."','".addslashes($a)."',0,0,'20','20','50', '1')");

You might want to consider this instead

$DB_site->query("INSERT INTO profilefield (title,description,required,hidden,maxlength,size, displayorder,editable) VALUES ('".addslashes($aa)."','".addslashes($a)."',0,0,'20','20','50', '1')");

$newid = mysql_insert_id();
$DB_site->query("ALTER TABLE userfield ADD field".$newid." CHAR(250) NOT NULL");

You may mess up some users installs if they have those id's already.

Thanks for the hack.

Derek

EvilLS1

10-24-2003, 06:44 PM

corsacrazy ,
Yes, I can make an add-on for portals that will show the top 5 quickest cars. I'll make it as soon as I get some free time (maybe this weekend) and post it here.

VampireMan,
Looks very good. Nice job converting it!

7thgenCivic.Com,
The new fields are hardcoded because they must correspond with the specified fields in timeslips.php. However, I set the ID numbers for the new fields very high (@ 50+) so this shouldn't be a problem for anyone. And even if they already had that many custom fields (highly doubtful) it would simply give an error saying that those fields already exist.

Anyway, thanks everyone for the compliments.. Nice to see some of you found it useful.

Dewayne

EvilLS1

10-24-2003, 11:13 PM

Portal add-on: Top Five 1/4 mile ETs

Attached is instructions and a screenshot for the top five 1/4 mile ETs add on for your front page portal.

If you want to show or sort by other fields just change the userfield IDs accordingly.

glo

10-25-2003, 12:57 AM

Hey EvilLS1, good work!

"Clicks Install"

Do you know how i can add an extra field for a drop down menu for "Vehicle Make"

EvilLS1

10-25-2003, 01:29 AM

Thanks glo.

Yes its easy to add an extra field for a drop down menu. I have one myself.

If you haven't already done so, install this hack (https://vborg.vbsupport.ru/showthread.php?t=21833) (adds ability to make drop down menus in custom profile fields). Look in the last couple of pages of that thread to find updated instructions for later versions of vbulletin.

Anyway, once you've added that hack, go into your admin panel and add the new profile field w/ drop down menu.

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

Then open timeslips.php and find:

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

Below it add:

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

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

Still in timeslips.php find:

$ride= $userinfo[field50];

Below it add:

$make= $userinfo[fieldXX];

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

Now in your "timeslips" template find:

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

Below it add:

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

Find:

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

Replace it with:

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

Find:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>Username</b></smallfont></td>

Below it add:

<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>Vehicle Make</b></smallfont></td>

Find:

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

Replace it with:

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

In your "timeslipsbit" template find:

<td bgcolor="{secondaltcolor}"><normalfont><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$userinfo[userid]">$username</a></normalfont></td>

Below it add:

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

That will add the extra vehicle make info to the timeslips page and allow you to sort by it (alphabetically). You can experiment with the code a little and make it sort differently or whatever you want.

Dewayne

corsacrazy

10-25-2003, 03:29 PM

im good at ideas and you are a great hacker, thank you my friend :)

EvilLS1

10-25-2003, 04:26 PM

Thanks corsa. That was a nice idea. :)

BTW, I made a small addition to the hack. Now the timeslips page will put brackets around the catagory that is currently being sorted by.
Example (sorting by 1/4):
Username - Ride - RWHP - 60' - 1/8 mile ET - [1/4 Mile ET] - Slip

I updated the zip in the first post.. To upgrade just replace your timeslips template with the new one, then upload the new timeslips.php.

NickCat

10-25-2003, 05:02 PM

*clicks install*

Thanks EvilLS1... Great Hack.

I just installed it on my board this morning. I had to make a few small modifications though. I changed RWHP to WHP (Subaru website... AWD cars) and I already had car info in the user profiles to I pulled that info instead or the new 'Ride' field.

Teriffic hack though, I hope my members like using it.

The only request I might make would be if it were possible to allow the timeslips to be uploaded like an attachment. Since you know users tend to change image hosts all the time, and or delete stuff.

-Nick
http://www.nasioc.com/

MaxScript

10-25-2003, 05:09 PM

***vb3***? :)

EvilLS1

10-25-2003, 09:47 PM

MaxScript

10-25-2003, 09:48 PM

NickCat

10-25-2003, 11:04 PM

NickCat,
Thanks. :) And sorry about the RWHP thing.. I just copied the template from my own site (about 99% of my members have rwd cars).

Anyway, I will probably add the upload feature to v2.0. But for now, you could do what I do.. Next to the timeslip link field I posted a link to a thread in my drag racing forum that says "upload your images here". They can upload the images in that thread and then just put a link to the attachment in the field.

Thanks for the update. I added a few more tweaks of my own today. I used the custom dropdown to add a list of tracks and type of induction. My users were concerned about elevation effects on the 1/4 times in the registry so I figure as an alternative to trying to add elevation, temp, and humidity (which most users would leave blank anyway) I just added the track name field with a drop down of the most popular tracks.

And good idea on the image attachment thread.

I'll anxiously be awaiting the release of V2.0 with the built in attachment upload! ;)

-Nick
http://www.nasioc.com/

EvilLS1

10-26-2003, 06:58 PM

NOTE: This comes standard with version 1.3!

Add-on: Separate "Vehicle Profile" page for submitting Timeslip Data.

Description: This add-on will remove the timeslip fields from your edit profle & registration pages and put them in thier own separate catagory called "Vehicle Profile".

This should help cut down the number of users who submit false data when registering or editing their profile since the vehicle info is edited on a completely separate page.

Instructions and screenshot attached:

EvilLS1

10-26-2003, 07:00 PM

Thanks for the update. I added a few more tweaks of my own today. I used the custom dropdown to add a list of tracks and type of induction. My users were concerned about elevation effects on the 1/4 times in the registry so I figure as an alternative to trying to add elevation, temp, and humidity (which most users would leave blank anyway) I just added the track name field with a drop down of the most popular tracks.

And good idea on the image attachment thread.

I'll anxiously be awaiting the release of V2.0 with the built in attachment upload! ;)

-Nick
http://www.nasioc.com/

Looks nice Nick. I like the new track name field. :)

corsacrazy

10-26-2003, 07:07 PM

hehe i made ur addon a while ago for myself but you version is alot neater :P

evil please can you read https://vborg.vbsupport.ru/showthread.php?t=58203 ? thanks

Drowned

10-27-2003, 12:30 AM

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

Best hack EVER!!!!!!!!! :surprised: Are you planning on working a version for vb3? Please say yes! :nervous: hehehehe...

EvilLS1

10-27-2003, 07:11 PM

corsacrazy,
I would take a look at what Zed has offered if I were you.. His hacks are usually great and it can probably be altered to do exactly what you want. Something like that would require some time to make and right now my own "to do" list is pretty long.

Drowned,
Thanks. :) I don't plan on upgrading my own forum to VB3 but I do have it running on my PC. So I'll probably port over this hack and a couple of others whenever it goes final. That is if they release it before my membership expires. :rolleyes:

SVTOA

10-29-2003, 12:27 AM

Yea, it figures... I have been asking about this for a LONG time, nobody would help me. So I did my own version. Yours is obviously much better. I just kinda hacked up memberlist.php and added Chen's custom profile search hack. You can see it here:
http://www.mustangcentral.net/mcforums/fullqtrmilelist.php

Great job, awesome hack...

EvilLS1

10-29-2003, 01:00 AM

oly51

10-29-2003, 01:02 AM

Great hack, EvilLS1. Very clean!!

I'm trying to tweak it to be a VIN and car info registry so we can end up with a page that will list by VIN when in the production cycle certain changes were introduced.

How can it be set up so a member can have multiple cars listed?

Also, could I create a user called say, 'Unknown' and enter data that I have gathered from 150 or so cars?

SVTOA

10-29-2003, 01:13 AM

SVTOA,
Thanks. :) I think your version looks great too.

I had been wanting this hack for a while also but was just too lazy to make it. Previously we just had a thread in our drag racing forum where members posted their best ETs and were ranked on a list (manually).. But our ET thread got deleted a couple of weeks ago so I decided to go ahead and make the timeslips script rather than start a new one.

The "static" 1/4 mile list is a staple all over the place. Some person has to be put in charge of it and then the members have to wait/rely on that person to post updates. That is what prompted me to do mine. It just kinda sucks because as I said, I had asked all around if anyone had a script like this and got a pretty lukewarm response to my inquiries.
I got the idea that I could probably make something out of the member list, but you have no idea how long I played with this thing to get it work like it does now. Chen was kind enough to point me to the "search custom profile fields" hack, and that was key in getting what I visualized in my minds eye to appear onscreen.

I just happened to pop in here and your subject caught my eye. I am sure there are plenty of people who will want that feature and make use of your hard work. Props are in order sir, nice going...!

EvilLS1

10-29-2003, 01:26 AM

oly51,
Adding new fields to sort by is easy. Just add the new field in your admin control panel as usual, then make a note of the field ID#..

Then add a new section of code below where it says "// Do sorting methods" in timeslips.php something like this:

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

Just replace the fieldXX with the correct IDs for the new VIN field you added.

Then add the new URL to the drop down menu for sorting:
$bburl/timeslips.php?action=vin

If you wanted to show the VIN # on the page you would just add this below to the "// Set up vars" section of code:

$vin= $userinfo[fieldXX];

Replace the XX with the ID for your field, then add $vin to your timeslipsbit template and it'll show up..

It works the same way for adding more fields for multiple cars.

I'm not sure what you mean about adding the "unknown" user and all that info. But hopefully this helps with the other stuff. Good luck with customizing it.

oly51

10-29-2003, 02:05 AM

Thanks for the quick reply and the code and sorting help.

As for the multiple cars...
Some of my members have 3 or more cars they would enter the info on. (I have 6) Plus I have VIN and other info from 150 or so cars that I have gathered over the years whose owners are not members. Could these be entered on the "Vehicle Profile" page?

ImportPassion

10-29-2003, 02:40 PM

Add-on: Separate "Vehicle Profile" page for submitting Timeslip Data.

Description: This add-on will remove the timeslip fields from your edit profle & registration pages and put them in thier own separate catagory called "Vehicle Profile".

This should help cut down the number of users who submit false data when registering or editing their profile since the vehicle info is edited on a completely separate page.

What's up with this code?
$profilefields=$DB_site->query("SELECT profilefieldid,required,title,size,maxlength
FROM profilefield
WHERE editable = 1
AND profilefieldid IN (5,6,11,12,13,14,15,18,19)");

Are the profile id's wrong?

EvilLS1

10-29-2003, 03:03 PM

oly51,
Yes you can add any new fields to the Vehicle Profile page.. Just add the new field IDs into the queries where it says "AND profilefieldid IN (50,51,52,53,54,55,56,57)" and they will show up on the new vehicle profile page. You'll need to add the new field ID in 5 places (in the hack instructions for the addon).

As for the info on the other 150 cars that don't belong to registered users, I'm not sure how you could include those.

7thgenCivic.Com,
Sorry about that.. Those profile fields are from my own board and I forgot to change them in the hack instructions. Just replace that section of code with this:

$profilefields=$DB_site->query("SELECT profilefieldid,required,title,size,maxlength
FROM profilefield
WHERE editable = 1
AND profilefieldid IN (50,51,52,53,54,55,56,57)");

I updated the instructions for the vehicle profile addon.. Thanks for pointing it out.

ImportPassion

10-29-2003, 04:01 PM

hmm....I am not getting the actual form fields output with your new addition. It shows the field names, but not the form fields.

brendonm

10-29-2003, 08:58 PM

Nice, I have got the phpBB version working on two boards out there already. I have just installed this one on my Nissan Skyline related website which uses vBulletin. The install was very very simple, I will probably tweak it up later but for now is pretty standard.
Thanks EvilLS1 -*clicks install*

ImportPassion

10-29-2003, 10:50 PM

when I made the separate page for the timeslips, i made HP required field, but when ppl tried to join, they got an error saying HP was a required field and there was no HP field being presented, which is what I want, but it should be coming up as not entered.

EvilLS1

10-29-2003, 11:40 PM

7thgenCivic.Com,
I appologise. It looks like I posted the wrong contents for the "timeslips_customfields" template. I also left out a step and forgot to put a "); at the end of one of the queries. I was very tired when I wrote the instructions for the addon.. Thats my excuse. :p

Anyway, I updated the instructions once again for the vehicle profile page addon, and this time its right.

But to save you from having to look through the whole thing to find what I changed, I'll post it here:

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

<tr>
<td bgcolor="$bgcolor"><normalfont><b>$profilefield[title]:</b></normalfont><br>
<smallfont>$profilefield[description]</smallfont></td>
<td bgcolor="$bgcolor"><normalfont><input type="text" class="bginput" name="$profilefieldname" value="$bbuserinfo[$profilefieldname]" size="$profilefield[size]" maxlength="$profilefield[maxlength]"></normalfont></td>
</tr>

In your usercpnav template find:

<td bgcolor="$cpnav[2]"><smallfont><b><a href="member.php?s=$session[sessionhash]&action=editprofile">Edit Profile</a></b></smallfont></td>

Below it add:

<td bgcolor="$cpnav[2]"><smallfont><b><a href="member.php?s=$session[sessionhash]&action=edittimeslip">Edit Vehicle Profile</a></b></smallfont></td>

This will fix the problem you're having with the required HP field:

In register.php find:

$profilefields=$DB_site->query("SELECT maxlength,profilefieldid,required,title
FROM profilefield
WHERE editable = 1
ORDER BY displayorder");

Replace it with:

$profilefields=$DB_site->query("SELECT maxlength,profilefieldid,required,title
FROM profilefield
WHERE editable = 1
AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)
ORDER BY displayorder");

That should do it.

@ brendonm.. Thanks. :)

brendonm

10-29-2003, 11:58 PM

Hiya,
I like SVTOA's approach - nice work dude :) In particular I like the sorting into time brackts.

Using the timeslip mod, how hard would it be to structure a search function to present only vehicles within a given bracket? e.g. 8sec, 9sec, 10sec and then include these searches into the sort box? (actually I think the search box inclusion may have been discussed, but not the time brackets).

If I take a look at the existing if/else statement, I can see a condition statement thing. Is this where I'd put in some sort of less than/greater than condition?

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

This would actually be a very nice enhancement for this mod in the instance that I am using it for aswell as might be a nice addition for others too. Even if someone can help me with the syntax for the first one I can write the rest (I don't expect everything to be done for me, I just don't know where to start with developing such a query). I am only interested in sorting by time bracket for 1/4 mile, not for 60 foot and 1/8 mile aswell. Any help or guidance in this matter would be much appreciated - if I manage to make anything useful I'll be sure to post it up here.

regards

BrendonM

EvilLS1

10-30-2003, 12:23 AM

BrendonM,
Yes, you have the right idea.

You would just add some variables above "// Do sorting methods" something like this:

$a=11;
$b=10;
$number=0;
// Do sorting methods

And then add a new action with the $conditions like this:

} else if ($action=="TenSecCars") {
$cond.=" WHERE userfield.field55<'".intval($a)."' AND userfield.field55>='".intval($b)."'";
$condition.=" AND userfield.field55<'".intval($a)."' AND userfield.field55>='".intval($b)."'";
$orderby="userfield.field55";
$direction=ASC;

You get the idea. Good luck with it.

EvilLS1

10-30-2003, 01:25 AM

BrendonM,
I'm adding this feature for you. Give me a few more minutes and I'll have it done.

brendonm

10-30-2003, 01:29 AM

Hiya,

that is perfect, works very well thank you. I was'nt sure how to approach that syntactically now I can code as many brackets as I like. I have just asked my community for the brackets they want to sort by and will code them up tommorrow. If anyone wants the code let me know, although it is pretty easy.... ...now :)

EvilLS1

10-30-2003, 01:58 AM

I also added this to the Timeslip Database hack. Check the demo (my site) to see it. Thanks to brendonm and SVTOA for the idea. :)

alkatraz

10-30-2003, 06:06 AM

awesome hack!!!! thank you so much, my members will love this

Keep the Automotive stuff coming =) pretty please

brendonm

10-30-2003, 07:49 AM

EvilLS1 = the man!
gee that was quick, and it works so well! Thank you on behalf of my user community :)

TheComputerGuy

10-30-2003, 02:55 PM

I am thinking of modifiying this for my gun site. So people can post their Shots and a pic of the target! I like this alot. Installed!

SVTBlackLight01

10-30-2003, 03:01 PM

[QUOTE=SVTOA]I just kinda hacked up memberlist.php and added Chen's custom profile search hack. You can see it here:
http://www.mustangcentral.net/mcforums/fullqtrmilelist.php
QUOTE]

Still, not a bad job on yours. :)

EvilLS1

10-31-2003, 01:22 AM

Thanks guys.

TheComputerGuy,
Sounds cool. What kind of gun site?

<--- gun nut! :D
http://modernmusclecars.net/guns/myguns.html

SVTOA

10-31-2003, 01:41 AM

Hey thanks you guys! This is a great place to share and exchange ideas, and I'm glad that for once I am able to contribute versus always coming here looking for stuff to use! In hindsight, it was a good thing in a way that nobody offered up any ideas when I first wanted my own 1/4 mile list, because it actually forced me to learn more about scripting and I ended up with what I wanted.

I am not nearly as experienced or organized as EvilLS1, I kind of made mine on "the fly" and have been able to duplicate it for three other sites, but as of now there is no installer of any kind. I still think his whole hack is better in that it can be setup easily. It would take a lot of tedious work to get what I have incorporated into your site.

As long as you guys are open to ideas... On one site, we took those "ET Clubs" and made them hyperlinks for the main page: http://www.mach-1.org
You may notice also, that I set the ET field as the one that is sorted from quickest to slowest, both on the master list as well as the individual ET clubs, and this is what the members seem to like most. Also, on the "ADVANCED SEARCH" page- you can search by power adder or mod, or et bracket. You could do a search for members who run 12.xx and have nitrous, or you could search for 11.xx with a blower, etc etc...

EvilLS1

10-31-2003, 03:46 PM

Hack updated 10-31-03 (new feature): -Added a new action that will show the average ET, trap speed, and horsepower for your site.
Go to the demo page (http://modernmusclecars.net/forums/timeslips.php) and select "Site Averages (http://modernmusclecars.net/forums/timeslips.php?s=&action=averages)" from the drop down menu to see what I mean.

To upgrade, just replace your timeslips.php file, timeslips template, and timeslipsbit template with the new ones.

EvilLS1

10-31-2003, 04:04 PM

I am not nearly as experienced or organized as EvilLS1, I kind of made mine on "the fly" and have been able to duplicate it for three other sites, but as of now there is no installer of any kind. I still think his whole hack is better in that it can be setup easily. It would take a lot of tedious work to get what I have incorporated into your site.

I think you did a great job. Yours is much better than my first attempt at making a timeslip database (the phpBB version was my first one). Heck, I'm no php guru either. I just get ideas and tinker with the code sometimes. I still have a lot to learn.

Dewayne

alkatraz

10-31-2003, 10:12 PM

*Front page portal add-on: Top Five 1/4 mile ETs

^ wow this is awesome! Thank you!!

ImportPassion

10-31-2003, 10:14 PM

in the separate page for to edit timeslip data instructions, there is an error

###### Replace with:
$profilefields=$DB_site->query("SELECT profilefieldid,required,title,size,maxlength
FROM profilefield
WHERE editable = 1
AND profilefieldid NOT IN (50,51,52,53,54,55,56,57");

should be

###### Replace with:
$profilefields=$DB_site->query("SELECT profilefieldid,required,title,size,maxlength
FROM profilefield
WHERE editable = 1
AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)");

also, in this section

$templatesused = 'redirect_updatethanks,error_fieldmissing,error_em ailmismatch,error_emailtaken,error_fieldmissing,er ror_requiredfieldmissing,error_birthdayfield';

I don't think half these templates are actually used?

Still installing all the updates and fixes. Let you know the outcome soon.

One thing I will be adding for admins and possibly mods is a delete button to delete fake crap. It's already starting. :disappointed:

EvilLS1

10-31-2003, 10:47 PM

7thgenCivic.Com,
Nice catch on the missing ). The profile fieldID #s on my own site are different than the ones posted in the hack instructions here. So I must have accidentally deleted it when I changed the IDs for the hack.

As for the templates used in the "updatetimeslip" action, those are just left overs from where I copied that bit of code from the original "updateprofile" action. I forgot to remove them, but it wouldn't hurt anything to leave them there. I just updated the instructions and removed them so not to cause any confusion though. Also added the missing ) to the query. Thanks again for pointing it out.

One thing I will be adding for admins and possibly mods is a delete button to delete fake crap. It's already starting.

That sounds like a good idea.

I was thinking about making it possible to ban users from the "edit vehicle profile" page. This should help root out the users who insist on entering false data just to be funny.
If you want, I'll post the instructions for that addon here whenever I get around to making it.

drumsy

11-01-2003, 03:09 AM

What's up with my font and table color???

www.honda-acura.net/forums/timeslips.php

drumsy

11-01-2003, 03:59 AM

Fixed, had to modify templates.

drumsy

11-01-2003, 04:10 AM

Add-on: Separate "Vehicle Profile" page for submitting Timeslip Data.

Description: This add-on will remove the timeslip fields from your edit profle & registration pages and put them in thier own separate catagory called "Vehicle Profile".

This should help cut down the number of users who submit false data when registering or editing their profile since the vehicle info is edited on a completely separate page.

Instructions and screenshot attached:

Do you have instructions on how to do this for a 2.3.2 version? The lines are not matching up on my register.php page and I'm not comfortable trying to manually do it.

EvilLS1

11-01-2003, 05:32 PM

drumsy,
Not sure why you had to edit the font and table color. Unless the replacements are different in 2.3.2, the hack should use the same font & table colors as the rest of your board.

I looked at a copy of register.php from 2.3.2, and the code is the same.. 2.3.2 just has some line breaks in different places.

In register.php Find:

$profilefields = $DB_site->query("
SELECT * FROM profilefield
WHERE editable = 1 ORDER BY displayorder
");

Replace with:

$profilefields=$DB_site->query("SELECT *
FROM profilefield
WHERE editable = 1
AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)
ORDER BY displayorder");

Find:

$profilefields=$DB_site->query("SELECT maxlength,profilefieldid,required,title
FROM profilefield
WHERE editable = 1
ORDER BY displayorder");

Replace with:

$profilefields=$DB_site->query("SELECT maxlength,profilefieldid,required,title
FROM profilefield
WHERE editable = 1
AND profilefieldid NOT IN (50,51,52,53,54,55,56,57)
ORDER BY displayorder");

Then follow the rest of the hack instructions for editing member.php.

SIINSI

11-01-2003, 05:36 PM

Awesome hack, thanks alot for this... Installed on http://www.jdmuniverse.com

Thanks again

EvilLS1

11-01-2003, 05:45 PM

Thanks SIINSI. Glad you like it.

drumsy

11-01-2003, 06:48 PM

Gracias senor for the code! :thumbup:

EvilLS1

11-02-2003, 02:40 AM

NOTE: This comes standard with version 1.3!

Add-on: Ban users from editing their Vehicle Profile (Timeslip Info)

Description: This add-on will allow you to 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.

I suggest putting a warning at the top of your Edit Vehicle Profile page that says something like "Vehicle Profile privileges will be taken away from users who enter false data". Then if they do it anyway, just click on the user's profile, then click "user options" and set "Can edit vehicle profile" to no. The user will still be able to edit his regular profile, but not his vehicle provile.

To use this add-on you must already have the Vehicle Profile add-on (https://vborg.vbsupport.ru/showpost.php?p=443280&postcount=40) installed.

Instructions attached:

PranK

11-03-2003, 07:21 AM

oh hell yes!

*clicks install*

rishel

11-04-2003, 09:25 PM

This looks interesting also: http://www.horsepowered.com/members/

Also looks like a lot of SVTOA's concepts are in this script posted here on VB.org

alkatraz

11-06-2003, 02:59 AM

This hack just keeps getting better and better!!

(It's starting to become a pain to update every few days) :)

This looks interesting also: http://www.horsepowered.com/members/

Also looks like a lot of SVTOA's concepts are in this script posted here on VB.org

wow, I *heart* that script!! =)

If anyone knows where to find this, (especialy if its vb integrated) please let me know!!!!!!!!

0ptima

11-09-2003, 02:59 AM

This is an amazing script! Im going to install it, as soon as I makes some modifications as I already have 'ride' field.

Are you going to make a VB3 version of it?

EvilLS1

11-09-2003, 04:10 PM

Thanks. If they release VB3 before my membership expires I'll probably port this over.

0ptima

11-10-2003, 08:28 PM

Thanks for the quick reply and the code and sorting help.

As for the multiple cars...
Some of my members have 3 or more cars they would enter the info on. (I have 6)

Im in a similar situation as well. Many years agao, I created a vehicle registry page and photo gallery in php, which members cannot update. What I want to do is create a vehicle registry that is integrated into vbulletin that can accept unlimited cars per member and several pictures per entry. I would try to make it generic enough so it can be used by many people. Im going to try to start during the holidays and it will be for VB3.

EvilLS1

11-11-2003, 12:34 AM

Updated 11-10-03: -Added the vehicle profile addon to the hack instructions. Added the ability to ban users from editing their vehicle profile to the hack instructions.. Added a few new fields to the vehicle profile page (race weight, track, D/A, mods, tranny type, etc). Added a "details" column to the Timeslip Database page which lets you view all vehicle profile fields when the details link is clicked (see demo).

I'll post upgrade instructions when I get some free time. Or if you've already installed a previous version you can add the vehicle profile and ability to ban users from VP addons manually by using the instructions posted a few pages back.

rishel

11-11-2003, 12:55 AM

Evil, you going to keep ripping off other peoples concepts amd not even give them props?

rishel

11-11-2003, 01:00 AM

For those of you wanting to know where I believe most of the concepts are coming from go look at Mach-1.org ( hes to modest to say anything ) or look at HorsePowered.com's member pages.

Mach-1: http://www.mach-1.org/vbulletin/memberlisttest.php

HorsePowered: http://www.horsepowered.com/members/

EvilLS1

11-11-2003, 01:23 AM

Evil, you going to keep ripping off other peoples concepts amd not even give them props?

Um, excuse me, but FYI Timeslip Database scripts that have many of the same functions as mine (and the ones you listed) have been around for as long as I can remember.

A few examples for you:

phpBB timeslip database hack:
http://phpbbhacks.com/viewhack.php?id=546
This one was also made by ME a couple of years ago.

One of many sites using my old phpBB version:
http://www.fl-thirdgen.org/forum3/timeslips.php

A different one:
http://www.sportcompactracing.com/vbulletin/TIMESLIP.php

Here's one thats almost identical to the Mach1.org version:
http://www.tamparacing.com/forums/timeslip.php

Here's a version thats a separate script which works independantly from the forum software:
http://www.ls1tech.com/quarter/LS1tech_list.php

Yet another one:
http://www.ls1.com/qtrmile1.htm

As for the sorting by ET brackets (11 sec cars, 10 sec cars, etc).. No offense intended to SVTOA, but this concept was also thought of a long time ago.
Here's just one of many sites who already use it:
http://www.corral.net/timeslips/timeslips.html

BrendonM requested it and I added it.

As you can see, all of the "concepts" mentioned in this thread have already been done numerous times by others. I'm not the first person to come up with this idea, I simply made a version of it that works with vBulletin. Any "addons" which I've added to the vB Timeslip script were requested in this thread and coded by ME.

So in short, you should get your facts straight before making lame accusations.

alkatraz

11-11-2003, 01:49 AM

Evil: I *really* want to add these new updates to my script, but I'm afraid of messing things up as the script has changed significantly since I first installed it..

Any suggestions??? Do you still have archived versions of the earlier released hack that I can use to compare with the new one?

Evil, you going to keep ripping off other peoples concepts amd not even give them props?

While I agree that ripping ideas without credit is a big no-no, from the sounds of it Evil is just using other peoples ideas as inspiration for his own work. It's not like he's taking someone elses code and re-labeling it.

EvilLS1

11-11-2003, 02:08 AM

alkatraz,
Which upgrades are you wanting? I have a copy of version 1.2 which includes the ET brackets sorting methods. The vehicle profile and ban user from VP addons are also posted a few pages back.

I will make an upgrade script for 1.3 in the next few days (when I get time) but if you really want to upgrade now you would have to completely uninstall the hack, then re-install it.

I'll attach v1.2 incase you want it. Just replace your timeslips.php file with the new one and replace your templates with the new ones.

While I agree that ripping ideas without credit is a big no-no, from the sounds of it Evil is just using other peoples ideas as inspiration for his own work. It's not like he's taking someone elses code and re-labeling it.

Exactly. This script was coded by me alone. As for the ideas for new features, like I said, they've already been done by many others in the past (in non-vB scripts). None of them are new concepts. Its kinda like forum software.. There's several different (yet original) scripts availible that include many of the same features. Its not a rip-off as long as the code is original. Honestly, If I knew who made the first timeslip script I'd be more than happy to give him credit for the idea. But there's so many different versions availible which have been around for years, so I have no idea who made the first one. Hell, this isn't even the first one that I've made.

Anyway, older version attached:

rishel

11-11-2003, 02:16 AM

No actually you should give props to the people that your currently copying, which you know you are.

With 431 post you have, you should know by know that on VB.org we give credit where its do.

Those new mods you just started adding with equipment based ideas, strange, 3 days after you inspected someone elses site I imagine?

Odd, very odd...

And as for lame, dont get me started. Play by the rules on this site EvilLS1, and dont play it off as unrealized potential.

You can say whatever you want, I just think you should give props to those sites, that I know your currently building after.

I mean, some of us are dumb, but not that dumb.

Those links you posted are great, truly I am sure they are.

But suddenly your adding equipments mods and other things just like, hmmm... HorsePowered.com

My beef with what your doing is this. Your script stayed on a set path of featuresets until just a few days ago, after all this time, until a link was posted to another script, and then suddenly wella, here come the matching featuresets.

Call it what you want guy, but it sure looks odd.

And before anyone jumps in and screams about ranting and raving, remember, we do give props on this site to others for their intellectual concepts etc.

EvilLS1 I am truly interested in seeing where you are taking this script, and am very much awaiting to see your original concepts you will be adding.

Don't disappoint us.

EvilLS1

11-11-2003, 02:43 AM

rishel,
Did you even take a look at the links I posted? ALL of the ideas used on the site you mentioned have been done before on OTHER sites that I've been visiting for YEARS.

But suddenly your adding equipments mods and other things just like, hmmm... HorsePowered.com

..and just like, hmmm... LS1Tech.com, LS1.com, and a sh*tload of others. Its been done a million times! Get over it!

If you are referring to the new fields which I added in 1.3 (race weight, track, D/A, mods, tranny type, etc), those are common things that nearly ALL drag racers want to know about when discussing 1/4 mile times. Again, take a look at LS1Tech.com or LS1.com and you'll see the same thing there. Now I've been visiting those sites way before I even became a member of vb.org, so how can you possibly think that I got the idea from the sites you mentioned? There are MANY sites who incude those fields in their timeslip details.

FYI I had plans to release many updates when I posted the first version here. I just wanted to make the base (bare bones) version availible first to see what others thought of it. Incase you haven't noticed, I've been releasing updates every few days since I posted this hack. None of these 'concepts' are new to me. They have been around as long as the first Timeslip script itself. I'm sorry but you are WRONG about this whole thing.

Like I said in my post above: If I knew who made the first timeslip script I'd be more than happy to give him credit for the ideas. But there's so many different versions availible which have been around for years, so I have no idea who made the first one.

With 431 post you have, you should know by know that on VB.org we give credit where its do.

Well with all 34 posts that you have, you should know to stay out of things which you obviously know nothing about.

My beef with what your doing is this. Your script stayed on a set path of featuresets until just a few days ago, after all this time, until a link was posted to another script, and then suddenly wella, here come the matching featuresets.

You honestly have no clue, do you? VISIT THE LINKS I POSTED! These ideas have been in use for YEARS on many other sites that I visit. I've seen them all before!

And before anyone jumps in and screams about ranting and raving, remember, we do give props on this site to others for their intellectual concepts etc.

Using your logic, I guess all of those people should also give ME credit for making the first forum integrated Timeslip Database more than 2 years ago (phpBB)? Since I had the idea first right? Nope. Thats lame. Unless they're using my code they do not owe me any credits.

BTW, I noticed that your site ( http://www.integritymessenger.com/ ) doesn't give any credit to AIM, Yahoo, ICQ, or any of the other original instant messengers.. Aren't you being slightly hypocritical here? After all, the instant messenger was NOT your idea, and yours does seem to have ALOT of the features from the other messengers!

See how stupid that sounds?

EvilLS1 I am truly interested in seeing where you taking this script, and am very much awaiting to see your original concepts you will be adding.

Its people like you who make me not even want to waste my time writing instructions to share my hacks. Infact, I think I'm done with this one. :angry:

alkatraz

11-11-2003, 05:37 AM

Infact, I think I'm done with this one.

please noooo!!! =) don't let politics stop you.

if this is against the rules rishel then report it to a moderator and they can decide. personaly I see nothing wrong with it. I've been to thousands of automotive sites and these types of features are seen everywhere. however this is the first time i've seen something like it for vbb so i'm happy to see someone has been kind enough to share their work. he runs an automotive site and probably just made it cuz he couldn't find anything like it out there. I *wish* I had the programming knowledge to put something like this together myself.

thank you again EvilLS1

rishel

11-11-2003, 12:35 PM

Infact, I think I'm done with this one. :angry:

Good riddens. Nows the part where you want people to beg you to keep making it, and then try to get them upset with me.

And as far as my 34 posts, I know more about whats in the automotive industry than you think, and I know a fork-er when I see one.

I give credit where credit is due.

And if you pull the date of creation line on me again, I will embarrass you and show you a time slip concept from a board that FAR supercedes your 2 year claim.

EvilLS1

11-11-2003, 01:30 PM

Good riddens. Nows the part where you want people to beg you to keep making it, and then try to get them upset with me.

No, nows the part where you ruin a perfectly good thread/hack with your ignorance.

And as far as my 34 posts, I know more about whats in the automotive industry than you think,

You may know something about the automotive industry, however that has absolutely nothing to do with this discussion. What you DON'T know anything about is timeslip database scripts and drag racing in general.

I give credit where credit is due.

Really? Then where is credit given on your site for ideas borrowed from the original instant messenger? Thats what I thought.

You're asking me to give credit to someone who did not influence my hack and did not come up with those concepts in the first place. How stupid is that!? But if it makes you feel better, then fine.. Special thanks to whoever it was that came up with the first timeslip script. And thanks to all those dozens of sites that (just like me) have re-invented and improved upon the concepts used within the first one.

And if you pull the date of creation line on me again, I will embarrass you and show you a time slip concept from a board that FAR supercedes your 2 year claim.

Show me. The only one who should be "embarrassed" here is you. Idiot.

rishel

11-11-2003, 05:28 PM

He thinks I am with the instant messenger site?

LOL, ummm, ok. Sounds good!

EvilLS1

11-11-2003, 06:00 PM

He thinks I am with the instant messenger site?

LOL, ummm, ok. Sounds good!

Well gee, I wonder what gave me that idea.. Could it possibly be the fact that you have it listed as your occupation and homepage in your pofile? (duh!)

BTW, I just took a look at the horsepower.com site (for the first time). Its not even a Timeslip Database script. It more of a mini-homepage for car enthusiasts. Completely different than what I released here. If you can't see that, then you're blind.

Even with all of the proof that I've shown you about your so called "concepts" not being original, I'm sure you'll never admit you were wrong. Crow doesn't taste so good eh?

Logician

11-11-2003, 06:26 PM

With 431 post you have, you should know by know that on VB.org we give credit where its do.
I've got this thread reported by a vb.org member and I want to understand what the problem is. If conflict is not yet solved, I appreciate if someone can take sometime and recap what's going on as I am not familiar with the automative scripts. :)

In the meantime, here are some points depending on what I understood until now: (and plz forgive if I understood wrongly)

1- If someone "converts" a code of another to release here, he should get permission of the author. Eg. if you want to include phpmyadmin into vbulletin to release here(what a job that would be lol), you have to get phpmyadmin's author's permission.

2- If you code your own script that does something another program is doing, and you coded it from the ground, you don't have to get anybody's permission to do that. Eg. if you code a vb hack from the ground that does what phpmyadmin is exactly doing, you don't need a permission, because you coded it from the ground. If it were otherwise, vbulletin itself would never be coded since there were other bb scripts around that use the same "concept". ;)

3- Exception of Rule 2: If you recode a "small" vb hack to release here, we want it relased in the original hack thread as recodings of small hacks are usually no different than the original hack due to the volume of the code.

Hope these general principals shed a light to the problem you are discussing.

And a kind request for rishel:
If you believe this hack is breaking any vb.org rule, please report it to moderation team, instead of flaming the thread so that we can moderate accordingly. Because if it is not breaking any rules, then your comments might be discouraging hack author unnecessarily and cluttering the thread with wrong assumptions and we wouldn't want that. :) On the other hand, if it is breaking a rule, our moderation will solve the problems so there won't be any ground for such comments in the thread. Thank you for understanding..

EvilLS1

11-11-2003, 07:08 PM

Logician ,
Thank you for re-enforcing my point.

rishel, READ!

2- If you code your own script that does something another program is doing, and you coded it from the ground, you don't have to get anybody's permission to do that. Eg. if you code a vb hack from the ground that does what phpmyadmin is exactly doing, you don't need a permission, because you coded it from the ground. If it were otherwise, vbulletin itself would never be coded since there were other bb scripts around that use the same "concept".

FYI (logician), this was all coded from the ground by me. There are no other released timeslip scripts for vbulletin. Only mine. If you read back through this thread you'll notice nothing but positive replies (other than rishel's) from other users as this is all original and nothing like it has ever been released here.

Here's a quick rundown on the situation:

rishel claims that I have "ripped" the concepts (ideas) which are being used on a site that he/she visits.

To prove otherwise, I posted several different Timeslip Database scripts from other websites (including a script that I wrote about 2 years ago) which use the same concepts as the one she mentioned and have been around for years.

rishel doesn't seem to understand that all timeslip database scripts share many of the same features. Just like forum software.

Honestly, until today I had not even looked at the horsepower.com site which rishel claims that I "ripped". But after looking at it, its completely different than my own.

You can take a look at this post and you'll see for yourself that there are many different timeslip scripts which share the same or similar features:
https://vborg.vbsupport.ru/showpost.php?p=446160&postcount=90

So in short, rishel is very confused and is making false accusations.

EvilLS1

11-11-2003, 08:39 PM

And if your "intelligent" self would go look at the script again on HP, then you would see it has those same things on the opening members page, so open your eyes genius.

You're still missing the point, sweet cheeks. Even if that site had some of the same features, it doesn't matter because 1) I did not copy anything from that site. 2) they are not the first or the last website to use those concepts for a script such as this one. and 3) This was coded by me from start to finish, so the fact that other sites have similar features is irrelevant.

Get the last word in, let everyone see this MASSIVE rebuttle your going to make. Make sure it sounds intelligent, witty, and do everything you can to discredit me.

I have no need to discredit you. You never had any credit to begin with. Your accusations are false and way off base. You're obviously not mature enough to admit you were wrong and move on. Instead you just keep slinging insults like a 5 year old. By doing this you discredited yourself.

You can do it, because no matter what you say, I am through with this thread.

Good. Now could a moderator please remove this garbage from my thread? Thanks.

Logician

11-11-2003, 09:06 PM

Good. Now could a moderator please remove this garbage from my thread?
@EvilS1: done.

@rishel: Given the situation and hack's complying by vb.org rules, your flame is unjust and unnecessary. Message removed. Please help us grow this community by encouraging hack authors to share their work. They are here with uncommercial purposes, sharing their work, offering free help thus offending them in their hack threads is not helping anything. Especially when there is no ground to flame their hack which seems to be complying by vb.org rules.

If we restricted release of hacks here just because their concept is similiar to a different project, we would have no hacks. 99.9% of the hacks here is for sure similiar to an other project in the internet regarding its concept. I'm sure even your own site (whatever it is) is not unique in its subject and I'm sure internet's having a site about "X" did not stop you openning your own site about same subject, did it? Coding business is no different..

EvilLS1

11-11-2003, 09:26 PM

Thank you Logician.

EvilLS1

11-12-2003, 09:28 PM

Attached are instructions on how to upgrade all previous versions to v1.3.

drumsy

11-12-2003, 10:06 PM

Attached are instructions on how to upgrade all previous versions to v1.3.

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: INSERT INTO profilefield (profilefieldid,title,description,required,hidden, maxlength,size,displayorder,editable) VALUES (50,'Ride','What do you drive?',0,0,'20','20','50', '1')
mysql error: Duplicate entry '50' for key 1

mysql error number: 1062

Date: Wednesday 12th of November 2003 07:10:55 PM
Script: http://www.honda-acura.net/forums/forums/admin/TDinstaller.php?action=insert
Referer: http://www.honda-acura.net/forums/admin/TDupgrade.php

EvilLS1

11-12-2003, 10:37 PM

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: INSERT INTO profilefield (profilefieldid,title,description,required,hidden, maxlength,size,displayorder,editable) VALUES (50,'Ride','What do you drive?',0,0,'20','20','50', '1')
mysql error: Duplicate entry '50' for key 1

mysql error number: 1062

Date: Wednesday 12th of November 2003 07:10:55 PM
Script: http://www.honda-acura.net/forums/forums/admin/TDinstaller.php?action=insert
Referer: http://www.honda-acura.net/forums/admin/TDupgrade.php

Oops. Forgot to change the file name in the url for the insert action. Its fixed now. Redownload the upgrade script and run it again. BTW, if you've added any new custom profile fields with IDs from 58-63 you'll have to remove them or change the IDs first.

sunrunner_pei

11-14-2003, 06:23 PM

I just finished installing this hack. Thanks so much, EvilLS1, it works perfectly!!!

*clicks install*

sunrunner_pei

11-14-2003, 06:49 PM

Hmmm, I just had an idea...

Is there any way to get 1/4 mile times in the PostBit? And only show up in the postbit if the user has the info listed in their profile?

corsacrazy

11-14-2003, 06:55 PM

(no space between $ and p)$ post[fieldXX]

sunrunner_pei

11-14-2003, 07:14 PM

(no space between $ and p)$ post[fieldXX]

Excellent! But how do I know what the field# is?

corsacrazy

11-14-2003, 07:25 PM

goto custom fileds in the admin cp... hover over the link to edit one of the fields and note the url of that link it will say the field number at the end its probally 51 or sumin hight like that ;)

sunrunner_pei

11-14-2003, 07:37 PM

OK, I got the fields... But one problem: If the user doesn't have any info entered, it displays 0.000@0.00 in thir postbit. Is there any way to stop this from happening?

BTW, on my forum it's field55 and field56. :)

corsacrazy

11-14-2003, 07:43 PM

theres isnt n e short way to stop this im afraid y dont u link thetimes in the postbit to the edit info page so wen a user sees they have no time it will inspire them to go and fill it in :~)

EvilLS1

11-14-2003, 09:06 PM

0ptima

11-15-2003, 08:27 PM

An awesome hack, I installed it on my forum. Thanks!

0ptima

11-15-2003, 08:31 PM

I created a 'timeslip' PSD and GIF file which you can use on your forum. The zip file contains the PSD, GIF, a screen shot and instructions on how to add the button to the header.

@EviilLS1: You can add the button to your next update of the hack.

EvilLS1

11-15-2003, 08:45 PM

Looks good Optima. Nice job.

I added a link to your post in the add-ons section.

sunrunner_pei

11-15-2003, 08:50 PM

EvilLS1, thank you so very much!!! That worked perfectly!

EvilLS1

11-16-2003, 04:48 PM

You're welcome sunrunner. :)

PranK

11-17-2003, 06:41 AM

Evil - you rock!

Thanks mate!

oly51

11-18-2003, 12:59 AM

EvilLS1, I am very impressed with the amount of support you have shown for this hack!
Great job, keep up the good work!

EvilLS1

11-18-2003, 12:08 PM

Thank you. :)

carlitosz

11-18-2003, 04:00 PM

EvilLS1,

Please check your mail.

Carlos.

EvilLS1

11-19-2003, 02:56 AM

carlitosz,
I replied to your email but it bounced back to me. Please check your PMs.

EvilLS1

11-26-2003, 12:09 AM

Here's a little add-on that some of you might want..

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

{edit} This is for v1.3 only.

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:

</head>

Above it add:

<script language="javascript">

</script>

Find:

<form action="member.php" method="post">

Replace it with:

<form action="member.php" name="vbform" method="post" onSubmit="return validate(this)">

Done.

Silverstangs

11-28-2003, 12:26 AM

I now have it installed on vb2.3.3 and it works great. I did make a dumb mental error, I added the templates to only one set. Just remember they all need the same templates.

I am going to modify the hack a little and add "Torque" for one of the fields.

--Scott
aka Silver

PranK

11-28-2003, 08:15 AM

I was using this on my old VB 233... i now use VB3 B7... what are the possibilities of me getting it to work on that?

Thanks in advance!

EvilLS1

11-28-2003, 07:25 PM

PranK,
The hack will have to be re-written for VB3 since the code is all new. I do plan to port this over for VB3 once the RC versions are released though.

PranK

11-28-2003, 10:53 PM

Ahh sweet - you rock!

Thanks mate!

Christian

bandit022

12-03-2003, 08:43 PM

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

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

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

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

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

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

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

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

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

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

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

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

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

thanks for your help,

-jeff

Josh Combs

12-03-2003, 09:21 PM

bandit022

12-03-2003, 10:29 PM

what version of vb are you running?

oh crap, forgot to mention that.

2.3.0 with a good list of hacks installed.

bandit022

12-03-2003, 11:54 PM

nevermind.. i fixed it

bandit022

12-07-2003, 01:57 AM

hey evil,

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

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

thanks,

-jeff

EvilLS1

12-07-2003, 08:18 PM

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

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

Then open timeslips.php and find:

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

Below it add:

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

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

Still in timeslips.php find:

$ride= $userinfo[field50];

Below it add:

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

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

Now in your "timeslips" template find:

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

Below it add:

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

Find:

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

Replace it with:

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

Find:

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

Below it add:

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

Find:

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

Replace it with:

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

In your "timeslipsbit" template find:

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

Below it add:

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

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

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

And replace them with thise:

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

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

In your modifytimeslip template find:

<script language="javascript">

</script>

Replace it with:

<script language="javascript">

</script>

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

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

Dewayne

bandit022

12-07-2003, 09:34 PM

holy crap! you're the man Dewayne!

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

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

thanks again,

-jeff

bandit022

12-08-2003, 01:37 PM

works like a charm. :D

thanks a million!

-jeff

PKRWUD

12-09-2003, 11:40 AM

Wow, a hack thread with unnecessary drama, too! ;)

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

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

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

http://www.ricehatersclub.com/vbulletin/member.php?s=&action=vehicledetails&userid=94

Thanks!

~Chris

EvilLS1

12-09-2003, 07:06 PM

@ Jeff,
You're welcome. :)

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

timeslipsbit template:

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

Let me know if that doesn't fix it.

Dewayne

PKRWUD

12-09-2003, 07:58 PM

Damn, you're good. I forgot the second "s" in the name of the timeslipsbit template.

*clicks Install with immense pleasure!*

Please tell me you have other hacks, yours work great, and your instructions are excellent, especially to a know-nothing like me. I really like this hack, and the ease with which I installed it.

Thanks again!

Take care,
~Chris

EvilLS1

12-09-2003, 08:40 PM

Thanks Chris. :) Glad its working for you now.

SVTOA

12-13-2003, 03:22 PM

I also added this to the Timeslip Database hack. Check the demo (my site) to see it. Thanks to brendonm and SVTOA for the idea. :)

I don't know what all the drama in this thread is about, and I don't want anyone speaking for me. I know that EvilLS1 has done a GREAT job with his hack. I do not see what he has done as "copying" my idea, and I think the level of support he has offered to those who want to use his creation is A-1 TOP NOTCH and he should be commended for same.

He thanked me and brendonm for ideas, that's an indication of a stand-up guy. I have had some people on other boards accuse me of copying HIS idea, such is life I guess. The bottom line is, when people take the time to help others improve their forums, it's all good.

My version of this hack is nowhere near as comprehensive as Evil's is...
I have made some changes to it, so it loads faster with less draw on the database...

http://www.mach-1.org/vbulletin/quartermileranking.php?s=&action=getall&what=&ltr=&perpage=25&orderby=field6&ausername=&=&direction=ASC&fields[6]=.&pagenumber=1

You have to copy and paste the link to have it work for you...

EvilLS1- take a bow, you have done a GREAT job on this and that is all there is to it. Only thing I can say is, I wish that you had done all this back when I was asking for something like this.. NOBODY replied to my hack request, so I kinda started one of my own... In hindsight, it kind of forced me to learn more about PHP and that's a good thing.

Peace and Happy Holidays!

Greg

SVTOA

12-13-2003, 05:21 PM

sunrunner_pei,

In admin/functions.php find:

$jointime = (time() - $post[joindate]) / 86400; // Days Joined

Above it add:

if ($post[field55]>0){
$postquarter= $post[field55];
}else{
$postquarter="";
}
if ($post[field56]>0){
$postatmph= "@";
$postmph= $post[field56];
}else{
$postatmph="";
$postmph="";
}

Then in your postbit template put this where you want the 1/4 mile ET to show up.:

$postquarter$postatmph$postmph

This way it will only show up if an ET has been entered by the user.

That's awesome- to add: The way that is written, it will only display the ET/MPH. If you want to add some text such as "Best ET" to display along with the stats, add:

$posttext= "Best ET";

to the line above

$postatmph= "@";

Then add:

$posttext$postquarter$postatmph$postmph

to your postbit in the area where you want this to display.

Imprezer

12-30-2003, 03:09 AM

Great hack!

Installed.

My peeps will like it.

Alex
www.i-club.com

Carnage Media

01-18-2004, 07:05 PM

Installed and awesome!

what if you wanted to add another category getting people to tell what kind of suspension they have

like:
stock
tubbed
etc.

maybe in a drop down box?

also, how do you edit in case somebody puts something false in?

Thanks again Evil, I love this one.

SVTBlackLight01

01-18-2004, 07:22 PM

Hey Evil,

Have you looked into making this hack for vb3?

EvilLS1

01-18-2004, 08:53 PM

Carnage,
Thank you.
To add other fields check these two posts:
https://vborg.vbsupport.ru/showpost.php?p=442840&postcount=32
https://vborg.vbsupport.ru/showpost.php?p=450953&postcount=136

also, how do you edit in case somebody puts something false in?

You simply go into your admin panel and edit that user as you normally would. His timeslip info will be listed there. :)

Have you looked into making this hack for vb3?

I plan to within the next few weeks.. I just haven't had enough time to look into it yet (still using VB2).

SVTBlackLight01

01-19-2004, 04:12 AM

Sounds great. Still using VB2 here too. I probably won't be upgrading for a while.

sticky

01-21-2004, 07:26 AM

I can't believe I just found this, I wanted something just like this a few months ago on my forum but I thought it would be too complicated for anyone to ever do. This is the greatest hack in the world.

sticky

01-21-2004, 07:30 AM

Question: Would it be possible to sort by make? I could really use that feature so a user could see what the fastest car in each make was.

Another thing, with the whp column, would you be able to make it so someone can link to their dyno run the same way you do it with the slip?

Edit: What if a person has more than one car?

EvilLS1

01-21-2004, 11:04 PM

Thanks for the kind words.

Question: Would it be possible to sort by make? I could really use that feature so a user could see what the fastest car in each make was.

It is possible but would require alot of work. As it is right now your users can add their vehicle in a regular text input field.. Since its not fool-proof they could enter several different things which would not sort correctly.. For example, if one user enters "Mustang" and another user enters "Ford Mustang" and yet another user enters "stang" they will not be sorted together.

In order to make it possible to sort by vehicles you would need separate select box input fields for vehicle make, model, and year. This would take some time to add, and unfortunately I don't have alot of free time right now. However, if you feel comfortable editing a little php code you could do it yourself. If you'll read back through this thread I've posted instructions on how to add select box input fields and sort by them.

Another thing, with the whp column, would you be able to make it so someone can link to their dyno run the same way you do it with the slip?

Yes, its all explained in this post:
https://vborg.vbsupport.ru/showpost.php?p=450953&postcount=136

Edit: What if a person has more than one car?

You could add an extra field to list other cars, but the timeslips page can only show/sort the info for one car per user.

Carnage Media

01-22-2004, 12:19 AM

Evil, I've been searching but can't find it.

My members would like for the timeslips to be able to show what engine size instead of WHP.

How can I do that?

Thanks.

sticky

01-22-2004, 12:53 AM

Evil, if necessary, I will pay you to have a custom version of this made for my site to compensate for your time.

EvilLS1

01-22-2004, 12:56 AM

Evil, I've been searching but can't find it.

My members would like for the timeslips to be able to show what engine size instead of WHP.

How can I do that?

Thanks.
In timeslips.php find:

} else if ($action=="rwhp") {
$cond.=" WHERE userfield.field51>'".intval($number)."'";
$condition.=" AND userfield.field51>'".intval($number)."'";
$orderby="userfield.field51";
$direction=DESC;
$bracket7="<b>[</b>";
$bracket8="<b>]</b>";

Replace it with:

} else if ($action=="cubes") {
$cond.=" WHERE userfield.field61>'".intval($number)."'";
$condition.=" AND userfield.field61>'".intval($number)."'";
$orderby="userfield.field61";
$direction=DESC;
$bracket7="<b>[</b>";
$bracket8="<b>]</b>";

Find:

if ($userinfo[field51]>0){
$rwhp= $userinfo[field51];
}else{
$rwhp="";
}

Replace it with:

if ($userinfo[field61]!=""){
$cubes= $userinfo[field61];
}else{
$cubes="";
}

In your timeslips template find:

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

Replace it with:

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

Find:

<b>WHP</b>

Replace it with:

<b>C.I.</b>

In your timeslipsbit template find:

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

Replace it with:

<td bgcolor="{secondaltcolor}">$cubes</td>

EvilLS1

01-22-2004, 01:04 AM

Evil, if necessary, I will pay you to have a custom version of this made for my site to compensate for your time.
Thanks for the offer, but $$ is not really the issue. I'm just so busy with other things right now that I don't have time to do any custom work. I haven't even got around to upgrading my own site yet.

Maybe after I finish with all of my own projects.. But that'll probably be a while.

Carnage Media

01-22-2004, 01:15 AM

thank you for the fast response and it worked perfect

EvilLS1

01-22-2004, 01:17 AM

You're welcome. :)

EvilLS1

01-24-2004, 08:15 PM

For those interested, I've started working on a new version of this for VB3. I can only work on it in my spare time (and my spare time is limited) so its probably gonna be a few weeks before I release it. Should be pretty nice though.

Dewayne

0ptima

01-24-2004, 08:21 PM

EvilLS1

01-27-2004, 09:37 PM

I need one person to beta test vB Timeslip Database v2.0 for VB3. Anyone interested?

corsacrazy

01-27-2004, 10:10 PM

I need one person to beta test vB Timeslip Database v2.0 for VB3. Anyone interested?
yes

EvilLS1

01-27-2004, 10:16 PM

yes
Ok, I now have two beta testers.. Thats enough for now. Corsacrazy email me at EvilLS1TA-NOSPAM-@AOL.com (remove the -NOSPAM-) and I'll send you the hack instructions & files.

alkatraz

01-28-2004, 11:23 PM

For those interested, I've started working on a new version of this for VB3.

Awesome!! Can't wait

EvilLS1

01-29-2004, 12:22 AM

Just waiting to hear from my beta testers.. If all is good, I'll release it. :)

bandit022

01-29-2004, 05:09 PM

hey Dewayne,

one more thing if you don't mind. what part of the code do i have to change to require ALL 1/4 mile and 1/8 mile submissions to have a timeslip linked?

i tried setting it to require a timeslip for everyone faster than 16sec thinking that would cover just about everyone, but there are some that put 16.0 just to get their name on the list. so i am having to weed them out about once a week.

thanks for your time AGAIN. :D

-jeff

EvilLS1

01-29-2004, 08:10 PM

Jeff,
Replace the other code with this (in your modifytimeslip template):

<script language="javascript">

</script>

That will require a timeslip for all ETs.

EvilLS1

01-30-2004, 12:57 AM

Version 2.0 for VB3 is here:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=60945

bandit022

01-30-2004, 01:49 AM

dewayne,

you're the man! *cough*even if you do drive an ellis juan*cough*

<--- runs a mustang board/club :D

thanks again...

-jeff

EvilLS1

01-30-2004, 03:23 AM

<--- Ex Mustang owner. ;)

Mobo

02-02-2004, 12:55 PM

Mobo

02-02-2004, 05:23 PM

Okay, I ran into a problem. When I tried to put a link to the timeslip.php file on my forum, ithe page is not found. I added a button int the Head section (forum styles). This what I added...

<a href="timeslips.php?s=$session[sessionhash]"><img src="{imagesfolder}/top_carinfo.gif" alt="Timeslips, Mods and HP!!" border="0"></a>

EvilLS1

02-02-2004, 09:18 PM

Great Hack!! Just installed it with the ET&Trap in the postbit with no probs at all!! Well done.

I do have one question. Would it be possible to make it were only users or a certain User group should show up on the main list (timeslip.php)? My site has normal users and paid members, and I'd like for this to be an extra feature that the paid members have.

Thanks for the great Hack!
Just change the queries in timeslips.php so that it only selects from your specified usergroup like this:

Find:

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

Replace it with:

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

Change the X to the usergroupid in this bit of code: user.usergroupid = X

Then find:

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

Replace it with:

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

Again, change the X in the code above to the usergroupid.

Okay, I ran into a problem. When I tried to put a link to the timeslip.php file on my forum, ithe page is not found. I added a button int the Head section (forum styles). This what I added...

<a href="timeslips.php?s=$session[sessionhash]"><img src="{imagesfolder}/top_carinfo.gif" alt="Timeslips, Mods and HP!!" border="0"></a>

Is this in your forum directory? Try adding $bburl/ before timeslips.php. If that doesn't work just add the full url. If you can go to the page manually its gotta be just a typo in the URL or timeslips.php isn't in that directory.

Mobo

02-03-2004, 10:58 AM

Just change the queries in timeslips.php so that it only selects from your specified usergroup like this:

Find:

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

Replace it with:

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

Change the X to the usergroupid in this bit of code: user.usergroupid = X

Then find:

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

Replace it with:

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

Again, change the X in the code above to the usergroupid.

Is this in your forum directory? Try adding $bburl/ before timeslips.php. If that doesn't work just add the full url. If you can go to the page manually its gotta be just a typo in the URL or timeslips.php isn't in that directory.
EvilLS1 great support for a great hack. Thanks for the quick replies and help. I'll give them a shot.

Mobo

02-03-2004, 12:31 PM

Adding $bburl/ in front of it made it work thanks! Also, the paid members only thing worked as well. Is it possible to add more then one usergroupid to it? So that say paid members and club officers could have their stats show up? Or can you assign a user to more then on usergroup?

EvilLS1

02-03-2004, 02:26 PM

n/p.

Is it possible to add more then one usergroupid to it?

Yes, just use this instead of the other code:

AND user.usergroupid IN (X,X,X)

Replace the X's with the usergroupids. You can add as many as you'd like.. Just separate each one with a comma.

Mobo

02-03-2004, 04:45 PM

Cool, thanks a million!

EvilLS1

02-03-2004, 07:36 PM

Anytime. :)

Tungsten

02-14-2004, 03:00 PM

This is an excellent add-on, EvilLS1. Check your PM, I'd like to slide a little something into your PayPal account for sharing this with everyone. We've been trying unsuccessfully to code a timeslip db for our site for a while now and you just took a major load off of our non-programming asses. :D

EvilLS1

02-14-2004, 08:03 PM

Tungsten,
I'm glad you like it. And thank you very much for offering a donation, but thats not necessary. A simple "thanks" is enough payment for me. :) I use alot of hacks that others have released here, so sharing my own hacks is my way of saying thanks to the vb.org community. Plus, I'm always happy to help out a fellow car enthusiast.

Enjoy the hack, my friend. :)

Sadie Frost

02-16-2004, 01:46 AM

Great hack hon :)

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

EvilLS1

02-16-2004, 02:03 AM

Hey Sadia! :)

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

Dewayne

Sadie Frost

02-16-2004, 02:46 AM

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

EvilLS1

02-16-2004, 02:58 AM

See I did that, but I still don't get select boxes - I'll go through and try again, maybe I missed something :)
Have you installed this hack?
https://vborg.vbsupport.ru/showthread.php?t=21833

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

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

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

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

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

Sadie Frost

02-16-2004, 03:45 AM

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

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

EvilLS1

02-16-2004, 04:14 AM

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

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

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

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

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

if ($bgcolor=="{firstaltcolor}") {
$bgcolor="{secondaltcolor}";
} else {
$bgcolor="{firstaltcolor}";
}

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

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

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

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

###### Replace it with:

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

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

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

if ($bgcolor=="{firstaltcolor}") {
$bgcolor="{secondaltcolor}";
} else {
$bgcolor="{firstaltcolor}";
}
// new options
$TheField="";
$optionlines = explode(',', $profilefield[options]);
$option_bit=$optionlines[0];
if ($profilefield[type]==1) {
// radio
while ($option_bit) {
$option_bit=trim($option_bit);
if ($option_bit == $bbuserinfo[$profilefieldname]) { $LocOn = "checked"; } else { $LocOn = ""; }
$TheField .= "<input type=\"radio\" name=\"$profilefieldname\" value=\"$option_bit\" $LocOn> $option_bit ";
$option_bit=next($optionlines);
}
} elseif ($profilefield[type]==2) {
// select
$TheField = "<select size=\"$profilefield[size]\" name=\"$profilefieldname\">";
while ($option_bit) {
$option_bit=trim($option_bit);
if ($option_bit == $bbuserinfo[$profilefieldname]) { $LocOn = "selected"; } else { $LocOn = ""; }
$TheField .= "<option value=\"$option_bit\" $LocOn>$option_bit</option>";
$option_bit=next($optionlines);
}
$TheField .= "</select>";
} elseif ($profilefield[type]==3) {
// textarea
$bbuserinfo[$profilefieldname]=htmlspecialchars($bbuserinfo[$profilefieldname] );
$TheField = "<textarea name=\"$profilefieldname\" rows=\"6\" cols=\"40\" wrap=\"physical\">$bbuserinfo[$profilefieldname]</textarea>";
} else {
$TheField="<input type=\"text\" class=\"bginput\" name=\"$profilefieldname\" value=\"$bbuserinfo[$profilefieldname]\" size=\"$profilefield[size]\" maxlength=\"$profilefield[maxlength]\">";
}
if ($profilefield[required] == 1) {
$TheField .= " <b><font size=1>* Required</font></b>";
}
// new options

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

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

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

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

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

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

That should do it. ;)

Sadie Frost

02-16-2004, 04:32 AM

YES! It works lol :D Thanks for helping me out :D

EvilLS1

02-16-2004, 04:41 AM

Anytime. Glad ya got it workin'. :)

Carnage Media

02-24-2004, 05:48 AM

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

EvilLS1

02-24-2004, 06:02 AM

hey Evil, what would cause this to happen, you submit your info. but it does not show up? thanks.
Is it not showing any info at all? If not, make sure that the timeslipsbit template has been added and the spelling of the template name is correct.

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

Carnage Media

02-24-2004, 11:19 AM

I entered my info as a test but it didnt' show, this morning I had a user.php error so its probably in there. I'm having to work around the "miserable users" hack also.

EvilLS1

02-25-2004, 03:12 AM

I entered my info as a test but it didnt' show, this morning I had a user.php error so its probably in there. I'm having to work around the "miserable users" hack also.
Weird. Not sure what could be causing it. I registered at your site (1SLlivE) last night to test it and it worked fine for me.

glo

02-29-2004, 02:57 AM

hey EvilLS1,

1.3 great addition to an already great hack! (Now i just have to do the upgrade!) :)

Great work!

glo

02-29-2004, 04:52 AM

EvilLS1, is there anyway to add an image of the vehicle in the "vehicle profile"?

Also, is it easy to sort by any of the other fields?

EvilLS1

02-29-2004, 10:20 PM

Thanks glo. Zzed has released a hack which allows you to add images to the profile. You can easily apply it to the vehicle profile aswell. Check his profile page for a link to the hack.

Check this post to change the default sort method:
https://vborg.vbsupport.ru/showpost.php?p=442298&postcount=15

EvilLS1

03-16-2004, 04:32 AM

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 admin/functions.php find:

//highlight words for search engine

Above it add:

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

Then put $poop in your postbit template where you want it to show up.

ucsigep

06-10-2004, 06:03 AM

kind of bringing up a semi-dead thread, but great hack!! I run a DSM board, and I love the hack! Makes my job a lot easier in keeping track and updating best 1/4 mile times for our club. It's even better that my 12.5 is at the top of the list. :)

A couple issues, however...

After installing the hack, I get an error when trying to register on the board. The error reads:

Parse error: parse error in /home/columb7/public_html/forum/register.php on line 402

If I return register.php back to it's previous state, there are no problems.

Second issue: when on the actual list, I click to sort by (anything), and I get "The requested URL /forum/timeslips.php was not found on this server." I get the same error when clicking on "Submit your timeslip data."

Any assistance in these issues is greatly appreciated! The hack is very beneficial even in it's current state, but I'd like to fix these issues and get it working properly. Oh, I'm using vB 2.3.4, only hacks are this one, xx posts to make new thread, xx days to make new thread, and usertrade rating system.

EvilLS1

06-10-2004, 07:50 AM

ucsigep,
A parse error usually means that something was not pasted correctly when editing the files (maybe a missing ; ).. Try re-applying the file edits to a fresh (unhacked) register.php and see if it works.
As for the other issue, if you'll provide me with a link to your timeslips page I'll take a look at it for you.

Dewayne

ucsigep

06-10-2004, 05:51 PM

it's at http://gs8.inmotionhosting.com/~columb7/forum/timeslips.php (URL hasn't updated to our new host yet).

It may not let you on, we've got it set up to only allow registered users to view. But feel free to register. :)

I'll double check the register.php, but I've tried it about 3 or 4 times and had the same result. I've glanced over the instructions that I'm copying and pasting, I don't see anything that appears to be missing. Thank you for your help, though!!

SVTOA

06-10-2004, 07:13 PM

Make sure you are putting your edit in the right place an have not left anything off.
Perhaps you can post the edit file for examination?

EvilLS1

06-10-2004, 09:04 PM

it's at http://gs8.inmotionhosting.com/~columb7/forum/timeslips.php (URL hasn't updated to our new host yet).

Thats why you're having the problem with the "page not found" error when sorting. Your domain name isn't set yet and the timeslip software is pointing to $bburl/timeslips.php. The $bburl variable is replaced with http://www.columbusdsm.com/forum/ in your browser and that won't work until your domain has updated.

To get around this, in your timeslips template you can find all instances of $bburl/ and remove it..

For example, you would replace this:

<option value="$bburl/timeslips.php?s=$session[sessionhash]&action=quarter">1/4 Mile ET</option>

with this:

<option value="timeslips.php?s=$session[sessionhash]&action=quarter">1/4 Mile ET</option>

Do that for all sort options & also the url for submitting timeslip data.

Or you could just wait until your domain is working and it will work fine.

As for the parse error in register.php if you'll email me the file I'll find the problem and correct it for you. Email it to webmaster@modernmusclecars.net

EvilLS1

06-10-2004, 10:07 PM

ucsigep,
Check your email. I found what was causing your parse error. :)

94supratt

09-08-2004, 03:38 AM

All I get is a blank white screen when I try to post a timeslip.

EvilLS1

09-08-2004, 03:49 AM

All I get is a blank white screen when I try to post a timeslip.

Make sure you added all of the new templates to all styles. Thats about the only thing that could be causing it.

More specifically, check to make sure that you added the "modifytimeslip" template. If so, check the spelling of the template name for a typeo.

EvilLS1

09-08-2004, 04:00 AM

Also check to make sure that you didn't miss an edit in member.php.. You should have this code:

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

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

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

if ($bgcolor=="{firstaltcolor}") {
$bgcolor="{secondaltcolor}";
} else {
$bgcolor="{firstaltcolor}";
}

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

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

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

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

94supratt

09-08-2004, 12:36 PM

Make sure you added all of the new templates to all styles. Thats about the only thing that could be causing it.

More specifically, check to make sure that you added the "modifytimeslip" template. If so, check the spelling of the template name for a typeo.

I didn't add that template. :( I added all the others but somehow skipped over that one. Thanks.

94supratt

09-08-2004, 02:01 PM

Any ideas whats going on with mine?

http://www.tidewaterracing.com/forums/timeslips.php

I thought it was fine. But soon as someone tried to post a time it got all jumbled up.

94supratt

09-08-2004, 02:23 PM

I got it straight.

94supratt

09-08-2004, 10:55 PM

Is there any way to post times for users with multiple times? I quite a few that do.

EvilLS1

09-08-2004, 11:22 PM

Is there any way to post times for users with multiple times? I quite a few that do.

Not at the moment. The timeslips page can only sort one ET per user.

bouncer18

02-09-2005, 03:42 PM

EvilLS1

02-09-2005, 08:35 PM

how would you shop the top 5 on the forum index.php page..

i figured out you need to create the templates but now i cant figure out what modifications need to be made to the index.php itself so it loads properly when $timeslips is called in the forumhome template

You would just need to add this code before the output to the main template (near the bottom of the file) in forums/index.php:

// Top Times add-on
$pos = 0;
$users=$DB_site->query("SELECT *
FROM user,userfield
WHERE user.userid = userfield.userid
AND userfield.field55>0
ORDER BY userfield.field55 ASC
LIMIT 5");

// Set up vars
while ($userinfo=$DB_site->fetch_array($users)) {
$pos++;
$rank= number_format($pos);
$TDusername= $userinfo[username];
$ride= $userinfo[field50];
if ($userinfo[field52]>0){
$sixty= $userinfo[field52];
}else{
$sixty="";
}
if ($userinfo[field55]>0){
$quarter= $userinfo[field55];
}else{
$quarter="";
}
if ($userinfo[field56]>0){
$atmph2="@";
}else{
$atmph2="";
}
if ($userinfo[field56]>0){
$quartermph= $userinfo[field56];
}else{
$quartermph="";
}
eval("\$times .= \"".gettemplate('times')."\";");
} // end while

eval("\$toptimes .= \"".gettemplate('toptimes')."\";");