/[libdata]/trunk/admin/subject_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 /trunk/admin/subject_stats.phtml

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

revision 71 by dpavlin, Thu Mar 4 22:43:50 2004 UTC revision 72 by dpavlin, Thu Mar 18 20:33:37 2004 UTC
# Line 17  printf("<link rel=\"stylesheet\" href=\" Line 17  printf("<link rel=\"stylesheet\" href=\"
17  printf("</HEAD>\n");  printf("</HEAD>\n");
18    
19    
20    // Default access settings
21    $sess_time_human = "";
22    $sess_staff_account = "";
23    $sess_staff_id = 0;
24    $sess_access_level = 0;
25    $sess_access = "";
26    $sess_last_name = "";
27    $sess_first_name = "";
28    
29    
30  // Page header  // Page header
31  require_once ($GLOBAL_ADMIN_HEADER);  require_once ($GLOBAL_ADMIN_HEADER);
32    
# Line 78  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.substats";                  FROM libstats.substats";
91          $rs = xx_query($sql, $con);              $rs = xx_tryquery($sql);        
92          $row = xx_fetch_array ($rs);          $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 259  if(isset($libsession) && $sess_access_le Line 269  if(isset($libsession) && $sess_access_le
269                  WHERE s.subject_id > 1                  WHERE s.subject_id > 1
270                  ORDER BY s.subject";                  ORDER BY s.subject";
271    
272          $rs = xx_query($sql, $con);          $rs = xx_tryquery($sql);
273                    
274          // Initialize          // Initialize
275          $rowcount = 0;          $rowcount = 0;
276          $sub_loads_total = 0;          $sub_loads_total = 0;
277    
278          while ($row = xx_fetch_array ($rs)) {          while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
279    
280                  // Fetch the stuff                  // Fetch the stuff
281                  $subject_id = $row["subject_id"];                  $subject_id = $row["subject_id"];
# Line 295  if(isset($libsession) && $sess_access_le Line 305  if(isset($libsession) && $sess_access_le
305                          . "' AND visit_date <= '"                          . "' AND visit_date <= '"
306                          . $end_stamp                          . $end_stamp
307                          . "'";                          . "'";
308                  $stats_rs = xx_query($stats_sql, $con);                  $stats_rs = xx_tryquery($stats_sql);
309                  $stats_row = xx_fetch_array ($stats_rs);                  $stats_row = xx_fetch_array ($stats_rs, xx_ASSOC);
310                  $sub_loads = $stats_row["sub_loads"];                  $sub_loads = $stats_row["sub_loads"];
311                                    
312                  printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads);                  printf("<td align=\"center\" %s>%d</td>\n", $color, $sub_loads);
Legend:
Removed from v.71  
changed lines
  Added in v.72
  ViewVC Help
Powered by ViewVC 1.1.26