I’d like to see a list or thumbnail gallery of all my uploads.
Actually I’d like to see someone else’s uploads.
Actually, as admin I’d like to see everyone’s uploads.
I attached an image a few weeks ago and it’s relevant to this new discussion. It was a direct cut-n-paste job so I don’t have the original. I can’t remember where I posted it, and I can’t search for an image.
Ditto, but it was user x who posted it in… which thread? when? It was a great image and I want to share it again.
I want to see what sort of files our users are uploading and also make sure that no single user is abusing the upload facility.
I can make mockups if you like, but I think this feature describes itself.
This would be a great feature! If the size of the file could be its own column, then one could (especially admins and mods) could sort by size when a cleanup is needed. Additionally, having an option (MediaWiki comes to mind) to see where the image is used would be great, so one does not affect a current thread by deleting an image.
Also, @Tom_Newsom, how would this work for private/restricted categories? If I posted in the Lounge (for example), would a new user see that image on my user profile?
Now we’re getting stuck into the ugly details, which I suspect will make this hard to implement It’s also the point at which my knowledge of Discourse internals dries up so I have no idea how hard/easy that would be.
If all else fails, it would still be very useful to see your own uploads (and for admins to track down the gigantic ones that are taking up all that space on the server etc.)
Just thought of a further complication - if an admin adds an upload to someone else’s post, or in the case of a wiki post with many uploads, who do those uploads “belong” to? Unless the information is captured at the time of uploading, it would be impossible to know…
To avoid filling the screen up with the full-res images
WHERE DATE(current_date) - DATE(created_at) < 7
to restrict the search to the last week.
so, full query:
CONCAT('<img src="https://discourse.southlondonmakerspace.org', url, E'" style = "max-width: 100%\x3B">')
WHERE DATE(current_date) - DATE(created_at) < 5
ORDER BY created_at DESC
Ideally, I’d like to restrict the list to uploads that are found in posts with the “regular” archetype (ie. not PMs) but that’s a nested SQL query way out of my depth.