.
*/
define("MODULE_FAIL", "You cannot access this module directly.
\n",true);
if(!defined("MODULE_FILE"))
{
die(MODULE_FAIL);
}
global $db;
/**
* List available pages.
* Only right now I don't know if the _pages table has been deprecated.
* I'm confused. -jhunk
*/
if(isset($_GET['list']))
{
if($_GET['list'] == "true")
{
$result = $db->Query("SELECT title, page_id FROM bayonet_articles");
while(($row = $db->Fetch($result)) !== false)
{
$pages[] = $row;
}
mysql_free_result($result);
OpenTable();
echo "Page Map
";
echo "";
echo "
";
foreach($pages as $page)
{
echo "- " . LinkPage($page['page_id'], $page['title']) . "
";
}
echo "
";
echo "
\n");
// return 1;
$id = 1; //makes it so that the default page is the home page
}else{
$id = $_GET['id'];
}
$result = $db->Query("SELECT u.username AS author, p.page_created, p.title, p.text FROM `bayonet_pages` AS p LEFT OUTER JOIN `bayonet_users` AS u ON u.user_id = p.author_id WHERE p.page_id = '$id'");
$proceed = mysql_num_rows($result);
if($proceed > 0)
{
while(($row = $db->Fetch($result))!==false)
{
$page = $row;
OpenTable();
echo "";
$aresult = $db->Query("SELECT * FROM `bayonet_articles` WHERE `page_id` = $id ORDER BY `weight` ASC");
while(($article = $db->Fetch($aresult))!==false)
{
$articleTitle = $article['title'];
echo '
'.$articleTitle.'
';
//echo "".$article['title']."
";
echo BBCode($article['text']);
}
echo "";
CloseTable();
}
?>
\n");
}
?>