showperson.asp

问吧程序 问吧程序 问吧程序 问吧程序

	if rs.eof then
	response.write"<script>alert('没有所查找的用户!');history.back();</script>"
	else
	%>
		<p align="center"><font color="#6699FF">
		<span style="font-weight: 800; font-size: 13px">用户<font color=red><%=rs("name")%></font>的资料如下:</font></span></font></td>
      </tr>
        </tr></table>
	<table width="90%"  border="0" align="center" cellpadding="0" cellspacing="0" id="table20">
  <tr>
    <td height="153" valign="top">
	<table width="90%"  border="0" align="center" cellpadding="0" cellspacing="1" id="table21">
      <tr>
        <td width="13%"><img src="images/13.gif" width="50" height="50"></td>
        <td width="14%" align="center" valign="middle"><font style="font-size:14px">用户<br>
          积分</font>
          </td>
        <td width="73%" align="center"><font color=red style="font-size:14px"><%=rs("jifen")%></font></td>
      </tr>
      <tr>
        <td><img src="images/13.gif" width="50" height="50"></td>
        <td align="center" valign="middle"><font style="font-size:14px">用户<br>
          头衔</font></td>
        <td align="center"><font color=red style="font-size:14px"><%=rs("touxian")%></font></td>
      </tr>
      <tr>
        <td><img src="images/13.gif" width="50" height="50"></td>
        <td align="center" valign="middle" width="14%"><font style="font-size:14px">发表问题数量</font></td>
        <td align="center"><font color=red style="font-size:14px"><%=rs("asknum")%></font></td>
      </tr>
      <tr>
        <td><img src="images/13.gif" width="50" height="50"></td>
        <td align="center" valign="middle" width="14%"><font style="font-size:14px">回复问题数量</font></td>
        <td align="center"><font color=red style="font-size:14px"><%=rs("replynum")%></font></td>
      </tr>
      <tr>
        <td><img src="images/13.gif" width="50" height="50"></td>
        <td align="center" valign="middle" width="14%"><font style="font-size:14px">解决问题数量</font></td>
        <td align="center"><font color=red style="font-size:14px"><%=rs("helpnum")%></font></td>
      </tr>
    </table>
	  
	  <table width="90%"  border="0" align="center" cellpadding="0" cellspacing="0" id="table22">
        <tr>
          <td height="20" bgcolor="eeeeee"><font style="font-size:14px">用户解决的问题</font></td>
        </tr>
		<%rs2.open"select distinct replyid from reply where replyer='"&rs("name")&"' and isdeal=1",conn,1,1
		if rs2.eof then%>
        <tr>
          <td>暂时没有解决任何问题!</td>
        </tr>
		<%else
		maxnum=rs2.recordcount
		rs2.pagesize=10
		maxpage=rs2.pagecount
		if request("p")="" then
		p=1
		else
		p=cint(request("p"))
		end if
		if p>maxpage then
		p=maxpage
		end if
		if p=0 then
		p=1
		end if
		if p<>1 then
		rs2.move (p-1)*rs2.pagesize
		end if
		for i=1 to rs2.pagesize
		rs3.open"select * from question where id="&rs2("replyid"),conn,1,1
	    %>
		<tr>
          <td>▲<a href=showquestion.asp?id=<%=rs2("replyid")%>><%=rs3("title")%></a><br>
		  浏览数:<%=rs3("views")%> 回复数:<%=rs3("replys")%> 主题:<a href=assort.asp?topic=<%=rs3("topic")%>><%=rs3("topic")%></a> 发布者:<a href=showperson.asp?name=<%=rs3("sender")%>><%=rs3("sender")%></a> 发布时间:<%=rs3("sendtime")%>
		  <hr size=1 style="border:1pt dotted cccccc "></td>
        </tr>
		<%rs3.close
		rs2.movenext
		if rs2.eof then exit for
		next
		end if
		rs2.close%>
		<tr><td>共解决<font color=red><%=maxnum%></font>个问题，每页显示10个问题，总页数<font color=red><%=maxpage%>,当前页<%=p%>
		<a href=showperson.asp?id=<%=id%>&p=1>首页</a>
		<a href=showperson.asp?id=<%=id%>&p=<%=p-1%>>上页</a>
		<a href=showperson.asp?id=<%=id%>&p=<%=p+1%>>下页</a>
		<a href=showperson.asp?id=<%=id%>&p=<%=maxpage%>>尾页</a>
		</td></tr>
      </table>
	  <table width="90%"  border="0" align="center" cellpadding="0" cellspacing="0" id="table23">
        <tr>
          <td height="20" bgcolor="eeeeee"><font style="font-size:14px">用户回复的问题</font></td>
        </tr>
		<%rs2.open"select distinct replyid from reply where replyer='"&rs("name")&"'",conn,1,1
		if rs2.eof then%>
        <tr>
          <td>暂时没有回复任何问题!</td>
        </tr>
		<%else
		maxnum=rs2.recordcount
		rs2.pagesize=10
		maxpage=rs2.pagecount
		if request("page")="" then
		page=1
		else
		page=cint(request("page"))
		end if
		if page>maxpage then
		page=maxpage
		end if
		if page=0 then
		page=1
		end if
		if page<>1 then
		rs2.move (page-1)*rs2.pagesize
		end if
		for i=1 to rs2.pagesize
		rs3.open"select * from question where id="&rs2("replyid"),conn,1,1
	    %>
		<tr>
          <td>▲<a href=showquestion.asp?id=<%=rs2("replyid")%>><%=rs3("title")%></a><br>
		  浏览数:<%=rs3("views")%> 回复数:<%=rs3("replys")%> 主题:<a href=assort.asp?topic=<%=rs3("topic")%>><%=rs3("topic")%></a> 发布者:<a href=showperson.asp?name=<%=rs3("sender")%>><%=rs3("sender")%></a> 发布时间:<%=rs3("sendtime")%>
		  <hr size=1 style="border:1pt dotted cccccc "></td>
        </tr>
		<%rs3.close
		rs2.movenext
		if rs2.eof then exit for
		next
		end if
		rs2.close%>
		<tr><td>共回复<font color=red><%=maxnum%></font>个问题，每页显示10个问题，总页数<font color=red><%=maxpage%>,当前页<%=page%>
		<a href=showperson.asp?id=<%=id%>&page=1>首页</a>
		<a href=showperson.asp?id=<%=id%>&page=<%=page-1%>>上页</a>
		<a href=showperson.asp?id=<%=id%>&page=<%=page+1%>>下页</a>
		<a href=showperson.asp?id=<%=id%>&page=<%=maxpage%>>尾页</a>
		</td></tr>
      </table>
	  <table width="90%"  border="0" align="center" cellpadding="0" cellspacing="0" id="table24">
        <tr>
          <td height="20" bgcolor="eeeeee"><font style="font-size:14px">用户发表的问题</font></td>
        </tr>
		<%rs2.open"select *  from question where sender='"&rs("name")&"'",conn,1,1
		if rs2.eof then%>
        <tr>
          <td>暂时没有发表任何问题!</td>
        </tr>
		<%else
		maxnum=rs2.recordcount
		rs2.pagesize=10
		maxpage=rs2.pagecount
		if request("pages")="" then
		pages=1
		else
		pages=cint(request("pages"))
		end if
		if pages>maxpage then
		pages=maxpage
		end if
		if pages=0 then
		pages=1
		end if
		if pages<>1 then
		rs2.move (pages-1)*rs2.pagesize
		end if
		for i=1 to rs2.pagesize
	    %>
		<tr>
          <td>▲<a href=showquestion.asp?id=<%=rs2("id")%>><%=rs2("title")%></a><br>
		  浏览数:<%=rs2("views")%> 回复数:<%=rs2("replys")%> 主题:<a href=assort.asp?topic=<%=rs2("topic")%>><%=rs2("topic")%></a> 发布者:<a href=showperson.asp?name=<%=rs2("sender")%>><%=rs2("sender")%></a> 发布时间:<%=rs2("sendtime")%>
		  <hr size=1 style="border:1pt dotted cccccc "></td>
        </tr>
		<%
		rs2.movenext
		if rs2.eof then exit for
		next
		end if
		rs2.close%>
		<tr><td>共回复<font color=red><%=maxnum%></font>个问题，每页显示10个问题，总页数<font color=red><%=maxpage%>,当前页<%=page%>
		<a href=showperson.asp?id=<%=id%>&pages=1>首页</a>
		<a href=showperson.asp?id=<%=id%>&pages=<%=pages-1%>>上页</a>
		<a href=showperson.asp?id=<%=id%>&pages=<%=pages+1%>>下页</a>
		<a href=showperson.asp?id=<%=id%>&pages=<%=maxpage%>>尾页</a>
		</td></tr>
      </table><%end if
	rs.close
	end if%>
				</tr></table></table>
	</div>
</div>
</body>
</html>