#1 Simple SQL Guide (Copy - Paste items)

Stat type can be found here:
https://trinitycore.atlassian.net/wik...

Display ID can be found by looking at other items or DBC.

In text:
Step 1: Connect to Heidisql
Step 2: List items by ID (not required, but makes it easier)
Step 3: Find the item that you'd like to copy
Step 4: Update items stats by increasing them slightly (or add new stats, but do not do this for Emerald items)
Step 5: Make sure to update ilevel to 275, quality to 5
Step 6: To save the item, simply click on another column and it'll save it automatically.