ÉçÇø(php&&mysql)Îå

function post2() {
global $sid,$aid,$PHP_SELF;
global $banner,$body,$poster,$email,$type,$CHAR_GB;

if(strlen($banner)==0 || strlen($body)==0 || strlen($poster)==0 || strlen($email)==0) {   
    echo "   
      <script language=javascript>   
        alert('¶ñ¼g¤£§¹¾a');   
        history.back();   
      </script>   
     ";   
    return;   
}   

//$banner=AddSlashes($banner);   
//$body=AddSlashes($body);   
$rip=getenv('REMOTE_ADDR');   

$DROOT=getenv('DOCUMENT_ROOT');   
include("sql.php3");   
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);    
$now=date('Y')."-".date('m')."-".date('d')." ".date('H').":".date('i').":".date('s');   

if($CHAR_GB==1) {   
    include("CCharset.php3");   
    $code=new CCharset;   
    $banner=$code->Gb_Big5($banner);   
    $body=$code->Gb_Big5($body);   
    $poster=$code->Gb_Big5($poster);               
}   

if($type==1) {   
    $qsql="INSERT INTO bbs_docs (aid,sid,banner,body,poster,email,pip,wdate)   
       values('$aid','$sid','$banner','$body','$poster','$email','$rip','$now')";   
} else {   
    $qsql="INSERT INTO bbs_subj (aid,banner,body,poster,email,pip,wdate)   
       values('$aid','$banner','$body','$poster','$email','$rip','$now')";   
}       
$rs=mysql_db_query($sql['db'],$qsql);   
$id=mysql_insert_id();   



if($type==0) { //¦Û°Ê¥[¤Jmail_list   
    $qsql="INSERT INTO  bbs_sml (sid,email) values('$id','$email')";   
    $rs=mysql_db_query($sql['db'],$qsql);   

}   
if($type==0)  Send_the_doc_to_mail_list($aid,$id,$id);   
else           Send_the_doc_to_mail_list($aid,$sid,$id);       
//incdocs($aid);   
if($type==0) { $sid=$rid=$id;}   
else         { $rid=$id;}   
echo "   
      <script language=javascript>   
      document.location='$PHP_SELF?proc=view&aid;=$aid&sid;=$sid&rid;=$rid'   
      </script>   
     ";    

}
//======================================================================
function search_docs($aid,$skey) {
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
//$qsql="SELECT from bbs_docs where sid='$id' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";
if($aid) $qsql="SELECT from bbs_docs where aid='$aid' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";
else $qsql="SELECT * from bbs_docs where (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
while($row=mysql_fetch_array($rs)) {
$id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
$aid=$row['aid'];
$sid=$row['sid'];

        echo "<tr bgcolor='#F0F0F0'>";   
            echo "<td>";   
                echo "<a href=$PHP_SELF?proc=view&aid;=$aid&sid;=$sid&rid;=$id>";   
                echo "  <font color=#836FFF>$banner</font>";   
                echo "</a>";   

            echo "</td>";   
            echo "<td>";   
                echo $poster;   
            echo "</td>";   
            echo "<td class='num'>";   
                echo " ";   
            echo "</td>";   
            echo "<td class='num'>";   
                echo $views;   
            echo "</td>";   
            echo "<td class='num'>";   
                echo $wdate;   
            echo "</td>";   

        echo "</tr>";   
}   

}
//======================================================================
function search() {
global $PHP_SELF;
global $key,$aid;
if(!strlen($key)) {
echo "

  echo "<tr><td>";   

          echo "<input type='hidden' name=aid value='$aid'>";       
          echo "*j´M¤a³¹:";   
          echo "<INPUT TYPE='TEXT' NAME='key' value='$key' size=25 class='tablefont'>";   
          echo "<INPUT TYPE='Submit'value='¬d¸ß' class='tablefont'>";   

  echo "</td></tr>";   
  echo "</FORM>";    
echo "</table>";    


$skey="%$key%";   
$DROOT=getenv('DOCUMENT_ROOT');   
include("sql.php3");   
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);    
if($aid) $qsql="SELECT * from bbs_subj where aid='$aid' and (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";   
else $qsql="SELECT * from bbs_subj where  (banner like '$skey' or poster like '$skey' or body like '$skey') order by wdate DESC";       
//echo $qsql;   
$rs=mysql_db_query($sql['db'],$qsql);   

echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>";   
  echo "<tr><td>";   
  echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class='tablefont'>";   
    echo "<tr bgcolor=#F1E1FF>";   
        echo "<th >¼ÐÃD</th>";   
        echo "<th>µo°_¤H</th>";   
        echo "<th width=30>¦^À³</th>";   
        echo "<th width=30>¤H®ð</th>";   
        echo "<th width=70>¤e´Á</th>";   
    echo "</tr>";   
    while($row=mysql_fetch_array($rs)) {   
        $id=$row['id'];   
        $paid=$row['aid'];   
        $banner=$row['banner'];   
        $poster=$row['poster'];   
        $views=$row['views'];   
        $wdate=sdatetime($row['wdate']);   
        $docs=reAnum($id);   
        echo "<tr bgcolor='#F0F8FF'>";   
            echo "<td>";   
                echo "<a href=$PHP_SELF?proc=view&aid;=$paid&sid;=$id&rid;=$id>";   
                    echo $banner;   
                echo "</a>";   
            echo "</td>";   
            echo "<td>";   
                echo $poster;   
            echo "</td>";   
            echo "<td class='num'>";   
                echo $docs;   
            echo "</td>";   
            echo "<td class='num'>";   
                echo $views;   
            echo "</td>";   
            echo "<td class='num'>";   
                echo $wdate;   
            echo "</td>";   
        echo "</tr>";   

    }   
    search_docs($aid,$skey);   
  echo "</td></tr></table>";   
echo"</td></tr></table>";         

}
//======================================================================

if($proc=="post2") {
setcookie("c_poster",$poster,time()+ 31536000);
setcookie("c_email",$email,time()+ 31536000);
}

//if($proc!="do_sel" && $proc!="post2" && $proc!="colloff" && $proc!="collon") include("frame_top.php3");
switch($proc) {
case search:
search();
break;
case mail_list:
mail_list();
break;
case mail_friend:
mail_friend();
break;
case post2:
post2();
break;
case colloff:
cook_cooloff();
break;
case collon:
cook_coolon();
break;
case view;
view();
break;
default:
area();
break;
}
//if($proc!="do_sel" && $proc!="post2" && $proc!="colloff" && $proc!="collon") include("frame_bottom.php3");
?>

ÒÔÉÏÇ°ÎaƪΪһ¸oÒ³Ãae