how to set cash shop items ?

[fashi]

in the data table ItemMall.dbo.tItems , what does the column 'nGoodsNo' mean ? how to build a connection between the database and "ItemInfo.shn" ?

[MentaL]

[Jaeru]

The ItemMall/Store/Shop doesn't just work between databases and ItemInfo.shn, like you can see in the files, there are files named "ItemShop.shn" & "ItemShopView.shn", that means that what really links the items between DataBases (DB) and InGame is: DB - ItemShop.shn - ItemInfo.shn+ItemShop.shn, when you bought an Item in the store it asks to the ItemShop.shn when you try to "check" your premium inventory (PI), then if that item exists in both files, you will be available to see it in your PI, else the item will not even be visible... if you already added the item you wish to "change" (if it wasn't already on the databases or the Item files) the relation between data is the next (supposing that you are using bakey's release):
[DB] = [ItemShop.shn]+[ItemShopView.shn] = [ItemInfo.shn]
nGoodsNo = goodsNo-InxName+InxName-{IconsConfig} = InxName

From there you will need to "match your data" into the DB and the ItemShop file ("Lot" = meaning the quantity of stacked items)... and if you have issues, you can always take an existing item like reference. Hope helped you....

[fashi]

It seems that [ItemShop.shn]+[ItemShopView.shn] are ok, I bought 2 items in the premiun inventory and i can see them in the game.
When i try to right click it ( i wanna move it to my normal inventory) An unknown error has occurred :4162

[Jaeru]

Thats probably your Rest Server Version, or it can be too the "ports" where you are running the server... try downloading another RestServer Version (or make your own, I Mean, after the code was released you can build your own), I won't "post" those link to avoid issues with the corresponding Autors, anyways you can find it by here in RGz.... Conclusion: Check your Rest server... and else your server configuration....

[oodasm]

when i use the item in premiun inventory, I found the RestServer log.like：
******DatabaseManager::setItemUsed('53631', '49', '20304') FAILED******
denied on object 'tPurchases' (database 'Account',architecture 'dbo' ) UPDATE permissions.
ＨＯＷ　TO FIX IT？I modify the permission ，but no usefull。Plz help me,

[Jaeru]

In your "OdinRestServerSettings.shn" config file check that the highlighted settings in the image (link) bellow are those:
http://prntscr.com/3vedio

As you can see there are 2 tables implicated (without taking in count Item Mall database) at the moment os setting an Item like "Used":
- tPurchases: The items that are here is at the moment you bought something, goes here, thats like those items can be "viewed" by all your characters.
- tItemUses: When you use (right click on PI) an Item that was on "tPurchases" table, the data of it, pass to the other table.

In this case, your RestServer is asking for "(database 'Account',architecture 'dbo' )", then, is yout database name the correct on the "OdinRestServerSettings.shn"?
Why do I ask that? Well, normally the default name of the OdinFiles for that database is: OdinAccounts
Then check fine if you changed the name to change it to in the SHN file that set the config of the REST.Server, if this is not what you think that is the error, maybe we will need to know more details about your issue....