REMOV ITEM MOBS possible bug_

[Tripple2]

guys i remov item drop coin gold coin silver copper and i kill isis drop again xd
idk why

[HECKT00R]

bcz job uniques have special treatment since they have there special drop tables
here you go
1- check _RefMonster_AssignedItemDrop table how it works
at refmonsterid column > search for id of isis / anubis aka the unique you need how ? use the query below

 Spoiler

select id from _refobjcommon where codename128 = 'your unique code name'

so you have the id of each unique now

2- search at _RefMonster_AssignedItemDrop with refmonsterid
and if you want to completely remove the drops you have 2 ways
i- put drop ratio =0
ii- set service =0

p.s : while going to disable or change the drop rate make sure that the itemgroupcodename128 column like 'ITEM_SD_TOKEN%_DROPGROUP'

Regards !

[Tripple2]

Originally Posted by HECKT00R

bcz job uniques have special treatment since they have there special drop tables
here you go
1- check _RefMonster_AssignedItemDrop table how it works
at refmonsterid column > search for id of isis / anubis aka the unique you need how ? use the query below

 Spoiler

select id from _refobjcommon where codename128 = 'your unique code name'

so you have the id of each unique now

2- search at _RefMonster_AssignedItemDrop with refmonsterid
and if you want to completely remove the drops you have 2 ways
i- put drop ratio =0
ii- set service =0

p.s : while going to disable or change the drop rate make sure that the itemgroupcodename128 column like 'ITEM_SD_TOKEN%_DROPGROUP'

Regards !

tested and work perfect ty bro

Oly no work with drop tablet 9d

[HECKT00R]

you welcome
p.s:thers a button called thanks .

[ZαKuRα]

Disable Stone

Use
SRO_VT_SHARD

update _RefDropClassSel_Alchemy_ATTRStone set ProbGroup1 = '0' , ProbGroup2 = '0' , ProbGroup3 = '0' , ProbGroup4 = '0' ,
ProbGroup5 = '0' , ProbGroup6 = '0' , ProbGroup7 = '0' , ProbGroup8 = '0' , ProbGroup9
= '0' , ProbGroup10 = '0' , ProbGroup11 = '0' , ProbGroup1 = '0' , ProbGroup12 = '0'

Disable Tablet

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

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

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

[Tripple2]

Originally Posted by ZαKuRα

Disable Stone


Disable Tablet

working ty bro

resolved

[Spidy.]

#Solved