File: /home/awaldron/www/archive/demo/guidebook/toc.php
<?php
echo "<div class=\"headline\">".$gbtitle." : Table of Contents</div>\n";
echo "<div class=\"pagebody\">\n";
echo "<P>".format_body(quickSQL("SELECT gb_intro FROM tbl_guidebooks WHERE gb_id=".$gb));
echo "<center><P><table width=100% border=0 cellspacing=0 cellpadding=0>\n";
echo "<tr><td valign=\"top\" width=50%><div class=\"pagebody\">\n";
$sql = "SELECT * FROM tbl_gbtabs WHERE gb_id=".$gb." ORDER BY gbtab_col ASC, gbtab_rank ASC";
$res = mysql_query($sql);
$numtabs = mysql_num_rows($res);
$col = 1;
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
if ($row["gbtab_col"] != $col) {
echo "</div></td><td valign=\"top\" width=50%><div class=\"pagebody\">\n";
$col = 2;
}
if (!check_pgroup($_SESSION[auth_user],$gbadmins)) $add = "";
else $add = " (<a href=\"content_add.php?gb=".$gb."&tab=".$row["gbtab_id"]."\">+</a>)";
echo "<P><span class=\"subhead\"><span id=\"vred\">".$row["gbtab_name"]."</span></span>".$add."\n";
$sql2 = "SELECT * FROM tbl_pages WHERE gbtab_id=".$row["gbtab_id"]." AND page_active=1 ORDER BY page_rank ASC";
$res2 = mysql_query($sql2);
echo "<ul>";
for ($j=0; $j < mysql_num_rows($res2); $j++) {
$page = mysql_fetch_array($res2);
echo "<li style=\"line-height:16px\"><a href=\"page.php?gb=".$gb."&tab=".$row["gbtab_id"]."&p=".$page["page_id"]."\">".$page["page_title"]."</a>\n";
}
echo "</ul>\n";
}
echo "</div></td></tr></table><br><br><br>\n";
//echo "<tr><td colspan=2 align=\"center\"><br><br><br><br>\n";
//echo "<b>Guidebook Administration:</b> <a href=\"#\">Add a Tab</a> | <a href=\"#\">Rank Tabs</a> | <a href=\"#\">Edit Title/Introduction</a>\n";
//echo "</td></tr></table>\n";
echo "</div>\n";
?>