Show how much space each user is taking up in attachments

[BamaStangGuy]

It would be cool if someone could make a small hack that would show the users total attachment totals, sortable by total amount and username

[Beermonster]

If you go to your AdminCP/Attachment/Attachment Statistics you can get the top 5

[Andreas]

[sql]SELECT SUM( filesize ) AS total, user.username
FROM attachment
LEFT JOIN user ON ( user.userid = attachment.userid )
GROUP BY attachment.userid
ORDER BY total DESC
[/sql]

or ORDER BY total ASC, ORDER BY username DESC, ORDER BY username ASC

[BamaStangGuy]

Originally Posted by KirbyDE

[sql]SELECT SUM( filesize ) AS total, user.username
FROM attachment
LEFT JOIN user ON ( user.userid = attachment.userid )
GROUP BY attachment.userid
ORDER BY total DESC
[/sql]

or ORDER BY total ASC, ORDER BY username DESC, ORDER BY username ASC

Thanks that worked