/**
* Get user sessions
*
* @return array [0=>session1,1=>session2...] where session1 is an array with keys: id,score,totaltime,starttime,done,solved,attempts. First sessions are newest.
* @param object $jclicid The jclic to get sessions
* @param object $userid The user id to get sessions
*/
function jclic_get_sessions($jclicid, $userid)
{
global $CFG;
$sessions = array();
if ($rs = get_records_sql("SELECT js.*\n FROM {$CFG->prefix}jclic j, {$CFG->prefix}jclic_sessions js \n WHERE j.id=js.jclicid AND js.jclicid={$jclicid} AND js.user_id={$userid}\n ORDER BY js.session_datetime")) {
$i = 0;
foreach ($rs as $session) {
$activity = jclic_get_activity($session);
$activity->attempts = $i + 1;
$sessions[$i++] = $activity;
}
}
return $sessions;
}
/**
* Get user sessions
*
* @return array [0=>session1,1=>session2...] where session1 is an array with keys: id,score,totaltime,starttime,done,solved,attempts. First sessions are newest.
* @param object $jclicid The jclic to get sessions
* @param object $userid The user id to get sessions
*/
function jclic_get_sessions($jclicid, $userid)
{
global $CFG, $DB;
$sessions = array();
jclic_normalize_date();
$sql = "SELECT js.*\n FROM {jclic} j, {jclic_sessions} js\n WHERE j.id=js.jclicid AND js.jclicid=? AND js.user_id=?\n ORDER BY js.session_datetime";
$params = array($jclicid, $userid);
if ($rs = $DB->get_records_sql($sql, $params)) {
$i = 0;
foreach ($rs as $session) {
$activity = jclic_get_activity($session);
$activity->attempts = $i + 1;
$sessions[$i++] = $activity;
}
}
return $sessions;
}
