?? user.asp
字號:
<!--#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"> <b class="p14"> ★個人中心★</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"> <b><font size="4">◎</font></b> <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"),"?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -