1", "", "lname, fname"); while ($l = mysql_fetch_assoc($r['r'])) { $uLogIns = 0; //$uFails = 0; $uAband = 0; $uTD = 0; $uMulti = 0; $uStale = 0; $uOpen = 0; $uTtl = 0; $uLast = ""; $uDatList = sqlSelect("logins", "empNo = '".$l['empNo']."'", "", "touch desc"); while ($uDat = mysql_fetch_assoc($uDatList['r'])) { $uLogIns += 1; if (empty($uLast)) $uLast = $uDat['login']; if (strpos($uDat['locked'], "AUTOLOGOUT [A") !== false) $uAband += 1; if (strpos($uDat['locked'], "AUTO_LOG_OUT") !== false) $uAband += 1; if (strpos($uDat['locked'], "AUTOLOGOUT [S") !== false) $uStale += 1; if (strpos($uDat['locked'], "AUTOLOGOUT [M") !== false) $uMulti += 1; if ($uDat['locked'] == "") $uOpen += 1; $t = duration($uDat['login'], $uDat['touch']); $uTtl += $t['d']; if (substr($uDat['login'], 0, 8) == date("Ymd")) $uTD += 1; } if ($uLogIns) $uPerc = intval(($uAband * 100) / $uLogIns); else $uPerc = 0; $tOpen += $uOpen; $tTD += $uTD; $tAband += $uAband; // $tPerc += $uPerc; $tMulti += $uMulti; $tStale += $uStale; $tLogIns += $uLogIns; $tTtl += $uTtl; $uTtl = duration("", "", $uTtl); $uLast = formatDate($uLast); echo " \n"; echo " \n"; echo " \n"; //echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $rowCnt += 1; } while ($rowCnt < 21) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $rowCnt += 1; } $tPerc = substr("00".intval(($tAband * 100) / $tLogIns), -2); $tTtl = duration("", "", $tTtl); echo "\n"; ?>

Name	UserName	Emp	TD	Abnd	%	Stale	Multi	Total	Usage	Last
Totals			0	0	0	0	0	0	0h 00m
".$l['fName']." ".$l['lName']."	".$l['userName']."	$uOpen	".sprintf("%03d", $l['empNo'])."	$uTD	$uAband	".substr("00".$uPerc, -2)."	$uStale	$uMulti	$uLogIns	".$uTtl['h']."h ".$uTtl['m']."m	$uLast