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

明輝手游網中心:是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺!

用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>";
?>  

【本文版權歸作者與奧索網共同擁有,如需轉載,請注明作者及出處】    



主站蜘蛛池模板: 日韩在线操 | 亚洲wwww| 天天做天天爱天天爽综合区 | 四虎国产精品视频免费看 | 日本欧美一区二区三区视频 | 亚洲乱码一二三四区乱码 | 色综合色综合色综合色综合网 | 色妞网欧美 | 亚洲欧美综合 | 一级a毛片免费观看久久精品 | 日韩黄视频| 中文字幕色综合久久 | 亚洲第一大网站 | 欧美影院一区二区三区 | 亚洲成av人片天堂网 | 午夜影视污 | 日本在线一本 | 日本高清视频免费在线观看 | 日本欧美激情 | 天天插天天狠天天透 | 亚洲欧美日韩不卡一区二区三区 | 日韩欧美视频二区 | 午夜在线亚洲男人午在线 | 香港三级理论在线观看网站 | 欧美一区二区影院 | 亚洲我不卡 | 日本高清视频在线免费观看 | 中文精品久久久久国产网站 | 日本国产一区二区三区 | 天堂资源在线官网bt | 青娱乐在线国产 | 日本中文字幕在线看 | 青草娱乐视频 | 日本一区视频 | 一级做a爰片性色毛片刺激 一级做a爰片欧美一区 | 热热影院 | 在线精品91青草国产在线观看 | 亚洲va欧美va国产va天堂 | 一区二区三区在线观看视频 | 婷婷开心中文字幕 | 四虎影视在线影院4hutv |