if (db_check_larare($_SESSION['sendMe']['id'])) { // lärar-view ?> <h2>Att rätta</h2> <?php $sql = "SELECT id, namn FROM kurs WHERE skapad_av='" . $_SESSION['sendMe']['id'] . "' ORDER BY namn"; $q = mysql_query($sql); if (mysql_num_rows($q) > 0) { echo "<table border=1 style='width: 100%'>\n"; while ($r = mysql_fetch_array($q)) { echo "<tr><th colspan='6' style='width: 100%; background-color: #ccc; text-align: left'><strong>" . $r['namn'] . "</strong></th></tr>"; $s = "SELECT * FROM uppgifter WHERE kurs_id='" . $r['id'] . "' AND rattad='0' ORDER BY inlamnad DESC"; $qu = mysql_query($s); while ($row = mysql_fetch_array($qu)) { $file_url = $row['inlamnad'] . "-" . $row['name_orig']; printf("<tr><td><img src='icons/%s.gif' style='width: 20px'/></td><td><a href='showfile.php?file=%s'>%s</a></td><td>%s</td><td>%s</td><td>%s</td><td align='right'><a href='getfile.php?file=%s'><img src='icons/download.gif' title='H�mta' alt='H�mta' style='border: 0; width: 20px' /></a></td></tr>", file_to_icon($row['file_type']), $file_url, $row['name_orig'], db_get_user_name($row['user_id']), show_filesize($row['file_size']), show_date($row['inlamnad']), $file_url); } } echo "</table>\n"; } else { echo "<p>Du har inga kurser upplagda än.</p>"; } ?> <?php } else { // elev-view ?> <h2>Dina inlämnade uppgifter</h2> <h2>Dina rättade uppgifter</h2>
// lagra $update_sql = "UPDATE uppgifter SET rattad='1', rattad_av='" . $_SESSION['sendMe']['id'] . "', betyg='" . $grade . "' WHERE id='{$uid}'"; $update_query = mysql_query($update_sql); $insert_sql = sprintf("INSERT INTO kommentar(uppgift_id, kommentar, tid, kommentar_av) VALUES('%s','%s','%s','%s')", $uid, $comments, time(), $_SESSION['sendMe']['id']); $insert_query = mysql_query($insert_sql); $message = "Din kommentar och ditt omdöme registerades."; unset($_POST); } } require 'top.php'; $sql = "SELECT id, user_id, name_orig, inlamnad, rattad, rattad_av, kurs_id FROM uppgifter WHERE name_orig='{$name}' AND inlamnad='{$time}' LIMIT 1"; $q = mysql_query($sql); if (mysql_num_rows($q) == 1) { $r = mysql_fetch_array($q); $kurs = db_get_course_name(stripslashes($r['kurs_id'])); $user = db_get_user_name(stripslashes($r['user_id'])); $filnamn = stripslashes($r['name_orig']); $inlamnad = show_date(stripslashes($r['inlamnad'])); $rattad = stripslashes($r['rattad']); $rattad_av = stripslashes($r['rattad_av']); ?> <table> <tr><td>Kurs:</td><td><?php echo $kurs; ?> </td><td>Användare:</td><td><?php echo $user; ?> </td></tr> <tr><td>Filnamn:</td><td><?php echo $filnamn;
function table_att_ratta($id) { $ret = ""; $id = db_clean($id); $sql = "SELECT id, namn FROM kurs WHERE skapad_av='" . $id . "' AND active='1' ORDER BY namn"; $q = mysql_query($sql); if (mysql_num_rows($q) > 0) { $ret .= "<table border=0 style='width: 100%'>\n"; while ($r = mysql_fetch_array($q)) { $s = "SELECT * FROM uppgifter WHERE kurs_id='" . $r['id'] . "' AND rattad='0' ORDER BY inlamnad DESC"; $qu = mysql_query($s); if (mysql_num_rows($qu) > 0) { $ret .= "<tr><th colspan='6' style='width: 100%; background-color: #ccc; text-align: left'><strong>" . $r['namn'] . "</strong></th></tr>"; while ($row = mysql_fetch_array($qu)) { $file_url = $row['inlamnad'] . "-" . $row['name_orig']; $ret .= sprintf("<tr><td><img src='icons/%s.gif' style='width: 20px'/></td><td><a href='showfile.php?file=%s'>%s</a></td><td>%s</td><td class='right'>%s</td><td class='right'>%s</td><td class='right'><a href='getfile.php?file=%s'><img src='icons/download.gif' title='Hämta' alt='Hämta' style='border: 0; width: 20px' /></a></td></tr>", file_to_icon($row['file_type']), $file_url, $row['name_orig'], db_get_user_name($row['user_id']), show_filesize($row['file_size']), show_date($row['inlamnad']), $file_url); } } } $ret .= "</table>\n"; } else { $ret .= "<p>Du har inga kurser upplagda än.</p>"; } return $ret; }