Rewrite the showcase

[SGA-A]

Is your feature request related to a problem? Please describe.

This is an issue that requests for the showcase to be rewritten. The way it is stored as well as the algorithms used will be rewritten again entirely from scratch.

Describe the solution you'd like

We want to make a single command that is used to manage your entire showcase. The fundamentals behind how this logic works needs to be firm.

A single callback This function defines the select options that will be displayed along with the logic that returns the embed for what the showcase will look like on the Discord UI. It will also return a list of tuples. It makes a single query to the database that fetches all the item metadata, item ID sorted by its position. This function is called every single time an interaction is made with the view this command is in to invalidate possibly outdated data. No cache systems are built in for the sake of keeping it simple.

Here's the gist of what this function will do:

• Make a single query to the database to fetch the metadata of the items within the showcase and its respective IDs sorted by the position in descending order.
• The embed returns the UI showcase in a for loop
• The select options are also generated in that same for loop
• This function will also detect when the user doesn't have an item any more, in which case, delete the entry. The select option and the corresponding number on the embed will say "Empty slot".
• Return the embed with its added content and a new list of tuples generated containing [(item_id, item_emoji, item_name), ...] or a dictionary instead (still considering how this will work)

Button logic [Not Complete] This will list all the buttons, what they do and how to behave in certain scenarios. The brackets containing Unicode Character indicates that there will be no label on the button, just an emoji representing what it does.

• Move Up (Unicode Character)
  • Move the current item up. If there's nothing above, disable the item.
• Move Down (Unicode Character)
  • Move the current item down. If there's nothing benath, disable the item.
• Set/Remove Item..
  • This item is dynamic, the functionality (and hence the label) changes based on what the current item selected is.
  • IF there is an empty slot selected, button will be labelled Add Item... Allows the user to set an item under this slot. A modal is sent. If all goes well and the user enters a valid item name, add it to the empty slot and replace the select option label and emoji to the selected item. Change the state of this item to the logic of 'Remove Item'.
  • IF there is an item selected, button will be labelled Remove Item... Allows the user to remove an item under the selected slot. Since the select menu should hopefully store the ID of the selected item, we make a single query to remove the item at this point. Update the embed and dropdown to display an empty slot at this position. Change the state of this item to the logic of 'Add Item'.

Select menu logic [Not Complete] Based on what's selected and where it's selected the buttons to move up and down will be disabled. By default, the first time you view the showcase, you will always have selected the first item (or nothing if it doesn't exist). Therefore, the item should be disabled immediatley when the class is instantiated.

• IF this is the only item in the list (or there are none), disable all buttons.
• IF this is the last item in the list, disable the buttons as well.
• IF there is nothing beneath this item, disabled the button to move the item down
• IF the maximum showcase size has been reached and the person is viewing the last item (assuming a showcase full of items), disable the button to move this item down.
• IF the person is viewing an empty slot (meaning no item is selected because there isn't any at that slot), disable all items. There's probably more logic that needs to be designed for this, I'll write it up later.

In any callback, whether it be a button or a select menu, should refresh the showcase by checking it again in the database. It doesn't matter if changes weren't made, we call the database for a double check regardless.

Describe alternatives you've considered

None at this time.

[SGA-A]

We are considering placing everything in one command. So there will be buttons to remove and items instead of making them seperate commands. This isn't definite though.

Update: This has been made definite and will be implemented in this way.

[SGA-A]

Most of what we said was going to be made was not implemented, simply because of how complex it had gotten. Keeping track of states on every interaction is not easy, and we weren't willing to let the bot keep up with it. It's now stateless and you can no longer change the positioning of items in your showcase. In the end, we just wanted a functional and efficient showcase management system.