Eu Drop

[ILowe]

hello

Eu Drop closed where ?

[Veteran1337]

delete _RefDropItemAssign
from _RefDropItemAssign Drops
left join _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_EU_%_%_%'

[ILowe]

thx....

error ?

[ILowe]

Originally Posted by ILowe

thx....

error ?

helpp

[ᶽPhoenix1337ᶽ]

Re-download it again / Re-extract from your own backup .. Maybe you've got c++ virus or at least you did removed c++ runtime library .

[ILowe]

Is there an error in this ?

eu drop remove

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

[TychusFindlay]

I know this is pretty old but what if I do

update _RefObjCommon set CanDrop = 0
WHERE CodeName128 like '%ITEM_EU_%_%_%'

to disable EU related drops. I used the other method to drop probabilities to %0 but it caused no drops . I have queried if I set them all to %0 by mistake but that wasn't the case. So I wonder if that would work after all to disable EU drops in VSRO 11d db.

Best
Tychus

[A new hope]

delete from _refdropitemassign where refitemid in ( select id from _refobjcommon where codename128 like 'item_eu%' )

[TychusFindlay]

Originally Posted by A new hope

delete from _refdropitemassign where refitemid in ( select id from _refobjcommon where codename128 like 'item_eu%' )

Interesting, if I do this then everytime I kill a mob I get DC. I rollback and I don't have issues. I can pretty much understand why you have written such transact command but it is bugging my db for some reason. I am looking for alternatives like not deleting but modifying stuff. But thanks for the reply anyways.