[Request] Vsro disable/remove all EU drops

10/11/2016 10:46 vietnguyen09#1
Hi guys,

I've been working since last week tried to disable/remove all EU drops but failed all the time.
I've been following various released topics, but it never works.

I've worked on _RefDropItemAssign tried to delete all EU stuff records, it fine when I removed the
EU equipment and EU Weapons from D1 -> D8 but SR_GameServer.exe (GS) crashed runtime error when
I removed D9, D10, D12 and I don't know why. I've tried to set Service = 0 and GS still crashing.
After all, I tried to set DropCount = 0 in _RefDropItemAssign but EU stuff still dropping all the time, F**K

The one thing I don't understand here that, some stuff does not exist on _RefMonster_AssignedItemDrop
But it still drops, why? Does GS have it own DropRatio for everything if they do not exist in the database?

I believe I've read all topics which are related to "VSRO disable EU drop" but the way of success
still missing, please help me.

Best regards

Help

Please help,

I've changed ItemClass in _RefObjectItem for all EU equipment -> not work
I've changed Rarity to 7 in _RefObjectCommon for all EU stuff -> not work

It's fucking crazy in my mind
12/18/2016 21:21 hallohupi#2
Hey,

i changed it for the most items today too(it worked for normal and sox drops till now). Just replace the field country in _RefObjCommon with the right value (CH = 0, EU = 1, Both = 3).

Here the SQL i used (to disable all EU drops/change them to CH drops from Hotan Area to the end):

update dbo._RefObjCommon set dbo._RefObjCommon.Country = '0' where dbo._RefObjCommon.Country = '3' AND dbo._RefObjCommon.CodeName128 like '%MOB%'

to disable all EU drops/change to CH drops you can use this SQL:
update dbo._RefObjCommon set dbo._RefObjCommon.Country = '0' where dbo._RefObjCommon.CodeName128 like '%MOB%'


Best Regards
12/28/2016 08:51 Lanvin*#3
Here is the query:

PHP Code:
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 10897 AND 11416


UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 10897 AND 11416



UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 10897 AND 11416