sql_query($sql)) { return "ERROR"; } else { $rowset = $db->sql_fetchrowset($result); return($rowset[0]["total"]); } } function get_user_count($db) { $sql = "SELECT count(user_id) AS total FROM ". USERS_TABLE ." WHERE user_id != ".ANONYMOUS." AND user_level != ".DELETED; if(!$result = $db->sql_query($sql)) { return "ERROR"; } else { $rowset = $db->sql_fetchrowset($result); return($rowset[0]["total"]); } } function get_newest_user($db) { $sql = "SELECT user_id, username FROM ".USERS_TABLE." WHERE user_id != " . ANONYMOUS. " AND user_level != ". DELETED ." ORDER BY user_id DESC LIMIT 1"; if(!$result = $db->sql_query($sql)) { return array("user_id" => "-1", "username" => "ERROR"); } else { $rowset = $db->sql_fetchrowset($result); $return_data = array("user_id" => $rowset[0]["user_id"], "username" => $rowset[0]["username"]); return($return_data); } } function make_jumpbox($db, $phpEx) { $boxstring = "

Jump to: Select Forum "; $sql = "SELECT cat_id, cat_title FROM ".CATEGORIES_TABLE." ORDER BY cat_order"; if($result = $db->sql_query($sql)) { if($total_cats = $db->sql_numrows($result)) { $cat_rows = $db->sql_fetchrowset($result); for($x = 0; $x < $total_cats; $x++) { $boxstring .= " \n"; $boxstring .= "".stripslashes($cat_rows[$x]["cat_title"])."\n"; $boxstring .= "----------------\n"; $f_sql = "SELECT forum_name, forum_id FROM ".FORUMS_TABLE." WHERE cat_id = ". $cat_rows[$x]["cat_id"] . " ORDER BY forum_id"; if($f_result = $db->sql_query($f_sql)) { if($total_forums = $db->sql_numrows($f_result)) { $f_rows = $db->sql_fetchrowset($f_result); for($y = 0; $y < $total_forums; $y++) { $name = stripslashes($f_rows[$y]["forum_name"]); $boxstring .= "$name\n"; } } } else { $boxstring .= "Error!\n"; } } } else { $boxstring .= "No Forums to Jump to\n"; } } else { $boxstring .= "Cat Error\n"; } $boxstring .= "\n

"; return($boxstring); } function get_moderators($db, $forum_id) { $sql = "SELECT u.username, u.user_id FROM " . FORUM_MODS_TABLE ." f, " . USERS_TABLE . " u WHERE f.forum_id = '$forum_id' AND u.user_id = f.user_id"; if($result = $db->sql_query($sql)) { if($total_mods = $db->sql_numrows($result)) { $rowset = $db->sql_fetchrowset($result); for($x = 0; $x < $total_mods; $x++) { $modArray[] = array("id" => $rowset[$x]["user_id"], "name" => $rowset[$x]["username"]); } } else { $modArray[] = array("id" => "-1", "name" => "ERROR"); } } else { $modArray[] = array("id" => "-1", "name" => "ERROR"); } return($modArray); } ?>