Human Towerları Aktif Etme

Kod:
--Kod 1
DELETE FROM K_NPC
WHERE (sSid = 5300) OR
(sSid = 5400)

Kod:
--Kod 2
DELETE FROM K_NPCPOS
WHERE (NpcID = 5300) OR
(NpcID = 5400)

Kod:
--Kod 3
INSERT INTO K_NPC ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup],
[byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint],
[sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2],
[sStandtime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR],
[sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem],
[byDirectAttack], [byMagicAttack], [byMoneyType] ) 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_NPC ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup],
[byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint],
[sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2],
[sStandtime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR],
[sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem],
[byDirectAttack], [byMagicAttack], [byMoneyType] ) 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 );

Kod:
--Kod 4
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,
665, 930, 666, 928, 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, 5400, 104, 0, 0, 0, 0,
1328, 1110, 1329, 1108, 1321, 1117, 1339, 1100, 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,
646, 924, 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,
669, 907, 671, 905, 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,
574, 911, 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, 5400, 104, 0, 0, 0, 0,
1361, 1134, 1363, 1133, 1354, 1139, 1373, 1124, 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, 5400, 104, 0, 0, 0, 0,
1334, 1062, 1336, 1060, 1330, 1068, 1346, 1053, 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, 5400, 104, 0, 0, 0, 0,
1349, 1087, 1351, 1085, 1342, 1094, 1360, 1078, 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, 5400, 104, 0, 0, 0, 0,
1354, 1072, 1356, 1071, 1348, 1079, 1363, 1062, 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, 5400, 104, 0, 0, 0, 0,
1398, 1101, 1400, 1099, 1394, 1108, 1410, 1089, 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, 5400, 104, 0, 0, 0, 0,
1403, 1086, 1404, 1085, 1396, 1092, 1418, 1075, 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, 5400, 104, 0, 0, 0, 0,
1343, 1125, 1345, 1124, 1338, 1130, 1353, 1117, 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, 5400, 104, 0, 0, 0, 0,
1383, 1136, 1385, 1134, 1379, 1141, 1392, 1128, 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, 5400, 104, 0, 0, 0, 0,
1409, 1050, 1411, 1049, 1406, 1056, 1419, 1043, 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, 5400, 104, 0, 0, 0, 0,
1366, 1038, 1368, 1037, 1358, 1047, 1374, 1030, 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, 5400, 104, 0, 0, 0, 0,
1389, 1039, 1390, 1037, 1382, 1045, 1398, 1029, 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, 5400, 104, 0, 0, 0, 0,
1423, 1066, 1424, 1065, 1418, 1072, 1436, 1055, 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, 5400, 104, 0, 0, 0, 0,
1345, 1044, 1347, 1042, 1340, 1049, 1356, 1035, 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, 5400, 104, 0, 0, 0, 0,
1405, 1130, 1407, 1128, 1397, 1135, 1419, 1117, 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, 5400, 104, 0, 0, 0, 0,
1422, 1088, 1423, 1086, 1413, 1095, 1431, 1077, 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, 5400, 104, 0, 0, 0, 0,
1414, 1111, 1416, 1109, 1407, 1117, 1423, 1101, 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,
577, 936, 579, 934, 570, 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,
580, 887, 582, 886, 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, 5400, 104, 0, 0, 0, 0,
1328, 1085, 1330, 1083, 1320, 1092, 1338, 1076, 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, '' );