电脑技术学习

社区(php&&mysql)一

dn001
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 "
;;<script language=javascript>
;;alert('竒,ぃ惠狡');
;;</script>
;";;;;;;
}
;;;;} 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 "
;;<script language=javascript>
;;;;alert('﹟ゼ虫ず!');
;;</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."ㄓ璹綷ゅ彻"
;;;;$message=":$postern"
;;;;$message.="ゅ彻夹肈:$bannern"
;;;;$message.="ゅ彻ず甧:$bodyn"
;;;;$message.="nㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$ridn"
;;;;$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.="ゅ彻夹肈:$bannern"
;;;;$message.="ゅ彻ず甧:$bodyn"
;;;;$message.="nㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF?proc=view&sid=$sid&aid=$aid&rid=$ridn"
;;;;$message.="<<舧>>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>
;";;;
}

待续......;

标签: