Sorunsuz 103 , [ +open3 ] , [ Dark Lunar War ] , [ 30-59]

Sorunsuz 103 , [ +open3 ] , [ Dark Lunar War ] , [ 30-59]
<BLOCKQUOTE class="postcontent restore ">

Sorunsuz 103 , [ +open3 ] , [ Dark Lunar War ] , [ 30-59] Reklam

Öncelikle Forumda Verildiyse Özür Dilerim ;
Ama Bir Çok Konu Açtım Cevaplanmadı yada çözüLmedi sanırım verilmemiştir..

İlk Olarak Mevcut Keeper Ve Warderleri Silelim.

Kod:
DELETE
Kod:

FROM K_NPC

WHERE (strName = 'warder 1') OR

(strName = 'warder 2') OR
(strName = 'keeper')

Kod:
DELETE

Kod:

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)

Sorunsuz Yenilerini Ekliyelim ;

Kod:
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)

Kod:

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)

Ve Zoneleri Elden Geçirelim ;

Kod:
update zone_info set roomevent = '101'

Kod:

where zoneno = '101'

go

update zone_info set roomevent = '102'

where zoneno = '102'

go

update zone_info set roomevent = '103'

where zoneno = '103'

go

Buda 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

Bi Teşekkür Yeter

</BLOCKQUOTE>

» SORUNSUZ ADREAM BY IBO
» SORUNSUZ ADREAM
» TÜM SORUNSUZ PACTHLER
» SORUNSUZ MORA
» SORUNSUZ NPC SİLME