Small tutorial to fix/add randomitems/avatarsets
Open the navicat and go to ItemClassInfo, to find avatarset that you need, eg this randomitem_avatar_female_hoodie_rare
Now you need to add this item to RandomItem,RandomItemRecipeClass and RandomItemRecipe table's (I'll use SQLiteStudio)
Start with RandomItem table
Start with RandomItem table
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
ItemClass - the same as in itemclassinfo
Visual - 1(I think so)
In other columns, set values as in the above rows
RandomItemRecipeClass
Id - the same as in RandomItem table
ItemClass - the same as in ItemClassInfo
Probability - 1
ItemNumber - number of items in the package
ItemClass - the same as in ItemClassInfo
Probability - 1
ItemNumber - number of items in the package
RandomItemRecipe
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
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
UPDATE
Fix transaction failed innerarmor/hair
Fix transaction failed innerarmor/hair
For example "lynn_inner_bloodyrose"
Open "heroes.db3.comp" go to the tables "CustomazeItemInfo" "CustomizePriceInfo" and find inner/hair
Open "heroescontent.db3" open the same tables
and just copy all rows from the heroes.db3.comp to the heroescontent.db3
and just copy all rows from the heroes.db3.comp to the heroescontent.db3
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
Go to "CustomizeItemInfo"
Change all CashShopType "en-EU" to "zh-TW", after "zh-TW" to "en-EU"
To do the same in "CustomizePriceInfo"
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
Change all CashShopType "en-EU" to "zh-TW", after "zh-TW" to "en-EU"
Attachments
You must be registered for see attachments list
Last edited: