This is simply guide how to add the new avatars into a item mall.
If you got the avatars enabled in _RefObjCommon and also modified on client side it should work.
Query for server side:
This query will enable you all the avatars in db, if you dont want them all you can simply manually set the service to 1 for desired avatar in _RefObjCommon table.Code:UPDATE [dbo].[_RefObjCommon] SET Service = 1 WHERE CodeName128 like '%ITEM_MALL_AVATAR%'
Before you proceed to step 2, read this for client side avatars:
Link
Ok for example i will take Assassin woman hat.
First you need to create package item so open the _RefPackageItem (I wont use query's due only 1 item, but if you add more of them Insert into is your friend)
Now scroll to the bottom and add this
Service= 1 ( Enabled)
Country=15 (Vietnam)
ID= Leave it blank its auto fill
CodeName128= PACKAGE_ITEM_MALL_AVATAR_W_ASSASSIN_HAT (female assassin hat)
Saletag= 0
Expand Term= EXPAND_TERM_ALL
NameStrID=SN_ITEM_MALL_AVATAR_W_ASSASSIN_HAT
DescStrID=SN_ITEM_MALL_AVATAR_W_ASSASSIN_HAT_TT_DESC
AssocFileIcon= item\Avatar\mall_avatar_w_assassin_hat.ddj (icon inside the media.pk2)
Rest of collums do the same as others (-1,xxx etc)
Now when your package is ready time to RefScrapOfPackageItem
Service=1
Country=15
RefPackageItemCodeName= PACKAGE_ITEM_MALL_AVATAR_W_ASSASSIN_HAT
RefItemCodeName= ITEM_MALL_AVATAR_W_ASSASSIN_HAT
Data= 0 (use 0 for avatars)
Index= will be auto filled
Time for RefPricePolicyOfItem
Service=1
Country=15
RefPackageItemCodeName=PACKAGE_ITEM_MALL_AVATAR_W_ASSASSIN_HAT
Payment device= 2 ( Look at the other item mall items)
Cost= your price of item
Now RefShopGoods
Service=1
Country=15
RefTabCodeName= MALL_AVATAR_HAT (mall_avatar_dress or mall_avatar_attach, depends on item)
RefPackageItemCodeName= PACKAGE_ITEM_MALL_AVATAR_W_ASSASSIN_HAT
Slot= Now take a look to hat section, find the item with highest slot number. New hat should be that number + 1.
There is also a table named _RefShopItemStockPeriod . Some of mine items didnt work without that table ( makes no sense but k).Well open up and put the data inside.
->This is server side, same thing you have to do on client side. Those .txt files are same as db tables, use pk2 extractor and start your edit.
->im sorry for bit "ugly" guide, kinda tierd but should help you.
Notice: Index on RefScrapOfPackageItem have to be same on client side, same goes with ID on _RefPackageItem



Reply With Quote


