国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 數據庫 > MySQL > 正文

社區(php&&mysql)一

2024-07-24 12:56:42
字體:
來源:轉載
供稿:網友


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=":$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 "
          <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>
         ";  
}

待續...... 
發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 依兰县| 新宁县| 九江市| 密云县| 哈密市| 阳原县| 江华| 清河县| 肇东市| 高邑县| 拉萨市| 邢台市| 屯昌县| 伊春市| 隆回县| 凌云县| 黑水县| 石泉县| 祥云县| 修武县| 历史| 神池县| 宁德市| 云安县| 九龙坡区| 天峻县| 年辖:市辖区| 洛川县| 丹棱县| 长岛县| 阿图什市| 酉阳| 宝清县| 道孚县| 通山县| 凤山县| 三门峡市| 三门县| 翁牛特旗| 东阳市| 抚顺县|