📄 e_bigclass.asp
字号:
<%@ Language=VBScript%>
<!--#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) '防注入
if typeid="" or request_bigclassid="" then
Show_Err("未指定参数<br><br><a href='javascript:history.back()'>返回</a>")
response.end
else
if not IsNumeric(request_BigClassID) or not IsNumeric(typeid) then
Show_Err("非法参数<br><br><a href='javascript:history.back()'>返回</a>")
response.end
else
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_BigClass_Table &" where bigclassid=" & request_bigclassid &" order by BigClassorder"
rs.Open rs.Source,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")
rs.Source="select * from "& db_BigClass_Table &" where typeid=" & typeid &" order by BigClassorder"
rs.Open rs.Source,conn,1,1
dim digclassid
bigclassid=ChkRequest(request("bigclassid"),1) '防注入
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_smallClass_Table &" where bigclassid="& bigclassid &" order by smallClassorder"
rs.Open rs.Source,conn,1,1
i=1
Dim ArraysmallClassID(), ArrayE_smallclassname(), ArrayE_smallclassview()
ReDim ArraysmallClassID(int(rs.RecordCount)), ArrayE_smallclassname(int(rs.RecordCount)), ArrayE_smallclassview(int(rs.RecordCount))
if not rs.EOF then
rseof=1
end if
end if
while not rs.EOF
abcount=rs.RecordCount
E_smallclassview=rs("E_smallclassview")
smallClassID=rs("smallClassID")
E_smallclassname=trim(rs("E_smallclassname"))
ArrayE_smallclassview(i)=E_smallclassview
ArraysmallClassID(i)=smallClassID
ArrayE_smallclassname(i)=E_smallclassname
i=i+1
rs.MoveNext
wend
rs.close
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
rs2.close
set rs2=nothing
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
for i=1 to SmallClassCount
ArraySmallClassID(i)=rs4("SmallClassID")
ArrayE_smallclassname(i)=rs4("E_smallclassname")
rs4.MoveNext
next
rs4.Close
set rs4=nothing
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")
typeorder=rs5("typeorder")
rs5.Close
set rs5=nothing
end if
%>
<html><head>
<meta http-equiv="Content-Type" content="">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=E_BigClassName%>__<%=typeName%>__<%=jjgn%>_建站铺修正版_bbs.jzpu.com</title>
<LINK href="news.css" rel="stylesheet">
</head>
<body>
<!--#include file="top.asp"-->
<%
dim E_BigClassName
bigclassid=ChkRequest(request("bigclassid"),1) '防注入
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from "& db_bigclass_Table &" where bigclassid="& bigclassid &" order by bigclassorder"
rs.Open rs.Source,conn,1,1
E_BigClassName=rs("E_BigClassName")
rs.close
set rs=nothing
%>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr valign="top">
<td width="210" rowspan="0" bgcolor="#FEE8E8"><table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td height="30" align="center" background="IMAGES/red_bg.jpg"><span class="white_title"><%=E_BigClassName%>·大类 <%=Typeorder%>-<%=bigclassorder%></span></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=class 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" align=center background="IMAGES/red_bg.jpg"><span class="white_title">最新图文</span> </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 top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(eChuang)("key")="" then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and newslevel=0 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(eChuang)("key")="selfreg" then
if Request.cookies(eChuang)("reglevel")=3 then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(eChuang)("reglevel")=2 then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies(eChuang)("reglevel")=1 then
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
end if
else
rs3.Source ="select top " & top_img & " * from "& db_News_Table &" where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
rs3.Open rs3.Source,conn,1,1
if not rs3.EOF then
while not rs3.EOF
fileExt=lcase(getFileExtName(rs3("picname")))
Content=htmlencode4(rs3("Content"))
%>
<tr>
<td style="WORD-WRAP: break-word"> <a class=middle href="E_ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=htmlencode4(rs3("title"))%>">
<%if fileext="jpg" or fileext="bmp" or fileext="png" or fileext="gif" then%>
<img src="<%=FileUploadPath & rs3("picname")%>" width="65" height="65" border=0 align="left">
<%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="65" height="65" border=0 align="left">
<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="65" height="65" border=0 align="left" pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash'></embed>
</object>
<%end if%>
<%=rs3("title")%> </a> </td>
</tr>
<%
rs3.MoveNext
wend
else
Response.Write "<tr><td width=100% align=center height=18 >暂无</td></tr>"
end if
rs3.close
set rs3=nothing
%>
</table>
</td>
<td width="550" rowspan="0">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="30" background="IMAGES/menu_bg.jpg"><span class="white_link"> 栏目导航 <a href="./" class="white_link">网站首页</a>>><a href=E_Type.asp?typeid=<%=typeid%> class="white_link"><%=typename%></a>
<% Response.Write ">>" & E_BigClassName & "" %>
</span></td>
</tr>
<tr>
<td>
<script language=javascript src=./zongg/ad.asp?i=16></script></td>
</tr>
<tr><td>
<!--无小类文章区开始-->
<% select case cint(bigclasszs)%>
<% case 1 %>
<!--图片模版-->
<table border="0" cellpadding="3" cellspacing="0" width="100%">
<%set rsnosmall=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
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1) order by newsid DESC"
end if
if Request.cookies(eChuang)("key")="" then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(eChuang)("key")="selfreg" then
if Request.cookies(eChuang)("reglevel")=3 then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(eChuang)("reglevel")=2 then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
if Request.cookies(eChuang)("reglevel")=1 then
rsnosmall.Source="select top " & bigclassshownum & " * from "& db_News_Table &" where (bigClassID=" & bigClassID &" and smallclassid is null and checkked=1 ) order by newsid DESC"
end if
end if
else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -