Kod:
/*
# Upgrade Percent Options
# Author : AKUMA
# E-mail : akuma@knightonlineturkiye.web.tr
*/
DECLARE @ItemUpgrade1 int,@ItemUpgrade2 int,@ItemUpgrade3 int,@ItemUpgrade4 int,@ItemUpgrade5 int,@ItemUpgrade6 int,@ItemUpgrade7 int,@ItemUpgrade8 int,@ItemUpgrade9 int,@ItemUpgrade10 int
DECLARE @AccessoryUpgrade1 int,@AccessoryUpgrade2 int,@AccessoryUpgrade3 int,@AccessoryUpgrade4 int,@AccessoryUpgrade5 int,@AccessoryUpgrade6 int,@AccessoryUpgrade7 int,@AccessoryUpgrade8 int,@AccessoryUpgrade9 int,@AccessoryUpgrade10 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 = 7000
-- +5 Upgrade Oran?
SET @ItemUpgrade5 = 8000
-- +6 Upgrade Oran?
SET @ItemUpgrade6 = 3500
-- +7 Upgrade Oran?
SET @ItemUpgrade7 = 2000
-- +8 Upgrade Oran?
SET @ItemUpgrade8 = 500
-- +9 Upgrade Oran?
SET @ItemUpgrade9 = 200
-- +10 Upgrade Oran?
SET @ItemUpgrade10 = 100
/* Percent for Accessory Upgrade */
-- +1 Upgrade Oran?
SET @AccessoryUpgrade1 = 10000
-- +2 Upgrade Oran?
SET @AccessoryUpgrade2 = 10000
-- +3 Upgrade Oran?
SET @AccessoryUpgrade3 = 10000
-- +4 Upgrade Oran?
SET @AccessoryUpgrade4 = 0
-- +5 Upgrade Oran?
SET @AccessoryUpgrade5 = 0
-- +6 Upgrade Oran?
SET @AccessoryUpgrade6 = 0
-- +7 Upgrade Oran?
SET @AccessoryUpgrade7 = 0
-- +8 Upgrade Oran?
SET @AccessoryUpgrade8 = 0
-- +9 Upgrade Oran?
SET @AccessoryUpgrade9 = 0
-- +10 Upgrade Oran?
SET @AccessoryUpgrade10 = 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 = @AccessoryUpgrade1 WHERE nOriginItem LIKE '%1'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade2 WHERE nOriginItem LIKE '%2'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade3 WHERE nOriginItem LIKE '%3'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade4 WHERE nOriginItem LIKE '%4'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade5 WHERE nOriginItem LIKE '%5'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade6 WHERE nOriginItem LIKE '%6'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade7 WHERE nOriginItem LIKE'%7'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade8 WHERE nOriginItem LIKE '%8'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade9 WHERE nOriginItem LIKE '%9'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade10 WHERE nOriginItem LIKE '%0'AND nReqItem1 = 379159000
Kolay Gelsin
/*
# Upgrade Percent Options
# Author : AKUMA
# E-mail : akuma@knightonlineturkiye.web.tr
*/
DECLARE @ItemUpgrade1 int,@ItemUpgrade2 int,@ItemUpgrade3 int,@ItemUpgrade4 int,@ItemUpgrade5 int,@ItemUpgrade6 int,@ItemUpgrade7 int,@ItemUpgrade8 int,@ItemUpgrade9 int,@ItemUpgrade10 int
DECLARE @AccessoryUpgrade1 int,@AccessoryUpgrade2 int,@AccessoryUpgrade3 int,@AccessoryUpgrade4 int,@AccessoryUpgrade5 int,@AccessoryUpgrade6 int,@AccessoryUpgrade7 int,@AccessoryUpgrade8 int,@AccessoryUpgrade9 int,@AccessoryUpgrade10 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 = 7000
-- +5 Upgrade Oran?
SET @ItemUpgrade5 = 8000
-- +6 Upgrade Oran?
SET @ItemUpgrade6 = 3500
-- +7 Upgrade Oran?
SET @ItemUpgrade7 = 2000
-- +8 Upgrade Oran?
SET @ItemUpgrade8 = 500
-- +9 Upgrade Oran?
SET @ItemUpgrade9 = 200
-- +10 Upgrade Oran?
SET @ItemUpgrade10 = 100
/* Percent for Accessory Upgrade */
-- +1 Upgrade Oran?
SET @AccessoryUpgrade1 = 10000
-- +2 Upgrade Oran?
SET @AccessoryUpgrade2 = 10000
-- +3 Upgrade Oran?
SET @AccessoryUpgrade3 = 10000
-- +4 Upgrade Oran?
SET @AccessoryUpgrade4 = 0
-- +5 Upgrade Oran?
SET @AccessoryUpgrade5 = 0
-- +6 Upgrade Oran?
SET @AccessoryUpgrade6 = 0
-- +7 Upgrade Oran?
SET @AccessoryUpgrade7 = 0
-- +8 Upgrade Oran?
SET @AccessoryUpgrade8 = 0
-- +9 Upgrade Oran?
SET @AccessoryUpgrade9 = 0
-- +10 Upgrade Oran?
SET @AccessoryUpgrade10 = 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 = @AccessoryUpgrade1 WHERE nOriginItem LIKE '%1'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade2 WHERE nOriginItem LIKE '%2'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade3 WHERE nOriginItem LIKE '%3'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade4 WHERE nOriginItem LIKE '%4'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade5 WHERE nOriginItem LIKE '%5'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade6 WHERE nOriginItem LIKE '%6'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade7 WHERE nOriginItem LIKE'%7'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade8 WHERE nOriginItem LIKE '%8'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade9 WHERE nOriginItem LIKE '%9'AND nReqItem1 = 379159000
UPDATE ITEM_UPGRADE SET nGenRate = @AccessoryUpgrade10 WHERE nOriginItem LIKE '%0'AND nReqItem1 = 379159000
Kolay Gelsin