if ($j == ( sizeof($results) - 1 ))
$limit = date("Y-m-d H:i:s", $nextReqDate);
else
$limit = $results[$j + 1];
// select all access to tool between displayed date and next displayed date or now() if
// displayed date is the last login date
$sql = "SELECT access_tool, count(access_tool)
FROM $TABLETRACK_ACCESS
WHERE access_user_id = '$uInfo'
AND access_tool IS NOT NULL
AND access_date > '" . $results[$j] . "'
AND access_date < '" . $limit . "'
AND access_cours_code = '" . $_cid . "'
GROUP BY access_tool
ORDER BY access_tool ASC";
$results2 = getManyResults2Col($sql);
if (is_array($results2)) {
echo "<tr><td colspan='2'>\n";
echo "<table width='50%' cellpadding='0' cellspacing='0' border='0'>\n";
for ($k = 0; $k < count($results2); $k++) {
echo "<tr>\n";
echo "<td width='70%' style='padding-left : 60px;'>" . get_lang($results2[$k][0]) . "</td>\n";
echo "<td width='30%' align='right' style='padding-right : 40px'>" . $results2[$k][1] . " " . get_lang('Visits') . "</td>\n";
echo "</tr>";
}
echo "</table>\n";
echo "</td></tr>\n";
}
$previousDate = $value;
}
/**
* Displays the links followed for a specific user in a specific course.
* @todo remove globals
*/
public function display_links_tracking_info($view, $user_id, $course_id)
{
global $TABLETRACK_LINKS, $TABLECOURSE_LINKS;
$line = null;
if (substr($view,3,1) == '1') {
$new_view = substr_replace($view,'0',3,1);
$title[1]=get_lang('LinksDetails');
$sql = "SELECT cl.title, cl.url
FROM $TABLETRACK_LINKS AS sl, $TABLECOURSE_LINKS AS cl
WHERE sl.links_link_id = cl.id
AND sl.links_cours_id = '$course_id'
AND sl.links_user_id = '$user_id'
GROUP BY cl.title, cl.url";
$results = getManyResults2Col($sql);
$title_line= get_lang('LinksTitleLinkColumn')."\n";
if (is_array($results)) {
for ($j = 0 ; $j < count($results) ; $j++) {
$line .= $results[$j][0]."\n";
}
} else {
$line=get_lang('NoResult');
}
} else {
$new_view = substr_replace($view,'1',3,1);
}
return array($title_line, $line);
}
