Removing item drop.

TheRealHero · 01/01/2017, 14:59

Hello guys.

I have been facing a problem for days now and I just can\t solve it so I hope one of you can and will.

My problem is that, some monsters drop Arena and others Magic pop.

I have checked Assigneditemsdrop, and also the other tables which I dont fully understand yet.

Pls help me

~~madengo~~ · 01/01/2017, 15:48

Try this query

PHP Code:


			
delete _RefDropItemAssign
from _RefDropItemAssign Drops
left join _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID) 
WHERE CodeName128 like '%ITEM_CH_%_09_%'

PHP Code:


			
ITEM_MALL_GACHA_CARD
ITEM_ETC_ARENA_COIN

TheRealHero · 01/02/2017, 07:53

(0 row(s) affected)
(0 row(s) affected)

:/ any other suggestion?

saqr2003 · 01/02/2017, 11:37

PHP Code:


			
Use [SRO_VT_SHARD]

Declare [MENTION=614520]mob[/MENTION]CodeName128 Varchar(128) , [MENTION=1134588]item[/MENTION]CodeName128 Varchar(128)

Set [MENTION=614520]mob[/MENTION]CodeName128 = 'Write Monster CodeName128'

Set [MENTION=1134588]item[/MENTION]CodeName128 = 'Write Item CodeName128'

Delete From dbo._RefMonster_AssignedItemDrop

Where RefItemID = (Select ID From dbo._RefObjCommon Where CodeName128 = [MENTION=1134588]item[/MENTION]CodeName128)

and RefMonsterID = (Select ID From dbo._RefObjCommon Where CodeName128 = [MENTION=614520]mob[/MENTION]CodeName128);

Try this

~~madengo~~ · 01/02/2017, 13:57

Quote:

Originally Posted by TheRealHero

(0 row(s) affected)
(0 row(s) affected)

:/ any other suggestion?

PHP Code:


			
delete from _RefMonster_AssignedItemDrop where RefItemID = ' Arena & Magic pop card ID '

TheRealHero · 01/02/2017, 15:21

Guys I really appreciate you trying to help me.

I've tried some similar queries written by my own but they all end up giving no results.
Same as the one you posted.

Is it possible that these items aren't linked to AssignedItemDrop but some other table?
I'm pretty sure these items aren't to be found inside AssignedItemDrop since I've checked seveal times.

Any suggestions :/ ?

AssignedItemRndDrop
1 14937 12 ITEM_PIGGY_DROPGROUP 0 0 1 0.007 0 0

How does this table work??
I found that 14937 is the"Kokoru mob", which drop arena coin. IDK what this ITEM_PIGGY_DROPGROUP IS, how to modify it but can it somehow be linked together?

DID not work either hmm...

~~madengo~~ · 01/02/2017, 16:06

Quote:

Originally Posted by TheRealHero

Guys I really appreciate you trying to help me.

I've tried some similar queries written by my own but they all end up giving no results.
Same as the one you posted.

Is it possible that these items aren't linked to AssignedItemDrop but some other table?
I'm pretty sure these items aren't to be found inside AssignedItemDrop since I've checked seveal times.

Any suggestions :/ ?

AssignedItemRndDrop
1 14937 12 ITEM_PIGGY_DROPGROUP 0 0 1 0.007 0 0

How does this table work??
I found that 14937 is the"Kokoru mob", which drop arena coin. IDK what this ITEM_PIGGY_DROPGROUP IS, how to modify it but can it somehow be linked together?

DID not work either hmm...

Check this tables

PHP Code:


			
_RefDropItemAssign

_RefDropItemGroup

TheRealHero · 01/02/2017, 16:18

_RefDropItemAssign
_RefDropItemGroup Does not have 25834 in it "ID of arena coin."

~~madengo~~ · 01/02/2017, 16:28

i meant to search in those tables about [ ITEM_PIGGY_DROPGROUP ] you found because AssignedItemRndDrop is connected with _RefDropItemAssign
_RefDropItemGroup

Exo · 01/02/2017, 23:07

Quote:

Originally Posted by TheRealHero

Guys I really appreciate you trying to help me.

I've tried some similar queries written by my own but they all end up giving no results.
Same as the one you posted.

Is it possible that these items aren't linked to AssignedItemDrop but some other table?
I'm pretty sure these items aren't to be found inside AssignedItemDrop since I've checked seveal times.

Any suggestions :/ ?

AssignedItemRndDrop
1 14937 12 ITEM_PIGGY_DROPGROUP 0 0 1 0.007 0 0

How does this table work??
I found that 14937 is the"Kokoru mob", which drop arena coin. IDK what this ITEM_PIGGY_DROPGROUP IS, how to modify it but can it somehow be linked together?

DID not work either hmm...

_RefDropItemGroup has the Mob RefID as well as the group name || ID.
Check objcommon for 14937. If that's the targeted drop. I'm sorry for the vague information but I don't have access to a db rn.

TheRealHero · 01/03/2017, 02:42

Well it turns out it was inside _RefMonster_AssignedItemDrop

I have no idea how I could have missed it.

As I mentioned i checked both RefItemID and monster ID hmm well its solved Thx guys >P