Students turning in late work will be greeted with a message.

diff --git a/detail_root.php b/detail_root.php
index 7aa78bf..cea4b02 100644 (file)
--- a/detail_root.php
+++ b/detail_root.php
@@ -5,6 +5,26 @@ include_once("header.php");
 include_once("time.php");
 include_once("user_details.php");
 
+function taunt_user()
+{
+       $taunt[0] = "No Soup For You";
+       $taunt[1] = "My Dog Ate It";
+       $taunt[2] = "Alien Invasion";
+       $taunt[3] = "Alien Abduction";
+       $taunt[4] = "Epic Fail";
+       $taunt[5] = "You Have Failed To Fail";
+       $taunt[6] = "None Shall Pass";
+       $taunt[7] = "You'll Get Nothing And Like It";
+       $taunt[8] = "Virus";
+       $taunt[9] = "Fries With That?";
+       $taunt[10] = "You're Still Here?";
+       $taunt[11] = "About Time...";
+       $rand = rand (0, 11);
+       return $taunt[$rand];
+}
+
+if(isset($_GET["user"])) { $user_sent = true; } else { $user_sent = false; }
+
 // prevents students from seeing other's work
 if($role != 0) { $_GET["user"] = $user_id; }
 
@@ -50,13 +70,15 @@ if($role == 0) {
 }
 
 /* get files / late status for this assignment */
-if($role == 0 && $_GET["user"]) {
-       if(assignment_late($_GET["user"], $_GET["sched"])) {
-               $file_count .= '<img src=gfx/tick_off.png></td>';
-       } else {
-               if(file_count($_GET["user"], $_GET["sched"])) {
-                       $file_count .= '<img src=gfx/star.png></td>';
-               } else { $file_count .= '<img src=gfx/error.png></td>'; }
+if($role == 0 ) {
+       if($user_sent) {
+               if(assignment_late($_GET["user"], $_GET["sched"])) {
+                       $file_count .= '<img src=gfx/tick_off.png></td>';
+               } else {
+                       if(file_count($_GET["user"], $_GET["sched"])) {
+                               $file_count .= '<img src=gfx/star.png></td>';
+                       } else { $file_count .= '<img src=gfx/error.png></td>'; }
+               }
        }
 
 } else {
@@ -80,36 +102,36 @@ $result = mysql_query($sql);
 
 if (!$result) { die("SQL ERROR"); }
 
-while($row = mysql_fetch_row($result))
+while($row = mysql_fetch_array($result))
 {
        $html .= '<tr>';
 
+       $html .= '<td>'.$row['sched_id'].'</td>';
+
        // assignment started?
-       if($row[11] < 0){
+       if($row['ava'] < 0){
                $html .= "<td><img src=gfx/bullet_black.png>";
                $started = false;
        } else {
                // assignment open?
-               if($row[8] > 0 || $row[10] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
+               if($row['status'] > 0 || $row['ava'] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
                $started = true;
        }
 
-
        // assignment graded?
-       if($row[12]) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
+       if($row['graded']) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
 
        $html .= $help_icon;
        $html .= $file_count."</td>";
-       $html .= '<td><a href="detail_root.php?sched='.$row[7].'">'.$row[2].'</a></td><td>'.$row[9].'</td><td>'.$row[0].'</td>';
-       $html .= '<td>'.$row[1].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td>';
+       $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'">'.$row['title'].'</a></td><td>'.$row['type_name'].'</td><td>'.$row['chapter'].'</td>';
+       $html .= '<td>'.$row['section_id'].'</td><td>'.$row['ava_date'].'</td><td>'.$row['due_date'].'</td>';
 
        if($started) {
-               $html .= '<td>'.absHumanTiming($row[6]).'</td>';
+               $html .= '<td>'.absHumanTiming($row['due_date']).'</td>';
        } else {
-               $html .= '<td>'.absHumanTiming($row[5]).'</td>';
+               $html .= '<td>'.absHumanTiming($row['ava_date']).'</td>';
        }
 
-       //$html .= '<td>'.absHumanTiming($row[6]).'</td>';
        if($role != 0 ) { $html .= '<td><a href=help_me.php?sched='.$_GET["sched"].'>'.$help_stat.'</a></td>'; }
        $html .= '</tr>';
 }
@@ -141,24 +163,38 @@ if($_GET["user"] == '' ) {
        $class_id = $row[0];
 
        /* get list of students that are in this class and generate a list of them */
-       $sql = 'select users.name, users.email, users.user_id, role from users, enrollment where (users.user_id = enrollment.user_id) and enrollment.class_id='.$class_id.' order by users.name';
-
-       //echo $sql;
+       $sql = 'select users.name, users.user_id, role from users, enrollment where (users.user_id = enrollment.user_id) and enrollment.class_id='.$class_id.' order by users.name';
 
        $result = mysql_query($sql);
 
        if (!$result) { die("SQL ERROR"); }
 
-       $student_list = '<table class="gridtable">
-       <tr>
-               <th>Role</th><th>Name</th><th>Email</th><th>Grade</th>
-       </tr>';
+       $student_list = '<table class="gridtable"><tr><th>Student</th><th>Student</th><th>Student</th><th>Student</th></tr>';
+
+       $i = 1;
+
+       $student_list .= '<tr>';
 
        while($row = mysql_fetch_array($result)) // getting list of students
        {
-               $student_list .= '<tr><td>';
-               if($row['role'] == 0) { $student_list .= '<img src="gfx/user_suit.png">'; } else { $student_list .=  '<img src="gfx/user_green.png">'; }
-               $student_list .= '</td><td>'.$row['name'].'</td><td>'.$row['email'].'<td><a href=detail_root.php?sched='.$_GET["sched"].'&user='.$row['user_id'].'>Grade</a></td></tr>';
+               $student_list .= '<td>';
+               //if(assignment_late($user_id, $_GET[$sched]) { } else { }
+
+               if(need_help($row['user_id'], $_GET['sched'])) {
+                       $student_list .= '<img src=gfx/flag_red.png>';
+               } else { $student_list .= '<img src=gfx/flag_white.png>'; }
+
+               if(assignment_late($row['user_id'], $_GET['sched'])) {
+                       $student_list .= '<img src=gfx/tick_off.png>';
+               } else {
+                       if(file_count($row['user_id'], $_GET['sched'])) {
+                               $student_list .= '<img src=gfx/star.png>';
+                       } else { $student_list .= '<img src=gfx/error.png>'; }
+               }
+               
+               //if($row['role'] == 0) { $student_list .= '<img src="gfx/user_suit.png">'; } else { $student_list .=  '<img src="gfx/user_green.png">'; }
+               $student_list .= '<a href=detail_root.php?sched='.$_GET["sched"].'&user='.$row['user_id'].'>'.$row['name'].'</a></td>';
+               if( $i == 4) { $i = 1; $student_list .= '</tr><tr>'; } else { $i++; }
        }
 
        $student_list .= '</table>';
@@ -383,7 +419,7 @@ if($row[0] == 1) { // assignment is open
 
 } else { // assignment is closed - show as a red upload box
        if($role == 0 && $user_id_role == 0 && $user_data_sent) {
-               $upload_form = '<div class="comment_box_closed"><div class="comment_box_closed_message">-20 POINTS</div>
+               $upload_form = '<div class="comment_box_closed"><div class="comment_box_closed_message">'. taunt_user().'</div>
                Upload File:<form action="upload.php?sched='.$_GET["sched"].'" method="post" enctype="multipart/form-data">
                <input type="file" name="file" size="40"><br><br>
                <input name="user" type="hidden" value='.$_GET["user"].'>
@@ -391,7 +427,7 @@ if($row[0] == 1) { // assignment is open
                <input type="submit" name="submit" value="Submit"/>
                </form></div>';
        } else if($role != 0) {
-               $upload_form = '<div class="comment_box_closed"><div class="comment_box_closed_message">-20 POINTS</div>
+               $upload_form = '<div class="comment_box_closed"><div class="comment_box_closed_message">'. taunt_user().'</div>
                        Upload File:<form action="upload.php?sched='.$_GET["sched"].'" method="post" enctype="multipart/form-data">
                        <input type="file" name="file" size="40"><br><br>
                        <input type="submit" name="submit" value="Submit"/>
@@ -434,7 +470,7 @@ if($role == 0) {
 
 <table class="gridtable">
        <tr>
-               <th>Status</th><th>Title</th><th>Type</th><th>Chapter</th><th>Section</th><th>Avalable Date</th><th>Due Date</th><th>Human Time</th>
+               <th>#</th><th>Status</th><th>Title</th><th>Type</th><th>Chapter</th><th>Section</th><th>Avalable Date</th><th>Due Date</th><th>Human Time</th>
 
                <?php if($role != 0 ) { echo "<th>Help</th>"; } ?>
        </tr>

diff --git a/header.php b/header.php
index 56005db..0045c0f 100644 (file)
--- a/header.php
+++ b/header.php
@@ -54,7 +54,9 @@ if($user_id != '') {
 </head>
 <body onload="sh_highlightDocument();">
 
-<h2><img src="gfx/bricks.png">Assignment Trapper</h2>
+<table>        <tr><td><img src="gfx/bricks.png"></td><td class="banner_header">Assignment Trapper</td></tr></table>
+
+
 <div class="header">
        <div class="menu">
                <?php echo $menu; ?>

diff --git a/index.php b/index.php
index 3da528d..9e4618c 100644 (file)
--- a/index.php
+++ b/index.php
@@ -11,7 +11,7 @@ if($role == 0) { // faculty sees list of students names and assignments
 
        //$sql = 'select sched_id, title, type_name,  chapter, section_id, ava_date, due_date, graded, NOW()-due_date as due, NOW()-ava_date as ava from schedule, types where (schedule.assign_type = types.assign_type) and sched_id = ANY (select sched_id from sched_details where fac_viewed = 0 or help_me != 0 and user_id = '.$user_id.' group by sched_id) order by due_date desc, ava_date desc, title desc, chapter desc, section_id desc';
 
-       $sql ='select sched_details.sched_id, schedule.title, schedule.chapter, schedule.section_id, sched_details.user_id, users.name, help_me, sched_details.timeposted, late from sched_details, schedule, users where (sched_details.sched_id = schedule.sched_id) and (sched_details.user_id = users.user_id) and (fac_viewed = 0 or help_me != 0) group by sched_id order by help_me desc, sched_details.timeposted limit 50';
+       $sql ='select sched_details.sched_id, schedule.title, schedule.chapter, schedule.section_id, sched_details.user_id, users.name, help_me, sched_details.timeposted, late, NOW()-due_date as due, NOW()-ava_date as ava, graded from sched_details, schedule, users where (sched_details.sched_id = schedule.sched_id) and (sched_details.user_id = users.user_id) and (fac_viewed = 0 or help_me != 0) group by sched_id order by help_me desc, sched_details.timeposted limit 50';
 
        $html = '<table class="gridtable">
                        <tr>
@@ -22,7 +22,7 @@ if($role == 0) { // faculty sees list of students names and assignments
 } else { // students see list of assignments
        //$sql = 'select sched_id, title, type_name,  chapter, section_id, graded, timeposted from schedule, types where (schedule.assign_type = types.assign_type) and sched_id = ANY (select sched_id from sched_details where user_viewed = 0 and user_id = '.$user_id.' group by sched_id) order by due_date desc, ava_date desc, title desc, chapter desc, section_id desc';
 
-       $sql ='select sched_details.sched_id, schedule.title, schedule.chapter, schedule.section_id, sched_details.user_id, users.name, help_me, sched_details.timeposted, late from sched_details, schedule, users where (sched_details.sched_id = schedule.sched_id) and (sched_details.user_id = users.user_id) and (user_viewed = 0 and sched_details.user_id = '.$user_id.') group by sched_id order by help_me desc, sched_details.timeposted limit 50';
+       $sql ='select sched_details.sched_id, schedule.title, schedule.chapter, schedule.section_id, sched_details.user_id, users.name, help_me, sched_details.timeposted,  late, NOW()-due_date as due, NOW()-ava_date as ava, graded from sched_details, schedule, users where (sched_details.sched_id = schedule.sched_id) and (sched_details.user_id = users.user_id) and (user_viewed = 0 and sched_details.user_id = '.$user_id.') group by sched_id order by help_me desc, sched_details.timeposted limit 50';
 
        $html = '<table class="gridtable">
                        <tr>
@@ -46,6 +46,10 @@ while($row = mysql_fetch_array($result))
                // assignment open?
                if($row['due'] > 0 || $row['ava'] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
 
+
+//             if($row[8] > 0 || $row[10] < 0) { $html .= "<td><img src=gfx/bullet_delete.png>"; } else { $html .= "<td><img src=gfx/bullet_add.png>"; }
+       
+
                // assignment graded?
                if($row['graded']) { $html .= "<img src=gfx/bullet_disk.png>"; } else { $html .= "<img src=gfx/bullet_wrench.png>"; }
 
@@ -53,17 +57,14 @@ while($row = mysql_fetch_array($result))
 
                $html .= $help_icon;
 
-
                if($row['late']) {
                        $html .= '<img src=gfx/tick_off.png></td>';
                } else {
-
-                       if(file_count($row[4], $row[0])) {
+                       if(file_count($row['user_id'], $row['sched_id'])) {
                                $html .= '<img src=gfx/star.png></td>';
                                } else { $html .= '<img src=gfx/error.png></td>'; }
                }
 
-
                $html .= '<td>'.$row['name'].'</td>';
 
                $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'&user='.$row['user_id'].'">'.$row['title'].'</a></td><td>'.$row['chapter'].'</td>';
@@ -89,9 +90,13 @@ while($row = mysql_fetch_array($result))
 
                $html .= $help_icon;
 
-               if(file_count($user_id, $row[0])) {
-                       $html .= '<img src=gfx/star.png></td>';
-                       } else { $html .= '<img src=gfx/error.png></td>'; }
+               if($row['late']) {
+                       $html .= '<img src=gfx/tick_off.png></td>';
+               } else {
+                       if(file_count($user_id, $row['sched_id'])) {
+                               $html .= '<img src=gfx/star.png></td>';
+                               } else { $html .= '<img src=gfx/error.png></td>'; }
+               }
 
                $html .= '<td><a href="detail_root.php?sched='.$row['sched_id'].'">'.$row['title'].'</a></td><td>'.$row['type_name'].'</td><td>'.$row['chapter'].'</td>';
 

diff --git a/legend.php b/legend.php
index fe92b5b..251bfc9 100644 (file)
--- a/legend.php
+++ b/legend.php
@@ -4,12 +4,19 @@
                <td><img src="gfx/bullet_disk.png"></td><td>Graded</td>
                <td><img src="gfx/flag_red.png"></td><td>Help Me Enabled</td>
                <td><img src="gfx/star.png"></td><td>Files Posted</td>
-               <td><img src="gfx/error.png"></td><td>No Files Posted</td>
+               
        </tr>
        <tr>
                <td><img src="gfx/bullet_delete.png"></td><td>Closed for Submission</td>
                <td><img src="gfx/bullet_wrench.png"></td><td>Ungraded</td>
                <td><img src="gfx/flag_white.png"></td><td>Help Me Disabled</td>
-               <td><img src=gfx/tick_off.png></td><td>Files Late</td>
+               <td><img src="gfx/error.png"></td><td>No Files Posted</td>
+               
+       </tr>
+       <tr>
+               <td><img src="gfx/bullet_black.png"></td><td>Not Yet Open</td>
+               <td></td><td></td>
+               <td></td><td></td>
+               <td><img src=gfx/tick_off.png></td><td>Files Posted Late</td>
        </tr>
 </table>

diff --git a/manage.php b/manage.php
index ba58309..efae3b8 100644 (file)
--- a/manage.php
+++ b/manage.php
@@ -12,32 +12,61 @@ $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $user_count = $row[0];
 
+
 $sql = 'select count(*), max(timeposted) from schedule';
 
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $assignment_count = $row[0];
-$assignment_max = $row[1];
+if($assignment_count == 0) {
+       $assignment_max = "Never";
+       $assignment_time = "Never";
+} else {
+       $assignment_max = $row[1];
+       $assignment_time = absHumanTiming($assignment_max);
+}
 
 $sql ='select count(*), max(timeposted) from comments';
 
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $comment_count = $row[0];
-$comment_max = $row[1];
+if($comment_count == 0) {
+       $comment_max = "Never";
+       $comment_time = "Never";
+} else {
+       $comment_max = $row[1];
+       $comment_time = absHumanTiming($comment_max);
+}
+
 
 $sql = 'select count(*), max(timeposted) from filecom';
 
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $filecomm_count = $row[0];
-$filecomm_max = $row[1];
+if($filecomm_count == 0) {
+       $filecomm_max = "Never";
+       $filecomm_time = "Never";
+} else {
+       $filecomm_max = $row[1];
+       $filecomm_time = absHumanTiming($filecomm_max);
+}
+
 
 $sql = 'select count(*), max(time_post) from files';
 
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $file_count = $row[0];
+if($file_count == 0) {
+       $file_max = "Never";
+       $file_time = "Never";
+} else {
+       $file_max = $row[1];
+       $file_time = absHumanTiming($file_max);
+}
+
 $file_max = $row[1];
 
 $sql = 'select count(*) from users where attempts > 100';
@@ -84,10 +113,10 @@ $std_locked = $row[0];
 <div class="col">
        <table class="gridtable">
        <tr><th>Stat</th><th>Value</th><th>Human Time</th><th>Last Updated</th></tr>
-       <tr><td>Files:</td><td><?php echo $file_count; ?></td><td><?php echo absHumanTiming($file_max); ?></td><td><?php echo $file_max; ?></td></tr>
-       <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>
-       <tr><td>Comments:</td><td><?php echo $comment_count; ?></td><td><?php echo absHumanTiming($comment_max); ?></td><td><?php echo $comment_max; ?></td></tr>
-       <tr><td>Assignments:</td><td><?php echo $assignment_count; ?></td><td><?php echo absHumanTiming($assignment_max); ?></td><td><?php echo $assignment_max; ?></td></tr>
+       <tr><td>Files:</td><td><?php echo $file_count; ?></td><td><?php echo $file_time; ?></td><td><?php echo $file_time; ?></td></tr>
+       <tr><td>File Comments:</td><td><?php echo $filecomm_count; ?></td><td><?php echo $filecomm_time; ?></td><td><?php echo $filecomm_max; ?></td></tr>
+       <tr><td>Comments:</td><td><?php echo $comment_count; ?></td><td><?php echo $comment_time; ?></td><td><?php echo $comment_max; ?></td></tr>
+       <tr><td>Assignments:</td><td><?php echo $assignment_count; ?></td><td><?php echo $assignment_time; ?></td><td><?php echo $assignment_max; ?></td></tr>
        <tr><td>Users:</td><td colspan=3><?php echo $user_count; ?></td></tr>
        <tr><td>Users Locked:</td><td colspan=3><?php echo $std_locked; ?></td></tr>
        <tr><td>Current Time:</td><td colspan=3><?php echo date("F d, Y h:i" ,time()); ?></td></tr>
@@ -103,21 +132,39 @@ $sql = 'select count(*), max(time_post) from files where user_id = '.$user_id;
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $file_count = $row[0];
-$file_max = $row[1];
+if($file_count == 0) {
+       $file_max = "Never";
+       $file_time = "Never";
+} else {
+       $file_max = $row[1];
+       $file_time = absHumanTiming($file_max);
+}
 
 $sql ='select count(*), max(timeposted) from comments where user_id = '.$user_id;
 
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $comment_count = $row[0];
-$comment_max = $row[1];
+if($comment_count == 0) {
+       $comment_max = "Never";
+       $comment_time = "Never";
+} else {
+       $comment_max = $row[1];
+       $comment_time = absHumanTiming($comment_max);
+}
 
 $sql = 'select count(*), max(timeposted) from filecom where user_id = '.$user_id;
 
 $result = mysql_query($sql);
 $row = mysql_fetch_row($result);
 $filecomm_count = $row[0];
-$filecomm_max = $row[1];
+if($filecomm_count == 0) {
+       $filecomm_max = "Never";
+       $filecomm_time = "Never";
+} else {
+       $filecomm_max = $row[1];
+       $filecomm_time = absHumanTiming($filecomm_max);
+}
 
 ?>
 <div class="col2">
@@ -134,10 +181,10 @@ $filecomm_max = $row[1];
 </div>
 <div class="col">
        <table class="gridtable">
-       <tr><th>Stat</th><th>Value</th><th>Human Time</th><th>Last Updated</th></tr>
-       <tr><td>Files:</td><td><?php echo $file_count; ?></td><td><?php echo absHumanTiming($file_max); ?></td><td><?php echo $file_max; ?></td></tr>
-       <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>
-       <tr><td>Comments:</td><td><?php echo $comment_count; ?></td><td><?php echo absHumanTiming($comment_max); ?></td><td><?php echo $comment_max; ?></td></tr>
+       <tr><th>Stat</th><th>Count</th><th>Human Time</th><th>Last Updated</th></tr>
+       <tr><td>Files:</td><td><?php echo $file_count; ?></td><td><?php echo $file_time; ?></td><td><?php echo $file_max; ?></td></tr>
+       <tr><td>File Comments:</td><td><?php echo $filecomm_count; ?></td><td><?php echo $filecomm_time; ?></td><td><?php echo $filecomm_max; ?></td></tr>
+       <tr><td>Comments:</td><td><?php echo $comment_count; ?></td><td><?php echo $comment_time; ?></td><td><?php echo $comment_max; ?></td></tr>
        </table>
 </div>
 

diff --git a/style.css b/style.css
index 7de9fd7..eccf28e 100644 (file)
--- a/style.css
+++ b/style.css
@@ -17,6 +17,11 @@ body {
        font-size: 20px;
        font-weight:bold;
 }
+.banner_header {
+       font-size: 40px;
+       font-weight:bold;
+       color: #666;
+}
 .col {
        position: relative;
        float: left;
@@ -328,5 +333,5 @@ table.gridtable td {
     float:right;
     color: #faa;
     font-weight:bold;
-    font-size: 120px;
+    font-size: 65px;
 }