六月婷婷综合激情-六月婷婷综合-六月婷婷在线观看-六月婷婷在线-亚洲黄色在线网站-亚洲黄色在线观看网站

明輝手游網(wǎng)中心:是一個免費提供流行視頻軟件教程、在線學(xué)習(xí)分享的學(xué)習(xí)平臺!

用PHP與ACCESS寫聊天室(4)

[摘要]代碼如下: <?php ConnID=@odbc_connect("jtfcht","admin",""); if (ConnID) @odbc_exec(ConnID,"DELETE * ...
代碼如下:
<?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";
                    }
                }
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>房間</title>
<link rel="stylesheet" href="main.css" type="text/css">
<meta http-equiv="refresh" content="<?php echo (((int)($sRefRate))*8); ?>;url=room.php3?id=<?php echo $id ?>&ps=<?php echo $ps; ?>&at=<?php echo time(); ?>">
<script language="JavaScript">
<!--

function CheckValid() {
    document.frmInRoom.selRoom.value = document.frmRoom.selRoom.value;
    return true;
}

function AlertIt() {
    document.frmDelRoom.sDelRoom.value = document.frmRoom.selRoom.value;
    return confirm("你真的要拆了這個房子啊!");
}

//-->
</script>
</head>
<body>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
    <tr>
        <td colspan="3">&nbsp;<font style="font-size:10.5pt;">已有的房間:</font></td>
    </tr>
    <form method="post" action="#" name="frmRoom">
    <tr>
        <td align="center" colspan="3"><?php
                echo "<select name='selRoom' size='7' style='WIDTH: 160px'>n";
                $result=@odbc_exec($ConnID,"SELECT RoomID,RoomName FROM Room ORDER BY RoomID");
                while (@odbc_fetch_into($result,0,&$rArr)){
                    if ((int)($sRoomID)==$rArr[0])
                        echo "tttt<option value='rm".$rArr[0]."' selected>".$rArr[1]."</option>n";
                    else
                        echo "tttt<option value='rm".$rArr[0]."'>".$rArr[1]."</option>n";
                }
                echo "tttt</select>n";
?>
        </td>
    </tr>
    </form>
    <tr>
<?php
    if ($id=="1" && $ps="superldz"){
?>
        <td width="64" align="center"></td>
        <td width="50" align="center"></td>
<?php
    }
    else{
?>
        <form method="post" action="newroom.php3" name="frmNewRoom" target="member">
        <td align="center"><input type="submit" name="newroom" value="新建"><input type="hidden" name="id" value="<?php echo $id; ?>"><input type="hidden" name="ps" value="<?php echo $ps; ?>"></td>
        </form>
        <form method="post" action="enterrm.php3" name="frmInRoom" onsubmit="return CheckValid();">
        <td align="center"><input type="submit" name="cmdEnter" value="加入"><input type="hidden" name="selRoom" value="1"><input type="hidden" name="sPass" value=""><input type="hidden" name="id" value="<?php echo $id; ?>"><input type="hidden" name="ps" value="<?php echo $ps; ?>"></td>
        </form>
<?php
    }
?>
        <form method="post" action="room.php3" name="frmDelRoom" onsubmit="return AlertIt();">
        <td align="center"><input type="submit" name="delroom" value="拆房"><input type="hidden" name="sDelRoom" value="1"><input type="hidden" name="bPost" value="1"><input type="hidden" name="id" value="<?php echo $id; ?>"><input type="hidden" name="ps" value="<?php echo $ps; ?>"></td>
        </form>
    </tr>
</table>
</body>
</html>
<?php
            }
            else echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>房間</title><link rel='stylesheet' href='main.css' type='text/css'></head><body></body></html>";
        }
        else echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>房間</title><link rel='stylesheet' href='main.css' type='text/css'></head><body></body></html>";
        @odbc_close($ConnID);
    }
    else echo "<html><head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>房間</title><link rel='stylesheet' href='main.css' type='text/css'></head><body></body></html>";
?>  

【本文版權(quán)歸作者與奧索網(wǎng)共同擁有,如需轉(zhuǎn)載,請注明作者及出處】    



主站蜘蛛池模板: 青青青青青青在线精品视频 | 有码日韩 | 四虎精品影院永久在线播放 | 色又色| 日韩一级在线观看 | 亚欧乱色一区二区三区 | 欧美综合一区二区三区 | 四虎澳门永久8848在线影院 | 五月婷色 | 中文字幕波多野不卡一区 | 中日韩一级片 | 天天做天天做天天综合网 | 日韩欧美一区二区三区中文精品 | 全部免费毛片 | 网站久久 | 欧洲97色综合成人网 | 欧美在线播放视频 | 在线观看亚洲 | 中文字幕第66页永久乱码 | 中文字幕在线精品不卡 | 午夜视频福利在线观看 | 色视频一区二区三区 | 亚洲成在人线中文字幕 | 青青草一区国产97 | 色偷偷91综合久久噜噜 | 婷婷综合激情 | 亚洲国产天堂久久综合图区 | 青青青免费高清视频在线 | 欧美性黑人极品hd网站 | 青青草自拍| 欧洲黄色大片 | 影院理论 | 伊人免费视频网 | 日韩一级欧美一级 | 天天色综合1 | 日本在线看小视频网址 | 日本成人免费在线观看 | 日本一二三区在线视频 | 天天舔天天射天天干 | 日韩中文字幕在线有码视频网 | 日本三级在线播放线观看2021 |