[How to]Deactivate EU Drops

12/21/2012 12:48 luuk#1
Hey guys,

i want to deactivate eu drops around hotan taklamakan and roc mountain.
is there any possebile way to do that ?

I tried to delete all eu items. but then gameserver is crashing =)

ty
12/21/2012 12:56 xXMagicalXx#2
Try this one, its made by Hean: ( Do a backup before, i didnt test it)
Quote:
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
12/21/2012 13:36 luuk#3
hey thanks.. this is deactivate query for eu items correct ?

cause i saw one like this for alchemy material

okay, i backupped and the query works .. =)

thank you .. i will test the dopping items