manage.php

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