Well, I for one would love to see the XML patch to this. At least I now know what to tell my 9 second users as to why they are so low on the list!

In the mean time, I'm having all sub 10.000 E/T times enter a leading ZERO (09.911x etc..) so that they sort correctly.

John

I can now see what's going on with my 1/8mi guys. The conditional check in timeslips.php is only looking for values greater than 0 to produce the list....and the list currently sorts by 1/4mi ET by default.

else if ($_REQUEST['do'] == 'quarter')
{
$cond.=" WHERE userfield.field55>0";
$condition.=" AND userfield.field55>0";
$orderby="userfield.field55";
$direction=ASC;
$bracket3="<b>[</b>";
$bracket4="<b>]</b>";

I could change the list to default the sort by 1/8mi but I would rather default to 'username'. Unfortunately the 'username' sort also requires field55 to be greater than 0. Field55 is 1/4mi ET.

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

Same problem here... I hope there is a way to fix this soon so all my users running 9's aren't listed at the BOTTOM :(

The brackets just show what the list is sorted by. If you change the sort to 1/8 mile or 60 foot time, the brackets will move to that column.


The reason that it always requires 1/4 mile ET to be greater than 0 is because all members have a default entry of 0.00 for all of their times on the list. You could change it so that 1/8 mile ET would have to be greater than 0, but then you would have to go through your entire list and make sure that all the users with 1/4 mile times also included their 1/8 mile times, or else they won't be listed.

- Justin

There is a way to fix it, I just can't remember how I did it. It must be listed in this thread somewhere though....

Mine: http://www.njfboa.org/forums/timeslips.php?

- Justin

10-4 on the brackets, thanks

I started reading back at page 1 and found a reference to a decimal value change on page2 but I can't determine if that is for this particular issue. Also, can't determine where exactly to change the values or I would give it a shot.

Look back at post #s 26, 29, (post #31 bug#5). Is this what we're dealing with?

Thanks Tru2Chevy!!

Yes, it would be nice to figure how to fix the 9 second problem. The quickest cars are dead last on the list. This needs to be fixed.

Back in March of '06 I got a version of this with bug fixes from Sidewindr. That is prolly where the fixes I have came from.

- Justin

Any ideas on this? I installed this on my 3.6.4 and everything works except for user profiles now give this error:

Invalid SQL:

SELECT profilefieldid, required, title, type, data, def, height
FROM profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0
ORDER BY displayorder;

MySQL Error : Unknown column 'title' in 'field list'
Error Number : 1054
Date : Friday, November 2nd 2007 @ 07:13:47 PM
Script : http://www.clickclickracing.com/foru...lastposter&f=8
Referrer : http://www.clickclickracing.com/forums/
IP Address : 76.99.159.63
Username : RdRunnr
Classname : vb_database

You're missing the 'title' field. Take a look at this

https://vborg.vbsupport.ru/showpost....&postcount=374

Probably need to run these two queries