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.