最热日志
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/apache/htdocs/pc/pcstat.php on line 338
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/apache/htdocs/pc/pcstat.php on line 340
pcstat.php:
310 function getHotNodesByPeriod($link,$period,$num=10)
311 {
312 $num = intval( $num );
313 if($period=="day")
314 $queryTime = time () - 24*3600;
315 elseif($period=="month")
316 $queryTime = time () - 30*24*3600;
317 else
318 $queryTime = 0;
319
320 // kxn: 这里需要判断一下，如果是没有时间限制的，那么应该强制 nodes 使用 visitcount 做索引，
321 // 如果有时间限制的话，就不要去动他，用时间限制做主 key , 效果会好
322 $nodesindex = $queryTime == 0 ? " use index(visitcount) " : "";
323
324 $query = "SELECT nodes.uid , nid , subject ".
325 "FROM nodes ".$nodesindex.",users ".
326 "WHERE access = 0 ".
327 " AND nodes.uid = users.uid ".
328 " AND nodetype = 0 ".
329 " AND pctype < 4 ";
330
331 if($queryTime)
332 $query.= " AND created > FROM_UNIXTIME(".$queryTime . ")";
333 //$query.= "GROUP BY uid ";
334 $query.= "ORDER BY nodes.visitcount DESC ".
335 "LIMIT 0 , ".$num." ;";
336 $result = mysql_query($query,$link);
337 $nodes = array();
338 while($rows = mysql_fetch_array($result))
339 $nodes[] = $rows;
340 mysql_free_result($result);
341 return $nodes;
342 }
--
FROM 202.193.5.*