Home / Server Files Paylaşımları / Prosedür Ve Query Kod Paylaşımları / Lunar Savaşı Tamamen Bugsuz Yapma %100 Fix

Lunar Savaşı Tamamen Bugsuz Yapma %100 Fix

lunar savaşı ve diğer savaşları tamamen bugsuz yapmak isterseniz altaki q.a kodlarını uygulayarak sorunsuz savaş yaptıra bilir ve bugları ortadan kaldira bilirsiniz.

Kodu SQL’ye Uygulamanız Yeterlidir
Verilen Mapları 101-102-103. Maplarınız İle Degiştirin.

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

About admin

Check Also

Usko Maradon Yapımı

Evet Arkadaşlar sizlere herkesin parayla yaptığı bu usko maradon ve usko cz yapımını elimden geldiği …

Bir Cevap Yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir