Untitled

<html>
<head><title>KoL Documentation v2</title></head>
<body>
<?php

set_magic_quotes_runtime(0);

$dbuser="mydom_chris22";
$dbname="mydomains_koldocs";
$dbhost="localhost";
$dbpass="xxx";

// INITIALIZE DATABASE
mysql_connect ("$dbhost:3306", "$dbuser", "$dbpass");
mysql_select_db ("$dbname");

function grab($tablename, $keyval, $rkey, $thekey = "ID") {

	if($rkey=="*") $query2 = "SELECT * FROM `$tablename` WHERE `$thekey`=\"$keyval\"";
	else $query2 = "SELECT `$rkey` FROM `$tablename` WHERE `$thekey`=\"$keyval\"";
	//echo "<!-- QUERY: $query2 -->\n";
	$qrh2 = mysql_query ($query2);
	$row2 = mysql_fetch_array ($qrh2);
	$nor = mysql_num_rows ($qrh2);
	if ($nor==0) {
		// echo "<!-- Found no rows for query: $query2 -->\n";
		return -1;
	} else {
		if ($rkey!="*") {
			$picked = $row2[0];
			return $picked;
		} else {
			$picked=$row2;
			return $picked;
		}
	}
}

if(!$page) {
	// Show TOC
	echo "<h2>Kingdom of Loathing Documentation</h2><p>\n";

	echo "<font size=2><ul>\n";

	$query="SELECT * FROM `docpages` WHERE parent=0 ORDER BY sequence,title";
	$qrh=mysql_query($query);
	while($row=mysql_fetch_array($qrh)) {
		$thelit=$row["title"];
		$thepage=$row["reftag"];
		echo "<li><a href=$PHP_SELF?page=$thepage>$thelit</a></li>\n";
	}

	echo "</ul></font>\n";


} else {
	// Show requested page, or error message

	$theid=grab("docpages",$page,"ID","reftag");
	$thetitle=grab("docpages",$page,"title","reftag");
	$thedad=grab("docpages",$page,"parent","reftag");
	$theseq=grab("docpages",$page,"sequence","reftag");
	if($thetitle=="-1") $thetitle="I AM ERROR";

	$prev="";
	$next="";

	// 1 - Lowest child of the previous sibling, or previous sibling
	$query3="SELECT * FROM `docpages` WHERE parent=$thedad AND sequence<$theseq ORDER BY sequence DESC LIMIT 1";
	$qrh3=mysql_query($query3);
	if($row=mysql_fetch_array($qrh3)) {
		$previd=$row["ID"];
		$prevref=$row["reftag"];
		$prevname=$row["title"];

		$query4="SELECT * FROM `docpages` WHERE parent=$previd ORDER BY sequence DESC LIMIT 1";
		$qrh4=mysql_query($query4);
		if($row4=mysql_fetch_array($qrh4)) {
			$previd=$row4["ID"];
			$prevref=$row4["reftag"];
			$prevname=$row4["title"];
		}

		$prev="<a href=$PHP_SELF?page=$prevref title=\"$prevname\"><img src=leftarrow.gif></a> ";
	}

	// 2 - Dad
	if($prev=="") {
		$query3="SELECT * FROM `docpages` WHERE ID=$thedad LIMIT 1";
		$qrh3=mysql_query($query3);
		if($row=mysql_fetch_array($qrh3)) {
			$prevref=$row["reftag"];
			$prevname=$row["title"];
			$prev="<a href=$PHP_SELF?page=$prevref title=\"$prevname\"><img src=leftarrow.gif></a> ";
		}
	}


	// 1 - Lowest-sequence child
	$query3="SELECT * FROM `docpages` WHERE parent=$theid ORDER BY sequence LIMIT 1";
	$qrh3=mysql_query($query3);
	if($row=mysql_fetch_array($qrh3)) {
		$nextref=$row["reftag"];
		$nextname=$row["title"];
		$next=" <a href=$PHP_SELF?page=$nextref title=\"$nextname\"><img src=rightarrow.gif></a>";
	}


	// 2 - Next sibling
	if($next=="") {
		$query3="SELECT * FROM `docpages` WHERE parent=$thedad AND sequence>$theseq ORDER BY sequence LIMIT 1";
		$qrh3=mysql_query($query3);
		if($row=mysql_fetch_array($qrh3)) {
			$nextref=$row["reftag"];
			$nextname=$row["title"];
			$next=" <a href=$PHP_SELF?page=$nextref title=\"$nextname\"><img src=rightarrow.gif></a>";
		}
	}

	// 3 - Next sibling for Dad
	if($next=="") {
		$daddad=grab("docpages",$thedad,"parent");
		$dadseq=grab("docpages",$thedad,"sequence");
		//echo "<!-- Curr doc is $theid -- thedad is $thedad -- daddad is $daddad -- dadseq is $dadseq -->\n";
		$query3="SELECT * FROM `docpages` WHERE parent=$daddad AND sequence>$dadseq ORDER BY sequence LIMIT 1";
		//echo "<!-- $query3 -->\n";
		$qrh3=mysql_query($query3);
		if($row=mysql_fetch_array($qrh3)) {
			$nextid=$row["ID"];
			$nextref=$row["reftag"];
			$nextname=$row["title"];
			//echo "<!-- nextid is $nextid and nextref is $nextref -->\n";
			$next=" <a href=$PHP_SELF?page=$nextref title=\"$nextname\"><img src=rightarrow.gif></a>";
		}
	}


	echo "<font size=2><b>\n";
	$finished=0;
	$currdad=$thedad;
	$trail="";
	while(!$finished) {
		$dadtitle=grab("docpages",$currdad,"title");
		$dadref=grab("docpages",$currdad,"reftag");
		if($dadtitle=="-1") {
			$trail="<a href=$PHP_SELF>Documentation Home</a> >> ".$trail;
			$finished=1;
		} else {
			$trail="<a href=$PHP_SELF?page=$dadref>$dadtitle</a> >> ".$trail;
			$daddad=grab("docpages",$currdad,"parent");
			$currdad=$daddad;
		}
	}

	echo "$prev $next<br>\n";
	echo $trail;
	echo "</b>\n";
	echo "<ul>\n";

	$query6="SELECT * FROM `docpages` WHERE parent=$thedad ORDER BY sequence, title";
	$qrh6=mysql_query($query6);
	while($row6=mysql_fetch_array($qrh6)) {
		$theref=$row6["reftag"];
		$thetit=$row6["title"];
		echo "<li>";
		if($theref==$page) echo "<b>";
			else echo "<a href=$PHP_SELF?page=$theref>";
		echo $thetit;
		if($theref==$page) echo "</b>";
			else echo "</a>";
		echo "</li>\n";
		if($theref==$page) {
			// Next level down
			$query2="SELECT * FROM `docpages` WHERE parent=$theid ORDER BY sequence,title";
			$qrh2=mysql_query($query2);
			$nor2=mysql_num_rows($qrh2);
			if($nor2>0) {
				echo "<ul>\n";
				while($row2=mysql_fetch_array($qrh2)) {
					$thelit=$row2["title"];
					$thepage=$row2["reftag"];
					echo "<li><a href=$PHP_SELF?page=$thepage>$thelit</a></li>\n";
				}
				echo "</ul>\n";
			}

		}

	}

	echo "</ul></font><hr>\n";


	echo "<b>$thetitle</b> :: [ <a href=admin.php?action=edit&pageid=$theid>Edit Me</a> ]<p>\n";

	$thetext=grab("docpages",$page,"contents","reftag");
	if($thetext=="-1") $thetext="Sorry, but page '$page' doesn't seem to exist.";

	$thetext=str_replace("[[","<a href=$PHP_SELF?page=",$thetext);
	$thetext=str_replace("|",">",$thetext);
	$thetext=str_replace("]]","</a>",$thetext);

	echo "$thetext<p>\n";

	echo "<center><a href=index.php>Back to TOC</a></center>\n";
}

// Search

echo "<form action=$PHP_SELF method=post>\n";
echo "<b>Search:</b><br>\n";
echo "<input name=searchme type=text value=\"$searchme\"><input type=submit value=Search></form>\n";

if($searchme) {
	echo "<hr>\n";
	echo "<b>Search Results:</b><p>\n";

	$found=0;
	echo "<ul>\n";
	$query="SELECT * FROM `docpages` WHERE title LIKE '%$searchme%'";
	$qrh=mysql_query($query);
	while($row=mysql_fetch_array($qrh)) {
		$found=1;
		$rowref=$row["reftag"];
		$rowname=$row["title"];
		echo "<li><a href=$PHP_SELF?page=$rowref>$rowname</a></li>\n";
	}
	$query="SELECT * FROM `docpages` WHERE contents LIKE '%$searchme%'";
	$qrh=mysql_query($query);
	while($row=mysql_fetch_array($qrh)) {
		$found=1;
		$rowref=$row["reftag"];
		$rowname=$row["title"];
		echo "<li><a href=$PHP_SELF?page=$rowref&searchme=$searchme>$rowname</a></li>\n";
	}
	if(!$found) echo "<li>No results found.</li>\n";
	echo "</ul><p>\n";

}

?>
</body>
</html>