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

代码如下:
    $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 "房间";
?>

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

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

PHP相关栏目本月热门文章