基于mysql的论坛(2)

  #################################

  ## apply.php ####################

  #################################

  <html>

  <head>

  <title>注册用户</title>

  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">

  <link rel="stylesheet" type="text/css" href="css/index.css">

  </head>

  <body bgcolor="#FFFFFF" background="image/bg.gif">

  <?php include "header.php";?>

  <br>

  <hr noshade width="97%" size="1">

  <div align="center">注册新用户<br>

  </div>

  <table width="90%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#336699" bordercolordark="#FFFFFF" align="center">

  <tr>

  <td colspan="2">

  <div align="center">

  <textarea name="temp" wrap="VIRTUAL" cols="60" rows="8">注册须知:

  

  用户只有注册之后,才能有权发新贴子和回复贴子。非注册用户只能察看贴子。

  注册项目中,带“*”的是您必须填写的项目,其他是可选项目。不过,为了联系方便,最好将资料写的详细一些。

  本论坛不欢迎有关政治敏感话题,如果由此引起纠纷,本论坛使用管理者不负责任。

  在注册之后,每发一篇贴子,增加5点积分,回复一篇,增加3点,被删除一篇,扣除4点。积分只是为了活跃论坛气氛,不代表网友的某方面水平。

  

          制作:冷情疯子</textarea>

  </div>

  </td>

  </tr>

  <tr valign="top">

  <td colspan="2">  </td>

  </tr>

  <tr>

  <td colspan="2">

  <form method="post" action="adduser.php">

  <table width="80%" border="0" cellspacing="0" cellpadding="3" align="center">

  <tr>

  <td align="right">用户名</td>

  <td>

  <input type="text" name="name" maxlength="16" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">

  * </td>

  </tr>

  <tr>

  <td align="right">密码</td>

  <td>

  <input type="password" name="pwd1" maxlength="8" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="9">

  * </td>

  </tr>

  <tr>

  <td align="right">重复密码</td>

  <td>

  <input type="password" name="pwd2" maxlength="8" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="9">

  * </td>

  </tr>

  <tr>

  <td align="right">Email</td>

  <td>

  <input type="text" name="email" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">

  </td>

  </tr>

  <tr>

  <td align="right">性别</td>

  <td>

  <select name="sex">

  <option value="秘密" selected>秘密</option>

  <option value="男">男</option>

  <option value="女">女</option>

  </select>

  </td>

  </tr>

  <tr>

  <td align="right">真实性名</td>

  <td>

  <input type="text" name="realname" size="17" maxlength="16" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">

  </td>

  </tr>

  <tr>

  <td align="right">地址</td>

  <td>

  <input type="text" name="address" maxlength="40" size="30" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">

  </td>

  </tr>

  <tr>

  <td align="right">电话</td>

  <td>

  <input type="text" name="phone" size="22" maxlength="20" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000">

  </td>

  </tr>

  <tr>

  <td align="right">主页</td>

  <td>

  <input type="text" name="homepage" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="50" value="http://">

  </td>

  </tr>

  <tr>

  <td align="right">OICQ</td>

  <td>

  <input type="text" name="oicq" maxlength="11" style="font-size: 9pt; background-color: #FFFFFF; color: #FF0000; border: 1 solid #000000" size="12">

  </td>

  </tr>

  <tr>

  <td align="right">签名</td>

  <td>

  <textarea name="qm" wrap="VIRTUAL" cols="50"></textarea>

  </td>

  </tr>

  <tr>

  <td align="right">  </td>

  <td align="center">

  <input type="submit" name="b1" value="注册">

  <input type="reset" name="Submit2" value="清除" >

  </td>

  </tr>

  </table>

  </form>

  </td>

  </tr>

  </table>

  <br>

  <?php include "footer.php";?>

  </body>

  </html>

  ##########################################

  ## chklogin.php #########################

  ########################################

  <?php

  require ("func.php");

  $name=trim($name);

  $password=trim($password);

  $sql="select * from user where name='$name'";

  $sql_result=mysql_query($sql);

  $sql_row=mysql_fetch_array($sql_result);

  if (($password==$sql_row[password])and(!empty($sql_row[slaveboard]))){

  setcookie("jl_forum[board]",$sql_row[slaveboard]);

  setcookie("jl_forum[name]",$name);

  setcookie("jl_forum[password]",$password);

  redirect2("manage_list.php");

  }

  else {

  show_error(4);

  }

  ?>

  ###################################

  #####  config.inc.php ##########

  #############################

  <?

  $MYSQL_HOSTNAME = "localhost";

  $MYSQL_USERNAME = "root";

  $MYSQL_PASSWORD = "";

  $DATABASE = "forum";

  $pagesize=25;

  $copyright="Copyright © 2000, by Edincur, All Rights Reserved<BR>";

  $admin_email="your_email";

  $admin_name="your_admin_name";         #论坛管理员名称

  $admin_password="your_password";       #论坛管理员密码

  $remove_score=4;  #被删除一篇扣除的分数

  $new_topic_score=5;   #发表新主题的分数

  $re_topic_score=3;   #回复一篇的分数

  mysql_connect($MYSQL_HOSTNAME, $MYSQL_USERNAME, $MYSQL_PASSWORD);

  mysql_select_db($DATABASE) or die(mysql_error());

  ?>

  ###############################

  #