
Originally Posted by
blapanda
Items at NPCs are bound to the tables:
_RefObjCommon: about regular values, item ID, item price, etc. -> cooperates with _RefObjItem
_RefPackageItem: is the usual inventory of the shopping list (either NPC, Item Mall, others), as well some specialities can be done here, like listing those items (Item Mall only) at the main page on more than 3 categories
_RefPricePolicyOfItem: the typical "what does it costs? how much it costs?" will be declared here
_RefScrapPackageOfItem: general item count when purchasing, parameters like plus, str, int, etc stock-upgrades, and so on
_RefShopGoods: the shop item itself, where it should be listed on which NPC in which row and column (SlotIndex)
Try to keep those as sync as possible. There are quite helpful queries merging _RefObj* tables properly for the client.
The other "shop" related tables, just do a simple "USE XYZ FROM _TableName WHERE Service = 1". Copy and paste the results to the respective text-files at your client. Done.
About your other stuff:
"this item is to drop but can't find in ..."
Those items, which are not active, will get this error. I assume, you haven't checked the Service of those items. Just simply do a search query, e.g.:
USE SRO_VT_SHARD
SELECT * FROM _RefObjCommon
WHERE ID = 7084
Is the first column [Service] = 0? That is your problem. Set it to 1 (active). Fixed.
The other "!!! there is no record" error, you can actually ignore those. Not important, if you haven't bothered with it.
The tax rate might be a bug (the value is quite suspicious) but not an actual error. It just shows the current tax. "fatal" is not always a bad sign.
Your last issue is your own fault. You either forgot to extract the "Data.pk2"-pack file from your silkroad client to the server's root "data"-folder or it is mismatching.
That issue usually says "Hai dood, you know what? Me haz coordinates for region XYZ but I am missing nav(igation)mesh(es). Gimmi those, pleez!".