/[libdata]/branches/paul_xx/admin/scribe_stats.phtml
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /branches/paul_xx/admin/scribe_stats.phtml

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

branches/paul/admin/scribe_stats.phtml revision 68 by dpavlin, Thu Mar 18 19:24:54 2004 UTC branches/paul_xx/admin/scribe_stats.phtml revision 69 by dpavlin, Thu Mar 18 20:01:09 2004 UTC
# Line 88  if(isset($libsession) && $sess_access_le Line 88  if(isset($libsession) && $sess_access_le
88    
89          $sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date          $sql = "SELECT MIN(visit_date) as min_date, MAX(visit_date) as max_date
90                  FROM libstats.pagestats";                  FROM libstats.pagestats";
91          $rs = mysql_tryquery($sql);              $rs = xx_tryquery($sql);        
92          $row = mysql_fetch_array ($rs, MYSQL_ASSOC);          $row = xx_fetch_array ($rs, xx_ASSOC);
93          $min_date = $row["min_date"];          $min_date = $row["min_date"];
94          $max_date = $row["max_date"];          $max_date = $row["max_date"];
95                    
# Line 279  if(isset($libsession) && $sess_access_le Line 279  if(isset($libsession) && $sess_access_le
279                  p.page_title";                  p.page_title";
280    
281    
282          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
283                    
284          // Initialize          // Initialize
285          $rowcount = 0;          $rowcount = 0;
286          $page_loads_total = 0;          $page_loads_total = 0;
287          $element_uses_total = 0;                  $element_uses_total = 0;        
288    
289          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
290    
291                  // Fetch the stuff                  // Fetch the stuff
292                  $page_id = $row["page_id"];                  $page_id = $row["page_id"];
# Line 316  if(isset($libsession) && $sess_access_le Line 316  if(isset($libsession) && $sess_access_le
316                          . "' AND visit_date <= '"                          . "' AND visit_date <= '"
317                          . $end_stamp                          . $end_stamp
318                          . "'";                          . "'";
319                  $stats_rs = mysql_tryquery($stats_sql);                  $stats_rs = xx_tryquery($stats_sql);
320                  $stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);                  $stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
321                  $page_loads = $stats_row["page_loads"];                          $page_loads = $stats_row["page_loads"];        
322                                    
323                  printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads);                  printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads);
# Line 333  if(isset($libsession) && $sess_access_le Line 333  if(isset($libsession) && $sess_access_le
333                          . $end_stamp                          . $end_stamp
334                          . "'";                          . "'";
335    
336                  $stats_rs = mysql_tryquery($stats_sql);                  $stats_rs = xx_tryquery($stats_sql);
337                  $stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);                  $stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
338                  $element_uses = $stats_row["element_uses"];                  $element_uses = $stats_row["element_uses"];
339    
340    
# Line 398  if(isset($libsession) && $sess_access_le Line 398  if(isset($libsession) && $sess_access_le
398                  ORDER BY c.course_concat";                  ORDER BY c.course_concat";
399    
400    
401          $rs = mysql_tryquery($sql);          $rs = xx_tryquery($sql);
402                    
403          // Initialize          // Initialize
404          $rowcount = 0;          $rowcount = 0;
405          $page_loads_total = 0;          $page_loads_total = 0;
406          $element_uses_total = 0;          $element_uses_total = 0;
407    
408          while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
409    
410                  // Fetch the stuff                  // Fetch the stuff
411                  $page_id = $row["page_id"];                  $page_id = $row["page_id"];
# Line 439  if(isset($libsession) && $sess_access_le Line 439  if(isset($libsession) && $sess_access_le
439                          . "' AND visit_date <= '"                          . "' AND visit_date <= '"
440                          . $end_stamp                          . $end_stamp
441                          . "'";                            . "'";  
442                  $stats_rs = mysql_tryquery($stats_sql);                  $stats_rs = xx_tryquery($stats_sql);
443                  $stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);                  $stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
444                  $page_loads = $stats_row["page_loads"];                          $page_loads = $stats_row["page_loads"];        
445                                    
446                  printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads);                  printf("<td align=\"center\" %s>%d</td>\n", $color, $page_loads);
# Line 455  if(isset($libsession) && $sess_access_le Line 455  if(isset($libsession) && $sess_access_le
455                          . "' AND visit_date <= '"                          . "' AND visit_date <= '"
456                          . $end_stamp                          . $end_stamp
457                          . "'";                            . "'";  
458                  $stats_rs = mysql_tryquery($stats_sql);                  $stats_rs = xx_tryquery($stats_sql);
459                  $stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);                  $stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
460                  $element_uses = $stats_row["element_uses"];                  $element_uses = $stats_row["element_uses"];
461                                    
462                  // Encode the date limits                  // Encode the date limits
Legend:
Removed from v.68  
changed lines
  Added in v.69
  ViewVC Help
Powered by ViewVC 1.1.26