We want backend views for the scoreboard.
For quests:
aggregates
Status (not started etc.) x (playing or not) => # Quests
For guilds:
aggregate guilds
Status (closed/recruiting/member) => # Guilds
Eventually:
N top guilds by # quests played, scoring...
N top players by # of quests played, scoring, guild scoring (Sum if many guilds?)
We want backend views for the scoreboard.
For quests:
aggregates
Status (not started etc.) x (playing or not) => # Quests
For guilds:
aggregate guilds
Status (closed/recruiting/member) => # Guilds
Eventually:
N top guilds by # quests played, scoring...
N top players by # of quests played, scoring, guild scoring (Sum if many guilds?)