Sorunsuz Guard Tower (ortadaki 4 KULE Dahil) .. 2013 ..

delete from k_npc where ssid = 5300 

delete from k_npc where ssid = 5400

delete from k_npcpos where  zoneid = 201 and npcid = 5300

delete from k_npcpos where  zoneid = 201 and npcid = 5400

INSERT INTO [k_npc] Values (5300,'Guard Tower',5301,100,0,0,2,0,62,1,1,1,0,90,0,0,100000,0,0,15000,497,497,0,1500,0,0,1000,300139,0,0,255,255,255,255,255,255,255,200,30,35,35,0,0,1,1,0)

INSERT INTO [k_npc] Values (5400,'Guard Tower',5401,100,0,0,1,0,62,1,1,1,0,90,0,0,100000,0,0,15000,497,497,0,1500,0,0,1000,300139,0,0,255,255,255,255,255,255,255,200,30,35,35,0,0,1,1,0)

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 597, 914, 599, 912, 588, 924, 610, 902, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 668, 929, 674, 930, 659, 939, 677, 919, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 601, 897, 603, 895, 591, 906, 614, 885, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 649, 926, 648, 922, 638, 932, 658, 915, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 649, 910, 651, 908, 643, 916, 662, 897, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 593, 949, 595, 947, 585, 955, 603, 942, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 634, 954, 636, 952, 627, 959, 646, 945, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 651, 873, 653, 872, 646, 881, 662, 863, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 613, 864, 615, 862, 603, 872, 629, 850, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 633, 865, 635, 863, 628, 873, 649, 853, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 666, 886, 668, 884, 660, 893, 681, 873, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 594, 870, 596, 868, 587, 876, 608, 860, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 655, 949, 657, 947, 648, 956, 671, 935, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 675, 910, 679, 906, 658, 917, 680, 893, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 575, 927, 576, 908, 567, 918, 582, 901, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 566, 907, 566, 907, 580, 944, 589, 927, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 572, 884, 572, 884, 573, 894, 589, 879, 1, 60, 0, 0, '' );

INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinX], [LimitMinZ], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 201, 5300, 104, 0, 0, 0, 0, 613, 956, 616, 954, 606, 963, 625, 946, 1, 60, 0, 0, '' );

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1361,1134,1363,1133,1139,1354,1373,1124,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1334,1062,1336,1060,1068,1330,1346,1053,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1352,1097,1351,1085,1094,1342,1360,1078,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1398,1101,1400,1099,1108,1394,1410,1089,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1403,1086,1404,1085,1092,1396,1418,1075,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1383,1136,1385,1134,1141,1379,1392,1128,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1409,1050,1411,1049,1056,1406,1419,1043,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1366,1038,1368,1037,1047,1358,1374,1030,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1389,1039,1390,1037,1045,1382,1398,1029,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1345,1044,1347,1042,1049,1340,1356,1035,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1405,1130,1407,1128,1135,1397,1419,1117,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1418,1111,1416,1109,1117,1407,1423,1101,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1330,1095,1330,1083,1092,1320,1338,1076,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1328,1110,1329,1108,1117,1321,1339,1100,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1354,1072,1356,1071,1079,1348,1363,1062,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1343,1125,1345,1124,1130,1338,1353,1117,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1423,1066,1424,1065,1072,1418,1436,1055,1,60,0,0,'')

INSERT INTO [k_npcpos] Values (201,5400,104,0,0,0,0,1422,1088,1423,1086,1095,1413,1431,1077,1,60,0,0,'')

insert into [K_NPCPOS] values ('201','5400','104','0','0','0','0','1374','1077','1375','1076','1370','1081','1379','1072','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5400','104','0','0','0','0','1367','1085','1368','1084','1363','1089','1371','1081','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5400','104','0','0','0','0','1374','1093','1376','1091','1370','1096','1379','1088','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5400','104','0','0','0','0','1382','1085','1383','1084','1378','1089','1387','1080','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5300','104','0','0','0','0','631','911','632','910','625','917','637','904','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5300','104','0','0','0','0','611','911','613','909','606','916','618','904','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5300','104','0','0','0','0','621','921','622','920','615','926','627','914','1','60','0','0','');

insert into [K_NPCPOS] values ('201','5300','104','0','0','0','0','621','902','622','900','616','907','627','895','1','60','0','0','');

UPDATE K_NPC SET sAttackDelay = 550

 WHERE strname = 'Guard Tower'

UPDATE    MAGIC_TYPE3

SET              FirstDamage = - 13000

WHERE     (iNum = 300139)