How does sun drop rates are really work in vSRO?

RedWoman · 04/08/2016, 15:45

Hello everyone,
it's a long time that I'm looking for an answer for problem I have,
I'll be very happy if someone will help me to fix it,
so here is the problem: How does sun drop rates are really work in vSRO?
My server is cap 100, and I want to set sun from mobs, there is only one problem with it, players don't receive sun drops!
Here is what I did: I have changed PobGroup30 values in the table _RefDropClassSel_RareEquip, no matter what I'll write there, the players won't get sun drop from mobs, I wrote there in one of the times 23435936 because someone told me that it's 100% but the players still didn't get any sun drop,
in another time I wrote there 999999999, and still nothing!
No matter what I wrote there, 20,0.99,99999999,23435936,22.50,50 still nothing!!!!
I have changed the PobGroup30 values where MonLevel was 90 to 100,
Every time I changed the PobGroup30 values, I have also made sure that Service = 1 at the table _RefObjCommon where codename128 like 'item_%_10%c_%rare', and Service = 1 also in the table _RefDropItemAssign where codename128 like 'item_%_10%c_%rare'.
So after I saw that everything isn't help, I changed rarity from 2 to 3 by the next query:

PHP Code:



update _RefObjCommon set Rarity = 3 where codename128 like 'item_%_10%c_%rare' and Service =1

After I done with this query, and made restart, the sun drop rate was too high, players got sun drop every 5 minute!
Well I was happy, because finally they got sun drops and now I can play with the rates at the table _RefDropClassSel_RareEquip, so here we go again:
No matter what I wrote in the PobGroup30 values,
0.99,5,0.25,0.001,0.000000303,
the players still got sun drop every 5 minutes, I have changed the PobGroup30 values where MonLevel was 90 to 100, same like the last time I changed those values.
So what the hell is going on here???
Someone wants to give me an explain to how it works?
I'll be very happy to get an answer, because I tried EVERYTHING and it doesn't work, I lost

I really appreciate your help, thanks in advance .

Judgelemental · 04/08/2016, 17:12

Have you tried " set Rarity = 2 " ?

WickedNite. · 04/08/2016, 18:06

D10 sun items are on probgroup30, 31 are Nova items.The way it works is sos = probgroup1, som = probgroup2, sun = probgroup3, that's for d1 items, then you calculate for each degree which column u have to edit.

Syloxx · 04/08/2016, 20:22

_RefDropClassSel_RareEquip

1 = 100%
0 = 0%

ProbX = ItemClass in _RefObjItem

but you are right, its kinda "bugged" i didn't discovered how Joymax calculate it yet

Exo · 04/08/2016, 21:07

Quote:

Originally Posted by Syloxx

_RefDropClassSel_RareEquip

1 = 100%
0 = 0%

ProbX = ItemClass in _RefObjItem

but you are right, its kinda "bugged" i didn't discovered how Joymax calculate it yet

Ye kind of, I reached a point I even doubted that table is used. One of the weirdest stuff in the database tho.

Syloxx · 04/08/2016, 21:11

1st of all the table is selected by the gameserver on start.
2nd if you set everything to 1 then you can even drop level 1 sun items on level 120 jupiter monsters so yes, somehow the table effects the drop rate

Judgelemental · 04/08/2016, 21:38

How about manually make the monster drop a specific sun item and set that probability to low ?
It's going to take a while though

RedWoman · 04/09/2016, 02:44

Quote:

Originally Posted by Judgelemental

Have you tried " set Rarity = 2 " ?

As I said at the thread - " I changed rarity from 2 to 3 by the next query: ".
Yes

Quote:

Originally Posted by WickedNite.

D10 sun items are on probgroup30, 31 are Nova items.The way it works is sos = probgroup1, som = probgroup2, sun = probgroup3, that's for d1 items, then you calculate for each degree which column u have to edit.

Yes, you are right, I made a mistake at the thread and I wrote 31, I changed the PobGroup30 values... I edited the thread, thank you for paying attention, but the problem still not resolved

Quote:

Originally Posted by Syloxx

_RefDropClassSel_RareEquip

1 = 100%
0 = 0%

ProbX = ItemClass in _RefObjItem

but you are right, its kinda "bugged" i didn't discovered how Joymax calculate it yet

What do you mean by typing the row I made big?
Can you explain it better please?

Quote:

Originally Posted by Judgelemental

How about manually make the monster drop a specific sun item and set that probability to low ?
It's going to take a while though

Well, how can I do that?
What tables I should edit?
There is any query that can help me to do it faster?, Please explain me how it works.

Thanks everyone for help, The problem is still not resolved!

Judgelemental · 04/09/2016, 07:09

Quote:

Originally Posted by NanoKid

Well, how can I do that?
What tables I should edit?
There is any query that can help me to do it faster?, Please explain me how it works.

Hello.

Syloxx · 04/09/2016, 11:15

Quote:

Originally Posted by NanoKid

What do you mean by typing the row I made big?
Can you explain it better please?

well in the table you have ProbGroup 1 - 36 if i remember well
1 = SOS D1
2 = SOM D1
3 = SUN D1

4 = SOS D2
5 = SOM D2
6 = SUN D2

etc...

RedWoman · 04/09/2016, 15:03

Quote:

Originally Posted by Judgelemental

Hello.

Thank you, I hope it will help.
Do you have an idea for what is the normal rate?
Normal for me it's about one sun drop to every player in the server every day.

Quote:

Originally Posted by Syloxx

well in the table you have ProbGroup 1 - 36 if i remember well
1 = SOS D1
2 = SOM D1
3 = SUN D1

4 = SOS D2
5 = SOM D2
6 = SUN D2

etc...

Ah that's POBGROUP, not Prob.

Judgelemental · 04/09/2016, 15:14

Quote:

Originally Posted by NanoKid

Thank you, I hope it will help.
Do you have an idea for what is the normal rate?
Normal for me it's about one sun drop to every player in the server every day.

Hello !
You're welcome.

I think 0.1 or 0.01 if I recall...I'm not sure !
You should try on a testserver. I remember I could make the rate so the drop would drop in a day or two but that was long time ago