\n"; return $dbi; } function CloseDataBase($dbi) { // NOOP: we use persistent database connections } // Return hash of page + attributes or default function RetrievePage($dbi, $pagename) { $pagename = addslashes($pagename); $query = "select * from $dbi[table] where pagename='$pagename'"; $res = pg_exec($dbi['dbc'], $query); if (pg_numrows($res)) { if ($array = pg_fetch_array($res, 0)) { while (list($key, $val) = each($array)) { // pg_fetch_array gives us all the values twice, // so we have to manually edit out the indices if (gettype($key) == "integer") { continue; } $pagehash[$key] = $val; } // unserialize/explode content $pagehash['refs'] = unserialize($pagehash['refs']); $pagehash['content'] = explode("\n", $pagehash['content']); return $pagehash; } } // if we reach this the query failed return -1; } // Either insert or replace a key/value (a page) function InsertPage($dbi, $pagename, $pagehash) { $pagename = addslashes($pagename); // echo "
dbi in InsertPage: '$dbi' '$dbi[table]' '$dbi[dbc]'
"; // prepare the content for storage if (!isset($pagehash["pagename"])) $pagehash["pagename"] = $pagename; if (!isset($pagehash["flags"])) $pagehash["flags"] = 0; $pagehash["author"] = addslashes($pagehash["author"]); $pagehash["content"] = implode("\n", $pagehash["content"]); $pagehash["content"] = addslashes($pagehash["content"]); $pagehash["pagename"] = addslashes($pagehash["pagename"]); $pagehash["refs"] = serialize($pagehash["refs"]); // record the time of modification $pagehash["lastmodified"] = time(); if (IsWikiPage($dbi, $pagename)) { $PAIRS = "author='$pagehash[author]'," . "content='$pagehash[content]'," . "created=$pagehash[created]," . "flags=$pagehash[flags]," . "lastmodified=$pagehash[lastmodified]," . "pagename='$pagehash[pagename]'," . "refs='$pagehash[refs]'," . "version=$pagehash[version]"; $query = "UPDATE $dbi[table] SET $PAIRS WHERE pagename='$pagename'"; } else { // do an insert // build up the column names and values for the query $COLUMNS = "author, content, created, flags, " . "lastmodified, pagename, refs, version"; $VALUES = "'$pagehash[author]', '$pagehash[content]', " . "$pagehash[created], $pagehash[flags], " . "$pagehash[lastmodified], '$pagehash[pagename]', " . "'$pagehash[refs]', $pagehash[version]"; $query = "INSERT INTO $dbi[table] ($COLUMNS) VALUES($VALUES)"; } // echo "
Query: $query
\n";
$retval = pg_exec($dbi['dbc'], $query);
if ($retval == false)
echo "Insert/update failed: " . pg_errormessage($dbi['dbc']);
}
function IsWikiPage($dbi, $pagename) {
$pagename = addslashes($pagename);
$query = "select count(*) from $dbi[table] where pagename='$pagename'";
$res = pg_exec($query);
$array = pg_fetch_array($res, 0);
return $array[0];
}
// setup for title-search
function InitTitleSearch($dbi, $search) {
global $search_counter;
$search_counter = 0;
$search = strtolower($search);
$search = addslashes($search);
$query = "select pagename from $dbi[table] where lower(pagename) " .
"like '%$search%' order by pagename";
// echo "search query: $query
\n";
$res = pg_exec($dbi["dbc"], $query);
return $res;
}
// iterating through database
function TitleSearchNextMatch($dbi, $res) {
global $search_counter;
if($o = @pg_fetch_object($res, $search_counter)) {
$search_counter++;
return $o->pagename;
} else {
return 0;
}
}
// setup for full-text search
function InitFullSearch($dbi, $search) {
global $search_counter;
$search_counter = 0;
$search = addslashes($search);
$search = addslashes($search);
$query = "select pagename,content from $dbi[table] " .
"where lower(content) like '%$search%'";
$res = pg_exec($dbi["dbc"], $query);
return $res;
}
// iterating through database
function FullSearchNextMatch($dbi, $res) {
global $search_counter;
if ($hash = @pg_fetch_array($res, $search_counter)) {
$search_counter++;
$page['pagename'] = $hash["pagename"];
$page['content'] = explode("\n", $hash["content"]);
return $page;
}
else {
return 0;
}
}
////////////////////////
// new database features
function IncreaseHitCount($dbi, $pagename) {
return;
$query = "update hitcount set hits=hits+1 where pagename='$pagename'";
$res = mysql_query($query, $dbi['dbc']);
if (!mysql_affected_rows($dbi['dbc'])) {
$query = "insert into hitcount (pagename, hits) " .
"values ('$pagename', 1)";
$res = mysql_query($query, $dbi['dbc']);
}
return $res;
}
function GetHitCount($dbi, $pagename) {
return;
$query = "select hits from hitcount where pagename='$pagename'";
$res = mysql_query($query, $dbi['dbc']);
if (mysql_num_rows($res)) {
$hits = mysql_result($res, 0);
} else {
$hits = "0";
}
return $hits;
}
function InitMostPopular($dbi, $limit) {
return;
$query = "select * from hitcount " .
"order by hits desc, pagename limit $limit";
$res = mysql_query($query);
return $res;
}
function MostPopularNextMatch($dbi, $res) {
return;
if ($hits = mysql_fetch_array($res)) {
return $hits;
} else {
return 0;
}
}
?>