📄 index.asp
字号:
<!--#include file=conn.asp--><HTML><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head><title>问吧-解决你的疑难杂症</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="Content-Language" content="gb2312" />
<?xml version="1.0" encoding="gb2312"?>
<meta content="all" name="robots" />
<LINK href="/img/index/index.css" type=text/css
rel=stylesheet>
<style TYPE="text/css">
<!--
A:link{text-decoration:none}
A:visited{text-decoration:none}
A:hover {color: #000000;text-decoration:underline}
-->
</style>
<style type="text/css">
<!--
.zhtable {table-layout:fixed; word-wrap:break-word;}
.formfont {FONT-SIZE: 16px;font-family:"arial"}
.input2 {font-size:14px;width:90px;height:24px}
td {font-size: 9pt; line-height: 18px;font-family: "Arial";}
.bnsrh {padding-top:2px;height:24px}
.bgbdy {background-color: #FFFFFF;margin:0px}
.bgtle {border-top: #58CB64 1px solid; background-color: #DDF1D8; padding-left: 10px; padding-right: 10px; height:24px; font-weight:bold; font-size: 14px;}
.bgtleBl {border-top: #64B7D7 1px solid; background-color: #DEEEF4; padding-left: 10px; padding-right: 10px; height:24px; font-weight:bold; font-size: 14px;}
.bgtleYl {border-top: #F4BF20 1px solid; background-color: #FBF5C6; padding-left: 10px; padding-right: 10px; height:24px; font-weight:bold; font-size: 14px;}
.bgcntBor3 {BORDER-left: #DDF1D8 2px solid; BORDER-right: #DDF1D8 2px solid; BORDER-bottom: #DDF1D8 2px solid; background-color: #FFFFFF; padding-left: 8px; padding-top: 5px; padding-right: 5px; padding-bottom: 5px;}
.bgcntBor3Bl {BORDER-left: #DEEEF4 2px solid; BORDER-right: #DEEEF4 2px solid; BORDER-bottom: #DEEEF4 2px solid; background-color: #FFFFFF; padding-left: 8px; padding-top: 5px; padding-right: 5px; padding-bottom: 5px;}
.bgcntBor3Yl {BORDER-left: #FBF5C6 2px solid; BORDER-right: #FBF5C6 2px solid; BORDER-bottom: #FBF5C6 2px solid; background-color: #FFFFFF; padding-left: 8px; padding-top: 5px; padding-right: 5px; padding-bottom: 5px;}
.bgcntBor4 {BORDER: #DDF1D8 2px solid; background-color: #FFFFFF; padding-left: 8px; padding-top: 5px; padding-right: 5px; padding-bottom: 5px;}
.yelB4 {BORDER: #FBF5C6 2px solid; background-color: #FFFFFF; padding-left: 8px; padding-top: 5px; padding-right: 5px; padding-bottom: 5px;}
.ln23 {height:23px;border-bottom:1px solid #E1E1E1;}
.f14 {font-size: 14px;line-height: 22px;}
.f14B {font-size: 14px; font-weight:bold;line-height: 22px;}
.f12gn {color:#008800;}
a.gn:link {color:#008800;}
a.gn:visited {color:#008800;}
a.rib:link {color:#FF0000;font-weight:bold}
a.rib:visited {color:#FF0000;font-weight:bold}
.magBtm12{margin-bottom:12px;}
a:link {text-decoration: underline;Color:#0000cc;}
a:visited {text-decoration: underline;Color:;}
a.lbk:link {color:#000000; text-decoration: underline}
a.lbk:visited {color: #000000; text-decoration: underline}
a.lwe:link {color:#FFFFFF; text-decoration: underline}
a.lwe:visited {color: #FFFFFF; text-decoration: underline}
a.lmore:link {font-weight:bold; text-decoration: underline}
a.lmore:visited {font-weight:bold; text-decoration: underline}
a.cy:link {color: #7777cc; text-decoration: underline}
a.cy:visited {color: #7777cc; text-decoration: underline}
a.headTit:link{color:#0000cc;font-size:14px; line-height: 24px;}
a.headTit:visited{color:#0000cc;font-size:14px; line-height: 24px;}
.headTitB{font-weight:bold;font-size:14px; line-height: 24px;font-family: "Arial";}
.tab{font-size:14px; line-height: 24px;font-family: "Arial";}
.cBaidu{color:#777777}
.per80{line-height:80%}
a.lgy:link {color:#555555; text-decoration: underline}
a.lgy:visited {color: #555555; text-decoration: underline}
.topic{margin-bottom:12px;width:376px;height:38px;border:1px solid #00CC00;background-color:F1FFED;font-size:14px}
#footer{ CLEAR: both; MARGIN: 0px 0px 0px 0px; PADDING: 5px; WIDTH: 770px; font-size: 9pt; line-height: 18px;font-family: "Arial";}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>首页 | 注册 | 登陆 | 密码保护 | 取回密码</title>
</head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" link="#000000" vlink="#000000" alink="#000000">
<div align="center">
<table border="0" width="760" id="table1" style="border-collapse: collapse">
<tr>
<td width="139"><IMG
src="img/logo-zhidao.gif" border=0></td>
<td>
<TABLE cellSpacing=0 cellPadding=0 border=0 id="table2">
<TBODY>
<TR>
<TD class=tab noWrap><font style="font-size:14px"><span class="style4">
<a href="index.asp" style="text-decoration: underline">
<font color="#000000">首页</font></a> |
<a href="reg.asp" style="text-decoration: underline">
<font color="#000000">注册</font></a> |
<a href="index.asp" style="text-decoration: underline">
<font color="#000000">登陆</font></a> |
<a href="applypwd.asp" style="text-decoration: underline">
<font color="#000000">密码保护</font></a> |
<a href="getpwd.asp" style="text-decoration: underline">
<font color="#000000">取回密码</font></a></span></font></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 border=0 id="table3">
<TBODY>
<TR>
<TD noWrap style="font-size: 9pt; line-height: 18px; font-family: Arial"><form method=post action=search.asp>
<p>
<input name="content" type="text" id="content" value="" size="50">
<input type="submit" name="Submit" value="站内搜索""></TD></form></TR></TBODY></TABLE>
</td>
</tr>
</table>
<br>
<div align="center">
<table border="0" width="760" id="table5" style="border-collapse: collapse">
<tr>
<td width="157" valign="top">
<TABLE class=zhtable height="100%" cellSpacing=0 cellPadding=0 width=155
border=0 id="table13">
<TBODY>
<TR>
<TD class=bgtleBl noWrap>问题分类</TD></TR>
<TR>
<TD class=bgcntBor3Bl vAlign=top><SPAN
class=f12gn><font color="#000000"><%rs.open"select * from person",conn,1,1
totalperson=rs.recordcount
rs.close
rs.open"select * from question",conn,1,1
totalquestion=rs.recordcount
rs.close
rs.open"select * from reply",conn,1,1
totalreply=rs.recordcount
rs.close
dealnum=0
rs.open"select * from question",conn,1,1
while not rs.eof
rs2.open"select * from reply where replyid="&rs("id"),conn,1,1
for i=1 to rs2.recordcount
if rs2("isdeal")=1 then
dealnum=dealnum+1
exit for
end if
rs2.movenext
next
rs2.close
rs.movenext
wend
rs.close
undealnum=totalquestion-dealnum
rs.open"select distinct sender from question",conn,1,1
sendernum=rs.recordcount
rs.close
undealsendernum=0
rs.open"select * from question",conn,1,1
while not rs.eof
rs2.open"select * from reply where replyid="&rs("id")&" and isdeal=1",conn,1,1
if rs2.eof then
undealsendernum=undealsendernum+1
end if
rs2.close
rs.movenext
wend
rs.close
today=year(now)&"-"&month(now)&"-"&day(now)
rs.open"select * from question where sendtime like '%"&today&"%'",conn,1,1
updatequestion=rs.recordcount
rs.close
rs.open"select * from reply where replytime like '%"&today&"%'",conn,1,1
updatereply=rs.recordcount
rs.close
%>问题吧总用户<%=totalperson%>个<br>共有<%=totalquestion%>个问题<br>共有<%=totalreply%>个回复<br>已解决的问题数<%=dealnum%><br>没解决的问题数<%=undealnum%></font><font color=red><table width="100%" height="67" border="0" cellpadding="0" cellspacing="0" style="border-bottom:1pt solid dddddd;" id="table14">
<%rs.open"select top 100 * from assort",conn,1,1
if rs.eof then%>
<tr align="right">
<td height="20">暂时没有分类!</td>
</tr>
<%else%>
<tr><%while not rs.eof
i=i+1%>
<td height="30" bgcolor="#FFFFFF"> ·<a href=assort.asp?id=<%=rs("id")%>><font color="#000000"><%=rs("topic")%></font></a></td>
<%rs.movenext
if i>=2 then
i=0%>
</tr>
<tr>
<%end if
wend
end if
rs.close%>
</tr>
<%rs.open"select * from assort",conn,1,1
if rs.recordcount>8 then%>
<tr>
<td height="20" align="right"><a href="assort.asp">
<span style="text-decoration: none"><font color="#000000">更多分类</font></span></a></td>
</tr><%end if
rs.close%>
</table>
</font></SPAN><font color=red>
<TABLE class="magBtm12 zhtable" cellSpacing=0 cellPadding=0 width="99%"
border=0 id="table18">
<TBODY>
<TR>
<TD bgcolor="#F4BF20" height="1"></TD></TR>
<TR>
<TD bgcolor="#FBF5C6" height="23"><b>
<span style="font-size: 11pt">总积分排行榜</span></b></TD></TR>
<TR>
<TD class=bgcntBor3Yl vAlign=top><%rs.open"select top 5 * from person order by id desc",conn,1,1
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -