Help me in add drop item on Uniques

[coolspace9]

Hello Everyone

like add drop weapon's on unique

Exp:Every time he is killed Drop a different weapon

%ITEM_CH_WEAPON% & %ITEM_EU_WEAPON%

i don't Like drop weapon One type at a time

Drop one weapon only different at a time.

[coolspace9]

Originally Posted by coolspace9

Hello Everyone

like add drop weapon's on unique

Exp:Every time he is killed Drop a different weapon

%ITEM_CH_WEAPON% & %ITEM_EU_WEAPON%

i don't Like drop weapon One type at a time

Drop one weapon only different at a time.

Up

[Emerald Garden SRO]

Originally Posted by coolspace9

Up

Emerald Garden ADMIN#5307 on discord and I will help you.

[coolspace9]

Up if AnyOne know

[Loyality_]

USE SRO_VT_SHARD
GO

DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real



SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50%
SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop


INSERT _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, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , '***')

To get mob ID use this Query

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'

Change MOB_RM_ROC With your Monster or Unique Code

To get ITEM ID use this Query

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE'

Change ITEM_CH_TBLADE_11_SET_A_RARE to Any item you want

Query by Syinea

[coolspace9]

Originally Posted by Loyality_

To get mob ID use this Query




Change MOB_RM_ROC With your Monster or Unique Code

To get ITEM ID use this Query


Change ITEM_CH_TBLADE_11_SET_A_RARE to Any item you want

Query by Syinea

what the Special in this Query?
this Query For add drop on Mob or Uniq
But you not understand my Request
how can make item's droped Different's
if me playing with char China and killed this mob like droped One Only Type Anyweapon Ch & Eu
Exp: Bow or Staff or Dagger or Glaive
if use this ur query will droped the weapon market located on query

[Skedaddle!]

Originally Posted by coolspace9

what the Special in this Query?
this Query For add drop on Mob or Uniq
But you not understand my Request
how can make item's droped Different's
if me playing with char China and killed this mob like droped One Only Type Anyweapon Ch & Eu
Exp: Bow or Staff or Dagger or Glaive
if use this ur query will droped the weapon market located on query

Check _RefDropItemGroup and _RefMonster_AssignedItemRndDrop, Those tables got exactly what you want.

[coolspace9]

Originally Posted by Skedaddle!

Check _RefDropItemGroup and _RefMonster_AssignedItemRndDrop, Those tables got exactly what you want.

perfect
Done
#

[Skedaddle!]

Originally Posted by coolspace9

perfect
Done
#

wow, you're the first one to understand my hints from the first time.