showHot.php
资源名称:BBWPS.rar [点击查看]
上传用户:yttaitong
上传日期:2009-05-10
资源大小:128k
文件大小:1k
源码类别:
WEB源码(ASP,PHP,...)
开发平台:
PHP
- <?
- /*
- [BBWPS!] (C)2006-2010 小蜜蜂版权所有.
- This is NOT a freeware, use is subject to license terms
- 时间:2007年12月
- 描述:
- */
- global $cid,$prefix,$h_pagesize,$sid;
- $sql ="select ".$prefix."message.mid,".$prefix."message.title,".$prefix."message.sid from ".$prefix."message
- left join ".$prefix."city on ".$prefix."message.cid=".$prefix."city.cid left join ".$prefix."sort on
- ".$prefix."message.sid=".$prefix."sort.sid where hits>'0' and ( ".$prefix."city.cid='".$cid."' or ".$prefix."city.cparent='".$cid."')
- and ".$prefix."message.etime > '".time()."' and ( ".$prefix."sort.sparent='".$sid."' or ".$prefix."message.sid='".$sid."' )
- order by ".$prefix."message.hits desc limit 0,$h_pagesize";
- ?>