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

明輝手游網(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)載,請注明作者及出處】    



主站蜘蛛池模板: 色一情一乱一伦一视频免费看 | 青青草国产免费久久久91 | 伊人影院视频 | 天天做天天爱天天操 | 深夜视频在线播放视频在线观看免费观看 | 四虎在线免费播放 | 日本亚洲欧美 | 亚洲免费网站 | 人人揉人人添人人捏人人看 | 一级做a爰片久久毛片看看 一级做a爰片久久毛片16 | 中文字幕一区在线观看视频 | 婷婷综合五月中文字幕欧美 | 亚洲狼网站狼狼鲁亚洲下载 | 亚洲日本欧美日韩高观看 | 日本激情小视频 | 日日日天天射天天干视频 | 在线观看欧美三级 | 一级做a爰片性色毛片思念网 | 青青青手机视频在线观看 | 青青草国产精品视频 | 在线人成精品免费视频 | 新天堂网| 色婷婷在线视频观看 | 午夜免费毛片 | 亚洲精品乱码国产精品乱码 | 色老成人精品视频在线观看 | 日本高清一区二区三区水蜜桃 | 日本巨黄视频 | 特级一级毛片 | 一级黄片一级毛片 | 日在线视频| 日韩精品一区二区三区乱码 | 亚洲一区免费看 | 日韩欧美激情视频 | 欧美一区日韩一区中文字幕页 | 特级淫片国产免费高清视频 | 日本在线视频免费观看 | 天堂在线观看免费视频 | 欧美一级在线观看视频 | 亚洲乱亚洲23p女 | 四虎hu|