MemberSaveReg.asp
上传用户:mtjhgs
上传日期:2021-12-08
资源大小:3755k
文件大小:5k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

HTML/CSS

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
  2. <!--#include file="../Include/Const.asp"-->
  3. <!--#include file="../Include/ConnSiteData.asp"-->
  4. <%Response.Charset="utf-8"%>
  5. <%
  6. if DateDiff("s",session("time"),now())<Refresh then
  7.    response.write "<script language='JavaScript'>alert('Please refresh it at "&Refresh&" seconds.');" & "history.back()" & "</script>"
  8.    response.end
  9. else
  10.    session("time")=now()
  11. end if
  12. dim mMemName,mRealName,mSex,mPassword,mQuestion,mAnswer,mCompany,mAddress,mZipCode,mTelephone,mFax,mMobile,mEmail,mHomePage
  13. dim vPassword,CheckCode
  14. dim rs,sql
  15. mMemName=trim(request.form("MemName"))
  16. mRealName=trim(request.form("RealName"))
  17. mSex=trim(request.form("Sex"))
  18. mPassword=trim(request.form("Password"))
  19. vPassword=trim(request.form("vPassword"))
  20. mQuestion=trim(request.form("Question"))
  21. mAnswer=trim(request.form("Answer"))
  22. mCompany=trim(request.form("Company"))
  23. mAddress=trim(request.form("Address"))
  24. mZipCode=trim(request.form("ZipCode"))
  25. mTelephone=trim(request.form("Telephone"))
  26. mFax=trim(request.form("Fax"))
  27. mMobile=trim(request.form("Mobile"))
  28. mEmail=trim(request.form("Email"))
  29. mHomePage=trim(request.form("HomePage"))
  30. CheckCode = Trim(request.form("CheckCode"))
  31. dim ErrMessage,ErrMsg(13),FindErr(13),i
  32.   ErrMsg(0)="·Your MemberID must contain 3 - 16 characters.(A/a-Z/z,0-9)"
  33.   ErrMsg(1)="·This MemberID is already registered"
  34.   ErrMsg(2)="·Your password must contain 6 - 16 characters."
  35.   ErrMsg(3)="·Your password wasn't contifrmed."
  36.   ErrMsg(4)="·Your question must contain 3 - 100 characters."
  37.   ErrMsg(5)="·Your answer must contain 3 - 100 characters."
  38.   ErrMsg(6)="·Your company/address must contain 0 - 100 characters."
  39.   ErrMsg(7)="·Your Zip/Postal Code must contain 0 - 20 characters."
  40.   ErrMsg(8)="·Your name/tel/fax/mobile/website must contain 0 - 50 characters."
  41.   ErrMsg(9)="·Please enter a valid email address."
  42.   ErrMsg(10)="·This email is already registered."
  43.   ErrMsg(11)="·Please enter the number in the image."
  44.   ErrMsg(12)="·Time that you stop over in the 【 Register 】 page over long, cause verify the code the expiration. the n pleases return and break the 【 Register 】 page to Register afresh!"
  45.   ErrMsg(13)="·Verifying the code can't for getting empty please return the check."
  46. if not IsValidMemName(mMemName) then FindErr(0)=true
  47. if not conn.execute("select MemName from Wygkcnflash_Members where MemName='" & mMemName & "'").eof then FindErr(1)=true
  48. if not (6<=len(mPassword) and len(mPassword)<=16) then FindErr(2)=true
  49. if mPassword<>vPassword then FindErr(3)=true
  50. if not (3<=len(mQuestion) and len(mQuestion)<=100) then FindErr(4)=true
  51. if not (3<=len(mAnswer) and len(mAnswer)<=100) then FindErr(5)=true
  52. if len(mCompany)=0 Or len(mCompany)>100 Or len(mAddress)=0 Or len(mAddress)>100 then FindErr(6)=true
  53. if len(mZipCode)<>6 then FindErr(7)=true
  54. if len(mRealName)=0 Or len(mTelephone)=0 Or len(mFax)=0 Or len(mMobile)=0 Or len(mHomePage)=0 Or len(mRealName)>50 Or len(mTelephone)>50 Or len(mFax)>50 Or len(mMobile)>50 Or len(mHomePage)>50 then FindErr(8)=true
  55. if not IsValidEmail(mEmail) then FindErr(9)=true
  56. if not conn.execute("select MemName from Wygkcnflash_Members where Email='" & Email & "'").eof then FindErr(10)=True
  57. If CheckCode = "" Then FindErr(11)=true
  58. If Trim(Session("CheckCode")) = "" Then FindErr(12)=true
  59. If CheckCode <> Session("CheckCode") Then FindErr(13)=true
  60. for i = 0 to UBound(FindErr)
  61.   if FindErr(i)=true then
  62.     ErrMessage=ErrMessage+ErrMsg(i)+"n"
  63.   end if
  64. next
  65. if not (ErrMessage="" Or isnull(ErrMessage)) then
  66.   WriteMsg(ErrMessage)
  67.   response.end
  68. end if
  69. set rs = server.createobject("adodb.recordset")
  70. sql="select * from Wygkcnflash_Members"
  71. rs.open sql,conn,1,3
  72. rs.addnew
  73. rs("MemName")=mMemName
  74. rs("RealName")=StrReplace(mRealName)
  75. rs("Sex")=mSex
  76. rs("Password")=Md5(mPassword)
  77. rs("Question")=StrReplace(mQuestion)
  78. rs("Answer")=Md5(mAnswer)
  79. rs("Company")=StrReplace(mCompany)
  80. rs("Address")=StrReplace(mAddress)
  81. rs("ZipCode")=StrReplace(mZipCode)
  82. rs("Telephone")=StrReplace(mTelephone)
  83. rs("Fax")=StrReplace(mFax)
  84. rs("Mobile")=StrReplace(mMobile)
  85. rs("Email")=mEmail
  86. rs("HomePage")=StrReplace(mHomePage)
  87. rs("GroupID")="200709088888888888"
  88. rs("GroupName")=GroupName("200709088888888888")
  89. rs("AddTime")=now()
  90. rs.update
  91. rs.close
  92. Set rs=Nothing
  93. response.write "<script language='javascript'>alert('Congratulations, Your account has been created!');location.replace('Index.asp');</script>"
  94. response.End
  95. function GroupName(GroupID)
  96.   dim rs,sql
  97.   set rs = server.createobject("adodb.recordset")
  98.   sql="select * from Wygkcnflash_MemGroup where GroupID='"&GroupID&"'"
  99.   rs.open sql,conn,1,1
  100.   GroupName=rs("GroupName"&Language)
  101.   rs.close
  102.   set rs=nothing
  103. end function
  104. %>