% If Session(strCookieURL & "Approval") = "15916941253" Then %>
NOTE: The following table will show you a list of all users of this forum, and their email addresses.
| User Name |
Email Address |
Posts |
<%
'## Forum_SQL - Find all records with the search criteria in them
strSql = "SELECT " &strMemberTablePrefix & "MEMBERS.M_NAME, " &strMemberTablePrefix & "MEMBERS.M_EMAIL, " &strMemberTablePrefix & "MEMBERS.M_POSTS "
strSql = strSql & " FROM " &strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_STATUS = " & 1
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize=20
rs.open strSql, my_Conn, 3
%>
<% if rs.EOF or rs.BOF then '## No new topic posts found in DB %>
| No Members Found |
<% else %>
<% do until rs.EOF %>
| <% =rs("M_NAME") %> |
"><% =rs("M_EMAIL") %> |
<% =rs("M_POSTS") %> |
<% rs.MoveNext %>
<% loop %>
<% end if %>
|
<% WriteFooter
Else
scriptname = split(request.servervariables("SCRIPT_NAME"),"/")
Response.Redirect "admin_login.asp?target=scriptname"
End IF
%>