- Katılım
- 12 Mart 2012
- Mesajlar
- 1,142
Sorunsuz +open2 Full Fix MAP Dahil
+open2 Savaşı Map dosyaları
AiServer ve Ebenezer MAP dosyasını indirmek için tıklayınız.
Rar Şifresi: ko-fox.com
Databasenizde basmalı savaş açtığınızda ebenezer kapanıyor, Warder kesilince notice geçimiyor ya da Warder ve Keeper kesilince savaş sona ermiyorsa aşağıdaki kodları sorunsuz kullanabilirsiniz.
Düzenlenen +open2
Savaş +open2 komutu ile başlar
Warder kesilindiğinde kesen kişinin Nicki notice geçer
Keeper kesilindiğinde kesen kişinin Nicki notice geçer
Warder ve Keeper kesilindiğinde NP verir
Guardlar sorunsuz ve USKO düzeninde
Guardlar atak verir
Warder ve Keeper kesildiğinde savaş sona erer
Savaş sona erdiğinde karşı ırk towna sorunsuz ışınlar
Usko ile birebirdir
NPC'ler np vermiyorsa tıklayın
Full fix +open2
İlk olarak Warder, Keeper ve Guardları silelim
Kod:
Delete from k_npc where ssid in(10510,11041,11042,11043,11044,11047,12000,12120 ,14408,20510,21041,21042,21043,21044,21045,22000,2 2120,24408)
Sildiğimiz Warder, Keeper ve Guardları tekrar geri ekleyelim
Kod:
insert into [K_NPC] values ('10510','Victory Gate','30100','100','0','0','2','0','53','1','1',' 1','0','60','0','0','10000','0','0','360','194','1 94','0','1000','0','0','1000','0','0','0','250','2 50','250','250','250','250','250','100','5','5','5 ','0','10510','0','0','0');
insert into [K_NPC] values ('11041','Keeper','11610','100','149101229','17910 2329','2','7','11','1','1','2','0','100','0','0',' 350000','0','3000','32000','375','375','5000','150 0','2','7','1000','106560','0','0','500','500','50 0','500','500','500','500','90','7','14','35','200 0','11041','0','0','1');
insert into [K_NPC] values ('11042','Warder 1','11610','100','149101229','179102329','2','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','4000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','11042','0',' 0','1');
insert into [K_NPC] values ('11043','guard','11000','100','159302419','179102 329','2','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','500','11043','0 ','0','0');
insert into [K_NPC] values ('11044','Recon','11000','100','130650000','170450 000','2','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','300','11044','0 ','0','0');
insert into [K_NPC] values ('11047','Warder 2','11610','100','149101229','179102329','2','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','4000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','11047','0',' 0','1');
insert into [K_NPC] values ('12000','[Innkeeper] Lined','30700','100','0','0','2','1','31','1','0', '1','0','50','100','0','50000','0','0','5000','130 ','130','1000','1500','2','5','1000','0','0','0',' 250','250','250','250','250','250','250','90','7', '14','25','15000','12000','0','0','1');
insert into [K_NPC] values ('12120','[sundries]Halber','12100','100','0','0','2','7','22','1','0' ,'1','255000','50','100','0','30000','0','0','5000 ','130','130','1000','1500','2','5','1000','0','0' ,'0','250','250','250','250','250','250','250','90 ','7','14','25','15000','12120','0','0','1');
insert into [K_NPC] values ('14408','El Morad Spy','11000','100','150210000','170210000','2','7' ,'141','1','3','3','0','60','0','0','50000','0','0 ','15000','275','275','3000','1500','2','7','1000' ,'0','0','0','250','250','250','250','250','250',' 250','90','7','14','35','15000','14408','0','0','1 ');
insert into [K_NPC] values ('20510','Victory Gate','30100','100','0','0','1','0','53','1','1',' 1','0','60','0','0','10000','0','0','360','194','1 94','0','1000','0','0','1000','0','0','0','250','2 50','250','250','250','250','250','100','5','5','5 ','0','20510','0','0','0');
insert into [K_NPC] values ('21041','Keeper','21610','100','149101229','17910 2329','1','7','11','1','1','2','0','100','0','0',' 350000','0','3000','32000','375','375','8000','150 0','2','7','1000','106560','0','0','500','500','50 0','500','500','500','500','90','7','14','35','200 0','21041','0','0','1');
insert into [K_NPC] values ('21042','Warder 1','21610','100','149101229','179102329','1','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','6000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','21042','0',' 0','1');
insert into [K_NPC] values ('21043','guard','21000','100','159302419','179102 329','1','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','500','21043','0 ','0','0');
insert into [K_NPC] values ('21044','Recon','21000','100','130650000','170450 000','1','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','300','21044','0 ','0','0');
insert into [K_NPC] values ('21045','Warder 2','21610','100','149101229','179102329','1','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','6000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','21045','0',' 0','1');
insert into [K_NPC] values ('22000','[Innkeeper]Galid','22000','100','0','0','1','1','31','1','0', '1','0','50','100','0','50000','0','0','5000','130 ','130','1000','1500','2','5','1000','0','0','0',' 250','250','250','250','250','250','250','90','7', '14','25','15000','22000','0','0','1');
insert into [K_NPC] values ('22120','[Sundries]Ardin','22100','100','0','0','1','1','22','1','0', '1','255000','50','100','0','30000','0','0','5000' ,'130','130','1000','1500','2','5','1000','0','0', '0','250','250','250','250','250','250','250','90' ,'7','14','25','15000','22120','0','0','1');
insert into [K_NPC] values ('24408','Karus Spy','21000','100','130650000','170450000','1','7' ,'141','1','3','3','0','60','0','0','50000','0','0 ','15000','275','275','3000','1500','2','7','1000' ,'0','0','0','250','250','250','250','250','250',' 250','90','7','14','35','15000','24408','0','0','1 ');
Sorun olan +open2'deki pozisyonları silelim
Kod:
delete from k_npcpos where zoneid = 102
USKO pozisyonları ekleyelim
Kod:
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','906','962',' 957','912','889','972','972','891','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','785','540',' 804','524','779','543','816','519','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','451','707',' 560','587','418','732','603','553','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','604','666',' 678','605','580','686','704','582','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','632','906',' 721','813','614','924','762','778','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','594','715',' 664','654','571','738','689','628','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','287','604',' 403','470','261','626','434','438','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','215','342',' 295','264','200','358','325','241','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','267','154',' 361','87','232','191','408','62','2','12000','0',' 0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','192','542',' 236','505','175','556','257','494','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','88','350','1 84','287','87','360','200','275','2','12000','0',' 0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','869','869',' 869','868','868','870','870','867','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','156','159',' 157','158','155','160','158','156','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','157','158',' 158','157','156','159','159','155','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','161','154',' 162','153','160','155','163','151','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','162','152',' 163','151','159','153','163','150','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','67','93','73 ','88','59','103','79','76','3','16000','0','0','' );
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','132','68','1 38','61','120','82','160','49','3','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','270','167',' 289','148','211','216','296','133','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','378','271',' 434','211','348','302','448','201','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','869','868',' 870','868','869','870','871','867','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','186','457',' 190','454','181','465','194','450','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21041','104','0','1','98','0','73','77','7 6','75','64','84','82','66','1','16000','0','0','' );
insert into [K_NPCPOS] values ('102','12120','104','0','5','0','0','804','513',' 805','511','797','521','805','510','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21042','104','0','2','90','0','450','188', '453','186','444','193','461','179','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','821','803',' 879','750','806','816','896','734','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','530','812',' 547','799','526','817','554','793','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','797','553',' 813','538','792','557','816','533','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','854','741',' 918','653','814','770','948','615','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','620','893',' 696','794','596','920','733','757','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','878','923',' 924','870','864','940','951','862','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','913','949',' 957','913','899','969','968','895','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','796','545',' 812','531','791','549','819','525','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','788','555',' 802','534','781','559','807','528','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','753','750',' 805','697','734','768','827','679','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','737','705',' 799','646','721','722','819','626','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','733','642',' 797','578','712','658','810','566','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','664','656',' 733','586','651','669','751','566','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','730','523',' 781','472','707','541','811','439','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','919','909',' 955','859','900','927','981','836','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','810','878',' 865','805','790','890','883','781','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','14408','100','0','0','0','0','860','962',' 861','961','859','963','861','961','1','600','0',' 0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','732','542',' 771','495','711','559','790','475','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','302','258',' 379','189','291','266','393','164','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','900','904',' 951','859','873','924','971','837','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','810','724',' 881','617','783','741','910','589','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','615','543',' 708','455','596','565','727','436','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','940','909',' 982','889','922','922','989','876','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','859','675',' 957','597','828','693','981','580','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','655','711',' 725','639','629','730','761','612','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','312','424',' 380','360','297','437','396','344','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','583','191',' 719','85','552','240','741','57','2','12000','0',' 0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','842','839',' 888','777','814','854','916','737','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','848','965',' 888','922','840','975','924','885','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','140','243',' 196','187','127','258','220','175','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','217','438',' 291','365','201','450','333','327','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','258','399',' 331','327','237','416','354','306','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','262','280',' 319','212','247','296','344','188','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','874','973',' 924','927','869','975','948','903','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','525','809',' 548','791','524','816','560','785','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','811','549',' 824','530','802','550','825','523','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','704','754',' 753','704','689','768','770','688','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','643','782',' 700','727','628','795','716','711','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','798','425',' 893','330','742','465','928','268','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','331','851',' 446','732','306','870','479','705','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','573','788',' 636','731','559','803','663','700','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','844','962',' 878','927','835','969','895','911','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','24408','100','0','0','0','0','185','46','1 86','45','184','46','186','44','1','600','0','0',' ');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','505','768',' 550','705','484','785','579','672','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','190','274',' 252','206','173','287','271','190','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','185','207',' 238','135','176','220','260','122','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','134','652',' 233','551','118','673','266','523','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','480','387',' 598','267','459','413','623','244','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','309','333',' 378','269','295','349','395','255','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','194','404',' 280','316','184','414','328','275','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','360','371',' 437','293','342','386','460','271','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','494','247',' 566','190','480','264','624','159','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','866','871',' 867','870','865','872','868','869','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','864','870',' 865','870','864','871','866','869','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','865','872',' 866','871','864','873','867','870','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','160','155',' 161','154','159','155','162','152','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','82','69','88 ','61','76','75','95','55','3','16000','0','0','') ;
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','176','67','1 79','65','171','75','186','61','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','470','199',' 473','195','463','205','477','192','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','456','183',' 461','181','451','193','466','178','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','461','213',' 463','209','457','217','470','201','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','69','130','7 3','125','61','138','86','117','3','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','170','55','1 73','53','164','60','177','48','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','135','109',' 141','105','121','125','151','87','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','865','944',' 917','902','842','957','941','890','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','483','792',' 525','741','464','806','541','717','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','226','518',' 271','464','217','528','299','445','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','465','266',' 508','225','448','287','522','215','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','868','870',' 868','869','868','871','869','868','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','867','871',' 867','870','866','872','869','868','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','868','867',' 869','867','867','869','870','866','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','160','155',' 160','154','159','156','162','153','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','158','157',' 159','156','157','157','161','155','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','110','148',' 114','144','92','158','127','120','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','63','147','6 5','144','62','148','71','139','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','134','349',' 144','328','98','392','160','306','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','103','59','1 08','51','92','70','128','45','3','16000','0','0', '');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','350','135',' 364','110','292','193','378','90','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','142','299',' 158','270','113','317','180','232','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','196','469',' 201','464','189','475','207','461','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','468','207',' 472','203','460','210','476','197','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','168','453',' 172','448','163','456','180','444','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','192','481',' 195','476','188','484','202','469','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','178','468',' 184','464','175','472','191','457','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','450','196',' 455','191','445','198','463','184','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','94','101','1 01','89','86','112','117','76','3','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','57','140','5 9','138','55','142','65','135','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','81','82','88 ','75','75','91','94','66','3','16000','0','0','') ;
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','155','160',' 156','159','154','160','158','157','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11041','104','0','6','99','0','947','949', '949','946','944','952','952','943','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','22120','104','0','2','0','0','455','221',' 457','219','452','223','460','217','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11042','104','0','4','92','0','554','816', '557','813','541','819','560','801','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','11047','104','0','5','93','0','807','545', '810','542','794','548','814','530','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','21045','104','0','3','91','0','176','455', '178','453','167','465','188','446','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','12000','104','0','4','0','0','523','805',' 523','804','521','807','524','801','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','22000','104','0','3','0','0','192','489',' 193','488','191','491','196','485','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','20510','100','0','0','0','0','941','942',' 943','940','940','943','944','939','1','30','0','0 ','');
insert into [K_NPCPOS] values ('102','10510','100','0','0','0','0','79','82','81 ','80','78','83','82','79','1','30','0','0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','766','881',' 817','823','755','890','832','809','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','752','818',' 808','760','740','830','827','745','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','532','794',' 551','783','528','807','556','781','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','547','821',' 559','804','538','825','564','796','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','538','810',' 554','796','535','814','560','792','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','691','869',' 748','795','678','879','772','773','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','916','932',' 956','880','906','941','971','869','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','885','960',' 928','908','875','968','944','893','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','834','955',' 887','909','821','965','914','895','3','16000','0' ,'0','');
+open2 Savaşı Map dosyaları
AiServer ve Ebenezer MAP dosyasını indirmek için tıklayınız.
Rar Şifresi: ko-fox.com
NPC'ler NP Vermiyor ise Konuya Göz Atın
NPC'ler NP Vermiyor ise Konuya Göz Atın
Database'inizde NPC'ler NP vermiyor ise aşağıdaki kodları Query Analyzer girerek F5 yapın.
Kod:
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Sundries%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Inn%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Healing%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%arms%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Hand%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%The Key%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Armor%'
Özellikler:
* Tüm Sundires [ Cz ve Ardreamdakiler dahil ]
* Tüm Inn HosTesler [ Cz Veya Ardreamdakiler dahil ]
* Tüm PotCular [ Cz ve Ardreamdakiler dahil ]
* Tüm Weapon & Armorcular
* Anahtar Görevi NPC'leri
Yukarıdaki kodlar ile NPC'ler 300 Np verecektir, 'iloyalty = 300' Bu Kısımda Yazan '300'ü NPC'nin kaç Np vermesini istiyorsanız bu kısmı değiştirebilirsiniz.
+open2 Savaşı Map dosyaları
AiServer ve Ebenezer MAP dosyasını indirmek için tıklayınız.
Ziyaretçiler için gizlenmiş link,görmek için
Giriş yap veya üye ol.
Rar Şifresi: ko-fox.com
Databasenizde basmalı savaş açtığınızda ebenezer kapanıyor, Warder kesilince notice geçimiyor ya da Warder ve Keeper kesilince savaş sona ermiyorsa aşağıdaki kodları sorunsuz kullanabilirsiniz.
Düzenlenen +open2
Savaş +open2 komutu ile başlar
Warder kesilindiğinde kesen kişinin Nicki notice geçer
Keeper kesilindiğinde kesen kişinin Nicki notice geçer
Warder ve Keeper kesilindiğinde NP verir
Guardlar sorunsuz ve USKO düzeninde
Guardlar atak verir
Warder ve Keeper kesildiğinde savaş sona erer
Savaş sona erdiğinde karşı ırk towna sorunsuz ışınlar
Usko ile birebirdir
NPC'ler np vermiyorsa tıklayın
Full fix +open2
İlk olarak Warder, Keeper ve Guardları silelim
Kod:
Delete from k_npc where ssid in(10510,11041,11042,11043,11044,11047,12000,12120 ,14408,20510,21041,21042,21043,21044,21045,22000,2 2120,24408)
Sildiğimiz Warder, Keeper ve Guardları tekrar geri ekleyelim
Kod:
insert into [K_NPC] values ('10510','Victory Gate','30100','100','0','0','2','0','53','1','1',' 1','0','60','0','0','10000','0','0','360','194','1 94','0','1000','0','0','1000','0','0','0','250','2 50','250','250','250','250','250','100','5','5','5 ','0','10510','0','0','0');
insert into [K_NPC] values ('11041','Keeper','11610','100','149101229','17910 2329','2','7','11','1','1','2','0','100','0','0',' 350000','0','3000','32000','375','375','5000','150 0','2','7','1000','106560','0','0','500','500','50 0','500','500','500','500','90','7','14','35','200 0','11041','0','0','1');
insert into [K_NPC] values ('11042','Warder 1','11610','100','149101229','179102329','2','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','4000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','11042','0',' 0','1');
insert into [K_NPC] values ('11043','guard','11000','100','159302419','179102 329','2','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','500','11043','0 ','0','0');
insert into [K_NPC] values ('11044','Recon','11000','100','130650000','170450 000','2','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','300','11044','0 ','0','0');
insert into [K_NPC] values ('11047','Warder 2','11610','100','149101229','179102329','2','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','4000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','11047','0',' 0','1');
insert into [K_NPC] values ('12000','[Innkeeper] Lined','30700','100','0','0','2','1','31','1','0', '1','0','50','100','0','50000','0','0','5000','130 ','130','1000','1500','2','5','1000','0','0','0',' 250','250','250','250','250','250','250','90','7', '14','25','15000','12000','0','0','1');
insert into [K_NPC] values ('12120','[sundries]Halber','12100','100','0','0','2','7','22','1','0' ,'1','255000','50','100','0','30000','0','0','5000 ','130','130','1000','1500','2','5','1000','0','0' ,'0','250','250','250','250','250','250','250','90 ','7','14','25','15000','12120','0','0','1');
insert into [K_NPC] values ('14408','El Morad Spy','11000','100','150210000','170210000','2','7' ,'141','1','3','3','0','60','0','0','50000','0','0 ','15000','275','275','3000','1500','2','7','1000' ,'0','0','0','250','250','250','250','250','250',' 250','90','7','14','35','15000','14408','0','0','1 ');
insert into [K_NPC] values ('20510','Victory Gate','30100','100','0','0','1','0','53','1','1',' 1','0','60','0','0','10000','0','0','360','194','1 94','0','1000','0','0','1000','0','0','0','250','2 50','250','250','250','250','250','100','5','5','5 ','0','20510','0','0','0');
insert into [K_NPC] values ('21041','Keeper','21610','100','149101229','17910 2329','1','7','11','1','1','2','0','100','0','0',' 350000','0','3000','32000','375','375','8000','150 0','2','7','1000','106560','0','0','500','500','50 0','500','500','500','500','90','7','14','35','200 0','21041','0','0','1');
insert into [K_NPC] values ('21042','Warder 1','21610','100','149101229','179102329','1','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','6000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','21042','0',' 0','1');
insert into [K_NPC] values ('21043','guard','21000','100','159302419','179102 329','1','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','500','21043','0 ','0','0');
insert into [K_NPC] values ('21044','Recon','21000','100','130650000','170450 000','1','7','11','1','1','2','0','60','0','0','30 000','0','0','3000','194','194','1500','1500','2', '7','1000','0','0','0','250','250','250','250','25 0','250','250','90','7','14','35','300','21044','0 ','0','0');
insert into [K_NPC] values ('21045','Warder 2','21610','100','149101229','179102329','1','7',' 11','1','1','2','0','80','0','0','250000','0','200 0','30000','275','275','6000','1500','2','7','1000 ','106560','0','0','500','500','500','500','500',' 500','500','90','7','14','35','1000','21045','0',' 0','1');
insert into [K_NPC] values ('22000','[Innkeeper]Galid','22000','100','0','0','1','1','31','1','0', '1','0','50','100','0','50000','0','0','5000','130 ','130','1000','1500','2','5','1000','0','0','0',' 250','250','250','250','250','250','250','90','7', '14','25','15000','22000','0','0','1');
insert into [K_NPC] values ('22120','[Sundries]Ardin','22100','100','0','0','1','1','22','1','0', '1','255000','50','100','0','30000','0','0','5000' ,'130','130','1000','1500','2','5','1000','0','0', '0','250','250','250','250','250','250','250','90' ,'7','14','25','15000','22120','0','0','1');
insert into [K_NPC] values ('24408','Karus Spy','21000','100','130650000','170450000','1','7' ,'141','1','3','3','0','60','0','0','50000','0','0 ','15000','275','275','3000','1500','2','7','1000' ,'0','0','0','250','250','250','250','250','250',' 250','90','7','14','35','15000','24408','0','0','1 ');
Sorun olan +open2'deki pozisyonları silelim
Kod:
delete from k_npcpos where zoneid = 102
USKO pozisyonları ekleyelim
Kod:
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','906','962',' 957','912','889','972','972','891','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','785','540',' 804','524','779','543','816','519','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','451','707',' 560','587','418','732','603','553','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','604','666',' 678','605','580','686','704','582','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','632','906',' 721','813','614','924','762','778','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','594','715',' 664','654','571','738','689','628','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','287','604',' 403','470','261','626','434','438','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','215','342',' 295','264','200','358','325','241','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','267','154',' 361','87','232','191','408','62','2','12000','0',' 0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','192','542',' 236','505','175','556','257','494','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','88','350','1 84','287','87','360','200','275','2','12000','0',' 0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','869','869',' 869','868','868','870','870','867','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','156','159',' 157','158','155','160','158','156','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','157','158',' 158','157','156','159','159','155','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','161','154',' 162','153','160','155','163','151','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','162','152',' 163','151','159','153','163','150','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','67','93','73 ','88','59','103','79','76','3','16000','0','0','' );
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','132','68','1 38','61','120','82','160','49','3','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','270','167',' 289','148','211','216','296','133','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','378','271',' 434','211','348','302','448','201','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','869','868',' 870','868','869','870','871','867','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','186','457',' 190','454','181','465','194','450','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21041','104','0','1','98','0','73','77','7 6','75','64','84','82','66','1','16000','0','0','' );
insert into [K_NPCPOS] values ('102','12120','104','0','5','0','0','804','513',' 805','511','797','521','805','510','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21042','104','0','2','90','0','450','188', '453','186','444','193','461','179','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','821','803',' 879','750','806','816','896','734','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','530','812',' 547','799','526','817','554','793','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','797','553',' 813','538','792','557','816','533','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','854','741',' 918','653','814','770','948','615','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','620','893',' 696','794','596','920','733','757','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','878','923',' 924','870','864','940','951','862','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','913','949',' 957','913','899','969','968','895','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','796','545',' 812','531','791','549','819','525','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','788','555',' 802','534','781','559','807','528','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','753','750',' 805','697','734','768','827','679','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','737','705',' 799','646','721','722','819','626','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','733','642',' 797','578','712','658','810','566','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','664','656',' 733','586','651','669','751','566','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','730','523',' 781','472','707','541','811','439','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','919','909',' 955','859','900','927','981','836','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','810','878',' 865','805','790','890','883','781','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','14408','100','0','0','0','0','860','962',' 861','961','859','963','861','961','1','600','0',' 0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','732','542',' 771','495','711','559','790','475','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','302','258',' 379','189','291','266','393','164','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','900','904',' 951','859','873','924','971','837','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','810','724',' 881','617','783','741','910','589','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','615','543',' 708','455','596','565','727','436','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','940','909',' 982','889','922','922','989','876','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','859','675',' 957','597','828','693','981','580','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','655','711',' 725','639','629','730','761','612','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','312','424',' 380','360','297','437','396','344','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','583','191',' 719','85','552','240','741','57','2','12000','0',' 0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','842','839',' 888','777','814','854','916','737','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','848','965',' 888','922','840','975','924','885','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','140','243',' 196','187','127','258','220','175','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','217','438',' 291','365','201','450','333','327','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','258','399',' 331','327','237','416','354','306','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','262','280',' 319','212','247','296','344','188','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','874','973',' 924','927','869','975','948','903','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','525','809',' 548','791','524','816','560','785','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','5','0','0','811','549',' 824','530','802','550','825','523','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','704','754',' 753','704','689','768','770','688','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','643','782',' 700','727','628','795','716','711','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','798','425',' 893','330','742','465','928','268','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','331','851',' 446','732','306','870','479','705','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','573','788',' 636','731','559','803','663','700','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','6','0','0','844','962',' 878','927','835','969','895','911','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','24408','100','0','0','0','0','185','46','1 86','45','184','46','186','44','1','600','0','0',' ');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','505','768',' 550','705','484','785','579','672','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','190','274',' 252','206','173','287','271','190','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','185','207',' 238','135','176','220','260','122','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','134','652',' 233','551','118','673','266','523','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','480','387',' 598','267','459','413','623','244','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','309','333',' 378','269','295','349','395','255','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','194','404',' 280','316','184','414','328','275','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','3','0','0','360','371',' 437','293','342','386','460','271','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','494','247',' 566','190','480','264','624','159','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','866','871',' 867','870','865','872','868','869','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','864','870',' 865','870','864','871','866','869','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','865','872',' 866','871','864','873','867','870','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','160','155',' 161','154','159','155','162','152','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','82','69','88 ','61','76','75','95','55','3','16000','0','0','') ;
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','176','67','1 79','65','171','75','186','61','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','470','199',' 473','195','463','205','477','192','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','456','183',' 461','181','451','193','466','178','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','461','213',' 463','209','457','217','470','201','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','69','130','7 3','125','61','138','86','117','3','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','170','55','1 73','53','164','60','177','48','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','135','109',' 141','105','121','125','151','87','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','865','944',' 917','902','842','957','941','890','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11044','101','0','0','0','0','483','792',' 525','741','464','806','541','717','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','226','518',' 271','464','217','528','299','445','2','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21044','101','0','0','0','0','465','266',' 508','225','448','287','522','215','1','12000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','868','870',' 868','869','868','871','869','868','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','867','871',' 867','870','866','872','869','868','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','104','0','6','0','0','868','867',' 869','867','867','869','870','866','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','160','155',' 160','154','159','156','162','153','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','158','157',' 159','156','157','157','161','155','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','110','148',' 114','144','92','158','127','120','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','63','147','6 5','144','62','148','71','139','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','134','349',' 144','328','98','392','160','306','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','103','59','1 08','51','92','70','128','45','3','16000','0','0', '');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','350','135',' 364','110','292','193','378','90','3','16000','0', '0','');
insert into [K_NPCPOS] values ('102','21043','101','0','0','0','0','142','299',' 158','270','113','317','180','232','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','196','469',' 201','464','189','475','207','461','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','468','207',' 472','203','460','210','476','197','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','168','453',' 172','448','163','456','180','444','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','192','481',' 195','476','188','484','202','469','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','3','0','0','178','468',' 184','464','175','472','191','457','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','2','0','0','450','196',' 455','191','445','198','463','184','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','94','101','1 01','89','86','112','117','76','3','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','57','140','5 9','138','55','142','65','135','1','16000','0','0' ,'');
insert into [K_NPCPOS] values ('102','21043','101','0','1','0','0','81','82','88 ','75','75','91','94','66','3','16000','0','0','') ;
insert into [K_NPCPOS] values ('102','21043','104','0','1','0','0','155','160',' 156','159','154','160','158','157','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11041','104','0','6','99','0','947','949', '949','946','944','952','952','943','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','22120','104','0','2','0','0','455','221',' 457','219','452','223','460','217','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11042','104','0','4','92','0','554','816', '557','813','541','819','560','801','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','11047','104','0','5','93','0','807','545', '810','542','794','548','814','530','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','21045','104','0','3','91','0','176','455', '178','453','167','465','188','446','1','16000','0 ','0','');
insert into [K_NPCPOS] values ('102','12000','104','0','4','0','0','523','805',' 523','804','521','807','524','801','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','22000','104','0','3','0','0','192','489',' 193','488','191','491','196','485','1','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','20510','100','0','0','0','0','941','942',' 943','940','940','943','944','939','1','30','0','0 ','');
insert into [K_NPCPOS] values ('102','10510','100','0','0','0','0','79','82','81 ','80','78','83','82','79','1','30','0','0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','766','881',' 817','823','755','890','832','809','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','752','818',' 808','760','740','830','827','745','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','532','794',' 551','783','528','807','556','781','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','547','821',' 559','804','538','825','564','796','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','4','0','0','538','810',' 554','796','535','814','560','792','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','691','869',' 748','795','678','879','772','773','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','916','932',' 956','880','906','941','971','869','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','885','960',' 928','908','875','968','944','893','3','16000','0' ,'0','');
insert into [K_NPCPOS] values ('102','11043','101','0','6','0','0','834','955',' 887','909','821','965','914','895','3','16000','0' ,'0','');
+open2 Savaşı Map dosyaları
AiServer ve Ebenezer MAP dosyasını indirmek için tıklayınız.
Ziyaretçiler için gizlenmiş link,görmek için
Giriş yap veya üye ol.
Rar Şifresi: ko-fox.com
NPC'ler NP Vermiyor ise Konuya Göz Atın
NPC'ler NP Vermiyor ise Konuya Göz Atın
Database'inizde NPC'ler NP vermiyor ise aşağıdaki kodları Query Analyzer girerek F5 yapın.
Kod:
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Sundries%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Inn%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Healing%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%arms%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Hand%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%The Key%'
UPDATE K_NPC SET iloyalty = 300 where StrName Like '%Armor%'
Özellikler:
* Tüm Sundires [ Cz ve Ardreamdakiler dahil ]
* Tüm Inn HosTesler [ Cz Veya Ardreamdakiler dahil ]
* Tüm PotCular [ Cz ve Ardreamdakiler dahil ]
* Tüm Weapon & Armorcular
* Anahtar Görevi NPC'leri
Yukarıdaki kodlar ile NPC'ler 300 Np verecektir, 'iloyalty = 300' Bu Kısımda Yazan '300'ü NPC'nin kaç Np vermesini istiyorsanız bu kısmı değiştirebilirsiniz.