guesttomember.asp

一个很好的班级同学录

<!--#include file="../public/conn.asp" -->
<%
if session("username")="" or session("quanxian")<>"master" then
   response.redirect "../index.asp"
end if

set rs=server.createobject("adodb.recordset")
sql="select * from user where username='"&trim(request("username"))&"'"
rs.open sql,secondconn,3,3

if rs.eof then
   response.redirect("index.asp")
else
   rs("quanxian")="member"
   rs("checked")=true
   rs.update
   rs.close
   set rs=nothing 
end if
response.Redirect "index.asp"
%>