There was an error. Please try again."); if(!isset($_SESSION["id"]) || (!in_array ($_SESSION["username"], $adminuser))) { unset($_POST); unset($_SESSION); header("Location: index.php"); } include("header.inc"); $link = @mysqli_connect("$dbhost", "$dbuser", "$dbpasswd", "$db"); #$db_selected = @mysqli_select_db("$db", $link); $sql = "select uid,sum(quota) from quotas group by uid order by uid"; $result = mysqli_query($link, $sql); $i = 0; $total = 0; while($row = mysqli_fetch_row($result)) { $row[0] = strtolower($row[0]); $quota["$row[0]"] = $row[1]; $i++; } echo mysqli_error($link); $sql = "select uid,sum(pages) from jobs group by uid order by sum(pages) desc"; $result = mysqli_query($link, $sql); echo mysqli_error($link); $date = date("Y-m-d",time()); echo "Printing Summary

Summary for $date

"; while($row = @mysqli_fetch_row($result)) { $uid = $row[0]; print "
UIDPagesQuota
$uid$row[1]$quota[$uid]\n"; $total = $total + $row[1]; } print "
\n"; $avg = round($total / $i); print "$i users printed a total of $total pages (~$avg pages per user).\n"; include("footer.inc"); ?>