Finally how to add Avatar in Item Mall VSRO Files

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 "

Code:

---

/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

Code:

---

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

took you long enough to figure it out..

thank you

Quote:

---

Originally Posted by benike1

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..

Quote:

---

Originally Posted by rieljames

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

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 ^^?

Quote:

---

Originally Posted by 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 ^^?

---

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

Code:

---

refpackageitem
refpricepolicyofitem
refshopgoods
refscrapofpackageitem

---

and in media Side in txt with same name of table

Code:

---

/server_dep/silkroad/textdata

---

Thanks....

Quote:

---

Originally Posted by ModGift

where saletag?

---

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

PHP Code:

---

 
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..

Quote:

---

Originally Posted by arabcart

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

Code:

---

refpackageitem
refpricepolicyofitem
refshopgoods
refscrapofpackageitem

---

and in media Side in txt with same name of table

Code:

---

/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.:thumbup:

Quote:

---

Originally Posted by ItachiSNS

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.:thumbup:

---

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

Code:

---

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

---

Quote:

---

Originally Posted by rieljames

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

PHP Code:

---

 
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.

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

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

Quote:

---

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

---

this query is not working http://img707.imageshack.us/img707/8650/unled5zn.png

need correct query i trying

Quote:

---

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

---

but still error