saveuser.asp

网上购物,不错的购物系统,花了好长时间来改的

<!--#include file="conn.asp"-->
<!--#include file="../md5.asp"-->
<!--#include file="session3.asp"-->
<%
dim userid,action
action=request.QueryString("action")
userid=request.QueryString("id")
if userid="" then userid=request("userid")
select case action
case "save"
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from [sh_user] where userid="&userid,conn,1,3
if trim(request("userpassword"))<>"" then rs("userpassword")=md5(trim(request("userpassword")))
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("useremail")=trim(request("useremail"))
rs("quesion")=trim(request("quesion"))
if trim(request("answer"))<>"" then rs("answer")=md5(trim(request("answer")))

rs("sfz")=trim(request("sfz"))
rs("sex")=trim(request("shousex"))
rs("nianling")=trim(request("nianling"))
rs("province")=trim(request("province"))
rs("city")=trim(request("city"))
rs("shouhuodizhi")=trim(request("shouhuodizhi"))
rs("usertel")=trim(request("usertel"))
rs("youbian")=trim(request("youbian"))
rs("oicq")=trim(request("qq"))
rs("homepage")=trim(request("homepage"))
rs("content")=trim(request("content"))
if trim(request("vipdate"))<>"" then
    rs("vipdate")=trim(request("vipdate"))
end if

if trim(request("yucun"))<>"" then
rs("yucun")=trim(request("yucun"))
else
rs("yucun")=0
end if

rs("reglx")=trim(request("reglx"))

rs.Update
rs.Close
set rs=nothing
response.Write "<script language=javascript>alert('操作成功!');history.go(-1);</script>"
case "del"
conn.execute "delete from [sh_user] where userid in ("&userid&") "
conn.execute "delete from sh_action where userid in ("&userid&")"
conn.execute "delete from sh_action_jp where userid in ("&userid&")"
conn.execute "delete from sh_his where userid in ("&userid&")"
'response.Redirect "manageuser.asp"
response.Redirect request.servervariables("http_referer")
end select
%>