Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Savaşı Tamamen Bugsuz Yapma

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Savaşı Tamamen Bugsuz Yapma başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 685 kez görüntülenmiş, 0 yorum ve 0 tepki puanı almıştır...
Kategori Adı Prosedür & Kod Paylaşımları
Konu Başlığı Savaşı Tamamen Bugsuz Yapma
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
Kodu SQL'ye Uygulamanız Yeterlidir

Verilen Mapları 101-102-103. Maplarınız İle Degiştirin.




Kod:
 DELETE
FROM K_NPC
WHERE (strName = 'warder 1') OR
(strName = 'warder 2') OR
(strName = 'keeper')

DELETE
FROM K_NPCPOS
WHERE (ZoneID = 102) AND (NpcID = 21045) OR
(ZoneID = 102) AND (NpcID = 21041) OR
(ZoneID = 102) AND (NpcID = 21042) OR
(ZoneID = 102) AND (NpcID = 11041) OR
(ZoneID = 102) AND (NpcID = 11042) OR
(ZoneID = 102) AND (NpcID = 11047) OR
(ZoneID = 103) AND (NpcID = 21045) OR
(ZoneID = 101) AND (NpcID = 21045)

INSERT INTO [K_NPCPOS] Values(103,21045,104,1,3,91,0,670,143,671,142,670,144,672,142,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(101,21045,104,1,3,91,0,597,300,600,297,596,301,601,296,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(102,21045,104,1,3,91,0,176,455,178,453,167,465,188,446,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(102,11047,104,1,5,93,0,807,545,810,542,794,548,814,530,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(102,21041,104,1,1,98,0,73,77,76,75,64,84,82,66,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(102,21042,104,1,2,90,0,450,188,453,186,444,193,461,179,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(102,11041,104,1,6,99,0,947,949,949,946,944,952,952,943,1,30,0,0,NULL)
INSERT INTO [K_NPCPOS] Values(102,11042,104,1,4,92,0,554,816,557,813,541,819,560,801,1,30,0,0,NULL)

INSERT INTO [K_NPC] Values(11041,'Keeper',11610,100,120310049,170450000,2,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,5000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,2000,21011,0,0,1)
INSERT INTO [K_NPC] Values(11042,'Warder 1',11610,100,120710049,170450000,2,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,4000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1)
INSERT INTO [K_NPC] Values(11047,'Warder 2',11610,100,120710049,170450000,2,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,4000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1)
INSERT INTO [K_NPC] Values(21042,'Warder 1',21610,100,130450179,170450000,1,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,6000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1)
INSERT INTO [K_NPC] Values(21045,'Warder 2',21610,100,130450179,170450000,1,7,11,1,1,2,0,70,0,0,150000,0,0,10000,275,275,6000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,1000,21011,0,0,1)
INSERT INTO [K_NPC] Values(21041,'Keeper',21610,100,130650179,170450000,1,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,8000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,35,2000,21011,0,0,1)

update zone_info set roomevent = '101'
where zoneno = '101'

go

update zone_info set roomevent = '102'
where zoneno = '102'

go

update zone_info set roomevent = '103'
where zoneno = '103'
Bunları Q.a'ya Ekledikten sonra evtleride yaptımı sorun kalmaz.



101.evt





Kod:
   TYPE 0

ROOM 01
NATION 2
POS 275 570 325 600
A 2 0 0
E 100 1 12
END

ROOM 02
NATION 2
POS 195 119 273 139
A 2 0 0
E 100 1 11
END

ROOM 03
NATION 1
POS 912 772 933 790
A 2 0 0
E 100 1 1
END

ROOM 04
NATION 1
POS 635 308 665 355
A 2 0 0
E 100 1 2
END

ROOM 05
NATION 2
POS 163 860 200 890
A 1 11041 0
E 100 0 0
END

ROOM 06
NATION 1
POS 784 81 805 159
A 1 21041 0
E 100 0 0
END
102.evt





Kod:
    TYPE 0

ROOM 01
NATION 1
POS 120 100 180 200
A 1 21041 0
E 100 0 0
END

ROOM 02
NATION 1
POS 450 140 465 240
A 2 0 0
E 100 1 1
END

ROOM 03
NATION 1
POS 180 420 200 510
A 2 0 0
E 100 1 2
END

ROOM 04
NATION 2
POS 540 760 555 855
A 2 0 0
E 100 1 11
END

ROOM 05
NATION 2
POS 790 490 810 585
A 2 0 0
E 100 1 12
END

ROOM 06
NATION 2
POS 836 820 900 925
A 1 11041 0
E 100 0 0
END
103.evt





Kod:
  TYPE 0

ROOM 01
NATION 1
POS 10 14 355 256
A 1 21041 0
E 100 0 0
END

ROOM 02
NATION 1
POS 562 278 771 491
A 2 0 0
E 100 1 1
END

ROOM 03
NATION 1
POS 605 39 803 251
A 2 0 0
E 100 1 2
END

ROOM 04
NATION 2
POS 227 504 460 728
A 2 0 0
E 100 1 11
END

ROOM 05
NATION 2
POS 180 746 386 968
A 2 0 0
E 100 1 12
END

ROOM 06
NATION 2
POS 651 728 1006 998
A 1 11041 0
E 100 0 0
END
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