%
dim adoCn
dim strSQL
set adoCn = Server.CreateObject("ADODB.Connection")
adoCn.Open strConn
dim adoRs
set adoRs = Server.CreateObject("ADODB.Recordset")
if Request.QueryString("action")="upload" then
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Dim UploadRequest
Set UploadRequest = CreateObject("Scripting.Dictionary")
ByteCount = Request.TotalBytes
RequestBin = Request.BinaryRead(byteCount)
BuildUploadRequest RequestBin
Dim aux, aux1, FILEFLAG
Dim FileName, strEmail, strChangeEmail, ContentType, PhotoPathName, strLoginName, strActive, strChoosePassword, strVerifyPassword, strFullName, strAddress1, strAddress2, strCity, strState, strCountry, strZipCode, strAboutYourself, strAccessLevel, strActivateCode, Value
strLoginName=UploadRequest.Item("txtLoginName").Item("Value")
strLoginName=replace(strLoginName, "'", "''")
strLoginName=LCase(strLoginName)
strActive=UploadRequest.Item("txtActive").Item("Value")
strActive=replace(strActive, "'", "''")
strChoosePassword=UploadRequest.Item("txtChoosePassword").Item("Value")
strChoosePassword= replace(strChoosePassword, "'", "''")
strChoosePassword=LCase(strChoosePassword)
strVerifyPassword=UploadRequest.Item("txtVerifyPassword").Item("Value")
strVerifyPassword= replace(strVerifyPassword, "'", "''")
strVerifyPassword=Lcase(strVerifyPassword)
strEmail=UploadRequest.Item("txtEmail").Item("Value")
strEmail=replace(strEmail, "'", "''")
strEmail=Lcase(strEmail)
strChangeEmail=UploadRequest.Item("txtChangeEmail").Item("Value")
strChangeEmail=replace(strChangeEmail, "'", "''")
strFullName=UploadRequest.Item("txtFullName").Item("Value")
strFullName=replace(strFullName, "'", "''")
strAddress1 = UploadRequest.Item("txtAddress1").Item("Value")
strAddress1= replace(strAddress1, "'", "''")
strAddress2 = UploadRequest.Item("txtAddress2").Item("Value")
strAddress2 = replace(strAddress2, "'", "''")
strCity = UploadRequest.Item("txtCity").Item("Value")
strCity= replace(strCity, "'", "''")
strState = UploadRequest.Item("txtState").Item("Value")
strState= replace(strState, "'", "''")
strCountry = UploadRequest.Item("txtCountry").Item("Value")
strCountry= replace(strCountry, "'", "''")
strZipCode = UploadRequest.Item("txtZipCode").Item("Value")
strZipCode= replace(strZipCode, "'", "''")
strAboutYourself = UploadRequest.Item("txtAboutYourself").Item("Value")
strAboutYourself = replace(strAboutYourself, "'", "''")
strAccessLevel = UploadRequest.Item("txtAccessLevel").Item("Value")
strAccessLevel = replace(strAccessLevel, "'", "''")
strActivateCode = replace(GenRandomF(15), "'", "''")
%>
<%
on error resume next
ContentType =UploadRequest.Item("File").Item("ContentType")
FILEFLAG = err.number
on error goto 0
if FILEFLAG = 0 then
ContentType = UploadRequest.Item("File").Item("ContentType")
PhotoPathName = UploadRequest.Item("File").Item("FileName")
FileName = Right(PhotoPathName,Len(PhotoPathName)-InstrRev(PhotoPathName,"\"))
FileName=Lcase(FileName)
Value = UploadRequest.Item("File").Item("Value")
else
FileName = ""
end if
if filename<>"" then
strSQL = "SELECT * from Login where LoginName='"& strLoginName &"'"
adoRs.Open strSQL, adoCn
if adoRs.eof and adoRs.bof then
adoCn.Execute("INSERT INTO Login (LoginName, Active, ChoosePassword, VerifyPassword, Email, ChangeEmail, FullName, Address1, Address2, City, State, Country, ZipCode, AboutYourself, AccessLevel, ActivateCode, FileName, MimeType) VALUES ('" &_
strLoginName &_
"','" & strActive&_
"','" & strChoosePassword &_
"','" & strVerifyPassword &_
"','" & strEmail &_
"','" & strChangeEmail &_
"','" & strFullName &_
"','" & strAddress1 &_
"','" & strAddress2 &_
"','" & strCity &_
"','" & strState &_
"','" & strCountry &_
"','" & strZipCode &_
"','" & strAboutYourself &_
"','" & strAccessLevel &_
"','" & strActivateCode &_
"','" & FileName &_
"','" & ContentType &_
"')")
%>
<%
response.write "
Identifiant " & strLoginName & " enregistré.
"
response.write "
Vous allez recevoir par email les informations nécessaires à l'activation de votre compte.
"
%>
<%
else
%>
<%
response.write "
Inscription incomplète"
response.write "
L'identifiant '" &strLoginName&"' existe déjà. Veuillez en choisir un autre."
%>
Modifier mon inscription
<%
end if
adoRs.close
adoRs.open "select top 1 * from Login order by LoginID DESC", adoCn, 1, 3
if not adoRs.eof then
adoRs.Fields("Bindata").appendChunk value & chrB(0)
adoRs.Update
adoRs.close
end if
Else
strSQL = "SELECT * from Login where LoginName='"& strLoginName &"'"
adoRs.Open strSQL, adoCn
if adoRs.eof and adoRs.bof then
adoCn.Execute("INSERT INTO Login ( LoginName, Active, ChoosePassword, VerifyPassword, Email, ChangeEmail, FullName, Address1, Address2, City, State, Country, ZipCode, AboutYourself, AccessLevel, ActivateCode) VALUES ('" &_
strLoginName &_
"','" & strActive&_
"','" & strChoosePassword &_
"','" & strVerifyPassword &_
"','" & strEmail &_
"','" & strChangeEmail &_
"','" & strFullName &_
"','" & strAddress1 &_
"','" & strAddress2 &_
"','" & strCity &_
"','" & strState &_
"','" & strCountry &_
"','" & strZipCode &_
"','" & strAboutYourself &_
"','" & strAccessLevel &_
"','" & strActivateCode &_
"')")
%>
<%
response.write "
L'identifiant " & strLoginName & "a été enregistré.
"
response.write "
Vous allez recevoir par email les instructions pour activer votre compte.
"
%>
<%
else
%>
<%
response.write "
Inscription incomplète "
response.write "
L'identifiant '" &strLoginName&"' existe déjà.
Veuillez en choisir un autre"
%>
[Modifier votre inscription]
<%
end if
end if
set UploadRequest = nothing
if Session("AccessLevel")= "Admin" Then
Response.Redirect "loginvoiradmin.asp"
Else
End IF
else
call LoginAdminAddTable()
End If
%>
<% Sub LoginAdminAddTable()%>
<% End Sub%>