/////////////////////////////////////////////////////////////////////////////////// // // // phpBoard -- Copyright (c) 2000 by Nathan Clemons // // nathan@thelinuxcommunity.org // // // // This program is free software; you can redistribute it and/or modify // // it under the terms of the GNU General Public License as published by // // the Free Software Foundation; either version 2 of the License, or // // (at your option) any later version. // // // // This program is distributed in the hope that it will be useful, // // but WITHOUT ANY WARRANTY; without even the implied warranty of // // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the // // GNU General Public License for more details. // // // // You should have received a copy of the GNU General Public License // // along with this program; if not, write to the Free Software // // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA // // // /////////////////////////////////////////////////////////////////////////////////// require "config_inc.php3"; require $inc_dir . "sql_inc.php3"; require $inc_dir . "lib_inc.php3"; require $inc_dir . $user_lib; $title = "$site_name"; include $inc_dir . "header.php3"; $cookie_name = eregi_replace(" ", "_", $site_name); ?>
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("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("
| Forum Name | Description | Posts in Forum | Latest Post | Moderator(s) | |||
|---|---|---|---|---|---|---|---|
| $group | |||||||
| SQL: $st2 | "); $res2 = SQL_query($st2, $db_link); $rows = SQL_get_aff_rows($db_link, $res2); $row2 = SQL_fetch_array($res2, 0); $mydatetime = $row2["touched"]; $pret_time = make_time($mydatetime); $time_text = "$pret_time | \n"; $clast_name = "$site_name-" . $row["name"] . "-last"; $clast_name = eregi_replace(" ", "_", $clast_name); $clast = $HTTP_COOKIE_VARS["$clast_name"]; if ($clast == "") { $clast = 0; } $cuser = $HTTP_COOKIE_VARS["$cookie_name-username"]; if ($cuser == "") { if ($REMOTE_USER != "") { $cuser = $REMOTE_USER; } } $myunixtime = SQL_unixtime($db_link, $mydatetime); if ($cuser && $clast < $myunixtime) { $pw_img .= "\n"; } print(" | $pw_img | " . $row["name"] . " | " . $row["description"] . " | \n"); print("$posts | $time_text"); if ($row["moderator"] == "") { print("Unmoderated | " . $row["moderator"] . " | \n"); } $last_group = $group; } print("