Selamlar,

Upgrade Oranlarında Zorluk Çeken Arkadaşlar İçin Çok Basit Bir SQL Kodu Yazdım, Hem Takı Upgrade ni Hemde Item Upgrade ni Ayarlayabileceğiniz, Tamamiyle Sorunsuz Çalışan Bir Kod..

Sadece Değerleri Değiştirin Yeter Örnek Vermeme Gerek Yok Sanırım Gayet Basit Çünkü

Kod:
Kod:
/* 
# Upgrade Percent Options
# Author : AKUMA
# E-mail : 
*/
 
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