[代码修改] Discuz X DIY记录调用只调用每个用户的最新一条记录

dly 发表于 2013-8-13 13:38:20 | 显示全部楼层 |阅读模式

source\class\block\space\block_doing.php

把

$query = C::t('home_doing')->fetch_all_by_uid_doid($uids, $bannedids, $parameter['orderby'], $startrow, $items, true, true);

复制代码

注释掉，

下面添加

$datas = DB::fetch_all('select uid,max(dateline) as maxdateline from pre_home_doing group by uid order by maxdateline desc limit 10');
$query = array();
foreach($datas as $data){
$uid = $data['uid'];
$maxdateline = $data['maxdateline'];
$sql = "select * from pre_home_doing where uid='{$uid}' and dateline='{$maxdateline}' limit 1";
$record = mysql_fetch_array(mysql_query($sql),MYSQL_ASSOC);
$query[] = $record;
}

复制代码