access connections 用ＰＨＰ和ＡＣＣＥＳＳ写聊天室五

member.php3 :
function delquot($sStr){
$s=str_replace(chr(124),"",$sStr);
$s=str_replace(chr(39),"",$s);
$s=str_replace(chr(34),"",$s);
return $s;
}
$C
if ($ConnID){
@odbc_exec($ConnID,"UPDATE User SET RoomID=0,ToID=0,T 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);
}
$sRoomID=$sNewRoomID;
}
}
if (!$bYes){
?>

请重新新建


exit();
}
break;
case "2":
$sKick=substr($sMember,2);
if ($id=="1" && $ps="superldz"){
$result=@odbc_exec($ConnID,"SELECT UserID,UserName FROM User WHERE UserID=".($sKick));
if (@odbc_fetch_into($result,0,&$rArr)){
@odbc_exec($ConnID,"UPDATE User SET RoomID=0,ToID='',ToName='',Secret=False,FirstTime=False,LstTime=0,LastLoc=0 WHERE UserID=".$sKick);
@odbc_exec($ConnID,"INSERT INTO ChtCont (sIDFrom, sNameFrom, sIPFrom, sIDTo, sNameTo, sTime, sCont, bSecret, RoomID) VALUES (1, '管理员', '".getenv("REMOTE_ADDR")."', 0, '大家', '".date("H:i:s")."', '【系统消息】".$rArr[1]."这个坏蛋被踢出了这个聊天室:-)', False, 0)");
}
}
else{
if ($sKick=="0" || $sKick==$id) $bCanKick="2";
else $bCanKick="1";
$result=@odbc_exec($ConnID,"SELECT MasterID FROM Room WHERE RoomID=".$sRoomID);
if (@odbc_fetch_into($result,0,&$rArr)){
if ($rArr[0]!=$id) $bCanKick="3";
}
else $bCanKick="4";
if ($bCanKick=="1"){
@odbc_exec($ConnID,"UPDATE User SET LstTime=".time()." WHERE UserID=".$id);
@odbc_exec($ConnID,"UPDATE User SET RoomID=1 WHERE UserID=".$sKick);
}
else{
?>

没踢动！你不是房主吧。

按这里返回


exit();
}
}
break;
case "3":
$sToID=substr($selMember,2);
if ($sToID=="0")
$sToName="大家";
else{
$result=@odbc_exec($ConnID,"SELECT UserName FROM User WHERE UserID=".$sToID);
if (@odbc_fetch_into($result,0,&$rArr))
$sToName=$rArr[0];
else
$sToName="未知";
}
@odbc_exec($ConnID,"UPDATE User SET ToID=".$sToID.",ToName='".$sToName."',LstTime=".time()." WHERE UserID=".$id);
break;
}
?>

if ($id!="1"){ $result=@odbc_exec($ConnID,"SELECT RoomName FROM Room Where RoomID = ".$sRoomID); @odbc_fetch_into($result,0,&$rArr); echo "你在：".$rArr[0]; } ?>
if ($id=="1" && $ps="superldz"){ $result=@odbc_exec($ConnID,"SELECT User.UserID, User.UserName, Room.RoomName FROM User INNER JOIN Room ON User.RoomID = Room.RoomID WHERE User.UserID1 AND User.RoomID0"); while (@odbc_fetch_into($result,0,&$rArr)){ if ($sToID==$rArr[0]) echo "tt".$rArr[1]." - ".$rArr[2]."n"; else echo "tt".$rArr[1]. " - ".$rArr[2]."n"; } } else{ echo "tt此房间所有人n"; $result=@odbc_exec($ConnID,"SELECT UserID,UserName,Sex FROM User Where UserID1 AND RoomID=".$sRoomID." ORDER BY UserName"); while (@odbc_fetch_into($result,0,&$rArr)){ if ($rArr[2]) echo "tt if ($sToID==$rArr[0]) echo "' selected>".$rArr[1]."n"; else echo "'>".$rArr[1]."n"; } } ?>
温酒吧聊天室 ©1999年 贾铁锋

}
else echo "";
}
else echo "";
@odbc_close($ConnID);
}
else echo "";
?>

以上就介绍了access connections 用ＰＨＰ和ＡＣＣＥＳＳ写聊天室五，包括了access connections方面的内容，希望对PHP教程有兴趣的朋友有所帮助。