Add new Item Drop

[Hean]

Well, it's a small query I made times ago. I hope it will help anyone.
I hope anyone can understand how it works It shouldn't be that hard.

USE SRO_VT_SHARD_INIT
GO

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



SET @MonsterID = 24082 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 0.00004 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 3851 -- You can find Item ID's at RefObjCommon


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 ,           'xxx')

 

[rodzio2]

Re: [Release] Add new Item Drop

How drop ratio is calculated ? 0.00004 is high or low?

 

[Hean]

Re: [Release] Add new Item Drop

How drop ratio is calculated ? 0.00004 is high or low?

1 = 100% Drop Chance
0.5 = 50% Drop Chance
0 = 0%

Understand ?

 

[sladlejrhfpq]

Re: [Release] Add new Item Drop

thank you

 

[ahmed_ahmed9889]

Re: [Release] Add new Item Drop

thx alot

but what is

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 , 'xxx')

that mobs id or what?

 

[Paranoit]

Re: [Release] Add new Item Drop

and what is _RefDropItemAssign?

 

[ahmed_ahmed9889]

Re: [Release] Add new Item Drop

can u know why i cant open forgotten world?

i got the icon and on i right click on it i got

requires level is not reached for entering

the code of item

/makeitem ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_1 1
and
/makeitem ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4 1

but damn the msg

any one know why?

im lv 120 max

help

 

[Paranoit]

Re: [Release] Add new Item Drop

Forgotten world working only until level 110 and you spawn the item only in a City / Save Zone )

 

[ameerking]

Re: [Release] Add new Item Drop

thank you

but i want add item drop in mobs general and Champion and giant Only

 

[NoMore]

Thanks
Good Work ^^

 

[shawky]

if i want to add arena coin | normal mob drop 1 arena coin , but if i want to make a unique drop like 50 - 100 arena coins what i should do ?

 

[K4bo]

if i want to add arena coin | normal mob drop 1 arena coin , but if i want to make a unique drop like 50 - 100 arena coins what i should do ?

go learn _RefMonster_AssignedItemDrop

can u know why i cant open forgotten world?

i got the icon and on i right click on it i got

requires level is not reached for entering

the code of item

/makeitem ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_1 1
and
/makeitem ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4 1

but damn the msg

any one know why?

im lv 120 max

help

this isn't about fgw, just one thing if you have played isro you will realized that fgw from lvl101 to lvl110

 

[shawky]

btw, iam asking thread starter not you

 

[K4bo]

I have the rights to post in any thread, if you don't like my post so don't care to it :

 

[Kira]

Nice Share and Nice Work

 

[SupremeSRO]

hi bud , i apply thi query :


USE SHARD_DB
GO

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



SET @MonsterID = 43783 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 1 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 39004,39007,39010,39013,39016,39019,39022,39025,39028,39031,39034,39037,39040,39043,39046,39049,39052,39055,39058,39061,39064,39067,39070,39073,39076,39079,39082,39085,39088,39091,39094,39097,39100,39103,39106,39109,39112,39115,39118,39121,39124,39127,39130,39133,39136,39139,39142,39145,39148,39151,39154,39157,39160,39163,39166,39169,39172,39175,39178,39181,39184,39187,39190,39193,39196,39199,39202,39205,39208,39211,39214,39217,39220,39223,39226,39229,39232,39235,39238,39241,39244,39247,39250,39253,39256,39259,39262,39265,39268,39271,39274,39277,39280,39283 -- You can find Item ID's at RefObjCommon


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 , 'xxx')


but i get this Error > : Msg 102, Level 15, State 1, Line 10
Incorrect syntax near ','.

apparently ofc is for the " , " - so how i can separate the Id`s ?

REGARDS and thanks in advance

 

[huntercodex]

you can give a query and made ​​of an item please???

 

[Hean]

hi bud , i apply thi query :


USE SHARD_DB
GO

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



SET @MonsterID = 43783 -- You can find Monster ID's at RefObjCommon
SET @DropRatio = 1 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @ItemID = 39004,39007,39010,39013,39016,39019,39022,39025,39028,39031,39034,39037,39040,39043,39046,39049,39052,39055,39058,39061,39064,39067,39070,39073,39076,39079,39082,39085,39088,39091,39094,39097,39100,39103,39106,39109,39112,39115,39118,39121,39124,39127,39130,39133,39136,39139,39142,39145,39148,39151,39154,39157,39160,39163,39166,39169,39172,39175,39178,39181,39184,39187,39190,39193,39196,39199,39202,39205,39208,39211,39214,39217,39220,39223,39226,39229,39232,39235,39238,39241,39244,39247,39250,39253,39256,39259,39262,39265,39268,39271,39274,39277,39280,39283 -- You can find Item ID's at RefObjCommon


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 , 'xxx')


but i get this Error > : Msg 102, Level 15, State 1, Line 10
Incorrect syntax near ','.

apparently ofc is for the " , " - so how i can separate the Id`s ?

REGARDS and thanks in advance

You can't add multiply items xD For that you need a monster list I wrote a tool wich add item by list in c#.
I will release it soon

 

[SupremeSRO]

Ok ty for answer Hean

 

[miezzy]

which included this code? :?: