Avatar Repository

[chi00]

This new feature aims to enable moderators to view approved avatars:

1. to ensure that all avatars are unique
2. to check whether the user who recently submitted an avatar doesn't have a previously approved avatar

Describe the solution you'd like I'd like to request for a repository (or an equivalent) of avatars that shall display the following information:

1. Username
2. Res img (this would show a preview of the res avatar)
3. Res link (this would show the URL of the res avatar
4. Spy img (this wold show a preview of the spy avatar)
5. Spy link ( this would show the URL of the spy avatar
6. Approved by (moderator who approved the avatar)
7. Approved on (this shall be the date when the avatar was approved in YYYY/MM/DD HH:MM:SS AM/PM format as this would allow for sorting based on the timestamp)

The repository shall be accessible through a hyperlink in the Custom Avatar Requests page. Upon clicking the hyperlink, the user shall be directed to a page where the user would be able to see the details specified above.

By default, entries shall be sorted based on the username in ascending order but the sorting can be changed to the following:

1. Sorting in descending order based on the username
2. Sorting in ascending/descending order based on the moderator
3. Sorting in ascending/descending order based on the date approved

All entries shall be grouped by 20's and shall be displayed by pages. By default, only the first 20 entries shall be displayed and succeeding entries shall be displayed by clicking on the page number or Next/Previous Page..

There shall be a function to enable filtering by::

1. username
2. approved by
3. date approved For the UI, a dropdown list of the filter criteria shall be displayed followed by an input field. The input field shall allow wildcard chars % and _.

Describe alternatives you've considered A work-around currently is to manually go to profiles and then search for the user who requested for an avatar to check if they already have an avatar or not and to manually check all users who already have approved avatars to check that all avatars are unique.

Suggested wireframe: https://ibb.co/FhbJBcg

[sidewalkill]

I don't think a repository is needed: A quick check could be conducted where, with each avatar request, their current avatar is also sent to the mod. If programming is efficient, approved avatars should all be stored in the same folder on the server.

[chi00]

I took into consideration that storing all approved avatars in the server would take up a lot of space (avatars are currently hosted in third party sites and the server only stores links.) that's why the request was to display a preview and display the URL of the avatar. The wireframe (including the preview and the link) was also heavily patterned on the current layout of Customer Avatar Requests page so anyone who wants to pull this request can have a baseline.