func.php

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

<?

function ReadUserid() {
  global $ONLINE_TABLE,$DEFAULT_ID,$DEFAULT_USER;
  global $id,$userid,$nickname,$sex,$email,$sign,$login_time,$login_ip;

  if (($id) and ($id!=$DEFAULT_ID)) {
    $SQL="SELECT * FROM $ONLINE_TABLE WHERE id='$id'";

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

    $row=mysql_fetch_Array($result);

    $userid=$row[userid];
    $nickname=$row[nickname];
    $sex=$row[sex];
    $email=$row[email];
    $sign=$row[sign];
    $login_time=$row[login_time];
    $login_ip=$row[login_ip];
  } else {
    $id=$DEFAULT_ID;
    $userid=$DEFAULT_USER;
    $nickname="社区游客";
  }
}


function CheckAdmin() {
  global $ADMIN;
  global $userid;

  if ($userid!=$ADMIN) {
    header("Location: error.php?code=11\n");
    exit;
  }
}


function CheckDemo() {
  global $DEFAULT_USER;
  global $userid;

  if ($userid==$DEFAULT_USER) {
    header("Location: error.php?code=11\n");
    exit;
  }
}


function ReadBlock() {
  global $BLOCK_TABLE,$ADMIN;
  global $blockid,$english,$chinese,$admin,$sysop,$op,$blockok;

  if ($blockid!=0) {
    $SQL="SELECT * FROM $BLOCK_TABLE WHERE blockid='$blockid'";

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

    $row=mysql_fetch_Array($result);

    $english=$row[english];
    $chinese=$row[chinese];
    $admin=$row[admin];
    $sysop=$row[sysop];
    $op=$row[op];
    $blockok=$row[blockok];
  } else {
    $english="apply";
    $chinese="版务申请";
    $admin=$ADMIN;
    $sysop=$ADMIN;
  }
}


function ReadData() {
  global $BBS_TABLE;
  global $bbsid,$mood,$title,$content,$writer;

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

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

  $row=mysql_fetch_Array($result);

  $mood=$row[mood];
  $title=$row[title];
  $content=ReadReplace($row[content]);
  $writer=$row[writer];
}


function ReadSignature() {
  global $USER_ATTR_TABLE;
  global $userid,$s_no,$signature,$signature1,$signature2,$signature3;

  $SQL="SELECT signature1,signature2,signature3 FROM $USER_ATTR_TABLE WHERE userid='$userid'";

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

  $row=mysql_fetch_Array($result);

  $signature1=$row[signature1];
  $signature2=$row[signature2];
  $signature3=$row[signature3];

  switch ($s_no) {
    case 1:
      $signature=$signature1;
      break;
    case 2:
      $signature=$signature2;
      break;
    case 3:
      $signature=$signature3;
      break;
    default:
      $signature="";
      break;
  }
}


function ReadProc($S,$Re) {
  $pieces=explode("\n",$S);
  $size=count($pieces);

  $S="";
  for ($i=0;$i<$size;$i++) {
      if (eregi("∶",$pieces[$i]) and ($Re==1)) $S.="<FONT class=wdBlue>".$pieces[$i]."</FONT><BR>\n";
        else $S.=$pieces[$i]."<BR>\n";
  }
  return $S;
}


function AddData() {
  global $BBS_TABLE;
  global $bbsid,$mainid,$blockid,$mood,$title,$content,$size,$writer,
         $signature,$writetime,$read_value,$sub_value,$hot_value,
         $bbsmail,$bbssub,$bbsok,$bbsprime;

  $content=WriteReplace($content,0);

  ReadSignature();

  $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 (
          '$bbsid','$mainid','$blockid','$mood','$title','$content','$size','$writer',
          '$signature','$writetime','$read_value','$sub_value','$hot_value',
          '$bbsmail','$bbssub','$bbsok','$bbsprime'
        )";

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


function UpdateUserSign() {
  global $USER_TABLE,$ONLINE_TABLE;
  global $id,$userid,$s_no;

  $SQL="UPDATE $USER_TABLE SET sign='$s_no' WHERE userid='$userid'";

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

  $SQL="UPDATE $ONLINE_TABLE SET sign='$s_no' WHERE id='$id'";

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


function WriteReplace($S,$Html) {
  $S=str_replace("\\\\", "＼", $S);

  if ($Html!=1) {
    $S=str_replace("<", "&lt;", $S);
    $S=str_replace(">", "&gt;", $S);
  }
  return($S);
}


function ReadReplace($S) {
  $S=str_replace("＼＼", "\\", $S);
  $S=str_replace("＼", "", $S);
  return($S);
}


function SendMail() {
  global $MAIL_INFO,$MAIL_FROM;
  global $email,$title,$content;

  $subject="Fw: ".$title;
  $content.=$MAIL_FROM;

  mail($email,$subject,$content,$MAIL_INFO);
}


?>