本帖最后由 voone 于 2010-4-5 04:12 编辑
source/network.php
找到- $piclist = array();
- $query = $_SGLOBAL['db']->query("SELECT album.albumname, album.friend, space.username, space.name, space.namestatus, main.*
- FROM ".tname('pic')." main
- LEFT JOIN ".tname('album')." album ON album.albumid=main.albumid
- LEFT JOIN ".tname('space')." space ON space.uid=main.uid
- WHERE ".implode(' AND ', $wherearr)."
- ORDER BY main.{$order} $sc LIMIT 0,$shownum");
复制代码 修改为- $piclist = array();
- $query = $_SGLOBAL['db']->query("SELECT album.albumname, album.friend, space.username, space.name, space.namestatus, main.*
- FROM ".tname('pic')." main
- LEFT JOIN ".tname('album')." album ON album.albumid=main.albumid
- LEFT JOIN ".tname('space')." space ON space.uid=main.uid
- WHERE ".implode(' AND ', $wherearr)."
- GROUP BY main.uid
- ORDER BY main.{$order} $sc
- LIMIT 0,$shownum");
复制代码 后台更新缓存 |