社区(phpmysql)一

　　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 INTObbs_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 FROMbbs_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=":$poster\n";
$message.="ゅ彻夹肈:$banner\n";
$message.="ゅ彻ず甧:$body\n";
$message.="\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ㄤ闽ゅ彻叫
$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>
";
}

待续......