Kurulum
Kodu SQL'ye Uygulamanız Yeterlidir
Verilen Mapları 101-102-103. Maplarınız İle Degiştirin.
Not : 2 Anlatım Vardır Unutmayınız
Kod:
DELETE
FROM K_NPC
WHERE (strName = 'warder 1') OR
(strName = 'warder 2') OR
(strName = 'keeper')
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)
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 ( 21041, 'Keeper', 11610, 100, 130650179, 170450000, 2, 7, 11, 1, 1, 2, 0, 80, 0, 0, 215000, 0, 0, 15000, 375, 375, 8000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 2000, 21011, 0, 0, 1 );
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 ( 21042, 'Warder 1', 11610, 100, 130450179, 170450000, 2, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 6000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 21045, 'Warder 2', 11610, 100, 130450179, 170450000, 2, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 6000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 11041, 'Keeper', 21610, 100, 120310049, 170450000, 1, 7, 11, 1, 1, 2, 0, 80, 0, 0, 215000, 0, 0, 15000, 375, 375, 5000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 2000, 21011, 0, 0, 1 );
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 ( 11042, 'Warder 1', 21610, 100, 120710049, 170450000, 1, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 4000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 11047, 'Warder 2', 21610, 100, 120710049, 170450000, 1, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 4000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21045, 104, 1, 3, 0, 0, 807, 545, 810, 542, 794, 548, 814, 530, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11047, 104, 1, 5, 0, 0, 176, 455, 178, 453, 167, 465, 188, 446, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21041, 104, 1, 1, 98, 0, 947, 949, 949, 946, 944, 952, 952, 943, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21042, 104, 1, 2, 0, 0, 554, 816, 557, 813, 541, 819, 560, 801, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11041, 104, 1, 6, 99, 0, 73, 77, 76, 75, 64, 84, 82, 66, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11042, 104, 1, 4, 0, 0, 450, 188, 453, 186, 444, 193, 461, 179, 1, 30, 0, 0, '' );
101. Map
Kod:
TYPE 0
ROOM 01
NATION 2
POS 275 570 325 600
A 2 0 0
E 100 1 12
END
ROOM 02
NATION 2
POS 195 119 273 139
A 2 0 0
E 100 1 11
END
ROOM 03
NATION 1
POS 912 772 933 790
A 2 0 0
E 100 1 1
END
ROOM 04
NATION 1
POS 635 308 665 355
A 2 0 0
E 100 1 2
END
ROOM 05
NATION 2
POS 163 860 200 890
A 1 11041 0
E 100 0 0
END
ROOM 06
NATION 1
POS 784 81 805 159
A 1 21041 0
E 100 0 0
END
102. Map
Kod:
TYPE 0
ROOM 01
NATION 1
POS 120 100 180 200
A 1 21041 0
E 100 0 0
END
ROOM 02
NATION 1
POS 450 140 465 240
A 2 0 0
E 100 1 1
END
ROOM 03
NATION 1
POS 180 420 200 510
A 2 0 0
E 100 1 2
END
ROOM 04
NATION 2
POS 540 760 555 855
A 2 0 0
E 100 1 11
END
ROOM 05
NATION 2
POS 790 490 810 585
A 2 0 0
E 100 1 12
END
ROOM 06
NATION 2
POS 836 820 900 925
A 1 11041 0
E 100 0 0
END
103. Map
Kod:
TYPE 0
ROOM 01
NATION 1
POS 10 14 355 256
A 1 21041 0
E 100 0 0
END
ROOM 02
NATION 1
POS 562 278 771 491
A 2 0 0
E 100 1 1
END
ROOM 03
NATION 1
POS 605 39 803 251
A 2 0 0
E 100 1 2
END
ROOM 04
NATION 2
POS 227 504 460 728
A 2 0 0
E 100 1 11
END
ROOM 05
NATION 2
POS 180 746 386 968
A 2 0 0
E 100 1 12
END
ROOM 06
NATION 2
POS 651 728 1006 998
A 1 11041 0
E 100 0 0
END
Kolay Gelsin ..
2 Ci Anlatım Aşağıdadır
Asagıdaki kod
+open2
savası icin kullanılır bugsuz savas kodu
Hepsi Q.A Kodudur.
Kod:
DELETE
FROM K_NPC
WHERE (strName = 'warder 1') OR
(strName = 'warder 2') OR
(strName = 'keeper')
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)
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)
Kod:
INSERT INTO [K_NPC] Values(11041,'Keeper',11610,100,120310049,17045000 0,2,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,5 000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,10 0,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,2 1011,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,2 1011,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,2 1011,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,2 1011,0,0,1)
INSERT INTO [K_NPC] Values(21041,'Keeper',21610,100,130650179,17045000 0,1,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,8 000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,10 0,90,7,14,35,2000,21011,0,0,1)
5. Ve Son Kod`umuz.
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'
Buraya Kadar Herşey Tamam.
Şimdi Sıra Geldi Sorunsuz 101 102 103 Evt. Lere
Kod İçin Uygun Bir Evt'dir.Lütfen İndirin Aksi Halde İsim Geçmeme Gibi Sorunla Karşılaşabilirsiniz.
Evt. leri Ai Server MAP Atınız.
Link : [Linkleri Görebilmek İcin ]
Not : Linkler Bozuk Bozulan Linklerde Yukardaki 101-102-103. Maplarınız İle Degiştirin.
Kodu SQL'ye Uygulamanız Yeterlidir
Verilen Mapları 101-102-103. Maplarınız İle Degiştirin.
Not : 2 Anlatım Vardır Unutmayınız
Kod:
DELETE
FROM K_NPC
WHERE (strName = 'warder 1') OR
(strName = 'warder 2') OR
(strName = 'keeper')
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)
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 ( 21041, 'Keeper', 11610, 100, 130650179, 170450000, 2, 7, 11, 1, 1, 2, 0, 80, 0, 0, 215000, 0, 0, 15000, 375, 375, 8000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 2000, 21011, 0, 0, 1 );
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 ( 21042, 'Warder 1', 11610, 100, 130450179, 170450000, 2, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 6000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 21045, 'Warder 2', 11610, 100, 130450179, 170450000, 2, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 6000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 11041, 'Keeper', 21610, 100, 120310049, 170450000, 1, 7, 11, 1, 1, 2, 0, 80, 0, 0, 215000, 0, 0, 15000, 375, 375, 5000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 2000, 21011, 0, 0, 1 );
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 ( 11042, 'Warder 1', 21610, 100, 120710049, 170450000, 1, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 4000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
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 ( 11047, 'Warder 2', 21610, 100, 120710049, 170450000, 1, 7, 11, 1, 1, 2, 0, 70, 0, 5000, 150000, 0, 0, 10000, 275, 275, 4000, 1500, 2, 7, 1000, 0, 0, 0, 500, 500, 500, 500, 500, 500, 500, 90, 7, 14, 35, 1000, 21011, 0, 0, 1 );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21045, 104, 1, 3, 0, 0, 807, 545, 810, 542, 794, 548, 814, 530, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11047, 104, 1, 5, 0, 0, 176, 455, 178, 453, 167, 465, 188, 446, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21041, 104, 1, 1, 98, 0, 947, 949, 949, 946, 944, 952, 952, 943, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 21042, 104, 1, 2, 0, 0, 554, 816, 557, 813, 541, 819, 560, 801, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11041, 104, 1, 6, 99, 0, 73, 77, 76, 75, 64, 84, 82, 66, 1, 30, 0, 0, '' );
INSERT INTO K_NPCPOS ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) VALUES ( 102, 11042, 104, 1, 4, 0, 0, 450, 188, 453, 186, 444, 193, 461, 179, 1, 30, 0, 0, '' );
101. Map
Kod:
TYPE 0
ROOM 01
NATION 2
POS 275 570 325 600
A 2 0 0
E 100 1 12
END
ROOM 02
NATION 2
POS 195 119 273 139
A 2 0 0
E 100 1 11
END
ROOM 03
NATION 1
POS 912 772 933 790
A 2 0 0
E 100 1 1
END
ROOM 04
NATION 1
POS 635 308 665 355
A 2 0 0
E 100 1 2
END
ROOM 05
NATION 2
POS 163 860 200 890
A 1 11041 0
E 100 0 0
END
ROOM 06
NATION 1
POS 784 81 805 159
A 1 21041 0
E 100 0 0
END
102. Map
Kod:
TYPE 0
ROOM 01
NATION 1
POS 120 100 180 200
A 1 21041 0
E 100 0 0
END
ROOM 02
NATION 1
POS 450 140 465 240
A 2 0 0
E 100 1 1
END
ROOM 03
NATION 1
POS 180 420 200 510
A 2 0 0
E 100 1 2
END
ROOM 04
NATION 2
POS 540 760 555 855
A 2 0 0
E 100 1 11
END
ROOM 05
NATION 2
POS 790 490 810 585
A 2 0 0
E 100 1 12
END
ROOM 06
NATION 2
POS 836 820 900 925
A 1 11041 0
E 100 0 0
END
103. Map
Kod:
TYPE 0
ROOM 01
NATION 1
POS 10 14 355 256
A 1 21041 0
E 100 0 0
END
ROOM 02
NATION 1
POS 562 278 771 491
A 2 0 0
E 100 1 1
END
ROOM 03
NATION 1
POS 605 39 803 251
A 2 0 0
E 100 1 2
END
ROOM 04
NATION 2
POS 227 504 460 728
A 2 0 0
E 100 1 11
END
ROOM 05
NATION 2
POS 180 746 386 968
A 2 0 0
E 100 1 12
END
ROOM 06
NATION 2
POS 651 728 1006 998
A 1 11041 0
E 100 0 0
END
Kolay Gelsin ..
2 Ci Anlatım Aşağıdadır
Asagıdaki kod
+open2
savası icin kullanılır bugsuz savas kodu
Hepsi Q.A Kodudur.
Kod:
DELETE
FROM K_NPC
WHERE (strName = 'warder 1') OR
(strName = 'warder 2') OR
(strName = 'keeper')
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)
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)
Kod:
INSERT INTO [K_NPC] Values(11041,'Keeper',11610,100,120310049,17045000 0,2,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,5 000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,10 0,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,2 1011,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,2 1011,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,2 1011,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,2 1011,0,0,1)
INSERT INTO [K_NPC] Values(21041,'Keeper',21610,100,130650179,17045000 0,1,7,11,1,1,2,0,80,0,0,215000,0,0,15000,375,375,8 000,1500,2,7,1000,0,0,0,100,100,100,100,100,100,10 0,90,7,14,35,2000,21011,0,0,1)
5. Ve Son Kod`umuz.
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'
Buraya Kadar Herşey Tamam.
Şimdi Sıra Geldi Sorunsuz 101 102 103 Evt. Lere
Kod İçin Uygun Bir Evt'dir.Lütfen İndirin Aksi Halde İsim Geçmeme Gibi Sorunla Karşılaşabilirsiniz.
Evt. leri Ai Server MAP Atınız.
Link : [Linkleri Görebilmek İcin ]
Not : Linkler Bozuk Bozulan Linklerde Yukardaki 101-102-103. Maplarınız İle Degiştirin.