Finally how to add Avatar in Item Mall VSRO Files

[arabcart]

Hello Brothers
Yesterday i was ask all how i can add Avatar to Item mall
and Finally i get Way personal with Care of Allah
So i say i must make guide because all ask about it and no one answer

Program Required :
1- Pk2ExtractorSE.exe Download
2- Pk2Editor.exe Download

Steps :
1- Open PK2ExtractorSE.exe and open media From it
then Extract " refpackageitem.txt "

/server_dep/silkroad/textdata

then open it i mean " refpackageitem.txt " and change all Saletag to 0 ( ZERO )

2- open SQL then open table dbo._refpackageitem

SRO_VT_SHARD/TABLES/dbo._RefPackageItem

and change all Saletag to 0 For All

3- now open Pk2Editor.exe and open media then import file refpackageitem.txt Edited

now try your server you will found all Avatar in Item Mall
i hope help some others

[MentaL]

[benike1]

took you long enough to figure it out..

[sladlejrhfpq]

thank you

[rieljames]

took you long enough to figure it out..

so you mean you already knew it all along and you are not sharing it.?

@threadstarter
Tnx..

[arabcart]

so you mean you already knew it all along and you are not sharing it.?

@threadstarter
Tnx..

np bro
when i get this i share it after test it direct

[ItachiSNS]

Do you guys think this will work by adding weapons to item mall?
E.g.
ITEM_CH_SWORD_12_C_RARE SaleTag 1 > 0.

Do you think this will be added to item mall ^^?

[arabcart]

Do you guys think this will work by adding weapons to item mall?
E.g.
ITEM_CH_SWORD_12_C_RARE SaleTag 1 > 0.

Do you think this will be added to item mall ^^?

to add items in Item mall you must add it in 4 Tables in SRO_VT_SHARD

refpackageitem
refpricepolicyofitem
refshopgoods
refscrapofpackageitem

and in media Side in txt with same name of table

/server_dep/silkroad/textdata

[ModGift]

Thanks....

[rieljames]

where saletag?

in front of your eyes.. look thoroughly..
it is the number right next to item codename

 
ITEM_MALL_AVATAR_W_FOX_HAT        32    //change '32' to '0' 
ITEM_MALL_AVATAR_W_FOX        32  //change '32' to '0' 

do it for all avatar codenames..

[ItachiSNS]

to add items in Item mall you must add it in 4 Tables in SRO_VT_SHARD

refpackageitem
refpricepolicyofitem
refshopgoods
refscrapofpackageitem

and in media Side in txt with same name of table

/server_dep/silkroad/textdata

For god sake , that tables are to add the item to npc and i already done that , i am asking if it's possible to add an normal weapon/shield/acc etc to item mall.

[arabcart]

For god sake , that tables are to add the item to npc and i already done that , i am asking if it's possible to add an normal weapon/shield/acc etc to item mall.

refshopgoods = where item will sell
refpricepolicyofitem = Price of item and payment Method

1 = Gold
2 = P Silk
4 = Gift Silk
16= N silk

[ModGift]

in front of your eyes.. look thoroughly..
it is the number right next to item codename

 
ITEM_MALL_AVATAR_W_FOX_HAT        32    //change '32' to '0' 
ITEM_MALL_AVATAR_W_FOX        32  //change '32' to '0' 

do it for all avatar codenames..

oh dude i found thanks again.

[zilvis310]

cPk2Writer::Open: This object has not been initialized yet.

[hexcode]

You can use this query to enable all avatars in server side (SRO_VT_SHARD):

UPDATE _RefPackageItem
SET SaleTag = '0'
WHERE (CodeName128 LIKE 'PACKAGE_ITEM_MALL_AVATAR%')

[Kemo]

this query is not working

need correct query i trying

UPDATE [dbo].[_RefPackageItem]
SET SaleTag = 0
WHERE CodeName128 like '%PACKAGE_ITEM_MALL_AVATAR%'

but still error