azerothcore / acore-cms

ACore CMS based on Wordpress
https://www.azerothcore.org/acore-cms/
50 stars 33 forks source link

Transmog appareance collection #108

Open Helias opened 2 years ago

Helias commented 2 years ago

Add in the wordpress administration panel of the user, next-to the Characters, a panel for "Transmog Collections".

It should show the collection items per account and, selecting a character and an item of the saved ones, the 3D character viewer with the related item selected.

Structure table for retrieving the item per account_id:

SQL
CREATE TABLE IF NOT EXISTS `custom_unlocked_appearances` (
    `account_id`       int(10) unsigned      NOT NULL,
    `item_template_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`account_id`, `item_template_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

Mockup example: image

I would like to replace the "ITEM" with some good item list in a