Query to remove drop !!

11/21/2015 18:10 Dracula Untold#1

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

11/21/2015 20:39 Midnight �#2

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

11/22/2015 08:05 Dracula Untold#3

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

11/22/2015 18:34 Midnight �#4

Ok here you are

Spoiler

11/23/2015 13:32 TakeshiVongola#5

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.

11/23/2015 14:26 WickedNite.#6

Quote:

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

11/23/2015 14:49 Dracula Untold#7

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

Fixed by my self.

12/12/2015 14:26 Pavo xD#8

ty bro

12/13/2015 12:58 BadSorrow#9

Quote:

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.

12/14/2015 02:51 spinal2#10

Quote:

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.

Code:

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

12/29/2015 09:05 hysteria34#11

Quote:
Originally Posted by spinal2
Code:
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 :/

01/01/2016 11:45 Apollo*#12

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

05/22/2016 15:50 omG86#13

Apollo* Thanks for the idea :)

Remove all Tablets Magic, Attribute, Sapphire and Alchemy Materials

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

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

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

Code:

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

05/22/2016 18:31 mtnman33#14

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

Quote:

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