49 |
WHERE |
WHERE |
50 |
page_id = " . $page_id; |
page_id = " . $page_id; |
51 |
|
|
52 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
53 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
54 |
|
|
55 |
$course_id = $row["course_id"]; |
$course_id = $row["course_id"]; |
56 |
$staff_id_created = $row["staff_id_created"]; |
$staff_id_created = $row["staff_id_created"]; |
149 |
WHERE |
WHERE |
150 |
course_id = " . $course_id . " ORDER BY personnel_id"; |
course_id = " . $course_id . " ORDER BY personnel_id"; |
151 |
|
|
152 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
153 |
|
|
154 |
// See how many in this record set |
// See how many in this record set |
155 |
$num_personnel = mysql_num_rows($rs); |
$num_personnel = xx_num_rows($rs); |
156 |
|
|
157 |
if ($num_personnel > 0) { |
if ($num_personnel > 0) { |
158 |
|
|
161 |
printf("<b>Personnel:</b><br>\n"); |
printf("<b>Personnel:</b><br>\n"); |
162 |
|
|
163 |
|
|
164 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
165 |
|
|
166 |
// Initialize |
// Initialize |
167 |
$last_name = ""; |
$last_name = ""; |
240 |
. $subject_id |
. $subject_id |
241 |
. " AND sp.page_id = p.page_id ORDER BY p.page_title"; |
. " AND sp.page_id = p.page_id ORDER BY p.page_title"; |
242 |
|
|
243 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
244 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
245 |
$page_id = $row["page_id"]; |
$page_id = $row["page_id"]; |
246 |
$page_title = $row["page_title"]; |
$page_title = $row["page_title"]; |
247 |
|
|
276 |
. $subject_id |
. $subject_id |
277 |
. " AND so.othersub_id = s.subject_id ORDER BY s.subject"; |
. " AND so.othersub_id = s.subject_id ORDER BY s.subject"; |
278 |
|
|
279 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
280 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
281 |
$othersub_id = $row["othersub_id"]; |
$othersub_id = $row["othersub_id"]; |
282 |
$subject = $row["subject"]; |
$subject = $row["subject"]; |
283 |
|
|
308 |
// Calculate number of elements |
// Calculate number of elements |
309 |
$sql = "SELECT COUNT(*) as num_elements FROM element WHERE indent_level < 1 AND page_id = " |
$sql = "SELECT COUNT(*) as num_elements FROM element WHERE indent_level < 1 AND page_id = " |
310 |
. $page_id; |
. $page_id; |
311 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
312 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
313 |
$num_elements = $row["num_elements"]; |
$num_elements = $row["num_elements"]; |
314 |
|
|
315 |
// Calculate midpoint element |
// Calculate midpoint element |
348 |
. $page_id |
. $page_id |
349 |
. " AND e.indent_level < 1 ORDER BY e.element_order"; |
. " AND e.indent_level < 1 ORDER BY e.element_order"; |
350 |
|
|
351 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
352 |
|
|
353 |
// Build a general ToC anchor |
// Build a general ToC anchor |
354 |
printf("<a name=\"toc\"></a>\n"); |
printf("<a name=\"toc\"></a>\n"); |
363 |
|
|
364 |
$row_num = 0; |
$row_num = 0; |
365 |
|
|
366 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
367 |
|
|
368 |
// Check for the midpoint |
// Check for the midpoint |
369 |
if ($row_num == $midpoint && $wrap_toc == 1) { |
if ($row_num == $midpoint && $wrap_toc == 1) { |
461 |
AND s.coursesub_id = c.coursesub_id " |
AND s.coursesub_id = c.coursesub_id " |
462 |
. " ORDER BY s.coursesub"; |
. " ORDER BY s.coursesub"; |
463 |
|
|
464 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
465 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
466 |
$coursesub = $row["coursesub"]; |
$coursesub = $row["coursesub"]; |
467 |
|
|
468 |
printf("<option value = \"%s\"", $coursesub); |
printf("<option value = \"%s\"", $coursesub); |
505 |
AND p.published = '1'" |
AND p.published = '1'" |
506 |
. " ORDER BY f.faculty_lastname, f.faculty_firstname"; |
. " ORDER BY f.faculty_lastname, f.faculty_firstname"; |
507 |
|
|
508 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
509 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
510 |
$faculty_id = $row["faculty_id"]; |
$faculty_id = $row["faculty_id"]; |
511 |
$faculty_lastname = $row["faculty_lastname"]; |
$faculty_lastname = $row["faculty_lastname"]; |
512 |
$faculty_firstname = $row["faculty_firstname"]; |
$faculty_firstname = $row["faculty_firstname"]; |
559 |
. $where |
. $where |
560 |
. " ORDER BY " |
. " ORDER BY " |
561 |
. $field_display; |
. $field_display; |
562 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
563 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
564 |
$field_display_item = $row[$field_display]; |
$field_display_item = $row[$field_display]; |
565 |
if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; |
if (strlen($field_display_item) > 40) $field_display_item = substr($field_display_item, 0, 39) . "..."; |
566 |
$field_value_item = $row[$field_value]; |
$field_value_item = $row[$field_value]; |
609 |
. " ORDER BY " |
. " ORDER BY " |
610 |
. $field_display; |
. $field_display; |
611 |
|
|
612 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
613 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
614 |
$field_display_item = $row[$field_display]; |
$field_display_item = $row[$field_display]; |
615 |
$field_value_item = $row[$field_value]; |
$field_value_item = $row[$field_value]; |
616 |
if (strlen($field_display_item) > 50) $field_display_item = substr($field_display_item, 0, 49) . "..."; |
if (strlen($field_display_item) > 50) $field_display_item = substr($field_display_item, 0, 49) . "..."; |
654 |
. "=" |
. "=" |
655 |
. $limit_id; |
. $limit_id; |
656 |
|
|
657 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
658 |
$rowcount = mysql_num_rows($rs); |
$rowcount = xx_num_rows($rs); |
659 |
if ($rowcount >= 1){ |
if ($rowcount >= 1){ |
660 |
$rowcount = 1; |
$rowcount = 1; |
661 |
} |
} |
696 |
. "='" |
. "='" |
697 |
. $key_value |
. $key_value |
698 |
. "'"; |
. "'"; |
699 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
700 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
701 |
if (mysql_num_rows($rs) == 1) $result = $row[$desc_field]; |
if (xx_num_rows($rs) == 1) $result = $row[$desc_field]; |
702 |
else $result = ""; |
else $result = ""; |
703 |
|
|
704 |
return $result; |
return $result; |
723 |
|
|
724 |
$sql = "SELECT first_name, last_name FROM staff WHERE staff_id = " |
$sql = "SELECT first_name, last_name FROM staff WHERE staff_id = " |
725 |
. $staff_id; |
. $staff_id; |
726 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
727 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
728 |
$last_name = $row["last_name"]; |
$last_name = $row["last_name"]; |
729 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
730 |
|
|
767 |
. ", now(), '" |
. ", now(), '" |
768 |
. $user_ip |
. $user_ip |
769 |
. "')"; |
. "')"; |
770 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
771 |
|
|
772 |
} |
} |
773 |
|
|
827 |
. ", now(), '" |
. ", now(), '" |
828 |
. $user_ip |
. $user_ip |
829 |
. "')"; |
. "')"; |
830 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
831 |
|
|
832 |
} |
} |
833 |
|
|