عرض مشاركة واحدة
قديم 14-12-2014, 08:37 PM   #2

pop2009
عضو لامع





• الانـتـسـاب » Nov 2007
• رقـم العـضـويـة » 5370
• المشـــاركـات » 1,261
• الـدولـة » https://t.me/pump_upp
• الـهـوايـة » database editor
• اسـم الـسـيـرفـر » No Server
• الـجـنـس » Male
• نقـاط التقييم » 19
pop2009 صـاعـد

pop2009 غير متواجد حالياً


إرسال رسالة عبر ICQ إلى pop2009 إرسال رسالة عبر AIM إلى pop2009 إرسال رسالة عبر Yahoo إلى pop2009

افتراضي



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,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,@DropAmountMin,@DropAmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'xxx')/**/