ѧԺÊ×Ò³>ÍøÂç±à³Ì>PHP>ÉçÇø(php&&mysql)Ò»

ÉçÇø(php&&mysql)Ò»

×÷Õߣº À´Ô´£º²»Ïê Ìí¼Óʱ¼ä£º2006-5-25 20:44:40
  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; //­q¾\
 if(strlen($way2)) $mailtype=1;//¨ú®ø

 $DROOT=getenv('DOCUMENT_ROOT');
 include("sql.php3");
 $db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);  
 if($mailtype==0) { //­q¾\
  $qsql="SELECT * from bbs_sml where sid='$sid' AND email='$email'";
  $rs=mysql_db_query($sql['db'],$qsql);
  if(mysql_num_rows($rs)==0) { //ÁÙ¨S¥[¤J
 $qsql="INSERT INTO  bbs_sml (sid,email) values('$sid','$email')";
 $rs=mysql_db_query($sql['db'],$qsql);
  } else {
 echo "
 <script language=javascript>
 alert('§A¤w¸g¥[¤J,¤£»Ý­«½Æ¥[¤J');
 </script>
";  
  }
 } else { //¨ú®ø­q¾\
  $qsql="SELECT * from bbs_sml where sid='$sid' AND email='$email'";
  $rs=mysql_db_query($sql['db'],$qsql);
  if(mysql_num_rows($rs) > 0) { //¤w¦b¦W³æ
 $qsql="DELETE FROM  bbs_sml where sid='$sid' AND email='$email'";
 $rs=mysql_db_query($sql['db'],$qsql);
  } else {
 echo "
 <script language=javascript>
alert('©|¥¼¦b¦W³æ¤º!');
 </script>
";

  }

 }

 } else {
  echo "
 <script language=javascript>
  alert('E-mail®æ¦¡¿ù»~');
 </script>
";  
 }
 echo "
 <script language=javascript>
 document.location='$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid'
 </script>
";  
}

//===============================================================
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."¨Ó¦Û­q¾\ªº¤å³¹";
 $message="§@ªÌ:$poster\n";
 $message.="¤å³¹¼ÐÃD:$banner\n";
 $message.="¤å³¹¤º®e:$body\n";
 $message.="\n¨ä¥L¬ÛÃö¤å³¹½Ð¦Ü http://$HTTP_HOST$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid\n";
 $message.="<<Åwªï§Aªº¥[¤J>>\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;
 }
 //±Hµ¹ºÞ²zªÌ
 $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 ª©·s¶iªº¤å³¹",$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."¤¶²Ð§A¦nªº¤å³¹";
 $message="§Aªº¦nªB¤Í: $c_poster ¤¶²Ð§A¬Ý³o«Ê¤å³¹\n";
 $message.="¤å³¹¼ÐÃD:$banner\n";
 $message.="¤å³¹¤º®e:$body\n";
 $message.="\n¨ä¥L¬ÛÃö¤å³¹½Ð¦Ü http://$HTTP_HOST$PHP_SELF?proc=view&sid=$sid&aid=$aid&rid=$rid\n";
 $message.="<<Åwªï§Aªº¥[¤J>>\n";
 $mailfrom="From:".$c_email;
  
 mail($frmail,$subj,$message,$mailfrom);
 }else {
  echo "
 <script language=javascript>
  alert('E-mail®æ¦¡¿ù»~');
 </script>
";  
 }
 //echo "rid=$rid a=$aid s=$sid p=$pgno";
  
 echo "
 <script language=javascript>
 document.location='$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid'
 </script>
";  
}

´ýÐø......  
Õ¾ÄÚËÑË÷