\n"); print(""); print("\n"); print(""); print("\n"); print(""); print("\n"); print(""); print("\n"); print(""); print("\n"); print(""); print("\n"); print("\n"); print("
bgcolor bgtext
thcolor trcolor
trcolor1 trcolor2
mod_color adm_color
link vlink
alink

\n"); print("

Welcome to the phpBoard demo site!

\n"); // connect to the server $db_link = SQL_connect(); if ($use_category_groups) { // form the select statement $statement = "SELECT * FROM categories ORDER BY catgroup, name"; } else { // form the select statement $statement = "SELECT * FROM categories ORDER BY name"; } // output it... helpful for debugging purposes... //print("

SQL Statement: $statement

"); $db_result = SQL_query($statement, $db_link); // find out how many results there were... $aff_rows = SQL_get_aff_rows($db_link, $db_result); //print("
There are currently $aff_rows categories.

\n"); $is_index = 1; top_bar(); // from lib_inc.php3 if ($aff_rows == 0) { print("

No categories found in this database... have you created them in the admin interface?\n"); SQL_close($db_link); include $inc_dir . "footer.php3"; exit; } print("\n"); print("\n"); // get each row for ($db_row = 0; $db_row < $aff_rows; $db_row++) { $row = SQL_fetch_array($db_result, $db_row); $group = $row["catgroup"]; $name = $row["name"]; if ((($db_row == 0) || ($group != $last_group)) && $use_category_groups) { print(""); } if ($db_row % 2) { print("\n"); } else { print("\n"); } $ref = $site_url . "browse" . $ext . "?category=" . urlencode($row["name"]); if ($row["password"]) { $pw_img = ""; } else { $pw_img = ""; } print("\n"); $st2 = "SELECT id FROM articles WHERE category='" . $row["name"] . "' AND approved=" . $row["moderated"]; $res = SQL_query($st2, $db_link); $posts = SQL_get_aff_rows($db_link, $res); print(""); if ($posts > 0) { $st2 = "SELECT posted FROM articles WHERE category='" . $row["name"] . "' AND approved=" . $row["moderated"] . " ORDER BY posted DESC"; //print(""); $res2 = SQL_query($st2, $db_link); $rows = SQL_get_aff_rows($db_link, $res2); $row2 = SQL_fetch_array($res2, 0); $mydatetime = $row2["posted"]; $pret_time = make_time($mydatetime); print("\n"); } else { print("\n"); } if ($row["moderator"] == "") { print("\n"); } else { print("\n"); } $last_group = $group; } print("
Forum NameDescriptionPosts in ForumLatest PostModerator(s)
$group
$pw_img" . $row["name"] . "" . $row["description"] . "$postsSQL: $st2  $pret_timeUnmoderated
" . $row["moderator"] . "
\n"); print("

"); print("// Some basic config values for the HTML display of the\n"); print("// phpBoard\n"); if ($link != "") { print("\$link = '$link';\n"); } else { print("//\$link = '';\n"); } if ($alink != "") { print("\$alink = '$alink';\n"); } else { print("//\$alink = '';\n"); } if ($vlink != "") { print("\$vlink = '$vlink';\n"); } else { print("//\$vlink = '';\n"); } if ($bgcolor != "") { print("\$bgcolor = '$bgcolor';\n"); } else { print("//\$bgcolor = '';\n"); } if ($thcolor != "") { print("\$thcolor = '$thcolor';\n"); } else { print("//\$thcolor = '';\n"); } if ($trcolor != "") { print("\$trcolor = '$trcolor';\n"); } else { print("//\$trcolor = '';\n"); } if ($trcolor1 != "") { print("\$trcolor1 = '$trcolor1';\n"); } else { print("//\$trcolor1 = '';\n"); } if ($trcolor2 != "") { print("\$trcolor2 = '$trcolor2';\n"); } else { print("//\$trcolor2 = '';\n"); } if ($bgtext != "") { print("\$bgtext = '$bgtext';\n"); } else { print("//\$bgtext = '';\n"); } if ($bgimg != "") { print("\$bgimg = '$bgimg';\n"); } else { print("//\$bgimg = '';\n"); } if ($font_face != "") { print("\$font_face = '$font_face';\n"); } else { print("//\$font_face = '';\n"); } if ($mod_color != "") { print("\$mod_color = '$mod_color';\n"); } else { print("//\$mod_color = '';\n"); } if ($adm_color != "") { print("\$adm_color = '$adm_color';\n"); } else { print("//\$adm_color = '';\n"); } print(""); SQL_close($db_link); // that's all for the moment, folks... include $inc_dir . "footer.php3"; ?>