Sitemizden Yararlanmak İçin

Sitemize Üye Olmalısınız

or Kayıt ol
Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

1454 Moradon NPCPOS

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Knight Online Pvp Prosedür & Kod Paylaşımları kategorisinde arizadatabase tarafından oluşturulan 1454 Moradon NPCPOS başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 559 kez görüntülenmiş, 2 yorum ve 0 tepki puanı almıştır...
Kategori Adı Knight Online Pvp Prosedür & Kod Paylaşımları
Konu Başlığı 1454 Moradon NPCPOS
Konbuyu başlatan arizadatabase
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan campos12

arizadatabase

Forum Sahibi
Yönetici
Katılım
19 May 2013
Mesajlar
1,225
Tepkime puanı
177
Puanları
63
Paylaşıldımı Bilmiorum evde internet yokken hazırlamıştım tamamiyle Güzel oldu eğer

1725 NpcSkin varsa Korkmanıza gerek yok dokunmuyor



Kunabarl Sabit ve önündeki guardlar Dağınık değil



Kodlar Biraz Uzun






Kod:
Kod:
delete from k_Npcpos where zoneid = 21 and npcid =11032
delete from k_Npcpos where zoneid = 21 and npcid =21031

------------------HumanGuard----------------------

INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,430,308,430,308,430,308,430,308,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,432,308,432,308,432,308,432,308,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,434,308,434,308,434,308,434,308,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,436,308,436,308,436,308,436,308,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,438,308,438,308,438,308,438,308,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,440,308,440,308,440,308,440,308,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,442,308,442,308,442,308,442,308,1,60,0,0,'NULL')

INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,430,305,430,306,430,306,430,306,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,432,305,432,306,432,306,432,306,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,434,305,434,306,434,306,434,306,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,436,305,436,306,436,306,436,306,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,438,305,438,306,438,306,438,306,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,440,305,440,306,440,306,440,306,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,442,305,442,306,442,306,442,306,1,60,0,0,'NULL')

INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,430,303,430,304,430,304,430,304,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,432,303,432,304,432,304,432,304,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,434,303,434,304,434,304,434,304,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,436,303,436,304,436,304,436,304,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,438,303,438,304,438,304,438,304,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,440,303,440,304,440,304,440,304,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,11032,104,0,0,0,0,442,303,442,304,442,304,442,304,1,60,0,0,'NULL')

------------------KarusGuard----------------------

Kod:
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,430,300,430,300,430,300,430,300,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,432,300,432,300,432,300,432,300,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,434,300,434,300,434,300,434,300,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,436,300,436,300,436,300,436,300,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,438,300,438,300,438,300,438,300,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,440,300,440,300,440,300,440,300,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,442,300,442,300,442,300,442,300,1,60,0,0,'NULL')

INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,430,297,430,297,430,297,430,297,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,432,297,432,297,432,297,432,297,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,434,297,434,297,434,297,434,297,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,436,297,436,297,436,297,436,297,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,438,297,438,297,438,297,438,297,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,440,297,440,297,440,297,440,297,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,442,297,442,297,442,297,442,297,1,60,0,0,'NULL')

INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,430,294,430,294,430,294,430,294,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,432,294,432,294,432,294,432,294,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,434,294,434,294,434,294,434,294,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,436,294,436,294,436,294,436,294,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,438,294,438,294,438,294,438,294,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,440,294,440,294,440,294,440,294,1,60,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,21031,104,0,0,0,0,442,294,442,294,442,294,442,294,1,60,0,0,'NULL')
-------------------------Npcler-------------------------
Kod:
update k_npc set iweapon1=120110000,iweapon2=170410000 where ssid=11032
update k_npc set iweapon1=120110000,iweapon2=170410000 where ssid=21031
delete from k_npc where ssid = 603
insert into [K_NPC] Values (603,'Chaotic   Generator',30200,100,0,0,1,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)
update k_Npc set spid=11610 where ssid=16011 and spid =11100
update k_npc set bygroup =2 where ssid=13006
update k_npc set strname  ='[Blacksmith] Heppa' where ssid=14301
update k_npc set strname = '[Sentinel]Patrick' where ssid=16011
update k_npc set strname = '[Operator] Moira' where ssid=16047
update k_npc set strname = '[InnKeeper] Naia' where ssid=22000
update k_npc set strname = '[InnKeeper] Laneia' where ssid = 12000
update k_npc set strname = '[Weapon Merchant]Gargameth' where ssid = 13008
update k_npc set strname = '[Armor Merchant]Nesta' where ssid =13006
update k_npc set strname = '[Merchant Daughter]Menissiah' where ssid =16079
delete from k_npcpos where npcid = 603 
delete from k_npcpos where npcid = 13009 and zoneid=21
delete from k_npcpos where npcid = 13002 and zoneid=21
delete from k_npcpos where npcid = 13004 and zoneid=21
delete from k_npcpos where npcid = 16047 and zoneid=21
delete from k_npcpos where npcid = 13008 and zoneid=21
delete from k_npcpos where npcid = 13007 and zoneid=21
delete from k_npcpos where npcid = 13006 and zoneid=21
delete from k_npcpos where npcid = 22000 and zoneid=21
delete from k_npcpos where npcid = 13015 and zoneid=21
delete from k_npcpos where npcid = 16092 and zoneid=21
delete from k_npcpos where npcid = 14301 and zoneid=21
delete from k_npcpos where npcid = 16079 and zoneid=21
delete from k_npcpos where npcid = 13012 and zoneid=21
delete from k_npcpos where npcid = 12101 and zoneid=21
delete from k_npcpos where npcid = 13001 and zoneid=21
delete from k_npcpos where npcid = 521 and zoneid=21
delete from k_npcpos where npcid = 13013 and zoneid=21
delete from k_npcpos where npcid = 15002 and zoneid=21
delete from k_npcpos where npcid = 16046 and zoneid=21
delete from k_npcpos where npcid = 16083 and zoneid=21
delete from k_npcpos where npcid = 16071 and zoneid=21
delete from k_npcpos where npcid = 14401 and zoneid=21
delete from k_npcpos where npcid = 16087 and zoneid=21
delete from k_npcpos where npcid = 16011 and zoneid=21
delete from k_npcpos where npcid = 16086 and zoneid=21
delete from k_npcpos where npcid = 13014 and zoneid=21
delete from k_npcpos where npcid = 13011 and zoneid=21
INSERT INTO [k_npcpos] Values (21,603,100,0,0,0,0,273,453,273,453,273,453,273,453,1,10,0,0,'NULL')
INSERT INTO [k_npcpos] Values (21,13009,104,0,0,0,0,447,301,447,301,447,301,447,301,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16047,104,0,0,0,0,318,429,318,429,318,429,318,429,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,13008,104,0,0,0,0,404,369,404,369,404,369,404,369,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,13006,104,0,0,0,0,404,363,404,363,404,363,404,363,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,22000,104,0,0,0,0,394,402,394,402,394,402,394,402,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,13007,104,0,0,0,0,381,316,381,316,381,316,381,316,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,14301,104,0,0,0,0,371,362,371,362,371,362,371,362,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16079,104,0,0,0,0,304,354,304,354,304,354,304,354,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,13001,104,0,0,0,0,281,438,281,438,281,438,281,438,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,521,104,0,0,0,0,464,274,464,274,464,274,464,274,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,13013,104,0,0,0,0,465,314,465,314,465,314,465,314,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,15002,104,0,0,0,0,345,464,345,464,345,464,345,464,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16046,104,0,0,0,0,341,445,341,445,341,445,341,445,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16083,104,0,0,0,0,427,454,427,454,427,454,427,454,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16071,104,0,0,0,0,371,422,371,422,371,422,371,422,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,14401,104,0,0,0,0,248,442,248,442,248,442,248,442,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16087,104,0,0,0,0,253,451,253,451,253,451,253,451,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16011,104,0,0,0,0,316,343,316,343,316,343,316,343,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,16086,104,0,0,0,0,308,397,308,397,308,397,308,397,1,4400,0,11,'NULL')
INSERT INTO [k_npcpos] Values (21,13014,104,0,0,0,0,309,404,309,404,309,404,309,404,1,4400,0,11,'NULL')
Kullanımı ...



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

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

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