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 |
|
|
52 |
if(isset($libsession) && $sess_access_level >= 20) { |
if(isset($libsession) && $sess_access_level >= 20) { |
53 |
|
|
54 |
// Fetch the information type descr. field |
// Fetch the information type descr. field |
55 |
$masterinfotype = lookupField($con, "masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype"); |
$masterinfotype = lookupField("masterinfotype", "masterinfotype_id", $masterinfotype_id, "masterinfotype"); |
56 |
|
|
57 |
printf("<center>\n"); |
printf("<center>\n"); |
58 |
printf("<h3>Master Information Type '%s' (#%d) contains the the following specific Information Types:</h3>", $masterinfotype, $masterinfotype_id); |
printf("<h3>Master Information Type '%s' (#%d) contains the the following specific Information Types:</h3>", $masterinfotype, $masterinfotype_id); |
76 |
. $masterinfotype_id |
. $masterinfotype_id |
77 |
. " ORDER BY i.infotype"; |
. " ORDER BY i.infotype"; |
78 |
|
|
79 |
// Debugging |
$rs = xx_tryquery($sql); |
|
// printf("sql was: %s<BR>\n", $sql); |
|
|
|
|
|
$rs = xx_query($sql, $con); |
|
80 |
|
|
81 |
// Initialize counter |
// Initialize counter |
82 |
$rowcount = 0; |
$rowcount = 0; |
83 |
|
|
84 |
// Cycle through the result set |
// Cycle through the result set |
85 |
while ( $row = xx_fetch_array ( $rs ) ) { |
while ( $row = xx_fetch_array ($rs, xx_ASSOC)) { |
86 |
$infotype_id = Trim($row["infotype_id"]); |
$infotype_id = Trim($row["infotype_id"]); |
87 |
$infotype = Trim($row["infotype"]); |
$infotype = Trim($row["infotype"]); |
88 |
|
|