include_once "include/db_mysql.php"; include_once "include/common.php"; $conn = db_connect($h, $p, $u, $db); $bid = $_GET['bid']; $tid = $_GET['tid']; if (!is_numeric($bid) || !is_numeric($tid)) { $error = $ERR['NO_PARAM']; showerrpage($error); exit; } $show_info = ""; $sql = "select board_name,content,DATE_FORMAT(post_time,'%Y-%m-%d %H:%i') "; $sql .= "as post_time from topics,boards where bid=boards.id and bid={$bid} and topics.id={$tid}"; $result = mysql_query($sql) or die("ERROR: " . mysql_error() . " <br/>SQL=" . $sql); if ($num = mysql_num_rows($result)) { $row = mysql_fetch_array($result); $board_name = $row['board_name']; $content = $row['content']; $content = str_replace("<br> ", "\r\n", $content); $post_time = $row['post_time']; } else { $error = $ERR['NO_PARAM']; showerrpage($error); exit; } $html_title = $HTML_TITLE['mod']; $board_name_list = getBoardList(); $user_rank_list = userRank($bid); close_db($conn); include_once "template/mod_topic.htm";
$conn = db_connect($h, $p, $u, $db); $user_name = $_POST['username']; $passwd = $_POST['passwd']; $passwd1 = $_POST['passwd1']; $email = $_POST['email']; $come_from = $_POST['from']; if (empty($user_name) || empty($passwd) || empty($passwd1) || empty($email) || empty($come_from)) { $err_info = '注册中的每一项都必须填写或选择!'; showerrpage($err_info); exit; } if ($passwd != $passwd1) { $err_info = '两次填写的密码不一致!'; showerrpage($err_info); exit; } $pwd = md5($passwd); $sql = "select user_id from users where user_name='" . mysql_escape_string($user_name) . "'"; $result = mysql_query($sql) or die('ERROR: ' . mysql_error()); if (mysql_num_rows($result) > 0) { $err_info = '该用户名已经存在,请更换!'; showerrpage($err_info); exit; } $reg_ip = $_SERVER["REMOTE_ADDR"]; $sql = "insert into users set user_name='" . mysql_escape_string($user_name) . "',passwd='" . mysql_escape_string($pwd) . "',email='" . mysql_escape_string($email) . "',reg_ip='" . $reg_ip . "',reg_time=NOW(),come_from='" . $come_from . "'"; mysql_query($sql) or die('ERROR: ' . mysql_error()); mysql_free_result($result); mysql_close(); header("location: index.php"); //注册成功将跳转到论坛首页