Glamours: Re-work the entire system.

[UkcsAlias]

Every piece of the same gear has the same look on every character so the item exists only once in the database. You only need a simple reference between the item and the character and you are done.

A player will only see 1 set of items applied on you. You can change to some plates on that, but even here, its a static set. It doesnt matter how many combinations can be made, the sets are limited already the moment you leave your inn room. It does not matter how many glam items there are in your dresser, how the colors are applied (whether they use dye or not), since these things are not being saved in your plate. The plate just stores it and each client can just load that plate.

The entire problem is purely down to how things are stored in that dresser.

[Larirawiel]

A player will only see 1 set of items applied on you. You can change to some plates on that, but even here, its a static set. It doesnt matter how many combinations can be made, the sets are limited already the moment you leave your inn room. It does not matter how many glam items there are in your dresser, how the colors are applied (whether they use dye or not), since these things are not being saved in your plate. The plate just stores it and each client can just load that plate.

The entire problem is purely down to how things are stored in that dresser.

It is not static because you can dye it. The dye-part is dynamic. So you need:

Character -> CharacterItems -> Item -> ItemColors -> Color mapping in your database. Because items can have many colors and colors can be applied on many items, an m:n connection is needed between items and colors. Which is realized with an additional table in the database.

In WoW you only need Account -> AccountItems -> Item mapping because each item is exactly the same. WoW does not support dyeing.

And yes, it would be possible to make a system equal to WoW even with dyes. But it would require a partial database migration and some work in the game logic. I guess, they fear it because it means tons of work.



Cheers