manage.php

   1 <?php
   2
   3 include_once("auth.php");
   4 include_once("header.php");
   5 include_once("time.php");
   6
   7 if($role==0) {
   8
   9 $sql = 'select count(*) from users';
  10
  11 $result = mysql_query($sql);
  12 $row = mysql_fetch_row($result);
  13 $user_count = $row[0];
  14
  15 $sql = 'select count(*), max(timeposted) from schedule';
  16
  17 $result = mysql_query($sql);
  18 $row = mysql_fetch_row($result);
  19 $assignment_count = $row[0];
  20 $assignment_max = $row[1];
  21
  22 $sql ='select count(*), max(timeposted) from comments';
  23
  24 $result = mysql_query($sql);
  25 $row = mysql_fetch_row($result);
  26 $comment_count = $row[0];
  27 $comment_max = $row[1];
  28
  29 $sql = 'select count(*), max(timeposted) from filecom';
  30
  31 $result = mysql_query($sql);
  32 $row = mysql_fetch_row($result);
  33 $filecomm_count = $row[0];
  34 $filecomm_max = $row[1];
  35
  36 $sql = 'select count(*), max(time_post) from files';
  37
  38 $result = mysql_query($sql);
  39 $row = mysql_fetch_row($result);
  40 $file_count = $row[0];
  41 $file_max = $row[1];
  42
  43 $sql = 'select count(*) from users where attempts > 100';
  44
  45 $result = mysql_query($sql);
  46 $row = mysql_fetch_row($result);
  47 $std_locked = $row[0];
  48
  49                         // ADIMINISTRATOR MENU
  50 ?>
  51 <div class="col2">
  52
  53         <table>
  54                 <tr><td><img src="gfx/rss.png"></td><td class="link_header">Feeds</td></tr>
  55                 <tr><td></td><td><a href="comment_feed.php">Full Comments</a></td></tr>
  56                 <tr><td></td><td><a href="assignment_feed.php">Assignments Modified</a></td></tr>
  57         </table>
  58         <br><br>
  59         <table>
  60                 <tr><td><img src="gfx/report.png"></td><td class="link_header">Assignments</td></tr>
  61                 <tr><td></td><td><a href="assignment_add.php">Add New Assignment</a></td></tr>
  62         </table>
  63         <br><br>
  64         <table>
  65                 <tr><td><img src="gfx/user_female.png"></td><td class="link_header">Users</td></tr>
  66                 <tr><td></td><td><a href="enrollment.php">Enrollment Manager</a></td></tr>
  67                 <tr><td></td><td><a href="enrollment_new.php">New Enrollment</a></td></tr>
  68                 <tr><td></td><td><a href="password_change.php">Change Personal Password</a></td></tr>
  69                 <tr><td></td><td><a href="password_change_user.php">Change User Password</a></td></tr>
  70         </table>
  71         <br><br>
  72         <table>
  73                 <tr><td><img src="gfx/cog.png"></td><td class="link_header">Workflows</td></tr>
  74                 <tr><td></td><td><a href="index.php">Comments From Students</a></td></tr>
  75                 <tr><td></td><td><a href="workflow_comments.php">Most Recent Comments</a></td></tr>
  76                 <tr><td></td><td><a href="workflow_ungraded.php">Assignments Ready For Grading</a></td></tr>
  77         </table>
  78         <br><br>
  79         <table>
  80                 <tr><td><img src="gfx/database.png"></td><td class="link_header">System Admin</td></tr>
  81                 <tr><td></td><td><a href="adminer.php">SQL Admin</a></td></tr>
  82         </table>
  83 </div>
  84 <div class="col">
  85         <table class="gridtable">
  86         <tr><th>Stat</th><th>Value</th><th>Human Time</th><th>Last Updated</th></tr>
  87         <tr><td>Files:</td><td><?php echo $file_count; ?></td><td><?php echo absHumanTiming($file_max); ?></td><td><?php echo $file_max; ?></td></tr>
  88         <tr><td>File Comments:</td><td><?php echo $filecomm_count; ?></td><td><?php echo absHumanTiming($filecomm_max); ?></td><td><?php echo $filecomm_max; ?></td></tr>
  89         <tr><td>Comments:</td><td><?php echo $comment_count; ?></td><td><?php echo absHumanTiming($comment_max); ?></td><td><?php echo $comment_max; ?></td></tr>
  90         <tr><td>Assignments:</td><td><?php echo $assignment_count; ?></td><td><?php echo absHumanTiming($assignment_max); ?></td><td><?php echo $assignment_max; ?></td></tr>
  91         <tr><td>Users:</td><td colspan=3><?php echo $user_count; ?></td></tr>
  92         <tr><td>Users Locked:</td><td colspan=3><?php echo $std_locked; ?></td></tr>
  93         <tr><td>Current Time:</td><td colspan=3><?php echo date("F d, Y h:i" ,time()); ?></td></tr>
  94         </table>
  95 </div>
  96 <?php
  97
  98 } else {                // STUDENT MENU
  99
 100 ?>
 101                         <h3>Feeds:</h3>
 102
 103                         <img src="gfx/rss.png"><a href="comment_feed.php">Full Comments</a><br>
 104                         <img src="gfx/rss.png"><a href="assignment_feed.php">Assignments Modified</a>
 105
 106                         <h3>Links:</h3>
 107                         <a href="password_change.php">Change Password</a><br>
 108
 109
 110 <?php } ?>