'********* Här startar "Registrera"
If Request.QueryString = "register" Then
If Session("User") = "Yes" Then
Response.Write "Du är redan inloggad<br>" &_
"<a href='admin.asp?reqpass'>Glömt ditt lösenord?</a>."
Else
End If
End If
'********* Här skickas registreringen till databasen
If Request.QueryString("register") = "send" Then
If Not Isnull(Request.Form("Username")) Then strUsername = Cstr(Request.Form("Username"))
If Not Isnull(Request.Form("Mail")) Then strMail = Cstr(Request.Form("Mail"))
SQL = "SELECT f_Mail, f_User FROM t_Members where f_Mail = '" & strMail & "' OR f_User = '" & strUsername & "'"
intError = 0
set RS = Connect.Execute(SQL)
If Not rs.EOF Then
While Not rs.EOF
If LCase(RS("f_User")) = LCase(strUsername) Then
intError = intError + 1
strError = "<font class=smallheader>Användarnamnet är upptaget</font><br>" &_
"<a href=""javascript:history.go(-1)"">Tillbaka</a>"
End If
If LCase(RS("f_Mail")) = LCase(strMail) Then
intError = intError + 1
strError = "<font class=smallheader>Mailen är redan använd.</font> " &_
"<a href=""login.asp?reqlosen"">Glömt bort lösenordet?</a><br>" &_
"<a href=""javascript:history.go(-1)"">Tillbaka</a>"
End If
rs.movenext
Wend
If intError = 1 Then Response.Write strError Else response.write "<font class=smallheader>Både mailen och " &_
"användarnamnet är upptaget</font><br><a href=""javascript:history.go(-1)"">Tillbaka</a>"
Else
Username = Request.Form("Username")
Password = Request.Form("Password")
Mail = Request.Form("Mail")
Age = Request.Form("Age")
Sex = Request.Form("Sex")
Tele = Request.Form("Tele")
Name = Request.Form("Nameone") & Request.Form("Nametwo")
Admin = 0
Session.LCID = 1053
strDate = Date
strSQL = "INSERT INTO t_Members " _
& "( f_User, f_Mail, f_Password, f_Name, f_Age, f_Sex, f_Tele, f_RegDate, f_Admin ) " _
& "VALUES( '" & Username & "', '" & Mail & "', '" & Password & "', '" & Name & "', '" & Age & "', '" & Sex & "', '" & Tele & "', '" & strDate & "', '" & Admin & "' )"
[b]Connect.Execute( strSQL )[/b]
Response.Redirect "admin.asp?register=thanks"
End If
End If
If Request.QueryString("register") = "thanks" Then
Response.Write "<font class=smallheader>Tack för din registrering.</font><br>"
End If