bbscopyok.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+=1;                            //  表现值 +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 ReadBlockList() {
  global $BLOCK_TABLE;
  global $classid,$classname,$block,$english,$chinese,$count;

  $SQL="SELECT english,chinese FROM $BLOCK_TABLE WHERE blockid='$classid'";

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

  $row=mysql_fetch_Array($result);

  $classname=$row[chinese]."( ".$row[english]." )";

  $SQL="SELECT * FROM $BLOCK_TABLE WHERE classid='$classid'";

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

  $count=mysql_numrows($result);

  for ($i=0;$i<$count;$i++) {
    $row=mysql_fetch_Array($result);

    $block[$i]=$row[blockid];
    $english[$i]=$row[english];
    $chinese[$i]=$row[chinese];
  }
}


function PrintBlockList() {
  global $BODY_COLOR;
  global $id,$blockid,$block,$english,$chinese,$count;

  $size=$count/2;

  for ($i=0; $i<$size; $i++) {
    echo "<TR class=wdBlack>\n";
    for ($j=$i*2; $j<($i+1)*2; $j++) {
      if ($block[$j]!=$blockid) {
        if ($j<$count) echo "<TD width=50% height=24>　<INPUT type=\"checkbox\" name=\"newblockid\" value=\"$block[$j]\">$chinese[$j]($english[$j])</TD>\n";
        else echo "<TD width=50% height=24>&nbsp;</TD>\n";
      }
    }
    echo "</TR>\n";
  }
}


function CopyData() {
  global $BBS_TABLE;
  global $bbsid,$newblockid;

  $SQL="SELECT mood,title,content,size,writer,writetime,signature
        FROM $BBS_TABLE
        WHERE bbsid='$bbsid'";

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

  $row=mysql_fetch_Array($result);

  $mood=$row[mood];
  $size=$row[size];
  $writer=$row[writer];
  $writetime=$row[writetime];
  $signature=$row[signature];

  $newid=time();
  $mainid=$newid;
  $sub_value=0;
  $bbssub=0;
  $bbsmail=0;

  $title="转贴：".$row[title];
  $content=str_replace("'", "\'", $row[content]);

  $SQL="INSERT INTO $BBS_TABLE (
          bbsid,mainid,blockid,mood,title,content,size,writer,
          signature,writetime,read_value,sub_value,hot_value,
          bbsmail,bbssub,bbsok,bbsprime
        ) VALUES (
          '$newid','$mainid','$newblockid','$mood','$title','$content','$size','$writer',
          '$signature','$writetime','$read_value','$sub_value','$hot_value',
          '$bbsmail','$bbssub','$bbsok','$bbsprime'
        )";

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


  ReadUserid();
  CheckDemo();

  ReadBlockList();

if ($Ok) {
  if (!$newblockid) $err=22;
  if (!isset($err)) {
    CopyData();
    UpdateUserAttr();
    header("Location: ok.php?id=$id&blockid=$blockid&mainid=$mainid&code=3\n");
  } else {
    //  失败页面
    header("Location: error.php?code=$err\n");
  }
  exit;
}
  include "header.inc.php";
  include "ad.php";
?>

<TABLE width=95% border=0 align=center>
  <TR class=wdBlack>
    <TD width=25%>　<FONT class=wdBlue>●</FONT> 转贴文章</TD>
    <TD width=50%></TD>
    <TD width=25% align=center></TD>
  </TR>
</TABLE>

<HR color=#E3E3E3 noshade width=92% size=1>
<BR>
<DIV class=wdBlack align=center>您所在的版区：　<FONT color=red><? echo $classname; ?></FONT>　　　请选择您想要转贴的讨论区：</DIV>
<FORM 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>
<?
  PrintBlockList();
?>
    <TR>
      <TD align=center>
        <INPUT type="submit" name="Ok" value=" 确定 " class="wdBlack">
        <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>
<BR>
<DIV align="center"><a href="JavaScript: history.back()">&lt;&lt;返回&gt;&gt;</a></DIV>

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

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

</BODY>
</HTML>