<%
'#################################################################################
'## Copyright (C) 2000 Michael Anderson
'##
'## This program is free software; you can redistribute it and/or
'## modify it under the terms of the GNU General Public License
'## as published by the Free Software Foundation; either version 2
'## of the License, or any later version.
'##
'## This program is distributed in the hope that it will be useful,
'## but WITHOUT ANY WARRANTY; without even the implied warranty of
'## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
'## GNU General Public License for more details.
'##
'## You should have received a copy of the GNU General Public License
'## along with this program; if not, write to the Free Software
'## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
'##
'## Correspondence and Questions can be sent to:
'## reinhold@bigfoot.com
'##
'## or
'##
'## Snitz Communications
'## C/O: Michael Anderson
'## PO Box 200
'## Harpswell, ME 04079
'#################################################################################
%>
<% If Session("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 " & strTablePrefix & "MEMBERS.M_NAME, " & strTablePrefix & "MEMBERS.M_EMAIL, " & strTablePrefix & "MEMBERS.M_POSTS "
strSql = strSql & " FROM " & strTablePrefix & "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 %>
|
<% Else %>
<% Response.Redirect "admin_login.asp" %>
<% End IF %> 
All Forums
User Email List