% Manage=True %>
<%
nrtable=request("table-data")
fltable=request("table-class")
bigname=request("bigname")
smallname=request("smallname")
action=request("action")
eid=request("eid")
If request("cat")<>"" And IsNumeric(request("cat")) And request("dhid")<>"" And IsNumeric(request("dhid")) Then
dhid=Int(request("dhid"))
cat=Int(request("cat"))
Else
response.write "
请选择左侧栏目
"
response.end
End If
filterKeys=",pageno,action,"
backUrl=GetBackUrl(",pageno,action,id,keyword,")
If action="Add" Then
Call Add()
ElseIf action="SaveAdd" Then
Call SaveAdd()
ElseIf action="Modify" Then
Call Modify()
ElseIf action="SaveModify" Then
Call SaveModify()
ElseIf action="delete" Then
Call Delete()
ElseIf action="Att" Then
Call Att()
Else
Call main()
End If
Sub main()
%>
文章管理
[<%=bigname%>-<%=smallname%>]列表管理
ID
标题
图片
首页
固定
置顶
推荐
热门
推广
专题
轮换
上传时间
上传者
管理
<%
Set oRs=Server.CreateObject("ADODB.RecordSet")
sql_add = ""
If request("id") <> "" Then
sql_add = " And Id " & request("releate") & Int(request("Id"))
End If
If request("flag") <> "无" And request("flag") <> "" Then
sql_add = sql_add & " And biaozhu ='" & request("flag") &"'"
End If
If request("keyword") <> "" Then
sql_add = sql_add & " And (title_a like '%" & request("keyword") &"%' or content like '%" & request("keyword") &"%') "
If InStr(request("keyword"),"title:")>0 Then
sql_add =sql_add & " And (title_a like '%" & Replace(request("keyword"),"title:","") &"%' ) "
End If
End If
top = 100
If sql_add<>"" Then top = 500
sql="select top "&top&" * from "&nrtable&" where cid="&cat&" "&sql_add&" order by px desc,id desc "
oRs.Open sql,conn,1,1
'PageBar="No Data!"
IntRows=20
If Not oRs.eof Then
Call page_setup(oRs,IntRows)
PageBar=PageToHtml(backUrl&"&id="&request("Id")&"&keyword="&request("keyword"))
Do While Not oRs.eof And IntRows>0
If oRs("img")<>"" Then
smallImg=oRs("img")
If LCase(Left(oRs("img"),4))<>"http" And LCase(Left(oRs("img"),1))="u" Then
smallImg="/"&smallImg
End If
ImgTag=""
Else
ImgTag=""
End If
%>
<%=ImgBrowse%><%
If oRs("html_url")<>"" Then
response.Write ""&left(oRs("title_a"),24)&""
Else
response.Write(left(oRs("title_a"),24))
End If
If oRs("biaozhu")<>"" And oRs("biaozhu")<>"无" Then
response.Write " ["&oRs("biaozhu")&"]"
End If
If Int(oRs("px"))>0 Then
response.write "("&oRs("px")&")"
End If
%>
<%
End Sub
rem : 修改信息
Sub Modify()
set rs=server.createobject("adodb.recordset")
sql="select * from "&nrtable&" where id="&eid&""
rs.open sql,conn,1,1
%>
文章管理