An Uncessary unsolvable Item Shop issue

[blapanda]

Did anybody faced this issue yet?
I am pretty used to adding stuff into the item mall, it is just a piece of cake for me.

Tho, this time, the price will be showing "0 Silk".
On purchase, it will subtract the amount given at the database inside the table price policy.
The price is regularly set as "2" for silk, 100 as cost.
ObjCommon has the price as well, media sided string too.

So, why the heck is the price 0?
Tried to delete ForeignKeys, deleted the cache server and client sided, nothing seems to fix this issue.


It feels like vSRO 188 gets kind of unstable, if modified too heavily with ASM and SPs, but, I didn't modifed my client since 9 months.

Uh ... getting tired of this game. So freaking miserable and terrible programmed.

[MentaL]

[blapanda]

Issue still presists. C'mon guys.
Anyone, someone should have faced this issue yet...
Alike the annoying "EngagedCOS not total used" unnecessary crap, tho that one is easy to fix.

[Caosfox]

i only have 60 items in total at item mall, maybe that problem happends with way more items? i never got that error (like the engagedCOS, i never got that error)
you tried to check with unedited files? only to test if the editions screwed the server

[blapanda]

Well, I got quite some item mall items, to be honest. Probably more than 200.
Including potion bags (hp, mp, pill), devil/angel, every single official dress, growth, fellow, legendary, special quest enablers, d11- and d13 gender and race scrolls, etc.

I am thinking about getting started to csro or vsro 193 files, might trying there my luck instead.
But yeah, tried on a clean state of my files, isn't happening. Tho, deleting the foreignkeys of the scrappackageofitem and shopgoods will kind of bug every price inside the game.
On purchase, it will still subtract the correct amount.
It is just weird. Might be a simple programming issue between the communication of mssql and the server tools. Using SQL 2012 since the beginning and have had never an issue like this.

Btw. Thanks for your response. You are always replying! Rep+

The EngadedCOS issue is a mistake of joymax's table input. It is referring to a none existing "EngadedCOS" column in _Char and outputting the error message on side of the gameserver. It should erase the ownerstate or whatever it was, which is impossible. So just out commenting a source, which has no effect is the only way to get rid off it. Even the procedures are not up adding specific data to a column called EngagedCOS.

[Caosfox]

i must try vsro 193 someday
right now im happy with twsro, and totally dislike csro-r item mall, so im skyping it for now

[blapanda]

Mhm. That is my reason as well. A stock/clean server would be the base I would start over with.

Won't be that hard adding my content back to the server - documented and protocolled all my updates. :)