--- trunk/admin/scribe.phtml 2004/01/27 20:39:04 17 +++ trunk/admin/scribe.phtml 2004/03/04 22:43:50 42 @@ -67,19 +67,19 @@ . $page_title . "', 1, 0)"; - mysql_query ("LOCK TABLE page WRITE", $con); + xx_query ("LOCK TABLE page WRITE", $con); // Failed - if (!mysql_query($sql, $con)){ + if (!xx_query($sql, $con)){ sql_err($con); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - $page_id = mysql_insert_id($con); - mysql_query("UNLOCK TABLES", $con); + $page_id = xx_insert_id($con); + xx_query("UNLOCK TABLES", $con); } // If a coursescribe page -- write the row into the course table @@ -91,15 +91,15 @@ . "', 'Information Resources and Services for:')"; // Failed - if (!mysql_query($sql, $con)){ + if (!xx_query($sql, $con)){ sql_err($con); - mysql_query ("UNLOCK TABLES", $con); + xx_query ("UNLOCK TABLES", $con); bailout(); } // Succeeded else { - mysql_query("UNLOCK TABLES", $con); + xx_query("UNLOCK TABLES", $con); } } @@ -116,8 +116,8 @@ LEFT JOIN course c using (page_id) WHERE p.page_id = " . $page_id; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $page_title = $row["page_title"]; $pagetitle_style = $row["pagetitle_style"]; $style_id = $row["style_id"]; @@ -486,8 +486,8 @@ p.page_id = " . $page_id . " AND p.style_id = s.style_id"; - $rs = mysql_query($sql, $con); - $row = mysql_fetch_array ($rs); + $rs = xx_query($sql, $con); + $row = xx_fetch_array ($rs); $css_file = $row["css_file"]; if (strlen($css_file) > 0) { @@ -575,13 +575,13 @@ WHERE page_id = " . $page_id . " ORDER BY e.element_order"; - $rs = mysql_query($sql, $con); + $rs = xx_query($sql, $con); // Make a copy of the result set for cursor manipulation later $rscopy = $rs; // If the previous didn't work, do this explicitly - // $rscopy = mysql_query($sql, $con); + // $rscopy = xx_query($sql, $con); // Create a positional variable, may contain an element or a row of add buttons $position = 1; @@ -682,7 +682,7 @@ // Cycle through each row of page elements - while ($row = mysql_fetch_array ($rs)) { + while ($row = xx_fetch_array ($rs)) { // General element information $element_id = $row["element_id"];