[VSRO] (URGENT) Nova Drops

03/26/2021 23:03 amrsmooth#1
Hello, recently I had an issue with nova drop rates, I tried to change server drop rates but it didn't work
I've also tried this Query but ofc it got C++ error with game server
Quote:
USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'
I've tried also this: [Only registered and activated users can see links. Click Here To Register...]

Still didn't work, All I want is a decent drop rate like 1 or 2 Nova in 30mins or at least a way to make me able to control it from mobs level 104~110

That's my RareEqu table (Also item rarity is 2 when I used first query it sets it to 3 but game server crashes):
[Only registered and activated users can see links. Click Here To Register...]

Another question is about Chin Mastery, been trying to balance it to give Chin race a total of 440 mastery in a D11 Cap 110 server, used OLLYDBG on my sro_client and change it:
006A51BC BF 77010000 MOV EDI,168 to MOV EDI,1B8

Also used this to patch my GameServer:
[Only registered and activated users can see links. Click Here To Register...]

There result is 360/440 but still max is 360 but its 440 as shown:
[Only registered and activated users can see links. Click Here To Register...]

Help will be really appreciated, thank you so much in advance.
Regards!
03/27/2021 00:11 Beba Army#2
About drop u must increase in server.cfg also.
03/27/2021 00:38 amrsmooth#3
Quote:
Originally Posted by Beba Army View Post
About drop u must increase in server.cfg also.
I did increase it but same problem sadly.
03/27/2021 04:37 Beba Army#4
Quote:
Originally Posted by amrsmooth View Post
I did increase it but same problem sadly.
Try this gs
03/27/2021 04:37 Mc-Diesel#5
Create Custom Drop Groups for items
03/27/2021 10:46 sonniboy#6
As I recall, the value you see in the rare item table is divided by 100 by the gameserver to give you the actual drop rate. You can can edit this hardcoded division value in the gameserver if you find the adress. For vsro files, it was posted my megamax how to do it.
03/27/2021 16:31 amrsmooth#7
Quote:
Originally Posted by Beba Army View Post
Try this gs
I will try it and tell you tonight, this is for the Mastery Level right?

Quote:
Originally Posted by Mc-Diesel View Post
Create Custom Drop Groups for items
Can you please explain more? you mean I should create new table call it "_RefDropClassSel_RareEquip" and add 31 Columns and name them "MonLevel, ProbGroup1, ProbGroup2 etc... ~ ProbGroup31"

and then adding my own values?

Quote:
Originally Posted by sonniboy View Post
As I recall, the value you see in the rare item table is divided by 100 by the gameserver to give you the actual drop rate. You can can edit this hardcoded division value in the gameserver if you find the adress. For vsro files, it was posted my megamax how to do it.
So if I did understand you correctly you mean for example if I set value "50" of the rare drop rate from mobs 104~110 in ProbGroup31 it basically means 50 / 100 x 4
as:
50 = value in _RefDropClassSel_RareEquip
100 = gameserver default dividing thingy
4 = server.cfg (my current settings of the server.cfg droprate)
03/28/2021 21:45 amrsmooth#8
Quote:
Originally Posted by Beba Army View Post
Try this gs
Tried this gameserver but it didn't work as well :/ any other solutions?

Quote:
Originally Posted by sonniboy View Post
As I recall, the value you see in the rare item table is divided by 100 by the gameserver to give you the actual drop rate. You can can edit this hardcoded division value in the gameserver if you find the adress. For vsro files, it was posted my megamax how to do it.
I tried every single number (+restarting gameserver after changing the values to take effect) nothing worked so far!

Then I tried this query again:
Quote:
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'
It didn't give me errors at some point but nova drop rate was insane like 10x piece per 5mins which is too much (also I've changed the values in the tables but nothing worked to control that drop ratio so I reversed the rarity back to 2 instead of 3
so basically it's either way too much drop rate or no drop rate at all.

Quote:
Originally Posted by Mc-Diesel View Post
Create Custom Drop Groups for items
got no luck with that also I was thinking about it but new group means a new group other than the probgroup31 (which is the nova group) if i did create new one higher other than that group wouldn't it give me anything as the nova is only linked to group31?

--------concern mastery points----------
I'm using Sr_GameServer, I've used 2 patches so far also tried to do it manually both sides sro_client as well as Sr_GameServer as well as original GameServer
Here are the values:
1. Mastery sro_client.exe side: as 1B8 = 440 (mastery points)
CH-- 0x006AA4C3
CH-- 0x006A51BC

2. Mastery GameServer side: as 1B8 = 440 (mastery poins)
CH--- 0059C5E6

Still no luck with that either, any other solutions? help will be much appreciated
03/28/2021 22:21 Mc-Diesel#9
Quote:
Originally Posted by amrsmooth View Post
Tried this gameserver but it didn't work as well :/ any other solutions?



I tried every single number (+restarting gameserver after changing the values to take effect) nothing worked so far!

Then I tried this query again:


It didn't give me errors at some point but nova drop rate was insane like 10x piece per 5mins which is too much (also I've changed the values in the tables but nothing worked to control that drop ratio so I reversed the rarity back to 2 instead of 3
so basically it's either way too much drop rate or no drop rate at all.



got no luck with that also I was thinking about it but new group means a new group other than the probgroup31 (which is the nova group) if i did create new one higher other than that group wouldn't it give me anything as the nova is only linked to group31?

--------concern mastery points----------
I'm using Sr_GameServer, I've used 2 patches so far also tried to do it manually both sides sro_client as well as Sr_GameServer as well as original GameServer
Here are the values:
1. Mastery sro_client.exe side: as 1B8 = 440 (mastery points)
CH-- 0x006AA4C3
CH-- 0x006A51BC

2. Mastery GameServer side: as 1B8 = 440 (mastery poins)
CH--- 0059C5E6

Still no luck with that either, any other solutions? help will be much appreciated
using groups mean diffrent table .. RefDropItemGroup , RefMonster it gonna work 1000% no Way xD
03/30/2021 02:30 amrsmooth#10
Quote:
Originally Posted by Mc-Diesel View Post
using groups mean diffrent table .. RefDropItemGroup , RefMonster it gonna work 1000% no Way xD
Ohh, I see now... Thank you so much.
09/28/2021 02:50 eyder2#11
I manage to change the rate of the drops I need to know how to place the nova so that it is not so easy or so difficult
09/30/2021 12:43 JohnDornel^#12
It's pretty easy.

Create a group using the previous ones as example in _RefDropItemGroup, which will contain all NOVA items, RefItemID is the ID of the item/s you need from _RefObjCommon.

You can use INSERT INTO + SELECT statement to do it all at once.

Then you go to _RefMonster_AssignedItemRndDrop and create rows for each mob that you want to drop the newly created item group. For multiple mobs you can use and insert + select statement again. RefMonsterID = ID from _RefObjCommon of the monsters you want. For both tables you can use the existing data to figure out what each column does.

Good luck.