مشاهدة النسخة كاملة : ارجو الحل سريعا
Blizzard
14-12-2014, 08:30 PM
عندى موبس عاوز اليت وعاووز اخليها جنيرال و عاوزها تواقع احجره وايتم نوفا و موون بس اعملها ازاى
pop2009
14-12-2014, 08:37 PM
for Sox Drop Use This Query Change Number 10 to the Lineage you want
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
to Add Drop To Mobs Use this Query
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_SD_ISIS'/*Monster Code*/
SET @Item = 'ITEM_ETC_SD_TOKEN_04'/*Item Code*/
SET @DropAmountMin = 3 /*Drop Min*/
SET @DropAmountMax = 3 /*Drop Max*/
SET @DropRatio = 1 /*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')/**/
Blizzard
14-12-2014, 09:32 PM
طب انا عاوز احول الموبس من اليت لى جنيرالاعمل ايه
pop2009
14-12-2014, 09:45 PM
ديه معرفهاش بصراحه بس اعتقد هتلاقى الاكواد ده فى اى GM Helper
Blizzard
14-12-2014, 09:56 PM
يا مان انا عندى Mobs Elite وعاوز اخليها General ازاى بقى
pop2009
14-12-2014, 09:57 PM
معرفش بصراحه
Blizzard
14-12-2014, 10:05 PM
for Sox Drop Use This Query Change Number 10 to the Lineage you want
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATEto Add Drop To Mobs Use this Query
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_SD_ISIS'/*Monster Code*/
SET @Item = 'ITEM_ETC_SD_TOKEN_04'/*Item Code*/
SET @DropAmountMin = 3 /*Drop Min*/
SET @DropAmountMax = 3 /*Drop Max*/
SET @DropRatio = 1 /*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')/**/
اغير رقم 10 ليه ؟
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc