user.asp

类似于baidu的百度知道

<!--#include file=conn.asp-->
<!--#include file=Code_Html.asp-->
<!--#include file=Post_Ubb.asp-->
<!--#include file="Config.asp"-->
<!--#include file="md5.asp"-->
<!--#include file="top.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
%>

<title>个人中心</title>
<meta http-equiv=content-type content="text/html; charset=gb2312">

<table width="100%" border="0" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="24" class="greenBG">&nbsp;<b class="p14">&nbsp;&nbsp; ★个人中心★</b></td>
          <td height="24" class="greenBG"> <div align="right" class="p14">
<a href="Exit.asp">
退出登录</a></div>
          </td>
        </tr>
      </table>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
	<tr>
		<td valign="top" width="160">
<table border="0" width="100%" cellspacing="0" cellpadding="0" class="t1">
	<tr>
		<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
	<tr>
		<td height="36" align="center" onmouseover="this.className='tbb'" onmouseout="this.className='taa'" class="taa"><strong><%=rs("name")%></strong></td>
	</tr>
	<tr>
		<td align=center><br>
<table border="0" width="95%" cellspacing="0" cellpadding="0">
	<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="22" id="xxf1" <%if request("lei")="ziliao" then%>bgcolor="#D9F0F0"<%end if%>><a href="user.asp?lei=ziliao"><%if request("lei")="ziliao" then%><b>用户资料</b><%else%>用户资料<%end if%></a></td>
  </tr>
  <tr>
    <td height="22" id="xxf2" <%if request("lei")="gaipass" then%>bgcolor="#D9F0F0"<%end if%>><a href="user.asp?lei=gaipass"><%if request("lei")="gaipass" then%><b>修改密码<b><%else%>修改密码<%end if%></a></td>
  </tr>
  <tr>
    <td height="22" id="xxf3" <%if request("lei")="gaixinxi" then%>bgcolor="#D9F0F0"<%end if%>><a href="user.asp?lei=gaixinxi"><%if request("lei")="gaixinxi" then%><b>修改个人信息<b><%else%>修改个人信息<%end if%></a></td>
  </tr>
</table>
</td>
	</tr>
</table>
<br></td>
	</tr>
</table>
		</td>
	</tr>
</table>
<br>

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="t1">
	<tr>
		<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
	<tr>
		<td height="36" align="center" onmouseover="this.className='tbb'" onmouseout="this.className='taa'" class="taa"><strong>讯息统计</strong></td>
	</tr>
	<tr>
		<td align=center><br>
<table border="0" width="95%" cellspacing="0" cellpadding="0">
	<tr>
<td>
<table border="0" cellpadding="0" cellspacing="2" width="100%">
  <tr>
    <td valign="middle">
<a href="user.asp">查看积分</a><br>
<a href="user.asp?lei=mywen">我的提问</a><br>
<a href="user.asp?lei=myda">我的回答</a> </td>
  </tr>
</table>
</td>
	</tr>
</table>
<br></td>
	</tr>
</table>
		</td>
	</tr>
</table>
<br>


		</td>
		<td valign="top" width="8"></td>
		<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0" class="t1">
	<tr>
		<td>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="100%">
	<tr>
		<td height="36" align="center" onmouseover="this.className='tbb'" onmouseout="this.className='taa'" class="taa"><table width="100%"  border="0" cellpadding="0" cellspacing="0" class="greenBG">
<tr>
<td height="24">
<font class="p14 greenBG pb" id="titName">&nbsp;&nbsp; <b><font size="4">◎</font></b>&nbsp; <b><%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%>                                                                                                                               
</b></td>
</tr>
</table></td>
	</tr>
	<tr>
		<td align=center><br>
<table border="0" width="98%" cellspacing="0" cellpadding="0">
	<tr>
<td>
<%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><%=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="100%"  border="0" cellpadding="3" cellspacing="1" class="t1">
        <tr class="t11"> 
          <td><div align="center"><span><strong>积分明细</strong></div></span></td>
        </tr>
        <tr> 
          <td  height="60"> 
            <table width="95%" border="0" cellspacing="0" cellpadding="3">
              <tr> 
                <td align="right">总分： </td>
                <td><%=rs("jifen")%></td>
              </tr>
              <tr> 
                <td align="right">回答得分：</td>
                <td><%=rs("replynum")%></td>
              </tr>
              <tr> 
                <td align="right">悬赏付出：</td>
                <td>-<%=shangfen%></td>
              </tr>
              <tr> 
                <td align="right">处罚：</td>
                <td><%=rs("fa")%></td>
              </tr>
              <tr> 
                <td align="right">其他扣除：</td>
                <td><%=rs("qtfa")%></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
          <td valign="top" align="center">
		  <table border="0" cellpadding="3" cellspacing="1" width="95%" class="t1">
              <tr class="t11"> 
                <td><div align="center"><strong>回答统计</strong></div></td>
              </tr>
              <tr> 
                <td height="60" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="3">
                    <tr> 
                      <td width="100"><div align="right">回答总数： </div></td>
                      <td><%=rs("replynum")%></td>
                    </tr>
                    <tr> 
                      <td><div align="right">回答被采纳：</div></td>
                      <td><%=rs("helpnum")%></td>
                    </tr>
                    <tr> 
                      <td><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="95%"  border="0" cellpadding="3" cellspacing="1" class="t1">
              <tr class="t11"> 
                <td>
				<p align="center"><strong>提问统计</strong></td>
              </tr>
              <tr> 
                <td height="60" valign="middle"><table width="100%" border="0" cellspacing="0" cellpadding="3">
                    <tr> 
                      <td align="right">提问总数：</td>
                      <td><%=wenti%></td>
                    </tr>
                    <tr> 
                      <td align="right">已解决的问题数：</td>
                      <td><%=jiejue%></td>
                    </tr>
                    <tr> 
                      <td align="right">解决中的问题数：</td>
                      <td><%=weijiejue%></td>
                    </tr>
                    <tr> 
                      <td align="right">被撤销的问题数：</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> 
                <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"),"