|
vweyes
New Member
74 Posts |
 Posted - 30 July 2002 : 18:43:31
|
I just use this to see member info a lot more quickly. It shows member's name, email, signature, last post date, member ID, member level, and website. Note that this is not the greatest thing for boards that have a lot of members (like over 1,000) because with to many members, it would take a while to load. Just copy and paste this into a text file and save it as extrameminfo.asp
<%@ Language="VbScript"%>
<!--#INCLUDE FILE="config.asp" -->
<!--#INCLUDE FILE="inc_functions.asp" -->
<!--#INCLUDE FILE="inc_top.asp" -->
<BODY bgColor="#ffffff" Background="">
<table border="0" width="100%">
<tr>
<td width="33%" align="left" nowrap><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<img src="<%= strImageUrl %>icon_folder_open.gif" height=15 width=15 border="0"> <a href="default.asp">All Forums</a><br>
<img src="<%= strImageUrl %>icon_bar.gif" height=15 width=15 border="0"><img src="<%= strImageUrl %>icon_folder_open_topic.gif" height=15 width=15 border="0"> Member Info<br>
</font></td>
</tr>
</table>
<br>
<%
strSql = "SELECT * FROM " & strTablePrefix & "Members"
Set rs = my_conn.execute (strSql)
%>
<table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td bgcolor="<% =strTableBorderColor %>">
<table border="0" width="100%" cellspacing="1" cellpadding="4">
<tr>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Name</b></FONT>
</TD>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Member Email</b></FONT>
</TD>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Signature</b></FONT>
</TD>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Last Post</b></FONT>
</TD>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Member ID</b></FONT>
</TD>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Member Level</b></FONT>
</TD>
<td bgcolor="<% =strCategoryCellColor %>">
<font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>" color="<% =strCategoryFontColor %>" size"<% =strDefaultFontSize %>"><b>Website</b></FONT>
</TD>
<%Do While Not RS.EOF%>
<TR>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<%=RS("M_NAME")%></FONT>
</TD>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<%=RS("M_EMAIL")%></FONT>
</TD>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<%=RS("M_SIG")%></FONT>
</TD>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<%=RS("M_LASTPOSTDATE")%></FONT>
</TD>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<%=RS("MEMBER_ID")%></FONT>
</TD>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<%=RS("M_LEVEL")%></FONT>
</TD>
<td bgcolor="<% =strForumCellColor %>" valign=top><font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>">
<a href="<%=RS("M_HOMEPAGE")%>"><%=RS("M_HOMEPAGE")%></a></FONT>
</TD>
</TR>
<%
rs.MoveNext
Loop
rs.close
set rs = nothing
%>
</TABLE>
</BODY>
Edited by - vweyes on 30 July 2002 18:44:44
Edited by - vweyes on 30 July 2002 18:46:07 |
|
Topic Locked
