Disable Sun Drop

04/16/2015 20:38 xaladim#1
Hello epvpers, i need disable sun drops in my server, how to do ?
I want to be just by coin, thanks.
04/17/2015 01:30 raptter#2
+1
04/18/2015 01:53 Apollo*#3
Code:
UPDATE _RefDropItemAssign
SET Prob_Relative=0,Prob_Absolute=0
FROM
    _RefDropItemAssign Drops
    JOIN
    _RefObjCommon Obj ON Drops.RefItemID = Obj.ID
WHERE
Obj.CodeName128 like '%ITEM_%_%_10_C_RARE%'
04/19/2015 23:51 xaladim#4
man, dont work

[Only registered and activated users can see links. Click Here To Register...]
04/20/2015 02:21 raptter#5
Hint _RefDropClassSel_RareEquip there's column called MonLevel this is the monsters levels for example ( monlevel1 prbGroup1 = 14.999 ,probgroup2 = 14.999 , probgroup 3 = 14.999 ) probgroup1 mean sos probgroup 2 mean moon probgroup3 mean sun
if u wanna disable D 10 sun for example u just get monleve from level 90 to 100 and make probgroup3 = 0 to disable the sun only

btw sorry for my very bad english hope i could help u