%
verify
set objDB = OpenDatabase(true)
SQL = "Select * from vwUsers order by LastName"
set rsUsers = CreateRecordset(objDB, SQL)
set rFile = server.createobject("Scripting.FileSystemObject")
usersfilename = "users.csv"
set usersfile = rFile.CreateTextFile(server.mappath("temp") &"/" & usersfilename, true)
usersfile.writeline("UserType,FirstName,LastName,DistributorName,Company,Address,City,State,Zip,Email,Phone,Password,PrimaryContact,LastLogin")
section = "Users" %>
:: <%=section%>
Manage Users
Un-Approved Users
Approved Users
| Name
| Email |
|
<%
rsUsers.filter = "Approved = 1"
while not rsUsers.eof
if x mod 2 = 0 then
bgcolor = "#DFDFDF"
else
bgcolor = "#FFFFFF"
end if
%>
| <%= rsUsers("LastName") %>, <%= rsUsers("FirstName") %> |
<%= rsUsers("Email") %> |
">edit |
" onclick="return confirm('Are you sure you want to delete this user?')">delete |
<% usersfile.writeline("""" & rsUsers("UserType") & """,""" & rsUsers("FirstName") & """,""" & rsUsers("LastName") & """,""" & rsUsers("DistributorName") & """,""" & rsUsers("Company") & """,""" & rsUsers("Address") & """,""" & rsUsers("City") & """,""" & rsUsers("State") & """,""" & rsUsers("Zip") & """,""" & rsUsers("Email") & """,""" & rsUsers("Phone") & """,""" & rsUSers("Password") & """," & rsUsers("PrimaryContact") & ",""" & rsUsers("LastLogin") & """")
rsUsers.movenext
x = x + 1
wend %>
Download approved users
<%
rsUsers.close
set rsUsers = nothing
objDB.close
set objDB = nothing
%>