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

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

branches/paul/admin/subject_stats.phtml revision 68 by dpavlin, Thu Mar 18 19:24:54 2004 UTC branches/paul_xx/admin/subject_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.substats";                  FROM libstats.substats";
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 269  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 = mysql_tryquery($sql);          $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 = mysql_fetch_array ($rs, MYSQL_ASSOC)) {          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 305  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 = mysql_tryquery($stats_sql);                  $stats_rs = xx_tryquery($stats_sql);
309                  $stats_row = mysql_fetch_array ($stats_rs, MYSQL_ASSOC);                  $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.68  
changed lines
  Added in v.69
  ViewVC Help
Powered by ViewVC 1.1.26