81 |
// Check to make sure that the staff isn't already assigned |
// Check to make sure that the staff isn't already assigned |
82 |
$sql = "SELECT * FROM page_staff where page_id = " . $page_id . |
$sql = "SELECT * FROM page_staff where page_id = " . $page_id . |
83 |
" AND staff_id = " . $staff_id_array[$subscript]; |
" AND staff_id = " . $staff_id_array[$subscript]; |
84 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
85 |
if (mysql_num_rows($rs) == 0) { |
if (xx_num_rows($rs) == 0) { |
86 |
|
|
87 |
$sql = "INSERT INTO page_staff (page_id, staff_id) VALUES (" |
$sql = "INSERT INTO page_staff (page_id, staff_id) VALUES (" |
88 |
. $page_id |
. $page_id |
89 |
. ", " |
. ", " |
90 |
. $staff_id_array[$subscript] |
. $staff_id_array[$subscript] |
91 |
. ")"; |
. ")"; |
92 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
93 |
|
|
94 |
} // staff not already assigned |
} // staff not already assigned |
95 |
|
|
117 |
. " WHERE page_id = " |
. " WHERE page_id = " |
118 |
. $page_id; |
. $page_id; |
119 |
|
|
120 |
mysql_tryquery ($sql); |
xx_tryquery ($sql); |
121 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
122 |
} |
} |
123 |
|
|
147 |
// First, we delete any previously cut elements from the pastebuffer table |
// First, we delete any previously cut elements from the pastebuffer table |
148 |
$sql = "DELETE FROM pastebuffer WHERE paste_staff_id = " |
$sql = "DELETE FROM pastebuffer WHERE paste_staff_id = " |
149 |
. $sess_staff_id; |
. $sess_staff_id; |
150 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
151 |
|
|
152 |
// Element is a parent, and user is copying that element only. |
// Element is a parent, and user is copying that element only. |
153 |
if ($copysingle == 1) { |
if ($copysingle == 1) { |
168 |
. " AND element_order > " |
. " AND element_order > " |
169 |
. $element_order |
. $element_order |
170 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
171 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
172 |
|
|
173 |
// Check for indent level |
// Check for indent level |
174 |
while (($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) && ($end_found == 0)) { |
while (($row = xx_fetch_array ($rs, xx_ASSOC)) && ($end_found == 0)) { |
175 |
|
|
176 |
$probe_element_id = $row["element_id"]; |
$probe_element_id = $row["element_id"]; |
177 |
$probe_indent_level = $row["indent_level"]; |
$probe_indent_level = $row["indent_level"]; |
232 |
. $end_element_order |
. $end_element_order |
233 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
234 |
|
|
235 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
236 |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
237 |
|
|
238 |
} // end function |
} // end function |
250 |
|
|
251 |
$sql = "DELETE from pastebuffer WHERE paste_staff_id = " |
$sql = "DELETE from pastebuffer WHERE paste_staff_id = " |
252 |
. $paste_staff_id; |
. $paste_staff_id; |
253 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
254 |
header("Location: scribe.phtml?page_id=". $page_id); |
header("Location: scribe.phtml?page_id=". $page_id); |
255 |
} |
} |
256 |
|
|
270 |
. $personnel_id |
. $personnel_id |
271 |
. " AND course_id = " |
. " AND course_id = " |
272 |
. $course_id; |
. $course_id; |
273 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
274 |
header("Location: scribe.phtml?page_id=". $page_id); |
header("Location: scribe.phtml?page_id=". $page_id); |
275 |
} |
} |
276 |
|
|
320 |
. $page_id |
. $page_id |
321 |
. " AND element_id = " |
. " AND element_id = " |
322 |
. $element_id; |
. $element_id; |
323 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
324 |
|
|
325 |
// Next, update the order of the remainders |
// Next, update the order of the remainders |
326 |
$sql = "UPDATE element SET element_order = element_order - 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order - 1 WHERE page_id = " |
327 |
. $page_id |
. $page_id |
328 |
. " AND element_order > " |
. " AND element_order > " |
329 |
. $element_order; |
. $element_order; |
330 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
331 |
|
|
332 |
// Last, delete the element reference from the stats database |
// Last, delete the element reference from the stats database |
333 |
$sql = "DELETE from libstats.elementstats WHERE page_id = " |
$sql = "DELETE from libstats.elementstats WHERE page_id = " |
334 |
. $page_id |
. $page_id |
335 |
. " AND element_id = " |
. " AND element_id = " |
336 |
. $element_id; |
. $element_id; |
337 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
338 |
|
|
339 |
// Done, return to page |
// Done, return to page |
340 |
if ($position > 2) $new_pos = $position - 1; |
if ($position > 2) $new_pos = $position - 1; |
368 |
. " AND element_order > " |
. " AND element_order > " |
369 |
. $element_order |
. $element_order |
370 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
371 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
372 |
|
|
373 |
// Check for and promote all descendants |
// Check for and promote all descendants |
374 |
while (($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) && ($desc_indent_level > $indent_level)) { |
while (($row = xx_fetch_array ($rs, xx_ASSOC)) && ($desc_indent_level > $indent_level)) { |
375 |
$desc_element_id = $row["element_id"]; |
$desc_element_id = $row["element_id"]; |
376 |
$desc_parent_id = $row["parent_id"]; |
$desc_parent_id = $row["parent_id"]; |
377 |
$desc_indent_level = $row["indent_level"]; |
$desc_indent_level = $row["indent_level"]; |
382 |
. $page_id |
. $page_id |
383 |
. " AND element_id = " |
. " AND element_id = " |
384 |
. $desc_element_id; |
. $desc_element_id; |
385 |
mysql_tryquery($promote_sql); |
xx_tryquery($promote_sql); |
386 |
|
|
387 |
} // end of check for one descendant |
} // end of check for one descendant |
388 |
|
|
401 |
. $page_id |
. $page_id |
402 |
. " AND element_id = " |
. " AND element_id = " |
403 |
. $desc_element_id; |
. $desc_element_id; |
404 |
mysql_tryquery($newparent_sql); |
xx_tryquery($newparent_sql); |
405 |
|
|
406 |
} // end check for first generation children |
} // end check for first generation children |
407 |
|
|
410 |
// Next, delete the parent |
// Next, delete the parent |
411 |
$parent_sql = "DELETE FROM element WHERE element_id = " |
$parent_sql = "DELETE FROM element WHERE element_id = " |
412 |
. $element_id; |
. $element_id; |
413 |
mysql_tryquery($parent_sql); |
xx_tryquery($parent_sql); |
414 |
|
|
415 |
// Increment the deleted counter to include the parent |
// Increment the deleted counter to include the parent |
416 |
$num_desc++; |
$num_desc++; |
420 |
. $page_id |
. $page_id |
421 |
. " AND element_order > " |
. " AND element_order > " |
422 |
. $element_order; |
. $element_order; |
423 |
mysql_tryquery($order_sql); |
xx_tryquery($order_sql); |
424 |
|
|
425 |
// Last, delete the (parent) element reference from the stats database |
// Last, delete the (parent) element reference from the stats database |
426 |
$sql = "DELETE from libstats.elementstats WHERE page_id = " |
$sql = "DELETE from libstats.elementstats WHERE page_id = " |
427 |
. $page_id |
. $page_id |
428 |
. " AND element_id = " |
. " AND element_id = " |
429 |
. $element_id; |
. $element_id; |
430 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
431 |
|
|
432 |
// Done, return to page |
// Done, return to page |
433 |
if ($position > 2) $new_pos = $position - 1; |
if ($position > 2) $new_pos = $position - 1; |
462 |
. " AND element_order > " |
. " AND element_order > " |
463 |
. $element_order |
. $element_order |
464 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
465 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
466 |
|
|
467 |
// Check for and delete all descendants |
// Check for and delete all descendants |
468 |
while (($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) && ($desc_indent_level > $indent_level)) { |
while (($row = xx_fetch_array ($rs, xx_ASSOC)) && ($desc_indent_level > $indent_level)) { |
469 |
$desc_element_id = $row["element_id"]; |
$desc_element_id = $row["element_id"]; |
470 |
$desc_parent_id = $row["parent_id"]; |
$desc_parent_id = $row["parent_id"]; |
471 |
$desc_indent_level = $row["indent_level"]; |
$desc_indent_level = $row["indent_level"]; |
474 |
if ($desc_indent_level > $indent_level) { |
if ($desc_indent_level > $indent_level) { |
475 |
$delete_sql = "DELETE FROM element WHERE element_id = " |
$delete_sql = "DELETE FROM element WHERE element_id = " |
476 |
. $desc_element_id; |
. $desc_element_id; |
477 |
mysql_tryquery($delete_sql); |
xx_tryquery($delete_sql); |
478 |
|
|
479 |
// Increment the deleted descendant counter |
// Increment the deleted descendant counter |
480 |
$num_desc++; |
$num_desc++; |
486 |
. $page_id |
. $page_id |
487 |
. " AND element_id = " |
. " AND element_id = " |
488 |
. $desc_element_id; |
. $desc_element_id; |
489 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
490 |
|
|
491 |
} // end check for all descendants |
} // end check for all descendants |
492 |
|
|
493 |
// Delete the parent itself |
// Delete the parent itself |
494 |
$parent_sql = "DELETE FROM element WHERE element_id = " |
$parent_sql = "DELETE FROM element WHERE element_id = " |
495 |
. $element_id; |
. $element_id; |
496 |
mysql_tryquery($parent_sql); |
xx_tryquery($parent_sql); |
497 |
|
|
498 |
// Increment the deleted counter to include the parent |
// Increment the deleted counter to include the parent |
499 |
$num_desc++; |
$num_desc++; |
505 |
. $page_id |
. $page_id |
506 |
. " AND element_order > " |
. " AND element_order > " |
507 |
. $element_order; |
. $element_order; |
508 |
mysql_tryquery($order_sql); |
xx_tryquery($order_sql); |
509 |
|
|
510 |
// Last, delete the (parent) element reference from the stats database |
// Last, delete the (parent) element reference from the stats database |
511 |
$sql = "DELETE from libstats.elementstats WHERE page_id = " |
$sql = "DELETE from libstats.elementstats WHERE page_id = " |
512 |
. $page_id |
. $page_id |
513 |
. " AND element_id = " |
. " AND element_id = " |
514 |
. $element_id; |
. $element_id; |
515 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
516 |
|
|
517 |
// Done, return to page |
// Done, return to page |
518 |
if ($position > 2) $new_pos = $position - 1; |
if ($position > 2) $new_pos = $position - 1; |
566 |
$sql = "SELECT course_id FROM course WHERE page_id = " |
$sql = "SELECT course_id FROM course WHERE page_id = " |
567 |
. $page_id; |
. $page_id; |
568 |
|
|
569 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
570 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
571 |
|
|
572 |
// Collect the access information |
// Collect the access information |
573 |
$course_id = $row["course_id"]; |
$course_id = $row["course_id"]; |
574 |
|
|
575 |
// Delete all elements first |
// Delete all elements first |
576 |
$sql = "DELETE from element WHERE page_id =" . $page_id; |
$sql = "DELETE from element WHERE page_id =" . $page_id; |
577 |
if (mysql_tryquery ($sql)) printf("Removed this page's elements.<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed this page's elements.<BR>\n"); |
578 |
|
|
579 |
// Delete course information, if any |
// Delete course information, if any |
580 |
$sql = "DELETE from course WHERE page_id =" . $page_id; |
$sql = "DELETE from course WHERE page_id =" . $page_id; |
581 |
if (mysql_tryquery ($sql)) printf("Removed course information (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed course information (if any).<BR>\n"); |
582 |
|
|
583 |
// Delete assigned course personnel, if any |
// Delete assigned course personnel, if any |
584 |
if ($course_id > 0) { |
if ($course_id > 0) { |
585 |
|
|
586 |
$sql = "DELETE from course_personnel WHERE course_id =" . $course_id; |
$sql = "DELETE from course_personnel WHERE course_id =" . $course_id; |
587 |
if (mysql_tryquery ($sql)) printf("Removed assigned course personnel (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed assigned course personnel (if any).<BR>\n"); |
588 |
} |
} |
589 |
|
|
590 |
// Delete assigned staff, if any |
// Delete assigned staff, if any |
591 |
$sql = "DELETE from page_staff WHERE page_id =" . $page_id; |
$sql = "DELETE from page_staff WHERE page_id =" . $page_id; |
592 |
if (mysql_tryquery ($sql)) printf("Removed assigned staff (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed assigned staff (if any).<BR>\n"); |
593 |
|
|
594 |
// Delete assigned subjects, if any |
// Delete assigned subjects, if any |
595 |
$sql = "DELETE from sub_page WHERE page_id =" . $page_id; |
$sql = "DELETE from sub_page WHERE page_id =" . $page_id; |
596 |
if (mysql_tryquery ($sql)) printf("Removed assigned subjects (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed assigned subjects (if any).<BR>\n"); |
597 |
|
|
598 |
// Delete element statistics, if any |
// Delete element statistics, if any |
599 |
$sql = "DELETE from libstats.elementstats WHERE page_id =" . $page_id; |
$sql = "DELETE from libstats.elementstats WHERE page_id =" . $page_id; |
600 |
if (mysql_tryquery ($sql)) printf("Removed page's element statistics (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed page's element statistics (if any).<BR>\n"); |
601 |
|
|
602 |
// Delete page overall statistics, if any |
// Delete page overall statistics, if any |
603 |
$sql = "DELETE from libstats.pagestats WHERE page_id =" . $page_id; |
$sql = "DELETE from libstats.pagestats WHERE page_id =" . $page_id; |
604 |
if (mysql_tryquery ($sql)) printf("Removed page's overall statistics (if any).<BR>\n"); |
if (xx_tryquery ($sql)) printf("Removed page's overall statistics (if any).<BR>\n"); |
605 |
|
|
606 |
// Delete the page information |
// Delete the page information |
607 |
$sql = "DELETE from page WHERE page_id =" . $page_id; |
$sql = "DELETE from page WHERE page_id =" . $page_id; |
608 |
if (mysql_tryquery ($sql)) printf("Removed page successfully."); |
if (xx_tryquery ($sql)) printf("Removed page successfully."); |
609 |
|
|
610 |
} |
} |
611 |
else printf("Scribe page not found."); |
else printf("Scribe page not found."); |
713 |
$sql = "DELETE FROM page_staff where page_id = " . $page_id . |
$sql = "DELETE FROM page_staff where page_id = " . $page_id . |
714 |
" AND staff_id = " . $staff_list_array[$element]; |
" AND staff_id = " . $staff_list_array[$element]; |
715 |
|
|
716 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
717 |
} |
} |
718 |
|
|
719 |
// Call the PageScribe page back |
// Call the PageScribe page back |
740 |
// Calculate number of elements |
// Calculate number of elements |
741 |
$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 = " |
742 |
. $page_id; |
. $page_id; |
743 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
744 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
745 |
$num_elements = $row["num_elements"]; |
$num_elements = $row["num_elements"]; |
746 |
|
|
747 |
// Calculate midpoint element |
// Calculate midpoint element |
780 |
. $page_id |
. $page_id |
781 |
. " AND e.indent_level < 1 ORDER BY e.element_order"; |
. " AND e.indent_level < 1 ORDER BY e.element_order"; |
782 |
|
|
783 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
784 |
|
|
785 |
// Build a general ToC anchor |
// Build a general ToC anchor |
786 |
printf("<a name=\"toc\"></a>\n"); |
printf("<a name=\"toc\"></a>\n"); |
795 |
|
|
796 |
$row_num = 0; |
$row_num = 0; |
797 |
|
|
798 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
799 |
|
|
800 |
// Check for the midpoint |
// Check for the midpoint |
801 |
if ($wrap_toc == 1) |
if ($wrap_toc == 1) |
898 |
. $page_id |
. $page_id |
899 |
. " AND element_id = " |
. " AND element_id = " |
900 |
. $element_id; |
. $element_id; |
901 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
902 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
903 |
$down_indent_level = $row["indent_level"]; |
$down_indent_level = $row["indent_level"]; |
904 |
$down_element_order = $row["element_order"]; |
$down_element_order = $row["element_order"]; |
905 |
|
|
912 |
. $down_element_order |
. $down_element_order |
913 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
914 |
|
|
915 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
916 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
917 |
$up_element_id = $row["element_id"]; |
$up_element_id = $row["element_id"]; |
918 |
$up_element_order = $row["element_order"]; |
$up_element_order = $row["element_order"]; |
919 |
|
|
933 |
. " AND element_order < " |
. " AND element_order < " |
934 |
. $up_element_order; |
. $up_element_order; |
935 |
|
|
936 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
937 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
938 |
$down_num = $row["down_num"]; |
$down_num = $row["down_num"]; |
939 |
|
|
940 |
// Add the element itself |
// Add the element itself |
951 |
. $up_element_order |
. $up_element_order |
952 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
953 |
|
|
954 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
955 |
|
|
956 |
// Flag to determine the end of this element's lineage |
// Flag to determine the end of this element's lineage |
957 |
$lineage = 1; |
$lineage = 1; |
972 |
descendant affected by a move. |
descendant affected by a move. |
973 |
*/ |
*/ |
974 |
|
|
975 |
while (($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) && $lineage == 1) { |
while (($row = xx_fetch_array ($rs, xx_ASSOC)) && $lineage == 1) { |
976 |
$desc_element_id = $row["element_id"]; |
$desc_element_id = $row["element_id"]; |
977 |
$desc_indent_level = $row["indent_level"]; |
$desc_indent_level = $row["indent_level"]; |
978 |
$desc_element_order = $row["element_order"]; |
$desc_element_order = $row["element_order"]; |
1001 |
. " AND element_order <= " |
. " AND element_order <= " |
1002 |
. $stop_element_order |
. $stop_element_order |
1003 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
1004 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1005 |
|
|
1006 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1007 |
$mod_element_id = $row["element_id"]; |
$mod_element_id = $row["element_id"]; |
1008 |
$mod_indent_level = $row["indent_level"]; |
$mod_indent_level = $row["indent_level"]; |
1009 |
$mod_element_order = $row["element_order"]; |
$mod_element_order = $row["element_order"]; |
1030 |
. $page_id |
. $page_id |
1031 |
. " AND element_id = " |
. " AND element_id = " |
1032 |
. $mod_element_id; |
. $mod_element_id; |
1033 |
mysql_tryquery($mod_sql); |
xx_tryquery($mod_sql); |
1034 |
|
|
1035 |
} // all affected elements |
} // all affected elements |
1036 |
|
|
1081 |
. $page_id |
. $page_id |
1082 |
. " AND indent_level = " |
. " AND indent_level = " |
1083 |
. $auto_indent_level; |
. $auto_indent_level; |
1084 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1085 |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
1086 |
|
|
1087 |
} |
} |
1120 |
. $page_id |
. $page_id |
1121 |
. " AND element_id = " |
. " AND element_id = " |
1122 |
. $element_id; |
. $element_id; |
1123 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1124 |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
1125 |
} |
} |
1126 |
|
|
1150 |
. $page_id |
. $page_id |
1151 |
. " AND element_id = " |
. " AND element_id = " |
1152 |
. $element_id; |
. $element_id; |
1153 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1154 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1155 |
$up_indent_level = $row["indent_level"]; |
$up_indent_level = $row["indent_level"]; |
1156 |
$up_element_order = $row["element_order"]; |
$up_element_order = $row["element_order"]; |
1157 |
|
|
1164 |
. $up_element_order |
. $up_element_order |
1165 |
. " ORDER BY element_order DESC"; |
. " ORDER BY element_order DESC"; |
1166 |
|
|
1167 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1168 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1169 |
$down_element_id = $row["element_id"]; |
$down_element_id = $row["element_id"]; |
1170 |
$down_element_order = $row["element_order"]; |
$down_element_order = $row["element_order"]; |
1171 |
|
|
1185 |
. " AND element_order < " |
. " AND element_order < " |
1186 |
. $up_element_order; |
. $up_element_order; |
1187 |
|
|
1188 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1189 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1190 |
$down_num = $row["down_num"]; |
$down_num = $row["down_num"]; |
1191 |
|
|
1192 |
// Add the element itself |
// Add the element itself |
1202 |
. " AND element_order > " |
. " AND element_order > " |
1203 |
. $up_element_order |
. $up_element_order |
1204 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
1205 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1206 |
|
|
1207 |
// Flag to determine the end of this element's lineage |
// Flag to determine the end of this element's lineage |
1208 |
$lineage = 1; |
$lineage = 1; |
1223 |
descendant affected by a move. |
descendant affected by a move. |
1224 |
*/ |
*/ |
1225 |
|
|
1226 |
while (($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) && $lineage == 1) { |
while (($row = xx_fetch_array ($rs, xx_ASSOC)) && $lineage == 1) { |
1227 |
$desc_element_id = $row["element_id"]; |
$desc_element_id = $row["element_id"]; |
1228 |
$desc_indent_level = $row["indent_level"]; |
$desc_indent_level = $row["indent_level"]; |
1229 |
$desc_element_order = $row["element_order"]; |
$desc_element_order = $row["element_order"]; |
1252 |
. " AND element_order <= " |
. " AND element_order <= " |
1253 |
. $stop_element_order |
. $stop_element_order |
1254 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
1255 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1256 |
|
|
1257 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1258 |
$mod_element_id = $row["element_id"]; |
$mod_element_id = $row["element_id"]; |
1259 |
$mod_indent_level = $row["indent_level"]; |
$mod_indent_level = $row["indent_level"]; |
1260 |
$mod_element_order = $row["element_order"]; |
$mod_element_order = $row["element_order"]; |
1281 |
. $page_id |
. $page_id |
1282 |
. " AND element_id = " |
. " AND element_id = " |
1283 |
. $mod_element_id; |
. $mod_element_id; |
1284 |
mysql_tryquery($mod_sql); |
xx_tryquery($mod_sql); |
1285 |
|
|
1286 |
} // all affected elements |
} // all affected elements |
1287 |
|
|
1310 |
$sql = "SELECT MAX(indent_level) AS max_indent FROM element WHERE page_id = " |
$sql = "SELECT MAX(indent_level) AS max_indent FROM element WHERE page_id = " |
1311 |
. $page_id; |
. $page_id; |
1312 |
|
|
1313 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1314 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1315 |
$max_indent = $row["max_indent"]; |
$max_indent = $row["max_indent"]; |
1316 |
|
|
1317 |
return $max_indent; |
return $max_indent; |
1392 |
. "', '" |
. "', '" |
1393 |
. $pers_email |
. $pers_email |
1394 |
. "')"; |
. "')"; |
1395 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1396 |
$new_faculty_id = mysql_insert_id(); |
$new_faculty_id = xx_insert_id(); |
1397 |
|
|
1398 |
// Now, build the SQL for the insert into course_personnel |
// Now, build the SQL for the insert into course_personnel |
1399 |
$sql = "INSERT INTO course_personnel (course_id, stafftitle_id, faculty_id) VALUES (" |
$sql = "INSERT INTO course_personnel (course_id, stafftitle_id, faculty_id) VALUES (" |
1437 |
|
|
1438 |
// Proceed if there are no error messages |
// Proceed if there are no error messages |
1439 |
if ($err_code == 0) { |
if ($err_code == 0) { |
1440 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1441 |
|
|
1442 |
// Done. Call the PageScribe page back |
// Done. Call the PageScribe page back |
1443 |
header("Location: scribe.phtml?page_id=" . $page_id . "#coursePers"); |
header("Location: scribe.phtml?page_id=" . $page_id . "#coursePers"); |
1512 |
// Next, bump all of the following items down by one |
// Next, bump all of the following items down by one |
1513 |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
1514 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1515 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1516 |
|
|
1517 |
// Next insert the new label |
// Next insert the new label |
1518 |
$sql = "INSERT INTO element (page_id, label, label_url, element_descr, element_order, indent_level,parent_id) VALUES (" |
$sql = "INSERT INTO element (page_id, label, label_url, element_descr, element_order, indent_level,parent_id) VALUES (" |
1523 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1524 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1525 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1526 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1527 |
} |
} |
1528 |
|
|
1529 |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
1559 |
// Next, bump all of the following items down by one |
// Next, bump all of the following items down by one |
1560 |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
1561 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1562 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1563 |
|
|
1564 |
// Next insert the new location |
// Next insert the new location |
1565 |
$sql = "INSERT INTO element (page_id, location_id, element_order, indent_level,parent_id) VALUES (" |
$sql = "INSERT INTO element (page_id, location_id, element_order, indent_level,parent_id) VALUES (" |
1568 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1569 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1570 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1571 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1572 |
|
|
1573 |
} |
} |
1574 |
|
|
1605 |
// Next, bump all of the following items down by one |
// Next, bump all of the following items down by one |
1606 |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
1607 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1608 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1609 |
|
|
1610 |
// Next insert the new resource |
// Next insert the new resource |
1611 |
$sql = "INSERT INTO element (page_id, resource_id, element_order, indent_level,parent_id) VALUES (" |
$sql = "INSERT INTO element (page_id, resource_id, element_order, indent_level,parent_id) VALUES (" |
1614 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1615 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1616 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1617 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1618 |
|
|
1619 |
} |
} |
1620 |
|
|
1652 |
|
|
1653 |
// Identify the number of new elements to add |
// Identify the number of new elements to add |
1654 |
$sql = "SELECT COUNT(*) as num_rqs from res_sub_infotype WHERE subject_id = " . $subject_id; |
$sql = "SELECT COUNT(*) as num_rqs from res_sub_infotype WHERE subject_id = " . $subject_id; |
1655 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1656 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1657 |
|
|
1658 |
// Pull out the possible display values |
// Pull out the possible display values |
1659 |
$num_rqs = $row["num_rqs"]; |
$num_rqs = $row["num_rqs"]; |
1666 |
. $num_rqs |
. $num_rqs |
1667 |
. " WHERE page_id = " |
. " WHERE page_id = " |
1668 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1669 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1670 |
|
|
1671 |
// Cycle through the resources |
// Cycle through the resources |
1672 |
$sql = "SELECT rsi.resource_id, r.title |
$sql = "SELECT rsi.resource_id, r.title |
1675 |
WHERE subject_id = " . $subject_id . |
WHERE subject_id = " . $subject_id . |
1676 |
" ORDER BY r.title"; |
" ORDER BY r.title"; |
1677 |
|
|
1678 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1679 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
1680 |
|
|
1681 |
// Fetch resource |
// Fetch resource |
1682 |
$resource_id = $row["resource_id"]; |
$resource_id = $row["resource_id"]; |
1688 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1689 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1690 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1691 |
mysql_tryquery($i_sql); |
xx_tryquery($i_sql); |
1692 |
|
|
1693 |
// Increment element order |
// Increment element order |
1694 |
$prev_element_order++; |
$prev_element_order++; |
1733 |
// Next, bump all of the following items down by one |
// Next, bump all of the following items down by one |
1734 |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
1735 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1736 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1737 |
|
|
1738 |
// Next insert the new resource |
// Next insert the new resource |
1739 |
$sql = "INSERT INTO element (page_id, subject_id, element_order, indent_level,parent_id) VALUES (" |
$sql = "INSERT INTO element (page_id, subject_id, element_order, indent_level,parent_id) VALUES (" |
1742 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1743 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1744 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1745 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1746 |
|
|
1747 |
} |
} |
1748 |
|
|
1779 |
// Next, bump all of the following items down by one |
// Next, bump all of the following items down by one |
1780 |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
1781 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1782 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1783 |
|
|
1784 |
// Next insert the new service |
// Next insert the new service |
1785 |
$sql = "INSERT INTO element (page_id, service_id, element_order, indent_level,parent_id) VALUES (" |
$sql = "INSERT INTO element (page_id, service_id, element_order, indent_level,parent_id) VALUES (" |
1788 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1789 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1790 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1791 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1792 |
|
|
1793 |
} |
} |
1794 |
|
|
1822 |
// Next, bump all of the following items down by one |
// Next, bump all of the following items down by one |
1823 |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
$sql = "UPDATE element SET element_order = element_order + 1 WHERE page_id = " |
1824 |
. $page_id . " AND element_order >= " . $prev_element_order; |
. $page_id . " AND element_order >= " . $prev_element_order; |
1825 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1826 |
|
|
1827 |
// Next insert the new staff |
// Next insert the new staff |
1828 |
$sql = "INSERT INTO element (page_id, staff_id, element_order, indent_level,parent_id) VALUES (" |
$sql = "INSERT INTO element (page_id, staff_id, element_order, indent_level,parent_id) VALUES (" |
1831 |
. $prev_element_order . ", " |
. $prev_element_order . ", " |
1832 |
. $prev_indent_level . ", " |
. $prev_indent_level . ", " |
1833 |
. $parent_id . ")"; |
. $parent_id . ")"; |
1834 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1835 |
|
|
1836 |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
header("Location: scribe.phtml?page_id=" . $page_id . "#p" . $position); |
1837 |
} |
} |
1867 |
. ", now(), '" |
. ", now(), '" |
1868 |
. $user_ip |
. $user_ip |
1869 |
. "')"; |
. "')"; |
1870 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1871 |
|
|
1872 |
} |
} |
1873 |
|
|
1895 |
// First copy the page elements |
// First copy the page elements |
1896 |
$sql = "SELECT * FROM page WHERE page_id = " |
$sql = "SELECT * FROM page WHERE page_id = " |
1897 |
. $page_id; |
. $page_id; |
1898 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1899 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1900 |
|
|
1901 |
// Fetch results |
// Fetch results |
1902 |
$style_id = $row["style_id"]; |
$style_id = $row["style_id"]; |
1956 |
. $up_text |
. $up_text |
1957 |
. "')"; |
. "')"; |
1958 |
|
|
1959 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
1960 |
$new_page_id = mysql_insert_id(); |
$new_page_id = xx_insert_id(); |
1961 |
|
|
1962 |
// If a new stub was created, and this happens to be a course page, get the course id. |
// If a new stub was created, and this happens to be a course page, get the course id. |
1963 |
if ($new_page_id > 0 && $pagetype_id == 3) { |
if ($new_page_id > 0 && $pagetype_id == 3) { |
1970 |
// Copy the course elements |
// Copy the course elements |
1971 |
$sql = "SELECT * FROM course WHERE page_id = " |
$sql = "SELECT * FROM course WHERE page_id = " |
1972 |
. $page_id; |
. $page_id; |
1973 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
1974 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
1975 |
|
|
1976 |
// Fetch results |
// Fetch results |
1977 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
2036 |
$introheader2 . "', '" . |
$introheader2 . "', '" . |
2037 |
$intromessage2 . "')"; |
$intromessage2 . "')"; |
2038 |
|
|
2039 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2040 |
|
|
2041 |
} // was a CourseScribe type page |
} // was a CourseScribe type page |
2042 |
|
|
2048 |
. $page_id |
. $page_id |
2049 |
. " ORDER BY element_id"; |
. " ORDER BY element_id"; |
2050 |
|
|
2051 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2052 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2053 |
|
|
2054 |
// Fetch previous values |
// Fetch previous values |
2055 |
$element_id = $row["element_id"]; |
$element_id = $row["element_id"]; |
2115 |
$indent_level . ")"; |
$indent_level . ")"; |
2116 |
|
|
2117 |
// Execute the query |
// Execute the query |
2118 |
mysql_tryquery($clone_sql); |
xx_tryquery($clone_sql); |
2119 |
|
|
2120 |
} |
} |
2121 |
|
|
2170 |
. $page_id |
. $page_id |
2171 |
. " AND p.staff_coordinator = s.staff_id"; |
. " AND p.staff_coordinator = s.staff_id"; |
2172 |
|
|
2173 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2174 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2175 |
|
|
2176 |
$page_title = strip_tags($row["page_title"]); |
$page_title = strip_tags($row["page_title"]); |
2177 |
$first_name = $row["first_name"]; |
$first_name = $row["first_name"]; |
2221 |
. $page_id |
. $page_id |
2222 |
. " AND parent_id = " |
. " AND parent_id = " |
2223 |
. $element_id; |
. $element_id; |
2224 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2225 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2226 |
$num_children = $row["num_children"]; |
$num_children = $row["num_children"]; |
2227 |
|
|
2228 |
return $num_children; |
return $num_children; |
2261 |
// Found parent tag |
// Found parent tag |
2262 |
$found = 0; |
$found = 0; |
2263 |
|
|
2264 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2265 |
while (($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) && $found == 0) { |
while (($row = xx_fetch_array ($rs, xx_ASSOC)) && $found == 0) { |
2266 |
|
|
2267 |
/* Cycle through the list, looking for the first item with an indent |
/* Cycle through the list, looking for the first item with an indent |
2268 |
of less. */ |
of less. */ |
2313 |
$sql = "SELECT COUNT(*) as buffer_size FROM pastebuffer WHERE paste_staff_id = " |
$sql = "SELECT COUNT(*) as buffer_size FROM pastebuffer WHERE paste_staff_id = " |
2314 |
. $sess_staff_id |
. $sess_staff_id |
2315 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
2316 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2317 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2318 |
$buffer_size = $row["buffer_size"]; |
$buffer_size = $row["buffer_size"]; |
2319 |
|
|
2320 |
if ($debug == 1) printf("Number of elements in buffer: %s<br>\n", $buffer_size); |
if ($debug == 1) printf("Number of elements in buffer: %s<br>\n", $buffer_size); |
2325 |
. $page_id |
. $page_id |
2326 |
. " AND element_order = " |
. " AND element_order = " |
2327 |
. $element_order; |
. $element_order; |
2328 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2329 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2330 |
$adjust_parent_id = $row["element_id"]; |
$adjust_parent_id = $row["element_id"]; |
2331 |
|
|
2332 |
if ($debug == 1) printf("Parent of first element will be: %d<BR>", $adjust_parent_id); |
if ($debug == 1) printf("Parent of first element will be: %d<BR>", $adjust_parent_id); |
2342 |
|
|
2343 |
if ($debug == 1) printf("bump down sql was: %s<br>\n", $sql); |
if ($debug == 1) printf("bump down sql was: %s<br>\n", $sql); |
2344 |
|
|
2345 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2346 |
|
|
2347 |
// Select from the paste buffer |
// Select from the paste buffer |
2348 |
$sql = "SELECT * FROM pastebuffer WHERE paste_staff_id = " |
$sql = "SELECT * FROM pastebuffer WHERE paste_staff_id = " |
2349 |
. $sess_staff_id |
. $sess_staff_id |
2350 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
2351 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2352 |
|
|
2353 |
// row count |
// row count |
2354 |
$row_num = 0; |
$row_num = 0; |
2355 |
|
|
2356 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2357 |
|
|
2358 |
// Load copy-paste buffer elements |
// Load copy-paste buffer elements |
2359 |
$copy_indent_level = $row["indent_level"]; |
$copy_indent_level = $row["indent_level"]; |
2466 |
if ($debug == 1) printf("insert sql was: %s<br>\n", $p_sql); |
if ($debug == 1) printf("insert sql was: %s<br>\n", $p_sql); |
2467 |
|
|
2468 |
// Perform the write |
// Perform the write |
2469 |
mysql_tryquery($p_sql); |
xx_tryquery($p_sql); |
2470 |
$paste_element_id = mysql_insert_id(); |
$paste_element_id = xx_insert_id(); |
2471 |
|
|
2472 |
// Debugging |
// Debugging |
2473 |
if ($debug == 1) { |
if ($debug == 1) { |
2512 |
WHERE page_id = " |
WHERE page_id = " |
2513 |
. $page_id |
. $page_id |
2514 |
. " ORDER BY element_order"; |
. " ORDER BY element_order"; |
2515 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2516 |
|
|
2517 |
// Start populating generation array subscript [1] |
// Start populating generation array subscript [1] |
2518 |
$rowcount = 1; |
$rowcount = 1; |
2519 |
|
|
2520 |
while ($row = mysql_fetch_array ($rs, MYSQL_ASSOC)) { |
while ($row = xx_fetch_array ($rs, xx_ASSOC)) { |
2521 |
|
|
2522 |
// Fetch values |
// Fetch values |
2523 |
$element_order = $row["element_order"]; |
$element_order = $row["element_order"]; |
2577 |
|
|
2578 |
// printf("sql was: %s", $sql); |
// printf("sql was: %s", $sql); |
2579 |
|
|
2580 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
2581 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
2582 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
2583 |
$pagetype_id = $row["pagetype_id"]; |
$pagetype_id = $row["pagetype_id"]; |
2584 |
|
|
2638 |
// Clear out existing published information |
// Clear out existing published information |
2639 |
// This is important, also, to get rid of a NULL value before performing a CONCAT below. |
// This is important, also, to get rid of a NULL value before performing a CONCAT below. |
2640 |
$sql = "UPDATE page set pageHTML = '' WHERE page_id = " . $page_id; |
$sql = "UPDATE page set pageHTML = '' WHERE page_id = " . $page_id; |
2641 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2642 |
|
|
2643 |
// Open the filepointer for a screen dump |
// Open the filepointer for a screen dump |
2644 |
$fp = fopen ($page_loc, "r"); |
$fp = fopen ($page_loc, "r"); |
2660 |
|
|
2661 |
// Concatenate the stream into the pageHTML field |
// Concatenate the stream into the pageHTML field |
2662 |
$sql = "UPDATE page set pageHTML = CONCAT(pageHTML,'" . $iostream_fix . "') WHERE page_id = " . $page_id; |
$sql = "UPDATE page set pageHTML = CONCAT(pageHTML,'" . $iostream_fix . "') WHERE page_id = " . $page_id; |
2663 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2664 |
} |
} |
2665 |
|
|
2666 |
// Close up the open file pointer |
// Close up the open file pointer |
2668 |
|
|
2669 |
// Set published flag to 1 |
// Set published flag to 1 |
2670 |
$sql = "UPDATE page set published = '1' WHERE page_id = " . $page_id; |
$sql = "UPDATE page set published = '1' WHERE page_id = " . $page_id; |
2671 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2672 |
|
|
2673 |
} // end open file pointer |
} // end open file pointer |
2674 |
|
|
2680 |
|
|
2681 |
// Set published flag to 1 |
// Set published flag to 1 |
2682 |
$sql = "UPDATE page set published = '1' WHERE page_id = " . $page_id; |
$sql = "UPDATE page set published = '1' WHERE page_id = " . $page_id; |
2683 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2684 |
|
|
2685 |
/*********************** |
/*********************** |
2686 |
** End of comment-out ** |
** End of comment-out ** |
2707 |
|
|
2708 |
// Build the SQL |
// Build the SQL |
2709 |
$sql = "UPDATE page SET pageHTML = NULL, published = '0' WHERE page_id =" . $page_id; |
$sql = "UPDATE page SET pageHTML = NULL, published = '0' WHERE page_id =" . $page_id; |
2710 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2711 |
|
|
2712 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
2713 |
} |
} |
2818 |
. $display_toc |
. $display_toc |
2819 |
. " WHERE page_id = " |
. " WHERE page_id = " |
2820 |
. $page_id; |
. $page_id; |
2821 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2822 |
|
|
2823 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2824 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
2842 |
. $wrap_toc |
. $wrap_toc |
2843 |
. " WHERE page_id = " |
. " WHERE page_id = " |
2844 |
. $page_id; |
. $page_id; |
2845 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2846 |
|
|
2847 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2848 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
2872 |
. $display_up |
. $display_up |
2873 |
. " WHERE page_id = " |
. " WHERE page_id = " |
2874 |
. $page_id; |
. $page_id; |
2875 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2876 |
|
|
2877 |
/* If the current up_text is blank, and the user has |
/* If the current up_text is blank, and the user has |
2878 |
toggled ON, then insert the default wording. */ |
toggled ON, then insert the default wording. */ |
2881 |
. $up_text |
. $up_text |
2882 |
. "' WHERE page_id = " |
. "' WHERE page_id = " |
2883 |
. $page_id; |
. $page_id; |
2884 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2885 |
} |
} |
2886 |
|
|
2887 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2908 |
. $up_text |
. $up_text |
2909 |
. "' WHERE page_id = " |
. "' WHERE page_id = " |
2910 |
. $page_id; |
. $page_id; |
2911 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2912 |
|
|
2913 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2914 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
2941 |
. $display_urls |
. $display_urls |
2942 |
. " WHERE page_id = " |
. " WHERE page_id = " |
2943 |
. $page_id; |
. $page_id; |
2944 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2945 |
|
|
2946 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2947 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
2965 |
. $page_debug |
. $page_debug |
2966 |
. " WHERE page_id = " |
. " WHERE page_id = " |
2967 |
. $page_id; |
. $page_id; |
2968 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2969 |
|
|
2970 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2971 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
2989 |
. $pageheader |
. $pageheader |
2990 |
. "' WHERE page_id = " |
. "' WHERE page_id = " |
2991 |
. $page_id; |
. $page_id; |
2992 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
2993 |
|
|
2994 |
// Call the PageScribe page back |
// Call the PageScribe page back |
2995 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
3010 |
. $pagetitle_style |
. $pagetitle_style |
3011 |
. " WHERE page_id = " |
. " WHERE page_id = " |
3012 |
. $page_id; |
. $page_id; |
3013 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3014 |
|
|
3015 |
// Call the PageScribe page back |
// Call the PageScribe page back |
3016 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
3045 |
. $course_id |
. $course_id |
3046 |
. " AND page_id = " |
. " AND page_id = " |
3047 |
. $page_id; |
. $page_id; |
3048 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3049 |
|
|
3050 |
|
|
3051 |
} |
} |
3060 |
. $page_id |
. $page_id |
3061 |
. ")"; |
. ")"; |
3062 |
|
|
3063 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3064 |
$course_id = mysql_insert_id(); |
$course_id = xx_insert_id(); |
3065 |
|
|
3066 |
} |
} |
3067 |
updateScribeCourseConcat($course_id, $page_id); |
updateScribeCourseConcat($course_id, $page_id); |
3098 |
WHERE |
WHERE |
3099 |
course_id = " . $course_id; |
course_id = " . $course_id; |
3100 |
|
|
3101 |
$rs = mysql_tryquery($sql); |
$rs = xx_tryquery($sql); |
3102 |
$row = mysql_fetch_array ($rs, MYSQL_ASSOC); |
$row = xx_fetch_array ($rs, xx_ASSOC); |
3103 |
|
|
3104 |
$page_title = $row["page_title"]; |
$page_title = $row["page_title"]; |
3105 |
$coursesub_id = $row["coursesub_id"]; |
$coursesub_id = $row["coursesub_id"]; |
3131 |
. $course_concat |
. $course_concat |
3132 |
. "' WHERE course_id = " |
. "' WHERE course_id = " |
3133 |
. $course_id; |
. $course_id; |
3134 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3135 |
|
|
3136 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
3137 |
|
|
3193 |
. $page_id |
. $page_id |
3194 |
. " AND element_id = " |
. " AND element_id = " |
3195 |
. $element_id; |
. $element_id; |
3196 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3197 |
|
|
3198 |
|
|
3199 |
} |
} |
3211 |
. $page_id |
. $page_id |
3212 |
. " AND element_id = " |
. " AND element_id = " |
3213 |
. $element_id; |
. $element_id; |
3214 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3215 |
|
|
3216 |
} |
} |
3217 |
|
|
3228 |
. $page_id |
. $page_id |
3229 |
. " AND element_id = " |
. " AND element_id = " |
3230 |
. $element_id; |
. $element_id; |
3231 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3232 |
|
|
3233 |
} |
} |
3234 |
|
|
3257 |
. $page_title |
. $page_title |
3258 |
. "' WHERE page_id =" |
. "' WHERE page_id =" |
3259 |
. $page_id; |
. $page_id; |
3260 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3261 |
|
|
3262 |
// Update the concatenated course title if this is a course page |
// Update the concatenated course title if this is a course page |
3263 |
if ($pagetype_id == 3) updateScribeCourseConcat($course_id, $page_id); |
if ($pagetype_id == 3) updateScribeCourseConcat($course_id, $page_id); |
3282 |
. $style_id |
. $style_id |
3283 |
. " WHERE page_id =" |
. " WHERE page_id =" |
3284 |
. $page_id; |
. $page_id; |
3285 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3286 |
|
|
3287 |
header("Location: scribe.phtml?page_id=" . $page_id); |
header("Location: scribe.phtml?page_id=" . $page_id); |
3288 |
} |
} |
3303 |
. $sess_staff_account |
. $sess_staff_account |
3304 |
. "' WHERE page_id = " |
. "' WHERE page_id = " |
3305 |
. $page_id; |
. $page_id; |
3306 |
mysql_tryquery($sql); |
xx_tryquery($sql); |
3307 |
} |
} |
3308 |
|
|
3309 |
|
|
3349 |
// Younger found |
// Younger found |
3350 |
$younger = 0; |
$younger = 0; |
3351 |
|
|
3352 |
if ($element_order <= mysql_num_rows($rs)) { |
if ($element_order <= xx_num_rows($rs)) { |
3353 |
|
|
3354 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
3355 |
$probe_indent_level = $row["indent_level"]; |
$probe_indent_level = $row["indent_level"]; |
3356 |
$probe_element_id = $row["element_id"]; |
$probe_element_id = $row["element_id"]; |
3357 |
|
|
3362 |
*/ |
*/ |
3363 |
|
|
3364 |
if ($probe_indent_level > $indent_level) $younger = 1; |
if ($probe_indent_level > $indent_level) $younger = 1; |
3365 |
if ($element_order <= mysql_num_rows($rs)) mysql_data_seek($rs, $element_order - 1); |
if ($element_order <= xx_num_rows($rs)) xx_data_seek($rs, $element_order - 1); |
3366 |
|
|
3367 |
} |
} |
3368 |
|
|