Hiç kimsenin çözemediği şu lanet sorunu çözen birisi çıksın artık..!!

[Ronin_Empire]

Fazla uzatmama gerek yok kuleler calısmıyor.. su an piyasadaki hic bir serverdada calısmaz.. sadece db ile alakalı olan bişey deil bu sw fileslerlede alakalı gercekten kulelerin uskodaki gibi vurmasını saglayacak birileri varsa ilgilensin.. coluk cocukla ugrasacak durumda deiliz..

[email protected] ==> iletişim..

 

[Audreys]

Cevap: Hiç kimsenin çözemediği şu lanet sorunu çözen birisi çıksın artık..!!

1) Burası server-kurulumu yani paylaşım yeridir buraya sorunlarınızı açmayın. Eğer bi sorununuz varsa yardım bölümlerini kullanın kesin cevap alırsınız.
2) Birilerinden yardım isterken birazcık rica olarak isteyinki yardım edecek adamın "bu adam yapamamış, belki bilmiyormuş ben biliyorum yapayım şuna" desin.

Server fileslerle alakalı bir guard tower sorunu görmedim baştan yapalım;

Kod 1:

DELETE FROM K_NPC
WHERE     (sSid = 5300) OR
                      (sSid = 5400)

Kod 2:

DELETE FROM K_NPCPOS
WHERE     (NpcID = 5300) OR
                      (NpcID = 5400)

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 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, '' );

Buraylada kaç vursun ayarlıyabilirsin;

UPDATE    MAGIC_TYPE3
SET              FirstDamage = - 10000
WHERE     (iNum = 300139)

Ordaki -10000 towerlarin 1000 - 2000 vurmasini saglar.
Kendinize göre editleyebilirsiniz.

 

[kubi753]

Cevap: Hiç kimsenin çözemediği şu lanet sorunu çözen birisi çıksın artık..!!