Submitty
Forum Stat Page Upduck Count
What problem are you trying to solve with Submitty The forum stat page currently only includes total posts, total threads, and deleted threads, and does not reference upducks at all.
Describe the way you'd like to solve this problem A fourth stat column, listing total upducks of each user, should be added to the stat page.
Describe any potential alternatives you'd tried to solve the problem
I wrote an SQL command for SQL Toolbox to achieve the same thing, but it's less convenient:
select p.author_user_id, count(f.*) as upducks from posts p join forum_upducks f on p.id = f.post_id group by p.author_user_id order by upducks desc;
Additional context This column could be helpful for instructors attempting to give extra credit for frequent forum users.
Stat page header image - there's empty space between the 'Total Deleted Posts' and 'Show Posts' which could be used for this column.