<%
sub mingxing()
	response.write("<tr>")
	dim sql,rs,F_or_M,username,article,mingxing_1_type,mingxing_2_type,mingxing_3_type
%>
<!--#include file="mingxing.inc"-->
<%

'显示第一列的头像
select case mingxing_1
  case 1
  	mingxing_1_type="今日"
	sql="select top 1 username,count(username) from Dv_bbs1 where datediff(d,dateandtime,GetDate())<1 group by username order by count(username) desc"
  case 2
  	mingxing_1_type="本周"
	sql="select top 1 username,count(username) from Dv_bbs1 where DateAndTime>getdate()-weekday(date(),2) group by username order by count(username) desc"
  case 3
  	mingxing_1_type="本月"
  	sql="select top 1 username,count(username) from Dv_bbs1 where year(DateAndTime)=year(getdate()) and Month(DateAndTime)=month(getdate()) group by username order by count(username) desc"
  case 4
  	mingxing_1_type="今年"
  	sql="select top 1 username,count(username) from Dv_bbs1 where year(DateAndTime)=year(getdate()) group by username order by count(username) desc"
  case 5
  	mingxing_1_type="真正"
  	sql="select top 1 username,userpost from [Dv_user] order by userpost desc"
  case 6
  	mingxing_1_type="帅哥"
  	sql="select top 1 username,userpost from [Dv_user] where usersex=1 order by userpost desc"
  case 7
  	mingxing_1_type="靓妹"
  	sql="select top 1 username,userpost from [Dv_user] where usersex=0 order by userpost desc"
  case else
  	mingxing_1_type="今日"
	sql="select top 1 username,count(username) from Dv_bbs1 where DateAndTime>getdate() group by username order by count(username) desc"
end select
	set rs=Dvbbs.execute(sql)
if rs.eof then
	response.write("<TD vAlign=middle align=middle width='3%' class=tablebody2> <IMG  src='skins/default/FeMale.gif' align=absMiddle>")
	response.write("</TD>")
	response.write("<TD vAlign=top align=middle width='30%' class=tablebody1>")
	response.write("<table border=0 width='100%'>")
	response.write("<tr>")
	response.write("<td width=44% valign=top> <strong>")
	response.write("<font color=#ff0000>"&mingxing_1_type&"</font>灌水<font color=#DA9136>状元</font>")
	response.write("</strong> <font color=#9999ff>照片-=></font>")
	response.write("<p align=left>姓名：<font color=#ff0000>等你来改写</font> <br>")
	
	response.write "等级：<img src='plus/mingxing/leve0.gif' border=0>"
	response.write "<br><font color=red>"&mingxing_1_type&"</font>发贴<font color=#ff0000>零</font> 篇"
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar4.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar4_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar5_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar3_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"

	response.write("Email<font color=#ff0000>空</font>")
	response.write("</td><td width=33% valign=middle align=center><img src='plus/mingxing/nomx.gif' border=0></td></table></TD>")
  else
  	username=rs(0)
  	article=rs(1)
	sql="select userclass,userWealth,useremail,userface,userwidth,userheight,usersex,userEP,userCP from [Dv_user] where username='"&username&"'"
	set rs=Dvbbs.execute(sql)
	if rs(6)="1" then
		F_or_M="../../skins/default/Male.gif"
	else
		F_or_M="../../skins/default/FeMale.gif"
	end if
	response.write("<TD vAlign=middle align=middle width='3%' class=tablebody2> <IMG  src='plus/mingxing/"&F_or_M&"' align=absMiddle>")
	response.write("</TD>")
	response.write("<TD vAlign=top align=middle width='30%' class=tablebody1>")
	response.write("<table border=0 width='100%'>")
	response.write("<tr>")
	response.write("<td width=44% valign=top> <strong>")
	response.write("<font color=#ff0000>"&mingxing_1_type&"</font>灌水<font color=#DA9136>状元</font>")
	response.write("</strong> <font color=#9999ff>照片-=></font>")
	response.write("<p align=left>姓名：<font color=blue>"&username&"</font> <br>")
	response.write "等级：" & rs(0) & "<br>"
	response.write "<font color=red>"&mingxing_1_type&"</font>发贴<font color=red> " & Article & "</font> 篇"
	if rs(1)>68000 then
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td align=left width=80 background=plus/mingxing/img_backing.gif height=13><img src=plus/mingxing/bar4.gif width=97 height=9 alt="&rs(1)&"元现金></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar4.gif width=&(rs(1)/700000*100& height=8 alt="&rs(1)&"元现金><IMG height=9 src=plus/mingxing/bar4_1.gif border=0></td><td width=3 height=13><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if
	if rs(8)>4900 then
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=97 height=9 alt="&rs(8)&"></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else		
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=&(rs(8)/5000*100& height=9 alt="&rs(8)&"><IMG height=9 src=plus/mingxing/bar5_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if
	if rs(7)>4900 then
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=97 height=9 alt="&rs(7)&"></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else		
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=&(rs(7)/5000*100& height=9 alt="&rs(7)&"><IMG height=9 src=plus/mingxing/bar3_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if	
	response.write("Email")
	if trim(rs(2))<>"" then
    		response.write("<a href='mailto:"&rs(2)&"'><font color=olive>飞鸽传书</font></a>")
  	end if
	response.Write("</td><td width=33% valign=middle align=center><div alt='ddddd'><IFrame src=""Z_visual_show2.asp?username="&username&"&boardid=0&type=small&bgcolor=tablebody1"" width=""80"" height=""120"" marginwidth=""0"" marginheight=""0"" hspace=""0"" vspace=""0"" frameborder=""0"" scrolling=""NO"" allowtransparency=""true""></iframe></div></td></table></TD>")
  end if
	
'显示第二列的头像
select case mingxing_2
  case 1
  	mingxing_2_type="今日"
	sql="select top 2 username,count(username) from Dv_bbs1 where datediff(d,dateandtime,GetDate())<1 group by username order by count(username) desc"
  case 2
  	mingxing_2_type="本周"
	sql="select top 2 username,count(username) from Dv_bbs1 where DateAndTime>getDate()-weekday(getDate(),3) group by username order by count(username) desc"
  case 3
  	mingxing_2_type="本月"
  	sql="select top 2 username,count(username) from Dv_bbs1 where year(DateAndTime)=year(getDate()) and Month(DateAndTime)=month(getDate()) group by username order by count(username) desc"
  case 4
  	mingxing_2_type="今年"
  	sql="select top 2 username,count(username) from Dv_bbs1 where year(DateAndTime)=year(getDate()) group by username order by count(username) desc"
  case 5
  	mingxing_2_type="真正"
  	sql="select top 2 username,userpost from [Dv_user] order by userpost desc"
  case 6
  	mingxing_2_type="帅哥"
  	sql="select top 1 username,userpost from [Dv_user] where usersex=1 order by userpost desc"
  case 7
  	mingxing_2_type="靓妹"
  	sql="select top 1 username,userpost from [Dv_user] where usersex=0 order by userpost desc"
  case else
  	mingxing_2_type="今日"
	sql="select top 2 username,count(username) from Dv_bbs1 where DateAndTime>getDate() group by username order by count(username) desc"
end select
	set rs=Dvbbs.execute(sql)
	
if (not rs.eof) and mingxing_1=mingxing_2 then
	rs.movenext
end if	
if rs.eof then
	response.write("<TD vAlign=middle align=middle width='3%' class=tablebody2> <IMG src='skins/default/FeMale.gif' align=absMiddle>")
	response.write("</TD>")
	response.write("<TD vAlign=top align=middle width='30%' class=tablebody1>")
	response.write("<table border=0 width='100%'>")
	response.write("<tr>")
	response.write("<td width=44% valign=top> <strong>")
	if mingxing_1=mingxing_2 then
		response.write("<font color=#ff0000>"&mingxing_2_type&"</font>灌水<font color=#DA9136>榜眼</font>")
	else
		response.write("<font color=#ff0000>"&mingxing_2_type&"</font>灌水<font color=#DA9136>状元</font>")
	end if
	response.write("</strong> <font color=#9999ff>照片-=></font>")
	response.write("<p align=left>姓名：<font color=#ff0000>等你来改写</font> <br>")
	response.write "等级：<img src='plus/mingxing/leve0.gif' border=0>"
	response.write "<br><font color=red>"&mingxing_1_type&"</font>发贴<font color=#ff0000>零</font> 篇"
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar4.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar4_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar5_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar3_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	response.write("Email<font color=#ff0000>空</font>")
	response.write("</td><td width=33% valign=middle align=center><img src='plus/mingxing/nomx.gif' border=0></td></table></TD>")
  else
  	username=rs(0)
  	article=rs(1)
	
	sql="select userclass,userWealth,useremail,userface,userwidth,userheight,usersex,userEP,userCP from [Dv_user] where username='"&username&"'"
	
	set rs=Dvbbs.execute(sql)
	if rs(6)="1" then
		F_or_M="../../skins/default/Male.gif"
	else
		F_or_M="../../skins/default/FeMale.gif"
	end if
	response.write("<TD vAlign=middle align=middle width='3%' class=tablebody2> <IMG  src='plus/mingxing/"&F_or_M&"' align=absMiddle>")
	response.write("</TD>")
	response.write("<TD vAlign=top align=middle width='30%' class=tablebody1>")
	response.write("<table border=0 width='100%'>")
	response.write("<tr>")
	response.write("<td width=44% valign=top> <strong>")
	if mingxing_1=mingxing_2 then
		response.write("<font color=#ff0000>"&mingxing_2_type&"</font>灌水<font color=#DA9136>榜眼</font>")
	else
		response.write("<font color=#ff0000>"&mingxing_2_type&"</font>灌水<font color=#DA9136>状元</font>")
	end if
	response.write("</strong> <font color=#9999ff>照片-=></font>")
	response.write("<p align=left>姓名：<font color=blue>"&username&"</font> <br>")
	
	response.write "等级：" & rs(0) & "<br>"
	response.write "<font color=red>"&mingxing_2_type & "</font>发贴<font color=red> " & Article & "</font> 篇"
	if rs(1)>68000 then
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td align=left width=80 background=plus/mingxing/img_backing.gif height=13><img src=plus/mingxing/bar4.gif width=97 height=9 alt="&rs(1)&"元现金></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar4.gif width=&(rs(1)/700000*100& height=8 alt="&rs(1)&"元现金><IMG height=9 src=plus/mingxing/bar4_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if
	if rs(8)>4900 then
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=97 height=9 alt="&rs(8)&"></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else		
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=&(rs(8)/5000*100& height=9 alt="&rs(8)&"><IMG height=9 src=plus/mingxing/bar5_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if
	if rs(7)>4900 then
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=97 height=9 alt="&rs(7)&"></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else		
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=&(rs(7)/5000*100& height=9 alt="&rs(7)&"><IMG height=9 src=plus/mingxing/bar3_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if	
	response.write("Email")
	if trim(rs(2))<>"" then
    		response.write("<a href='mailto:"&rs(2)&"'><font color=olive>飞鸽传书</font></a>")
  	end if
	response.Write("</td><td width=33% valign=middle align=center><div alt='ddddd'><IFrame src=""Z_visual_show2.asp?username="&username&"&boardid=0&type=small&bgcolor=tablebody1"" width=""80"" height=""120"" marginwidth=""0"" marginheight=""0"" hspace=""0"" vspace=""0"" frameborder=""0"" scrolling=""NO"" allowtransparency=""true""></iframe></div></td></table></TD>")
end if

'显示第三列的头像
select case mingxing_3
  case 1
  	mingxing_3_type="今日"
	sql="select top 1 username,count(username) from Dv_bbs1 where datediff(d,dateandtime,GetDate())<1 group by username order by count(username) desc"
  case 2
  	mingxing_3_type="本周"
	sql="select top 1 username,count(username) from Dv_bbs1 where DateAndTime>getDate()-weekday(getDate(),2) group by username order by count(username) desc"
  case 3
  	mingxing_3_type="本月"
  	sql="select top 1 username,count(username) from Dv_bbs1 where year(DateAndTime)=year(getDate()) and Month(DateAndTime)=month(getDate()) group by username order by count(username) desc"
  case 4
  	mingxing_3_type="今年"
  	sql="select top 1 username,count(username) from Dv_bbs1 where year(DateAndTime)=year(getDate()) group by username order by count(username) desc"
  case 5
  	mingxing_3_type="真正"
  	sql="select top 1 username,userpost from [Dv_user] order by userpost desc"
  case 6
  	mingxing_3_type="帅哥"
  	sql="select top 1 username,userpost from [Dv_user] where usersex=1 order by userpost desc"
  case 7
  	mingxing_3_type="靓妹"
  	sql="select top 1 username,userpost from [Dv_user] where usersex=0 order by userpost desc"
  case else
  	mingxing_3_type="今日"
	sql="select top 1 username,count(username) from Dv_bbs1 where DateAndTime>getDate() group by username order by count(username) desc"
end select
	set rs=Dvbbs.execute(sql)
if rs.eof then
	response.write("<TD vAlign=middle align=middle width='3%' class=tablebody2> <IMG  src='skins/default/FeMale.gif' align=absMiddle>")
	response.write("</TD>")
	response.write("<TD vAlign=top align=middle width='30%' class=tablebody1>")
	response.write("<table border=0 width='100%'>")
	response.write("<tr>")
	response.write("<td width=44% valign=top> <strong>")
	response.write("<font color=#ff0000>"&mingxing_1_type&"</font>灌水<font color=#DA9136>状元</font>")
	response.write("</strong> <font color=#9999ff>照片-=></font>")
	response.write("<p align=left>姓名：<font color=#ff0000>等你来改写</font> <br>")
	
	response.write "等级：<img src='plus/mingxing/leve0.gif' border=0>"
	response.write "<br><font color=red>"&mingxing_1_type&"</font>发贴<font color=#ff0000>零</font> 篇"
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar4.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar4_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar5_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=20 height=9><IMG height=9 src=plus/mingxing/bar3_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"

	response.write("Email<font color=#ff0000>空</font>")
	response.write("</td><td width=33% valign=middle align=center><img src='plus/mingxing/nomx.gif' border=0></td></table></TD>")
  else
  	username=rs(0)
  	article=rs(1)
	sql="select userclass,userWealth,useremail,userface,userwidth,userheight,usersex,userEP,userCP from [Dv_user] where username='"&username&"'"
	set rs=Dvbbs.execute(sql)
	if rs(6)="1" then
		F_or_M="../../skins/default/Male.gif"
	else
		F_or_M="../../skins/default/FeMale.gif"
	end if
	response.write("<TD vAlign=middle align=middle width='3%' class=tablebody2> <IMG  src='plus/mingxing/"&F_or_M&"' align=absMiddle>")
	response.write("</TD>")
	response.write("<TD vAlign=top align=middle width='30%' class=tablebody1>")
	response.write("<table border=0 width='100%'>")
	response.write("<tr>")
	response.write("<td width=44% valign=top> <strong>")
	response.write("<font color=#ff0000>"&mingxing_3_type&"</font>灌水<font color=#DA9136>状元</font>")
	response.write("</strong> <font color=#9999ff>照片-=></font>")
	response.write("<p align=left>姓名：<font color=blue>"&username&"</font> <br>")
	response.write "等级：" & rs(0) & "<br>"
	response.write "<font color=red>"&mingxing_3_type&"</font>发贴<font color=red> " & Article & "</font> 篇"
	if rs(1)>68000 then
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td align=left width=80 background=plus/mingxing/img_backing.gif height=13><img src=plus/mingxing/bar4.gif width=97 height=9 alt="&rs(1)&"元现金></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else
		response.write "<br><table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>现金</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar4.gif width=&(rs(1)/700000*100& height=8 alt="&rs(1)&"元现金><IMG height=9 src=plus/mingxing/bar4_1.gif border=0></td><td width=3 height=13><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if
	if rs(8)>4900 then
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=97 height=9 alt="&rs(8)&"></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else		
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>魅力</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar5.gif width=&(rs(8)/5000*100& height=9 alt="&rs(8)&"><IMG height=9 src=plus/mingxing/bar5_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if
	if rs(7)>4900 then
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=97 height=9 alt="&rs(7)&"></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	else		
		response.write "<table cellspacing=0 cellpadding=0 width=150 border=0><tr><td>经验</td><td><table cellspacing=0 cellpadding=0 width=100 border=0><tbody><tr><td width=3 height=13 ><img height=13 src=plus/mingxing/img_left.gif width=3></td><td background=plus/mingxing/img_backing.gif><img src=plus/mingxing/bar3.gif width=&(rs(7)/5000*100& height=9 alt="&rs(7)&"><IMG height=9 src=plus/mingxing/bar3_1.gif border=0></td><td width=3 height=13 ><img height=13 src=plus/mingxing/img_right.gif width=3></td></tr></tbody></table></td></tr></table>"
	end if	
	response.write("Email")
	if trim(rs(2))<>"" then
    		response.write("<a href='mailto:"&rs(2)&"'><font color=olive>飞鸽传书</font></a>")
  	end if
	response.Write("</td><td width=33% valign=middle align=center><div alt='ddddd'><IFrame src=""Z_visual_show2.asp?username="&username&"&boardid=0&type=small&bgcolor=tablebody1"" width=""80"" height=""120"" marginwidth=""0"" marginheight=""0"" hspace=""0"" vspace=""0"" frameborder=""0"" scrolling=""NO"" allowtransparency=""true""></iframe></div></td></table></TD>")
  end if
	

	response.write("</TR>")
rs.close
set rs=nothing
end sub 

function mingxingtop(topmax)
	dim sql,rs
	sql="select top "&topmax&" username,count(username) from Dv_bbs1 where DateAndTime>getDate() group by username order by count(username) desc"
	set rs=Dvbbs.execute(sql)
	if rs.eof then
		mingxingtop="今日暂时无人发贴" 
	else
		mingxingtop=""
		dim c
		c=0
		do while not rs.eof
			mingxingtop=mingxingtop&"<font face=Wingdings color=blue>v</font> <a href=dispuser.asp?name="&rs(0)&" target=_blank title=""查看该社员个人资料及最新发帖一览""><font color=#00BFFF>"&rs(0)&"</font></a>[<font color=red>"&rs(1)&"</font>]&nbsp;&nbsp;"
			rs.movenext
			c=c+1
			if c=topmax then exit do
		loop
	end if
end function
%>