انا عاوز الارينا كوين تقع من الوحوش مش تبقى 0

[ahmedzizoa]

عاوز الارينا كوين تقع من وحوش مرم 119 و 120
فجربت على موبس 111 وعملت الكود (الكويرى تمام
بص برضه مبتقعش ولا حتى من اليونيكات
فى واحد قال شوف السيرفر يكون صفر
مش عارف يعنى بخليها واحد ازاى ومنين
ودى صورة من الداتا بيز بعد عمل الكورى واضافة الدروب ايتم من الموبس وبرضه مبتقعش
http://store6.up-00.com/2017-02/148735668286821.gif

[Mahmoud Rashwan]

جرب كدا ده USE SRO_VT_SHARD
DECLARE @Place VARCHAR(MAX),@Drop VARCHAR(MAX),@Rate real,@rows int = 0,@MinAmount int,@MaxAmount int,@RowsCount int
,@MobCode varchar(max),@ID int,@ItemID int
-------------------------------------------------------------------------------
SET @Place = 'JG' -- your desired area Jangan = JG, Donwhang = DW, Hotan = HT, Alex = AX, JobTemple = TP
SET @Drop = 'ITEM_' --Item CodeName
SET @Rate = '1' -- Drop Rate
SET @MinAmount = '1' --Minimum amount of item
SET @MaxAmount = '1' --Max amount of item
-------------------------------------------------------------------------------
IF @Place = 'JG'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'CHINA'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Jangan Mobs Successfully!'
END
ELSE IF @Place = 'DW'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'West_China'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Donwhang Mobs Successfully!'
END
ELSE IF @Place = 'HT'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like 'Oasis_Kingdom'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
END
ELSE IF @Place = 'AX'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like '%DELTA%' or ContinentName like '%SD%' or ContinentName like '%Pharaoh%' or ContinentName like '%KingsValley%'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Alexandria Mobs Successfully!'
END
ELSE IF @Place = 'TP'
BEGIN
SET @RowsCount = (SELECT COUNT(CodeName128) From _RefObjCommon where id in
(select dwobjid from Tab_RefTactics where dwTacticsID in
(select dwTacticsID from Tab_RefNest where nRegionDBID in
(select wregionid from _refregion where ContinentName like '%TEMPLE%'))) and CodeName128 like '%MOB_%')
while (@rows < @RowsCount) BEGIN
set @MobCode = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @rows)
set @ID = (select ID from _refobjcommon where CodeName128 = @MobCode)
set @ItemID = (Select id from _RefObjCommon where CodeName128 = @Drop)
INSERT _RefMonster_AssignedItemDrop VALUES (@ID,@ItemID,0,0,@MinAmount,@MaxAmount,@Rate,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')
END
Print ''+@Drop+' has been added to Temple Mobs Successfully!'
END
ELSE
PRINT 'You wrote a wrong place name'

[ahmedzizoa]

ايرور فى اللوج ان

[Dev.Klito]

دى عشان تجيب الـ ID

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

و استخدم دى كدا و شوف

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 -------- Item drop rate 1=100% , 0.3 = 30%
SET @ItemID = 24165 -------- ITEM ID You want Add in Drops


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