Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

70 Questlerinin Upgrade edilmesi için

Konu Bilgileri

Kategori Adı Prosedür & Kod Paylaşımları
Konu Başlığı 70 Questlerinin Upgrade edilmesi için
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
27 May 2013
2,664
2
0
70 questlerinin upgrade edilmesini sağlar









Kod:

INSERT INTO ITEM_UPGRADE VALUES ( 990720, 5001, 'Arrow of ', '+0', 9, 350, 379025000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990721, 5001, 'Arrow of ', '+1', 9, 351, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990722, 5001, 'Arrow of ', '+2', 9, 352, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990723, 5001, 'Arrow of ', '+3', 9, 353, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990724, 5001, 'Arrow of ', '+4', 9, 354, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990725, 5001, 'Arrow of ', '+5', 9, 355, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990726, 5001, 'Arrow of ', '+6', 9, 356, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990727, 5001, 'Arrow of ', '+7', 9, 357, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990728, 5001, 'Arrow of ', '+8', 9, 358, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 1500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990729, 5001, 'Arrow of ', '+9', 9, 359, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990730, 5001, 'Arrow of ', '+10', 9, 360, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990731, 5001, 'Arrow of ', '+1', 9, 351, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990732, 5001, 'Arrow of ', '+2', 9, 352, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990733, 5001, 'Arrow of ', '+3', 9, 353, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990734, 5001, 'Arrow of ', '+4', 9, 354, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990735, 5001, 'Arrow of ', '+5', 9, 355, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990736, 5001, 'Arrow of ', '+6', 9, 356, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990737, 5001, 'Arrow of ', '+7', 9, 357, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 4500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990738, 5001, 'Arrow of ', '+8', 9, 388, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990739, 5001, 'Arrow of ', '+9', 9, 359, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990740, 5001, 'Arrow of ', '+10', 9, 360, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );



INSERT INTO ITEM_UPGRADE VALUES ( 991200, 5001, 'Mace of ', '+0', 11, 324, 379025000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991201, 5001, 'Mace of ', '+1', 11, 371, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991202, 5001, 'Mace of ', '+2', 11, 372, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991203, 5001, 'Mace of ', '+3', 11, 373, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991204, 5001, 'Mace of ', '+4', 11, 374, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991205, 5001, 'Mace of ', '+5', 11, 375, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991206, 5001, 'Mace of ', '+6', 11, 376, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991207, 5001, 'Mace of ', '+7', 11, 377, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991208, 5001, 'Mace of ', '+8', 11, 378, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 1500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991209, 5001, 'Mace of ', '+9', 11, 379, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991210, 5001, 'Mace of ', '+10', 11, 380, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991211, 5001, 'Mace of ', '+1', 11, 371, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991212, 5001, 'Mace of ', '+2', 11, 372, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991213, 5001, 'Mace of ', '+3', 11, 373, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991214, 5001, 'Mace of ', '+4', 11, 374, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991215, 5001, 'Mace of ', '+5', 11, 375, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991216, 5001, 'Mace of ', '+6', 11, 376, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991217, 5001, 'Mace of ', '+7', 11, 377, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 4500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991218, 5001, 'Mace of ', '+8', 11, 378, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991219, 5001, 'Mace of ', '+9', 11, 379, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991220, 5001, 'Mace of ', '+10', 11, 380, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );



INSERT INTO ITEM_UPGRADE VALUES ( 990860, 5001, 'Staff of ', '+0', 10, 355, 379025000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990861, 5001, 'Staff of ', '+1', 10, 571, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990862, 5001, 'Staff of ', '+2', 10, 572, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990863, 5001, 'Staff of ', '+3', 10, 573, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990864, 5001, 'Staff of ', '+4', 10, 574, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990865, 5001, 'Staff of ', '+5', 10, 575, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990866, 5001, 'Staff of ', '+6', 10, 576, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990867, 5001, 'Staff of ', '+7', 10, 577, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990868, 5001, 'Staff of ', '+8', 10, 578, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 1500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990869, 5001, 'Staff of ', '+9', 10, 579, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990870, 5001, 'Staff of ', '+10', 10, 580, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990871, 5001, 'Staff of ', '+1', 10, 571, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990872, 5001, 'Staff of ', '+2', 10, 572, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990873, 5001, 'Staff of ', '+3', 10, 573, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990874, 5001, 'Staff of ', '+4', 10, 574, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990875, 5001, 'Staff of ', '+5', 10, 575, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990876, 5001, 'Staff of ', '+6', 10, 576, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990877, 5001, 'Staff of ', '+7', 10, 577, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 4500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990878, 5001, 'Staff of ', '+8', 10, 578, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990879, 5001, 'Staff of ', '+9', 10, 579, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990880, 5001, 'Staff of ', '+10', 10, 580, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );



INSERT INTO ITEM_UPGRADE VALUES ( 990881, 5001, 'Pole of ', '+0', 10, 351, 379025000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990882, 5001, 'Pole of ', '+1', 10, 581, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990883, 5001, 'Pole of ', '+2', 10, 582, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990884, 5001, 'Pole of ', '+3', 10, 583, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990885, 5001, 'Pole of ', '+4', 10, 584, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990886, 5001, 'Pole of ', '+5', 10, 585, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990887, 5001, 'Pole of ', '+6', 10, 586, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990888, 5001, 'Pole of ', '+7', 10, 587, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990889, 5001, 'Pole of ', '+8', 10, 588, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 1500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990890, 5001, 'Pole of ', '+9', 10, 589, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990991, 5001, 'Pole of ', '+10', 10, 590, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990892, 5001, 'Pole of ', '+1', 10, 581, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990893, 5001, 'Pole of ', '+2', 10, 582, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990894, 5001, 'Pole of ', '+3', 10, 583, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990895, 5001, 'Pole of ', '+4', 10, 584, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990896, 5001, 'Pole of ', '+5', 10, 585, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990897, 5001, 'Pole of ', '+6', 10, 586, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990898, 5001, 'Pole of ', '+7', 10, 587, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 4500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990899, 5001, 'Pole of ', '+8', 10, 588, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990900, 5001, 'Pole of ', '+9', 10, 589, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 990901, 5001, 'Pole of ', '+10', 10, 590, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );



INSERT INTO ITEM_UPGRADE VALUES ( 991300, 5001, 'Shield of ', '+0', 12, 544, 379025000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991301, 5001, 'Shield of ', '+1', 12, 301, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991302, 5001, 'Shield of ', '+2', 12, 302, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991303, 5001, 'Shield of ', '+3', 12, 303, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991304, 5001, 'Shield of ', '+4', 12, 304, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991305, 5001, 'Shield of ', '+5', 12, 305, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991306, 5001, 'Shield of ', '+6', 12, 306, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991307, 5001, 'Shield of ', '+7', 12, 307, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991308, 5001, 'Shield of ', '+8', 12, 308, 379021000, 0, 0, 0, 0, 0, 0, 0, 200000, 8, 1500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991309, 5001, 'Shield of ', '+9', 12, 309, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991310, 5001, 'Shield of ', '+10', 12, 310, 379021000,0, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991311, 5001, 'Shield of ', '+1', 12, 301, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991312, 5001, 'Shield of ', '+2', 12, 302, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991313, 5001, 'Shield of ', '+3', 12, 303, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991314, 5001, 'Shield of ', '+4', 12, 304, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991315, 5001, 'Shield of ', '+5', 12, 305, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 10000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991316, 5001, 'Shield of ', '+6', 12, 306, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 7900, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991317, 5001, 'Shield of ', '+7', 12, 307, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 4500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991318, 5001, 'Shield of ', '+8', 12, 308, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2500, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991319, 5001, 'Shield of ', '+9', 12, 309, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 2000, 1 );

INSERT INTO ITEM_UPGRADE VALUES ( 991320, 5001, 'Shield of ', '+10', 12, 310, 700002000, 379021000, 0, 0, 0, 0, 0, 0, 200000, 8, 1510, 1 );





Kullanımı ...







1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.



2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.



3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.
 

Users Who Are Viewing This Konu (Users: 0, Guests: 1)

Üst Alt