用PHP和ACCESS写聊天室(九)

enterrm.php3
代码如下:
%26lt;?php
$ConnID=@odbc_connect(%26quot;jtfcht%26quot;,%26quot;admin%26quot;,%26quot;%26quot;);
if ($ConnID){
$result=@odbc_exec($ConnID,%26quot;SELECT PassWord,LstTime,RoomID,RefRate FROM User WHERE UserID=%26quot;.$id);
if (@odbc_fetch_into($result,0,%26amp;$rArr)){
$sRoomID=$rArr[2];
$sRefRate=(int)$rArr[3];
if ($sRefRate%26lt;2) $sRefRate=2;
if (($rArr[0]==$ps) %26amp;%26amp; ($rArr[1]%26gt;=(time()-1800))){
$sNewRoomID=substr($selRoom,2);
if ($sNewRoomID!=$sRoomID){
$result=@odbc_exec($ConnID,%26quot;SELECT Password FROM Room WHERE RoomID=%26quot;.$sNewRoomID);
if (@odbc_fetch_into($result,0,%26amp;$rArr)){
if ((strlen(trim($rArr[0]))==0) || ($rArr[0]==$sPass)){
@odbc_exec($ConnID,%26quot;UPDATE User SET RoomID=%26quot;.$sNewRoomID.%26quot;,ToID=0,ToName='大家' WHERE UserID=%26quot;.$id);
if ((int)$sRoomID!=1){
$result=@odbc_exec($ConnID,%26quot;SELECT COUNT(UserID) FROM User WHERE RoomID=%26quot;.$sRoomID);
@odbc_fetch_into($result,0,%26amp;$rArr);
if ($rArr[0]==0) @odbc_exec($ConnID,%26quot;DELETE * FROM Room Where RoomID=%26quot;.$sRoomID);
}
}
else{
?%26gt;
%26lt;html%26gt;
%26lt;head%26gt;
%26lt;title%26gt;输入房间口令%26lt;/title%26gt;
%26lt;meta http-equiv=%26quot;Content-Type%26quot; content=%26quot;text/html; charset=gb2312%26quot;%26gt;
%26lt;link rel=%26quot;stylesheet%26quot; href=%26quot;main.css%26quot; type=%26quot;text/css%26quot;%26gt;
%26lt;script language=%26quot;JavaScript%26quot;%26gt;
%26lt;!--

function PassSetFocus( ) {
document.frmEnterSm.sPass.focus();
}

//--%26gt;
%26lt;/script%26gt;
%26lt;link rel=%26quot;stylesheet%26quot; href=%26quot;main.css%26quot; type=%26quot;text/css%26quot;%26gt;
%26lt;/head%26gt;
%26lt;body onload=%26quot;PassSetFocus();%26quot;%26gt;
%26lt;p%26gt;%26amp;nbsp;%26lt;/p%26gt;
%26lt;p align=%26quot;center%26quot;%26gt;%26lt;font color=%26quot;#996666%26quot;%26gt;输入房间口令%26lt;/font%26gt;%26lt;/p%26gt;
%26lt;form name=%26quot;frmEnterSm%26quot; action=%26quot;enterrm.php3%26quot; method=%26quot;post%26quot;%26gt;
%26lt;table width=%26quot;100%%26quot; border=%26quot;0%26quot; align=%26quot;center%26quot;%26gt;
%26lt;tr%26gt;
%26lt;td colspan=%26quot;2%26quot;%26gt;%26lt;input type=%26quot;hidden%26quot; name=%26quot;selRoom%26quot; value=%26quot;%26lt;?php echo $selRoom; ?%26gt;%26quot;%26gt;%26lt;input type=%26quot;hidden%26quot; name=%26quot;id%26quot; value=%26quot;%26lt;?php echo $id; ?%26gt;%26quot;%26gt;%26lt;input type=%26quot;hidden%26quot; name=%26quot;ps%26quot; value=%26quot;%26lt;?php echo $ps; ?%26gt;%26quot;%26gt;%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr%26gt;
%26lt;td width=%26quot;40%%26quot; align=%26quot;right%26quot;%26gt;口令%26lt;/td%26gt;
%26lt;td width=%26quot;60%%26quot;%26gt;%26lt;input type=%26quot;password%26quot; name=%26quot;sPass%26quot; maxlength=%26quot;10%26quot; size=%26quot;8%26quot;%26gt;%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;tr%26gt;
%26lt;td colspan=%26quot;2%26quot; align=%26quot;center%26quot;%26gt;%26lt;input type=%26quot;submit%26quot; name=%26quot;cmdYes%26quot; value=%26quot;进入%26quot;%26gt;%26lt;/td%26gt;
%26lt;/tr%26gt;
%26lt;/table%26gt;
%26lt;/form%26gt;
%26lt;p align=%26quot;center%26quot;%26gt;按%26lt;a href=%26quot;room.php3?id=%26lt;?php echo $id; ?%26gt;%26amp;ps=%26lt;?php echo $ps; ?%26gt;%26amp;at=%26lt;?php echo time(); ?%26gt;%26quot;%26gt;这里%26lt;/a%26gt;放弃%26lt;/p%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt;
%26lt;?php
exit();
}
}
else{
?%26gt;
%26lt;html%26gt;
%26lt;head%26gt;
%26lt;title%26gt;加入房间出错%26lt;/title%26gt;
%26lt;meta http-equiv=%26quot;Content-Type%26quot; content=%26quot;text/html; charset=gb2312%26quot;%26gt;
%26lt;link rel=%26quot;stylesheet%26quot; href=%26quot;main.css%26quot; type=%26quot;text/css%26quot;%26gt;
%26lt;/head%26gt;
%26lt;body%26gt;
%26lt;p%26gt;%26amp;nbsp;%26lt;/p%26gt;
%26lt;p align=%26quot;center%26quot;%26gt;这个房间已经被拆了！%26lt;/p%26gt;
%26lt;p align=%26quot;center%26quot;%26gt;按%26lt;a href=%26quot;room.php3?id=%26lt;?php echo $id; ?%26gt;%26amp;ps=%26lt;?php echo $ps; ?%26gt;%26amp;at=%26lt;?php echo time(); ?%26gt;%26quot;%26gt;这里%26lt;/a%26gt;返回%26lt;/p%26gt;
%26lt;/body%26gt;
%26lt;/html%26gt;
%26lt;?php
exit();
}
}
}
else echo %26quot;%26lt;html%26gt;%26lt;head%26gt;%26lt;meta http-equiv='Content-Type' content='text/html; charset=gb2312'%26gt;%26lt;title%26gt;房间%26lt;/title%26gt;%26lt;link rel='stylesheet' href='main.css' type='text/css'%26gt;%26lt;/head%26gt;%26lt;body%26gt;%26lt;/body%26gt;%26lt;/html%26gt;%26quot;;
}
else echo %26quot;%26lt;html%26gt;%26lt;head%26gt;%26lt;meta http-equiv='Content-Type' content='text/html; charset=gb2312'%26gt;%26lt;title%26gt;房间%26lt;/title%26gt;%26lt;link rel='stylesheet' href='main.css' type='text/css'%26gt;%26lt;/head%26gt;%26lt;body%26gt;%26lt;/body%26gt;%26lt;/html%26gt;%26quot;;
@odbc_close($ConnID);
}
else echo %26quot;%26lt;html%26gt;%26lt;head%26gt;%26lt;meta http-equiv='Content-Type' content='text/html; charset=gb2312'%26gt;%26lt;title%26gt;房间%26lt;/title%26gt;%26lt;link rel='stylesheet' href='main.css' type='text/css'%26gt;%26lt;/head%26gt;%26lt;body%26gt;%26lt;/body%26gt;%26lt;/html%26gt;%26quot;;
include(%26quot;room.php3%26quot;);
?%26gt;