[Tutorial] Fix Not Usable Randomitems/Avatarsets/Transaction failed

[Gvygvxvx]

Small tutorial to fix/add randomitems/avatarsets

Spoiler:

Open the navicat and go to ItemClassInfo, to find avatarset that you need, eg this randomitem_avatar_female_hoodie_rare

Spoiler:

Now you need to add this item to RandomItem,RandomItemRecipeClass and RandomItemRecipe table's (I'll use SQLiteStudio)
Start with RandomItem table

Spoiler:

Set id - which you want
ItemClass - the same as in itemclassinfo
Visual - 1(I think so)
In other columns, set values as in the above rows

RandomItemRecipeClass

Spoiler:

Id - the same as in RandomItem table
ItemClass - the same as in ItemClassInfo
Probability - 1
ItemNumber - number of items in the package

RandomItemRecipe

Spoiler:

Here add rows depending on the number of items in the package
For example, in randomitem_avatar_female_hoodie_rare 5 items
Id - the same as in RandomItem table
RecipeClassName - the same as in ItemClassInfo
ItemClass - the names of items in the package(head,upper and etc, can be found in ItemClassInfo table)
Number - 1
Probability - 0.2 or 1(0.2 It works for me)
Color - which you want(can be found in CustomizeItemInfo table)
NotifyMessage - 0 or 1(1 - It may be a Announced when you open the package)
In other columns, set values as in the above rows

finally, restart server and go to check package

Spoiler:

UPDATE
Fix transaction failed innerarmor/hair

Spoiler:

For example "lynn_inner_bloodyrose"
Open "heroes.db3.comp" go to the tables "CustomazeItemInfo" "CustomizePriceInfo" and find inner/hair

Spoiler:

Open "heroescontent.db3" open the same tables
and just copy all rows from the heroes.db3.comp to the heroescontent.db3

Spoiler:

If you are using eu client, You need to copy the rows where indicated cashshoptype en-EU
After, change "CashShopType" in "heroescontent.db3" to zh-TW. Done

UPDATE
Anofer metod for Fix transaction failed
Depending on the client's region
eg, eu client
ServerDB only
Transfer tables "CustomizeItemInfo" and "CustomizePriceInfo" in server db from client db

Spoiler:

Go to "CustomizeItemInfo"
Change all CashShopType "en-EU" to "zh-TW", after "zh-TW" to "en-EU"

Spoiler:

To do the same in "CustomizePriceInfo"

[MentaL]

[nultar]

This is really cool, too bad that we have to do the colors ourselves though :P

Thanks for sharing gvygvxvx, appreciate it a lot :)

[Patchouli]

Thanks. I'd have thought recipe was for... well... recipes.

There's a table where you can define default colors: CustomizeDefaultInfo
I haven't tested it yet, though.
A bunch of outfits have CSF files for their default colors. You can copy the values from there.

[nultar]

Just thought of something, does anyone know how to fix "That item cannot be assigned to the selected quickslot." when trying to equip avatar sets?

[Gvygvxvx]

Just thought of something, does anyone know how to fix "That item cannot be assigned to the selected quickslot." when trying to equip avatar sets?

Try just move the item in the slot, you can say the name of the set? I'll see what i can do

[Patchouli]

I get that error when I tried to equip items that weren't valid for that version.

For example, the Midnight Cocktail avatar set. The European client can't equip it in Euro mode.
The icons show up in red, green and blue instead of normal colors and it gives that slot error.
However, running the same client in TW mode makes it work as normal.

I don't know if it's the client or server database that locks the region. Maybe both.

[Patchouli]

I figured out how to fix it. You have to edit the client heroes.db3.
Look in the EquipItemInfo table, the last column is Feature.
For the avatar sister and minidress parts, Feature is set to KR and TW. Null the Feature value for each part.

They will now function properly in-game.

Edit: I'm still getting transaction failed even if my server heroescontents.db3 and client heroes.db3 match. They're both using en-US data and the client is also set to en-US.
Other hair works, but Twin Braid (and other new to US client hair) don't work, even though they are clearly in both databases.

PlayerService.PlayerService][PlayerService.PlayerService (1340)][BeautyShopCustomizeProcessor] - Wrong Costume Item : [fiona_hair_twin_braid]

[AzumaR2]

Any1 can help ?

[nultar]

Try just move the item in the slot, you can say the name of the set? I'll see what i can do

I was having problems with the Bunny Girl Set

I figured out how to fix it. You have to edit the client heroes.db3.
Look in the EquipItemInfo table, the last column is Feature.
For the avatar sister and minidress parts, Feature is set to KR and TW. Null the Feature value for each part.

They will now function properly in-game.

That works, thanks a lot! For whatever reason mods stopped working now though

Edit: Apparently the names of the inners recently got changed, got mods working again by renaming the name of the inner files.
Only thing that doesn't work atm are the tails, I can equip them but they don't show.

[Patchouli]

Probably because tail slot was added after (eg. in the newer bin folder we can't use).
I can upload my bunny suit onepiece + tail mod if you really want it.
Gvy's database didn't have the correct numbers for the Bunny Suit inner.
The numbers are in the player_costume.txt
All of the female chars use Fiona's version, except for Vella.

Any idea how to fix "transaction failed" on newer hairstyles?

[halo2008]

transaction failed


only with avatar i use EU Client

[nultar]

Probably because tail slot was added after (eg. in the newer bin folder we can't use).

Yeah that might be it. I can equip it though, weird issue imo.

I can upload my bunny suit onepiece + tail mod if you really want it.

Nah I'm good thank you :)

Gvy's database didn't have the correct numbers for the Bunny Suit inner.
The numbers are in the player_costume.txt
All of the female chars use Fiona's version, except for Vella.

I do have an item called "vella_inner_bunny_girl" but it looks completely different than the inner that should automatically be equipped when you equip the set, once again, really weird issue.

Any idea how to fix "transaction failed" on newer hairstyles?

Unfortunately I don't have a clue, can't you just add the hair as an item and edit the haircolor through the Equipable table? That's how I did it with make-up

[john007]

Isn't all these steps required us to move or rename UpToDateInfo.dat then we can modify the client's hfs files?

[Patchouli]

No, because you only need to update the server database to reflect the client database and the client's region.

@nultar
In EquipItemInfo (on server) look up the bunny inners and change the (I think) costume ID values to the bunny inners listed in player_costume.txt
It's something like 90703, I forget. Lynn's has 80 when it should be using Fiona's, etc.

[nultar]

@nultar
In EquipItemInfo (on server) look up the bunny inners and change the (I think) costume ID values to the bunny inners listed in player_costume.txt
It's something like 90703, I forget. Lynn's has 80 when it should be using Fiona's, etc.

Thanks a lot my friend! :)