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

代码如下: 
<?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);

补充：Web开发 , php ,

上一个：用ＰＨＰ和ＡＣＣＥＳＳ写聊天室(五)
下一个：用ＰＨＰ和ＡＣＣＥＳＳ写聊天室(三)