# Print Release System # (c) 2009 Toby Norden and Steven Brewer include("config.php"); session_start() or die("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); $uid = $_POST["uid"]; ?>
if($uid) { $quota = 0; # calculate remaining pages $sql = "SELECT sum(quota) FROM quotas where uid='$uid' GROUP BY uid"; $result = mysqli_query($link, $sql); if ($row = mysqli_fetch_row($result)) { # got quota $quota = $row[0]; } else { # set quota #$time = time(); #$sql = "insert into quotas () values ('','$uid',$initial_quota,'$time','gift','Initial Quota')"; #$result = mysqli_query($sql); } $sql = "SELECT SUM(pages) FROM jobs where uid='$uid' GROUP BY uid"; $result = mysqli_query($link, $sql); $row = mysqli_fetch_row($result); $printed = $row[0]; if(!($printed > 0)) { $printed = 0; } $remaining_pages = $quota - $printed; echo "
$uid has used $printed of $quota leaving $remaining_pages pages remaining. \n"; if($quota==0) { echo "
Is that uid really correct?\n"; } ?>
qid | uid | quota | time | transaction | comment |
---|---|---|---|---|---|
$row[0] | $row[1] | $row[2] | $stamp | $row[4] | $row[5] |
jid | time | uid | pages |
---|---|---|---|
$row[0] | $stamp | $row[2] | $row[3] |