How does sun drop rates are really work in vSRO?

04/08/2016 15:45 RedWoman#1
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 =
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 :D.

04/08/2016 17:12 Judgelemental#2
Have you tried " set Rarity = 2 " ?
04/08/2016 18:06 WickedNite.#3
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.
04/08/2016 20:22 Syloxx#4
_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
04/08/2016 21:07 ​Exo#5
Quote:
Originally Posted by Syloxx View Post
_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.
04/08/2016 21:11 Syloxx#6
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
04/08/2016 21:38 Judgelemental#7
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
04/09/2016 02:44 RedWoman#8
Quote:
Originally Posted by Judgelemental View Post
Have you tried " set Rarity = 2 " ?
As I said at the thread - " I changed rarity from 2 to 3 by the next query: ".
Yes :D

Quote:
Originally Posted by WickedNite. View Post
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 View Post
_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 View Post
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!
04/09/2016 07:09 Judgelemental#9
Quote:
Originally Posted by NanoKid View Post
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.
[Only registered and activated users can see links. Click Here To Register...]
04/09/2016 11:15 Syloxx#10
Quote:
Originally Posted by NanoKid View Post
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...
04/09/2016 15:03 RedWoman#11
Quote:
Originally Posted by Judgelemental View Post
Hello.
[Only registered and activated users can see links. Click Here To Register...]
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 View Post
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.
04/09/2016 15:14 Judgelemental#12
Quote:
Originally Posted by NanoKid View Post
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