Silk 0 Purchase - Bug

03/10/2015 19:02 blapanda#1
I have found recently a new bug, on the vSRO 188 Files.
I do have quite a lot of stock items at my cash-shop. E.g. Potions from Small to XX-L, Pills, Avatars, Pets, etc.
Lately, being 2 items in addition, those items and the next upcoming one will show "0 Silk" as its price, tho, it will subtract the correct amount of silk from the account.

It isn't that kind of a miracle adding new items to the shop. Done it dozens of times. Just those new items kinda messed up the price visualization.

Does anyone know which table, which foreign key or whatever causes this issue?

By cleaning the Foreign Keys of Ref/-ShopGoods/ScrapOfPackageItem/PricePolicy/ItemPackage will literally mess up the whole price visualization for every item. So, is there an other way?

E.g. re-adding the ScrapPackage items and making a 1 to 40000 [Index] count? Or anything else?

Nope, isn't working.

And yes, Payment Method is 2 for silk, and yes, the item is set as a cash item.
Media does have the price value, the objcommon has the price value, PricePolicy table has the price value.


I have had a total of working 1839 items at the shops and item mall. the 1840th seems to break the system. Any limitation server sided? E.g. gameserver has a "cap" for this shit? Alike the client had a cap for quests till lv 110 ... *facepalm*
03/11/2015 03:59 Aaron*#2
Can you share _refobjcommon & _refpricepolicyofitem lines so i can check them?
03/11/2015 10:56 blapanda#3
As I said, I know what I am doing. Most of the people asking here for nonesense stuff and are not even able to PHP script a part of new column addition to the _AddNewXYZ SPs for better exploit/abuse checking.

Common:
PHP Code:
1    43000    ITEM_MALL_BOOK_01    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_BOOK_01    SN_ITEM_MALL_BOOK_01_TT_DESC    1    0    3    3    3    1    180000    3    2    1    1    1    3    0    1    0    0    129    0    100    0    0    0    0    0    1    130    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\coupon_char_book_01.ddj    xxx    xxx    23100 
PHP Code:
1    15    PACKAGE_ITEM_MALL_BOOK_01    2    0    100    -1    xxx    -1    xxx    -1    xxx    -1    xxx 
03/11/2015 16:56 blapanda#4
Quote:
Originally Posted by SnowStorm1 View Post
If you know what you're doing then why bother asking here?
Scripting a 500-line PHP-Code is something different than Hardcoded issues.

As smart as you always act, you should be able to comprehend this, right?
03/11/2015 18:27 Aaron*#5
Quote:
Originally Posted by blapanda View Post
As I said, I know what I am doing. Most of the people asking here for nonesense stuff and are not even able to PHP script a part of new column addition to the _AddNewXYZ SPs for better exploit/abuse checking.

Common:
PHP Code:
1    43000    ITEM_MALL_BOOK_01    ???? ???? ??? (???)    xxx    SN_ITEM_MALL_BOOK_01    SN_ITEM_MALL_BOOK_01_TT_DESC    1    0    3    3    3    1    180000    3    2    1    1    1    3    0    1    0    0    129    0    100    0    0    0    0    0    1    130    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    item\etc\coupon_char_book_01.ddj    xxx    xxx    23100 
PHP Code:
1    15    PACKAGE_ITEM_MALL_BOOK_01    2    0    100    -1    xxx    -1    xxx    -1    xxx    -1    xxx 
btw _refobjcommon price column is not necessary to be 100, set it to 0 in db and media and try [i'm not sure if it's going to work or not but just try]
03/12/2015 10:41 blapanda#6
Quote:
Originally Posted by Aeron* View Post
btw _refobjcommon price column is not necessary to be 100, set it to 0 in db and media and try [i'm not sure if it's going to work or not but just try]
Tried it, but the same result. The price keeps being stuck at 0 Silk but the real subtraction is correct.
03/13/2015 03:10 Aaron*#7
Quote:
Originally Posted by blapanda View Post
Tried it, but the same result. The price keeps being stuck at 0 Silk but the real subtraction is correct.
Well, just to make sure the item itself is not bugged, go to a test server(incase your server is live and opened to all) and change _refscrapofpackageitem.RefitemCodename of any item to your item codename(dont forget to edit durability incase your item is an equipment), also _refpricepolicyofitem cost - paymentdevice , if it worked, then copy the working lines & put them at your server, don't forget to edit the icon ofc.
if not, try adding any working item into any npc (those ones which are already added and working), just change PACKAGE_ITEM to BLABLA_ITEM, it should work ofc(if it didn't work then your db is cursed [lol]) if it worked just copy the lines & edit the icon - price - refitemcodename., I am pretty sure there is nothing like limit for npc items in SRO. [I am not really sure if my solution should work, but i prefer trying to do everything when i have a problem rather than asking someone first. at least i'm gonna learn how to solve it if i succeeded.]
03/13/2015 07:12 WickedNite.#8
There is no such thing as a limit of existing items, however there is a possiblity that the item is added 2 times(I know it's unlikely, but double checking that is what you can do).There is only a "limit" of how many items you can have in item mall for example, if there are too many your client will most likely crash when you purchase anything.
03/13/2015 12:28 blapanda#9
Adding items, which I did add few months ago, will be shown as "0 Silk price" as well.
Those are the same lines, just the ID obviously has been modified.

And yes, it is unlikely that those are cloned/double inputs. I always do check my tables about the unique state.

I guess its something related to the between the client and server communication, dunno.
It is just weird. If I just could get some clean vsro 193 files, I wouldn't even dare about this issue. lol
03/13/2015 13:39 WickedNite.#10
Quote:
Originally Posted by blapanda View Post
Adding items, which I did add few months ago, will be shown as "0 Silk price" as well.
Those are the same lines, just the ID obviously has been modified.

And yes, it is unlikely that those are cloned/double inputs. I always do check my tables about the unique state.

I guess its something related to the between the client and server communication, dunno.
It is just weird. If I just could get some clean vsro 193 files, I wouldn't even dare about this issue. lol
Taiwan are better than 193 vsro.
03/13/2015 15:35 blapanda#11
Quote:
Originally Posted by TheWickedNite View Post
Taiwan are better than 193 vsro.
I am always hearing that ... would you be so kindly and explain me whats special on those files?
Whats the UI (e.g. double floating hotbar, fellow pets are working fully, etc.)?
How is the scripting of new stuff?
Is it stable?
Are there any offsets available yet? Or is there any kind of tutorial debugging and locating the offsets?
03/13/2015 18:42 WickedNite.#12
Quote:
Originally Posted by blapanda View Post
I am always hearing that ... would you be so kindly and explain me whats special on those files?
Whats the UI (e.g. double floating hotbar, fellow pets are working fully, etc.)?
How is the scripting of new stuff?
Is it stable?
Are there any offsets available yet? Or is there any kind of tutorial debugging and locating the offsets?
Everything that isro had up until d12 items came out, just like 193 vsro, without fellow pets.Except that they are more stable.
03/13/2015 18:49 Royalblade*#13
Change the SlotIndex. Check if the problem persists. If it does, then the lines at client are wrong.

If its fixed and the "new" items at the "bottom" are visually wrong, then its an actual bug.

Case#1: Fix the lines.
Case#2: Create a new ItemMall tab and put some items in there instead.

Both cases: Problem is fixed.

If you really know what ur doing, u should be able to do this without even asking here.

If in any case, this has been discussed or tried, too bad. I'm not reading the other pages.
03/13/2015 20:04 blapanda#14
Quote:
Originally Posted by Royalblade* View Post
Change the SlotIndex. Check if the problem persists. If it does, then the lines at client are wrong.

If its fixed and the "new" items at the "bottom" are visually wrong, then its an actual bug.

Case#1: Fix the lines.
Case#2: Create a new ItemMall tab and put some items in there instead.

Both cases: Problem is fixed.

If you really know what ur doing, u should be able to do this without even asking here.

If in any case, this has been discussed or tried, too bad. I'm not reading the other pages.
To get this straight, I wouldn't ask in forums, if I have had fixed this issue already.

The lines are correct, they are on a standalone category (shop header and tab), the slotindex has nothing to do with the price. I tried it on a different preexisting tab. This issue still presists.

I do have a template, which I do add my items to the shops already over a year, nothing happened to cause a problem, only these 2 last items (which are an upgraded version of other items of mine, which do work as they should) and the following new additions are bugging with 0 Silk Price as well.
03/13/2015 22:20 ​Exo#15
Did you try to remove those 2 items and add another 2, so we can define if it's just a number issue or something is wrong with the item itself.