SAVASI BUGSUZ YAPMA

Arkadaşlar Öncelikle İyi Form'lar.

Biliyorsunuzki Server Herşey Sorunsuz oluyor ama Lunar Bug'u insanı deli ediyor.

Bende Sizin İçin Kod'ları paylaşıyorum.

Tamamen Sorunsuzdur. Warder & Keeper kesince alttan notice geçer NP Verir.

Kodlar ALINTIDIR.

Hepsi Q.A Kodudur.

1. Kod


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


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


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)
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)
4. Kod



Kod:
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)
5. Ve Son Kodumuz.



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