mods/_standard/basiclti/index_instructor.php

   1 <?php
   2 define('AT_INCLUDE_PATH', '../../../include/');
   3 require (AT_INCLUDE_PATH.'vitals.inc.php');
   4 authenticate(AT_PRIV_BASICLTI);
   5
   6 if ( !is_int($_SESSION['course_id']) || $_SESSION['course_id'] < 1 ) {
   7     $msg->addFeedback('NEED_COURSE_ID');
   8     exit;
   9 }
  10
  11 if (isset($_GET['view'], $_GET['id'])) {
  12     header('Location: tool/instructor_view.php?id='.$_GET['id']);
  13     exit;
  14 } else if (isset($_GET['edit'], $_GET['id'])) {
  15     header('Location: tool/instructor_edit.php?id='.$_GET['id']);
  16     exit;
  17 } else if (isset($_GET['delete'], $_GET['id'])) {
  18     header('Location: tool/instructor_delete.php?id='.$_GET['id']);
  19     exit;
  20 }  else if ($_GET['delete'] ||$_GET['edit'] || $_GET['view'] && !isset($_GET['id'])){
  21         $msg->addError("NO_ITEM_SELECTED");
  22 }
  23
  24 require (AT_INCLUDE_PATH.'header.inc.php');
  25
  26 $sql = "SELECT t.id AS id,t.title AS title,t.toolid AS toolid,
  27                t.description AS description, COUNT(c.id) AS cnt
  28         FROM ".TABLE_PREFIX."basiclti_tools AS t
  29         LEFT OUTER JOIN ".TABLE_PREFIX."basiclti_content as c
  30         ON t.toolid = c.toolid
  31         WHERE t.course_id = ".$_SESSION['course_id']." GROUP BY t.toolid ORDER BY t.title";
  32 $result = mysql_query($sql, $db) or die(mysql_error());
  33 ?>
  34 <form name="form" method="get" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  35 <table class="data static" summary="" rules="all">
  36         <thead>
  37                 <th>&nbsp;</th>
  38                 <th><?php echo _AT('bl_title'); ?></th>
  39                 <th><?php echo _AT('bl_toolid'); ?></th>
  40                 <th><?php echo _AT('bl_description'); ?></th>
  41                 <th><?php echo _AT('bl_count'); ?></th>
  42         </thead>
  43         <tfoot>
  44                 <tr>
  45                 <td colspan="5"><input type="submit" name="view" value="<?php echo _AT('view'); ?>" />
  46                     <input type="submit" name="edit" value="<?php echo _AT('edit'); ?>" />
  47                     <input type="submit" name="delete" value="<?php echo _AT('delete'); ?>" /></td>
  48                 </tr>
  49         </tfoot>
  50         <tbody>
  51                 <?php while($row = mysql_fetch_array($result)) { ?><tr>
  52                 <td><input type="radio" name="id" value="<?php echo $row['id']; ?>" id="m<?php echo $row['id']; ?>" /></td>
  53                 <td><label for="m<?php echo $row['id']; ?>"><?php echo $row['title']; ?></label></td>
  54                 <td><?php echo $row['toolid']; ?></td>
  55                 <td><?php echo $row['description']; ?></td>
  56                 <td><?php echo $row['cnt']; ?></td>
  57                 </tr> <?php } ?>
  58         </tbody>
  59 </table>
  60 </form>
  61 <?php
  62 include(AT_INCLUDE_PATH.'footer.inc.php');
  63 ?>