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