[Смердокрыл]

Introduction

I bet many of you have, at least once, encountered a situation when you wanted to transmog an item just for fun, but you couldn't because of some stupid restriction, and even though it was nothing major and important, you couldn't just let it go because you have an obsessive personality. Now I shall teach you the excruciatingly sophisticated algorithm of bypassing the bullshit and just making the stupid thing work.

I will use the following key words:

• Source item - the actual item you want to change the look of
• Target item - the item you want to get the look from
• Intermediate item - any item which the source item can be transmogrified into

This should be working with all Cata + clients. I have no idea about custom transmog systems implemented on clients <Cata.

Tools and resources

• Any MySQL editor

The Technique

1. Find the intermediate item
2. Transmogrify the source item into the intermediate item
3. Open the Characters database, the item_instance table
4. In the owner_guid column, find the id of your character
5. In the enchantments cell of that row you will have a bunch of zeros and other numbers
   E.g. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 32868 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
   Among those numbers will be the id of your intermediate item
6. Replace that with the id of your target item
7. Relog on your character

Enjoy your one-handed mace-staff!