Fast Query to Add Drops in Mob , Unique bla bla bla ^^

[MaDenGo]

ok how i can Delete an item like a weapon ??

Use New Query and Write this

delete from _RefMonster_AssignedItemDrop
where RefItemID = Here ITEM ID you want to delet from Mob

[thebigbody]

lol this query not work although it added to table but nothing drop drop mobs G.L

[MaDenGo]

lol this query not work although it added to table but nothing drop drop mobs G.L

Bro this Query 100% Work i tested it 10000Times :) and alot of members told me that 100% work

[paltalkadel]

Grr
arabianfox already made this one stop spam theards

[hellspawn80]

need to edit client side too ? (media.pk2)

[Blacksheep25]

need to edit client side too ? (media.pk2)

no you don't, also this thread is nearly 4yrs old..

[hellspawn80]

LOLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
HAHAHAH
I BEAT YOUU

SEE MY QUERY

I DONT COPY AND PAST NEWBIE

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE [MENTION=292404]MOB[/MENTION] VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET [MENTION=292404]MOB[/MENTION]            =    'MOB_SD_ANUBIS'/*Monster Code*/
SET @Item            =    'ITEM_EVENT_GLOBAL_CHATTING'/*Item Code*/
SET @DropAmountMin    =    1 /*Drop Min*/
SET @DropAmountMax    =    2 /*Drop Max*/
SET @DropRatio        =    0.5 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID    =    (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = [MENTION=292404]MOB[/MENTION])/**/
SET @ItemID        =    (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3,RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@DropAmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/ 

how can i use it to add 1 item in many mob in same time ?

i tried
SET @MOB = '%MOB_NPC_THIEF%'/*Monster Code*/

but it didnt work. im poor! :(

[blapanda]

how can i use it to add 1 item in many mob in same time ?

i tried
SET @MOB = '%MOB_NPC_THIEF%'/*Monster Code*/

but it didnt work. im poor! :(

You cannot use a "LIKE" statement for a queue process, if you have no clue what this query does generally.
Simplified: You cannot say "add to mobs like XYZ" with this raw and simple query and await any good results.

You have an option to do so, adding a single item to 100 or more mobs at the same time, it is possible while using the "PIVOT" statement.
Learn it. It will become handy, not just for adding items.

[ThomasF2007]

Hello. i Problem with Medusa. Medusa spawn is ok, ar not drop in Medusa :( can help me?