#!/usr/local/Hughes/bin/lite
$sock=msqlConnect();
if ($sock<0) {echo("ERROR : $ERRMSG\n");}
if (msqlSelectDB($sock,"tether_calls")<0) {echo("ERROR : $ERRMSG\n");}
if (msqlQuery($sock,"select user from sessions order by user")<0) {echo("ERROR :
 $ERRMSG\n");}
$res=msqlStoreResult();
$count=msqlNumRows($res);
$i = 0;
$j = 0;
$row=msqlFetchRow($res);
$name[0] = $row[0];
while ($i < $count)
      {
      $row=msqlFetchRow($res);
      $i = $i + 1;
      if ($name[$j] != $row[0])
         {
         $j = $j + 1;
         $name[$j] = $row[0];
         }
      }
msqlFreeResult($res);
$numusers=# $name;
$i=0;
$over=0;
$totcalls=0;
echo ("Name\t\tMinutes\tCalls\tAve. Call\tOvertime\tOvertime Charge\n");
while ($i < $numusers - 1)
      {
      msqlQuery($sock,"select duration from sessions where user = '$name[$i]'");
      $res=msqlStoreResult();
      $numcalls=msqlNumRows($res);
      $j=0;
      $useage=0;
      while ($j < $numcalls)
            {
            $row=msqlFetchRow($res);
            $useage = $useage+(int)$row[0];
            $j = $j + 1;
            }
      $totcalls=$totcalls+$numcalls;
      $nam=$name[$i];
      $useage = (int)($useage / 60);
      $average = (int)($useage / $numcalls);
      $overtime = 0;
      if ($useage > 6000) 
         {
         $overtime = (int)($useage - 6000.0);
         }
      $charge = ($overtime/120);
      if (# $nam < 8) { $nam = $nam + "\t";}
      if ($charge > 0) {      
        printf("%s\t%d\t%d\t%d\t\t%d\t\t%d.00\n",$nam,$useage,$numcalls,$average,$overtime,$charge);
        $over = $over + 1;
      }
      $i = $i + 1;
      }
echo ("\n");
echo ("There were $over overtime users.\n");
msqlClose($sock);