[BR-Files] I can't buy a few item mall items

[trytokillme]

hey guys I have a problem with some item mall items like devil spirit, premium ticket, transgender and some pets.
there are in the mall and when I want buy them, nothing happens. they are in the game server too and activated but I can't buy them.

can you help me?

[MentaL]

[Jangan]

that means that the item is only in the media side and is not added or done properly in the server side.

in other words server shops != media shops format. so you should re-do the shops.

[PX2000]

I give you a trick to this ...

First step
put your desired items in client side..
_RefPackageItem.txt,
_RefPricePolicyOfItem.txt,
_RefScrapOfPackageItem.txt,
_RefShopGoods.txt
(Note: Test run the client after editing.. It will crash if you have mistake!)

Second step

DROP and CREATE
_RefPackageItem,
_RefPricePolicyOfItem,
_RefScrapOfPackageItem,
_RefShopGoods

Third step
Copy/paste this 4 edited files in 'C:\'
then use BULK INSERT to this 4 files that correspond to the 4 tables.
(Ignore the 2 Bulk Load message's after executing)

Fourth step
This step is to have a very sync
_RefPackageItem -> _RefPackageItem.txt
_RefPricePolicyOfItem -> _RefPricePolicyOfItem.txt
_RefScrapOfPackageItem -> _RefScrapOfPackageItem.txt
_RefShopGoods -> _RefShopGood.tx

Create a txt file with those files above open it in HEX editor then add in the first 'FF FE', save the file. Now open the file in "010 Editor" edit as 'Unicode' then press right-arrow key once then copy/paste the lines from the database..

Good luck!