Query Analyzer Procedureleri - 1754 Koxp , Koxp 1754 , 1754 Koxp indir, koxp 1754 indir, koxp download, 1754 Multiclient

20/11/2009

USKO Moradon Slotlari!(AI Server Sorunu Cozulmustur)

1. Query Kodlarimiz :

Kod:

delete from k_npcpos where zoneid = '21'
delete from k_npcpos where npcid = '16011'
delete from k_npcpos where npcid = '14301'
delete from k_npcpos where npcid = '16083'
delete from k_npcpos where npcid = '16082'
delete from k_npcpos where npcid = '16081'

delete from start_position where zoneid = '21'


insert into START_POSITION values (21 , 817 , 432 , 817 , 432 , 10 , 10 , 0 , 0 , 0 , 0)

insert into k_npc values (29003 , '[Armor Merchant]Hesta' , 12200 , 100 , 0 , 0 , 2 , 1 , 21 , 1 , 0 , 1 , 202001 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)
insert into k_npc values (29004 , '[Weapon Merchant]Gargameth' , 31400 , 100 , 0 , 0 , 2 , 7 , 21 , 1 , 0 , 1 , 201001 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12202 , 0 , 0 , 1)
insert into k_npc values (29007 , 'Guard' , 11000 , 100 , 910074311 , 170250270 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 60 , 100 , 0 , 10000 , 0 , 0 , 5000 , 194 , 194 , 3000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21021 , 0 , 0 , 0)
insert into k_npc values (29016 , '[Sundries]Lionel' , 2050 , 100 , 0 , 0 , 2 , 2 , 22 , 1 , 0 , 1 , 255000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)
insert into k_npc values (29019 , 'Iron Scarecrow' , 4083 , 100 , 0 , 0 , 0 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 50000 , 0 , 0 , 1000 , 46 , 46 , 1000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29009 , '[Peddler] Hemes' , 31000 , 125 , 0 , 0 , 2 , 7 , 23 , 1 , 3 , 3 , 0 , 90 , 100 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 21510 , 0 , 0 , 1)
insert into k_npc values (29028 , '[Blacksmith] Heppa' , 31100 , 100 , 0 , 0 , 2 , 7 , 126 , 1 , 3 , 3 , 0 , 80 , 100 , 500 , 100000 , 0 , 0 , 15000 , 375 , 375 , 3000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 20000 , 21510 , 0 , 0 , 1)
insert into k_npc values (24014 , 'Nameless Warrior' , 11000 , 100 , 910074311 , 170250270 , 2 , 7 , 146 , 1 , 3 , 3 , 193 , 80 , 100 , 0 , 10000000 , 0 , 0 , 15000 , 375 , 375 , 5000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 25 , 25 , 25 , 25 , 25 , 25 , 25 , 90 , 7 , 14 , 35 , 20000 , 21510 , 1 , 1 , 1)
insert into k_npc values (29036 , '[Mercenary Adjutant] Lazer' , 2050 , 100 , 910119310 , 910119310 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29037 , '[Mercenary Captain] Cougar' , 31600 , 125 , 0 , 0 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29035 , '[Entrep Trader] Berret' , 12100 , 100 , 0 , 0 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29033 , '[Karus Dispatch] Portma' , 21610 , 100 , 0 , 910126306 , 1 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29034 , '[Elmo Dispatch] Laidas' , 11610 , 100 , 0 , 910126306 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (28999 , '[Tarot Reader] Mekin' , 30900 , 150 , 0 , 0 , 2 , 1 , 71 , 1 , 0 , 1 , 254000 , 60 , 100 , 500 , 30000 , 0 , 0 , 5000 , 194 , 194 , 1000 , 1500 , 2 , 5 , 1000 , 300127 , 300132 , 300133 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)
insert into k_npc values (29039 , '[Coliseum] Artes' , 21610 , 100 , 0 , 0 , 1 , 1 , 136 , 1 , 3 , 3 , 0 , 80 , 100 , 0 , 100000 , 0 , 0 , 15000 , 375 , 375 , 3000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 20000 , 15002 , 0 , 0 , 1)
insert into k_npc values (29002 , '[Sundries]Zarta' , 12100 , 100 , 0 , 0 , 2 , 2 , 22 , 1 , 0 , 1 , 255000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)
insert into k_npc values (29001 , '[InnHostess] Nia' , 30700 , 100 , 0 , 0 , 2 , 7 , 31 , 1 , 0 , 1 , 0 , 50 , 100 , 0 , 50000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 1 , 1 , 2 , 0 , 22000 , 0 , 0 , 1)
insert into k_npc values (19073 , '[Krowaz Dominion] Shozin' , 30600 , 100 , 127410739 , 0 , 1 , 7 , 28 , 1 , 3 , 3 , 193 , 80 , 100 , 0 , 10000000 , 0 , 0 , 15000 , 375 , 375 , 5000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 25 , 25 , 25 , 25 , 25 , 25 , 25 , 90 , 7 , 14 , 35 , 20000 , 21510 , 1 , 1 , 1)
insert into k_npc values (29013 , '[FolkVillage Captain] Kronil' , 22200 , 100 , 0 , 0 , 2 , 7 , 31 , 1 , 0 , 1 , 0 , 50 , 100 , 0 , 50000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 1 , 1 , 2 , 0 , 22000 , 0 , 0 , 1)
insert into k_npc values (29015 , '[Potion] Kisiner' , 31300 , 125 , 0 , 0 , 2 , 7 , 21 , 1 , 0 , 1 , 253000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12103 , 0 , 0 , 1)
insert into k_npc values (29005 , '[Scrolls]Charon' , 30900 , 150 , 0 , 0 , 2 , 1 , 21 , 1 , 0 , 1 , 254000 , 60 , 100 , 500 , 30000 , 0 , 0 , 5000 , 194 , 194 , 1000 , 1500 , 2 , 5 , 1000 , 300127 , 300132 , 300133 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)
insert into k_npc values (29007 , 'Guard' , 11000 , 100 , 910074311 , 170250270 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 60 , 100 , 0 , 10000 , 0 , 0 , 5000 , 194 , 194 , 3000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21021 , 0 , 0 , 0)
insert into k_npc values (29014 , '[Potion Merchant]Clepio' , 31300 , 125 , 0 , 0 , 2 , 7 , 21 , 1 , 0 , 1 , 253000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12103 , 0 , 0 , 1)
insert into k_npc values (29027 , '[Mercenary Officer]' , 21510 , 100 , 0 , 0 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29020 , 'Elmorad Hero Statue' , 30090 , 100 , 0 , 0 , 2 , 7 , 106 , 1 , 4 , 3 , 0 , 90 , 0 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 0 , 0 , 0 , 1)
insert into k_npc values (29008 , 'Chaotic generator' , 30200 , 100 , 0 , 0 , 2 , 0 , 137 , 1 , 1 , 1 , 0 , 100 , 0 , 0 , 700000 , 0 , 0 , 15000 , 642 , 842 , 0 , 1000 , 0 , 0 , 1000 , 0 , 0 , 0 , 30000 , 30000 , 30000 , 30000 , 30000 , 30000 , 30000 , 100 , 5 , 5 , 5 , 0 , 603 , 0 , 0 , 0)
insert into k_npc values (29010 , '[Grand Merchant] Kaishan' , 31900 , 150 , 0 , 0 , 2 , 7 , 34 , 1 , 4 , 3 , 0 , 150 , 100 , 1000 , 120000 , 0 , 0 , 15000 , 375 , 375 , 3000 , 1500 , 2 , 7 , 16000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 150 , 7 , 30 , 35 , 20000 , 21530 , 0 , 0 , 1)
insert into k_npc values (29006 , '[Potion Merchant]Karpis' , 31300 , 125 , 0 , 0 , 2 , 7 , 21 , 1 , 0 , 1 , 253000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12103 , 0 , 0 , 1)
insert into k_npc values (29021 , 'Karus Hero Statue' , 30090 , 100 , 0 , 0 , 1 , 7 , 106 , 1 , 4 , 3 , 0 , 90 , 0 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 0 , 0 , 0 , 1)
insert into k_npc values (29030 , '[Accessory Merchant] Hera' , 31200 , 100 , 0 , 0 , 2 , 7 , 21 , 1 , 0 , 1 , 203002 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 12103 , 0 , 0 , 1)
insert into k_npc values (29012 , '[Sundries]Rabiro' , 11100 , 100 , 0 , 0 , 2 , 2 , 22 , 1 , 0 , 1 , 255000 , 50 , 100 , 300 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 25 , 15000 , 22203 , 0 , 0 , 1)
insert into k_npc values (29011 , 'Guard' , 21000 , 100 , 910074311 , 170250270 , 1 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29017 , 'Leather Scarecrow' , 4081 , 100 , 0 , 0 , 0 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 1000 , 0 , 0 , 1000 , 46 , 46 , 1000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29031 , 'Karus Bulletine Board' , 20004 , 150 , 0 , 0 , 1 , 7 , 26 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29032 , 'Human Bulletine Board' , 20005 , 100 , 0 , 0 , 2 , 7 , 26 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29029 , 'Kaul' , 25500 , 100 , 0 , 0 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29018 , 'Chain Scarecrow' , 4082 , 100 , 0 , 0 , 0 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 25000 , 0 , 0 , 1000 , 46 , 46 , 1000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29019 , 'Iron Scarecrow' , 4083 , 100 , 0 , 0 , 0 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 50000 , 0 , 0 , 1000 , 46 , 46 , 1000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29026 , '[Mercenary Adjutant]' , 2050 , 100 , 910119310 , 910119310 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29000 , '[InnHostess] Neria' , 30700 , 100 , 0 , 0 , 1 , 7 , 31 , 1 , 0 , 1 , 0 , 50 , 100 , 0 , 50000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 1 , 1 , 2 , 0 , 22000 , 0 , 0 , 1)
insert into k_npc values (16011 , 'Patrick [Sentinel]' , 30600 , 100 , 0 , 0 , 2 , 7 , 33 , 1 , 3 , 3 , 0 , 80 , 100 , 0 , 100000 , 0 , 0 , 15000 , 375 , 375 , 3000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 20000 , 21510 , 0 , 0 , 1)
insert into k_npc values (14301 , 'Isaac [Event]' , 30400 , 100 , 0 , 0 , 2 , 7 , 77 , 1 , 3 , 3 , 0 , 80 , 100 , 500 , 100000 , 0 , 0 , 15000 , 375 , 375 , 3000 , 1500 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 20000 , 21510 , 0 , 0 , 1)
insert into k_npc values (16083 , 'Laemith [Forgotten Temple 1]' , 2060 , 100 , 0 , 0 , 2 , 7 , 129 , 1 , 1 , 1 , 0 , 50 , 100 , 0 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 32000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 25 , 0 , 16083 , 0 , 0 , 1)
insert into k_npc values (16082 , 'Laedith [Forgotten Temple 2]' , 2060 , 100 , 0 , 0 , 2 , 7 , 130 , 1 , 1 , 1 , 0 , 50 , 100 , 0 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 32000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 25 , 0 , 16082 , 0 , 0 , 1)
insert into k_npc values (16081 , 'Learth [Forgotten Temple 3]' , 2060 , 100 , 0 , 0 , 2 , 7 , 131 , 1 , 1 , 1 , 0 , 50 , 100 , 0 , 30000 , 0 , 0 , 5000 , 130 , 130 , 1000 , 1500 , 2 , 5 , 32000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 25 , 0 , 16081 , 0 , 0 , 1)
insert into k_npc values (29038 , '[Trainer] Kate' , 31600 , 100 , 0 , 0 , 2 , 7 , 11 , 1 , 1 , 2 , 0 , 30 , 100 , 0 , 30000 , 0 , 0 , 5000 , 46 , 46 , 1000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 100 , 21022 , 0 , 0 , 0)
insert into k_npc values (29023 , '[Manager]Billbor' , 30500 , 100 , 0 , 0 , 2 , 7 , 106 , 1 , 4 , 3 , 0 , 90 , 0 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 90 , 7 , 14 , 35 , 32000 , 0 , 0 , 0 , 1)
insert into k_npc values (29024 , '[Operator] Moira' , 11100 , 100 , 0 , 0 , 2 , 7 , 29 , 1 , 4 , 3 , 0 , 90 , 100 , 0 , 120000 , 0 , 0 , 20000 , 497 , 497 , 4000 , 1500 , 2 , 7 , 1000 , 0 , 0 , 0 , 100 , 100 , 100 , 100 , 100 , 100 , 100 , 90 , 7 , 14 , 35 , 32000 , 21510 , 0 , 0 , 1)

2. Query Kodumuz :

Kod:

insert into K_MONSTER values (28000 , 'Worm' , 700 , 120 , 0 , 0 , 0 , 1 , 0 , 7 , 0 , 0 , 0 , 1 , 250 , 0 , 7 , 25 , 0 , 5 , 1 , 1 , 4 , 2000 , 1 , 2 , 1000 , 28000 , 0 , 0 , 0 , 9 , 9 , 9 , 8 , 9 , 9 , 9 , 75 , 5 , 3 , 40 , 13 , 0 , 0 , 0)
insert into K_MONSTER values (28001 , 'Blood worm' , 700 , 140 , 0 , 0 , 0 , 1 , 0 , 7 , 0 , 0 , 0 , 4 , 800 , 0 , 20 , 80 , 0 , 20 , 2 , 3 , 5 , 2000 , 1 , 4 , 1000 , 28001 , 0 , 0 , 0 , 14 , 14 , 14 , 10 , 14 , 14 , 14 , 75 , 5 , 3 , 40 , 48 , 0 , 0 , 0)
insert into K_MONSTER values (28002 , 'Bandicoot' , 800 , 90 , 0 , 0 , 0 , 1 , 0 , 8 , 0 , 0 , 0 , 2 , 350 , 0 , 11 , 48 , 0 , 10 , 1 , 1 , 3 , 1700 , 3 , 3 , 1500 , 28002 , 0 , 0 , 0 , 10 , 10 , 10 , 9 , 10 , 10 , 10 , 85 , 5 , 3 , 40 , 27 , 0 , 0 , 0)
insert into K_MONSTER values (28003 , 'Scavenger Bandicoot' , 800 , 120 , 0 , 0 , 0 , 1 , 0 , 8 , 0 , 0 , 0 , 7 , 1950 , 0 , 40 , 143 , 0 , 36 , 3 , 5 , 6 , 1700 , 3 , 4 , 1500 , 28003 , 0 , 0 , 0 , 19 , 19 , 19 , 13 , 19 , 19 , 19 , 85 , 5 , 3 , 40 , 86 , 0 , 0 , 0)
insert into K_MONSTER values (28004 , 'Bulcan' , 200 , 100 , 0 , 0 , 0 , 1 , 0 , 2 , 0 , 0 , 0 , 11 , 5050 , 0 , 99 , 253 , 0 , 57 , 6 , 9 , 11 , 1800 , 2 , 3 , 5000 , 28004 , 0 , 0 , 0 , 26 , 26 , 26 , 16 , 26 , 26 , 26 , 100 , 5 , 5 , 45 , 145 , 0 , 0 , 0)
insert into K_MONSTER values (28005 , 'Bulky bulcan' , 200 , 150 , 0 , 0 , 0 , 1 , 0 , 2 , 0 , 0 , 0 , 15 , 10100 , 0 , 169 , 400 , 0 , 78 , 9 , 14 , 17 , 1800 , 2 , 3 , 5000 , 28005 , 0 , 0 , 0 , 33 , 33 , 33 , 20 , 33 , 33 , 33 , 100 , 5 , 5 , 45 , 214 , 0 , 0 , 0)
insert into K_MONSTER values (28006 , 'Kecoon' , 100 , 100 , 120150000 , 0 , 0 , 1 , 0 , 1 , 0 , 0 , 0 , 6 , 1450 , 0 , 32 , 120 , 0 , 31 , 3 , 4 , 3 , 1500 , 2 , 3 , 5000 , 28006 , 0 , 0 , 0 , 18 , 18 , 18 , 13 , 18 , 18 , 18 , 70 , 5 , 5 , 45 , 73 , 0 , 0 , 0)
insert into K_MONSTER values (28007 , 'Kecoon warrior' , 100 , 150 , 130250000 , 0 , 0 , 1 , 0 , 1 , 0 , 0 , 0 , 16 , 11650 , 0 , 190 , 443 , 0 , 83 , 10 , 15 , 16 , 1500 , 2 , 3 , 5000 , 28007 , 0 , 0 , 0 , 34 , 34 , 34 , 21 , 34 , 34 , 34 , 70 , 5 , 5 , 45 , 233 , 0 , 0 , 0)
insert into K_MONSTER values (28008 , 'Kecoon captain' , 100 , 150 , 130450000 , 0 , 0 , 1 , 0 , 1 , 0 , 0 , 0 , 20 , 19100 , 0 , 352 , 642 , 0 , 138 , 14 , 33 , 25 , 1500 , 2 , 3 , 5000 , 28008 , 0 , 0 , 0 , 42 , 42 , 42 , 25 , 42 , 42 , 42 , 70 , 5 , 5 , 45 , 312 , 0 , 0 , 0)
insert into K_MONSTER values (28009 , 'Gavolt' , 300 , 100 , 0 , 0 , 0 , 1 , 0 , 3 , 0 , 0 , 0 , 16 , 11650 , 0 , 190 , 443 , 0 , 83 , 10 , 15 , 20 , 1800 , 2 , 4 , 5000 , 28009 , 0 , 0 , 0 , 34 , 34 , 34 , 21 , 34 , 34 , 34 , 70 , 5 , 5 , 45 , 153 , 0 , 0 , 0)
insert into K_MONSTER values (28010 , 'Giant gavolt' , 300 , 150 , 0 , 0 , 0 , 1 , 0 , 3 , 0 , 0 , 0 , 18 , 15150 , 0 , 238 , 537 , 0 , 93 , 11 , 19 , 24 , 1800 , 2 , 4 , 5000 , 28010 , 0 , 0 , 0 , 38 , 38 , 38 , 22 , 38 , 38 , 38 , 70 , 5 , 5 , 45 , 182 , 0 , 0 , 0)
insert into K_MONSTER values (28011 , 'Fury gavolt' , 300 , 120 , 0 , 0 , 0 , 1 , 0 , 3 , 0 , 0 , 0 , 20 , 18950 , 0 , 352 , 642 , 0 , 115 , 14 , 33 , 32 , 1800 , 2 , 4 , 5000 , 28011 , 0 , 0 , 0 , 33 , 33 , 33 , 25 , 33 , 33 , 33 , 70 , 5 , 5 , 45 , 212 , 0 , 0 , 0)
insert into K_MONSTER values (28012 , 'Bulture' , 200 , 180 , 0 , 0 , 0 , 1 , 0 , 2 , 0 , 0 , 0 , 19 , 17050 , 0 , 265 , 588 , 0 , 98 , 13 , 20 , 27 , 1800 , 2 , 3 , 5000 , 28012 , 0 , 0 , 0 , 39 , 39 , 39 , 24 , 39 , 39 , 39 , 100 , 5 , 5 , 45 , 292 , 0 , 0 , 0)
insert into K_MONSTER values (28013 , 'Giant bulcan' , 200 , 200 , 0 , 0 , 0 , 1 , 0 , 2 , 0 , 0 , 0 , 17 , 13350 , 0 , 214 , 489 , 0 , 88 , 10 , 17 , 22 , 1800 , 2 , 3 , 5000 , 28013 , 0 , 0 , 0 , 36 , 36 , 36 , 21 , 36 , 36 , 36 , 100 , 5 , 5 , 45 , 252 , 0 , 0 , 0)
insert into K_MONSTER values (28014 , 'silan' , 210 , 90 , 0 , 0 , 0 , 1 , 0 , 2 , 0 , 0 , 0 , 20 , 9450 , 0 , 705 , 642 , 0 , 104 , 14 , 22 , 50 , 1800 , 2 , 3 , 5000 , 28014 , 0 , 0 , 0 , 22 , 22 , 22 , 22 , 22 , 22 , 22 , 100 , 3 , 5 , 30 , 312 , 0 , 0 , 0)
insert into K_MONSTER values (28015 , 'Werewolf' , 500 , 120 , 190450000 , 0 , 0 , 1 , 0 , 5 , 0 , 0 , 0 , 23 , 25950 , 0 , 625 , 820 , 0 , 132 , 17 , 42 , 35 , 1500 , 4 , 5 , 1000 , 28015 , 0 , 0 , 0 , 36 , 36 , 36 , 27 , 36 , 36 , 36 , 175 , 5 , 5 , 60 , 314 , 0 , 0 , 0)
insert into K_MONSTER values (28016 , 'Gloomwing' , 300 , 100 , 0 , 0 , 0 , 1 , 0 , 3 , 0 , 0 , 0 , 24 , 28650 , 0 , 512 , 886 , 0 , 138 , 19 , 45 , 47 , 1800 , 2 , 4 , 2000 , 28016 , 0 , 0 , 0 , 38 , 38 , 38 , 27 , 38 , 38 , 38 , 70 , 5 , 5 , 45 , 280 , 0 , 0 , 0)
insert into K_MONSTER values (28017 , 'Glyptodont' , 400 , 100 , 0 , 0 , 0 , 1 , 0 , 4 , 0 , 0 , 0 , 34 , 65900 , 0 , 2206 , 1731 , 0 , 462 , 36 , 87 , 186 , 2500 , 2 , 4 , 10000 , 28017 , 0 , 0 , 0 , 50 , 50 , 50 , 36 , 50 , 50 , 50 , 425 , 5 , 7 , 45 , 574 , 0 , 0 , 0)
insert into K_MONSTER values (28020 , 'Pincers scorpion' , 900 , 130 , 0 , 0 , 0 , 1 , 0 , 9 , 0 , 0 , 0 , 30 , 4865 , 0 , 970 , 1351 , 0 , 306 , 28 , 69 , 83 , 1500 , 2 , 5 , 2000 , 28020 , 300101 , 0 , 0 , 45 , 45 , 45 , 33 , 45 , 45 , 45 , 100 , 5 , 10 , 60 , 394 , 0 , 2 , 0)
insert into K_MONSTER values (28021 , 'paralyzer' , 900 , 140 , 0 , 0 , 0 , 1 , 0 , 9 , 0 , 0 , 0 , 32 , 56800 , 0 , 1121 , 1533 , 0 , 326 , 32 , 78 , 96 , 1500 , 2 , 6 , 3000 , 28021 , 300101 , 0 , 0 , 48 , 48 , 48 , 34 , 48 , 48 , 48 , 100 , 5 , 10 , 60 , 436 , 0 , 2 , 0)
insert into K_MONSTER values (28022 , 'Orc Watcher' , 1601 , 120 , 130250000 , 170150000 , 0 , 0 , 1 , 16 , 0 , 0 , 0 , 30 , 24300 , 0 , 318 , 500 , 0 , 240 , 375 , 10 , 124 , 1500 , 2 , 5 , 5000 , 28022 , 0 , 0 , 0 , 91 , 91 , 91 , 91 , 91 , 91 , 49 , 100 , 5 , 5 , 45 , 373 , 0 , 0 , 0)
insert into K_MONSTER values (28023 , 'Dire wolf' , 500 , 150 , 190450000 , 0 , 0 , 1 , 0 , 5 , 0 , 0 , 0 , 33 , 61250 , 0 , 1373 , 1631 , 0 , 224 , 34 , 82 , 104 , 1500 , 5 , 5 , 5000 , 28023 , 0 , 0 , 0 , 49 , 49 , 49 , 36 , 49 , 49 , 49 , 175 , 5 , 5 , 60 , 548 , 0 , 0 , 0)
insert into K_MONSTER values (28024 , 'Shadow seeker' , 500 , 140 , 190450000 , 0 , 0 , 1 , 0 , 5 , 0 , 0 , 0 , 29 , 44850 , 0 , 1028 , 1264 , 0 , 167 , 26 , 64 , 60 , 1500 , 4 , 5 , 1500 , 28024 , 0 , 0 , 0 , 44 , 44 , 44 , 32 , 44 , 44 , 44 , 175 , 5 , 5 , 60 , 448 , 0 , 0 , 0)
insert into K_MONSTER values (28025 , 'Smilodon' , 600 , 100 , 0 , 0 , 0 , 1 , 0 , 6 , 0 , 0 , 0 , 37 , 81400 , 0 , 1564 , 2058 , 0 , 201 , 42 , 103 , 164 , 1200 , 5 , 6 , 1500 , 28025 , 0 , 0 , 0 , 63 , 63 , 63 , 38 , 54 , 54 , 54 , 165 , 5 , 10 , 60 , 656 , 0 , 0 , 0)
insert into K_MONSTER values (28026 , 'Wild smilodon' , 600 , 100 , 0 , 0 , 0 , 1 , 0 , 6 , 0 , 0 , 0 , 39 , 92900 , 0 , 1769 , 2296 , 0 , 212 , 47 , 115 , 187 , 1200 , 5 , 7 , 2000 , 28026 , 0 , 0 , 0 , 67 , 67 , 67 , 40 , 56 , 56 , 56 , 165 , 5 , 10 , 60 , 712 , 0 , 0 , 0)
insert into K_MONSTER values (28027 , 'Keilan' , 210 , 90 , 0 , 0 , 0 , 1 , 0 , 2 , 0 , 0 , 0 , 40 , 99050 , 0 , 1342 , 2422 , 0 , 208 , 49 , 81 , 50 , 1800 , 2 , 3 , 5000 , 28027 , 0 , 0 , 0 , 32 , 32 , 32 , 32 , 32 , 32 , 32 , 100 , 3 , 5 , 30 , 819 , 0 , 0 , 0)
insert into K_MONSTER values (28028 , 'Skeleton' , 1100 , 100 , 121510000 , 0 , 0 , 1 , 0 , 11 , 0 , 0 , 0 , 31 , 52600 , 0 , 1193 , 1440 , 0 , 210 , 30 , 73 , 89 , 1500 , 2 , 5 , 5000 , 28028 , 0 , 0 , 0 , 46 , 86 , 86 , 60 , 86 , 86 , 46 , 100 , 5 , 7 , 60 , 415 , 0 , 0 , 0)
insert into K_MONSTER values (28029 , 'undying' , 1000 , 100 , 0 , 0 , 0 , 1 , 0 , 10 , 0 , 0 , 0 , 33 , 61250 , 0 , 1202 , 1631 , 0 , 336 , 34 , 82 , 104 , 1500 , 2 , 4 , 5000 , 28029 , 0 , 0 , 0 , 49 , 91 , 91 , 63 , 91 , 91 , 49 , 100 , 5 , 7 , 45 , 548 , 0 , 0 , 0)
insert into K_MONSTER values (28030 , 'Battalion' , 1000 , 100 , 0 , 0 , 0 , 1 , 0 , 10 , 0 , 0 , 0 , 27 , 378540 , 0 , 769 , 1103 , 0 , 233 , 23 , 56 , 68 , 2000 , 2 , 4 , 5000 , 28030 , 0 , 0 , 0 , 42 , 75 , 75 , 52 , 75 , 75 , 42 , 100 , 5 , 7 , 45 , 402 , 0 , 0 , 0)
insert into K_MONSTER values (28031 , 'Rotten Eyes' , 1000 , 100 , 0 , 0 , 0 , 1 , 0 , 10 , 0 , 0 , 0 , 30 , 48650 , 0 , 970 , 1351 , 0 , 306 , 28 , 69 , 110 , 2000 , 2 , 4 , 5000 , 28031 , 0 , 0 , 0 , 45 , 84 , 84 , 58 , 84 , 84 , 45 , 100 , 5 , 7 , 45 , 472 , 0 , 0 , 0)
insert into K_MONSTER values (28032 , 'Death knight' , 1100 , 150 , 121510000 , 0 , 0 , 1 , 0 , 11 , 0 , 0 , 0 , 45 , 133850 , 0 , 2846 , 3115 , 0 , 324 , 63 , 155 , 241 , 1500 , 2 , 6 , 5000 , 28032 , 0 , 0 , 0 , 63 , 121 , 121 , 84 , 121 , 121 , 63 , 100 , 5 , 7 , 60 , 746 , 0 , 0 , 0)
insert into K_MONSTER values (28033 , 'Skeleton knight' , 1100 , 130 , 121510000 , 0 , 0 , 1 , 0 , 11 , 0 , 0 , 0 , 35 , 70850 , 0 , 1572 , 1836 , 0 , 238 , 38 , 93 , 119 , 1500 , 2 , 5 , 5000 , 28033 , 0 , 0 , 0 , 51 , 96 , 96 , 67 , 96 , 96 , 51 , 100 , 5 , 7 , 60 , 501 , 0 , 0 , 0)

3. ve Sonuncu Query Kodumuz :

Kod:

Insert Into [K_NPCPOS] Values (21,29010,100,0,0,0,0,816,692,816,692,816,692,816,692,1,4400,0,11,NULL)
Insert Into [K_NPCPOS] Values (21,29006,100,0,0,0,0,856,562,856,562,856,562,856,562,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29021,100,1,3,0,0,778,685,778,685,778,685,778,685,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29030,100,0,0,0,0,696,620,696,620,696,620,696,620,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29012,100,0,0,0,0,419,545,419,545,419,545,419,545,1,1800,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29011,100,1,3,0,0,795,491,795,491,795,491,795,491,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29017,100,1,3,0,0,758,423,758,423,758,423,758,423,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29017,100,1,3,0,0,775,406,775,406,775,406,775,406,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,921,480,921,480,921,480,921,480,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,905,481,905,481,905,481,905,481,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,910,475,910,475,910,475,910,475,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,919,473,919,473,919,473,919,473,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29018,100,1,3,0,0,768,415,768,415,768,415,768,415,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29019,100,1,3,0,0,778,415,778,415,778,415,778,415,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29026,100,0,0,0,0,755,529,755,529,755,529,755,529,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29000,100,0,0,0,0,770,651,770,651,770,651,770,651,1,60,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29017,100,1,3,0,0,758,415,758,415,758,415,758,415,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29038,100,1,3,0,0,886,477,886,477,886,477,886,477,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,905,469,905,469,905,469,905,469,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,897,476,897,476,897,476,897,476,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29029,100,1,3,0,0,898,484,898,484,898,484,898,484,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,16083,100,0,0,0,0,806,922,806,922,806,922,806,922,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,16082,100,0,0,0,0,816,922,816,922,816,922,816,922,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,16081,100,0,0,0,0,826,922,826,922,826,922,826,922,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29011,100,1,3,0,0,801,491,801,491,801,491,801,491,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29023,100,1,3,0,0,822,657,822,657,822,657,822,657,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29018,100,1,3,0,0,768,423,768,423,768,423,768,423,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,112,1,0,0,0,0,638,265,638,265,638,265,638,265,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,301,1,0,0,0,0,556,238,556,238,556,238,556,238,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,302,1,0,0,0,0,513,229,513,229,513,229,513,229,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,204,1,0,0,0,0,461,330,461,330,461,330,461,330,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,203,1,0,0,0,0,415,390,415,390,415,390,415,390,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,207,1,0,0,0,0,421,421,421,421,421,421,421,421,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,207,1,0,0,0,0,390,424,390,424,390,424,390,424,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,500,1,0,0,0,0,387,452,387,452,387,452,387,452,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,304,1,0,0,0,0,476,583,476,583,476,583,476,583,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,304,1,0,0,0,0,502,598,502,598,502,598,502,598,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,903,1,0,0,0,0,432,730,432,730,432,730,432,730,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,904,1,0,0,0,0,418,768,418,768,418,768,418,768,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1671,1,0,0,0,0,332,703,332,703,332,703,332,703,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1671,1,0,0,0,0,335,668,335,668,335,668,335,668,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,505,1,0,0,0,0,521,781,521,781,521,781,521,781,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,505,1,0,0,0,0,566,763,566,763,566,763,566,763,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,553,1,0,0,0,0,543,841,543,841,543,841,543,841,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,553,1,0,0,0,0,571,851,571,851,571,851,571,851,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,600,1,0,0,0,0,498,821,498,821,498,821,498,821,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,600,1,0,0,0,0,452,820,452,820,452,820,452,820,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,300,1,0,0,0,0,578,259,578,259,578,259,578,259,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,300,1,0,0,0,0,438,613,438,613,438,613,438,613,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,602,1,0,0,0,0,484,863,484,863,484,863,484,863,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,602,1,0,0,0,0,459,873,459,873,459,873,459,873,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,257,1,0,0,0,0,351,758,351,758,351,758,351,758,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,257,1,0,0,0,0,348,782,348,782,348,782,348,782,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1100,1,0,0,0,0,355,849,355,849,355,849,355,849,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1100,1,0,0,0,0,389,873,389,873,389,873,389,873,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1004,1,0,0,0,0,319,889,319,889,319,889,319,889,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1004,1,0,0,0,0,295,881,295,881,295,881,295,881,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1002,1,0,0,0,0,287,934,287,934,287,934,287,934,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1002,1,0,0,0,0,310,946,310,946,310,946,310,946,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1003,1,0,0,0,0,359,954,359,954,359,954,359,954,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1001,1,0,0,0,0,163,935,163,935,163,935,163,935,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1001,1,0,0,0,0,189,906,189,906,189,906,189,906,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1109,1,0,0,0,0,53,431,53,431,53,431,53,431,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1109,1,0,0,0,0,231,176,231,176,231,176,231,176,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29003,100,0,0,0,0,787,596,787,596,787,596,787,596,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29004,100,0,0,0,0,787,587,787,587,787,587,787,587,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29007,100,0,0,0,0,836,491,836,491,836,491,836,491,1,3600,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29016,100,0,0,0,0,84,923,84,923,84,923,84,923,1,1800,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29019,100,1,3,0,0,778,423,778,423,778,423,778,423,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29009,100,0,0,0,0,908,553,908,553,908,553,908,553,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29028,100,0,0,0,0,729,579,729,579,729,579,729,579,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,24014,100,0,0,0,0,344,884,344,884,344,884,344,884,1,32000,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29036,100,0,0,0,0,425,528,425,528,425,528,425,528,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29037,100,0,0,0,0,748,528,748,528,748,528,748,528,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29035,100,0,0,0,0,392,550,392,550,392,550,392,550,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29033,100,1,3,0,0,880,359,880,359,880,359,880,359,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29034,100,1,3,0,0,797,324,797,324,797,324,797,324,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,28999,100,0,0,0,0,856,592,856,592,856,592,856,592,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29039,100,0,0,0,0,757,481,757,481,757,481,757,481,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29002,100,0,0,0,0,872,531,872,531,872,531,872,531,1,1800,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29001,100,0,0,0,0,861,650,861,650,861,650,861,650,1,60,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,19073,100,0,0,0,0,690,553,690,553,690,553,690,553,1,32000,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29013,100,0,0,0,0,408,555,408,555,408,555,408,555,1,60,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29015,100,0,0,0,0,48,897,48,897,48,897,48,897,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29005,100,0,0,0,0,820,607,820,607,820,607,820,607,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29007,100,0,0,0,0,842,491,842,491,842,491,842,491,1,3600,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29014,100,0,0,0,0,376,572,376,572,376,572,376,572,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29027,100,0,0,0,0,742,529,742,529,742,529,742,529,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29020,100,1,3,0,0,852,685,852,685,852,685,852,685,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29008,100,0,0,0,0,702,527,702,527,702,527,702,527,1,10,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29018,100,1,3,0,0,775,398,775,398,775,398,775,398,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29019,100,1,3,0,0,775,389,775,389,775,389,775,389,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29024,100,0,0,0,0,805,771,805,771,805,771,805,771,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,750,1,0,0,0,0,642,426,642,426,642,426,642,426,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,750,1,0,0,0,0,616,391,616,391,616,391,616,391,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,752,1,0,0,0,0,603,429,603,429,603,429,603,429,10,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,804,1,0,0,0,0,636,461,636,461,636,461,636,461,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,801,1,0,0,0,0,623,475,623,475,623,475,623,475,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,801,1,0,0,0,0,599,468,599,468,599,468,599,468,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,200,1,0,0,0,0,550,411,550,411,550,411,550,411,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,200,1,0,0,0,0,542,376,542,376,542,376,542,376,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,201,1,0,0,0,0,513,434,513,434,513,434,513,434,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,201,1,0,0,0,0,509,408,509,408,509,408,509,408,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,101,1,0,0,0,0,597,329,597,329,597,329,597,329,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,101,1,0,0,0,0,620,333,620,333,620,333,620,333,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,112,1,0,0,0,0,644,305,644,305,644,305,644,305,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,112,1,0,0,0,0,616,293,616,293,616,293,616,293,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,112,1,0,0,0,0,669,277,669,277,669,277,669,277,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,112,1,0,0,0,0,638,265,638,265,638,265,638,265,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,301,1,0,0,0,0,556,238,556,238,556,238,556,238,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,302,1,0,0,0,0,513,229,513,229,513,229,513,229,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,204,1,0,0,0,0,461,330,461,330,461,330,461,330,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,203,1,0,0,0,0,415,390,415,390,415,390,415,390,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,207,1,0,0,0,0,421,421,421,421,421,421,421,421,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,207,1,0,0,0,0,390,424,390,424,390,424,390,424,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,500,1,0,0,0,0,387,452,387,452,387,452,387,452,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,304,1,0,0,0,0,476,583,476,583,476,583,476,583,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,304,1,0,0,0,0,502,598,502,598,502,598,502,598,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,903,1,0,0,0,0,432,730,432,730,432,730,432,730,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,904,1,0,0,0,0,418,768,418,768,418,768,418,768,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1671,1,0,0,0,0,332,703,332,703,332,703,332,703,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1671,1,0,0,0,0,335,668,335,668,335,668,335,668,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,505,1,0,0,0,0,521,781,521,781,521,781,521,781,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,505,1,0,0,0,0,566,763,566,763,566,763,566,763,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,553,1,0,0,0,0,543,841,543,841,543,841,543,841,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,553,1,0,0,0,0,571,851,571,851,571,851,571,851,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,600,1,0,0,0,0,498,821,498,821,498,821,498,821,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,600,1,0,0,0,0,452,820,452,820,452,820,452,820,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,300,1,0,0,0,0,578,259,578,259,578,259,578,259,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,300,1,0,0,0,0,438,613,438,613,438,613,438,613,5,20,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,602,1,0,0,0,0,484,863,484,863,484,863,484,863,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,602,1,0,0,0,0,459,873,459,873,459,873,459,873,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,257,1,0,0,0,0,351,758,351,758,351,758,351,758,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,257,1,0,0,0,0,348,782,348,782,348,782,348,782,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1100,1,0,0,0,0,355,849,355,849,355,849,355,849,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1100,1,0,0,0,0,389,873,389,873,389,873,389,873,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1004,1,0,0,0,0,319,889,319,889,319,889,319,889,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1004,1,0,0,0,0,295,881,295,881,295,881,295,881,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1002,1,0,0,0,0,287,934,287,934,287,934,287,934,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1002,1,0,0,0,0,310,946,310,946,310,946,310,946,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1003,1,0,0,0,0,359,954,359,954,359,954,359,954,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1001,1,0,0,0,0,163,935,163,935,163,935,163,935,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1001,1,0,0,0,0,189,906,189,906,189,906,189,906,5,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1109,1,0,0,0,0,53,431,53,431,53,431,53,431,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,1109,1,0,0,0,0,231,176,231,176,231,176,231,176,7,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29003,100,0,0,0,0,787,596,787,596,787,596,787,596,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29004,100,0,0,0,0,787,587,787,587,787,587,787,587,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29007,100,0,0,0,0,836,491,836,491,836,491,836,491,1,3600,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29016,100,0,0,0,0,84,923,84,923,84,923,84,923,1,1800,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29019,100,1,3,0,0,778,423,778,423,778,423,778,423,1,15,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29009,100,0,0,0,0,908,553,908,553,908,553,908,553,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29028,100,0,0,0,0,729,579,729,579,729,579,729,579,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,24014,100,0,0,0,0,344,884,344,884,344,884,344,884,1,32000,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29036,100,0,0,0,0,425,528,425,528,425,528,425,528,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29037,100,0,0,0,0,748,528,748,528,748,528,748,528,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29035,100,0,0,0,0,392,550,392,550,392,550,392,550,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29033,100,1,3,0,0,880,359,880,359,880,359,880,359,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29034,100,1,3,0,0,797,324,797,324,797,324,797,324,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,28999,100,0,0,0,0,856,592,856,592,856,592,856,592,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29039,100,0,0,0,0,757,481,757,481,757,481,757,481,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29002,100,0,0,0,0,872,531,872,531,872,531,872,531,1,1800,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29001,100,0,0,0,0,861,650,861,650,861,650,861,650,1,60,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,19073,100,0,0,0,0,690,553,690,553,690,553,690,553,1,32000,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29013,100,0,0,0,0,408,555,408,555,408,555,408,555,1,60,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29015,100,0,0,0,0,48,897,48,897,48,897,48,897,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29005,100,0,0,0,0,820,607,820,607,820,607,820,607,1,4400,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29007,100,0,0,0,0,842,491,842,491,842,491,842,491,1,3600,0,2,NULL)
Insert Into [K_NPCPOS] Values (21,29014,100,0,0,0,0,376,572,376,572,376,572,376,572,1,4400,0,3,NULL)
Insert Into [K_NPCPOS] Values (21,29027,100,0,0,0,0,742,529,742,529,742,529,742,529,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29020,100,1,3,0,0,852,685,852,685,852,685,852,685,1,30,0,0,NULL)
Insert Into [K_NPCPOS] Values (21,29008,100,0,0,0,0,702,527,702,527,702,527,702,527,1,10,0,0,NULL)

Moradondaki Kullandigim SMD : http://s1.dosya.tc/UskoMoradonMap.rar.html

Bu sayfayı paylaşın.

Sayfa Linki: Site kodu: Forum kodu:

Kategori: Query Analyzer Procedureleri | Yorum (yok) Yorum yaz! Kalıcı Bağlantı

20/11/2009

Non-Trade Armor Yapimi

-TBL Editor
-DXT Editor(Onerilen : http://rs583.rapidshare.com/files/190160408/N3TexViewer.rar )
-Notepad veya Word (Aklinizda Tutamicaginizi Varsayarak)

Asagidaki Islemi Yaparken Degistirmek Istediginiz Item Kodunu Saklayin Lasim Olucaktir(Notepad veya Worde Kayit Edebilirsiniz.)

Bu Islemi Yaptiktan Sonra Clientimizin Icinde Bulunan Item Klasorune Arama Yapiyoruz ve DXT Giysi Aramasina Basliyoruz
Kaydettigimiz Item Kodunu aliyoruz , Benim Kodum : 255001000
Burda Bize Lasim olan Kismi Sadece Ilk Kodu Yani "2".

Simdi Ben Sadece Sizler icin Human Disi Rogue`yi Yapacagim.

Human Female(Kiz,Bayan,Disi Nasil Isterseniz) Rogue icin Gerekli Kodumuz :
2_4513_10_0 - >> Bu Human Rogue Female Pauldron(Gogusluk)

Kaynak : ko-cuce.com

Bu sayfayı paylaşın.

Sayfa Linki: Site kodu: Forum kodu:

Kategori: Query Analyzer Procedureleri | Yorum (yok) Yorum yaz! Kalıcı Bağlantı

20/11/2009

Quest Oluşturmak

İlk önce quest_content_us.tbl dosyamızı açıyoruz.
Burada ilk sütun bize görevlerin numaralarını söyler.
bu numara 1 - 255 arasında olmalıdır.
1 - 255 arasında eskiden bulunmayan bir numara yazıyoruz.

Örnek vereyim;

Kod:

no   level class isim açıklama gerekenler

sırasına göre yazıyoruz.
(class için; (yani görevi kimler yapabilir)
1= warrior
2= rogue
3= mage
4= Priest
5= Hepsi)

Kod:

71    30    5    Herkes yapsın    Ahmete git.     300 e 500 koordinatlarındaki ahmet'ten mehmet kağıdını al şevkete gönder.

Şimdi tbl kısmını hallettiğimize göre server kısmına gelelim;

Hangi npc'ye quest vereceksek o npc'yi açıyoruz.

Ben var olan bir quest'i örnek olarak kullanıp açıklayacağım..

Kod:

EVENT 20701 ; Göreve tıkladı ilk neler olacak acaba?
E RUN_EVENT 20702
E RUN_EVENT 20704
END

EVENT 20702
A CHECK_LV 1 19 ;1 ile 19 level arası ise ;
E SAY -1 -1 20709 -1 -1 -1 -1 -1 -1 -1 -1 -1 ;Levelinin yetmediğini söyle.
E RETURN
END

EVENT 20704
E RUN_EVENT 20705
E RUN_EVENT 20710
E RUN_EVENT 20713
END

EVENT 20705; ÁøÇàÁßÀÏ ¶§
A CHECK_EXIST_EVENT 71 1 ; Daha önce bu görevi alıp tamamlamamış mı?
E RUN_EVENT 20720
END

EVENT 20710; ¿Ï·áÇßÀ» ¶§
A CHECK_EXIST_EVENT 71 2 ;Daha önce bu görevi alıp tamamlamış mı?
E SAY -1 -1 20714 -1 -1 -1 -1 -1 -1 -1 -1 -1
E RETURN
END

EVENT 20713;Ã³À½ÀÏ¶§
A CHECK_EXIST_EVENT 71 0  ; Daha önce bu görevi alır gibi yapmış mı? (bu kod tamamen mantıksız :D)
E SAY -1 20714 20701 20702 -1 -1 -1 -1 -1 -1 -1 -1
E RETURN
END

EVENT 20714
E SELECT_MSG -1 20703 20701 20715 20702 20716 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END

EVENT 20715 
E SELECT_MSG -1 20705 20703 20740 20704 20745 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END

EVENT 20716
E SAY -1 -1 20704 -1 -1 -1 -1 -1 -1 -1 -1 -1
E RETURN
END ; Hata mesajları ile ilgili şeyler.

EVENT 20720
E RUN_EVENT 20725
E RUN_EVENT 20730
END

EVENT 20725
A HOWMUCH_ITEM 910017000 3 9999 ;÷÷Ó¨ãóß¾Úªù¡ 
E RUN_EVENT 20735
END

EVENT 20730 ;ãóß¾Úªù¡Üôğë
A HOWMUCH_ITEM 910017000 0 2;÷÷Ó¨ãóß¾Úªù¡
E SAY -1 -1 20710 -1 -1 -1 -1 -1 -1 -1 -1 -1
E RETURN
END 

EVENT 20735 ;ãóß¾Úªù¡ğë? 
E SELECT_MSG -1 20711 20705 20750 20706 20746 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1
END ; Görev detayları...

EVENT 20740;?öâ 
E SAY -1 -1 20708 -1 -1 -1 -1 -1 -1 -1 -1 -1
E SAVE_EVENT 71 1 ; Görevi Alınmış olarak kaydet...
E RETURN  
END

EVENT 20745 ;ÜôÎ·öâ 
E SAY -1 -1 20704 -1 -1 -1 -1 -1 -1 -1 -1 -1
E RETURN
END

EVENT 20746 ;?ë¶ÊğîÜÌ¸ã§ê¬ 
E SAY -1 -1 20712 -1 -1 -1 -1 -1 -1 -1 -1 -1
E RETURN
END ; Görev detayları...
 
EVENT 20750 ;æğãıÍëìÌîÜüŞÜÃ 
E SAY -1 -1 20713 -1 -1 -1 -1 -1 -1 -1 -1 -1
E ROB_ITEM 910017000 3
E EXP_CHANGE 5000
E GIVE_ITEM 389013000 10
E GIVE_ITEM 389018000 10 ; Görev ödüllerini ver.
E SAVE_EVENT 71 2 ;Görevi yapılmış olarak kaydet.
E RETURN
END

Bu şekilde görev ekleyebilirsiniz..
Herhangi bir görevi sınırsız sayıda yaptırabilir , veya 1 kereye mahsus yapılsın şekilde ayarlayabilirsiniz..

Bu sayfayı paylaşın.

Sayfa Linki: Site kodu: Forum kodu:

Kategori: Query Analyzer Procedureleri | Yorum (yok) Yorum yaz! Kalıcı Bağlantı

1/9/2009

Oto Ban - Duperleri Oto Banla - Otomatik Ban Sistemi

Merhaba Arkadaşlar
Server Sahiplerinin Çok İşine YarayacakBir Program Dupecileri Otomatik Banlıyor Sizin Yapmanız Gereken Her Restten Sonra veya Server Online İken Programı Çalıştırıp Temizle Tuşuna Basmak Gayet basit bir sistem bunu Uyguladığınızda Kişiler banlanıyor ve Kayıt Defterine Banlanan dupeciler ve itemleri geçiyor..

Gayet basit ^^ Bağlantıyı yaptıktan sonra dupeciler listede gozukuyor.Türk halkının öfkesini bilerek program ban kayıtlarını kayit.ini de tutuyor.Biri gelip size "Neden banlandım ? " dediği zaman en azından bir kanıt bulunabilir elinizde Gülümseme

[ Ban Tarihi ]
Karakter Adı = Dupe Item

şeklinde kaydediliyor.Biri neden banlandım diye sorarsa elinizin altında bulunsun diye yaptım Kahkaha

Bağlantıyı yapamayanlar Inventory Editor konumdaki guide da bağlantı bölümünü okusunlar ..

Her zamanki gibi önce yukle.bat ı çalıştırıyorsunuz.Kusura bakmayın bu yukle.bat ı sonraki projelerde kaldıracağım sadece exe olacak Gülümseme

Teşekkürler - Trayhoper

: DOWNLOAD :
http://rapidshare.com/files/241461035/Otoban_Polisi.rar

Bu sayfayı paylaşın.

Sayfa Linki: Site kodu: Forum kodu:

Kategori: Query Analyzer Procedureleri | Yorum (yok) Yorum yaz! Kalıcı Bağlantı

1/9/2009

Usko Npc İşaretleri

Merhaba arkadaşlar 1299 Private Serverların Geliştiği Uskoya yaklaştığı bu dönemlerde yenibir paylaşımla birkez daha karşnızdayız :) Biliyorsunuz ki uskoya birkaç ay önce npclerin görevlerine göre üstlerine işaretler geldi.
Bende bu konuya farklı bir yoldan yaklaşarak işi clienttan halletmeyi başardım.Fakat bu seferde karşımıza bir engel çıktı.Oyunda görevleri farklı olan fakat spidleri aynı olan npcler var sizinde bildiğiniz gibi.Mesala bir bankaya işaret koyduğum zaman aynı spid e sahip farklı bir npc nin üzerindede banka işareti çıkıyordu.Bu sorunu halletmek içinse clientta bir kaç tbller üzerinde yeni spidler yarattım.Ve bu spidleri oyundaki tüm inn,sundries,armor,weapon,potion npclerine verdik.Ben client editlediğim için ve serverdan çakmadığım için kodları Oğuz(Ölümanı) hazırladı.Sonuç olarak (:

Güzel bir görüntü çıktı ortaya.

Ve bunu serverımıza uygulayabilmek için;
Öncelikle Query Analyzer'e girip db nizi secın daha sonra boş olan yere kodumuzu yazıp ctrl+f5 f5 yapın.

Kod:

---Made By ÖlümAnı---
update k_npc set spid = '22008' where ssid = 22000
update k_npc set spid = '22008' where ssid = 16097
update k_npc set spid = '22008' where ssid = 26061
update k_npc set spid = '12008' where ssid = 16061
update k_npc set spid = '12008' where ssid = 16096
update k_npc set spid = '12008' where ssid = 12000
update k_npc set spid = '22209' where ssid = 506
update k_npc set spid = '22209' where ssid = 22202
update k_npc set spid = '22209' where ssid = 13005
update k_npc set spid = '22209' where ssid = 13115
update k_npc set spid = '11518' where ssid = 16089
update k_npc set spid = '11518' where ssid = 12117
update k_npc set spid = '11518' where ssid = 12118
update k_npc set spid = '11518' where ssid = 13003
update k_npc set spid = '11518' where ssid = 13113
update k_npc set spid = '22108' where ssid = 22100
update k_npc set spid = '22108' where ssid = 22102
update k_npc set spid = '22108' where ssid = 22203
update k_npc set spid = '22108' where ssid = 503
update k_npc set spid = '22108' where ssid = 13006
update k_npc set spid = '12109' where ssid = 13002
update k_npc set spid = '12109' where ssid = 12100
update k_npc set spid = '12109' where ssid = 12102
update k_npc set spid = '22109' where ssid = 22106
update k_npc set spid = '22109' where ssid = 22200
update k_npc set spid = '22109' where ssid = 504
update k_npc set spid = '22109' where ssid = 13004
update k_npc set spid = '12208' where ssid = 12202
update k_npc set spid = '12208' where ssid = 13008
update k_npc set spid = '12208' where ssid = 12200
update k_npc set spid = '12108' where ssid = 16062
update k_npc set spid = '12108' where ssid = 11045
update k_npc set spid = '12108' where ssid = 12120
update k_npc set spid = '12108' where ssid = 12208
update k_npc set spid = '22208' where ssid = 21047
update k_npc set spid = '22208' where ssid = 22120
update k_npc set spid = '22208' where ssid = 22208
update k_npc set spid = '22208' where ssid = 505
update k_npc set spid = '22208' where ssid = 13007
update k_npc set spid = '22208' where ssid = 26062

Bunları uyguladıktan sonra aşağıdaki patchi clientinize atın..

http://rapidshare.com/files/254083664/NpcIsaretleri_Sorunsuz.rar

İşte bu kadar npc işaretlerimiz artık hazır.Tüm inn,sundries,armor,weapon,potion npclerinde işaretler görüncekdir.Bu npclerin haricinde hiçbir npcde alakasız bir işaret oluşmıyacakdır..