Question [HELP ITEM MALL]Avatar can see but can't buy

[zomgevonyreally]

Using a VSRO

Hey guys,

I can see all of the Avatars in the Item Mall, and some of them are purchasable but others just don't buy.

If anyone can help it would be greatly appreciated.

Thank you.

[JuliaRocks]

Because they're only in media.pk2 that's why you see them but you can't buy.

[Haxor]

#moved

[zomgevonyreally]

Originally Posted by JuliaRocks

Because they're only in media.pk2 that's why you see them but you can't buy.

Thanks for the reply! I thought that may be the issue as well so I tried adding the items that did not work into the item mall.

I followed and ran the search query in that guide to check if the items were in the database.

The search came back and it showed that the items were in the database so I skipped the step with the query to add items into the database. I moved on to the step with the query to add items into the item mall.

I ran the query and set the servicetag to 1 and the saletag to 0.

I tried buying the item again from the mall and it did not work. So I checked the saletag of other items in the mall that did work and they were set to saletag 32.

So I went back to the item I was trying to add and set the saletag to 32.

I tried buying the item again and it still did not work.

If you know of another way to add items into the item mall, please share.

Thanks again for the reply and taking the time to read this message!

Link to the Guide:

[Anonymous-6723]

Well here is a simple way that you could use if your data is not equal media/db side

Extract your server_dep folder navigate to textdata and copy those 4 files:
-RefPackageItem
-RefPricePolicyOfItem
-RefScrapOfPackageItem
-RefShopGoods

paste them in C:\

Now execute this query:

truncate table _refpackageitem
truncate table _refpricepolicyofitem
truncate table _refscrapofpackageitem
truncate table _refshopgoods

Now those ones :

BULK INSERT _RefPackageItem FROM 'c:\refpackageitem.txt' WITH (FIELDTERMINATOR = '	')
BULK INSERT _RefPricePolicyOfItem FROM 'c:\RefPricePolicyOfItem.txt' WITH (FIELDTERMINATOR = '	')
BULK INSERT _RefScrapOfPackageItem FROM 'c:\RefScrapOfPackageItem.txt' WITH (FIELDTERMINATOR = '	')
BULK INSERT _RefShopGoods FROM 'c:\RefShopGoods' WITH (FIELDTERMINATOR = '	')

And now this :

SELECT * FROM _RefPackageItem where Service = 1
SELECT * FROM _RefPricePolicyOfItem where Service = 1
SELECT * FROM _RefScrapOfPackageItem where Service = 1
SELECT * FROM _RefShopGoods where Service = 1

Copy/and paste the whole data in the right .txt files (in your media.../textdata folder) import, restart gameserver and test Hope it works for you too.

[carl0s_]

I don't understand why we need to make the last step:

SELECT * FROM _RefPackageItem where Service = 1
SELECT * FROM _RefPricePolicyOfItem where Service = 1
SELECT * FROM _RefScrapOfPackageItem where Service = 1
SELECT * FROM _RefShopGoods where Service = 1

Copy/and paste the whole data in the right .txt files (in your media.../textdata folder) import, restart gameserver and test Hope it works for you too.

Sound redundant O.o, can you explain me this please?, means to re-write with same content the files from i toke initial data? I think this last step is wrong step, but tnx so much for your help, regards