mods/_standard/tracker/tools/page_student_stats.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 \r
  18 authenticate(AT_PRIV_CONTENT);\r
  19 \r
  20 /* Getting content id from page that reffered */\r
  21 $content_id = intval($_GET['content_id']);\r
  22 \r
  23 $_pages['mods/_standard/tracker/tools/page_student_stats.php']['title'] = $contentManager->_menu_info[$content_id]['title'];\r
  24 $_pages['mods/_standard/tracker/tools/page_student_stats.php']['parent'] = 'mods/_standard/tracker/tools/index.php';\r
  25 \r
  26 require(AT_INCLUDE_PATH.'header.inc.php');\r
  27 \r
  28 $sql = "SELECT counter, content_id, member_id, SEC_TO_TIME(duration) AS total, SEC_TO_TIME(duration/counter) AS average FROM ".TABLE_PREFIX."member_track WHERE course_id=$_SESSION[course_id] AND content_id=$content_id ORDER BY total DESC";\r
  29 $result = mysql_query($sql, $db);\r
  30 \r
  31 $savant->assign('result', $result); \r
  32 $savant->display('instructor/content/page_student_stats.tmpl.php');\r
  33 require(AT_INCLUDE_PATH.'footer.inc.php'); ?>