用PHP和ACCESS写聊天室(九)
用PHP和ACCESS写聊天室(九)
发布时间:2016-12-29 来源:查字典编辑
摘要:enterrm.php3代码如下:

enterrm.php3

代码如下:

<?php

$ConnID=@odbc_connect("jtfcht","admin","");

if ($ConnID){

$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 (($rArr[0]==$ps) && ($rArr[1]>=(time()-1800))){

$sNewRoomID=substr($selRoom,2);

if ($sNewRoomID!=$sRoomID){

$result=@odbc_exec($ConnID,"SELECT Password FROM Room WHERE RoomID=".$sNewRoomID);

if (@odbc_fetch_into($result,0,&$rArr)){

if ((strlen(trim($rArr[0]))==0) || ($rArr[0]==$sPass)){

@odbc_exec($ConnID,"UPDATE User SET RoomID=".$sNewRoomID.",ToID=0,ToName='大家' WHERE UserID=".$id);

if ((int)$sRoomID!=1){

$result=@odbc_exec($ConnID,"SELECT COUNT(UserID) FROM User WHERE RoomID=".$sRoomID);

@odbc_fetch_into($result,0,&$rArr);

if ($rArr[0]==0) @odbc_exec($ConnID,"DELETE * FROM Room Where RoomID=".$sRoomID);

}

}

else{

?>

<html>

<head>

<title>输入房间口令</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<link rel="stylesheet" href="main.css" type="text/css">

<script language="JavaScript">

<>

</script>

<link rel="stylesheet" href="main.css" type="text/css">

</head>

<body onload="PassSetFocus();">

<p></p>

<p align="center"><font color="#996666">输入房间口令</font></p>

<form name="frmEnterSm" action="enterrm.php3" method="post">

<table width="100%" border="0" align="center">

<tr>

<td colspan="2"><input type="hidden" name="selRoom" value="<?php echo $selRoom; ?>"><input type="hidden" name="id" value="<?php echo $id; ?>"><input type="hidden" name="ps" value="<?php echo $ps; ?>"></td>

</tr>

<tr>

<td width="40%" align="right">口令:</td>

<td width="60%"><input type="password" name="sPass" maxlength="10" size="8"></td>

</tr>

<tr>

<td colspan="2" align="center"><input type="submit" name="cmdYes" value="进入"></td>

</tr>

</table>

</form>

<p align="center">按<a href="room.php3?id=<?php echo $id; ?>&ps=<?php echo $ps; ?>&at=<?php echo time(); ?>">这里</a>放弃</p>

</body>

</html>

<?php

exit();

}

}

else{

?>

<html>

<head>

<title>加入房间出错</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<link rel="stylesheet" href="main.css" type="text/css">

</head>

<body>

<p></p>

<p align="center">这个房间已经被拆了!</p>

<p align="center">按<a href="room.php3?id=<?php echo $id; ?>&ps=<?php echo $ps; ?>&at=<?php echo time(); ?>">这里</a>返回</p>

</body>

</html>

<?php

exit();

}

}

}

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

include("room.php3");

?>

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

推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
相关阅读
网友关注
最新php教程学习
热门php教程学习
编程开发子分类