bbsadd.php

这是使用ＰＨＰ编程的虚拟社区ＭySQL的简易版

<?
  include "config.inc.php";
  include "func.php";

function UpdateUserAttr() {
  global $USER_ATTR_TABLE;
  global $userid;

  $SQL="SELECT * FROM $USER_ATTR_TABLE WHERE userid='$userid'";

  $result=mysql_query($SQL) or die(mysql_error());
  $row=mysql_fetch_Array($result);

  $exper_cent=$row[exper_cent];
  $act_cent=$row[act_cent];
  $article=$row[article];

  $exper_cent++;                           //  经验值 +1
  $act_cent+=5;                            //  表现值 +5
  $article++;                              //  发表文章篇数 +1

  $SQL="UPDATE $USER_ATTR_TABLE SET
          article='$article',exper_cent='$exper_cent',act_cent='$act_cent'
        WHERE userid='$userid'";

  $result=mysql_query($SQL) or die(mysql_error());
}

  ReadUserid();
  CheckDemo();

if ($Ok) {
  $writetime=time();
  $bbsid=$writetime;
  $mainid=$bbsid;
  $size=strlen($content);
  $sub_value=0;
  $bbssub=0;
  $writer=$userid;
  ($bbsmail) ? $bbsmail=1 : $bbsmail=0;

  AddData();
  UpdateUserSign();
  UpdateUserAttr();

  header("Location: bbslist.php?id=$id&blockid=$blockid\n");
  exit;
} else {
  ReadBlock();
}

  include "header.inc.php";
  include "ad.php";
?>

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=25%>　　版主： <A href=who.php?ID=<? echo $sysop.">".$sysop; ?></A></TD>
    <TD width=50%>讨论区： <FONT color=red><? echo $chinese."( ".$english." )"; ?></FONT></TD>
    <TD width=25% align=center><FONT color=#2F8BDF>●</FONT> 发表文章</TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=100% size=1>

<FORM name=AddForm method=POST action=<? echo $PHP_SELF; ?>>
  <TABLE width=95% border=0 cellpadding=2 cellspacing=2 align=center>
    <TR class=wdBlack bgcolor=<? echo $HEADER_COLOR; ?>>
      <TD height=20>&nbsp;</td>
    </TR>
    <TR class=wdBlack>
      <TD height=32>主题： <INPUT type=text name=title size=50 maxlength=50 class=wdBlack value=<? echo $title; ?>> <FONT color=red>*</FONT> 　<INPUT type=checkbox name="bbsmail">转信</TD>
    </TR>
    <TR class=wdBlack>
      <TD> 签名：
        <INPUT type=radio name="s_no" value="1"<? echo ($sign==1) ? " checked" : ""; ?>> A
        <INPUT type=radio name="s_no" value="2"<? echo ($sign==2) ? " checked" : ""; ?>> B
        <INPUT type=radio name="s_no" value="3"<? echo ($sign==3) ? " checked" : ""; ?>> C
        <INPUT type=radio name="s_no" value="0"<? echo ($sign==0) ? " checked" : ""; ?>> 不使用
      </TD>
    </TR>
    <TR class=wdBlack></TR>
    <tr class=wdBlack>
      <TD width=70%>
        <TEXTAREA name="content" cols=70 rows=10 wrap=OFF class=wdBlack><? echo $content; ?></TEXTAREA>
      </TD>
      <TD width=30%>
        <TABLE width=80% border=0 align=right>
          <TR>
            <TD width=68>
              <INPUT type=radio value=0 name="mood" checked><IMG src=images/mood0.gif width=15 height=15 alt=" 心情不错！">
            </TD>
            <TD width=68>
              <INPUT type=radio value=1 name="mood"><IMG src=images/mood1.gif width=15 height=15 alt=" 随便说说... ">
            </TD>
          </TR>
          <TR>
            <TD width=68>
              <INPUT type=radio value=2 name="mood"><IMG src=images/mood2.gif width=15 height=15 alt=" 谁来帮助我？">
            </TD>
            <TD width=68>
              <INPUT type=radio value=3 name="mood"><IMG src=images/mood3.gif width=15 height=15 alt=" 呜呜~~我好伤心！">
            </TD>
          </TR>
          <TR>
            <TD width=68>
              <INPUT type=radio value=4 name="mood"><IMG src=images/mood4.gif width=15 height=15 alt=" 哼！气死我了！">
            </TD>
            <TD width=68>
              <INPUT type=radio value=5 name="mood"><IMG src=images/mood5.gif width=15 height=15 alt=" 嘻嘻，开心！">
            </TD>
          </TR>
          <TR>
            <TD width=68>
              <INPUT type=radio value=6 name="mood"><IMG src=images/mood6.gif width=15 height=15 alt=" 对面的人儿看过来... ">
            </TD>
            <TD width=68>
              <INPUT type=radio value=7 name="mood"><IMG src=images/mood7.gif width=15 height=15 alt=" 当心！！！">
            </TD>
          </TR>
          <TR>
            <TD width=68>
              <INPUT type=radio value=8 name="mood"><IMG src=images/mood8.gif width=15 height=15 alt=" 同意！">
            </TD>
            <TD width=68>
              <INPUT type=radio value=9 name="mood"><IMG src=images/mood9.gif width=15 height=15 alt=" 我反对！">
            </TD>
          </TR>
          <TR>
            <TD width=68>
              <INPUT type=radio value=10 name="mood"><IMG src=images/mood10.gif width=15 height=15 alt=" 号外！号外！">
            </TD>
            <TD width=68>
              <INPUT type=radio value=11 name="mood"><IMG src=images/mood11.gif width=15 height=15 alt=" 我来回答你！">
            </TD>
          </TR>
          <TR>
            <TD width=68>
              <INPUT type=radio value=12 name="mood"><IMG src=images/mood12.gif width=15 height=15 alt=" 咦？奇怪！">
            </TD>
            <TD width=68>
              <INPUT type=radio value=13 name="mood"><IMG src=images/mood13.gif width=15 height=15 alt=" 不知所云... ">
            </TD>
          </TR>
        </TABLE>
      </TD>
    </TR>
    <TR>
      <TD> 　　　　
        <INPUT type=submit name=Ok value=" 发送 " class=wdBlack>          　　　　　　　　　
        <INPUT type=button name=Back value=" 返回 " class=wdBlack onClick=JavaScript:history.back()>
        <INPUT type="hidden" name="id" value="<? echo $id; ?>">
        <INPUT type="hidden" name="blockid" value="<? echo $blockid; ?>">
      </TD>
    </TR>
  </TABLE>
</FORM>

<HR color=#E3E3E3 noshade width=100% size=1>

<DIV class=wdBlack align=center><? echo $COPYRIGHT; ?></DIV><BR>

</BODY>
</HTML>