1534-18xx-19xx Sorunsuz Uprage Ayarlamak 2021

Y Çevrimdışı

yunus280

Kayıtlı Üye
23 Kasım 2012
692
3
18
İçerik Açılmıştır Teşekkürler :)
/*

# Upgrade Percent Options

# Author : AKUMA

# E-mail : [email protected]

*/



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 = 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 @AccessoryUpgrade1 = 10000

-- +2 Upgrade Oranı

SET @AccessoryUpgrade2 = 7000

-- +3 Upgrade Oranı

SET @AccessoryUpgrade3 = 5000

-- +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




ALINTIDIR...
 
S Çevrimdışı

sorev

Kayıtlı Üye
1 Şubat 2013
535
2
18
31
Cevap: 1534-18xx-19xx Sorunsuz Uprage Ayarlamak



Teşşekurler...
 
G Çevrimdışı

GelGit

Kayıtlı Üye
13 Mayıs 2012
241
0
16
43
Cevap: 1534-18xx-19xx Sorunsuz Uprage Ayarlamak



Paylaşım için teşekkürler.
 
F Çevrimdışı

FLackh

Kayıtlı Üye
28 Mart 2012
380
0
16
34
Cevap: 1534-18xx-19xx Sorunsuz Uprage Ayarlamak



teşekkürler...
 
Üst