<% 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.

" %>
[S'identifier] [Liste des clients]
<% 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.

" %>
[Identification] [Liste des clients]
<% 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()%>
 >> INSCRIPTION
<% If Session("AccessLevel") = "Admin" then %> [ Tous les membres ] <%end if %>
<% If Session("AccessLevel")="Admin" Then %> <%Else%> <%End IF%> <% If Session("AccessLevel")="Admin" Then %> <%Else%> <%End IF%>
Identifiant : *  Choisissez un mot de passe *
Retapez votre mot de passe : *   Votre photo :
Statut : Auteur
Administrateur
 Statut : Auteur
Actif : Non
Oui
 Actif : Non
Email : *  
Votre Nom : *   Adresse :
Adresse (suite) :   Ville :
Département :   Pays : *
Code postal :  
Vos renseignements *
<% End Sub%>