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

[Blacksheep25]

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

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

 

[hellspawn80]

Re: [Realease] Fast Query to Add Drops in Mob , Unique bla bla bla ^^

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 [USER=292404]MOB[/USER] VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET [USER=292404]MOB[/USER]			=	'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 = [USER=292404]MOB[/USER])/**/
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]

Re: [Realease] Fast Query to Add Drops in Mob , Unique bla bla bla ^^

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?