[New] Admin plane: Community leaderboards are all-time cumulative only — no weekly/monthly reset like Skool's signature engagement loop

Area: Admin plane (audit p12) · Surface: Community / Stats leaderboards (/stats#leaderboards, LeaderboardController redirects here) · Dimension: competitor-gap · Severity: major

Skool's entire retention model is the weekly leaderboard that resets every Monday, plus monthly and all-time tabs. The reset is the point: it gives new members a winnable game each week and prevents the earliest/highest-volume members from permanently owning the top spots, which is exactly what an all-time-only board does. Circle and Mighty Networks have also added periodic leaderboards. mobieus has rich raw signals (posts, threads, karma, achievements, credits) but exposes them only as a static lifetime ranking, leaving the highest-leverage daily-return mechanic on the table.

Evidence

LeaderboardController.php:9 redirects to /stats#leaderboards. Every leaderboard query in StatsController.php:138-205 (topPosters, topThreaders, topKarma, topAchievers, etc.) is `... GROUP BY u.id ORDER BY <count> DESC LIMIT 10` with NO time-window predicate — they sum lifetime activity. There is no `WHERE created_at >= NOW() - INTERVAL N DAY` and no period selector anywhere in the controller.

Suggested fix. Add a period tab (This Week / This Month / All Time) to the leaderboard, driving the existing queries off activity-table timestamps (forum_posts.created_at, file_uploads.created_at, etc.) with a date predicate. Week boundary should be tenant-timezone aware. Surface the member's own current weekly rank to create the 'I can still climb' pull.

Filed by the automated tenant-app audit and adversarially evidence-verified. Status: verified. Open — not yet actioned.