function peoplebyuname()
{
$cloud = mysql_query("SELECT per_id, uname, fname, lname, street, city, province, postal, email, created FROM tbl_people WHERE active='Y' ORDER BY uname") or die(mysql_error());
$num_rows = mysql_num_rows($cloud);
printf('<br /><br />There are currently ' . $num_rows . ' active accounts.');
while ($arr = mysql_fetch_assoc($cloud)) {
$perid = $arr['per_id'];
$reviewer = authname($arr['per_id']);
printf('
<div id="account">
<table>
<tr><td>Username:</td><td>' . $arr['uname'] . '</td><td></td></tr>
<tr><td>Account #:</td><td>' . $perid . '</td><td></td></tr>
<tr><td>Name:</td><td><a href="viewauthor.php?perid=' . $perid . '">' . $reviewer . '</a></td><td></td></tr>
<tr><td>Address:</td><td>' . $arr['street'] . '</td><td></td></tr>
<tr><td></td></tr></td><td>' . $arr['city'] . ', ' . $arr['province'] . '</td><td></td></tr>
<tr><td></td></tr></td><td>' . $arr['postal'] . '</td><td></td></tr>
<tr><td>Email:</td><td>' . $arr['email'] . '</td><td></td></tr>
<tr><td>Date created:</td><td>' . $arr['created'] . '</td><td></td></tr>');
printf('</table></div>');
}
}
printf('Only editors may view this page.');
printf('<script type="text/javascript">
location.replace("author.php");
</script>');
}
if ($_SESSION['role_id'] == 2) {
printf('Only editors may view this page.');
printf('<script type="text/javascript">
location.replace("reviewer.php");
</script>');
}
$manid = $_GET['manid'];
$cloud = mysql_query("SELECT title_orig, title_published, datestatus, SASE, active, disp_id, let_id, genre, notes, stat_id, per_id, datesubmitted FROM tbl_manuscript WHERE man_id={$manid}") or die(mysql_error());
$arr = mysql_fetch_assoc($cloud);
$perid = $arr['per_id'];
$author = authname($perid);
printf('
<span class="manuscript">
<table>
<tr><td>Manuscript ref #:</td><td>' . $manid . '</td><td></td></tr>
<tr><td>Author:</td><td><a href="viewauthor.php?perid=' . $perid . '">' . $author . '</a></td><td></td></tr>
<tr><td>Title:</td><td>' . $arr['title_orig'] . '</td><td></td></tr>
<tr><td>Genre:</td><td>' . $arr['genre'] . '</td><td></td></tr>
<tr><td>Author Note:</td><td>' . $arr['notes'] . '</td><td></td></tr>
<tr><td>Date submitted: </td><td>' . $arr['datesubmitted'] . '</td><td></td></tr>');
getfileinfoedit($manid);
printf('</span>');
printf('<span class="manuside">');
if ($arr['active'] == 'Y') {
printf('Active <span class="note"><a href="deactivate.php?manid=' . $manid . '&active=N">(Make Inactive)</a></span><br /><br />');
