الموقع العربي الاول للعبة Silkroad Online
صفحة 1 من 2 1 2
عرض 40 مشاركات من هذا الموضوع لكل صفحة

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   مشكله في uinue drop (https://silkroad4arab.com/vb/showthread.php?t=585865)

Spicoo 20-05-2015 08:03 PM
مشكله في uinue drop
 
انا عملت البدع والله علشان اخلي Uinuqe [Tiger] ينزل ارينا كوين ومش لاقي حل
انا ضفت ببرنامج Auto Quere
وضفت بكويري Add New Drop وبر ضو مبينزلشي حاجه
ارجو الحل
Data Base Evolution

!_Ahmed Elabbasy_! 20-05-2015 11:25 PM
رد: مشكله في uinue drop
 
عاوز تعمل درب موبس اعمل الكويرى دا


كود 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
رد: مشكله في uinue drop
 
عملتو والله يا باشا ومفيش حاجه بتنزل
:blush-anim-cl:

MR D.B 21-05-2015 12:23 AM
رد: مشكله في uinue drop
 
ممكن يكون عشان لفل cher اعلى من التيجر فا مش هينز حاجه جربه فى uniques يكون قريب من max lvl cher عندك فى الجيم

Spicoo 21-05-2015 12:40 AM
رد: مشكله في uinue drop
 
عملت ياباشا cher لفل 25 وبرضو منزلشي حاجه :toobad::toobad:

vortex77 21-05-2015 01:16 AM
رد: مشكله في uinue drop
 
جرب الكويرى ده

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
رد: مشكله في uinue drop
 
ياباشا ال Normal Unique لو اتشقلبت مش هينزلو ومتسألشى ليه ^^

vortex77 21-05-2015 01:18 AM
رد: مشكله في uinue drop
 
جرب الكويرى ده

اقتباس:
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
رد: مشكله في uinue drop
 
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
رد: مشكله في uinue drop
 
اقتباس:
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
رد: مشكله في uinue drop
 
اقتباس:
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
رد: مشكله في uinue drop
 
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
رد: مشكله في uinue drop
 
جرب دى كدا

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
رد: مشكله في uinue drop
 
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
رد: مشكله في uinue drop
 
جرب ده وعدل على المسافات فى الكويرى بس وهيشتغل معاك
اقتباس:
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')


الساعة الآن 09:31 PM.
صفحة 1 من 2 1 2
عرض 40 مشاركات من هذا الموضوع لكل صفحة

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions, Inc.