社区(php&&mysql)一

function covary的形容词ok_cooloff(){

global $php_lf,$aid,$pgno;

tcookie(“open_list”,0,time()+ 31536000);

header(“location:$php_lf?aid=$aid&pgno=$pgno”);

exit;

}

//===============================================================

function cook_coolon(){

global $php_lf,$aid,$pgno;

tcookie(“open_list”,1,time()+ 31536000);

header(“location:$php_lf?aid=$aid&pgno=$pgno”);

exit;

}

function check_mail($mail)

{

$str=strchr($mail,’@’);

if ($st天津三中r==””) return fal;

$str=strchr($mail,”.”);

if ($str==””) return fal;

return true;

}

//================================================================

function addhitviews($sid,$rid) {

$台州学院人文学院droot=getenv(‘document_root’);

include(“sql.php3”);

$db=mysql_connect($sql[‘host’], $sql[‘ur’] , $sql[‘passwd’]);

if($sid==$rid)$qsql=”lect * from bbs_subj where id=’$rid'”;

el $qsql=”lect * 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 t views=’$views’ where id=’$rid'”;

el $qsql=”update bbs_docs t views=’$views’ where id=’$rid'”;

mysql_db_query($sql[‘db’],$qsql);

}

//===============================================================

function mail_list(){

global $php_lf,$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[‘ur’] , $sql[‘passwd’]);

if($mailtype==0) { //璹綷

$qsql=”lect * from bbs_sml where sid=’$sid’ and email=’$email'”;

$rs=mysql_db_query($sql[‘db’],$qsql);

if(mysql_num_rows($rs)==0) { //临⊿

$qsql=”inrt intobbs_sml (sid,email) values(‘$sid’,’$email’)”;

$rs=mysql_db_query($sql[‘db’],$qsql);

} el {

echo ”

<script language=javascript>

alert(‘竒,ぃ惠狡’);

</script>

“;

}

} el { //璹綷

$qsql=”lect * from bbs_sml where sid=’$sid’ and email=’$email'”;

$rs=mysql_db_query($sql[‘db’],$qsql);

if(mysql_num_rows($rs) > 0) { //虫

$qsql=”delete frombbs_sml where sid=’$sid’ and email=’$email'”;

$rs=mysql_db_query($sql[‘db’],$qsql);

} el {

echo ”

<script language=javascript>

alert(‘﹟ゼ虫ず!’);

</script>

“;

}

}

} el {

echo ”

<script language=javascript>

alert(‘e-mailα岿粇’);

</script>

“;

}

echo ”

<script language=javascript>

document.location=’$php_lf?proc=view&aid=$aid&sid=$sid&rid=$rid’

</script>

“;

}

//===============================================================

function nd_the_doc_to_mail_list($aid,$sid,$rid){

global $php_lf,$http_host;

$droot=getenv(‘document_root’);

include(“sql.php3”);

$db=mysql_connect($sql[‘host’], $sql[‘ur’] , $sql[‘passwd’]);

if($sid==$rid)$qsql=”lect * from bbs_subj where id=’$sid'”;

el $qsql=”lect * 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_lf?proc=view&aid=$aid&sid=$sid&rid=$rid\n”;

$message.=”<<舧>>\n”;

$mailfrom=”from:magic jerry”;

$qsql=”lect * 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=”lect * 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_lf,$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[‘ur’] , $sql[‘passwd’]);

if($sid==$rid) {

$qsql=”lect * from bbs_subj where id=’$rid’ “;

} el {

$qsql=”lect * 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_lf?proc=view&sid=$sid&aid=$aid&rid=$rid\n”;

$message.=”<<舧>>\n”;

$mailfrom=”from:”.$c_email;

mail($frmail,$subj,$message,$mailfrom);

}el {

echo ”

<script language=javascript>

alert(‘e-mailα岿粇’);

</script>

“;

}

//echo “rid=$rid a=$aid s=$sid p=$pgno”;

echo ”

<script language=javascript>

document.location=’$php_lf?proc=view&aid=$aid&sid=$sid&rid=$rid’

</script>

“;

}

待续……