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]

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


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

[BamaStangGuy]

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


or ORDER BY total ASC, ORDER BY username DESC, ORDER BY username ASC
Thanks that worked