<?php

include ("forixinc.php");
include ("util.php");



function ng_cab($ng_nome,$nome)
{
  extract($GLOBALS);

?>
<table border="0" cellspacing="0" cellpadding="0">
<TR>
<TD BGCOLOR="<?php   echo $BOR_BGC; ?>" WIDTH="1"><img src="../pic/0.gif" width="1" height="1"></TD>
<TD><table border="0" cellspacing="0" cellpadding="0">
<TR BGCOLOR="<?php   echo $BOR_BGC; ?>"><TD HEIGHT="1"><img src="../pic/0.gif" width="1" height="1"></TD></TR>
<?php   if (strlen($ng_nome)>0)
  {
?>
<TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TD HEIGHT="4"><img src="../pic/0.gif" width="1" height="1"></TD></TR>
<TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TH VALIGN="middle"><FONT SIZE="+2"><?php     echo $ng_nome; ?>&nbsp;<A HREF="__ng.asp?<?php     echo $args; ?>"><IMG SRC="../pic/lista.gif" ALT="=" ALIGN="absmiddle" BORDER="0"></A></FONT></TH></TR>
<?php   } ?>
<?php   if (strlen($nome)>0)
  {

?><TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TD HEIGHT="4"><img src="../pic/0.gif" width="1" height="1"></TD></TR>
<TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TH VALIGN="middle"><FONT SIZE="+3"><?php     echo $nome; ?></FONT></TH></TR><?php
  } ?>
<TR BGCOLOR="<?php   echo $CAB_BGC; ?>"><TD HEIGHT="4"><img src="../pic/0.gif" width="1" height="1"></TD></TR>
<TR BGCOLOR="<?php   echo $BOR_BGC; ?>"><TD HEIGHT="1"><img src="../pic/0.gif" width="1" height="1"></TD></TR>
<?php   return $function_ret;
}



function NGlista()
{
  extract($GLOBALS);


fxhead("Forix: ".$titulo[$N_RACES]);
ng_cab("",$titulo[$N_RACES]);
  $SQLQuery="Select n_gp.name as ng_nome, Count(n_gp.name) as ngp From n_gp where rgp-100*truncate(rgp/100,0) > 50 Group by n_gp.name Order by n_gp.name";
  if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
  {

?>
<TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TD ALIGN="center"><TABLE border="0" cellspacing="0" cellpadding="2"><TR>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_NAME]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_TOTAL]; ?></B></TD>
</TR><?php
    $BGC=$TR2_BGC;
    while ($RSList= mysql_fetch_array($result))
    {

      if ($BGC==$TR1_BGC)
      {

        $BGC=$TR2_BGC;
      }
        else
      {

        $BGC=$TR1_BGC;
      }

?><TR BGCOLOR="<?php       echo $BGC; ?>">
<TD ALIGN="left">&nbsp;<A HREF="__ng.asp?<?php       echo $args; ?>&r=<?php       echo str_replace(" ","+",$RSList["ng_nome"]); ?>&c=1"><?php       echo $RSList["ng_nome"]; ?></A></TD>
<TD ALIGN="right">&nbsp;<?php       echo $RSList["ngp"]; ?></TD>
</TR><?php
    }
?>
</TABLE></TD></TR>
<?php   } ?>
<TR BGCOLOR="<?php   echo $BOR_BGC; ?>"><TD HEIGHT="1"><img src="../pic/0.gif" width="1" height="1"></TD></TR></TABLE></TD>
<TD BGCOLOR="<?php   echo $BOR_BGC; ?>" WIDTH="1"><img src="../pic/0.gif" width="1" height="1"></TD>
</TR>
</TABLE>
<?php
   include ("__fxtail.php");
   return $function_ret;
}



function NGgpr()
{
  extract($GLOBALS);


fxhead("Forix: ".$ng_nome.", ".$titulo[$N_RACES]);
ng_cab($rng,$titulo[$N_RACES]);
  $SQLQuery="SELECT n_gp.*, n_gp.name as gp_name, dayofmonth(n_gp.date) as dd, month(n_gp.date) as mm, n_ci.* FROM n_ci INNER JOIN n_gp ON n_gp.circuit=n_ci.name where n_gp.name like '".$rng."' and n_gp.rgp-100*truncate(n_gp.rgp/100,0) > 50 and n_gp.rgp>=n_ci.rci and n_gp.rgp<n_ci.rci_n order by n_gp.rgp";
  if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
  {
?>
<TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TD ALIGN="center"><TABLE border="0" cellspacing="0" cellpadding="2"><TR>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_ASEQ]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_YEAR]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_DATE]; ?></B></TD>
<TD ALIGN=CENTER><B>Race</B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_CIRC]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_APER]; ?><BR>[m]</B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_ALAPS]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_DIST]; ?><BR>[km]</B></TD>
</TR><?php
    $seq=1;
    $BGC=$TR2_BGC;
    while ($RSList= mysql_fetch_array($result))
    {

      if ($BGC==$TR1_BGC)
      {

        $BGC=$TR2_BGC;
      }
        else
      {

        $BGC=$TR1_BGC;
      }

?><TR BGCOLOR="<?php       echo $BGC; ?>">
<TD ALIGN="center">&nbsp;<?php       echo $seq; ?></TD>
<TD ALIGN="center">&nbsp;<A HREF="__gp.asp?<?php       echo $args; ?>&r=<?php       echo $RSList["rgp"]; ?>&c=<?php       echo $cmdGPfic; ?>"><?php       echo intval($RSList["rgp"]/100); ?></A></TD>
<TD ALIGN="right">&nbsp;<?php       echo pri_data($RSList["dd"],$RSList["mm"],0,0); ?></TD>
<TD ALIGN="left">&nbsp;<?php       echo $RSList["fname"]; ?></TD>
<TD ALIGN="left">&nbsp;<?php       echo $RSList["circuit"]; ?></TD><?php
      $perim=$RSList["perim_mt"];
      if ($perim==0)
      {

        $perim=$RSList["perim_mi"]*1.609344;
      }

?><TD ALIGN="right">&nbsp;<?php       echo intval($perim); ?></TD>
<TD ALIGN="right">&nbsp;<?php       echo $RSList["laps"]; ?></TD>
<TD ALIGN="right">&nbsp;<?php       echo sprintf("%0.3f",$RSList["laps"]*$perim/1000); ?></TD>
</TR><?php
      $seq=$seq+1;
    }
?>
</TABLE></TD></TR>
<?php
   include ("__ng_menu.php");
   }
    else
  {
?>
<TR><TH ALIGN="center"><FONT SIZE="+2">Not available</FONT></TH></TR>
<TR BGCOLOR="<?php     echo $BOR_BGC; ?>"><TD HEIGHT="1"><img src="../pic/0.gif" width="1" height="1"></TD></TR>
<?php   }
   include ("__ng_sel.php");
 ?>
</TABLE></TD>
<TD BGCOLOR="<?php   echo $BOR_BGC; ?>" WIDTH="1"><img src="../pic/0.gif" width="1" height="1"></TD>
</TR>
</TABLE>
<?php
   include ("__fxtail.php");
   return $function_ret;
}



function NGvpr($nome)
{
  extract($GLOBALS);


fxhead("Forix: ".$ng_nome.", ".$nome);
ng_cab($rng,$nome);
  $SQLQuery="Select n_pa.*, n_pa.c_make as co_nome, n_pa.c_model as ca_nome, n_pa.e_make as mo_nome, n_pa.e_model as mo_tipo, n_gp.rgp, n_gp.name as gp_name from n_pa inner join n_gp on truncate(n_pa.rpa/1000,0)=n_gp.rgp Where n_gp.name like '".$rng."' and n_gp.rgp-100*truncate(n_gp.rgp/100,0) > 50 and ";

  if ($cmd==$cmdNGvit)
  {

    $SQLQuery=$SQLQuery."n_pa.r_cla=1";
  }

  if ($cmd==$cmdNGpol)
  {

    $SQLQuery=$SQLQuery."n_pa.g_cla=1";
  }

  if ($cmd==$cmdNGvmr)
  {

    $SQLQuery=$SQLQuery."n_pa.f_cla=1";
  }


  $SQLQuery=$SQLQuery." order by n_pa.rpa";
  if (($result = mysql_query($SQLQuery)) and mysql_num_rows($result) > 0)
  {

?>
<TR BGCOLOR="<?php     echo $CAB_BGC; ?>"><TD ALIGN="center"><TABLE width="100%" border="0" cellspacing="0" cellpadding="2"><TR>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_YEAR]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_DRIV]; ?></B></TD>
<TD ALIGN=CENTER><B><?php     echo $titulo[$N_CAEN]; ?></B></TD>
</TR><?php
    $seq=1;
    $BGC=$TR2_BGC;
    while ($RSList= mysql_fetch_array($result))
    {

      if ($BGC==$TR1_BGC)
      {

        $BGC=$TR2_BGC;
      }
        else
      {

        $BGC=$TR1_BGC;
      }

?><TR BGCOLOR="<?php       echo $BGC; ?>">
<TD ALIGN="center">&nbsp;<A HREF="__gp.asp?<?php       echo $args; ?>&r=<?php       echo intval($RSList["rpa"]/1000); ?>&c=0"><?php       echo intval($RSList["rpa"]/100000); ?></A></TD>
<TD ALIGN="left">&nbsp;&nbsp;<?php       echo $RSList["driver"]; ?>&nbsp;&nbsp;</TD>
<TD ALIGN="left">&nbsp;&nbsp;<?php       echo $RSList["co_nome"]; ?>&nbsp;<?php       echo $RSList["ca_nome"]; ?><?php       if ($RSList["co_nome"]!=$RSList["mo_nome"])
      {
?> / <?php         echo $RSList["mo_nome"]; ?><?php       } ?>&nbsp;&nbsp;</TD>
</TR><?php
    }
?>
</TABLE></TD></TR>
<?php
   include ("__ng_menu.php");
   }
   include ("__ng_sel.php");
?>
</TABLE></TD>
<TD BGCOLOR="<?php   echo $BOR_BGC; ?>" WIDTH="1"><img src="../pic/0.gif" width="1" height="1"></TD>
</TR>
</TABLE>
<?php
   include ("__fxtail.php");
   return $function_ret;
}



$rng=get_arg("r");
$cmd=intval(get_arg("c"));
$cref=intval(get_arg("o"));

if (strlen($rng)==0)
{

  $ngp=post_arg("ngp");
  if (strlen($ngp)>0)
  {

    $SQLQuery="Select n_gp.name from n_gp Where n_gp.name like '".$ngp."%'";
    if (($result = mysql_query($SQLQuery)) and ($RSList = mysql_fetch_array($result)))
    {

      $rng=$RSList["name"];
    }

  }

}

if (strlen($rng)==0)
{

  NGlista();
}
  else
{

  $ng_nome=$rng;
  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]);
  }

}

?>
