2 /****************************************************************/
4 /****************************************************************/
5 /* Copyright (c) 2002-2010 */
6 /* Inclusive Design Institute */
9 /* This program is free software. You can redistribute it and/or*/
10 /* modify it under the terms of the GNU General Public License */
11 /* as published by the Free Software Foundation. */
12 /****************************************************************/
13 /////////////////////////////
14 //Display the g_data bar chart for the member selected
15 //get the translations to the gdata numbers first
16 if (!defined('AT_INCLUDE_PATH')) { exit; }
18 // NOTE: this script should not be altered. its use will soon be deprecated.
21 $sql5 = "select * from ".TABLE_PREFIX."g_refs";
22 $result = mysql_query($sql5, $db);
24 while ($row= mysql_fetch_array($result)) {
25 $refs[$row['g_id']] = $row['reference'];
27 /* this if-statement doesn't make any sense: */
28 if ($_GET['member_id']){
29 $this_member = $_GET['member_id'];
31 $this_member=$_SESSION['member_id'];
32 if(!authenticate(AT_PRIV_ADMIN, AT_PRIV_RETURN)){
33 $_GET['member_id'] = $_SESSION['member_id'];
37 $sql2 = "SELECT g, count(*) AS cnt
38 FROM ".TABLE_PREFIX."g_click_data
39 WHERE member_id=$this_member AND course_id='$_SESSION[course_id]'
43 if ($result7 = mysql_query($sql2, $db)) {
44 while($row2 = mysql_fetch_array($result7)) {
45 $nav_total = ($nav_total + $row2["cnt"]);
49 if (($result = mysql_query($sql2, $db)) && $_GET['member_id']) {
50 echo '<h3>'._AT('nav_tendencies').' '.$this_user[$this_member].'</h3>';
52 echo '<table class="data static" rules="cols" summary="">';
55 echo '<th>' . _AT('access_method') . '</th>';
56 echo '<th>' . _AT('count') . '</th>';
61 while($row = mysql_fetch_array($result)){
64 foreach($refs AS $key => $value){
71 echo '<td><img src="images/bar.gif" height="12" width="'.((($row["cnt"]/$nav_total)*100)*3).'" alt="" />' . $row["cnt"] . '</td>';
79 ////////////////////////////
80 //Show the member's click path
81 echo '<a name="access"></a>';
82 echo '<h3>'._AT('nav_path').' '.$this_user[$this_member].'</h3>';
83 echo '<table class="data static" rules="cols" summary="">';
86 echo '<th>' . _AT('access_method') . '</th>';
87 echo '<th>' . _AT('page_viewed') . '</th>';
88 echo '<th>' . _AT('duration') . '</th>';
89 echo '<th>' . _AT('date') . '</th>';
93 if (authenticate(AT_PRIV_ADMIN, AT_PRIV_RETURN)) {
94 $sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."g_click_data WHERE course_id=$_SESSION[course_id] AND member_id='$_GET[member_id]'";
97 $sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."g_click_data WHERE course_id=$_SESSION[course_id] AND member_id='$_SESSION[member_id]'";
100 //create the paginator
101 if (!$result = mysql_query($sql, $db)) {
102 echo _AT('page_error');
104 $num_rows = mysql_fetch_assoc($result);
107 ".TABLE_PREFIX."content.title,
108 ".TABLE_PREFIX."content.content_id,
109 ".TABLE_PREFIX."g_click_data.to_cid,
110 ".TABLE_PREFIX."g_click_data.g,
111 ".TABLE_PREFIX."g_click_data.duration,
112 ".TABLE_PREFIX."g_click_data.timestamp AS t
114 ".TABLE_PREFIX."content,
115 ".TABLE_PREFIX."g_click_data
117 ".TABLE_PREFIX."content.content_id=".TABLE_PREFIX."g_click_data.to_cid
119 ".TABLE_PREFIX."g_click_data.member_id=$this_member
121 ".TABLE_PREFIX."g_click_data.course_id=$_SESSION[course_id]";
124 ".TABLE_PREFIX."g_click_data.g,
125 ".TABLE_PREFIX."g_click_data.member_id,
126 ".TABLE_PREFIX."g_click_data.to_cid,
127 ".TABLE_PREFIX."g_click_data.duration,
128 ".TABLE_PREFIX."g_click_data.timestamp AS t
130 ".TABLE_PREFIX."g_click_data
132 ".TABLE_PREFIX."g_click_data.to_cid=0
134 ".TABLE_PREFIX."g_click_data.member_id=$this_member
136 ".TABLE_PREFIX."g_click_data.course_id=$_SESSION[course_id]
140 if ($result=mysql_query($sql3, $db)) {
141 while($row=mysql_fetch_assoc($result)){
142 $this_data[$row['t']]= $row;
146 //$num_records = count($this_data);
147 if ($result2 = mysql_query($sql4, $db)) {
148 while ($row=mysql_fetch_assoc($result2)) {
149 $row['title'] = $refs[$row['g']];
150 $this_data[$row['t']] = $row;
155 $num_records = ($num_records+count($this_data));
156 //$num_records = $num_rows['cnt'];
159 if (!$_GET['page']) {
162 $page = intval($_GET['page']);
164 $start = ($page-1)*$num_per_page;
165 $num_pages = ceil($num_records/$num_per_page);
168 echo '<td>'._AT('page').': ';
169 for ($i=1; $i<=$num_pages; $i++) {
173 echo '<a href="' . $_SERVER['PHP_SELF'] . '?coverage=raw' . SEP . 'member_id=' . $_GET["member_id"] . SEP . 'page=' . $i . '#access">' . $i . '</a>';
177 echo ' <span class="spacer">|</span> ';
186 $current = current($this_data);
187 $pre_time = $current[t];
189 foreach ($this_data AS $key => $value) {
191 if ($q >= $start && $q < ($start+$num_per_page)) {
192 $diff = $value['duration']; // - $pre_time);
193 $that_g = $refs[$value['g']];
197 if ($that_g == _AT('g_session_start')) {
207 if ($that_g == _AT('g_session_start')) {
213 if (substr($value['title'], 0 ,2) == "g_" ) {
214 echo _AT($value['title']);
217 echo $value['title'];
221 if ($that_g == _AT('g_session_start')) {
232 $this_time=date('i:s', $diff);
234 $session_time=($session_time+$diff);
236 $remainder = $diff / 60;
239 if ($that_g == _AT('g_session_start')) {
252 $that_date=date("M-j-y g:i:s:a", $value[t]);
253 $that_g=$refs[$value['g']];
254 $that_title=$value['title']." ";
255 $pre_time = $value['t'];
262 if ($start_date>0 && $start_date!=$pre_time) {
263 echo _AT('g_session_start').' '.date("F j, Y, g:i a", $start_date).' '._AT('session_end').' '.date("F j, Y, g:i a", $pre_time).' ('._AT('duration').':'.date('i \m\i\n s \s\e\c',($pre_time-$start_date)).')';
267 //echo _AT('invalid_session');