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

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

revision 1 by dpavlin, Fri Dec 5 18:34:18 2003 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 43  if(isset($libsession) && $sess_access_le Line 53  if(isset($libsession) && $sess_access_le
53    
54    
55          // Fetch the information type descr. field          // Fetch the information type descr. field
56          $infotype = lookupField($con, "infotype", "infotype_id", $infotype_id, "infotype");          $infotype = lookupField("infotype", "infotype_id", $infotype_id, "infotype");
57    
58          printf("<center>\n");          printf("<center>\n");
59          printf("<h3>Information Type '%s' (#%d) used on the following RQS Pages:</h3>", $infotype, $infotype_id);          printf("<h3>Information Type '%s' (#%d) used on the following RQS Pages:</h3>", $infotype, $infotype_id);
# Line 78  if(isset($libsession) && $sess_access_le Line 88  if(isset($libsession) && $sess_access_le
88          // Initialize counter          // Initialize counter
89          $rowcount = 0;          $rowcount = 0;
90    
91          $rs = mysql_query($sql, $con);          $rs = xx_tryquery($sql);
92    
93          // Cycle through the result set          // Cycle through the result set
94          while ( $row = mysql_fetch_array ( $rs ) ) {          while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
95                  $subject = Trim($row["subject"]);                  $subject = Trim($row["subject"]);
96                  $subject_id = Trim($row["subject_id"]);                                  $subject_id = Trim($row["subject_id"]);                
97                  $title = Trim($row["title"]);                  $title = Trim($row["title"]);
# Line 106  if(isset($libsession) && $sess_access_le Line 116  if(isset($libsession) && $sess_access_le
116          *****************************/          *****************************/
117                    
118          printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</td>\n");          printf("<tr><td colspan=\"2\" align=\"right\" class=\"backLight\">Total RQS Uses:</td>\n");
119          if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");          if (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
120          else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));          else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs));
121          printf("</tr>\n");          printf("</tr>\n");
122    
123          // Close table          // Close table
# Line 135  if(isset($libsession) && $sess_access_le Line 145  if(isset($libsession) && $sess_access_le
145          // Initialize counter          // Initialize counter
146          $rowcount = 0;          $rowcount = 0;
147    
148          $rs = mysql_query($sql, $con);          $rs = xx_tryquery($sql);
149    
150          // Cycle through the result set          // Cycle through the result set
151          while ( $row = mysql_fetch_array ( $rs ) ) {          while ( $row = xx_fetch_array ($rs, xx_ASSOC)) {
152                  $resource_id = Trim($row["resource_id"]);                                        $resource_id = Trim($row["resource_id"]);                      
153                  $title = Trim($row["title"]);                  $title = Trim($row["title"]);
154    
# Line 158  if(isset($libsession) && $sess_access_le Line 168  if(isset($libsession) && $sess_access_le
168    
169          // Summary of occurences in resources          // Summary of occurences in resources
170          printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n");          printf("<tr><td align=\"right\" class=\"backLight\">Total associated Resources:</td>\n");
171          if (mysql_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");          if (xx_num_rows($rs) == 0) printf("<td class=\"backLight\">(None)</td>\n");
172          else printf("<td class=\"backLight\">%d</td>\n", mysql_num_rows($rs));          else printf("<td class=\"backLight\">%d</td>\n", xx_num_rows($rs));
173          printf("</tr>\n");          printf("</tr>\n");
174    
175          // Close table          // Close table
Legend:
Removed from v.1  
changed lines
  Added in v.72
  ViewVC Help
Powered by ViewVC 1.1.26