mods/_standard/tracker/tools/student_usage.php

   1 <?php\r
   2 /************************************************************************/\r
   3 /* ATutor                                                                                                                               */\r
   4 /************************************************************************/\r
   5 /* Copyright (c) 2002-2010                                              */\r
   6 /* Inclusive Design Institute                                           */\r
   7 /* http://atutor.ca                                                                                                             */\r
   8 /*                                                                                                                                              */\r
   9 /* This program is free software. You can redistribute it and/or        */\r
  10 /* modify it under the terms of the GNU General Public License          */\r
  11 /* as published by the Free Software Foundation.                        */\r
  12 /************************************************************************/\r
  13 // $Id$\r
  14 \r
  15 define('AT_INCLUDE_PATH', '../../../../include/');\r
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 authenticate(AT_PRIV_CONTENT);\r
  18 \r
  19 require(AT_INCLUDE_PATH.'header.inc.php');\r
  20 \r
  21 $sql    = "SELECT M.member_id, M.login, CONCAT(M.first_name, ' ', M.second_name, ' ', M.last_name) AS full_name\r
  22                         FROM ".TABLE_PREFIX."members M, ".TABLE_PREFIX."course_enrollment C \r
  23                         WHERE M.member_id=C.member_id AND C.course_id=$_SESSION[course_id]";\r
  24 $result = mysql_query($sql, $db);\r
  25 \r
  26 $_GET['id'] = intval($_GET['id']);\r
  27 \r
  28 $sql = "SELECT counter, content_id, SEC_TO_TIME(duration) AS total FROM ".TABLE_PREFIX."member_track WHERE member_id=$_GET[id] AND course_id=$_SESSION[course_id] ORDER BY counter DESC";\r
  29 $result_list = mysql_query($sql, $db);\r
  30 $savant->assign('result_list', $result_list);\r
  31 $savant->assign('result', $result);\r
  32 $savant->display('instructor/content/tracker/student_usage.tmpl.php');\r
  33 require(AT_INCLUDE_PATH.'footer.inc.php'); ?>