getAccessLevel($lid); //create table PendingQueue(PID int, UID int, LID int, timestamp timestamp, ipaddress char(20), path char(255), type int, data mediumblob); if (!isset($_POST['viewPID']) && !isset($_POST['acceptPID']) && !isset($_POST['rejectPID'])) { ?> Queue
getACLArray()); for($i = 0; $i < count($lids); $i++) { $showedSomething = 1; $lid = $lids[ $i ]; $langName = Language::lookupName($lid); $accessLevel = $loggedInUser->getAccessLevel($lid); $clause = ''; if ($accessLevel == ACLs::$ACL_ACCESS_ADMIN_HIGH) { $clause = "(type=0 OR type=1)"; } else if ($accessLevel == ACLs::$ACL_ACCESS_ADMIN_LOW) { $clause = "type=1"; } else { die("Internal error!"); } echo 'Pending queue for ' . $langName . ':

'; $result = mysql_query("SELECT PendingQueue.*,username FROM PendingQueue,VerifiedUsers WHERE LID=" . $lid . " AND PendingQueue.UID=VerifiedUsers.UID AND " . $clause, $db); if (!$result) die("Error while retrieving from pending queue!"); if (mysql_affected_rows($db) == 0) { echo "
Queue for $langName is empty.

"; } else { echo ''; echo ''; while($row = mysql_fetch_assoc($result)) { $type = $row['type']; if ($type == 0) $type = "New translation"; else if ($type == 1) $type = "Correction"; $pid = $row['PID']; echo ""; } echo '
UsernameFileTimestampIP AddressType 
" . $row['username'] . "" . $row['path'] . "" . $row['timestamp'] . "" . $row['ipaddress'] . "" . $type . "
'; } echo '


'; } if ($showedSomething == 0) { print "Welcome to Litgloss."; } ?>
View submission
Submitted by: ()
Time:
IP Address: