当前位置:Gxlcms > PHP教程 > 社区(php&&mysql)一

社区(php&&mysql)一

时间:2021-07-01 10:21:17 帮助过:119人阅读

function cook_cooloff(){
  global $php_SELF,$aid,$pgno;
  setcookie("OPEN_LIST",0,time()+ 31536000);
  Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");
  exit;
}
//===============================================================
function cook_coolon(){
  global $PHP_SELF,$aid,$pgno;
  setcookie("OPEN_LIST",1,time()+ 31536000);
  Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");
  exit;
}
function check_mail($semail)
{
  $str=strchr($semail,'@'); 
  if ($str=="") return false;
  $str=strchr($semail,".");
  if ($str=="") return false;
  return true;
}
//================================================================
function addhitviews($sid,$rid) {
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=MySQL_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  if($sid==$rid)   $qsql="SELECT * from bbs_subj where id='$rid'";
  else $qsql="SELECT * from bbs_docs where id='$rid'";
  $rs=mysql_db_query($sql['db'],$qsql);
  $row=mysql_fetch_array($rs);
  $views=$row['views'];
  $views++;
  if($sid==$rid)   $qsql="UPDATE bbs_subj SET views='$views' where id='$rid'";
  else $qsql="UPDATE bbs_docs SET views='$views' where id='$rid'";
  
  mysql_db_query($sql['db'],$qsql);
}

//===============================================================
function mail_list(){
  global $PHP_SELF,$HTTP_HOST,$email;
  global $aid,$sid,$rid;
  global $way1,$way2;
  
  if(check_mail($email)) {
  $mailtype=0; //璹綷
  if(strlen($way2)) $mailtype=1;//

  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  if($mailtype==0) { //璹綷
    $qsql="SELECT * from bbs_sml where sid='$sid' AND email='$email'";
    $rs=mysql_db_query($sql['db'],$qsql);
    if(mysql_num_rows($rs)==0) { //临⊿
     $qsql="INSERT INTO bbs_sml (sid,email) values('$sid','$email')";
     $rs=mysql_db_query($sql['db'],$qsql);
    } else {
     echo "
     
     ";  
    }
  } else { //璹綷
    $qsql="SELECT * from bbs_sml where sid='$sid' AND email='$email'";
    $rs=mysql_db_query($sql['db'],$qsql);
    if(mysql_num_rows($rs) > 0) { //虫
     $qsql="DELETE FROM bbs_sml where sid='$sid' AND email='$email'";
     $rs=mysql_db_query($sql['db'],$qsql);
    } else {
     echo "
     
     ";

    }

  }

  } else {
    echo "
     
     "; 
  }
  echo "
     
     "; 
}

//===============================================================
function Send_the_doc_to_mail_list($aid,$sid,$rid){
  global $PHP_SELF,$HTTP_HOST;
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']); 
  if($sid==$rid)   $qsql="SELECT * from bbs_subj where id='$sid'";
  else $qsql="SELECT * from bbs_docs where id='$rid'";
    
  $rs=mysql_db_query($sql['db'],$qsql);
  $row=mysql_fetch_array($rs);
  $poster=$row['poster'];
  $banner=$row['banner'];
  $body=$row['body'];

  $subj=$c_poster."ㄓ璹綷ゅ彻";
  $message=":$poster\n";
  $message.="ゅ彻夹肈:$banner\n";
  $message.="ゅ彻ず甧:$body\n";
  $message.="\nㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid\n";
  $message.="<<舧>>\n";
  $mailfrom="From:Magic Jerry";


  $qsql="SELECT * from bbs_sml where sid='$sid'";
  $rs=mysql_db_query($sql['db'],$qsql);
  while($row=mysql_fetch_array($rs)) { //mail_list
    $email=$row['email'];
    mail($email,$subj,$message,$mailfrom);
    echo $email;
  }
  //盚倒恨瞶
  $qsql="SELECT * from bbs_area where id='$aid'";
  $rs=mysql_db_query($sql['db'],$qsql);
  $row=mysql_fetch_array($rs);
  $email=$row['email'];
  $banner=$row['banner'];

  mail($email,"$banner 穝秈ゅ彻",$message,$mailfrom);


}
//===============================================================
function mail_friend(){
  global $PHP_SELF,$HTTP_HOST,$c_email,$c_poster,$frmail;
  global $aid,$sid,$rid;
  if(check_mail($frmail)) {
  $DROOT=getenv('DOCUMENT_ROOT');
  include("sql.php3");
  $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
  if($sid==$rid) { 
    $qsql="SELECT * from bbs_subj where id='$rid' ";
  } else {
    $qsql="SELECT * from bbs_docs where id='$rid' ";
  }
  $rs=mysql_db_query($sql['db'],$qsql);
  $row=mysql_fetch_array($rs);
  
  $banner=$row['banner'];
  $body=$row['body'];
  
  $subj=$c_poster."ざ残ゅ彻";
  $message="狟ね: $c_poster ざ残硂ゅ彻\n";
  $message.="ゅ彻夹肈:$banner\n";
  $message.="ゅ彻ず甧:$body\n";
  $message.="\nㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF?proc=view&sid=$sid&aid=$aid&rid=$rid\n";
  $message.="<<舧>>\n";
  $mailfrom="From:".$c_email;
  
  mail($frmail,$subj,$message,$mailfrom);
  }else {
    echo "
     
     "; 
  }
  //echo "rid=$rid a=$aid s=$sid p=$pgno";
  
  echo "
     
     "; 
}

待续......

人气教程排行