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

Quote:

---

Originally Posted by ahmedothman

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

---

Use New Query and Write this

Quote:

---

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

---

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

Quote:

---

Originally Posted by thebigbody

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

Grr
arabianfox already made this one stop spam theards

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

Quote:

---

Originally Posted by hellspawn80

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

---

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

Quote:

---

Originally Posted by xxNukertube

LOLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
HAHAHAH
I BEAT YOUU

SEE MY QUERY

I DONT COPY AND PAST NEWBIE

PHP Code:

---

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! :(

Quote:

---

Originally Posted by hellspawn80

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.

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