");
echo("$titulo[$N_GPR] | ");
ng_select ("rng", $rng);
echo(" | ");
} else {
echo("");
if ($modo == 0)
tab_bar(4);
}
function NGtabela()
{
global $pub_part, $lin, $linEng, $TR1_BGC;
$pub_part=0;
fxhead("Forix: Grands Prix");
tab_ini();
tab_bar(2);
echo("Grands Prix | ");
tab_bar(4);
tab_bor();
?>
Code |
English |
echo Lingua($lin); ?> |
$SQLQuery="SELECT ngn.nome,ngn.rng from ngn where ngn.lin=".$linEng." order by ngn.rng";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0) {
campo($result,"rng","center");
campo($result,"nome","left");
$SQLQuery="SELECT ngn.nome from ngn where ngn.lin=".$lin." order by ngn.rng";
echo("".chr(10));
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
campo($result,"nome","left");
else
echo(" | ");
}
echo(" | ");
tab_fim();
fxtail();
}
function NGlista()
{
extract($GLOBALS);
fxhead("Forix: ".$titulo[$N_GPRIS]);
tab_ini();
tab_bar(2);
?> echo $titulo[$N_GPRIS]; ?> |
tab_bar(4);
tab_bor();
$SQLQuery="SELECT ng.*, ngn.nome as ng_nome from ng inner join ngn on ng.rng=ngn.rng where ngn.lin=".$lin." order by ";
switch ($sort)
{
case 1:
$SQLQuery=$SQLQuery."ng.ngp,";
break;
case 2:
$SQLQuery=$SQLQuery."ng.rgpi,";
break;
case 3:
$SQLQuery=$SQLQuery."ng.rgpf,";
break;
default:
$sort=0;
break;
}
$SQLQuery=$SQLQuery."ngn.nome";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
?> |
}
tab_fim();
fxtail();
return $function_ret;
}
function NGfic_vpr($ngp,$modo)
{
extract($GLOBALS);
$SQLQuery="SELECT papi.*, pin.nabr as pi_nome, can.nome as co_nome, mon.nome as mo_nome FROM ((((papi inner join pin on papi.rpi=pin.rpi) inner join can on papi.rco=can.rco) inner join ca on papi.rca=ca.rca) inner join mon on papi.rma=mon.rma) inner join mot on papi.rmo=mot.rmo where papi.rng=".$rng." and ";
switch ($modo) {
case 1:
$SQLQuery=$SQLQuery."papi.cla=1";
break;
case 2:
$SQLQuery=$SQLQuery."papi.gre=1";
break;
case 3:
$SQLQuery=$SQLQuery."papi.vmr=1";
break;
}
$SQLQuery=$SQLQuery." and can.lin=".$linx." and mon.lin=".$linx." order by papi.rpa desc Limit 3";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0) {
echo(" | ");
echo("");
switch ($modo) {
case 1:
echo("$titulo[$N_WINS]");
break;
case 2:
echo("$titulo[$N_POLES]");
break;
case 3:
echo("$titulo[$N_FLAPS]");
break;
}
echo(" | ");
while ($RSList= mysql_fetch_array($result)) {
echo("".(1900+intval($RSList["rpa"]/100000))." ".$RSList["pi_nome"]." | ");
include ("cm_nome.php");
echo(" ");
}
if ($ngp>3)
echo(". . . | ");
}
}
function NGfic()
{
extract($GLOBALS);
fxhead("Forix: ".$ng_nome);
$SQLQuery="SELECT ng.* from ng where ng.rng=".$rng;
if (($result = mysql_query($SQLQuery)) and ($RSList = mysql_fetch_array($result))) {
ng_cab("");
$ngp=$RSList["ngp"];
if ($ngp>0) {
tab_bor();
echo("");
// Left space
echo(" | ");
echo("");
echo(" |
if ($ngp > 0) {
echo("");
NGfic_vpr($ngp,1);
NGfic_vpr($ngp,2);
NGfic_vpr($ngp,3);
echo(" | ");
}
?>
|
if ($zip!=$Zip_CDROM) {
// Middle space
echo(" | ");
echo("");
// Trivia
$nl=rand(1,50);
$SQLQuery="Select trivia.* from trivia where trivia.lin=".$lin." and trivia.cref=".$REF_NG." and trivia.ref=".$rng." and trivia.seq=".$nl;
if (($result2 = mysql_query($SQLQuery)) and ($RStriv = mysql_fetch_array($result2)))
{
?>
Trivia |
|
|
}
// Photo gallery
$SQLQuery="SELECT count(fotos.foto) as total FROM fotos, contactos, gp Where fotos.sig=contactos.sig and truncate(fotos.ref/1000,0)=gp.rgp and fotos.dat<=$hiso and (fotos.gal='img' or fotos.gal is NULL) and fotos.cref=$REF_PA and gp.rng=$rng";
if (($result = mysql_query($SQLQuery)) and ($RSList = mysql_fetch_array($result))) {
$n=$RSList["total"];
if ($n > 0) {
$SQLQuery="SELECT fotos.*, contactos.copynote FROM fotos, contactos, gp Where fotos.sig=contactos.sig and truncate(fotos.ref/1000,0)=gp.rgp and fotos.dat<=$hiso and (fotos.gal='img' or fotos.gal is NULL) and fotos.cref=$REF_PA and gp.rng=$rng Limit ". rand(0,$n-1) .", 1";
$RSList= mysql_fetch_array(mysql_query($SQLQuery));
if ($n > 1) {
tab_bar2(4);
echo("$titulo[$N_PGAL] | ");
} else
tab_bar1(6);
echo("");
if ($RSList["zoom"]==0)
echo(" ");
else
echo(" ");
echo("".$RSList["copynote"]." | ");
echo(" | ");
}
}
// Milestones, words, etc.
echo("$titulo[$N_MILE] | ");
echo("$titulo[$N_WWORS] | ");
echo(" | ");
// Statistics
echo("$titulo[$N_STATS] | ");
tab_select(1);
echo(" | ");
}
// Right space
echo(" | ");
echo("
| ");
tab_bar1(8);
}
if ($zip!=$Zip_CDROM) {
Bkp($REF_NG,$rng,$lin);
www($REF_NG,$rng);
}
}
if ($zip != $Zip_CDROM) {
tab_bor();
ng_sel(0);
} else
tab_bar(4);
tab_fim();
fxtail();
}
function NGgpr()
{
extract($GLOBALS);
fxhead("Forix: ".$ng_nome.", ".$titulo[$N_GPRIS]);
$SQLQuery="SELECT gp.*, ngn.nome as ng_nome, ci.perim, ncn.nome as nc_nome, tmeses.sigla as mes FROM (((ngn INNER JOIN gp ON gp.rng = ngn.rng) inner join ci on ci.rci=gp.rci) inner join ncn on ncn.rnc=ci.rnc) inner join tmeses on gp.mm=tmeses.cod where gp.rng=".$rng." and ngn.lin = ".$lin." and ncn.lin = ".$lin." and tmeses.lin = ".$lin." order by ";
switch ($sort)
{
case 2:
$SQLQuery=$SQLQuery."ncn.nome,";
break;
case 3:
$SQLQuery=$SQLQuery."ci.perim,";
break;
case 4:
$SQLQuery=$SQLQuery."gp.nv,";
break;
case 5:
$SQLQuery=$SQLQuery."gp.dist,";
break;
case 6:
$SQLQuery=$SQLQuery."gp.npar,";
break;
case 7:
$SQLQuery=$SQLQuery."gp.nqua,";
break;
case 8:
$SQLQuery=$SQLQuery."gp.ncla,";
break;
case 9:
$SQLQuery=$SQLQuery."gp.nass,";
break;
}
$SQLQuery=$SQLQuery."gp.rgp";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
ng_cab($titulo[$N_GPRIS]);
tab_bor();
?>
echo $titulo[$N_ASEQ]; ?> |
ng_sort($titulo[$N_GPR],0);
?> echo $titulo[$N_DATE]; ?> |
if ($bloc==0)
{
ng_sort($titulo[$N_CIRC],2);
ng_sort($titulo[$N_APER]." [m]",3);
ng_sort($titulo[$N_LAPS],4);
ng_sort($titulo[$N_DIST]." [km]",5);
}
else
{
ng_sort($titulo[$N_ENT],6);
ng_sort($titulo[$N_QUALS],7);
ng_sort($titulo[$N_CLAD],8);
ng_sort($titulo[$N_ATT],9);
}
?>
$seq=0;
$rci=0;
$BGC=$TR2_BGC;
while ($RSList= mysql_fetch_array($result))
{
if ($BGC==$TR1_BGC)
{
$BGC=$TR2_BGC;
}
else
{
$BGC=$TR1_BGC;
}
$ss=intval(substr($RSList["rgp"],strlen($RSList["rgp"])-(2)));
if ($ss>80)
{
$m=1;
$BGC=$CAB_BGC;
}
else
{
$m=0;
}
?>
include ("seq.php");
if ($m==0)
{
?>
&c= echo $cmdGPfic; ?>"> echo 1900+intval($RSList["rgp"]/100); ?> |
}
else
{
?>
&c= echo $cmdNGfic; ?>"> echo 1900+intval($RSList["rgp"]/100); ?> |
} ?>
echo pri_datab($RSList["dd"],$RSList["mes"],0); ?> |
if ($bloc==0)
{
include ("ci_nome.php");
?>
echo $RSList["perim"]/10; ?> |
echo $RSList["nv"]; ?> |
echo sprintf("%0.3f",$RSList["dist"]/1000); ?> |
}
else
{
?>
if ($RSList["npar"]>0)
{
?> echo $RSList["npar"]; ?> } ?> |
if ($RSList["nqua"]>0)
{
?> echo $RSList["nqua"]; ?> } ?> |
if ($RSList["ncla"]>0)
{
?> echo $RSList["ncla"]; ?> } ?> |
if ($RSList["nass"]>0)
{
?> echo $RSList["nass"]; ?> 000 } ?> |
} ?>
}
?>
|
tab_bor();
ng_menu(1);
ng_sel(0);
tab_fim();
}
fxtail();
return $function_ret;
}
function NGvpr($nome)
{
extract($GLOBALS);
fxhead("Forix: ".$ng_nome.", ".$nome);
$SQLQuery="SELECT papi.*, ngn.nome as ng_nome, pin.nabr as pi_nome, can.nome as co_nome, ca.nome as ca_nome, mon.nome as mo_nome, mot.tipo as mo_tipo, pas.tim, pas.med FROM ((((((ngn INNER JOIN papi ON papi.rng = ngn.rng) inner join pin on papi.rpi=pin.rpi) inner join can on papi.rco=can.rco) inner join ca on papi.rca=ca.rca) inner join mon on papi.rma=mon.rma) inner join mot on papi.rmo=mot.rmo) inner join pas on papi.rpa=pas.rpa where papi.rng=".$rng." and ";
if ($cmd==$cmdNGvit)
$SQLQuery=$SQLQuery."papi.cla=1 and pas.ses=1";
else if ($cmd==$cmdNGpol)
$SQLQuery=$SQLQuery."papi.gre=1 and pas.ses=2";
else if ($cmd==$cmdNGvmr)
$SQLQuery=$SQLQuery."papi.vmr=1 and pas.ses=3";
$SQLQuery=$SQLQuery." and ngn.lin = ".$lin." and can.lin=".$linx." and mon.lin=".$linx." order by ";
switch ($sort)
{
case 1:
$SQLQuery=$SQLQuery."papi.num,";
break;
case 2:
$SQLQuery=$SQLQuery."pin.apel,";
break;
case 3:
if ($bloc==0)
$SQLQuery=$SQLQuery."can.nome,ca.nome,";
else
$sort=0;
break;
case 4:
if ($bloc==0)
$SQLQuery=$SQLQuery."mon.nome,mot.tipo,";
else
$sort=0;
break;
case 5:
if ($bloc==1)
$SQLQuery=$SQLQuery."pas.tim,";
else
$sort=0;
break;
case 6:
if ($bloc==1)
$SQLQuery=$SQLQuery."pas.med,";
else
$sort=0;
break;
}
$SQLQuery=$SQLQuery."papi.rpa";
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
{
ng_cab($nome);
tab_bor();
?>
echo $titulo[$N_ASEQ]; ?> |
ng_sort($titulo[$N_GPR],0);
ng_sort($titulo[$N_NUMB],1);
ng_sort($titulo[$N_DRIV],2);
if ($bloc==0)
{
ng_sort($titulo[$N_CAR],3);
if ($super_modo>=$Modo_clube)
{
?> echo $titulo[$N_CHAS]; ?> |
}
ng_sort($titulo[$N_ENG],4);
}
else
{
ng_sort($titulo[$N_TIME],5);
ng_sort("km/h",6);
}
?>
$seq=0;
$rgp=0;
$rpi=0;
$rca=0;
$rmo=0;
$BGC=$TR2_BGC;
while ($RSList= mysql_fetch_array($result))
{
if ($BGC==$TR1_BGC) $BGC=$TR2_BGC; else $BGC=$TR1_BGC;
$rgpa=intval($RSList["rpa"]/1000);
if ($rgpa!=$rgp)
{
$seq=$seq+1;
$rgp=$rgpa;
}
?> echo $seq; ?> |
echo 1900+intval($rgp/100); ?> |
include ("pa_num.php");
include ("pi_nome.php");
if ($bloc==0)
{
include ("car_link.php");
if ($super_modo>=$Modo_clube)
{
?>
echo $RSList["cha"]; ?> |
}
include ("mot_link.php");
}
else
{
?>
echo $RSList["tim"]; ?> |
echo $RSList["med"]; ?> |
} ?>
}
?>
|
tab_bor();
ng_menu(1);
ng_sel(0);
tab_fim();
}
fxtail();
return $function_ret;
}
function ng_cref ($RSList)
{
global $args, $cref, $REF_PI, $REF_CO, $REF_MA, $REF_PN;
global $zip, $Zip_PHOCD, $Zip_CDROM, $rpi, $rco, $rma, $rpn;
global $cmdPIfic, $cmdCMfic, $cmdPNfic;
switch ($cref) {
case $REF_PI:
include ("pi_nome.php");
break;
case $REF_CO:
include ("co_nome.php");
break;
case $REF_MA:
include ("mo_nome.php");
break;
case $REF_PN:
include ("pn_nome.php");
break;
}
}
function ng_val ($RSList, $icmd, $icref)
{
global $args, $rng, $cmdStat, $cmdStatPon;
global $REF_PI, $REF_CO, $REF_MA, $REF_PN;
if ($rng == 0)
$rnga = $RSList["rng"];
else
$rnga = $rng;
$val = $RSList["val"];
echo(" ");
if ($icmd<$cmdStatPon)
switch ($icref) {
case $REF_PI:
echo("$val");
break;
case $REF_CO:
echo("$val");
break;
case $REF_MA:
echo("$val");
break;
case $REF_PN:
echo("$val");
break;
}
if ($icmd==$cmdStatPon)
echo($val/100);
if ($icmd>$cmdStatPon)
echo($val);
echo(" | ");
}
function NGtop_ ($bgc, $icmd)
{
global $lin, $linx, $cref, $rng, $REF_PI, $REF_CO, $REF_MA, $REF_PN;
global $zip, $Zip_PHOCD, $Zip_CDROM, $rpi, $rco, $rma, $rpn;
switch ($cref) {
case $REF_PI:
if ($rng == 0)
$SQLQuery="Select ng_stat.rng, ng_stat.val, pin.rpi, pin.nabr as pi_nome, ngn.nome as gp_nome from ng_stat, pin, ngn where ng_stat.ref=pin.rpi and ng_stat.rng=ngn.rng and ngn.lin=$lin and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." order by ng_stat.val desc, pin.rpi limit 10";
else
$SQLQuery="SELECT ng_stat.val, pin.rpi, pin.nabr as pi_nome From pin inner join ng_stat on ng_stat.ref=pin.rpi where ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." order by ng_stat.val desc, pin.rpi limit 10";
break;
case $REF_CO:
if ($rng == 0)
$SQLQuery="Select ng_stat.rng, ng_stat.val, can.rco, can.nome as co_nome, ngn.nome as gp_nome from ng_stat, can, ngn where ng_stat.ref=can.rco and ng_stat.rng=ngn.rng and ngn.lin=$lin and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." and can.lin=".$linx." order by ng_stat.val desc, can.rco limit 10";
else
$SQLQuery="SELECT ng_stat.val, can.rco, can.nome as co_nome from ng_stat, can where ng_stat.ref=can.rco and ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." and can.lin=".$linx." order by ng_stat.val desc, can.rco limit 10";
break;
case $REF_MA:
if ($rng == 0)
$SQLQuery="Select ng_stat.rng, ng_stat.val, mon.rma, mon.nome as mo_nome, ngn.nome as gp_nome from ng_stat, mon, ngn where ng_stat.ref=mon.rma and ng_stat.rng=ngn.rng and ngn.lin=$lin and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." and mon.lin=".$linx." order by ng_stat.val desc, mon.rma limit 10";
else
$SQLQuery="SELECT ng_stat.val, mon.rma, mon.nome as mo_nome from ng_stat, mon where ng_stat.ref=mon.rma and ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." and mon.lin=".$linx." order by ng_stat.val desc, mon.rma limit 10";
break;
case $REF_PN:
if ($rng == 0)
$SQLQuery="Select ng_stat.rng, ng_stat.val, tpneu.cod as cpne, tpneu.nome as pneu, ngn.nome as gp_nome from ng_stat, tpneu, ngn where ng_stat.ref=tpneu.cod and ng_stat.rng=ngn.rng and ngn.lin=$lin and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." and tpneu.lin=".$linx." order by ng_stat.val desc, tpneu.cod limit 10";
else
$SQLQuery="SELECT ng_stat.val, tpneu.cod as cpne, tpneu.nome as pneu from ng_stat, tpneu where ng_stat.ref=tpneu.cod and ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$icmd." and tpneu.lin=".$linx." order by ng_stat.val desc, tpneu.cod limit 10";
break;
}
$result = mysql_query($SQLQuery);
$seq=0;
$val=0;
while ($RSList= mysql_fetch_array($result)) {
if ($val==0 || $RSList["val"]==$val) {
$val=$RSList["val"];
$seq=$seq+1;
echo(" ");
if ($seq==1)
echo(Statnome($icmd));
echo(" | ");
ng_cref ($RSList);
if ($rng == 0)
echo(" ".$RSList["gp_nome"]." | ");
ng_val ($RSList, $icmd, $cref);
echo(" ");
} else
break;
}
}
function NGtop ()
{
global $titulo, $N_STATS, $N_GPRIS, $N_GPR, $N_TOTAL, $ng_nome, $TR1_BGC, $TR2_BGC;
global $args, $rng, $cref, $cmdStatVit, $cmdStatPol, $cmdStatVmr, $cmdStatPod, $cmdStatPli, $cmdStatPon, $cmdStatGpc, $cmdStatVoc, $cmdStatKmc;
fxhead("Forix: ".$ng_nome.", ".$titulo[$N_STATS].", Top");
if ($rng == 0)
ng_cab("$titulo[$N_GPRIS] Top");
else
ng_cab("Top");
tab_bor();
echo("");
echo("$titulo[$N_STATS] | ");
echo("".CrefNome($cref)." | ");
if ($rng == 0)
echo("$titulo[$N_GPR] | ");
echo("$titulo[$N_TOTAL] | ");
NGtop_ ($TR1_BGC, $cmdStatVit);
NGtop_ ($TR2_BGC, $cmdStatPol);
NGtop_ ($TR1_BGC, $cmdStatVmr);
NGtop_ ($TR2_BGC, $cmdStatPod);
NGtop_ ($TR1_BGC, $cmdStatPli);
NGtop_ ($TR2_BGC, $cmdStatPon);
NGtop_ ($TR1_BGC, $cmdStatGpc);
NGtop_ ($TR2_BGC, $cmdStatVoc);
NGtop_ ($TR1_BGC, $cmdStatKmc);
echo(" | ");
tab_select (0);
tab_fim();
fxtail();
}
function NGstat ()
{
global $titulo, $N_STATS, $N_GPRIS, $N_GPR, $N_TOTAL, $N_CLA, $ng_nome, $TR1_BGC, $TR2_BGC;
global $args, $lin, $linx, $seq, $rng, $cmd, $cref, $REF_PI, $REF_CO, $REF_MA, $REF_PN;
if ($rng == 0) {
fxhead("Forix: $titulo[$N_STATS]");
ng_cab("$titulo[$N_GPRIS] ".StatNome($cmd));
} else {
fxhead("Forix: $ng_nome, $titulo[$N_STATS]");
ng_cab(StatNome($cmd));
}
tab_bor();
echo("");
echo("$titulo[$N_CLA] | ");
echo("".CrefNome($cref)." | ");
if ($rng == 0)
echo("$titulo[$N_GPR] | ");
echo("$titulo[$N_TOTAL] | ");
$BGC=$TR2_BGC;
switch ($cref) {
case $REF_PI:
if ($rng == 0)
$SQLQuery="SELECT ng_stat.rng, ng_stat.val, ngn.nome as gp_nome, pin.rpi, pin.nabr as pi_nome From ng_stat, ngn, pin Where ng_stat.rng=ngn.rng and ng_stat.ref=pin.rpi and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and ngn.lin=".$lin." Order by ng_stat.val desc, pin.rpi, ngn.nome limit 30";
else
$SQLQuery="SELECT ng_stat.val, pin.rpi, pin.nabr as pi_nome From pin inner join ng_stat on ng_stat.ref=pin.rpi where ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." order by ng_stat.val desc, pin.rpi";
break;
case $REF_CO:
if ($rng == 0)
$SQLQuery="SELECT ng_stat.rng, ng_stat.val, ngn.nome as gp_nome, co.rco, can.nome as co_nome From ng_stat, ngn, co, can where ng_stat.rng=ngn.rng and ng_stat.ref=co.rco and can.rco=co.rco and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and can.lin=".$linx." and ngn.lin=".$lin." order by ng_stat.val desc, co.rco, ngn.nome limit 30";
else
$SQLQuery="SELECT ng_stat.val, co.rco, can.nome as co_nome From (co inner join ng_stat on ng_stat.ref=co.rco) inner join can on can.rco=co.rco where ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and can.lin=".$linx." order by ng_stat.val desc, co.rco";
break;
case $REF_MA:
if ($rng == 0)
$SQLQuery="SELECT ng_stat.rng, ng_stat.val, ngn.nome as gp_nome, mo.rma, mon.nome as mo_nome From ng_stat, ngn, mo, mon Where ng_stat.rng=ngn.rng and ng_stat.ref=mo.rma and mon.rma=mo.rma and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and mon.lin=".$linx." and ngn.lin=".$lin." order by ng_stat.val desc, mo.rma, ngn.nome limit 30";
else
$SQLQuery="SELECT ng_stat.val, mo.rma, mon.nome as mo_nome From (mo inner join ng_stat on ng_stat.ref=mo.rma) inner join mon on mon.rma=mo.rma where ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and mon.lin=".$linx." order by ng_stat.val desc, mo.rma";
break;
case $REF_PN:
if ($rng == 0)
$SQLQuery="SELECT ng_stat.rng, ng_stat.val, ngn.nome as gp_nome, tpneu.cod as cpne, tpneu.nome as pneu From ng_stat, ngn, tpneu Where ng_stat.rng=ngn.rng and ng_stat.ref=tpneu.cod and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and tpneu.lin=".$linx." and ngn.lin=".$lin." order by ng_stat.val desc, tpneu.cod, ngn.nome limit 30";
else
$SQLQuery="SELECT ng_stat.val, tpneu.cod as cpne, tpneu.nome as pneu From ng_stat, tpneu where ng_stat.ref=tpneu.cod and ng_stat.rng=".$rng." and ng_stat.cref=".$cref." and ng_stat.cod=".$cmd." and tpneu.lin=".$linx." order by ng_stat.val desc, tpneu.cod";
break;
}
$result = mysql_query($SQLQuery);
while ($RSList= mysql_fetch_array($result)) {
if ($BGC==$TR1_BGC) $BGC=$TR2_BGC; else $BGC=$TR1_BGC;
echo("");
include("seq.php");
ng_cref ($RSList);
if ($rng == 0)
echo(" ".$RSList["gp_nome"]." | ");
ng_val ($RSList, $cmd, $cref);
echo(" ");
}
while($seq<10) {
if ($BGC==$TR1_BGC) $BGC=$TR2_BGC; else $BGC=$TR1_BGC;
echo(" | ");
$seq++;
}
echo("
| ");
tab_select (0);
tab_fim();
fxtail();
}
function NGpia()
{
extract($GLOBALS);
fxhead("Forix: ".$ng_nome.", ".$titulo[$N_ACTI]);
$SQLQuery="SELECT truncate(rpa/1000,0) AS ano FROM epoca, papi Where epoca.rpi=papi.rpi and epoca.rpi>0 and epoca.active>0 and papi.rng=".$rng." GROUP BY truncate(rpa/1000,0), papi.rng";
$n=0;
if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0) {
while ($RSList= mysql_fetch_array($result)) {
$anos[$n]=$RSList["ano"];
$n=$n+1;
}
}
$SQLQuery="SELECT papi.*, pin.nabr as pi_nome FROM (papi INNER JOIN pin ON papi.rpi = pin.rpi) inner join epoca on epoca.rpi=papi.rpi where epoca.rpi>0 and epoca.active>0 and papi.rng=".$rng." order by pin.apel, papi.rpa";
ng_cab($titulo[$N_ACTI]);
?>[ echo $titulo[$N_YEAR]; ?>: echo $titulo[$N_GRID]; ?> / echo $titulo[$N_RACE]; ?>] |
tab_bar(4);
tab_bor();
if ($n > 0 and ($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0) {
?>
echo $titulo[$N_ASEQ]; ?> |
echo $titulo[$N_DRIVS]; ?> |
for ($ii=0; $ii<=$n-1; $ii=$ii+1)
{
?> echo intval($anos[$ii]/100)+1900; ?> |
$anos[$ii]=intval($anos[$ii]/100);
}
?>
$seq=0;
$BGC=$TR2_BGC;
$RSList= mysql_fetch_array($result);
while ($RSList)
{
if ($BGC==$TR1_BGC) $BGC=$TR2_BGC; else $BGC=$TR1_BGC;
?>
include ("seq.php");
?>
$rpi=$RSList["rpi"];
$rpia=$rpi;
$ii=0;
?> echo $RSList["pi_nome"]; ?> |
while($RSList and $rpi==$rpia)
{
$ano=intval($RSList["rpa"]/100000);
$gre=$RSList["gre"];
if ($gre<=0)
$gre="-";
$cla=$RSList["cla"];
if ($cla<=0)
$cla="-";
if ($anos[$ii]==$ano)
{
?> &c= echo $cmdPAfic; ?>"> echo $gre; ?>/ echo $cla; ?> |
$RSList= mysql_fetch_array($result);
if ($RSList)
$rpia=$RSList["rpi"];
}
else
{
?> - |
}
$ii=$ii+1;
}
while($ii<$n)
{
?> - |
$ii=$ii+1;
}
?>
}
?>
|
}
else
{
?> echo $titulo[$N_NOPA]; ?> |
}
tab_bor();
ng_menu(0);
ng_sel(0);
tab_fim();
fxtail();
}
// Global
$seq = 0;
$rpi = 0;
$rco = 0;
$rma = 0;
$rpn = 0;
$rng = intval(get_arg("r"));
$cmd = intval(get_arg("c"));
$cref = intval(get_arg("x"));
$sort = intval(get_arg("s"));
$bloc = intval(get_arg("b"));
if (post_arg("stat") > 0)
$cmd = (int)post_arg("stat");
if (post_arg("group") > 0)
$cref = (int)post_arg("group");
if ($cref == 0)
$cref = $REF_PI;
if ($cmd==999)
NGtabela();
else {
if ($rng<=0)
$rng = post_arg("rng");
if ($rng>0) {
$ng_nome= NGnome($rng);
if (strlen($ng_nome)>0) {
log_page($REF_NG,$rng,$cmd);
if ($cmd==$cmdNGgpr)
NGgpr();
else if ($cmd==$cmdNGvit)
NGvpr($titulo[$N_WINS]);
else if ($cmd==$cmdNGpol)
NGvpr($titulo[$N_POLES]);
else if ($cmd==$cmdNGvmr)
NGvpr($titulo[$N_FLAPS]);
else if ($cmd==$cmdNGpia)
NGpia();
else if ($cmd==$cmdNGtop)
NGtop();
else if ($cmd>=$cmdStat)
NGstat();
else
NGfic();
}
} else
$rng=0;
if ($rng <= 0) {
log_page($REF_NG,0,$cmd);
if ($cmd==$cmdNGtop)
NGtop();
else if ($cmd >= $cmdStat)
NGstat();
else
NGlista();
}
}
?>
|