الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**Spicoo** · 20-05-2015, 08:03 PM

انا عملت البدع والله علشان اخلي Uinuqe [Tiger] ينزل ارينا كوين ومش لاقي حل
انا ضفت ببرنامج Auto Quere
وضفت بكويري Add New Drop وبر ضو مبينزلشي حاجه
ارجو الحل
Data Base Evolution

**!_Ahmed Elabbasy_!** · 20-05-2015, 11:25 PM

عاوز تعمل درب موبس اعمل الكويرى دا

كود PHP:


			
USE SRO_VT_SHARD -----> ( ahmed ) <----- 
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')

دا عشان تجيب id الموبس

كود PHP:


			
 Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'

دا عشان تجيب id الايتم id مش كود ركز

كود PHP:


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

**Spicoo** · 20-05-2015, 11:27 PM

عملتو والله يا باشا ومفيش حاجه بتنزل

**MR D.B** · 21-05-2015, 12:23 AM

ممكن يكون عشان لفل cher اعلى من التيجر فا مش هينز حاجه جربه فى uniques يكون قريب من max lvl cher عندك فى الجيم

**Spicoo** · 21-05-2015, 12:40 AM

عملت ياباشا cher لفل 25 وبرضو منزلشي حاجه

**vortex77** · 21-05-2015, 01:16 AM

جرب الكويرى ده

USE/**/[SRO_VT_SHARD]/**/

اقتباس:

--Credits to Hean

/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

**Danger Sro** · 21-05-2015, 01:17 AM

ياباشا ال Normal Unique لو اتشقلبت مش هينزلو ومتسألشى ليه ^^

**vortex77** · 21-05-2015, 01:18 AM

جرب الكويرى ده

اقتباس:

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

**vortex77** · 21-05-2015, 01:25 AM

USE/**/[SRO_VT_SHARD]/**/[/QUOTE]
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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') [QUOTE]

**vortex77** · 21-05-2015, 01:32 AM

اقتباس:

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

جرب دى

**vortex77** · 21-05-2015, 01:34 AM

اقتباس:

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

جرب دى وعدل عليها

**vortex77** · 21-05-2015, 01:37 AM

try this Query

اقتباس:

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

**vortex77** · 21-05-2015, 01:37 AM

جرب دى كدا

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

**vortex77** · 21-05-2015, 01:40 AM

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = '000'/*Monster Code*/
SET @Item = '0000'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

**vortex77** · 21-05-2015, 01:42 AM

جرب ده وعدل على المسافات فى الكويرى بس وهيشتغل معاك

اقتباس:

USE/**/[SRO_VT_SHARD]/**/
--Credits to Hean
/*Edited By Dangers*/
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_CH_SWORD_11_SET_B_RARE'/*Item Code*/
SET @DropAmountMin = 1 /*Drop Min*/
SET @DropAmountMax = 10 /*Drop Max*/
SET @DropRatio = 0.001 /*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')

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
drop مشكله	tram	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	7	30-08-2020 05:42 PM
مشكله فى DROP	kokyko32	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	11	22-08-2014 12:34 AM
مشكله فى DROP	kokyko32	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	0	21-08-2014 12:09 AM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	تسجيل الدخول دائمآ