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

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

revision 66 by dpavlin, Fri Dec 5 18:40:01 2003 UTC revision 67 by dpavlin, Thu Mar 18 19:24:54 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 57  if(isset($libsession) && $sess_access_le Line 67  if(isset($libsession) && $sess_access_le
67          // Logged in users          // Logged in users
68          $todays_date = substr($sess_time_human, 0, 10);          $todays_date = substr($sess_time_human, 0, 10);
69          $sql = "SELECT COUNT(*) FROM staff WHERE last_login LIKE '" . $summary_date . "%'";          $sql = "SELECT COUNT(*) FROM staff WHERE last_login LIKE '" . $summary_date . "%'";
70          $result = statQuery($con, $sql);          $result = statQuery($sql);
71          printf("<tr><td>Staff logging in today (%s)</td>\n", $summary_date);          printf("<tr><td>Staff logging in today (%s)</td>\n", $summary_date);
72          printf("<td>%s</td></tr>\n", $result);            printf("<td>%s</td></tr>\n", $result);  
73    
74          // Total number of resources          // Total number of resources
75          $sql = "SELECT COUNT(*) FROM resource";          $sql = "SELECT COUNT(*) FROM resource";
76          $result = statQuery($con, $sql);          $result = statQuery($sql);
77          printf("<tr><td>Resources</td>\n");          printf("<tr><td>Resources</td>\n");
78          printf("<td>%s</td></tr>\n", $result);          printf("<td>%s</td></tr>\n", $result);
79    
80          // Total number of subjects          // Total number of subjects
81          $sql = "SELECT COUNT(*) FROM subject";          $sql = "SELECT COUNT(*) FROM subject";
82          $result = statQuery($con, $sql);          $result = statQuery($sql);
83          printf("<tr><td>Subjects</td>\n");          printf("<tr><td>Subjects</td>\n");
84          printf("<td>%s</td></tr>\n", $result);                    printf("<td>%s</td></tr>\n", $result);          
85    
86          // Total number of CourseLib pages          // Total number of CourseLib pages
87          $sql = "SELECT COUNT(*) FROM page WHERE pagetype_id = 3";          $sql = "SELECT COUNT(*) FROM page WHERE pagetype_id = 3";
88          $result = statQuery($con, $sql);          $result = statQuery($sql);
89          printf("<tr><td>CourseLib pages</td>\n");          printf("<tr><td>CourseLib pages</td>\n");
90          printf("<td>%s</td></tr>\n", $result);          printf("<td>%s</td></tr>\n", $result);
91    
92          // Total number of PageScribe Pages          // Total number of PageScribe Pages
93          $sql = "SELECT COUNT(*) FROM page WHERE pagetype_id = 2";          $sql = "SELECT COUNT(*) FROM page WHERE pagetype_id = 2";
94          $result = statQuery($con, $sql);          $result = statQuery($sql);
95          printf("<tr><td>PageScribe pages</td>\n");          printf("<tr><td>PageScribe pages</td>\n");
96          printf("<td>%s</td></tr>\n", $result);          printf("<td>%s</td></tr>\n", $result);
97    
98          // Total number of elements          // Total number of elements
99          $sql = "SELECT COUNT(*) FROM element";          $sql = "SELECT COUNT(*) FROM element";
100          $result = statQuery($con, $sql);          $result = statQuery($sql);
101          printf("<tr><td>CourseLib and PageScribe elements</td>\n");          printf("<tr><td>CourseLib and PageScribe elements</td>\n");
102          printf("<td>%s</td></tr>\n", $result);            printf("<td>%s</td></tr>\n", $result);  
103    
104          // Total number of resource elements          // Total number of resource elements
105          $sql = "SELECT COUNT(*) FROM element WHERE resource_id > 0";          $sql = "SELECT COUNT(*) FROM element WHERE resource_id > 0";
106          $result = statQuery($con, $sql);          $result = statQuery($sql);
107          $num_resources = $result;          $num_resources = $result;
108          printf("<tr><td>CourseLib and PageScribe resource-type elements</td>\n");          printf("<tr><td>CourseLib and PageScribe resource-type elements</td>\n");
109          printf("<td>%s</td></tr>\n", $result);          printf("<td>%s</td></tr>\n", $result);
110    
111          // Total number of "unique resource" elements          // Total number of "unique resource" elements
112          $sql = "SELECT COUNT(*) FROM element WHERE LENGTH(label) > 0";          $sql = "SELECT COUNT(*) FROM element WHERE LENGTH(label) > 0";
113          $result = statQuery($con, $sql);          $result = statQuery($sql);
114          $num_text_elements = $result;          $num_text_elements = $result;
115          if ($num_resources > 0 && $num_text_elements > 0) {          if ($num_resources > 0 && $num_text_elements > 0) {
116                  $text_percent = 100 * ($num_text_elements / ($num_resources + $num_text_elements));                  $text_percent = 100 * ($num_text_elements / ($num_resources + $num_text_elements));
# Line 111  if(isset($libsession) && $sess_access_le Line 121  if(isset($libsession) && $sess_access_le
121    
122          // Total number of users          // Total number of users
123          $sql = "SELECT COUNT(*) FROM staff WHERE staff_id > 1";          $sql = "SELECT COUNT(*) FROM staff WHERE staff_id > 1";
124          $result = statQuery($con, $sql);          $result = statQuery($sql);
125          printf("<tr><td>Staff</td>\n");          printf("<tr><td>Staff</td>\n");
126          printf("<td>%s</td></tr>\n", $result);            printf("<td>%s</td></tr>\n", $result);  
127    
Legend:
Removed from v.66  
changed lines
  Added in v.67
  ViewVC Help
Powered by ViewVC 1.1.26