Sorunsuz Item ve Takı Upgrade Oranlarını Ayarlama

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

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

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.

Yukarıdaki Kodu Not Defteri İçinde İndirmek için Tıklayınız.

Technorati Etiketleri: sorunsuz, item, takı, upgrade, oranları, bifrost, valkry, valkrie, usko, cz, maradon, knight, online, 1299, private, serverlar, server, andream, luferson, graypton, bf, ip, kopanel, data, client, pelerin, sembol, patch, yama, hile, speed, hack, mykohack, yardımcı, programlar, ikonlu, 80, skilleri, query, analyzer, kodları

Google Arama Linki :

Sorunsuz Item ve Takı Upgrade Oranlarını Ayarlama

Dipnot

Bu yazı 9 Aralık 2008 Salı günü yazılmıştır. Bulunduğu kategori : Query Analyzer Procedureleri. Yazdığım yazıları RSS 2.0 sistemini kullanarak takip edebilir, dilerseniz yorum yapabilirsiniz.

9 Aralık 2008 Salı by d0FuTr[!] · 1