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 />');