update_course_tracking.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. $noajax=true;
  3. include("global.inc.php");
  4. require('common_course_tracking.ajax.php');
  5. function updateCourseTracking($i_user_id){
  6. global $_configuration;
  7. $objResponse = new xajaxResponse();
  8. if($_configuration['tracking_enabled'] && !isset($_SESSION['login_as']))
  9. {
  10. $course_tracking_table = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);
  11. //We select the last record for the current course in the course tracking table
  12. $sql="SELECT course_access_id FROM $course_tracking_table WHERE user_id='$i_user_id' ORDER BY login_course_date DESC LIMIT 0,1";
  13. $result=api_sql_query($sql,__FILE__,__LINE__);
  14. $i_course_access_id = mysql_result($result,0,0);
  15. //We update the course tracking table
  16. $sql="UPDATE $course_tracking_table " .
  17. "SET logout_course_date = NOW() " .
  18. "WHERE course_access_id='$i_course_access_id'";
  19. api_sql_query($sql,__FILE__,__LINE__);
  20. }
  21. return $objResponse;
  22. }
  23. $xajax_course_tracking->processRequests();
  24. ?>