Query to remove drop !!

[Dracula Untold]

i have used this query

USE SRO_VT_SHARD
DELETE _RefDropItemAssign
FROM _RefDropItemAssign Drops
LEFT join _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like '%ITEM_CH_%_10_%'


To remove 10 full DG from drop ..
but this one it removes only the normal items ..

can someone fix it to remove Sox as well ? or to create a query ?

Thanks in advance

[Midnight ™]

You can setup the sox droprate in the table [dbo].[_RefDropClassSel_RareEquip]

[Dracula Untold]

not to set it up ...
i need full removed all sox drop 10 DG ... u know to make a query?

or removed from all drop unique ...
because on my server all unique drop 10 DG sox

[Midnight ™]

Ok here you are

 Spoiler

USE SRO_VT_SHARD

UPDATE _RefDropClassSel_RareEquip SET ProbGroup28 = 0
UPDATE _RefDropClassSel_RareEquip SET ProbGroup29 = 0
UPDATE _RefDropClassSel_RareEquip SET ProbGroup30 = 0

[TakeshiVongola]

Also, if you want to still use your query, you could change the line:
WHERE CodeName128 like '%ITEM_CH_%_10_%'
to have it delete the RARE items.

[WickedNite.]

Originally Posted by TakeshiVongola

Also, if you want to still use your query, you could change the line:
WHERE CodeName128 like '%ITEM_CH_%_10_%'
to have it delete the RARE items.

That's if his tiny brain understands where to use '%'.

[Dracula Untold]

delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%')

Fixed by my self.

[Pavo xD]

ty bro

[BadSorrow]

Originally Posted by SensationSro

delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%')

Fixed by my self.

Thanks you for this query.

This query delete all sox ? or only Seal Of Sun / Moon / Star ?

I wait your answer.

[spinal2]

Originally Posted by BadSorrow

Thanks you for this query.

This query delete all sox ? or only Seal Of Sun / Moon / Star ?

I wait your answer.

delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%')

Its for all SOX and all Normals 10D itens .. and ALots of others Scrools Used _10_ in name like 'ITEM_MALL_RESURRECTION_100P_SCROLL' or 'ITEM_MALL_MP_INC_4100_POTION'



For a Sox type he need put a class Like ' A= Star . B = Moon , C = Sun'

EXemple

FOR WEAPONS SUNS and ACCESSORY

delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%_C_%')


FOR SETS SUNS


delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%_C_%')

[hysteria34]

Originally Posted by spinal2

delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%')

Its for all SOX and all Normals 10D itens .. and ALots of others Scrools Used _10_ in name like 'ITEM_MALL_RESURRECTION_100P_SCROLL' or 'ITEM_MALL_MP_INC_4100_POTION'



For a Sox type he need put a class Like ' A= Star . B = Moon , C = Sun'

EXemple

FOR WEAPONS SUNS and ACCESSORY

delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%_C_%')


FOR SETS SUNS


delete from _RefDropItemAssign where RefItemID in (select ID from _RefObjCommon where codename128 like '%item%_10_%_C_%')

And only for WEAPON => SUN => D8 ?

Thanks you for your answer.. I wait it :/

[Apollo*]

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

[omG86]

Apollo* Thanks for the idea

Remove all Tablets Magic, Attribute, Sapphire and Alchemy Materials

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

UPDATE _RefMonster_AssignedItemDrop
SET DropRatio=0
FROM
    _RefMonster_AssignedItemDrop Drops
    JOIN
    _RefObjCommon Obj ON Drops.RefItemID = Obj.ID
WHERE
Obj.CodeName128 like '%ITEM_ETC_ARCHEMY_MATERIAL_%'

[mtnman33]

omg..............simplest way ....lol

use SRO_VT_SHARD
update _RefObjCommon set CanDrop = 0 where CodeName128 like '%item name%'