Thanks mate, in the same server script load was reduced from about 35 to 8 seconds, incredibile.

Thanked in readme.txt file.

Interesting, thanks for suggestion.

According con new kind of Airio files (tab separated) i've created under suggestion of EQ Worry a new script (u can see attached in first post) to manage this kind of file.

It works in this way:
- first copy in local from remote airio file (so u'll see in your web space two new files: cr.txt and un.txt);
- then manage and convert them in db.

Please report bug if u find one.

Thanks in advance.

Quote from brianbakers :

actually there is a way to get the setup from a SP replay, but not from MP replay. You can get the whole complete set. So given that I have the WR replay, I can get the WR set. But the best way to improve is still make your own.

Sure of that ?
Can u explain this method ?

In menu.php

<select name="selectcar" size="2" style="width:160px; height:114px;" onChange="form.submit()">
<option value="">All Car</option>
<option value="GT2">GT2 Cars</option>
<option value="GTL">GTL Cars</option>
<option value="GTR">GTR Cars</option>
<option value="TBO">TBO Cars</option>
<?php
$cont = 1;
$db = mysql_connect ($localhost, $user, $password);
mysql_select_db ($database, $db);
$stringa = "select distinct car from lfslappertable order by car asc";
$result = mysql_query($stringa, $db);
while ($row = mysql_fetch_array($result))
{
if ($cont == 1)
{
echo "<option value='$row[car]' selected='selected'>$row[car]</option>";
}
else
{
echo "<option value='$row[car]'>$row[car]</option>";
}
$cont = $cont + 1;
}
mysql_close($db);
?>
</select>


---

replace with

---

<select name="selectcar" size="2" style="width:160px; height:114px;" onChange="form.submit()">
<?php
$cont = 1;
$db = mysql_connect ($localhost, $user, $password);
mysql_select_db ($database, $db);
$stringa = "select distinct car from lfslappertable order by car asc";
$result = mysql_query($stringa, $db);
while ($row = mysql_fetch_array($result))
{
if ($cont == 1)
{
echo "<option value='$row[car]' selected='selected'>$row[car]</option>";
}
else
{
echo "<option value='$row[car]'>$row[car]</option>";
}
$cont = $cont + 1;
}
mysql_close($db);
?>
<option value="">All Car</option>
<option value="GT2">GT2 Cars</option>
<option value="GTL">GTL Cars</option>
<option value="GTR">GTR Cars</option>
<option value="TBO">TBO Cars</option>
</select>

Good for u !!!

About AU request, yes u can, in menu.php find this line:

$stringa = "select distinct track from lfslappertable order by track asc";

replace with:

$stringa = "select distinct track from lfslappertable where track not like 'AU%' order by track asc";

Uhm, since is really hard (for me) find a solution !
But u can try to use, in page.php and page2.php font size=1 and not 2.
Can u test this ?

Can u post in a zip all the file that u are using and explain again exactly what u want do ?

then change in page2.php the same think that u have change in page.php

OK

<iframe id = "lfslapper" name = "lfslapper" width="636px" src ="page2.php?selectcar=&selecttrack=&orderby=times&usern=" onLoad = "changeContent()" style = "height:0; width:636x; border-width:0;">

change 636 in what u want

A ok perfect.

U have to edit page.php

Search
"<table bgcolor='#CCCCCC' border='1' bordercolor='1' cellspacing='0' cellpadding='1'>"

replace with

"<table bgcolor='#CCCCCC' border='1' bordercolor='1' cellspacing='0' cellpadding='1' width='XXX'>

XXX = what u want

U have to edit index.html too.

<frameset cols="200,*" frameborder="no">

in

<frameset cols="XXX,*" frameborder="no">

XXX = what u want

Wich table ?
About internal table where u select track or car u need edit menu.php, it's simple u can find "pixel" value of each "table".

Released, see on first post.

Errata corrige.

Take a look now.

Total drift and drift score for single track.

One question, i'm near to release version 1.0.1 for times and drift score.

But there's a problem:

http://www.g5c.com/lfslapperscript2/

For me in drift data when i displayed it is not "intelligenze" display tracks and car because drift score are for all, not for single track/car.

Is this correct ?

New script will store times and drift score, only drift or only times.

I try to "do" one only script for drift score and times.

Emil on the left there is the date/time of update

Check this one:

http://www.g5c.com/lfslapperscript/

I think we can use auto refresh without button because lfslapper db is not big like airio db.

Where i can found drift data ?

@emit-nl

--> I think it would be nice if I can do something like this: if the track KY2R is stored in the database, then select KY2R as standart value in the menu.php, instead of All Tracks.

This only if there one track, right ?

--> It would also be cool if you can add a line in the page like: 'Results last updated on date&time'.

I can do this one if u want, simple adding a new field in db.

--> Is it possible to make the page.php load before you hit the show results button? And maybe remove the button and make the page change when you click on a filter?

I did this one but i return back because if u have a big db this cause a big load server charge.

But if u want to it simple, in menù.php

ORIGINAL
<select name="selecttrack" size="2" style="width:160px; height:114px;">

MODIFIED:
<select name="selecttrack" size="2" style="width:160px; height:114px;" onchange="form.submit()">

This one for ALL select.

---

About iframe, I don't know java script language so i don't know other solution more "modern".

Last edited by michele0676, Tue, 23 Feb 2010 08:13.

Sorry for late @emit-nl
i was busy in these day but i can see that u solved the problem (iframe).

sure u can

LOL !

http://www.youtube.com/watch?v=JYCvsxcdimI

Quote from emit-nl :

Hi,

I just have been trying to make your lfslapperscript working, but I really have no experience with MySQL and PHPMyAdmin. I've seen your readme and mysql instructions files.. but still I can't get it, mainly because PHPMyAdmin there are much more values you can fill in.

So, could you help me with this please?
I attached some screenshots of PHPMyAdmin, and I'm sure it's not correct what I typed in it.. but hope you can tell me what to do.

Btw, I allready edited the config.php file for my database.
Link to the test website: www.sinsanity.nl/testt/website/Sinsanity.nl/lfslapperscript

Thanks in advance!

Tim

Select SQL task in the top then paste the contents of mysql_instrunction.txt e run it.

Quote from Fire_optikz001 :

-attacks dbs file-

I cannot see the attachs.

Can u attack one .dbs file please ?