'>
';?>


0) { while($a_learnpath = mysql_fetch_array($resultLearnpath)) { $sqlProgress = "SELECT COUNT(DISTINCT lp_item_id) AS nbItem FROM ".$a_infosCours['db_name'].".".$tbl_course_lp_view_item." AS item_view INNER JOIN ".$a_infosCours['db_name'].".".$tbl_course_lp_view." AS view ON item_view.lp_view_id = view.id AND view.lp_id = ".$a_learnpath['id']." AND view.user_id = ".$_user['user_id']." WHERE item_view.status = 'completed' OR item_view.status = 'passed' "; $resultProgress = api_sql_query($sqlProgress); $a_nbItem = mysql_fetch_array($resultProgress); $sqlTotalItem = " SELECT COUNT(item_type) AS totalItem FROM ".$a_infosCours['db_name'].".".$tbl_course_lp_item." WHERE lp_id = ".$a_learnpath['id']." AND item_type != 'chapter' AND item_type != 'dokeos_chapter' AND item_type != 'dir'" ; $resultItem = api_sql_query($sqlTotalItem); $a_totalItem = mysql_fetch_array($resultItem); $progress = round(($a_nbItem['nbItem'] * 100)/$a_totalItem['totalItem']); // calculates last connection time $sql = 'SELECT MAX(start_time) FROM '.$a_infosCours['db_name'].'.'.$tbl_course_lp_view_item.' AS item_view INNER JOIN '.$a_infosCours['db_name'].'.'.$tbl_course_lp_view.' AS view ON item_view.lp_view_id = view.id AND view.lp_id = '.$a_learnpath['id'].' AND view.user_id = '.$_user['user_id']; $rs = api_sql_query($sql, __FILE__, __LINE__); $start_time = mysql_result($rs, 0, 0); // calculates time $sql = 'SELECT SUM(total_time) FROM '.$a_infosCours['db_name'].'.'.$tbl_course_lp_view_item.' AS item_view INNER JOIN '.$a_infosCours['db_name'].'.'.$tbl_course_lp_view.' AS view ON item_view.lp_view_id = view.id AND view.lp_id = '.$a_learnpath['id'].' AND view.user_id = '.$_user['user_id']; $rs = api_sql_query($sql, __FILE__, __LINE__); $total_time = mysql_result($rs, 0, 0); echo " "; } } else { echo " "; } ?> 0){ while($a_exercices = mysql_fetch_array($resuktExercices)) { $sqlEssais = " SELECT COUNT(ex.exe_id) as essais FROM $tbl_stats_exercices AS ex WHERE ex.exe_user_id='".$_user['user_id']."' AND ex.exe_cours_id = '".$a_infosCours['code']."' AND ex.exe_exo_id = ".$a_exercices['id'] ; $resultEssais = api_sql_query($sqlEssais); $a_essais = mysql_fetch_array($resultEssais); $sqlScore = "SELECT exe_id , exe_result,exe_weighting FROM $tbl_stats_exercices WHERE exe_user_id = ".$_user['user_id']." AND exe_cours_id = '".$a_infosCours['code']."' AND exe_exo_id = ".$a_exercices['id']." ORDER BY exe_date DESC LIMIT 1" ; $resultScore = api_sql_query($sqlScore); $score = 0; while($a_score = mysql_fetch_array($resultScore)) { $score = $score + $a_score['exe_result']; $weighting = $weighting + $a_score['exe_weighting']; $exe_id = $a_score['exe_id']; } $pourcentageScore = round(($score*100)/$weighting); $weighting = 0; echo " "; echo " "; } } else{ echo ''; } } else{ echo ''; } ?>
"; echo stripslashes($a_learnpath['name']); echo " "; echo api_time_to_hms($total_time); echo " "; echo $progress.'%'; echo " "; if($start_time!=''){ echo format_locale_date(get_lang('dateFormatLong'),$start_time); } else{ echo '-'; } echo "
".get_lang('NoLearnpath')."
"; echo $a_exercices['title']; echo " "; echo $pourcentageScore.'%'; echo " "; echo $a_essais['essais']; echo ' '; if($a_essais['essais']>0) echo ' '; echo "
'.get_lang('NoEx').'
'.get_lang('NoEx').'