::NoName Magazine 无名杂志 » Project Parasy » sai请进~请教PP首页的最新讨论和NOWHERE的显示条数怎么控制
本主题共有 2 条回复 | 回到顶部
#1 - 2008-11-25 23:34
Sai
桂林
include/cache.func.php
CODE:
case 'nowhere':
$table = 'plugin_now n';
$cols = 'n.*,mf.avatar';
$conditions = "LEFT JOIN {$tablepre}memberfields mf ON mf.uid=n.authorid ORDER BY dateline DESC LIMIT 30";
break;
$table = 'plugin_now n';
$cols = 'n.*,mf.avatar';
$conditions = "LEFT JOIN {$tablepre}memberfields mf ON mf.uid=n.authorid ORDER BY dateline DESC LIMIT 30";
break;
CODE:
case 'newthread':
$table = 'threads t';
$cols = 't.tid, t.fid, t.author,t.subject, t.dateline, t.lastpost, t.lastposter, t.views, t.replies,f.name,f.board_name, mf.avatar,mf.uid';
$conditions = "LEFT JOIN {$tablepre}forums f ON f.fid=t.fid LEFT JOIN {$tablepre}memberfields mf ON mf.uid=t.authorid WHERE t.displayorder!='-1' ORDER BY t.lastpost DESC LIMIT 0, 20";
break;
$table = 'threads t';
$cols = 't.tid, t.fid, t.author,t.subject, t.dateline, t.lastpost, t.lastposter, t.views, t.replies,f.name,f.board_name, mf.avatar,mf.uid';
$conditions = "LEFT JOIN {$tablepre}forums f ON f.fid=t.fid LEFT JOIN {$tablepre}memberfields mf ON mf.uid=t.authorid WHERE t.displayorder!='-1' ORDER BY t.lastpost DESC LIMIT 0, 20";
break;