[Hamza FiGo]

المشاركة الأصلية كتبت بواسطة Mohamedaly1372 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

انا عاوزمن
1-5 80%
6-7 60%
7.9 40%
9-12 20%
12-20 10%
وشكرا على الموضوع الجميل :]

USE [SRO_VT_SHARD]
----------------------------xxHamza FiGoxx----------------------------
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='1347440720',Param3='1346124840',Param4='503644416' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1347440720',Param3='1346124840',Param4='503644416' where ID= @D15x2

المشاركة الأصلية كتبت بواسطة pepsiman00 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

ممكن اتعبك معايا معلش انا اسف اسف جدا انا عايز من 1 ل 10 70% و من 10 ل15 50% و من 15 ل 20 40 % معليش السرفر بتاعى البلس فيى لحل 20 انا اسف انى بتقل عليك

حضرتك البلاص لحد 12 فقط

المشاركة الأصلية كتبت بواسطة xxaakk عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

انا عاوز
1~3 100%
3~5 80%
5~8 50%
8~10 30%
10~11 10%
11~12 1%
و شكراً

USE [SRO_VT_SHARD]
----------------------------xxHamza FiGoxx----------------------------
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='1684300880',Param3='1345466930',Param4='505285121' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300880',Param3='1345466930',Param4='505285121' where ID= @D15x2