SELECT
driver.uid, driver.pname, driver.uname,
records_pb.uid, records_pb.track, records_pb.time,
records_wr.uid, records_wr.track, records_wr.time
FROM
driver, records_pb, records_wr
WHERE
driver.uid = records_pb.uid
OR
driver.uid = records_wr.uid
LIMIT
UPDATED FROM LAST QUERY;
$ curl 'http://www.lfsworld.net/pubstat/get_stat2.php?idk=<IDENTKEY>&version=1.4&s=1&action=ch&track=410&car=FXR'
[{"id_hl":"29961","split1":"29490","split2":"63940","split3":0,"laptime":"95140","flags_hlaps":"513","racername":"C.Schuht"},{"id_hl":"29750","split1":"29730","split2":"64140","split3":0,"laptime":"95360","flags_hlaps":"513","racername":"crazydav"},{"id_hl":"28002","split1":"29570","split2":"64240","split3":0,"laptime":"95750","flags_hlaps":"1601","racername":"Vugl@"},{"id_hl":"29671","split1":"29890","split2":"64520","split3":0,"laptime":"95890","flags_hlaps":"513","racername":"kiste"},{"id_hl":"29532","split1":"29740","split2":"64760","split3":0,"laptime":"96210","flags_hlaps":"513","racername":"phoenixIlooka"},{"id_hl":"29340","split1":"30160","split2":"65160","split3":0,"laptime":"96740","flags_hlaps":"8705","racername":"tournois"},{"id_hl":"27975","split1":"29970","split2":"64930","split3":0,"laptime":"96930","flags_hlaps":"129","racername":"max92"},{"id_hl":"27263","split1":"30350","split2":"65260","split3":0,"laptime":"97180","flags_hlaps":"8705","racername":"Fall_Angel"},{"id_hl":"28700","split1":"30350","split2":"65940","split3":0,"laptime":"97820","flags_hlaps":"513","racername":"marcel."},{"id_hl":"29312","split1":"31930","split2":"70950","split3":0,"laptime":"104820","flags_hlaps":"1609","racername":"tomona"},{"id_hl":"28427","split1":"32100","split2":"71080","split3":0,"laptime":"104920","flags_hlaps":"513","racername":"J"},{"id_hl":"27105","split1":"35150","split2":"76110","split3":0,"laptime":"111680","flags_hlaps":"8704","racername":"AtomicRacer"}]
{"id_hl":"28427","split1":"32100","split2":"71080","split3":0,"laptime":"104920","flags_hlaps":"513","racername":"J"}
[
{
"id_hl" : "28427",
"split1" : "32100",
"split2" : "71080",
"split3" : 0,
"laptime" : "104920",
"flags_hlaps" : "513",
[b]"racername" : "Jörg Baumgarth"[/b]
}
]
<?php
$url = 'http://www.lfsworld.net/pubstat/get_stat2.php?version=1.4&idk=<IDK>&ps=1&action=ch&track=410&car=FXR&control=0';
for ($i = 0; $i <= 3; $i++)
print "<H{$i}>{$i}</H{$i}>". file_get_contents($url . '&s=' . $i) . "<BR />";
?>
$spiChars = [url=http://php.net/manual/en/book.array.php]array[/url](
'a' => [url=http://php.net/manual/en/book.array.php]array[/url](
'ª', 'À', 'Á', 'Â', 'Ã', 'Ä', 'Å', 'à', 'á', 'â', 'ã', 'ä', 'å', 'Ā', 'ā', 'Ă', 'ă', 'Ą', 'ą'
),
'e' => [url=http://php.net/manual/en/book.array.php]array[/url](
'È', 'É', 'Ê', 'Ë', 'è', 'é', 'ê', 'ë', 'Ē', 'ē', 'Ĕ', 'ĕ', 'Ė', 'ė', 'Ę', 'ę', 'Ě', 'ě'
),
'i' => [url=http://php.net/manual/en/book.array.php]array[/url](
'Ì', 'Í', 'Î', 'Ï', 'ì', 'í', 'î', 'ï', 'Ĩ', 'ĩ', 'Ī', 'Ĭ', 'ĭ', 'Į', 'į', 'İ', 'ı'
),
'o' => [url=http://php.net/manual/en/book.array.php]array[/url](
'Ò', 'Ó', 'Ô', 'Õ', 'Ö', 'Ø', 'ò', 'ó', 'ô', 'õ', 'ö', 'ø', 'Ō', 'ō', 'Ŏ', 'ŏ', 'Ő', 'ő'
),
'u' => [url=http://php.net/manual/en/book.array.php]array[/url](
'Ù', 'Ú', 'Û', 'Ü', 'Ũ', 'ũ', 'Ū', 'ū', 'Ŭ', 'ŭ', 'Ů', 'ů', 'Ű', 'ű', 'Ų', 'ų', 'Ǔ', 'ǔ', 'Ǖ', 'ǖ', 'Ǘ', 'ǘ', 'Ǚ', 'ǚ', 'Ǜ', 'ǜ'
)
);
[url=http://php.net/foreach]foreach[/url] ($spiChars as $replace => $search) {
[url=http://php.net/str_replace]str_replace[/url]($search, $replace, $pre_jsoned_string);
}
<?php
php
$ext = new ReflectionExtension('json');
echo phpversion(), ' / ', $ext->getName(), '-', $ext->getVersion(), PHP_EOL; // 5.2.6 / json-1.2.1
echo json_encode('Jörg Baumgarth'), PHP_EOL; // "J"
echo $json = json_encode(mb_convert_encoding('Jörg Baumgarth', 'UTF-8', 'ISO-8859-1')), PHP_EOL; // "J\u00f6rg Baumgarth"
echo mb_convert_encoding(json_decode($json), 'ISO-8859-1', 'UTF-8'), PHP_EOL; // Jörg Baumgarth
?>
>> LFSWorldHelper.fetch_hot_laps_chart("KY2", "FXR").select {|r| r["id_hl"] == 28427 }
=> [{"racername"=>"Jörg Baumgarth", "split1"=>32100, "flags_hlaps"=>513, "split2"=>71080, "id_hl"=>28427, "split3"=>0, "laptime"=>104920}]
<?php
php
echo "<p>Niall's Online Status:</p>";
if( $str=file_get_contents( 'http://www.lfsworld.net/pubstat/get_stat2.php?version=1.4&idk=<ident-key>&action=pst&racer=niall09'))
if($str[66] == "0")
echo "<p><span class='off'>Offline</span></p>";
if($str[66] == "1")
echo "<p><span class='spec'>Spectating</span></p>";
if($str[66] == "2")
echo "<p><span class='pit'>in the pits</span></p>";
if($str[66] == "3")
echo "<p><span class='race'>Racing</span></p>";
?>
;;;;;;;;;;;;;;;;;;
; Fopen wrappers ;
;;;;;;;;;;;;;;;;;;
; Whether to allow the treatment of URLs (like http:// or ftp://) as files.
allow_url_fopen = On