I-Sro R Files MonsterDrop

[xXRuokXx]

Hey guys

sorry for bad english ^^ (german :-P)

I using the isro-r files based on RIGID project .
all mobs above level 100 have no drops how can i change this ?

i've searched the forum but cant find any guide .

Thanks ~

[Dacks87]

ich habe da was für dich




USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE @ VarChar(MAX) @ VarChar(MAX) @ID iNt @ID iNt @atio ReaL, @AmountMin INT, @AmountMax INT
--------------------------------------------------------------------------
SET @ = 'MOB_JUPITER_BABILION'/*Monster Code*/
SET @ = 'ITEM_ETC_ARENA_COIN'/*Item Code*/
SET @AmountMin = 35 /*Drop Min*/
SET @AmountMax = 50 /*Drop Max*/
SET @atio = 1 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @ID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @)/**/
SET @ID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @)/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,Dro pAmountMin,DropAmountMax,DropRatio,RefMagicOptionI D1,CustomValue1,RefMagicOptionID2,CustomValue2,Ref MagicOptionID3,CustomValue3,RefMagicOptionID4,Cust omValue4,RefMagicOptionID5,CustomValue5,RefMagicOp tionID6,CustomValue6,RefMagicOptionID7,CustomValue 7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9 ,CustomValue9,RentCodeName)/**/
VALUES @ID @ID,0,0 @AmountMin @AmountMax @atio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/

[xXRuokXx]

Vielen dank ,

aber das klappt bei mir nicht ^^

USE/**/[SRO_VT_SHARD]/**/ <--- in der Zeile habe ich auch meine DB eingetragen dennoch einige fehler

does not work for SRO_R_SHARD database

[Xeulin7]

You need to enable them in _RefDropClassSel_Equip table in SHARD database and also add item id's in _RefDropItemAssign table.

[Siezma09]

Originally Posted by xXRuokXx

Hey guys

sorry for bad english ^^ (german :-P)

I using the isro-r files based on RIGID project .
all mobs above level 100 have no drops how can i change this ?

i've searched the forum but cant find any guide .

Thanks ~

You can enable them all as Xeulin7 said. Thats the right way but if you want to copy them from vsro database, dont forget to replace eu item ID's

Originally Posted by Xeulin7

You need to enable them in _RefDropClassSel_Equip table in SHARD database and also add item id's in _RefDropItemAssign table.

[xXRuokXx]

hey guys

thanks for response i'm total beginner with SQL is there maybe a step by step tutorial ?

in _RefDropClassSel_Equip is monster level 1 to 180 listet but all rows are 0

greetz =)

[Xeulin7]

Originally Posted by xXRuokXx

hey guys

thanks for response i'm total beginner with SQL is there maybe a step by step tutorial ?

in _RefDropClassSel_Equip is monster level 1 to 180 listet but all rows are 0

greetz =)

Unfortunately for you, there's no such guide, you can copy _RefDropClassSel_Equip table from vSRO files to make it easier, but you can't do the same with _RefDropItemAssign as vsro and rigid files has different item ID's, so that will need to be do manually.
For example to add a 1st degree lvl 1 china sword to drops you'll add this like to _RefDropItemAssign table:

1	71	100	100	-1	1

71 being Item ID from _refobjcommon, hope this helps you to get the idea how it works.

[xXRuokXx]

sorry for late answer .

i've copied _RefDropClassSel_Equip and set some items to _RefDropItemAssign .
But mobs above level 100 had no drops . =(

maybe you can help me .

thanks ~

[Worshiper]

Originally Posted by xXRuokXx

sorry for late answer .

i've copied _RefDropClassSel_Equip and set some items to _RefDropItemAssign .
But mobs above level 100 had no drops . =(

maybe you can help me .

thanks ~

Didn't drop anything even stone and golds too?

[romio100]

The code has been modified and it works with me on the database.



USE [SRO_VT_SHARD]
GO

-- الفضل يعود إلى Hean - تم التعديل بواسطة nukertube

DECLARE
@ VARCHAR(MAX),
@ VARCHAR(MAX),
@ID INT,
@_ID INT,
@atio REAL,
@AmountMin INT,
@AmountMax INT;

-- الإعدادات
SET @ = 'MOB_JUPITER_BABILION'; -- كود الوحش
SET @ = 'ITEM_ETC_ARENA_COIN'; -- كود العنصر
SET @AmountMin = 35; -- الحد الأدنى للإسقاط
SET @AmountMax = 50; -- الحد الأقصى للإسقاط
SET @atio = 1; -- نسبة الإسقاط (1 = 100%)

-- الحصول على ID الوحش والعنصر من _RefObjCommon
SET @ID = (
SELECT ID
FROM [dbo].[_RefObjCommon]
WHERE CodeName128 = @
);

SET @_ID = (
SELECT ID
FROM [dbo].[_RefObjCommon]
WHERE CodeName128 = @
);

-- إدخال السطر في جدول الإسقاطات
INSERT INTO [dbo].[_RefMonster_AssignedItemDrop]
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6
)
VALUES
(
@ID,
@_ID,
0, -- DropGroupType
0, -- OptLevel
@AmountMin,
@AmountMax,
@atio,
0, 0,
0, 0,
0, 0,
0, 0,
0, 0,
0, 0
);

[xXRuokXx]

Originally Posted by Worshiper

Didn't drop anything even stone and golds too?

No nothing i've worked around 4 hours yesterday but i cant slove this poblem =(

Originally Posted by romio100

The code has been modified and it works with me on the database.



USE [SRO_VT_SHARD]
GO

-- الفضل يعود إلى Hean - تم التعديل بواسطة nukertube

DECLARE
@ VARCHAR(MAX),
@ VARCHAR(MAX),
@ID INT,
@_ID INT,
@atio REAL,
@AmountMin INT,
@AmountMax INT;

-- الإعدادات
SET @ = 'MOB_JUPITER_BABILION'; -- كود الوحش
SET @ = 'ITEM_ETC_ARENA_COIN'; -- كود العنصر
SET @AmountMin = 35; -- الحد الأدنى للإسقاط
SET @AmountMax = 50; -- الحد الأقصى للإسقاط
SET @atio = 1; -- نسبة الإسقاط (1 = 100%)

-- الحصول على ID الوحش والعنصر من _RefObjCommon
SET @ID = (
SELECT ID
FROM [dbo].[_RefObjCommon]
WHERE CodeName128 = @
);

SET @_ID = (
SELECT ID
FROM [dbo].[_RefObjCommon]
WHERE CodeName128 = @
);

-- إدخال السطر في جدول الإسقاطات
INSERT INTO [dbo].[_RefMonster_AssignedItemDrop]
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6
)
VALUES
(
@ID,
@_ID,
0, -- DropGroupType
0, -- OptLevel
@AmountMin,
@AmountMax,
@atio,
0, 0,
0, 0,
0, 0,
0, 0,
0, 0,
0, 0
);

This worked for RIGID Silkroad_R_Shard Database ?

[romio100]

Yes

[andzia098]

hopefully it's not this, but if you're 7 levels higher than the monster's level, it won't drop anything even gold, that's the system for sro-r, so first try with a lv 101 char, see if anything would drop. (If you're killing them with a lv 120 char that is)

[xXRuokXx]

Originally Posted by romio100

Yes

i have tested your code but change these lines

 Spoiler

SET @ = 'MOB_JUPITER_BABILION'; -- كود الوحش
SET @ = 'ITEM_ETC_ARENA_COIN'; -- كود العنصر
SET @AmountMin = 35; -- الحد الأدنى للإسقاط
SET @AmountMax = 50; -- الحد الأقصى للإسقاط
SET @atio = 1; -- نسبة الإسقاط (1 = 100%)

i've add weneg mob at alexandria and a seal of nova item 100% drop chance and nothing happend no drop =( i dont know why

Originally Posted by andzia098

hopefully it's not this, but if you're 7 levels higher than the monster's level, it won't drop anything even gold, that's the system for sro-r, so first try with a lv 101 char, see if anything would drop. (If you're killing them with a lv 120 char that is)

they also drop no gold ^^
and i'm level 102 @ 101 weneg mobs

[xXRuokXx]

// Update my friends now can find items after add some .

my account cant find items i've make a new account withoud admin or GM but for me dont drop items