• HyperFilter | DoS Protection | DDoS Protection | DoS Mitigation | DDoS Mitigation | AntiDoS | AntiDDoS | Proxy Shielding

[PAYLAŞIM] Colony Zonedaki kuleler geç dalıyorsa çözümü (Detaylı)

MysteriouS

Kayıtlı Üye
Katılım
8 Ağustos 2012
Mesajlar
401
[HIDE-REPLY]
1. işlem :



Query Analyzer'a Eklemeniz gereken kod :



HTML:
DELETE FROM K_NPCPOS

WHERE (NpcID = 5300) OR

(NpcID = 5400)





2. İşlem :



Query Analyzer'a Eklemeniz gereken kod :







HTML:
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, 674, 930, 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, 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, 679, 906, 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, 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, 1329, 1060, 1329, 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, 1429, 1090, 1429, 1090, 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, 1421, 1111, 1421, 1111, 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, 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, 5400, 104, 0, 0, 0, 0, 1324, 1084, 1324, 1084, 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, '' );





3. İşlem :



Query Analyzer'a eklemeniz gereken kod :





HTML:
UPDATE K_NPC SET sAttackDelay = 650 WHERE sSid = 5300

UPDATE K_NPC SET sAttackDelay = 650 WHERE sSid = 5400



Bu işlemlerden sonra Guard Towerların attacklarını ayarlamak isterseniz alttaki kodu kendinize göre editleyin ;



HTML:
UPDATE MAGIC_TYPE3

SET FirstDamage = - 10000

WHERE (iNum = 300139)



DİPNOT : Yukarıdaki kodda 10000 Yazan Yer İle Aynı Şekilde Editlerseniz Kuleler 1 K Vurur Başka Şekildede Editleyebilirsiniz.​
[/HIDE-REPLY]
 
Cevap: [PAYLAŞIM] Colony Zonedaki kuleler geç dalıyorsa çözümü (Detaylı)



bakalım çalışacakmı
 
Cevap: [PAYLAŞIM] Colony Zonedaki kuleler geç dalıyorsa çözümü (Detaylı)



tskklerrrrrrrrrrr
 
Geri
Üst