declare @c1 decimal(10,5), @c2 decimal(10,5), @c3 decimal(10,5), @c4 decimal(10,5), @c5 decimal(10,5), @c6 decimal(10,5), @c7 decimal(10,5), @c8 decimal(10,5), @c9 decimal(10,5), @c10 decimal(10,5)
declare @c11 decimal(10,5), @c12 decimal(10,5), @c13 decimal(10,5), @c14 decimal(10,5), @c15 decimal(10,5), @c16 decimal(10,5), @c17 decimal(10,5), @c18 decimal(10,5), @c19 decimal(10,5), @c20 decimal(10,5)
declare @ac1 decimal(10,5), @ac2 decimal(10,5), @ac3 decimal(10,5), @ac4 decimal(10,5), @ac5 decimal(10,5), @ac6 decimal(10,5), @ac7 decimal(10,5), @ac8 decimal(10,5), @ac9 decimal(10,5), @ac10 decimal(10,5)
declare @ac11 decimal(10,5), @ac12 decimal(10,5), @ac13 decimal(10,5), @ac14 decimal(10,5), @ac15 decimal(10,5), @ac16 decimal(10,5), @ac17 decimal(10,5), @ac18 decimal(10,5), @ac19 decimal(10,5), @ac20 decimal(10,5)
declare @s1 decimal(10,5), @s2 decimal(10,5), @s3 decimal(10,5), @s4 decimal(10,5), @s5 decimal(10,5), @s6 decimal(10,5), @s7 decimal(10,5), @s8 decimal(10,5), @s9 decimal(10,5), @s10 decimal(10,5)
declare @as1 decimal(10,5), @as2 decimal(10,5), @as3 decimal(10,5), @as4 decimal(10,5), @as5 decimal(10,5), @as6 decimal(10,5), @as7 decimal(10,5), @as8 decimal(10,5), @as9 decimal(10,5), @as10 decimal(10,5)
set @c1 = 1 -- <<== @c1 to @c20 = desired rates do Normal Cubes Strike/Defense R2 to R7
set @c2 = 1
set @c3 = 1
set @c4 = 1
set @c5 = 0.6
set @c6 = 0.5
set @c7 = 0.4
set @c8 = 0.3
set @c9 = 0.2
set @c10 = 0.1
set @c11 = 0.09
set @c12 = 0.08
set @c13 = 0.07
set @c14 = 0.06
set @c15 = 0.05
set @c16 = 0.04
set @c17 = 0.03
set @c18 = 0.02
set @c19 = 0.01
set @c20 = 0.01
set @ac1 = 1 -- <<== @ac1 to @ac20 = desired rates do Ancient Cubes Strike/Defense R2 to R7
set @ac2 = 1
set @ac3 = 1
set @ac4 = 1
set @ac5 = 1
set @ac6 = 0.90
set @ac7 = 0.80
set @ac8 = 0.70
set @ac9 = 0.60
set @ac10 = 0.50
set @ac11 = 0.40
set @ac12 = 0.30
set @ac13 = 0.25
set @ac14 = 0.20
set @ac15 = 0.15
set @ac16 = 0.14
set @ac17 = 0.13
set @ac18 = 0.12
set @ac19 = 0.11
set @ac20 = 0.10
set @s1 = 1 -- <<== @s1 to @s10 = desired rates do Cube Skill
set @s2 = 0.5
set @s3 = 0.3
set @s4 = 0.1
set @s5 = 0.05
set @s6 = 0
set @s7 = 0
set @s8 = 0
set @s9 = 0
set @s10 = 0
set @as1 = 1 -- <<== @as1 to @as10 = desired rates do Ancient Cube Skill
set @as2 = 0.90
set @as3 = 0.80
set @as4 = 0.70
set @as5 = 0.60
set @as6 = 0.50
set @as7 = 0.40
set @as8 = 0.30
set @as9 = 0.20
set @as10 = 0.10
/***** Cubes Def and Strikes *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @c1
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @c2
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @c3
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @c4
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @c5
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @c6
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @c7
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @c8
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @c9
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @c10
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_11] = @c11
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_12] = @c12
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_13] = @c13
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_14] = @c14
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_15] = @c15
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_16] = @c16
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_17] = @c17
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_18] = @c18
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_19] = @c19
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_20] = @c20
where need_item >= 700102 and need_item <= 700106 or need_item = 700112 or need_item >= 700202 and need_item <= 700206 or need_item = 700212
/***** Anc Cubes Def and Strikes *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @ac1
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @ac2
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @ac3
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @ac4
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @ac5
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @ac6
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @ac7
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @ac8
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @ac9
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @ac10
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_11] = @ac11
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_12] = @ac12
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_13] = @ac13
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_14] = @ac14
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_15] = @ac15
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_16] = @ac16
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_17] = @ac17
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_18] = @ac18
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_19] = @ac19
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_20] = @ac20
where need_item >= 700151 and need_item <= 700157 or need_item >= 700251 and need_item <= 700257 or need_item >= 700107 and need_item <= 70011 or need_item >= 700207 and need_item <= 700211
/***** Cube Skill *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @s1
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @s2
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @s3
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @s4
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @s5
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @s6
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @s7
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @s8
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @s9
where need_item = 700401
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @s10
where need_item = 700401
/***** Anc Cube Skill *****/
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_1] = @as1
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_2] = @as2
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_3] = @as3
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_4] = @as4
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_5] = @as5
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_6] = @as6
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_7] = @as7
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_8] = @as8
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_9] = @as9
where need_item = 700402
UPDATE [Arcadia].[dbo].[EnhanceResource]
SET [percentage_10] = @as10
where need_item = 700402