REMOV ITEM MOBS possible bug_

08/10/2017 00:49 Tripple2#1

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

08/10/2017 10:57 HECKT00R#2

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

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 !

08/10/2017 15:58 Tripple2#3

Quote:

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

08/10/2017 20:32 HECKT00R#4

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

08/11/2017 00:11 ZαKuRα#5

Disable Stone

Quote:

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

Quote:

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

Quote:

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

Quote:

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

08/11/2017 08:55 Tripple2#6

Quote:

Originally Posted by ZαKuRα

Disable Stone

Disable Tablet

working ty bro

resolved

08/12/2017 02:40 Spidy.#7

#Solved :)