المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : How To Fix Alchamy Rate [Query] For D1~D15


legendknight
24-01-2014, 04:13 AM
السلام عليكم
لقد بحثت كثيرا عن كيفية اصلاح نسبة نجاح ال+ وعندما وجت وجته حتي d12 فقط
فصنعت لكم هذا الموضوع
ممكن يفيد اي حد

first The Query
USE [SRO_VT_SHARD]
----------------------------Made By [Dev]LegendKnight----------------------------
DECLARE @LEGENDKNIGHT1 VARCHAR (129)
DECLARE @LEGENDKNIGHT2 VARCHAR (129)
DECLARE @LEGENDKNIGHT3 VARCHAR (129)
DECLARE @LEGENDKNIGHT4 VARCHAR (129)
DECLARE @LEGENDKNIGHT5 VARCHAR (129)
DECLARE @LEGENDKNIGHT6 VARCHAR (129)

SET @LEGENDKNIGHT1 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_13'
SET @LEGENDKNIGHT2 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_14'
SET @LEGENDKNIGHT3 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_15'
SET @LEGENDKNIGHT4 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_13'
SET @LEGENDKNIGHT5 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'
SET @LEGENDKNIGHT6 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_15'

Declare @D15x2 int SET @D15x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT6)
Declare @D13 int SET @D13 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT1)
Declare @D14 int SET @D14 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT2)
Declare @D15 int SET @D15 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT3)
Declare @D13x2 int SET @D13x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT4)
Declare @D14x2 int SET @D14x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT5)

UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='13 47110450' where ID= @D15x2

وهذا هو البرنامج الذي من خلاله يمكنك التحكم في نسبة ال+
http://files.fm/u/azllimm
البرنامج سهل جدا وي مش محتاج شرح
عايز اشوف كام دعوا حلوه كدا عان تفتحوا نفس الواحد يعملوكو مواضيع
LegendKnight

che_9299
14-02-2014, 10:47 AM
تمــت المـوافقــة ,,

MyRȝturn
14-02-2014, 02:32 PM
الله ينور
تسلم

iLead
14-02-2014, 06:08 PM
الله ينور تمام :111 (27):

Xeitran
19-02-2014, 12:10 AM
Ty BRO

●♥ Marwan1337 ♥●
19-02-2014, 06:47 PM
تمــام :)

Last_Fiddler
19-02-2014, 09:52 PM
تسلم ايدك

Hamza FiGo
30-04-2014, 01:12 AM
شكرا جزيلا جاري التجربة

وشكرا علي مساعدتك للناس

ruxana
23-05-2014, 12:36 PM
ياريت حد يرفع اللينك من جديد علشان مش شغال