📄 jz_list.asp

📁 发布整站源码可以再开发~ 本人实用中效果嗷嗷滴~
💻 ASP
字号:
<!--#include file="config.asp"-->
<!--#include file="conn.asp"-->
<!--#include file="code.asp"-->
<%
if not isempty(request("page")) then
	currentPage=cint(request("page"))
else
	currentPage=1
end if
menu=htmlencode(request("menu"))
if menu="" or (not isnumeric(menu)) or isnull(menu) then
	menu="all"
end if
set rs = server.createobject("adodb.recordset")
%>
<HTML>
<HEAD>
<TITLE><%=webname%>|千年私服|天堂2私服|仿盛大私服|魔兽世界私服|RO私服|奇迹私服</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META content=私服发布程序,私服宣传,私服技术,千年私服,仿盛大私服,奇迹私服,天堂2私服,魔兽世界私服,A3私服 name=keywords>
<meta name="description" content="3316私服发布程序(系统)是一个简单、实用的免费私服信息发布程序">
<LINK href="image/css.css" type=text/css rel=stylesheet>
</HEAD>
<BODY leftMargin=0 background="<%=bgimage%>" topMargin=0>
<!--#include file="top.asp"-->
<!--#include file="ad.asp"-->
<table width="990" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#000000">
  <tr>
    <td bgcolor="#FFFFFF"><a href="jz_index.asp">首页</a>&nbsp;<a href="jz_list.asp">所有家族</a>&nbsp;
	<%
Set Rs_type = Server.CreateObject("ADODB.RecordSet")
Sql_Type="select * from GameType order by orderid"
rs_type.open sql_type,conn,1,1
if rs_type.eof and rs_type.bof then
	response.Write "没有分类，请到后台添加！"
else
	do while not rs_type.EOF
		response.Write "<a href=Jz_list.asp?menu="&rs_type("id")&">"&rs_type("game")&"家族</a>&nbsp;"
	rs_type.movenext
	loop
	rs_type.close
end if
%></td>
  </tr>
</table>
<table width="50%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="10"></td>
  </tr>
</table>
<table width="990" border="0" align="center" bgColor=#000000 cellspacing="1" cellpadding="3">
  <tr bgColor=#8DD3F6>
    <td align="center" bgcolor="#8DD3F6"><strong>家族名称</strong></td>
    <td align="center" bgcolor="#8DD3F6"><strong>QQ群</strong></td>
    <td align="center"><b>负责人</b></td>
    <td align="center"><strong>创建时间</strong></td>
    <td align="center"><strong>所在游戏</strong></td>
    <td align="center"><b>规模</b></td>
    <td align="center"><strong>主页</strong></td>
    <td align="center"><b>地区</b></td>
    <td align="center"><b>介绍</b></td>
  </tr>
<%
'固定家族列表
if menu<>"all" then
sql="select Jzdata.id,Jzdata.name,Jzdata.qq,Jzdata.master,Jzdata.bulid,Jzdata.peo,Jzdata.addr,Jzdata.web,Jzdata.gameid,Gametype.game "
sql=sql&" from Jzdata,Gametype where jzdata.gameid=gametype.id and jzdata.top=true and jzdata.gameid="&menu
sql=sql&" and jzdata.ulock=true order by Jzdata.id desc"
else
sql="select Jzdata.id,Jzdata.name,Jzdata.qq,Jzdata.master,Jzdata.bulid,Jzdata.peo,Jzdata.addr,Jzdata.web,Jzdata.gameid,Gametype.game "
sql=sql&" from Jzdata,Gametype where jzdata.gameid=gametype.id and jzdata.top=true "
sql=sql&" and jzdata.ulock=true order by Jzdata.id desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
	rs.close
else
%>
  <%do while not rs.eof%>
  <tr bgColor=#EFEFEF>
    <td><a href=Jz_display.asp?id=<%=rs("id")%> target=_blank><%=rs("name")%></a></td>
    <td><%=rs("QQ")%></td>
    <td><%=rs("master")%></td>
    <td><%=formatdatetime(rs("Bulid"),1)%></td>
    <td><%=rs("game")%></td>
    <td><%=rs("peo")%>+</td>
    <td align="center"><%if rs("web")="" or rs("web")="无" or rs("web")="http://" then response.write "--" else response.write "<a href=go.htm?u="&rs("web")&" target=_blank>访问</a>" end if%></td>
    <td align="center"><%=rs("addr")%></td>
    <td align="center"><a href=Jz_display.asp?id=<%=rs("id")%> target=_blank>查看</a></td>
  </tr>
  <% 
rs.movenext
loop
rs.close
end if
%>
<%
'非固定家族列表
if menu<>"all" then
sql="select Jzdata.id,Jzdata.name,Jzdata.qq,Jzdata.master,Jzdata.bulid,Jzdata.peo,Jzdata.addr,Jzdata.web,Jzdata.gameid,Gametype.game "
sql=sql&" from Jzdata,Gametype where jzdata.gameid=gametype.id and jzdata.top=false and jzdata.gameid="&menu
sql=sql&" and jzdata.ulock=true order by Jzdata.id desc"
else
sql="select Jzdata.id,Jzdata.name,Jzdata.qq,Jzdata.master,Jzdata.bulid,Jzdata.peo,Jzdata.addr,Jzdata.web,Jzdata.gameid,Gametype.game "
sql=sql&" from Jzdata,Gametype where jzdata.gameid=gametype.id and jzdata.top=false "
sql=sql&" and jzdata.ulock=true order by Jzdata.id desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
	response.write "<tr bgColor=#FFFFFF><td colspan=9 align=center>当前没有家族信息！请到“<a href=jz_add.asp><font color=red>家族发布中心</font></a>”发布您的私服。</td></tr>"
	rs.close
else
	totalPut=rs.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 totalput,MaxPerPage,"Jz_list.asp" 
 	else 
 		if (currentPage-1)*MaxPerPage<totalPut then 
			rs.move  (currentPage-1)*MaxPerPage 
			showContent 
 			showpage totalput,MaxPerPage,"Jz_list.asp" 
  		else 
	  		currentPage=1 
  			showContent 
  			showpage totalput,MaxPerPage,"Jz_list.asp" 
			end if 
		end if 
		rs.close 
	end if
	sub showContent 
 	dim i 
	i=0 
%>
  <%do while not rs.eof%>
  <tr bgColor=#88E3F6 onmouseover=javascript:this.bgColor='#8DD3F6' onmouseout=javascript:this.bgColor='#88E3F6'>
    <td><a href=Jz_display.asp?id=<%=rs("id")%> target=_blank><%=rs("name")%></a></td>
    <td><%=rs("QQ")%></td>
    <td><%=rs("master")%></td>
    <td><%=formatdatetime(rs("Bulid"),1)%></td>
    <td><%=rs("game")%></td>
    <td><%=rs("peo")%>+</td>
    <td align="center"><%if rs("web")="" or rs("web")="无" or rs("web")="http://" then response.write "--" else response.write "<a href=go.htm?u="&rs("web")&" target=_blank>访问</a>" end if%></td>
    <td align="center"><%=rs("addr")%></td>
    <td align="center"><a href=Jz_display.asp?id=<%=rs("id")%> target=_blank>查看</a></td>
  </tr>
  <%
i=i+1
if i>=MaxPerPage then exit do
	rs.movenext 
loop
rs.close
end sub
%>
</table>
<table width="50%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="10"></td>
  </tr>
</table>
<%
function showpage(totalnumber,maxperpage,filename)
  	dim n
  	if totalnumber mod maxperpage=0 then
  		n= totalnumber \ maxperpage
  	else
  		n= totalnumber \ maxperpage+1
  	end if
  	response.write "<table align=center width=770><tr><form method=Post action="&filename&"?menu="&menu&"><td align=right>"

  	if CurrentPage<2 then
 		response.write "共"&totalnumber&"条记录&nbsp;首页 上页&nbsp;"
  	else
 		response.write "共"&totalnumber&"条记录&nbsp;<a href="&filename&"?page=1&menu="&menu&">首页</a>&nbsp;"
 		response.write "<a href="&filename&"?page="&CurrentPage-1&"&menu="&menu&">上页</a>&nbsp;"
  	end if

  	if n-currentpage<1 then
 		response.write "下页 尾页"
  	else
 		response.write "<a href="&filename&"?page="&(CurrentPage+1)&"&menu="&menu&">"
 		response.write "下页</a> <a href="&filename&"?page="&n&"&menu="&menu&">尾页</a>"
  	end if
	response.write "&nbsp;页次：<strong><font color=red>"&CurrentPage&"</font>/"&n&"</strong>页 "
 	response.write "&nbsp;<b>"&maxperpage&"</b>条记录/页 "
	response.write "转：<select name='page' size=1 onchange=javascript:submit()>"
	for i = 1 to n
		response.write "<option value="&i&" "
			if cint(Page)=cint(i) then
				response.wirte "selected "
			end if
		response.write ">第"&i&"页</option>"
	next
	response.write "</select></td></form></tr></table>"
end function
set rs=nothing
%>
<!--#include file="foot.asp"-->
</body>
</html>
<%
conn.close
set conn=nothing
%>
💿 文件大小 3464 K
👤 上传用户 Rebecca_SYF
📂 所属分类其他
🏷️ 相关标签

#发布 #源码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -