用ＰＨＰ和ＡＣＣＥＳＳ写聊天室(四)_PHP教程

    $ConnID=@odbc_connect("jtfcht","admin",""); 
    if ($ConnID){ 
        @odbc_exec($ConnID,"DELETE * FROM Room WHERE (RoomID Not IN (SELECT DISTINCT RoomID FROM User)) AND RoomID<>1"); 
        $result=@odbc_exec($ConnID,"SELECT PassWord,LstTime,RoomID,RefRate FROM User WHERE UserID=".$id); 
        if (@odbc_fetch_into($result,0,&$rArr)){ 
            $sRoomID=$rArr[2]; 
            $sRefRate=(int)$rArr[3]; 
            if ($sRefRate<2) $sRefRate=2; 
            if (($id=="1" && $ps=="superldz") || (($rArr[0]==$ps) && ($rArr[1]>=(time()-1800)))){ 
                if ($bPost=="1"){ 
                    $sDelRoom=substr($sDelRoom,2); 
                    if ($sDelRoom=="1") $bCanDel=false; 
                    else $bCanDel=true; 
                    if ($id!="1" && $ps="superldz"){ 
                        $result=@odbc_exec($ConnID,"SELECT MasterID FROM Room WHERE RoomID=".$sDelRoom); 
                        if (@odbc_fetch_into($result,0,&$rArr)){ 
                            if ($rArr[0]!=$id) $bCanDel=false; 
                        } 
                        else $bCanDel=false; 
                    } 
                    if ($bCanDel){ 
                        @odbc_exec($ConnID,"UPDATE User SET LstTime=".time()." WHERE RoomID=".$sDelRoom." AND UserID=".$id); 
                        @odbc_exec($ConnID,"UPDATE User SET RoomID=1 WHERE RoomID=".$sDelRoom); 
                        @odbc_exec($ConnID,"DELETE * FROM Room WHERE RoomID=".$sDelRoom); 
                        $sRoomID="1"; 
                    } 
                } 
?> 
 
 
 
 
 
 
 
 
 






    if ($id=="1" && $ps="superldz"){ 
?> 


    } 
    else{ 
?> 


    } 
?> 


     
         
 已有的房间：
     
          
         
         
                                
 
 
 
 
            } 
            else echo ""; 
        } 
        else echo ""; 
        @odbc_close($ConnID); 
    } 
    else echo ""; 
?>  

【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】    


http://www.bkjia.com/PHPjc/316751.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/316751.htmlTechArticle代码如下:
?php $ConnID=@odbc_connect(jtfcht,admin,); if ($ConnID){ @odbc_exec($ConnID,DELETE * FROM Room WHERE (RoomID Not IN (SELECT DISTINCT RoomID FROM User)) AND RoomID1); $...