<!--#include file="conn.asp"-->
<!--#include file="const.asp"-->
<%
  if session("admin")="" then
  response.redirect "admin_login.asp"
  else
	if session("flag")>2 then
		response.write "<br><p align=center>您没有操作的权限</p>"
		response.end
	end if
  end if
  %>
<%
set rs=server.createobject("adodb.recordset") 
sql="select * from data  where audit=0 order by id desc" 
rs.open sql,conn,1,3
rs.pagesize=pagesize_1
page=request("page")
if not rs.eof then
if page="" or page<1 then page=1
rs.absolutepage=page
end if
%>


<html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title></title>
<link rel="stylesheet" type="text/css" href="css.css">
<link href="css/css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" bgcolor="#FFFFFF">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="600">
  <tr>
    <td height="24" bgcolor="#CCCCCC">
    <p align="center"><b><font color="#FF0000">未验证通过站点列表</font></b></td>
  </tr>
</table>
</center>
<% 
if not rs.eof then
for i=1 to rs.pagesize
 if rs.eof then exit for %>
<table width="600" border="1" cellpadding="2" cellspacing="0" bordercolor="#999999" style="border-collapse: collapse">
  <tr> 
    <td width="90" align="center" bgcolor="#EFEFEF">网站LOGO</td>
    <td width="110" align="center" bgcolor="#EFEFEF">网站名称</td>
    <td width="80" align="center" bgcolor="#EFEFEF"> <p align="center">站 长</td>
    <td width="92" align="center" bgcolor="#EFEFEF">网站类型</td>
    <td width="92" align="center" bgcolor="#EFEFEF">所属地区</td>
    <td align="center" bgcolor="#EFEFEF"> <p align="center">验 证</td>
    <td align="center" bgcolor="#EFEFEF">修 改</td>
    <td align="center" bgcolor="#EFEFEF">删 除</td>
  </tr>
  <tr> 
    <td align="center"><a href="open.asp?id=<%=rs("id")%>&url=<%=rs("url")%>" target="_blank">      <%if rs("logo")="" then%>
      <%=rs("webname")%> 
      <%else%>
      <img src=<%=rs("logo")%> border=0 width=88 height=31 alt="<%=rs("webname")%>"> 
      <%end if%></a></td>
    <td width="110" align="center"><a href="open.asp?id=<%=rs("id")%>&url=<%=rs("url")%>" target="_blank"><%=rs("webname")%></a>　</td>
    <td width="73" align="center">　<%=rs("name")%></td>
    <td width="92" align="center"> 
      <%
sql = "select * from type where t_id="& rs("t_id")
set Rs1 = Server.CreateObject("ADODB.Recordset")
Rs1.open sql,conn,1,1
do while not Rs1.eof
%>
      <%=Rs1("type")%> 
      <%
Rs1.movenext
loop
Rs1.close
set Rs1 = nothing
%>
      　</td>
    <td width="92" align="center"> 
      <%
sql = "select * from area where a_id="& rs("a_id")
set Rs2 = Server.CreateObject("ADODB.Recordset")
Rs2.open sql,conn,1,1
do while not Rs2.eof
%>
      <%=Rs2("area")%>· 
      <%
Rs2.movenext
loop
Rs2.close
set Rs2 = nothing

sql = "select * from city where c_id="& rs("c_id")
set Rs3 = Server.CreateObject("ADODB.Recordset")
Rs3.open sql,conn,1,1
do while not Rs3.eof
%>
      <%=Rs3("city")%> 
      <%
Rs3.movenext
loop
Rs3.close
set Rs3 = nothing
%>
    </td>
    <td width="25" align="center"><a href="audit.asp?id=<%=rs("id")%>"><img border="0" src="images/button_yz.gif"></a></td>
    <td width="24" align="center"><a href="modify.asp?id=<%=rs("id")%>"><img border="0" src="images/button_edit.gif"></a></td>
    <td width="31" align="center"><a href="deldata.asp?id=<%=rs("id")%>"><img border="0" src="images/button_del.gif"></a></td>
  </tr>
  <tr> 
    <td colspan="8" width="594"><font color="#FF6600">网站介绍:</font><%=rs("intro")%></td>
  </tr>
</table>
<br>
<% rs.movenext
next
if rs.pagecount>0 then rs.moveprevious
end if
%>
<table width="600" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center"><%=rs.pagesize%>条/页　第<%=page%>页 
        <% if rs.absolutepage>1 then response.write("<a href='?"&page=1&"'>")%>
        首页</a> 
        <% if rs.absolutepage>1 then response.write("<a href='?page="&rs.absolutepage-1&"'>")%>
        上一页</a> 
        <% if rs.absolutepage<rs.pagecount then response.write("<a href='?page="&rs.absolutepage+1&"'>")%>
        下一页</a> 
        <% if rs.absolutepage<rs.pagecount then response.write("<a href='?page="&rs.pagecount&"'>")%>
        尾页</a> </div></td>
  </tr>
</table></body></html>