#!/usr/local/Hughes/bin/lite
$sock=msqlConnect();
if ($sock<0) {echo("ERROR : $ERRMSG\n");}
if (msqlSelectDB($sock,"tether_calls")<0) {echo("ERROR : $ERRMSG\n");}
msqlQuery($sock,"select user,address,login,duration,input_octets,output_octets from sessions order by login");
$res=msqlStoreResult();
$numcalls=msqlNumRows($res);
$j=0;
echo ("Username\tIP\t\tTime of call\t\tDuration\tBytes recieved\tBytes sent\n");
while ($j < $numcalls)
      {
      $row=msqlFetchRow($res);
      $user=$row[0];
      if (# $user < 8) { $user = $user + "\t";}
      $time=strftime("%D %T",(int)$row[2]);
      echo ("$user\t$row[1]\t$time\t$row[3]\t\t$row[5]\t$row[4]\n");
      $j = $j + 1;
      }
msqlFreeResult($res);
msqlClose($sock);