Finally how to add Avatar in Item Mall VSRO Files

Quote:

---

Originally Posted by Kemo

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

need correct query i trying
but still error

---

try

Code:

---

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

---

i try it already it's not working .....

for me its works i can see avatars in mall but i cannot buy it ..

maybe i should add it at _RefShopGoods.dbo?

Quote:

---

Originally Posted by dragonzee

for me its works i can see avatars in mall but i cannot buy it ..

maybe i should add it at _RefShopGoods.dbo?

---

r u restart your server

sure i did ...

when i add the avatar on refshogoods.txt its apper but not sell able

Quote:

---

Originally Posted by dragonzee

sure i did ...

when i add the avatar on refshogoods.txt its apper but not sell able

---

the Avatar Which u want add in Database or not ??

well i have almost all avatars in mall "that before see this guide"

and when i was try to add new one wasnt add now its added but not sell able

thos avatars (Hallowen"Witch",Winter,Devil wing, EU Wedding, CH Wedding)

that cause you guys should make package for it just the packageitem's can sold in the shop's or item mall
=)
when i have a time i will make guide :thumbup:

thx i do it

but same new items like tree

:D

i will try to find code for others items

Hi all.
How to add NEW AVATARS to database?
Anyone have Database with all(60) avatars? and media.pk2 with all avatar??

i need that too :D

Quote:

---

Originally Posted by Simiramist

Hi all.
How to add NEW AVATARS to database?
Anyone have Database with all(60) avatars? and media.pk2 with all avatar??

---

i think we may Extract it from the Real Media of Sro

i am working on it :)

Thanks :D i'll try it :D

Ty......

thank you mate work well :)