Query: $query
\n";
// first, insert the metadata
$retval = msql_query($query, $dbi['dbc']);
if ($retval == false)
echo "Insert/update failed: ", msql_error(), "
\n";
// second, insert the page data
// remove old data from page_table
$query = "delete from $dbi[page_table] where pagename='$pagename'";
//echo "Delete query: $query
\n";
$retval = msql_query($query, $dbi['dbc']);
if ($retval == false)
echo "Delete on $dbi[page_table] failed: ", msql_error(), "
\n";
// insert the new lines
reset($pagehash["content"]);
for ($x = 0; $x < count($pagehash["content"]); $x++) {
$line = addslashes($pagehash["content"][$x]);
$query = "INSERT INTO $dbi[page_table] " .
"(pagename, lineno, line) " .
"VALUES('$pagename', $x, '$line')";
//echo "Page line insert query: $query
\n";
$retval = msql_query($query, $dbi['dbc']);
if ($retval == false)
echo "Insert into $dbi[page_table] failed: ", msql_error(), "
\n";;
}
}
function IsWikiPage($dbi, $pagename) {
$pagename = addslashes($pagename);
$query = "select pagename from $dbi[table] where pagename='$pagename'";
// echo "Query: $query
\n";
if ($res = msql_query($query, $dbi['dbc'])) {
return(msql_affected_rows($res));
}
}
// setup for title-search
function InitTitleSearch($dbi, $search) {
$search = addslashes($search);
$query = "select pagename from $dbi[table] " .
"where pagename clike '%$search%' order by pagename";
$res = msql_query($query, $dbi["dbc"]);
return $res;
}
// iterating through database
function TitleSearchNextMatch($dbi, $res) {
if($o = msql_fetch_object($res)) {
return $o->pagename;
}
else {
return 0;
}
}
// setup for full-text search
function InitFullSearch($dbi, $search) {
$search = addslashes($search);
$query = "select * from $dbi[table] where searchterms clike '%$search%'";
$res = msql_query($query, $dbi["dbc"]);
return $res;
}
// iterating through database
function FullSearchNextMatch($dbi, $res) {
if($hash = msql_fetch_array($res)) {
return MakePageHash($hash);
} else {
return 0;
}
}
?>