DECLARE @ItemUpgrade1 int,@ItemUpgrade2 int,@ItemUpgrade3 int,@ItemUpgrade4 int,@ItemUpgrade5 int,@ItemUpgrade6 int,@ItemUpgrade7 int,@ItemUpgrade8 int,@ItemUpgrade9 int,@ItemUpgrade10 int
DECLARE [MENTION=205986]accessory[/MENTION]Upgrade1 int [MENTION=205986]accessory[/MENTION]Upgrade2 int [MENTION=205986]accessory[/MENTION]Upgrade3 int [MENTION=205986]accessory[/MENTION]Upgrade4 int [MENTION=205986]accessory[/MENTION]Upgrade5 int [MENTION=205986]accessory[/MENTION]Upgrade6 int [MENTION=205986]accessory[/MENTION]Upgrade7 int [MENTION=205986]accessory[/MENTION]Upgrade8 int [MENTION=205986]accessory[/MENTION]Upgrade9 int [MENTION=205986]accessory[/MENTION]Upgrade10 int
/* Percent for Item Upgrade */
-- +1 Upgrade Oraný
SET @ItemUpgrade1 = 10000
-- +2 Upgrade Oraný
SET @ItemUpgrade2 = 10000
-- +3 Upgrade Oraný
SET @ItemUpgrade3 = 10000
-- +4 Upgrade Oraný
SET @ItemUpgrade4 = 8000
-- +5 Upgrade Oraný
SET @ItemUpgrade5 = 7000
-- +6 Upgrade Oraný
SET @ItemUpgrade6 = 5000
-- +7 Upgrade Oraný
SET @ItemUpgrade7 = 3000
-- +8 Upgrade Oraný
SET @ItemUpgrade8 = 2000
-- +9 Upgrade Oraný
SET @ItemUpgrade9 = 1000
-- +10 Upgrade Oraný
SET @ItemUpgrade10 = 100
/* Percent for Accessory Upgrade */
-- +1 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade1 = 10000
-- +2 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade2 = 7000
-- +3 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade3 = 5000
-- +4 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade4 = 0
-- +5 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade5 = 0
-- +6 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade6 = 0
-- +7 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade7 = 0
-- +8 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade8 = 0
-- +9 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade9 = 0
-- +10 Upgrade Oraný
SET [MENTION=205986]accessory[/MENTION]Upgrade10 = 0
/* General Item Upgrade */
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade1 WHERE nOriginItem LIKE '%1'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade2 WHERE nOriginItem LIKE '%2'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade3 WHERE nOriginItem LIKE '%3'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade4 WHERE nOriginItem LIKE '%4'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade5 WHERE nOriginItem LIKE '%5'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade6 WHERE nOriginItem LIKE '%6'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade7 WHERE nOriginItem LIKE'%7'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade8 WHERE nOriginItem LIKE '%8'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade9 WHERE nOriginItem LIKE '%9'AND nReqItem1 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade10 WHERE nOriginItem LIKE '%0'AND nReqItem1 = 379021000
/* General Unique Item Upgrade */
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade1 WHERE nOriginItem LIKE '%1'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade2 WHERE nOriginItem LIKE '%2'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade3 WHERE nOriginItem LIKE '%3'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade4 WHERE nOriginItem LIKE '%4'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade5 WHERE nOriginItem LIKE '%5'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade6 WHERE nOriginItem LIKE '%6'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade7 WHERE nOriginItem LIKE'%7'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade8 WHERE nOriginItem LIKE '%8'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade9 WHERE nOriginItem LIKE '%9'AND nReqItem2 = 379021000
UPDATE ITEM_UPGRADE SET nGenRate = @ItemUpgrade10 WHERE nOriginItem LIKE '%0'AND nReqItem2 = 379021000
/* Accessory Upgrade */
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade1 WHERE nOriginItem LIKE '%1'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade2 WHERE nOriginItem LIKE '%2'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade3 WHERE nOriginItem LIKE '%3'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade4 WHERE nOriginItem LIKE '%4'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade5 WHERE nOriginItem LIKE '%5'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade6 WHERE nOriginItem LIKE '%6'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade7 WHERE nOriginItem LIKE'%7'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade8 WHERE nOriginItem LIKE '%8'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade9 WHERE nOriginItem LIKE '%9'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = [MENTION=205986]accessory[/MENTION]Upgrade10 WHERE nOriginItem LIKE '%0'AND nReqItem1 = 379159000
