<!--#include file=conn.asp-->
<!--#include file=html.asp-->
<!--#include file=postubb.asp-->
<!--#include file="config.asp"-->
<!--#include file="md5.asp"-->
<%if session("person")="" then
	response.write"<script>alert('对不起,您未登录!');window.navigate('login.asp');</script>"
	else
	rs.open"select * from person where name='"&session("person")&"'",conn,1,1
%>

<html><head><title>个人中心</title>
<meta http-equiv=content-type content="text/html; charset=gb2312">
<style type="text/css">
.*{font-family:宋体; }
td{font-size: 12px; line-height: 18px}
.p3	{font-size:13px; line-height: 24px}
.pad10L	{padding-left:10px}
a.cy:link		{color: #7777cc; text-decoration: underline}
a.cy:visited		{color: #7777cc; text-decoration: underline}
.cBaidu{color:#777777}
a.bluelink:link{color:#0033cc;}
a.bluelink:hover{color:#0033cc;}
a.bluelink:visited{color:#800080;}
.f14{font-size:14px;line-height:20px;}
.p14{font-size:14px;}
.pb{font-weight:bold;}
.greenBG{background-color:#D9F0F0;}
.yellowBG{background-color:#D9F0F0}
.tbPad10{padding-top:6px;padding-bottom:6px;}
.tdLine{border-top:1px solid #56BEBE}
.f14ln20	{font-size: 14px; line-height: 20px;}
.ln28		{height:28px; border-top:1px solid #E1E1E1; padding-left:6px;}
.bgpagLn	{ font-family: arial;BORDER:#D9F0F0 1px solid; background-color: #FFFFFF;font-size: 14px;}
.tdline28{border-bottom:1px solid #e1e1e1; height:28px; padding-left:10px;}
</style>
</head>

<body text=#000000 vlink=#261cdc link=#261cdc bgcolor=#ffffff topmargin=0 bottommargin=0>
<table width="100%" border=0 align="center">
  <tr height=60> 
    <td width=139 valign="top" height="69">
    <a href="<%=weburl%>"><img src="img/logo-zhidao1.gif" border="0"></a>
    </td>
    <td valign="bottom"> 
      <table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="24" class="greenBG">&nbsp;<b class="p14">个人中心</b></td>
          <td height="24" class="greenBG"> <div align="right" class="p14">
<a href="exit.asp">
退出登录</a></div>
          </td>
        </tr>
        <tr><td height="20" class="p2" colspan="2"></td></tr>
      </table>
    </td>
  </tr>
</table>
<br>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="134" rowspan="2" valign="top" nowrap>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="22" class="pad10L" id="xxf1">欢迎您！</td>
  </tr>
  <tr>
    <td height="22" class="pad10L" id="xxf2"><b style="font-size:16px "><%=rs("name")%></b></td>
  </tr>
</table>
<hr align="center" width="95%" color="#E1E1E1">
<br><b>个人信息中心</b><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="22" class="pad10L " id="xxf1" <%if request("lei")="ziliao" then%>bgcolor="#D9F0F0"<%end if%>><a class="bluelink" href="user.asp?lei=ziliao"><%if request("lei")="ziliao" then%><b>用户资料</b><%else%>用户资料<%end if%></a></td>
  </tr>
  <tr>
    <td height="22" class="pad10L" id="xxf2" <%if request("lei")="gaipass" then%>bgcolor="#D9F0F0"<%end if%>><a href="user.asp?lei=gaipass" class="bluelink"><%if request("lei")="gaipass" then%><b>修改密码<b><%else%>修改密码<%end if%></a></td>
  </tr>
  <tr>
    <td height="22" class="pad10L" id="xxf3" <%if request("lei")="gaixinxi" then%>bgcolor="#D9F0F0"<%end if%>><a href="user.asp?lei=gaixinxi" class="bluelink"><%if request("lei")="gaixinxi" then%><b>修改个人信息<b><%else%>修改个人信息<%end if%></a></td>
  </tr>
</table>
<div align="right">&nbsp;&nbsp;</div>
<hr align="center" width="95%" color="#E1E1E1">
<br>
<table width="120" border="0" cellpadding="0" cellspacing="2" bgcolor="F7E9D7" class="yellowBG">
  <tr>
    <td nowrap class="pad10L"><a href="<%=weburl%>"><b>问吧首页</b></a></td>
  </tr>
  <tr bgcolor="#ffffff">
    <td height="60" valign="middle" class="pad10L tbPad10">
<a href="user.asp" class="bluelink">查看积分</a><br>
<a href="user.asp?lei=mywen" class="bluelink">我的提问</a><br>
<a href="user.asp?lei=myda" class="bluelink">我的回答</a> </td>
  </tr>
</table>
<br>
</td>
<td width="6" rowspan="2" class="greenBG">&nbsp;</td>
<td height="100%" valign="top"><table width="100%"  border="0" cellpadding="0" cellspacing="0" class="greenBG">
<tr>
<td height="24" class="pad10L">
<font class="p14 greenBG pb" id="titName"><%if request("lei")="" then%>查看积分</font>  <img src="img/tips.gif" width="16" height="16"><%elseif request("lei")="ziliao" then%>用户资料<%elseif request("lei")="gaipass" then%>修改密码<%elseif request("lei")="gaixinxi" then%>修改个人信息<%elseif request("lei")="mywen" then%>我的提问<%elseif request("lei")="myda" then%>我的回答<%end if%>                                                                                                                               
</td>
</tr>
</table>
<br>
<!--resa--><%if request("lei")="" then
rs2.open"select sum(shang) as shangfen from question where sender='"&session("person")&"'",conn,1,1
if rs2.eof then
shangfen="0"
else
shangfen=rs2("shangfen")
end if
rs2.close
rs2.open"select * from question where sender='"&session("person")&"'",conn,1,1
if rs2.eof then
wenti="0"
else
wenti=rs2.recordcount
end if
rs2.close
rs2.open"select * from question where sender='"&session("person")&"' and jie=1",conn,1,1
if rs2.eof then
jiejue="0"
else
jiejue=rs2.recordcount
end if
rs2.close
rs2.open"select * from question where sender='"&session("person")&"' and jie<>1",conn,1,1
if rs2.eof then
weijiejue="0"
else
weijiejue=rs2.recordcount
end if
rs2.close
%>
  <table width="95%" border="0" align="center" cellpadding="5" cellspacing="0">
  <tr valign="top"> 
    <td nowrap class="f14"><%=rs("name")%> ( <%=rs("jifen")%> ) <%=rs("touxian")%></td>                                                                                                                                  
   
  </tr>
</table>  
 <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          
          <td valign="top" align="center">
		  <table width="150"  border="0" cellpadding="3" cellspacing="1" bgcolor="#DBDBDB">
        <tr> 
          <td nowrap bgcolor="#FFFFFF" class="pad10L"><div align="center"><span class="f14"><strong>积分明细</strong></div></span></td>
        </tr>
        <tr bgcolor="#ffffff"> 
          <td  height="60" valign="middle" class="pad10L tbPad10"> 
            <table width="100%" border="0" cellspacing="0" cellpadding="3">
              <tr> 
                <td width="100"><div align="right">总分： </div></td>
                <td width="52"><span class="f14"><%=rs("jifen")%></span></td>
              </tr>
              <tr> 
                <td nowrap><div align="right">回答得分：</div></td>
                <td><%=rs("replynum")%></td>
              </tr>
              <tr> 
                <td><div align="right">悬赏付出：</div></td>
                <td>-<%=shangfen%></td>
              </tr>
              <tr> 
                <td><div align="right">处罚：</div></td>
                <td><%=rs("fa")%></td>
              </tr>
              <tr> 
                <td><div align="right">其他扣除：</div></td>
                <td><%=rs("qtfa")%></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
          <td valign="top" align="center">
		  <table width="150"  border="0" cellpadding="3" cellspacing="1" bgcolor="#DBDBDB">
              <tr> 
                <td nowrap bgcolor="#FFFFFF" class="pad10L"><div align="center"><span class="f14"><strong>回答统计</strong></div></span></td>
              </tr>
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" class="pad10L tbPad10"><table width="100%" border="0" cellspacing="0" cellpadding="3">
                    <tr> 
                      <td width="100" nowrap><div align="right">回答总数： </div></td>
                      <td width="52"><%=rs("replynum")%></td>
                    </tr>
                    <tr> 
                      <td nowrap><div align="right">回答被采纳：</div></td>
                      <td><%=rs("helpnum")%></td>
                    </tr>
                    <tr> 
                      <td nowrap><div align="right">回答被采纳率：</div></td>
                      <td><%if rs("helpnum")=0 then baifenbi=0 else baifenbi=(rs("helpnum")/rs("replynum"))*100 end if%><%=round(baifenbi,2)%>%</td>
                    </tr>
                  </table></td>
              </tr>
            </table></td>
          
    <td valign="top" align="center"> 
      <table width="160"  border="0" cellpadding="3" cellspacing="1" bgcolor="#DBDBDB">
              <tr> 
                <td nowrap bgcolor="#FFFFFF" class="pad10L"><div align="center"><span class="f14"><strong>提问统计</strong></div></span></td>
              </tr>
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" class="pad10L tbPad10"><table width="100%" border="0" cellspacing="0" cellpadding="3">
                    <tr> 
                      <td width="110"><div align="right">提问总数： </div></td>
                      <td width="42"><%=wenti%></td>
                    </tr>
                    <tr> 
                      <td nowrap><div align="right">已解决的问题数：</div></td>
                      <td><%=jiejue%></td>
                    </tr>
                    <tr> 
                      <td nowrap><div align="right">解决中的问题数：</div></td>
                      <td><%=weijiejue%></td>
                    </tr>
                    <tr> 
                      <td nowrap><div align="right">被撤销的问题数：</div></td>
                      <td><%=rs("del")%></td>
                    </tr>
                  </table></td>
              </tr>
            </table>
    </td>

        </tr>
      </table>
      <%elseif request("lei")="ziliao" then%>
 <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          
    <td valign="top" align="left"> 
      <table width="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" width="100%">
                  <table border="0" width="100%">
                    <tr>
                      <td width="18%">用户名：</td>
                      <td width="82%"><%=rs("name")%></td>
                    </tr>
                    <tr>
                      <td width="18%">E-mail：</td>
                      <td width="82%"><%=rs("email")%></td>
                    </tr>
                    <tr>
                      <td width="18%">OICQ：</td>
                      <td width="82%"><%=rs("qq")%></td>
                    </tr>
                    <tr>
                      <td width="18%">注册时间：</td>
                      <td width="82%"><%=rs("time")%></td>
                    </tr>
                    <tr>
                      <td width="18%">上次登录时间：</td>
                      <td width="82%"><%=rs("logintime")%></td>
                    </tr>
                    <tr>
                      <td width="18%">自我简介：</td>
                      <td width="82%"></td>
                    </tr>
                    <tr>
                      <td width="100%" colspan="2">
                        <table border="0" width="100%" cellspacing="0" cellpadding="0">
                          <tr>
                            <td width="20">　</td>
                            <td width="96%"><%=HTMLcode(rs("jianjie"))%></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
    </td>

        </tr>
      </table>
      <%elseif request("lei")="gaixinxi" then
      if request("apply1")="提交修改" then
      if InStr(request("wen"),"or")<>0 or InStr(request("wen"),"'")<>0 or InStr(request("wen"),"`")<>0 or InStr(request("wen"),"=")<>0 or InStr(request("wen"),"-")<>0 or InStr(request("wen"),",")<>0 or InStr(request("wen"),"and")<>0 then 
Response.Write "<script language=JavaScript>{alert('密码提示问题含有非法字符！');history.back();}</script>"
Response.End 
end if
if InStr(request("da"),"or")<>0 or InStr(request("da"),"'")<>0 or InStr(request("da"),"`")<>0 or InStr(request("da"),"=")<>0 or InStr(request("da"),"-")<>0 or InStr(request("da"),",")<>0 or InStr(request("da"),"and")<>0 then 
Response.Write "<script language=JavaScript>{alert('密码提示问题答案含有非法字符！');history.back();}</script>"
Response.End 
end if
if request("email")<>"" then
if Instr(request("email"),"=")>0 or Instr(request("email"),"%")>0 or Instr(request("email"),chr(32))>0 or Instr(request("email"),"?")>0 or Instr(request("email"),"&")>0 or Instr(request("email"),";")>0 or Instr(request("email"),",")>0 or Instr(request("email"),"'")>0 or Instr(request("email"),",")>0 or Instr(request("email"),chr(34))>0 or Instr(request("email"),chr(9))>0 or Instr(request("email"),"")>0 or Instr(request("email"),"$")>0 then
		Response.Write ("<script>alert('友情提示!\n\n邮件地址含有非法字符!');history.back();</script>")
		Response.end
	end if
	if Instr(request("email"),"@")=0 then
		Response.Write ("<script>alert('友情提示!\n\n邮件地址格式不正确!');history.back();</script>")
		Response.end
	end if
	end if
if request("wen")="" then
if request("da")<>"" then
Response.Write "<script language=JavaScript>{alert('密码提示问题为空,不能单独填写提示答案！');history.back();}</script>"
Response.End 
end if
end if

      if request("qq")<>"" then
      if not IsNumeric(request("qq")) then
		Response.Write ("<script>alert('友情提示!\n\nOICQ号码必须是数字!');history.back();</script>")
		Response.end
	end if
	end if
	  if request("name")="" then
	  response.write"<script>alert('用户名不能为空!');history.back();</script>"
	  else
	  name=request("name")
	  sex=request("sex")
	  qq=request("qq")
	  wen=request("wen")
	  da=request("da")
	  email=request("email")
	  jianjie=request("jianjie")
	  rs3.open"select * from person where name='"&name&"'",conn,1,3
	  If Rs3.eof then
		Response.Write ("<script>alert('会员帐号错误已被删除!');history.back();</script>")
		Response.end
	end if
	  rs3("sex")=sex
	  rs3("qq")=qq
	  rs3("question")=wen
	  rs3("answer")=da
	  rs3("email")=email
	  rs3("jianjie")=jianjie
	  rs3.update
	  rs3.close
	  response.write"<script>alert('信息修改成功!');window.navigate('user.asp?lei=gaixinxi');</script>"
	  end if
	  end if

      %>
 <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>      
    <td valign="top" align="left"> <form method=post action=user.asp?lei=gaixinxi>
      <table width="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" width="100%">
                  <table border="0" width="100%">
                    <tr>
                      <td width="18%"><b>基本信息</b></td>
                      <td width="82%"></td>
                    </tr>
                    <tr>
                      <td width="18%">性别：</td>
                      <td width="82%">
          <input type="radio" name="sex" value="男" <%if rs("sex")="男" then%>checked<%end if%>>男   
         <input type="radio" name="sex" value="女" <%if rs("sex")="女" then%>checked<%end if%>>女</td>
                    </tr>
                    <tr>
                      <td width="18%">OICQ：</td>
                      <td width="82%"><input name="qq" type="text" id="em0" size="20" value="<%=rs("qq")%>"> 
                      </td>
                    </tr>
                    <tr>
                      <td width="18%">密码提示问题：</td>
                      <td width="82%"><input name="wen" type="text" id="em1" size="20" value="<%=rs("question")%>"> 
                      </td>
                    </tr>
                    <tr>
                      <td width="18%">密码提示问题答案：</td>
                      <td width="82%"><input name="da" type="text" id="em2" size="20" value="<%=rs("answer")%>"> 
                      </td>
                    </tr>
                    <tr>
                      <td width="18%">E-mail：</td>
                      <td width="82%"><input name="email" type="text" id="em" size="20" value="<%=rs("email")%>"> 
                        <span id="advance1"> <br>
        <font color="#666666">请输入有效的邮件地址，这将使您能用到问吧中的所有功能。</font> </span></td>
                    </tr>
                    <tr>
                      <td width="18%">自我简介：</td>
                      <td width="82%"><textarea  name="jianjie" cols="60" rows="5" wrap="PHYSICAL" id="co"><%=rs("jianjie")%></textarea> 
        <br> <font color="#666666">最多500个汉字，文字将出现在您的个人介绍页面。</font> </td>
                    </tr>
                    <tr>
                      <td width="100%" colspan="2"><input type="hidden" name="name" value="<%=rs("name")%>"></td>
                    </tr>
                    <tr>
                      <td width="100%" colspan="2"><input name="apply1" type="submit" value="提交修改"> 
                        　 <input type="reset" value="重新填写"></td>                   
                    </tr>
                  </table></form>
                </td>
              </tr>
            </table>
    </td>

        </tr>
      </table>
      <%elseif request("lei")="gaipass" then
      if request("apply")="提　交" then
	  if request("name")="" then
	  response.write"<script>alert('用户名不能为空!');history.back();</script>"
	  elseif request("oldpwd")="" then 
	  response.write"<script>alert('旧密码不能为空!');history.back();</script>"
	  elseif request("newpwd")="" then
	  response.write"<script>alert('新密码不能为空!');history.back();</script>"
	  elseif request("newpwd1")="" then
	  response.write"<script>alert('新密码确认不能为空!');history.back();</script>"
	  elseif request("newpwd")<>request("newpwd1") then
	  response.write"<script>alert('新密码与新密码确认不同!');history.back();</script>"
	  else
	  name=request("name")
	  oldpwd=request("oldpwd")
	  newpwd=request("newpwd")
	  newpwd1=request("newpwd1")
	  rs3.open"select * from person where name='"&name&"' and pwd='"&md5(oldpwd)&"'",conn,1,1
	  if rs3.eof then
	  response.write"<script>alert('用户名或旧密码错误!');history.back();</script>"
	  else
	  rs3.close
	  rs3.open"select * from person where name='"&name&"'",conn,1,3
	  rs3("pwd")=md5(newpwd)
	  rs3.update
	  rs3.close
	  response.write"<script>alert('密码修改成功!');window.navigate('user.asp');</script>"
	  end if
	  end if
	  end if
      %>
 <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>      
    <td valign="top" align="left"> <form method=post action=user.asp?lei=gaipass>
      <table width="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" width="100%">
                  <table border="0" width="100%">
                    <tr>
                      <td width="11%">用户名：</td>
                      <td width="89%"><%=rs("name")%></td>
                    </tr>
                    <tr>
                      <td width="11%">旧密码：</td>
                      <td width="89%"><input name="oldpwd" type="password" id="pwd" size="20"></td>
                    </tr>
                    <tr>
                      <td width="11%">新密码：</td>
                      <td width="89%"><input name="newpwd" type="password" id="pwd" size="20"></td>
                    </tr>
                    <tr>
                      <td width="11%">确认密码：</td>
                      <td width="89%"><input name="newpwd1" type="password" id="pwd" size="20"></td>
                    </tr>
                    <tr>
                      <td width="100%" colspan="2"><input type="hidden" name="name" value="<%=rs("name")%>"></td>
                    </tr>
                    <tr>
                      <td width="100%" colspan="2"><input name="apply" type="submit" value="提　交"> 
                        　 <input type="reset" value="重新填写"></td>
                    </tr>
                  </table></form>
                </td>
              </tr>
            </table>
    </td>

        </tr>
      </table>
<%elseif request("lei")="mywen" then
Function displaytime(BaseTime)
  dim date2,date1,sdate,sday,sdate1,shour,sdate2,sminute,sdate3
  date2 = basetime
  date1 = now()
  sdate = datediff("s", date1, date2) '总秒数
  sday = fix(sdate/60/60/24) '天数
  sdate1 = sdate mod 60*60*24 '余数
  shour = fix(sdate1/60/60) '小时
  sdate2 = sdate1 mod 60*60 '余数
  sminute = fix(sdate2/60) '分钟
  sdate3 = sdate2 mod 60 '余数
  if sday>0 then
   response.write sday & " 天"
  end if
  if sday=0 and shour>=0 then

   response.write shour & " 小时"
  end if
  if sday=0 and shour=0 and sminute>=0 then
   response.write sminute & " 分钟"
  end if
  if sday=0 and shour=0 and sminute=0 and sdate3>=0 then
   response.write sdate3 & " 秒"
  end if
  if sdate3<0 then
   response.write "已经关闭"
  end if
End Function
rs2.open"select *  from question where sender='"&rs("name")&"' order by sendtime desc",conn,1,1
		if rs2.eof then%>暂时没有发表任何问题!<%else%>
 <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>      
    <td valign="top" align="left">
      <table width="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" width="100%">
                                  <table width="98%" border="0" align="center" cellspacing="0" class="zhtable">
  <tr>
    <td width="43%" height="30" ><strong>标题</strong></td>
    <td width="7%"  align="center"><strong>回答数</strong></td>
    <td width="9%" align="center"><strong>状态</strong></td>
    <td width="19%" align="center"><strong>提问时间</strong></td>
  </tr>
<%maxnum=rs2.recordcount
		rs2.pagesize=UserMaxPerPage
		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 class="ln28 f14ln20">·<a href=showquestion.asp?id=<%=rs2("id")%> target="_blank"><%=rs2("title")%></a></td>
<td align="center" valign="middle" class="ln28"><font color="#333333"><%=rs2("replys")%></font></td>
<td align="center" valign="middle" class="ln28"><%if rs2("jie")=0 then %><img src=img/icn_time.gif  alt=待解决问题><%elseif rs2("jie")=1 or rs2("jie")=3 then%><img src=img/icn_ok.gif  alt =已解决问题><%elseif rs2("jie")=2 then%><img src=img/icn_cancel.gif  alt =问题已关闭><%elseif rs2("jie")=4 then%><img src=img/icn_vote.gif  alt =投票中问题><%end if%></td> 
<td align="center" valign="middle" class="ln28"><%if rs2("jie")=0 then %>离问题结束还有 <%=displaytime(rs2("overtime"))%><%else%><%=rs2("sendtime")%><%end if%></td>       
</tr>
<%
		rs2.movenext
		if rs2.eof then exit for
		next
		end if
		rs2.close%>
</table></td></tr></table></td></tr>
<tr><td>共发表<font color=red><%=maxnum%></font>个问题，每页显示<%=UserMaxPerPage%>个问题，共<font color=red><%=maxpage%></font>页,当前第<font color=red><%=pages%></font>页                                                                 
		<a href=user.asp?lei=mywen&pages=1>首页</a>       
		<a href=user.asp?lei=mywen&pages=<%=pages-1%>>上页</a>                                                                        
		<a href=user.asp?lei=mywen&pages=<%=pages+1%>>下页</a>                                                                        
		<a href=user.asp?lei=mywen&pages=<%=maxpage%>>尾页</a></td>                                                                        
</tr></table>
<%elseif request("lei")="myda" then
rs2.open"select * from reply where replyer='"&rs("name")&"' order by replytime desc",conn,1,1
if rs2.eof then%>暂时没有回答任何问题!<%else%>
 <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>      
    <td valign="top" align="left">
      <table width="100%"  border="0" cellpadding="0" cellspacing="0">
              <tr bgcolor="#ffffff"> 
                <td height="60" valign="middle" width="100%">
                                  <table width="98%" border="0" align="center" cellspacing="0" class="zhtable">
  <tr>
    <td width="43%" height="30" ><strong>标题</strong></td>
    <td width="7%"  align="center"><strong>回答数</strong></td>
    <td width="9%" align="center"><strong>状态</strong></td>
    <td width="9%" align="center"><strong>被采纳答案</strong></td>
    <td width="19%" align="center"><strong>提问时间</strong></td>
  </tr>
<%maxnum=rs2.recordcount
		rs2.pagesize=UserMaxPerPage
		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
		rs3.open"select * from question where id="&rs2("replyid"),conn,1,1
	    %>
<tr>
<td class="ln28 f14ln20">·<a href=showquestion.asp?id=<%=rs2("replyid")%> target="_blank"><%=rs3("title")%></a></td>
<td align="center" valign="middle" class="ln28"><font color="#333333"><%=rs3("replys")%></font></td>
<td align="center" valign="middle" class="ln28"><%if rs3("jie")=0 then %><img src=img/icn_time.gif  alt=待解决问题><%elseif rs3("jie")=1 or rs3("jie")=3 then%><img src=img/icn_ok.gif  alt =已解决问题><%elseif rs3("jie")=2 then%><img src=img/icn_cancel.gif  alt =问题已关闭><%elseif rs3("jie")=4 then%><img src=img/icn_vote.gif  alt =投票中问题><%end if%></td> 
<td align="center" valign="middle" class="ln28"><%if rs2("isdeal")=1 then %><img src=img/icn_best.gif  alt=被采纳为最佳答案><%else%>&nbsp;<%end if%></td>
<td align="center" valign="middle" class="ln28"><%=rs3("sendtime")%></td>     
</tr>
<%rs3.close
		rs2.movenext
		if rs2.eof then exit for
		next
		end if
		rs2.close%>
</table></td></tr></table></td></tr>
<tr><td>共回答<font color=red><%=maxnum%></font>个问题，每页显示<%=UserMaxPerPage%>个问题，共<font color=red><%=maxpage%></font>页,当前第<font color=red><%=pages%></font>页                                                                 
		<a href=user.asp?lei=myda&pages=1>首页</a>       
		<a href=user.asp?lei=myda&pages=<%=pages-1%>>上页</a>                                                                        
		<a href=user.asp?lei=myda&pages=<%=pages+1%>>下页</a>                                                                        
		<a href=user.asp?lei=myda&pages=<%=maxpage%>>尾页</a></td>                                                                        
</tr></table>

<%end if%>
<!--resa-->
</td>
</tr>
<tr>
<td height="24" valign="bottom"><div class="greenBG" style="height:24px; ">&nbsp;</div></td>
</tr>
</table>
<br>
<%
rs.close
end if
%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" style="clear:both;">  <tr>    <td height="30" align=center><!--#include file=end.asp--></td>   
  </tr>
</table>
</body>
</html>