<TABLE cellSpacing=0 cellPadding=0 width="155" border=0>
<TBODY>
<TR>
<TD class=border_1>
<%
strListNum = 10
SET RS = DBCON.EXECUTE("SELECT TOP " & strListNum & " [strLoginID], [strLoginName], [strNick], [intPoint] = (SELECT SUM([moneyPoint]) FROM [MPLUS_MEMBER_POINT] WHERE [strLoginID] = [MPLUS_MEMBER_LIST].[strLoginID]), [intBoardCount], [intCommentCount], [intVote], [intVisit], [dateRegDate], [strAvata] = (SELECT [strAvata] FROM [MPLUS_GROUP] WHERE [strGroupCode] = [MPLUS_MEMBER_LIST].[strGroup]) FROM [MPLUS_MEMBER_LIST] WHERE [strAdmin] != '2' ORDER BY [intPoint] DESC ")
%>
<TABLE cellSpacing=0 cellPadding=1 width="155">
<TBODY>
<TR>
<TD align=middle bgColor=#f2a8fb colSpan=3 height=26><FONT style="FONT-SIZE: 7pt; COLOR: white; FONT-FAMILY: tahoma"><B>RANKING</B></FONT></TD>
</TR>
<TR align=middle bgColor=#efefef height=26>
<TH width="40">순위</TH>
<TH>회원</TH>
<TH>엽전</TH>
</TR>
<%
i=1
IF RS.EOF THEN
ELSE
WHILE NOT(RS.EOF)
%>
<TR align=middle>
<TD style="FONT-SIZE: 8pt; FONT-FAMILY: tahoma"><%=i%></TD>
<TD align=center><IMG src="Pds/Member/GroupIcon/<%=rs("strAvata")%>" border=0><%=GetCutSubject(rs("strNick"),10)%></TD>
<TD style="FONT-SIZE: 7pt; FONT-FAMILY: tahoma"><%=rs("intPoint")%></TD>
</TR>
<%
end if
i=i+1
RS.MOVENEXT
WEND
end if
%>
</TBODY>
</TABLE></td></tr></table>
댓글 2