代码如下: $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()." E RoomID=".$sDelRoom." AND ユーザーID=".$ ID); @odbc_exec($ConnID,"UPDATE ユーザー SET RoomID=1 WHERE RoomID=".$sDelRoom); @odbc_exec($ConnID,"DELETE * FROM Room WHERE RoomID=".$sDelRoom); $sRoomID="1"; } } ?>