[Tutorial] Change appearance, item upgrades/color, hairstyle and hairstyle color

[Patchouli]

Edit: Updated the inner/hair freepass with an extra step to prevent future passes from overwriting the first pass.

Note that to see changes, you'll need to relog.
You may want to backup your database before you make any changes.

Why use these over the in-game systems?
Because you can get the exact colors and upgrades you want without having to deal with the BS.
You can also override some shop errors that prevent some hairstyles from being purchased.


Change appearance:

1. Using HeroesOpTool and Push Item, give yourself "cash_lookchange_item" (without the quotes).
If you don't know how to do this, read the tutorials in this forum that explain how.

2. Enter the Avatar Shop, select Body Type, purchase an Appearance Alteration Coupon.

3. Make the changes you want. Click Purchase.
You should now be able to Complete Purchase.



Change item enhance/enchant:

Hard way:
1. In Heroes database, open up "CharacterInfo" and get your character's ID.

2. Go to "Item", sort by ItemClass, and look for the name of the item you want to change.
For example, "shiningwill_head". Note the ID number.
Make sure the OwnerID matches your Character's ID number.

3. Go to "ItemAttribute". Add a new record (+ button in Navicat).
ID should be the next number in order (eg. if the last ID was 295, the new record should be 296).
Under ItemID, use the ID number you got from step 2.
Under Attribute, write ENHANCE, PREFIX or SUFFIX.
For Value, if you wrote ENHANCE, write 15.

If you wrote PREFIX or SUFFIX, use this link as reference.
Examples: berserker, explosive, judgment, jade, strong, bloodlust, fast.
You can also use HeroesDB.net and see the valid enchants for each item.

Note that you will need a separate record for ENHANCE, PREFIX and SUFFIX.
Also note that some enchants don't seem to be listed properly. Not sure if those ones actually work.


Easy way:
1. Upgrade the equipment to +1, or an obvious number.
If you don't have the upgrade item, use Push Item to give it to yourself:
enhance_stone_lvl1
enhance_stone_lvl2
enhance_stone_lvl3
Level 3 = Epic Enhancement Stone.

2. Open up the heroes database and go to ItemAttribute.
You'll see ID, ItemID, Attribute, Value, Arg, Arg2.
There should be an entry at the bottom with the Attribute "ENHANCE".
The Value will be whatever you just upgraded the item to (eg. +1 is Value = 1).

3. Change the Enhance level to 15 (or whatever your preferred enhance level is).
Refer to the hard way if you want to add enchants.
Or simply look for the matching ID's Prefix/Suffix and change the Value to your desired enchant.



Change item colors:

If you don't have the item yet:
1a. Add the item via Push Item (in HeroesOpTool).
If you don't know how to do this, read the tutorials in this forum that explain how.

2a. In the Heroes database, open up "Item".
The last (newest) entry should be the item you just added.
That entry's ItemClass should match what you added via Push Item.
Take note of its ID number.

If it is a temporary item, there will be a date under ExpireDateTime.
If you want to remove the timer, change this value to Null.

If you already have the item:
1b. In Heroes database, open up "CharacterInfo" and get your character's ID.

2b. Go to "Item", sort by ItemClass, and look for the name of the item you want to change.
For example, "shiningwill_head". Note the ID number.
Make sure the OwnerID matches your Character's ID number.

Both of the above scenarios continue here:
3. Go to Color Picker - ColorPicker.com and pick a color you like.
Note the Hex value (eg. pure white is 255, 255, 255 = #FFFFFF).

4. Open up Windows Calculator. You may need to set it to Programmer mode (under View dropdown).
Select Hex mode, and type in the Hex value you got in step 4 (eg. FFFFFF).
Click Dec. It should convert the Hex value into Decimal (eg. FFFFFF becomes 16777215).

5. Back to Heroes database, open "Equippable".
Look for the ID you obtained in step 2. If you just added the item, it should be the latest entry.
There will be Color1, Color2 and Color3.
These are equivalent to Part1, Part2 and Part 3 in the Dye Shop.

6. Copy paste the Decimal value you got in step 4, into the Color you want.
Repeat for each Color part. Once you're done, relog and enjoy!



Get hairstyle and change its color:

1. Using HeroesOpTool and Push Item, give yourself "cash_freepass_0_hair_test" (without the quotes).
This is a coupon that lets you purchase a free hairstyle, but it only lasts 10 minutes.
We'll fix that later.

You can also use this method to give yourself and change inner armor colors.
Give yourself "cash_freepass_0_inner_test" instead.

2. Go to the Avatar Shop and purchase a hairstyle (or inner).
Pick anything you like, and whatever color you like.
If you get an error (Fiona's Night Rose seems to always give an error), pick another hairstyle.

3. In Heroes database, open up "ItemAttribute".
The latest entry should be the hairstyle (or inner) you just added.
Note the Value. it will be the same name as the ItemClass.

4. In Heroes database, open up "Item".
The latest entry should be the hairstyle (or inner) you just added. Note the ID number.
Under ExpireDateTime, there will be a date. Change the value to Null.

You will need to change the ItemClass from "cash_freepass" to the Value you got from ItemAttribute.
If you don't do this, future freepasses will apply to the hairstyle/inner you first obtained with a pass.

You can also change the hairstyle here, if you were unable to purchase it.
Under ItemClass, replace the ItemClass name with the one you want.
Note that you will also need to go to "ItemAttribute" and change the Value there as well.
If you do not do that, the appearance will not change.

5. Go to Color Picker - ColorPicker.com and pick a color you like.
Note the Hex value (eg. pure white is 255, 255, 255 = #FFFFFF).

6. Open up Windows Calculator. You may need to set it to Programmer mode (under View dropdown).
Select Hex mode, and type in the Hex value you got in step 5 (eg. FFFFFF).
Click Dec. It should convert the Hex value into Decimal (eg. FFFFFF becomes 16777215).

7. Back to Heroes database, open "Equippable".
The latest entry should be the hairstyle you just added. If not, use the ID number from step 4 to find it.
There will be Color1, Color2 and Color3. As far as I know, hairstyles only use Color1.

8. Copy paste the Decimal value you got in step 6, into Color1
That should do it. Relog and equip your new hairstyle!


Enjoy. Let me know if you find any mistakes in my tutorial.

[MentaL]

[med1]

There is an easier way to get the colors you want, just use Push Item(Item Festival). For example

dye_color_cash[VALUE:16777215] will give you white dye ampoule

dye_color_avatar_avatarcolor[VALUE:14421775] will give you red avatar dye ampoule

Just use the color picker and convert HEX to DEC.

[Patchouli]

Thanks. Didn't think of editing dye colors.

[Anvis]

how do i open the database? i'm basically new to this server stuff

[PunkS7yle]

Open slq server management studio, in the connection tab type (local) for server name, sa for user, and use the pass u set when u installed SQL, click new query > type what's in these posts.

[tammy11]

I have everything working but can't find the latest spawned items (makeup, hair, inner) to perm them and modify colors on the makeup. When I spawn them, I see it in itemattribute but not in item.. really not sure. I'm using SSMS for DB editing and learning as I go. Should I use something else?

Im in Databases/System Databases/heroes/Tables/dbo.item opened with edit top 200

[WAMVN]

I have everything working but can't find the latest spawned items (makeup, hair, inner) to perm them and modify colors on the makeup. When I spawn them, I see it in itemattribute but not in item.. really not sure. I'm using SSMS for DB editing and learning as I go. Should I use something else?

Im in Databases/System Databases/heroes/Tables/dbo.item opened with edit top 200

You dont see it in item because Edit top 200 will show first 200 records only, you can not see records from 201.
Run query: select * from Item where OwnedId = your character id.
character id can be found in CharacterInfo table.

[Patchouli]

Not sure if the problem is because you're looking for the item name instead of the pass name.

I think in the official game, a single pass can be changed into other stuff for the duration that it lasts.
That's why passes are still listed as passes in the item table, and what you select is listed in itemattribute.
If you try to change your inner/makeup/hair, it just changes the itemattribute look, not the pass itself.

To make the inner/makeup/hair permanent, you have to copy paste the itemattribute look name over the item table look name, and set the expire date to null.
That will change it from a pass into a permanent item.

I should probably elaborate on that in the first post.

[Anvis]

Passes for permanent duration no db edit needed:
cash_lookchange_item -change proportions
cash_free_hair_forever_enus -permanent hair
cash_free_inner_forever_enus -permanent inner
cash_free_facepainting_free -permanent face tattoo
cash_free_bodypainting -permanent body tattoo
sharedinventory_ticket_unlimited -permanent shared inventory

[1150ny]

how to get make up and edit the make up color