?? admin_articlemanagespecial.asp
字號:
<%@language=vbscript codepage=936 %>
<%
option explicit
response.buffer=true
Const PurviewLevel=2
Const CheckChannelID=2
Const PurviewLevel_Article=2
%>
<!--#include file="inc/conn.asp"-->
<!--#include file="inc/config.asp"-->
<!--#include file="Admin_ChkPurview.asp"-->
<!--#include file="inc/ubbcode.asp"-->
<!--#include file="inc/function.asp"-->
<!--#include file="inc/admin_code_article.asp"-->
<%
dim strFileName,FileName
const MaxPerPage=20
dim totalPut,CurrentPage,TotalPages
dim i,j
dim keyword,strField
dim sql,rsArticleList
dim ClassID,SpecialID,SpecialName
FileName="Admin_ArticleManageSpecial.asp"
ClassID=Trim(request("ClassID"))
SpecialID=trim(request("SpecialID"))
keyword=trim(request("keyword"))
if keyword<>"" then
keyword=ReplaceBadChar(keyword)
end if
strField=trim(request("Field"))
if ClassID="" then
ClassID=0
else
ClassID=CLng(ClassID)
end if
if SpecialID="" then
SpecialID=0
else
SpecialID=Clng(SpecialID)
end if
strFileName=FileName & "?SpecialID=" & SpecialID & "&ClassID=" & ClassID & "&strField=" & strField & "&keyword=" & keyword
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
dim rsSpecial,sqlSpecial
sqlSpecial="select * from Special"
set rsSpecial=server.CreateObject("adodb.recordset")
rsSpecial.open sqlSpecial,conn,1,1
sql="select Article.ArticleID,Article.SpecialID,Special.SpecialName,Article.Title,Article.Key,Article.Author,Article.CopyFrom,Article.UpdateTime,Article.Editor,"
sql=sql & "Article.Hits,Article.OnTop,Article.Hot,Article.Elite,Article.Passed,Article.IncludePic,Article.Stars,Article.PaginationType,Article.ReadLevel,Article.ReadPoint from article"
sql=sql & " left join Special on Article.SpecialID=Special.SpecialID where Article.Deleted=False "
if SpecialID>0 then
sql=sql & " and Article.SpecialID=" & SpecialID
end if
if ClassID>0 then
sql=sql & " and Article.ClassID=" & ClassID
end if
if strField<>"" then
if keyword<>"" then
select case strField
case "Title"
sql=sql & " and Title like '%" & keyword & "%' "
case "Content"
sql=sql & " and Content like '%" & keyword & "%' "
case "Author"
sql=sql & " and Author like '%" & keyword & "%' "
case "Editor"
sql=sql & " and Editor like '%" & keyword & "%' "
case else
sql=sql & " and Title like '%" & keyword & "%' "
end select
end if
end if
sql=sql & " order by Article.articleid desc"
Set rsArticleList= Server.CreateObject("ADODB.Recordset")
rsArticleList.open sql,conn,1,1
%>
<html>
<head>
<title>專題文章管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<link rel="stylesheet" type="text/css" href="Admin_Style.css">
<SCRIPT language=javascript>
function unselectall()
{
if(document.myform.chkAll.checked){
document.myform.chkAll.checked = document.myform.chkAll.checked&0;
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.Name != "chkAll"&&e.disabled==false)
e.checked = form.chkAll.checked;
}
}
function ConfirmDel()
{
if(document.myform.Action.value=="DelFromSpecial")
{
document.myform.action="Admin_ArticleDel.asp";
if(confirm("確定要將選中的文章從其所屬專題中刪除嗎？操作成功后文章將不屬于任何專題。"))
return true;
else
return false;
}
else
{
document.myform.action="Admin_ArticleMove.asp";
if(confirm("確定要將選中的文章移動到指定的專題嗎？"))
return true;
else
return false;
}
}
</SCRIPT>
</head>
<body leftmargin="2" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="border">
<tr class="topbg">
<td height="22" colspan="2" align="center"><strong>專 題 文 章 管 理</strong></td>
</tr>
<tr class='tdbg'>
<td width="70"><strong>專題列表：</strong> </td>
<td >
<%
if rsSpecial.bof and rsSpecial.eof then
response.write "沒有任何專題"
else
response.write "<table width=100% border=0 cellspacing=1 cellpadding=2><tr>"
i=1
do while not rsSpecial.eof
if rsSpecial("SpecialID")=SpecialID then
SpecialName=rsSpecial("SpecialName")
response.write "<td><a href='" & FileName & "?SpecialID=" & SpecialID & "'><font color=red>" & SpecialName & "</font></a></td>"
else
response.write "<td><a href='" & FileName & "?SpecialID=" & rsSpecial("SpecialID") & "'>" & rsSpecial("SpecialName") & "</a></td>"
end if
i=i+1
if i mod 10 =0 then
response.write "</tr><tr>"
end if
rsSpecial.movenext
loop
response.write "</tr></table>"
end if
%>
</td>
</tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="22">您現在的位置：<a href="Admin_ArticleManageSpecial.asp">專題文章管理</a> >> <%
if SpecialID=0 then
response.write "所有文章"
else
response.write SpecialName
end if
%>
</td>
</tr>
</table>
<%
if rsArticleList.eof and rsArticleList.bof then
totalPut=0
if SpecialID=0 then
response.write "<p align='center'><br>沒有任何文章！<br></p>"
else
response.write "<p align='center'><br>此專題中沒有任何文章！<br></p>"
end if
else
totalPut=rsArticleList.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"篇文章"
else
if (currentPage-1)*MaxPerPage<totalPut then
rsArticleList.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rsArticleList.bookmark
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"篇文章"
else
currentPage=1
showContent
showpage strFileName,totalput,MaxPerPage,true,true,"篇文章"
end if
end if
end if
rsArticleList.close
set rsArticleList=nothing
sub showContent
dim ArticleNum
ArticleNum=0
%>
<table width='100%' border="0" cellpadding="0" cellspacing="0"><tr>
<form name="myform" method="Post" action="Admin_ArticleDel.asp" onsubmit="return ConfirmDel();">
<td><table class="border" border="0" cellspacing="1" width="100%" cellpadding="0">
<tr class="title" height="22">
<td height="22" width="30" align="center"><strong>選中</strong></td>
<td width="25" align="center" height="22"><strong>ID</strong></td>
<td width="120" align="center" ><strong>所屬專題</strong></td>
<td align="center" ><strong>文章標題</strong></td>
<td width="60" align="center" ><strong>錄入</strong></td>
<td width="40" align="center" ><strong>點擊數</strong></td>
<td width="60" align="center" ><strong>文章屬性</strong></td>
<td width="40" align="center" ><strong>已審核</strong></td>
</tr>
<%do while not rsArticleList.eof%>
<tr class="tdbg" onmouseout="this.style.backgroundColor=''" onmouseover="this.style.backgroundColor='#BFDFFF'">
<td width="30" align="center"><input name='ArticleID' type='checkbox' onclick="unselectall()" id="ArticleID" value='<%=cstr(rsArticleList("articleID"))%>'></td>
<td width="25" align="center"><%=rsArticleList("articleid")%></td>
<td width="120" align="center"><%
if rsArticleList("SpecialID")>0 then
response.write "<a href='" & FileName & "?SpecialID=" & rsArticleList("SpecialID") & "'>" & rsArticleList("SpecialName") & "</a>"
else
response.write " "
end if
%></td>
<td> <%
if rsArticleList("IncludePic")=true then
response.write "<font color=blue>[圖文]</font>"
end if
response.write "<a href='Admin_ArticleShow.asp?ArticleID=" & rsArticleList("articleid") & "'"
response.write " title='標 題：" & rsArticleList("Title") & vbcrlf & "作 者：" & rsArticleList("Author") & vbcrlf & "轉 貼 自：" & rsArticleList("CopyFrom") & vbcrlf & "更新時間：" & rsArticleList("UpdateTime") & vbcrlf
response.write "點 擊 數：" & rsArticleList("Hits") & vbcrlf & "關 鍵 字：" & mid(rsArticleList("Key"),2,len(rsArticleList("Key"))-2) & vbcrlf & "推薦等級："
if rsArticleList("Stars")=0 then
response.write "無"
else
response.write string(rsArticleList("Stars"),"★")
end if
response.write vbcrlf & "分頁方式："
if rsArticleList("PaginationType")=0 then
response.write "不分頁"
elseif rsArticleList("PaginationType")=1 then
response.write "自動分頁"
elseif rsArticleList("PaginationType")=2 then
response.write "手動分頁"
end if
response.write vbcrlf & "閱讀等級："
if rsArticleList("ReadLevel")=9999 then
response.write "游客"
elseif rsArticleList("ReadLevel")=999 then
response.write "注冊用戶"
elseif rsArticleList("ReadLevel")=99 then
response.write "收費用戶"
elseif rsArticleList("ReadLevel")=9 then
response.write "VIP用戶"
elseif rsArticleList("ReadLevel")=5 then
response.write "管理員"
end if
response.write vbcrlf & "閱讀點數：" & rsArticleList("ReadPoint")
response.write "'>" & rsArticleList("title") & "</a>"
%></td>
<td width="60" align="center">
<%
response.write "<a href='" & FileName & "?field=Editor&keyword=" & rsArticleList("Editor") & "' title='點擊將查看此用戶錄入的所有文章'>" & rsArticleList("Editor") & "</a>"
%>
</td>
<td width="40" align="center"><%= rsArticleList("Hits") %></td>
<td width="60" align="center"> <%
if rsArticleList("OnTop")=true then
response.Write "<font color=blue>頂</font> "
else
response.write " "
end if
if rsArticleList("Hits")>=HitsOfHot then
response.write "<font color=red>熱</a> "
else
response.write " "
end if
if rsArticleList("Elite")=true then
response.write "<font color=green>薦</a>"
else
response.write " "
end if
%> </td>
<td width="40" align="center"> <%
if rsArticleList("Passed")=true then
response.write "是"
else
response.write "否"
end if%></td>
</tr>
<%
ArticleNum=ArticleNum+1
if ArticleNum>=MaxPerPage then exit do
rsArticleList.movenext
loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200" height="30"><input name="chkAll" type="checkbox" id="chkAll" onclick=CheckAll(this.form) value="checkbox">
選中本頁顯示的所有文章 </td>
<td nowrap><input name="submit" type='submit' value='將選定的文章從所屬專題中刪除' onClick="document.myform.Action.value='DelFromSpecial'">
<input name="Action" type="hidden" id="Action" value="DelFromSpecial">
<input type="submit" name="Submit" value="將選定的文章移動到" onClick="document.myform.Action.value='MoveToSpecial'">
<select name="SpecialID" id="SpecialID">
<%
if rsSpecial.bof and rsSpecial.eof then
response.write "<option value=''>沒有任何專題</option"
else
rsSpecial.movefirst
do while not rsSpecial.eof
response.write "<option value='" & rsSpecial("SpecialID") & "'>" & rsSpecial("SpecialName") & "</option>"
rsSpecial.movenext
loop
end if
%>
</select> </td>
</tr>
</table>
</td>
</form></tr></table>
<%
end sub
%>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="border">
<tr class="tdbg">
<td width="80" align="right"><strong>文章搜索：</strong></td>
<td>
<%call Admin_ShowSearchForm(FileName,2)%>
</td>
</tr>
</table>
</body>
</html>
<%
rsSpecial.close
set rsSpecial=nothing
call CloseConn()
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -