Weapon ve Armor Enchant Scroll Çalıştırmak ve Sundries'ten Çekebilme

Bildiğiniz Üzere 1299 PW'lerde Weapon ve Armor Enchant Scrollar Çalışmamaktadır, Aşağıdaki Adımları Uyguladığınızda Oyuncular USKO Tarzı Sundiresten Çekip Basabilecekler.

Öncelikle Önemli Olan Mutlaka Yapılması Gerekenler ;

Uygulanacak SQL Kodu;
 

Kod:

DELETE FROM ITEM WHERE Num = 389155000
DELETE FROM ITEM WHERE Num = 389156000
DELETE FROM ITEM WHERE Num = 800061000
DELETE FROM ITEM WHERE Num = 800062000
DELETE FROM MAGIC WHERE MagicNum = 500049
DELETE FROM MAGIC WHERE MagicNum = 500050
DELETE FROM MAGIC WHERE MagicNum = 500051
DELETE FROM MAGIC WHERE MagicNum = 500052
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500049
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500050
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500051
DELETE FROM MAGIC_TYPE4 WHERE iNum = 500052

Item Tablosuna Eklenecekler ;

Kod:

INSERT INTO ITEM VALUES (389155000,'Weapon Enchant Scroll (+0)',97,15,0,0,0,0,0,30,1,700000,0,0,1,500049,0,1,99,0,0,0,0,0,0,0,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO ITEM VALUES (389156000,'Armor Enchant Scroll (+0)',97,15,0,0,0,0,0,30,1,300000,0,0,1,500050,0,1,99,0,0,0,0,0,0,0,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO ITEM VALUES (800061000,'Weapon Enchant Scroll (+0)',255,15,0,0,0,0,0,1,30,700000,10000,0,0,500051,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO ITEM VALUES (800062000,'Armor Enchant Scroll (+0)',255,15,0,0,0,0,0,1,30,300000,10000,0,0,500052,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

MAGIC Tablosuna Eklenecekler ;

Kod:

INSERT INTO MAGIC VALUES (500049,'Weapon Enchant Scroll',Weapon Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,389155000,0,0,100,4,0,0,1,0)
INSERT INTO MAGIC VALUES (500050,'Armor Enchant Scroll',Armor Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,389156000,0,0,100,4,0,0,1,0)
INSERT INTO MAGIC VALUES (500051,'Weapon Enchant Scroll',Weapon Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,800061000,0,0,100,4,0,0,1,0)
INSERT INTO MAGIC VALUES (500052,'Armor Enchant Scroll',Armor Enchant Scroll','Weapon Enchant Scroll',0,0,0,0,702,1,0,0,0,0,9,800062000,0,0,100,4,0,0,1,0)

MAGIC_TYPE4 Tablosuna Eklenecekler ;

Kod:

INSERT INTO MAGIC_TYPE4 VALUES (500049,'Weapon Enchant Scroll','Armor Enchant Scroll',13,0,1800,100,100,0,100,5,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (500050,'Armor Enchant Scroll' ,'Armor Enchant Scroll',14,0,1800,100,100,30,100,100,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (500051,'Weapon Enchant Scroll','Armor Enchant Scroll',13,0,1800,100,100,0,100,5,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (500052,'Armor Enchant Scroll','Armor Enchant Scroll',14,0,1800,100,100,30,100,100,100,0,100,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,100)

Google Arama Linki :

Weapon ve Armor Enchant Scroll Çalıştırmak ve Sundries'ten Çekebilme

Dipnot

Bu yazı 12 Eylül 2008 Cuma 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.

12 Eylül 2008 Cuma by d0FuTr[!] · 0