Hi everyone,

I'm trying to create a public-facing referral leaderboard that displays the top referrers on my community in a simple table.

What I want to achieve:

- A public leaderboard showing members ranked by total referrals

- Display member name, avatar, and referral count

My questions:

1. Is there a built-in widget or plugin to display a referral leaderboard on the front-end that I'm missing?

2. If not, what's the recommended approach to create a custom template that can:

- Query the core_members table directly (or whatever I need to query)

- Group by referrer_id and count referrals

3. Can database templates access core_members data, or are they limited to their own database records?

4. Is there a way to create a custom widget/block that has full PHP execution capabilities?

Thanks in advance!

No one? nothing?