67 |
. $page_title |
. $page_title |
68 |
. "', 1, 0)"; |
. "', 1, 0)"; |
69 |
|
|
70 |
mysql_query ("LOCK TABLE page WRITE", $con); |
xx_query ("LOCK TABLE page WRITE", $con); |
71 |
|
|
72 |
// Failed |
// Failed |
73 |
if (!mysql_query($sql, $con)){ |
if (!xx_query($sql, $con)){ |
74 |
sql_err($con); |
sql_err($con); |
75 |
mysql_query ("UNLOCK TABLES", $con); |
xx_query ("UNLOCK TABLES", $con); |
76 |
bailout(); |
bailout(); |
77 |
} |
} |
78 |
|
|
79 |
// Succeeded |
// Succeeded |
80 |
else { |
else { |
81 |
$page_id = mysql_insert_id($con); |
$page_id = xx_insert_id($con); |
82 |
mysql_query("UNLOCK TABLES", $con); |
xx_query("UNLOCK TABLES", $con); |
83 |
} |
} |
84 |
|
|
85 |
// If a coursescribe page -- write the row into the course table |
// If a coursescribe page -- write the row into the course table |
91 |
. "', 'Information Resources and Services for:')"; |
. "', 'Information Resources and Services for:')"; |
92 |
|
|
93 |
// Failed |
// Failed |
94 |
if (!mysql_query($sql, $con)){ |
if (!xx_query($sql, $con)){ |
95 |
sql_err($con); |
sql_err($con); |
96 |
mysql_query ("UNLOCK TABLES", $con); |
xx_query ("UNLOCK TABLES", $con); |
97 |
bailout(); |
bailout(); |
98 |
} |
} |
99 |
|
|
100 |
// Succeeded |
// Succeeded |
101 |
else { |
else { |
102 |
mysql_query("UNLOCK TABLES", $con); |
xx_query("UNLOCK TABLES", $con); |
103 |
} |
} |
104 |
} |
} |
105 |
|
|
116 |
LEFT JOIN course c using (page_id) |
LEFT JOIN course c using (page_id) |
117 |
WHERE p.page_id = " . $page_id; |
WHERE p.page_id = " . $page_id; |
118 |
|
|
119 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
120 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
121 |
$page_title = $row["page_title"]; |
$page_title = $row["page_title"]; |
122 |
$pagetitle_style = $row["pagetitle_style"]; |
$pagetitle_style = $row["pagetitle_style"]; |
123 |
$style_id = $row["style_id"]; |
$style_id = $row["style_id"]; |
486 |
p.page_id = " |
p.page_id = " |
487 |
. $page_id |
. $page_id |
488 |
. " AND p.style_id = s.style_id"; |
. " AND p.style_id = s.style_id"; |
489 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
490 |
$row = mysql_fetch_array ($rs); |
$row = xx_fetch_array ($rs); |
491 |
$css_file = $row["css_file"]; |
$css_file = $row["css_file"]; |
492 |
|
|
493 |
if (strlen($css_file) > 0) { |
if (strlen($css_file) > 0) { |
575 |
WHERE page_id = " . $page_id |
WHERE page_id = " . $page_id |
576 |
. " ORDER BY e.element_order"; |
. " ORDER BY e.element_order"; |
577 |
|
|
578 |
$rs = mysql_query($sql, $con); |
$rs = xx_query($sql, $con); |
579 |
|
|
580 |
// Make a copy of the result set for cursor manipulation later |
// Make a copy of the result set for cursor manipulation later |
581 |
$rscopy = $rs; |
$rscopy = $rs; |
582 |
|
|
583 |
// If the previous didn't work, do this explicitly |
// If the previous didn't work, do this explicitly |
584 |
// $rscopy = mysql_query($sql, $con); |
// $rscopy = xx_query($sql, $con); |
585 |
|
|
586 |
// Create a positional variable, may contain an element or a row of add buttons |
// Create a positional variable, may contain an element or a row of add buttons |
587 |
$position = 1; |
$position = 1; |
682 |
|
|
683 |
|
|
684 |
// Cycle through each row of page elements |
// Cycle through each row of page elements |
685 |
while ($row = mysql_fetch_array ($rs)) { |
while ($row = xx_fetch_array ($rs)) { |
686 |
|
|
687 |
// General element information |
// General element information |
688 |
$element_id = $row["element_id"]; |
$element_id = $row["element_id"]; |