📄 user.asp
字号:
<!--#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"> <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"> </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"> </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"),"⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -