reg_change2.asp

憧憬计数器v0.99

<%@ language=vbscript%>
<%response.buffer=true%>
<!--#include file=conn.asp-->
<% id=trim(request.form("id"))
   url=trim(request.form("url"))
   oldid=trim(request.form("oldid"))
   if id="" or url="" then response.end
   id=replace(id,"'","''")
   url=replace(url,"'","''")
   oldid=replace(oldid,"'","''")

   set reg=server.createobject("adodb.connection")

 if oldid<>id then
   sql="select admin from userinfo where admin='"&id&"'"
   reg.open conn
   set regtemp=reg.execute(sql)
   if not (regtemp.eof and regtemp.bof) then 
      regtemp.close
      set regtemp=nothing
      reg.close
      set reg=nothing
      response.write "<script language=jscript>alert('该用户名已存在');history.back();</script>"
      response.end
   end if
    regtemp.close
    set regtemp=nothing
    reg.close
end if
    webname=replace(trim(request.form("webname")),"'","''")
    pws=replace(trim(request.form("pws")),"'","''")
    intro=replace(trim(request.form("intro")),"'","''")
    keys=replace(trim(request.form("keys")),"'","''")
    intro=replace(intro,chr(10),"<br>")
    intro=replace(intro,chr(32),"&nbsp;")
    clas=request.form("class")
     if keys<>"" then
     keys_ar=split(keys&",",",")
     if ubound(keys_ar)>5 then
         keys=keys_ar(0)&","&keys_ar(1)&","&keys_ar(2)&","&keys_ar(3)&","&keys_ar(4)
         erase keys_ar
     end if
     end if
    sql="update userinfo set kindname='"&clas&"',admin='"&id&"',pass='"&pws&"',url='"&url&"',webname='"&webname&"',keys='"&keys&"',intro='"&intro&"' where admin='"&oldid&"'"
      reg.open conn
      reg.execute(sql)
      reg.close
      set reg=nothing
     

%>
<%server.transfer("reg_change_suc.asp")
  response.end%>