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

xxNukertube said:

LOLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
HAHAHAH
I BEAT YOUU

SEE MY QUERY

I DONT COPY AND PAST NEWBIE

PHP:

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')/**/

Click to expand...

hellspawn80 said:

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!

Click to expand...