انا عاوز اليونيكات ال mirror drop d14 sun set and wepon and acc

[ouun_elalb]

نا عاوز اليونيكات تنزل d14 sun uniq jupter all uniq mirror
we el d15 nfsy el sora tzha ana 3waz fe el d15 el wepon bas el sora tzhar we tsht3al
we el uniq mirror
ينزل اسلحه و لبس d14 sun

بس كدا لو حد يعرف ياريت يسعدنى

[ouun_elalb]

ايه يا جماعه محديش عارف ولا ايه

[hero_000]

طلبك هنا http://www.silkroad4arab.com/vb/showthread.php?p=4522201

[BomBom]

استخدم ال Query دى

USE SRO_VT_SHARD -----> ( MaDenGo ) <-----
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 , 'xxx')

عشان تعرف كود ال item

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

عشان تعرف كود ال mob

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

[ouun_elalb]

استخدم ال query دى

use sro_vt_shard -----> ( madengo ) <-----
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 , 'xxx')

عشان تعرف كود ال item

use sro_vt_shard select id from _refobjcommon where codename128 like 'mob_rm_roc'

عشان تعرف كود ال mob

use sro_vt_shard select id from _refobjcommon where codename128 like 'item_ch_tblade_11_set_a_rare'

طيب انا عاوز احط كزا كود ايتم احطهوم ازاى ممكن تقولى الحل