bbsreply.php

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

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

function UpdateUserAttr() {
  global $USER_ATTR_TABLE;
  global $userid,$article,$exper_cent,$act_cent;

  $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());
}


function UpdateSubvalue() {
  global $BBS_TABLE;
  global $mainid;

  $SQL="SELECT sub_value FROM $BBS_TABLE WHERE bbsid='$mainid'";

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

  $sub_value=$row[sub_value];
  $sub_value++;

  $SQL="UPDATE $BBS_TABLE SET sub_value='$sub_value' WHERE bbsid='$mainid'";

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


function ReplyProc() {
  global $title,$writer,$content;

  $title="Re: ".$title;

  $pieces=explode("\n",$content);
  $size=count($pieces);

  $content="　在【 ".$writer." 】的大作中提到：\n　　∶　\n";

  for ($i=0;$i<$size;$i++) {
    $content.="　　∶　".$pieces[$i]."\n";
  }
}


  ReadUserid();
  CheckDemo();

if ($Ok) {
  $writetime=time();
  $bbsid=$writetime;
  $writer=$userid;
  $bbssub=1;

  AddData();
  UpdateUserSign();

  UpdateSubvalue();
  UpdateUserAttr();

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

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

<TABLE width=100% border=0 align=center>
  <TR class=wdBlack>
    <TD width=40%>　　版主： <A href=who.php?<? echo $sysop.">".$sysop; ?></A></TD>
    <TD width=35%>讨论区： <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 colspan=2 height=20>&nbsp;</td>
    </TR>
    <TR class=wdBlack>
      <TD colspan=2 height=32>主题： <INPUT type=text name=title size=50 maxlength=50 class=wdBlack value="<? echo $title; ?>"> <FONT color=red>*</FONT> 　<INPUT type=checkbox name=IsMail>寄一份给原作者</TD>
    </TR>
    <TR class=wdBlack>
      <TD colspan=2> 签名：
        <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; ?>">
        <INPUT type="hidden" name="mainid" value="<? echo $mainid; ?>">
        <INPUT type="hidden" name="bbsid" value="<? echo $bbsid; ?>">
      </TD>
    </TR>
  </TABLE>
</FORM>

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

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

</BODY>
</HTML>