deletecy.asp

中国创网同学录1.02

<%@ Language=VBScript %>
<!--#include file=globals.asp -->
<%
userid=trim(session("userid"))
curclassid=trim(session("classid"))
pername=trim(request("pername"))
if userid="" then
    response.redirect "../error.asp?info=对不起，您已经掉线了，请重新申请！"
end if
set rs = createobject("ADODB.recordset")
sql="select * from classinfo where classid='"&curclassid&"'"
rs.open SQL,schooldb
if not rs.eof then
   monitor=rs("monitor")
   monitor1=rs("monitor1")
end if
rs.close
if userid<>monitor and userid<>monitor1 then
   response.redirect "../error.asp?info=对不起，您不是本班班长无权进入！"
end if  
sql="select * from userjoinclassinfo where userid='"&pername&"' and classid='"&curclassid&"'"

rs.open SQL,schooldb
if rs.eof then
   response.redirect "../error.asp?info=对不起，此人本来就不是本班成员！"
end if
rs.close
sql="delete from userjoinclassinfo where userid='"&pername&"' and classid='"&curclassid&"'"
rs.open SQL,schooldb,1,3
response.redirect "../success.asp?info=操作成功,"&pername&" 已经被您驱逐出该班！"
%>