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

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