📄 e_smallclass.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="config.asp"-->
<!--#include file="function.asp"-->
<!--#include file="char.inc"-->
<%
typeid=ChkRequest(request("typeid"),1) '防注入
request_BigClassID=ChkRequest(Request.QueryString("BigClassID"),1) '防注入
request_SmallClassID=ChkRequest(Request.QueryString ("SmallClassID"),1) '防注入
if typeid="" or request_bigclassid="" or request_smallclassid="" then
Response.Write "<script>alert('未指定参数');history.back()</script>"
response.end
else
if not IsNumeric(request_SmallClassID) or not IsNumeric(request_bigclassid) or not IsNumeric(typeid) then
response.write "<script>alert('非法参数');history.back()</script>"
response.end
else
set rs=server.CreateObject("ADODB.RecordSet")
rsSource="select * from "& db_BigClass_Table &" where bigclassid=" & request_BigClassID &" order by BigClassorder"
rs.Open rsSource,conn,1,1
E_BigClassName=rs("E_BigClassName")
bigclassorder=rs("bigclassorder")
bigclasszs=rs("bigclasszs")
rs.close
set rs=nothing
set rs=server.CreateObject("ADODB.RecordSet")
rsSource="select * from "& db_SmallClass_Table &" where smallclassid=" & request_smallClassID &" order by smallClassorder"
rs.Open rsSource,conn,1,1
E_smallclassname=rs("E_smallclassname")
smallclassorder=rs("smallclassorder")
rs.close
set rs=nothing
PageShowSize = 10 '每页显示多少个页
MyPageSize = 20 '每页显示多少条新闻
If Not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Or Request("page") <=0 Then
MyPage=1
Else
MyPage=Int(Abs(Request("page")))
End if
end if
set rs=server.CreateObject("ADODB.RecordSet")
rsSource="select * from "& db_BigClass_Table &" where typeid=" & typeid &" order by BigClassorder"
rs.Open rsSource,conn,1,1
dim ArrayBigClassID(),ArrayE_BigClassName()
ReDim ArrayBigClassID(int(rs.RecordCount)),ArrayE_BigClassName(int(rs.RecordCount))
BigClassCount=rs.RecordCount
for i=1 to BigClassCount
ArrayBigClassID(i)=rs("BigClassID")
ArrayE_BigClassName(i)=trim(rs("E_BigClassName"))
rs.MoveNext
next
rs.close
set rs=nothing
set rs2=server.CreateObject("ADODB.RecordSet") '专题
rs2.Source="select Top "& top_sp &" * from "& db_Special_Table &" order by SpecialID DESC "
rs2.Open rs2.Source,conn,1,1
set rs4=server.CreateObject("Adodb.RecordSet")
rs4.source="select * from "& db_SmallClass_Table &" Where BigClassid=" & request_BigClassid &" order by SmallClassorder"
rs4.open rs4.source,conn,1,1
SmallClassCount=rs4.RecordCount
dim ArraySmallClassID(10000),ArrayE_smallclassname(10000)
for i=1 to SmallClassCount
ArraySmallClassID(i)=rs4("SmallClassID")
ArrayE_smallclassname(i)=trim(rs4("E_smallclassname"))
rs4.MoveNext
next
rs4.Close
set rs4=nothing
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=E_smallclassname%>__<%=E_BigClassName%>__<%=jjgn%>_建站铺修正版_bbs.jzpu.com</title>
<LINK href="news.css" rel="stylesheet">
</head>
<!--#include file=top.asp -->
<body>
<table width="760" height="386" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="210" valign="top" bgcolor="FEE8E8">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<!--总栏顺序号标记-->
<%
dim typeorder
set rs8=server.CreateObject("ADODB.RecordSet")
rs8.Source="select * from "& db_type_Table &" where typeid=" & typeid &" order by typeorder"
rs8.Open rs8.Source,conn,1,1
typeorder=rs8("typeorder")
rs8.Close
set rs8=nothing
%>
<!--总栏顺序号标记-->
<tr>
<td height="30" align="center" valign="middle" background="IMAGES/red_bg.jpg" class="white_title"><%=E_smallclassname%>·小类 <%=typeorder%>-<%=bigclassorder%>-<%=smallclassorder%></td>
</tr>
<%
set rs6=server.CreateObject("ADODB.RecordSet")
rs6.Source="select * from "& db_SmallClass_Table &" where BigClassId="&request_bigclassid&" order by SmallClassorder"
rs6.Open rs6.Source,conn,1,1
do while not rs6.eof%>
<tr>
<td align=center valign="middle"><a class="blacklink" href="E_SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=rs6("bigclassid")%>&smallclassid=<%=rs6("smallclassid")%>"><%=rs6("E_smallclassname")%></a></td>
</tr>
<%rs6.movenext
loop
rs6.Close
set rs6=nothing
%>
<tr>
<td height="30" valign="middle" background="IMAGES/red_bg.jpg" class="vote_title">
本月最新</td>
</tr>
<tr>
<td>
<%
dim ii
ii = 0
if uselevel=1 then
if Request.cookies(eChuang)("key")="" then
rsSource="select top " & top_txt & " * from "& db_News_Table &" where year(updatetime)="& year(now()) &" and month(updatetime)="& month(now())&" and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc" '选择本月
end if
if Request.cookies(eChuang)("key")="selfreg" then
if Request.cookies(eChuang)("reglevel")=3 then
rsSource="select top " & top_txt & " * from "& db_News_Table &" where year(updatetime)="& year(now()) &" and month(updatetime)="& month(now())&" and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc" '选择本月
end if
if Request.cookies(eChuang)("reglevel")=2 then
rsSource="select top " & top_txt & " * from "& db_News_Table &" where year(updatetime)="& year(now()) &" and month(updatetime)="& month(now()) &" and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc" '选择本月
end if
if Request.cookies(eChuang)("reglevel")=1 then
rsSource="select top " & top_txt & " * from "& db_News_Table &" where year(updatetime)="& year(now()) &" and month(updatetime)="& month(now()) &" and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc" '选择本月
end if
end if
if Request.cookies(eChuang)("key")="super" or Request.cookies(eChuang)("key")="typemaster" or Request.cookies(eChuang)("key")="bigmaster" or Request.cookies(eChuang)("key")="smallmaster" or Request.cookies(eChuang)("key")="check" then
rsSource="select top " & top_txt & " * from "& db_News_Table &" where year(updatetime)="& year(now()) &" and month(updatetime)="& month(now()) &" and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc" '选择本月
end if
else
rsSource="select top "& top_txt &" * from "& db_News_Table
' &" where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc" '选择本月
end if
set rs=server.CreateObject("ADODB.RecordSet")
rs.Open rsSource,conn,1,3
if rs.bof and rs.eof then
response.write "<br><div align=center>本月无更新<div>"
else
do while not rs.eof
title=htmlencode4(trim(rs("title")))
%>
·
<%
typeid=checkstr(request("typeid"))
set rs11=server.CreateObject("ADODB.RecordSet")
rs11.Source="select * from "& db_Type_Table &" where typeid="&typeid&" order by typeorder"
rs11.Open rs11.Source,conn,1,1
mode=rs11("mode")
rs11.close
set rs11=nothing%>
<%if mode<>4 then%>
<%if mode="2" then%>
<%if rs("picname")<>"" then%>
<img src='images/news_img.gif' border='0'>
<%end if%>
<%end if%>
<a class=middle href="E_ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank"> <font color="<%=rs("titlecolor")%>"><%=gottopic(title,14)%></font></a><font color="#FF0000"> <%=rs("click")%></font>
<%else%>
<%if mode="2" then%>
<%if rs("picname")<>"" then%>
<img src='images/news_img.gif' border='0'>
<%end if%>
<%end if%>
<a class=middle href="E_ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank"> <font color="<%=rs("titlecolor")%>"><%=gottopic(title,12)%></font></a><font color="#FF0000"> <%=rs("click")%></font>
<%end if%>
<br>
<%
ii = ii + 1
if ii>50 then exit do
rs.movenext
loop
end if
rs.close
set rs=nothing
%> </td>
</tr>
</table>
</td>
<td width="550" valign="top" bgcolor="#FFFFFF" class="white_link">
<div align="center">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30" background="IMAGES/menu_bg.jpg" class="white_link"> <%
dim typename
set rs5=server.CreateObject("ADODB.RecordSet")
rs5.Source="select * from "& db_Type_Table &" where typeid=" & typeid &" order by typeorder"
rs5.Open rs5.Source,conn,1,1
typename=rs5("typename")
rs5.Close
set rs5=nothing
%>
<%=bigclasszs%>栏目导航 <a class="white_link" href="./" >网站首页</a>>><a class="white_link" href="E_Type.asp?typeid=<%=typeid%>"><%=typename%></a>>><a class="white_link" href='E_BigClass.asp?typeid=<%=typeid%>&BigClassID=<%=request_BigClassID%>'><%=E_BigClassName%></a>>><%=E_smallclassname%></td>
</tr>
<tr>
<td><script language=javascript src=./zongg/ad.asp?i=16></script></td>
</tr>
</table>
<!--模版开始-->
<% select case bigclasszs %>
<% case "1" %>
<!--图片模版-->
<%
set rs3=server.CreateObject("ADODB.RecordSet")
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber4">
<tr>
<td height="30" background="IMAGES/menu_bg.jpg" class="white_link"> <%=E_smallclassname%></td>
</tr>
<%
set rs3=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies(eChuang)("key")="super" or Request.cookies(eChuang)("key")="typemaster" or Request.cookies(eChuang)("key")="bigmaster" or Request.cookies(eChuang)("key")="smallmaster" or Request.cookies(eChuang)("key")="check" then
rs3.Source="select * from "& db_News_Table &" where (SmallClassid=" & request_SmallClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies(eChuang)("key")="" then
rs3.Source="select * from "& db_News_Table &" where (SmallClassid=" & request_SmallClassid &" and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(eChuang)("key")="selfreg" then
if Request.cookies(eChuang)("reglevel")=3 then
rs3.Source="select * from "& db_News_Table &" where (SmallClassid=" & request_SmallClassid &" and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(eChuang)("reglevel")=2 then
rs3.Source="select * from "& db_News_Table &" where (SmallClassid=" & request_SmallClassid &" and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(eChuang)("reglevel")=1 then
rs3.Source="select * from "& db_News_Table &" where (SmallClassid=" & request_SmallClassid &" and checkked=1 ) order by newsid DESC"
end if
end if
else
rs3.Source="select * from "& db_News_Table &" where (SmallClassid=" & request_SmallClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
if not rs3.EOF then
Rs3.PageSize = MyPageSize
MaxPages = Rs3.PageCount
Rs3.absolutepage = MyPage
total = Rs3.RecordCount
i = 0
%>
<tr>
<td> <table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
<!--图片换行显示1-->
<% do until rs3.Eof or i = rs3.PageSize %>
<tr>
<%
fileExt=lcase(getFileExtName(rs3("picname")))
Content=htmlencode4(rs3("Content"))
content=replace(content,"[---分页---]","")
%>
<% if not rs3.EOF then %>
<td width=25% align=center valign="top" style="table-layout:fixed; word-break:break-all"> <div align="center">
<% content=htmlencode4(rs3("Content"))
content=replace(content,"[---分页---]","")%>
<a class=middle href="E_ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=CutStr(nohtml(Content),150)%>">
<%if rs3("picname")=("") then%>
<img src="IMAGES/flashorno.gif" width="110" height="80" border=1 style=border-color:#000000 align=top>
<%else%>
<%if fileext="jpg" or fileext="bmp" or fileext="png" or fileext="gif" then%>
<img src="<%=FileUploadPath & rs3("picname")%>" width="110" height="80" border=1 style=border-color:#000000 align=top>
<%end if%>
<%if fileext="swf" then%>
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' width="110" height="80" border=0 >
<param name=movie value="<%=FileUploadPath & rs3("picname")%>">
<param name=quality value=high>
<param name='Play' value='-1'>
<param name='Loop' value='0'>
<param name='Menu' value='-1'>
<embed src="<%=FileUploadPath & rs3("picname")%>" width="110" height="80" border=0 pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash'></embed>
</object>
<%end if%>
<%end if%>
</a><br>
<br>
<a class=middle href="E_ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=htmlencode4(rs3("title"))%>"> <%=CutStr(rs3("title"),18)%> </a> </div></td>
<%rs3.movenext
i = i + 1
end if
%>
<!--图片换行显示2-->
<td width=25% align=center valign="top" style="table-layout:fixed; word-break:break-all"> <% if not rs3.EOF then %>
<div align="center">
<%
fileExt=lcase(getFileExtName(rs3("picname")))
Content=htmlencode4(rs3("Content"))
content=replace(content,"[---分页---]","")
%>
<a class=middle href="E_ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=CutStr(nohtml(Content),150)%>">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -