include ("forixinc.php");
include ("gp_util.php");
include ("util.php");
function as_menu()
{
extract($GLOBALS);
fxhead("Forix: ".$titulo[$N_STATS]);
tab_ini();
tab_bar(2);
?>
| echo $titulo[$N_STATS]; ?> |
tab_bar(4);
tab_bor();
tab_bar2(4);
?>
Age of the points
Hat tricks
Grand chelems
|
| Fastest |
Wins
Pole positions
Qualifying laps
Fastest laps
|
| Slowest |
Wins
Pole positions
Fastest laps
|
| Distance |
Longest races
Shortest races
|
| Duration |
Longest races
Shortest races
Longest poles
Shortest poles
|
tab_bar2(4);
tab_fim();
fxtail();
return $function_ret;
}
function as_cab($nome)
{
extract($GLOBALS);
tab_ini();
tab_bar(2);
?> echo $titulo[$N_STATS]; ?> echo $nome; ?> |
tab_bar(4);
return $function_ret;
}
function as_fast($modo,$nome)
{
extract($GLOBALS);
fxhead("Forix: ".$nome);
$SQLQuery="SELECT papi.*, ngn.nome as ng_nome, pin.nabr as pi_nome, can.nome as co_nome, mon.nome as mo_nome, pas.tim, pas.med FROM papi, ngn, pin, can, ca, mon, mot, pas where papi.rng=ngn.rng and papi.rpi=pin.rpi and papi.rco=can.rco and papi.rca=ca.rca and papi.rma=mon.rma and papi.rmo=mot.rmo and papi.rpa=pas.rpa and ";
if ($cmd==1 || $cmd==19 || $cmd==60 || $cmd==61)
{
$SQLQuery=$SQLQuery."papi.cla=1 and pas.ses=1 and pas.med <> '-'";
}
if ($cmd==2 || $cmd==29 || $cmd==62 || $cmd==63)
{
$SQLQuery=$SQLQuery."papi.gre=1 and pas.ses=2";
}
if ($cmd==3 || $cmd==39)
{
$SQLQuery=$SQLQuery."papi.vmr=1 and pas.ses=3";
}
if ($cmd==22)
{
$SQLQuery=$SQLQuery."pas.ses=2";
}
$SQLQuery=$SQLQuery." and ngn.lin=".$lin." and can.lin=".$linx." and mon.lin=".$linx;
if ($cmd<60)
{
$SQLQuery=$SQLQuery." order by pas.med";
}
else
{
$SQLQuery=$SQLQuery." order by pas.time";
}
if ($modo==0)
{
$SQLQuery=$SQLQuery." desc";
}
$SQLQuery=$SQLQuery.", papi.rpa Limit 30";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
as_cab($nome);
tab_bor();
?>
| echo $titulo[$N_CLA]; ?> |
if ($cmd<60)
{
?>km/h |
}
else
{
?>Time |
}
?> echo $titulo[$N_YEAR]; ?> |
echo $titulo[$N_GPR]; ?> |
echo $titulo[$N_NUMB]; ?> |
echo $titulo[$N_DRIV]; ?> |
echo $titulo[$N_CAEN]; ?> |
$seq=0;
$anop=0;
$rgp=0;
$rpi=0;
$BGC=$TR2_BGC;
while ($RSList= mysql_fetch_array($result))
{
if ($BGC==$TR1_BGC)
{
$BGC=$TR2_BGC;
}
else
{
$BGC=$TR1_BGC;
}
$seq=$seq+1;
?>
| echo $seq; ?> |
if ($cmd<60)
{
?> echo $RSList["med"]; ?> |
}
else
{
?> echo $RSList["tim"]; ?> |
}
include("cp_ano.php");
include("gp_nome.php");
include("pa_num.php");
include("pi_nome.php");
include("cm_nome.php");
?>
}
?>
|
tab_fim();
}
fxtail();
return $function_ret;
}
function as_dist($modo,$nome)
{
extract($GLOBALS);
fxhead("Forix: ".$nome);
$SQLQuery="SELECT gp.rgp, gp.dist, ngn.nome as ng_nome FROM gp, ngn where gp.rng=ngn.rng and ngn.lin=".$lin." order by gp.dist";
if ($modo==0)
{
$SQLQuery=$SQLQuery." desc";
}
$SQLQuery=$SQLQuery.", gp.rgp Limit 30";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
as_cab($nome);
tab_bor();
?> |
tab_fim();
}
fxtail();
return $function_ret;
}
function as_hattricks()
{
extract($GLOBALS);
fxhead("Forix: Hat tricks");
$SQLQuery="SELECT pin.nome as pi_nome, pin.rpi, Count(papi.rpi) AS total FROM pin, papi Where pin.rpi=papi.rpi and papi.gre=1 AND papi.cla=1 AND papi.vmr=1 GROUP BY pin.nome, pin.rpi, papi.gre, papi.cla, papi.vmr ORDER BY total DESC, pin.rpi";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
as_cab("Hat tricks");
tab_bor();
?>
| echo $titulo[$N_ASEQ]; ?> |
echo $titulo[$N_DRIV]; ?> |
echo $titulo[$N_TOTAL]; ?> |
$seq=0;
$rpi=0;
$BGC=$TR2_BGC;
while ($RSList= mysql_fetch_array($result))
{
if ($BGC==$TR1_BGC)
{
$BGC=$TR2_BGC;
}
else
{
$BGC=$TR1_BGC;
}
$seq=$seq+1;
?>
| echo $seq; ?> |
include("pi_nome.php");
?>
echo $RSList["total"]; ?> |
}
?>
|
tab_fim();
}
fxtail();
return $function_ret;
}
function as_gchelems()
{
extract($GLOBALS);
fxhead("Forix: Grand chelems");
$SQLQuery="SELECT pin.nome as pi_nome, Count(papi.rpi) as total, pin.rpi FROM gp, pin, papi Where pin.rpi=papi.rpi and papi.gre=1 AND papi.cla=1 AND papi.vmr=1 AND papi.cnv=gp.nv AND truncate(rpa/1000,0)=gp.rgp GROUP BY pin.nome, pin.rpi ORDER BY total desc, pin.rpi";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
as_cab("Grand chelems");
tab_bor();
?>
| echo $titulo[$N_ASEQ]; ?> |
echo $titulo[$N_DRIV]; ?> |
echo $titulo[$N_TOTAL]; ?> |
$seq=0;
$rpi=0;
$BGC=$TR2_BGC;
while ($RSList= mysql_fetch_array($result))
{
if ($BGC==$TR1_BGC)
{
$BGC=$TR2_BGC;
}
else
{
$BGC=$TR1_BGC;
}
$seq=$seq+1;
?>
| echo $seq; ?> |
include("pi_nome.php");
?>
echo $RSList["total"]; ?> |
}
?>
|
tab_fim();
}
fxtail();
return $function_ret;
}
$cmd=intval(get_arg("c"));
log_page($REF_STAT,0,$cmd);
if ($cmd==4)
{
as_hattricks();
}
else
if ($cmd==5)
{
as_gchelems();
}
else
if ($cmd==1)
{
as_fast(0,"Fastest wins");
}
else
if ($cmd==19)
{
as_fast(1,"Slowest wins");
}
else
if ($cmd==2)
{
as_fast(0,"Fastest pole positions");
}
else
if ($cmd==29)
{
as_fast(1,"Slowest pole positions");
}
else
if ($cmd==22)
{
as_fast(0,"Fastest qualifying laps");
}
else
if ($cmd==3)
{
as_fast(0,"Fastest fastest laps");
}
else
if ($cmd==39)
{
as_fast(1,"Slowest fastest laps");
}
else
if ($cmd==50)
{
as_dist(0,"Longest races");
}
else
if ($cmd==51)
{
as_dist(1,"Shortest races");
}
else
if ($cmd==60)
{
as_fast(0,"Longest races");
}
else
if ($cmd==61)
{
as_fast(1,"Shortest races");
}
else
if ($cmd==62)
{
as_fast(0,"Longest poles");
}
else
if ($cmd==63)
{
as_fast(1,"Shortest poles");
}
else
{
as_menu();
}
?>