Disable Sun Drop

xaladim · 04/16/2015, 20:38

Hello epvpers, i need disable sun drops in my server, how to do ?
I want to be just by coin, thanks.

raptter · 04/17/2015, 01:30

+1

Apollo* · 04/18/2015, 01:53

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%'

xaladim · 04/19/2015, 23:51

man, dont work

raptter · 04/20/2015, 02:21

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