php - 如何编辑此插件以显示今天在线和现在在线的帖子数大1 - MYBB onlinetoday

Question

我正在使用这个插件

http://mods.mybb.com/download/online-today-1.2.2

以下部分是查询

        $queries[] = $db->simple_select(
        "users u LEFT JOIN ".TABLE_PREFIX."sessions s ON (u.uid=s.uid)", 
        "s.sid, s.ip, s.time, s.location, u.uid, u.username, u.invisible, u.usergroup, u.displaygroup",
        "u.lastactive > $timesearch ORDER BY u.username ASC, s.time DESC"
    );
    $queries[] = $db->simple_select(
        "sessions s LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)",
        "s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup",
        "s.time>'$timesearch' ORDER BY u.username ASC, s.time DESC"
    );

现在我想修改此查询，以便仅获取帖子计数大于 0 的用户。所以至少 1 篇及以上帖子

谢谢

php、mybb

Answer 1

试试这个代码:

    $queries[] = $db->simple_select(
    "users u LEFT JOIN ".TABLE_PREFIX."sessions s ON (u.uid=s.uid)", 
    "s.sid, s.ip, s.time, s.location, u.uid, u.username, u.invisible, u.usergroup, u.displaygroup",
    "u.lastactive > $timesearch AND u.postnum > 0 ORDER BY u.username ASC, s.time DESC"
    );
    $queries[] = $db->simple_select(
    "sessions s LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid)",
    "s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup",
    "s.time>'$timesearch' AND u.postnum > 0 ORDER BY u.username ASC, s.time DESC"
    );

我刚刚添加了一个额外的 WHERE 子句，用于检查 postnum 字段以确保它大于 0。