update_course_tracking.php 910 B

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