admin_web.asp

安全性好,适用于制作论坛和进行资源下载的个人和大型网站使用!

elseif request("keyword")<>""  then
   keyword=trim(replace(request("keyword"),"'",""))
   sea_type=trim(replace(request("sea_type"),"'",""))
   sql_tmp=1
   sql="select * from coolsites where "&sea_type&" like '%"&keyword&"%' order by cs_id DESC"
   Url_Add=Url_Add&"sea_type="&sea_type&"&keyword="&keyword&"&"
elseif request.querystring("t")="pass" then
  sql="select * from coolsites where passed=1 order by cs_id desc"
  Url_Add=Url_Add&"t=pass&"
else
  sql="select * from coolsites where passed=0 order by cs_id desc"
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
  Response.Write("<tr align=""center""><td class=Hxcmsds colspan=4>当前没有酷站！</td></tr>")
Else
   Dim web_Nums,MultiPages,j
   rs.PageSize=adflperpage
   rs.AbsolutePage=CurPage
   web_Nums=rs.RecordCount
   MultiPages="<tr><td class=Hxcmsqs colspan=""4"" align=""center"">共有酷站："&web_Nums&"个。&nbsp;&nbsp;"&MultiPage(web_Nums,adflperpage,CurPage,Url_Add)&"</td></tr>"
%>
<form name="form3" method="post" action="">
<tr class=Hxcmsss>
<td colspan="3" align="right" style="padding-top:2px;">
<select style="margin:-3px" name="go" onChange='window.location=form.go.options[form.go.selectedIndex].value'>
<option value="">选择显示方式</option>
<option value="admin_web.asp?action=sites">显示所有酷站</option>
<%sql="select * from cscat"
set rs2=server.createobject("adodb.recordset")
rs2.open sql,conn,1,1
do while not rs2.eof%>
<option value="admin_web.asp?action=sites&cscat_id=<%=rs2("cscat_id")%>"><%=rs2("cscat_name")%></option>
<%rs2.movenext
loop
if rs2.bof and rs2.eof then%><option value="">当前没有分类</option>
<%end if
rs2.close
set rs2=nothing%>
              </select>
            </td>
        </tr>
   </form>
<form name="form4" method="post" action="admin_web.asp?action=sites">
<tr align="center" class=Hxcmsqs>
<td colspan="3">搜索（酷站列表）关键字：
<input type=text name=keyword size=15 maxlength=20>
<select name=sea_type size=1>
<option value='cs_name'>按标题</option>
<option value='tjuser'>按发布人</option>
</select>
<input type=submit value='搜 索'></td>          
</tr></form>
<form name=form method=post action="admin_web.asp?action=sites">
<script language="javascript">
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
</script>
<%
Do Until Rs.EOF OR j=adflperpage
sql="select cscat_id,cscat_name from cscat where cscat_id="&rs("cscat_id")
set rscat=server.createobject("adodb.recordset")
rscat.open sql,conn,1,1
%>
        <tr class=Hxcmsds>
          <td width="5%" align="center"><input type=checkbox Name=cs_id Value=<%=rs("cs_id")%>></td> 
          <td width="20%" align="center"><img src="<%=rs("cs_pic")%>" width='100' height="73" border='0'></td>
          <td width="75%">网站名称：<font color=red><%=rs("cs_name")%></font>&nbsp;&nbsp;&nbsp;&nbsp;→所属分类：<%=rscat("cscat_name")%><br>
            网站地址：<a href="<%=rs("cs_url")%>" target="_blank"><%=rs("cs_url")%></a><br>
            加入时间：<%=rs("cs_date")%>&nbsp;&nbsp;&nbsp;&nbsp;→点击次数：<%=rs("cs_count")%><br>
            审核状况：<%If Rs("passed")=1 Then%><a href="?id=<%=rs("cs_id")%>&action=checkpass"><font color=red>pass</font></a><%else%>√<%End If%>   提交会员：<%=rs("tjuser")%><br>
            <a href="admin_web.asp?id=<%=rs("cs_id")%>&action=editcs">编辑</a> 
            <a href="admin_web.asp?id=<%=rs("cs_id")%>&action=delcs">删除</a></td>
        </tr>
<%
rscat.close
set rscat=nothing
j=j+1
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
<tr class=Hxcmsqs><td class=Hxcmsds colspan="3">
            <input type=hidden value=DEL name=operation>
	 <input type="checkbox" name="chkall" onclick="CheckAll(this.form)" value="ON">选中本页所有 <input type=submit value=批量删除 onClick="return confirm('确定删除选中的网站吗?');" class="button">&nbsp;&nbsp;&nbsp;&nbsp;<%if sql_tmp="1" then response.write "（搜索结果："&keyword&"）"%></td>
                 </tr></form>
<%
Response.Write(MultiPages)
Response.Write("</table>")
end if
'================hx66.com.cn===============
if request.querystring("action")="newcs" then%>
<table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=Hxcmsss> 
            <td colspan="2">新增酷站</font></td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%" align="right">站点名称：</td>
            <td width="83%"> 
              <input type="text" name="name" class="textarea" size="40">
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">所属分类：</td>
            <td> 
              <select name="cscatid" class="textarea">
<%
sql="select * from cscat"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
do while not rs.eof%><option value="<%=rs("cscat_id")%>"><%=rs("cscat_name")%></option>
<%rs.movenext
loop
if rs.eof and rs.bof then%><option value="0">当前没有酷站分类</option>
<%end if
rs.close
set rs=nothing
%>
              </select>
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">站点地址：</td>
            <td> 
              <input type="text" name="url" class="textarea" size="60">
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">图片地址：</td>
            <td> 
              <input type="text" name="pic" class="textarea" size="60">
            </td>
          </tr>
             <tr class=Hxcmsds> 
              <td align="right">上传图片： </td>
              <td align="left" height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=web"></iframe></td>
            </tr>
          <tr class=Hxcmsds> 
            <td align="right">站点介绍：</td>
            <td> 
              <textarea name="desc" class="textarea" cols="65" rows="6"></textarea>
            </td>
          </tr>
          <tr class=Hxcmsds> 
          <td align="right">站点添加：</td> 
          <td><input type="text" name="tjuser" size="10" value="<%=Session("hxStudioAdminName")%>"></td>
          </tr>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2"> 
              <input type="checkbox" name="isbest" value="1" class="textarea">
              推荐&nbsp;&nbsp;&nbsp; 
              <input type="submit" name="Submit" value="确定新增" class="button">
              <input type="reset" name="Reset" value="清空重填" class="button">
              [<a href="admin_web.asp?action=sites">返回</a>] </td>
          </tr>
		  <input type="hidden" name="action" value="newcs">
		<input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%end if
'================hx66.com.cn===============
if request.QueryString("action")="editcs" then
if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的新闻ID参数！');history.back(1);</script>")
	response.end
  end if
end if
sql="select * from coolsites where cs_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
 <table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=Hxcmsss> 
            <td colspan="2">修改酷站</font></td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%" align="right">站点名称：</td>
            <td width="83%"> 
              <input name="name" type="text" class="textarea" id="name" size="40" value="<%=rs("cs_name")%>">
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">所属分类：</td>
            <td> 
              <select name="cscatid" class="textarea" id="cscatid">
                <%sql="select * from cscat"
                  set rs2=server.createobject("adodb.recordset")
                  rs2.open sql,conn,1,1
                  do while not rs2.eof%>
                <option value="<%=rs2("cscat_id")%>" <%if rs2("cscat_id")=rs("cscat_id") then response.write "selected" end if%>><%=rs2("cscat_name")%></option>
                <%rs2.movenext
                  loop
                  if rs2.eof and rs2.bof then%>
                <option value="0">当前没有酷站分类</option>
                <%end if%>
              </select>
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">站点地址：</td>
            <td> 
              <input name="url" type="text" class="textarea" id="url" size="60" value="<%=rs("cs_url")%>">
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">图片地址：</td>
            <td> 
              <input type="text" name="pic" class="textarea" size="60" value="<%=rs("cs_pic")%>">
            </td>
          </tr>
             <tr class=Hxcmsds> 
              <td align="right">上传图片： </td>
              <td height="25"><iframe frameborder=0 width=290 height=25 scrolling=no src="upload.asp?action=web"></iframe></td>
            </tr>
          <tr class=Hxcmsds> 
            <td align="right">站点介绍：</td>
            <td> 
              <textarea name="desc" cols="65" rows="6" class="textarea" id="desc"><%=rs("cs_desc")%></textarea>
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td align="right">站点添加：</td>
            <td><input type="text" name="tjuser" size="10" value="<%=rs("tjuser")%>">
            </td>
          </tr>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2" height="30" bgcolor="#F5F5F5"> <input name="isbest" type="checkbox" class="textarea" id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐
              <input name="Submit" type="submit" class="button" id="Submit" value="确定修改"> 
              <input type="reset" name="Reset" value="清空重填" class="button">
              [<a href="admin_web.asp?action=sites">返回</a>] </td>
          </tr>
		  <input type="hidden" name="id" value="<%=rs("cs_id")%>">
          <input type="hidden" name="action" value="editcs">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%
rs2.close
set rs2=nothing
rs.close
set rs=nothing
end if
'================hx66.com.cn===============
if request.QueryString("action")="delcs" then
if request.querystring("id")="" then
  Response.Write("<script language=javascript>alert('请指定操作的对象！');history.back(1);</script>")
  response.end
else
  if not isinteger(request.querystring("id")) then
    Response.Write("<script language=javascript>alert('非法的新闻ID参数！');history.back(1);</script>")
	response.end
  end if
end if
sql="select * from coolsites where cs_id="&cint(request.querystring("id"))
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1%>
 <table align="center" width="98%" align="center" border="1" cellspacing="0" cellpadding="4" class=Hxcmsbk style="border-collapse: collapse">
        <form name="form2" method="post" action="">
          <tr class=Hxcmsss> 
            <td colspan="2">删除酷站</font></td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%">站点名称</td>
            <td width="83%"><%=rs("cs_name")%></td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%">所属分类</td>
            <td width="83%"> 
                <%
                 sql="select * from cscat where cscat_id="&rs("cscat_id")
                 set rs2=server.createobject("adodb.recordset")
                 rs2.open sql,conn,1,1%><%=rs2("cscat_name")%></td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%">站点地址</td>
            <td width="83%"><%=rs("cs_url")%></td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%">图片地址</td>
            <td width="83%"><img src="<%=rs("cs_pic")%>" width='100' height="73" border='0'>
            </td>
          </tr>
          <tr class=Hxcmsds> 
            <td width="17%">站点介绍</td>
            <td width="83%"><%=rs("cs_desc")%></td>
          </tr>
          <tr class=Hxcmsqs align="center"> 
            <td colspan="2"> 
              <input name="isbest" type="checkbox" class="textarea" id="isbest" value="1" <%if rs("isbest")=1 then response.write "checked" end if%>>
              推荐 
              <input name="Submit" type="submit" class="button" id="Submit" value="确定删除">
              [<a href="admin_web.asp?action=sites">返回</a>] </td>
          </tr>
          <input type="hidden" name="id" value="<%=rs("cs_id")%>">
          <input type="hidden" name="action" value="delcs">
          <input type="hidden" name="MM_insert" value="true">
        </form>
      </table>
<%
rs2.close
set rs2=nothing
rs.close
set rs=nothing
end if
end if
'****************************************************
' Hxcms 7.6      Power by Hx66.net
' Web: http://www.Hx66.net,http://www.Hx66.com.cn
' Copyright (C) 2006 Hx66.net All Rights Reserved.
'****************************************************
%>