/**
 * Returns a string to display in the tracking frame within the contents.php page (for example)
 * @param   integer     Learnpath id
 * @param   integer     Current user id
 * @param   integer     Starting chapter id
 * @param   array       Tree of elements as returned by get_learnpath_tree()
 * @param   integer     Level of recursivity we have reached
 * @param   integer     Counter of elements already displayed
 * @author  Yannick Warnier <*****@*****.**>
 * @deprecated this function seems to be unused
 * @note : forced display because of display_addedresource_link_in_learnpath behaviour (outputing a string would be better)
 */
function get_tracking_table($learnpath_id, $user_id, $parent_item_id = 0, $tree = false, $level = 0, $counter = 0)
{
    $tbl_learnpath_chapter = Database::get_course_learnpath_chapter_table();
    $tbl_learnpath_item = Database::get_course_learnpath_item_table();
    $tbl_learnpath_user = Database::get_course_learnpath_user_table();
    //$mytable = '';
    $include_chapters = true;
    if (!is_array($tree)) {
        // Get a tree of the current learnpath elements.
        $tree = get_learnpath_tree($learnpath_id);
    }
    foreach ($tree[$parent_item_id] as $order => $elem) {
        if ($counter % 2 == 0) {
            $oddclass = 'row_odd';
        } else {
            $oddclass = 'row_even';
        }
        if ($elem['type'] == 'chapter') {
            if ($include_chapters === true) {
                //$mytable .= "<tr class='$oddclass'><td colspan = '3'>".str_repeat('&nbsp;',$level*2+2).$elem['chapter_name']."</td></tr>\n";
                echo "<tr class='{$oddclass}'><td colspan = '3'>" . str_repeat('&nbsp;', $level * 2 + 2) . $elem['chapter_name'] . "</td></tr>\n";
            }
            $counter++;
            //$mytable .= get_tracking_table($learnpath_id, $user_id, $elem['id'], $tree, $level + 1, $counter );
            get_tracking_table($learnpath_id, $user_id, $elem['id'], $tree, $level + 1, $counter);
        } elseif ($elem['type'] == 'item') {
            $sql = "SELECT * FROM {$tbl_learnpath_user} " . "WHERE user_id = {$user_id} " . "AND lp_id = {$learnpath_id} " . "AND learnpath_item_id = " . $elem['id'];
            $res = Database::query($sql);
            $myrow = Database::fetch_array($res);
            if ($myrow['status'] == 'completed' || $myrow['status'] == 'passed') {
                $color = 'blue';
                $statusmessage = get_lang('Complete');
            } else {
                $color = 'black';
                $statusmessage = get_lang('Incomplete');
            }
            $link = get_addedresource_link_in_learnpath($elem['item_type'], $elem['id'], $elem['item_id']);
            //$link = display_addedresource_link_in_learnpath($elem['item_type'], $elem['id'], $row['status'], $elem['item_id'], 'player', 'none');
            //$mytable .= "<tr class='$oddclass'>"
            echo "<tr class='{$oddclass}'>" . "<td class='mystatus'>" . str_repeat("&nbsp;", $level * 2 + 2);
            //."<a href='$link?SQMSESSID=36812c2dea7d8d6e708d5e6a2f09b0b9' target='toc'>hop</a>"
            display_addedresource_link_in_learnpath($elem['item_type'], $elem['ref'], $myrow['status'], $elem['id'], 'player', 'wrap');
            //we should also add the total score here
            echo "<td>" . "<font color='{$color}'><div class='mystatus'>" . $statusmessage . "</div></font>" . "</td>" . "<td>" . "<div class='mystatus' align='center'>" . ($myrow['score'] == 0 ? '-' : $myrow['score']) . "</div>" . "</td>" . "</tr>\n";
            $counter++;
        }
    }
    //return $mytable;
    return true;
}