Query add drops to mobs by city name

[Jayden]

http://o55.imgup.net/151f126a.png

بما انى لقيت كذا حد عايز يضيف Drops للوحوش بإسم المدينة
قررت أعملها وأفيدهم بيها
إتفضلوا

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'

[Hamza FiGo]

دا لو شغال تمام يبقي 100% . تسلم ايدك يا Jayden :thumbsup:

[abomohsen50]

الله ينور :pipe1::pipe1:

[Dev.LumiusCux]

الله ينور

[Dev.BigBear]

اغيب فترة اجى الاقى الدنيا مولعة كدة
طب خدونى معاكو
:mf_w00t1:

[Dev.Ri3o]

10/10

[™ EgY_KhaN ™]

الله ينور جميله فعلا واحسن حتي من Vsro auto query
تسلم ايدك

[Jayden]

العفو يا رجالة :wink:

[hodamando]

دا كود ممكن يكون احسن واسهل

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_SD_ANUBIS'/*Monster Code*/
SET @Item = 'ITEM_EVENT_GLOBAL_CHATTING'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 2 /*Drop Max*/
SET @DropRatio = 0.5 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
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(@MonsterID,@ItemID,0,0,@DropAmountMin,@Drop AmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,'xxx')/**/

[Helper4You]

دا كود ممكن يكون احسن واسهل

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By nukertube*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_SD_ANUBIS'/*Monster Code*/
SET @Item = 'ITEM_EVENT_GLOBAL_CHATTING'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 2 /*Drop Max*/
SET @DropRatio = 0.5 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
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(@MonsterID,@ItemID,0,0,@DropAmountMin,@Drop AmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,'xxx')/**/


دى حاجه ودى حاجه

[ابو ليلى]

ممكن حضرتك تقولى اعدل اية فى الكوير يعنى اكتب كود الايتم فين النسبة
يعنى انا مثلا فى الجزء دة اعدل فى حاجة ولا اسيبو زى ماهو
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

[elfr3on2010]

تسلم ايدك

[Jayden]

متعدلش فى حاجة غير اول ال Query اللى انا محددهولك

[midoxevi]

انت لي مش حاتت samrakand