/[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 41 by dpavlin, Fri Dec 5 18:34:18 2003 UTC revision 42 by dpavlin, Thu Mar 4 22:43:50 2004 UTC
# Line 78  if(isset($libsession) && $sess_access_le Line 78  if(isset($libsession) && $sess_access_le
78    
79          $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
80                  FROM libstats.substats";                  FROM libstats.substats";
81          $rs = mysql_query($sql, $con);            $rs = xx_query($sql, $con);    
82          $row = mysql_fetch_array ($rs);          $row = xx_fetch_array ($rs);
83          $min_date = $row["min_date"];          $min_date = $row["min_date"];
84          $max_date = $row["max_date"];          $max_date = $row["max_date"];
85                    
# Line 259  if(isset($libsession) && $sess_access_le Line 259  if(isset($libsession) && $sess_access_le
259                  WHERE s.subject_id > 1                  WHERE s.subject_id > 1
260                  ORDER BY s.subject";                  ORDER BY s.subject";
261    
262          $rs = mysql_query($sql, $con);          $rs = xx_query($sql, $con);
263                    
264          // Initialize          // Initialize
265          $rowcount = 0;          $rowcount = 0;
266          $sub_loads_total = 0;          $sub_loads_total = 0;
267    
268          while ($row = mysql_fetch_array ($rs)) {          while ($row = xx_fetch_array ($rs)) {
269    
270                  // Fetch the stuff                  // Fetch the stuff
271                  $subject_id = $row["subject_id"];                  $subject_id = $row["subject_id"];
# Line 295  if(isset($libsession) && $sess_access_le Line 295  if(isset($libsession) && $sess_access_le
295                          . "' AND visit_date <= '"                          . "' AND visit_date <= '"
296                          . $end_stamp                          . $end_stamp
297                          . "'";                          . "'";
298                  $stats_rs = mysql_query($stats_sql, $con);                  $stats_rs = xx_query($stats_sql, $con);
299                  $stats_row = mysql_fetch_array ($stats_rs);                  $stats_row = xx_fetch_array ($stats_rs);
300                  $sub_loads = $stats_row["sub_loads"];                  $sub_loads = $stats_row["sub_loads"];
301                                    
302                  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.41  
changed lines
  Added in v.42
  ViewVC Help
Powered by ViewVC 1.1.26