Eu Drop

06/27/2012 01:06 ILowe#1

hello

Eu Drop closed where ?

06/27/2012 06:47 Veteran1337#2

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

06/27/2012 07:03 ILowe#3

thx....

error ?

[Only registered and activated users can see links. Click Here To Register...]

06/28/2012 23:22 ILowe#4

Quote:

Originally Posted by ILowe

thx....

error ?

[Only registered and activated users can see links. Click Here To Register...]

helpp

07/03/2012 11:08 ᶽPhoenix1337ᶽ#5

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 .

07/03/2012 11:44 ILowe#6

Is there an error in this ?

eu drop remove

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

03/06/2013 14:13 TychusFindlay#7

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

03/06/2013 14:46 A new hope#8

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

03/06/2013 15:43 TychusFindlay#9

Quote:

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.