Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

razorlight
Konu Yazar

razorlight

Banlanmış
Kalemi Kırıldı!
Tem
199
5
Arkadaslar İstedigi Databaseyi Bulamayanlar Kendilerine Database Yapabilir

Ben Yapamayan Arkdaslara

Kücücük Bir Yardım AMACIYLA bu Konuyu Actım

Amaç Paylasmak Degilmi Sonuçta


resm1.png


resm2.png


resm3q.png


resm4.png


resm5.png


resm6.png


resm7.png


resm8.png


Asagıdada Databasede Cok Bulanan Bugları Fixlemek İcin

query Analyzer Kodları Verdim Buyrun Bakın

Seri R'yi Fixlemek

delete from magic where magicnum = '105720'
delete from magic where magicnum = '105755'
delete from magic where magicnum = '106720'
delete from magic where magicnum = '106755'
delete from magic where magicnum = '106770'
delete from magic where magicnum = '205720'
delete from magic where magicnum = '205755'
delete from magic where magicnum = '206720'
delete from magic where magicnum = '206755'
delete from magic where magicnum = '206770'
Genişletmek için tıkla ...

Savası Tamamen Bugsuz Yapmak



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, '' );
Genişletmek için tıkla ...

Savastan Kalanları Maradona ATMAK

update userdata set Zone = '21' where Zone = '101' or Zone = '102'
Genişletmek için tıkla ...

Stat Bugunu Fixlemek İcin



CREATE PROCEDURE [dbo].[REPAIR_USER_STAT_POINTS]
@strUserID varchar(21)
AS
/*
Author : SirReaL
*/
DECLARE @Level int, @Point tinyint, @Class int,@NewPoint int

SELECT @Level = Level,@Class = Class,@Point = Points FROM USERDATA WHERE strUserId = @strUserID

IF @Level >= 74 AND @Point = 31
BEGIN
/*
IF @Level = 71
BEGIN
SET @NewPoint = 210
END
ELSE IF @Level = 72
BEGIN
SET @NewPoint = 215
END
ELSE IF @Level = 73
BEGIN
SET @NewPoint = 220
END
ELSE IF @Level = 74
*/
IF @Level = 74
BEGIN
SET @NewPoint = 225
END
ELSE IF @Level = 75
BEGIN
SET @NewPoint = 230
END
ELSE IF @Level = 76
BEGIN
SET @NewPoint = 235
END
ELSE IF @Level = 77
BEGIN
SET @NewPoint = 240
END
ELSE IF @Level = 78
BEGIN
SET @NewPoint = 245
END
ELSE IF @Level = 79
BEGIN
SET @NewPoint = 250
END
ELSE IF @Level = 80
BEGIN
SET @NewPoint = 255
END

IF @Class = 201 OR @Class = 205 OR @Class = 206 OR @Class = 101 OR @Class = 105 OR @Class = 106
BEGIN
UPDATE USERDATA Set Strong = '97',Dex = '60',Sta = '65',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
END
ELSE IF @Class = 202 OR @Class = 207 OR @Class = 208 OR @Class = 102 OR @Class = 107 OR @Class = 108
BEGIN
UPDATE USERDATA Set Strong = '60',Dex = '102',Sta = '60',Intel = '50',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
END
ELSE IF @Class = 203 OR @Class = 209 OR @Class = 210 OR @Class = 103 OR @Class = 109 OR @Class = 110
BEGIN
UPDATE USERDATA Set Strong = '50',Dex = '70',Sta = '50',Intel = '70',Cha = '82',Points = @NewPoint WHERE strUserId = @strUserId
END
ELSE IF @Class = 204 OR @Class = 211 OR @Class = 212 OR @Class = 104 OR @Class = 111 OR @Class = 112
BEGIN
UPDATE USERDATA Set Strong = '65',Dex = '60',Sta = '65',Intel = '82',Cha = '50',Points = @NewPoint WHERE strUserId = @strUserId
END
END
GO
Genişletmek için tıkla ...

Keeper Kesince Isınlanma Sorunu

CREATE PROCEDURE MGAME_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO
Genişletmek için tıkla ...

Warder Kesince Savası Kaybetmeme

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]
Genişletmek için tıkla ...

Warder Ve Keeper Kesince Notice Gecmesi

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)

Daha sonra K_NPCPOS tablosuna şunu ekleyin:
Kod:

103 21045 104 1 3 91 0 670 143 671 142 670 144 672 142 1 30 0 0
101 21045 104 1 3 91 0 597 300 600 297 596 301 601 296 1 30 0 0
102 21045 104 1 3 91 0 176 455 178 453 167 465 188 446 1 30 0 0
102 11047 104 1 5 93 0 807 545 810 542 794 548 814 530 1 30 0 0
102 21041 104 1 1 98 0 73 77 76 75 64 84 82 66 1 30 0 0
102 21042 104 1 2 90 0 450 188 453 186 444 193 461 179 1 30 0 0
102 11041 104 1 6 99 0 947 949 949 946 944 952 952 943 1 30 0 0
102 11042 104 1 4 92 0 554 816 557 813 541 819 560 801 1 30 0 0

K_NPC tablosunada bunu ekleyin:
Kod:

11041 Keeper 11610 100 120310049 170450000 2 7 11 1 1 2 0 80 0 0 215000 0 0 15000 375 375 5000 1500 2 7 1000 0 0 0 100 100 100 100 100 100 100 90 7 14 35 2000 21011 0 0 1
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 21011 0 0 1
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 21011 0 0 1
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 21011 0 0 1
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 21011 0 0 1
21041 Keeper 21610 100 130650179 170450000 1 7 11 1 1 2 0 80 0 0 215000 0 0 15000 375 375 8000 1500 2 7 1000 0 0 0 100 100 100 100 100 100 100 90 7 14 35 2000 21011 0 0 1

Daha sonra Ai-server'ın map dosyasına bunu atın:
http://rapidshare.com/files/126198476/evt.rar.html
Son olarak ZONE_INFO'da 101 102 ve 103 için roomevent bölümüne sırasıyla 101 102 ve 103 yazın.
Artık warder ve keeper kesince hem NOTICE geçer hemde np gelir.

NOT: Klasik lunar bug çözümü değildir. Yapılan işlem eski warder ve keeperı yerine getirir. Çünkü Sorun warder ve keeperda değil evt dosyalarındadır.
Genişletmek için tıkla ...

DEVAMI YORUMLARDA
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Şimdi Servera Serverı Özellestircek Seler Eklıyelım :D

Czye Ronork Momument Ekleme

insert into k_npc values (32578 , 'Ronark Monument' , 14005 , 120 , 0 , 0 , 1 , 0 , 2 , 1 , 1 , 1 , 0 , 80 , 0 , 75 , 85713 , 0 , 0 , 800 , 124 , 124 , 0 , 1000 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 100 , 5 , 5 , 5 , 32000 , 32578 , 0 , 0 , 0)


insert into k_npcpos values (201 , 32578 , 137 , 0 , 0 , 0 , 0 , 1014 , 1005 , 1014 , 1005 , 1005 , 1014 , 1014 , 1005 , 1 , 1000 , 0 , 0 ,0)
Genişletmek için tıkla ...

Databaseye Ardream Eklemek

Monsterlar




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 ( 202, 2023, 1, 0, 0, 0, 0, 369, 489, 489, 509, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 2021, 1, 0, 0, 0, 0, 527, 644, 538, 679, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 2021, 1, 0, 0, 0, 0, 504, 619, 524, 639, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1821, 1, 0, 0, 0, 0, 590, 721, 610, 742, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1821, 1, 0, 0, 0, 0, 575, 689, 589, 710, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1821, 1, 0, 0, 0, 0, 606, 688, 626, 710, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1901, 1, 0, 0, 0, 0, 633, 659, 653, 679, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1901, 1, 0, 0, 0, 0, 632, 620, 649, 639, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1901, 1, 0, 0, 0, 0, 618, 630, 638, 650, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1823, 1, 0, 0, 0, 0, 580, 621, 599, 642, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1823, 1, 0, 0, 0, 0, 603, 606, 628, 626, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1696, 1, 0, 0, 0, 0, 437, 571, 451, 591, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1696, 1, 0, 0, 0, 0, 410, 570, 426, 592, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1696, 1, 0, 0, 0, 0, 401, 597, 412, 619, 0, 0, 0, 0, 3, 40, 0, 2, '' );
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 ( 202, 1744, 1, 0, 0, 0, 0, 427, 628, 442, 643, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1744, 1, 0, 0, 0, 0, 486, 652, 512, 673, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1743, 1, 0, 0, 0, 0, 384, 726, 410, 742, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1743, 1, 0, 0, 0, 0, 414, 700, 436, 721, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1743, 1, 0, 0, 0, 0, 439, 729, 461, 749, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1742, 1, 0, 0, 0, 0, 315, 646, 335, 666, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1742, 1, 0, 0, 0, 0, 359, 640, 372, 662, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1742, 1, 0, 0, 0, 0, 375, 669, 389, 681, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1695, 1, 0, 0, 0, 0, 561, 454, 571, 474, 0, 0, 0, 0, 4, 40, 0, 2, '' );
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 ( 202, 1695, 1, 0, 0, 0, 0, 562, 425, 579, 442, 0, 0, 0, 0, 4, 40, 0, 2, '' );
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 ( 202, 6924, 1, 1, 0, 0, 0, 651, 128, 653, 126, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 503, 1, 1, 0, 0, 0, 573, 150, 575, 148, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1210, 1, 1, 0, 0, 0, 463, 161, 465, 159, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1211, 1, 1, 0, 0, 0, 391, 93, 393, 91, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 2451, 1, 1, 0, 0, 0, 327, 171, 329, 169, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1310, 1, 1, 0, 0, 0, 245, 223, 247, 221, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 609, 1, 1, 0, 0, 0, 230, 331, 232, 329, 0, 0, 0, 0, 5, 40, 0, 2, '' );
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 ( 202, 1701, 1, 1, 0, 0, 0, 122, 304, 120, 302, 0, 0, 0, 0, 5, 40, 0, 2, '' );


Towerları Ve Npcleri Eklemek


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 ( 202, 16096, 140, 0, 0, 0, 0, 193, 910, 193, 910, 193, 910, 193, 910, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 161, 894, 161, 894, 161, 894, 161, 894, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 149, 914, 149, 914, 149, 914, 149, 914, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 113, 883, 113, 883, 113, 883, 113, 883, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 222, 900, 222, 900, 222, 900, 222, 900, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 219, 913, 219, 913, 219, 913, 219, 913, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 138, 870, 138, 870, 138, 870, 138, 870, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 213, 872, 213, 872, 213, 872, 213, 872, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 193, 871, 193, 871, 193, 871, 193, 871, 1, 90, 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 ( 202, 5300, 104, 0, 0, 0, 0, 182, 873, 182, 873, 182, 873, 182, 873, 1, 90, 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 ( 202, 12120, 140, 0, 0, 0, 0, 187, 910, 187, 910, 187, 910, 187, 910, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 788, 82, 788, 82, 788, 82, 788, 82, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 799, 130, 799, 130, 799, 130, 799, 130, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 785, 115, 785, 115, 785, 115, 785, 115, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 803, 113, 803, 113, 803, 113, 803, 113, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 821, 150, 821, 150, 821, 150, 821, 150, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 831, 161, 831, 161, 831, 161, 831, 161, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 848, 154, 848, 154, 848, 154, 848, 154, 1, 90, 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 ( 202, 5400, 104, 0, 0, 0, 0, 871, 148, 871, 148, 871, 148, 871, 148, 1, 90, 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 ( 202, 22120, 140, 0, 0,0, 0, 855, 137, 855, 137, 855, 137, 855, 137, 1, 90, 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 ( 202, 16096, 140, 0, 0, 0, 0, 850, 132, 850, 132, 850, 132, 850, 132, 1, 90, 0, 0, '' );
Genişletmek için tıkla ...



İlk 5 Clanın Heykeli

Npc Ler

DELETE FROM K_NPC WHERE sSid = 16048 or sSid = 16049 or sSid = 16050 or 26148 or sSid = 26149 or sSid = 26150 or 26248 or sSid = 26249 or sSid = 26250 or sSid like '17%' or sSid like '19%'
GO

---------- Luferson

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 (19011, '1. Clan:', 30090, 100, 0, 0, 1, 7, 106, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19012, '2. Clan:', 30089, 100, 0, 0, 1, 7, 107, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19013, '3. Clan:', 30088, 100, 0, 0, 1, 7, 108, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19014, '4. Clan:', 30088, 100, 0, 0, 1, 7, 108, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19015, '5. Clan:', 30088, 100, 0, 0, 1, 7, 108, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

---------- EMC


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 (19021, '1. Clan:', 30090, 100, 0, 0, 2, 7, 106, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19022, '2. Clan:', 30089, 100, 0, 0, 2, 7, 107, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19023, '3. Clan:', 30088, 100, 0, 0, 2, 7, 108, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19024, '4. Clan:', 30088, 100, 0, 0, 2, 7, 108, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

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 (19025, '5. Clan:', 30088, 100, 0, 0, 2, 7, 108, 1, 4, 3, 0, 90, 0, 0, 120000, 0, 0, 20000, 497, 497, 4000, 1500, 2, 7, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 32000, 0, 0, 0, 1)
GO

Npc Pozisyonları

DELETE FROM K_NPCPOS WHERE NpcID = 16048 or NpcID = 16049 or NpcID = 16050 or NpcID = 26148 or NpcID = 26149 or NpcID = 26150 or NpcID = 26248 or NpcID = 26249 or NpcID = 26250 or NPCID like '17%' or NPCID like '19%'
GO

------------ Karus

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 (1, 19011, 103, 0, 0, 0, 0, 448, 1643, 448, 1643, 448, 1643, 448, 1643, 1, 3600, 0, 2, '0448164304481643')
GO

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 (1, 19012, 103, 0, 0, 0, 0, 442, 1649, 442, 1649, 442, 1649, 442, 1649, 1, 3600, 0, 2, '0442164904421649')
GO

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 (1, 19013, 103, 0, 0, 0, 0, 436, 1655, 436, 1655, 436, 1655, 436, 1655, 1, 3600, 0, 2, '0436165504361655')
GO

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 (1, 19014, 103, 0, 0, 0, 0, 430, 1661, 430, 1661, 430, 1661, 430, 1661, 1, 3600, 0, 2, '0430166104301661')
GO

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 (1, 19015, 103, 0, 0, 0, 0, 424, 1667, 424, 1667, 424, 1667, 424, 1667, 1, 3600, 0, 2, '0424166704241667')
GO

------------ Elmo

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 (2, 19021, 103, 0, 0, 0, 0, 1605, 418, 1605, 418, 1605, 418, 1605, 418, 1, 3600, 0, 2, '1605041816050418')
GO

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 (2, 19022, 103, 0, 0, 0, 0, 1611, 412, 1611, 412, 1611, 412, 1611, 412, 1, 3600, 0, 2, '1611041216110412')
GO

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 (2, 19023, 103, 0, 0, 0, 0, 1617, 406, 1617, 406, 1617, 406, 1617, 406, 1, 3600, 0, 2, '1617040616170406')
GO

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 (2, 19024, 103, 0, 0, 0, 0, 1623, 400, 1623, 400, 1623, 400, 1623, 400, 1, 3600, 0, 2, '1623040016230400')
GO

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 (2, 19025, 103, 0, 0, 0, 0, 1629, 394, 1629, 394, 1629, 394, 1629, 394, 1, 3600, 0, 2, '1629039416290394')
GO
Genişletmek için tıkla ...

Maradona Sıralama Npc'si Eklemek

insert into K_NPC Values (12353,'SIRALAMALAR',2050,100,120710000,170210000,2,7,26,1,3,3,0,90,100,0,120000,0,0,20000,497,497,4000,1500,0,0,1000,0,0,0,250,250,250,250,250,250,250,90,7,14,35,32000,21510,0,0,1)
Genişletmek için tıkla ...

83 Lvl STATLAR VERİLİ Master Acık Baslatma

CREATE PROCEDURE CREATE_NEW_CHAR

@nRet smallint OUTPUT,
@AccountID char(21),
@index tinyint,
@CharID char(21),
@Race tinyint,
@Class smallint,
@Hair tinyint,
@Face tinyint,
@Str tinyint,
@Sta tinyint,
@Dex tinyint,
@Intel tinyint,
@Cha tinyint

AS

DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int
SET @Row = 0 SET @Nation = 0 SET @Zone = 0 SET @PosX = 0 SET @PosZ = 0

SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID

IF @Row >= 5 SET @nRet = 1

IF @Nation = 1 AND @Race > 10 SET @nRet = 2
ELSE IF @Nation = 2 AND @Race < 10 SET @nRet = 2
ELSE IF @Nation <>1 AND @Nation <> 2 SET @nRet = 2

IF @nRet > 0
RETURN

SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID
IF @Row > 0
BEGIN
SET @nRet = 3
RETURN
END


SET @Zone=21
SELECT @PosX = InitX, @PosZ = InitZ FROM ZONE_INFO WHERE ZoneNo = @Zone

select @row = 3
if @CharID like '%___%'
if @CharID like '%_%'
if @CharID like '%__%'
if @CharID like '%:%'
if @CharID like '%::%'
begin
SET @nRet = 3
RETURN


END
BEGIN TRAN
IF @index = 0
UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 1
UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 2
UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 3
UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID
ELSE IF @index = 4
UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID


INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ )
VALUES (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )


exec baslangicitem @CharID
update userdata set Class = 106 , strong = '255' , sta = '180' ,strskill = '?????P<???' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 101
update userdata set Class = 108 , strong = '71' , dex = '255' , sta = '169' ,strskill ='P<' , [level] = '83' , hp ='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 102
update userdata set Class = 110 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 103
update userdata set Class = 112 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P<' , [level] = '83' where struserid = @CharID and @Class = 104
update userdata set Class = 206 , strong = '255' , sta = '180' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 201
update userdata set Class = 208 , strong = '71' , dex = '255' , sta = '169' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 202
update userdata set Class = 210 , strong = '71' , sta = '100' , cha = '194' , intel = '162' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 203
update userdata set Class = 212 , strong = '110' , sta = '120' , intel = '230' ,strskill ='P<' , [level] = '83' , hp='5000' ,mp='5000' ,exp = '1' where struserid = @CharID and @Class = 204


update userdata set Class = 106 where struserid = @CharID and @Class = 101
update userdata set Class = 108 where struserid = @CharID and @Class = 102
update userdata set Class = 110 where struserid = @CharID and @Class = 103
update userdata set Class = 112 where struserid = @CharID and @Class = 104
update userdata set Class = 206 where struserid = @CharID and @Class = 201
update userdata set Class = 208 where struserid = @CharID and @Class = 202
update userdata set Class = 210 where struserid = @CharID and @Class = 203
update userdata set Class = 212 where struserid = @CharID and @Class = 204

IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
SET @nRet = 4
RETURN
END

COMMIT TRAN
SET @nRet = 0
GO
Genişletmek için tıkla ...

Databaseye 83 Skillerini Eklemek



MAGIC
Kod:

INSERT INTO MAGIC VALUES (210826, 'Guard Summon', 'Guard Summon', '.', 0,0,0,0, 0, 1, 20, 2108, 0, 0, 9, 379061000, 10, 255, 70, 9, 0, 0, 0,0)
INSERT INTO MAGIC VALUES (110826, 'Guard Summon', 'Guard Summon', '.', 0,0,0,0, 0, 1, 20, 1108, 0, 0, 9, 379061000, 10, 255, 70, 9, 0, 0, 0,0)
INSERT INTO MAGIC VALUES (206821, 'inevitable muderus', 'inevitable muderus', '.', 0,0,0,0, 10124, 1, 20, 2068, 500, 0, 9, 379059000, 13, 130, 100, 4, 0, 0, 0, 0)
INSERT INTO MAGIC VALUES (106821, 'inevitable muderus', 'inevitable muderus', '.', 0,0,0,0, 10124, 1, 20, 1068, 500, 0, 9, 379059000, 13, 130, 100, 4, 0, 0, 0, 0)
INSERT INTO MAGIC VALUES (112826, 'Minak''s Thorn', '.', '.', 0,0,0,0, 32036,6, 20, 1128, 700, 0, 9, 379062000, 15, 200, 100, 4, 0, 25, 0,0)
INSERT INTO MAGIC VALUES (212826, 'Minak''s Thorn', '.', '.', 0,0,0,0, 32036,6, 20, 2128, 700, 0, 9, 379062000, 15, 200, 100, 4, 0, 25, 0,0)
INSERT INTO MAGIC VALUES (108821, 'Eskrima', 'Eskrima', '.', 0,0,0,0, 32043,7, 20, 1088, 300, 0, 9, 379060000, 0, 255,100, 1, 4, 0, 0,0)
INSERT INTO MAGIC VALUES (208821, 'Eskrima', 'Eskrima', '.', 0,0,0,0, 32043,7, 20, 2088, 300, 0, 9, 379060000, 0, 255,100, 1, 4, 0, 0,0)
INSERT INTO MAGIC VALUES (206781, 'Battle Cry', 'Battle Cry', '.', 0,0,0,0, 32038, 6, 80, 2067, 800, 0, 9, 379059000, 10, 255,100, 4, 0, 0, 0 ,0)
INSERT INTO MAGIC VALUES (106781, 'Battle Cry', 'Battle Cry', '.', 0,0,0,0, 32038, 6, 80, 1067, 800, 0, 9, 379059000, 10, 255,100, 4, 0, 0, 0, 0)
INSERT INTO MAGIC VALUES (106782, 'Cry Echo', 'Cry Echo', '.', 0,0,0,0, 32033,7, 80, 1067, 500, 0, 9, 379059000, 0, 8,100, 1, 0, 0, 0,0)
INSERT INTO MAGIC VALUES (206782, 'Cry Echo', 'Cry Echo', '.', 0,0,0,0, 32033,7, 80, 2067, 500, 0, 9, 379059000, 0, 8,100, 1, 0, 0, 0,0)
INSERT INTO MAGIC VALUES (108656, 'Throwing Knife', 'Throwing Knife ', '.', 0,0,0,0, 32040,7, 63, 1086, 350, 0, 9, 370007000, 13, 100, 100, 2, 0, 20, 0,0)
INSERT INTO MAGIC VALUES (208656, 'Throwing Knife', 'Throwing Knife ', '.',0,0,0,0,32040,7, 63, 2086, 350, 0, 9, 370007000, 13, 100, 100, 2, 0, 20, 0,0)

MAGIC_TYPE1
Kod:

INSERT INTO MAGIC_TYPE1 VALUES (208821,'Eskrima','.',1, 100, 300, 100, 0, 0, 0,0,0)
INSERT INTO MAGIC_TYPE1 VALUES (108821,'Eskrima','.',1, 100, 300, 100, 0, 0, 0,0,0)
INSERT INTO MAGIC_TYPE1 VALUES (106782,'Cry Echo','.',1, 100, 300, 100, 0, 0, 0,0,0)
INSERT INTO MAGIC_TYPE1 VALUES (206782,'Cry Echo','.',1, 100, 300, 100, 0, 0, 0,0,0)

MAGIC_TYPE2
Kod:

INSERT INTO MAGIC_TYPE2 VALUES (108656,'Throwing Knife','.',0, 100, 300, 100, 1,0)
INSERT INTO MAGIC_TYPE2 VALUES (208656,'Throwing Knife','.',0, 100, 300, 100, 1,0)

MAGIC_TYPE4
Kod:

INSERT INTO MAGIC_TYPE4 VALUES (112826,'Minak''s Thorn','.',44, 30, 20, 100,100,0,100,100,100,0,100,0,100,0,100, 0, 0, 0, 0, 0, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (212826,'Minak''s Thorn','.',44, 30, 20, 100,100,0,100,100,100,0,100,0,100,0,100, 0, 0, 0, 0, 0, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (108821,'Eskrima','.',45, 1, 20, 100,100,0,100,100,100,0,100,0,100,0,100, 0, 0, 0, 0, 0, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (208821,'Eskrima','.',45, 1, 20, 100,100,0,100,100,100,0,100,0,100,0,100, 0, 0, 0, 0, 0, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (106821,'inevitable muderus','.',43, 1, 10, 100,100,0,100,100,100,0,100,0,100,0,100, 0, 0, 0, 0, 0, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (206821,'inevitable muderus','.',43, 1, 10, 100,100,0,100,100,100,0,100,0,100,0,100, 0, 0, 0, 0, 0, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (106781,'Battle Cry','.',7, 30, 60, 100,100,0,100,100,100,0,100,0,100,0,100, 15, 15, 15, 15, 15, 0,0,0,0,0,0,100)
INSERT INTO MAGIC_TYPE4 VALUES (206781,'Battle Cry','.', 7, 30, 60, 100,100,0,100,100,100,0,100,0,100,0,100, 15, 15, 15, 15, 15, 0,0,0,0,0,0,100)

MAGIC_TYPE 9
Kod:

INSERT INTO MAGIC_TYPE9 VALUES (110826, 'Guard Summon', '.', 0, 2, 7035, 3, 7,0,100,50,0, 100, 0)
INSERT INTO MAGIC_TYPE9 VALUES (210826, 'Guard Summon', '.', 0, 2, 7035, 3, 7,0,100,50,0, 100, 0)

ITEM
Kod:

INSERT INTO ITEM VALUES (370007000,'Throwing Knife',95,15,0,0,0,0,0,0,1,1,1000,0,0,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Genişletmek için tıkla ...


Amaç Paylasım

Cok Kücük Bir Paylasım Oldugunun Farkındayım

Ama Bazıların COK İsine Yarıycagındada Eminim !!!!
 
Son düzenleme:
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Çok güzel bir paylaşım saol
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Ufak Ama Yararlı Teşekkürler :)
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Süper PayLasım Cok SaqoL..
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Güzel Paylaşım Teşekkürler
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Güzel Konu..

Paylaşım İçin..

Teşekkürler..
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Teşekkürler.
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

teşekkürler paylasım icin
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

link nerde kardeşm bu editörleri nerdn bulcaz
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

cok gusel paylasım ellerine sağlık cok kişinin işine yarayacaktır
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Database Editlemek Bunlardanmi İbaret ?
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

bro link yok link verseydin bare
 
Cevap: Database Editlemek İsteyenler İcin Paylasıyorum [Basit Ufak Bir Paylasım :P]

Senın Ben Karını Sıkem ****** Cocuqu Link Nerde. ! *** veren
 
Cevap yazmak için giriş yap yada kayıt ol.

Online istatistikleri

Çevrimiçi kullanıcılar
4
Çevrimiçi ziyaretçiler
553
Toplam ziyaretçi
557
Toplamlar, gizli ziyaretçiler içerebilir.

About Us

Ko-Cuce.Net 2007 yılından bu yana pvp serverler tanıtım sektöründe öncü tanıtım sitesi olarak yayın hayatına devam eden bir private server forum sitesidir. 2007 yılından bu yana Ko-Cuce.Net olarak hizmet veren ve tüm oyunlara oyuncu katkısı sağlayan bir lider platform'dur Pvp Serverler m3u iptv gamers4life metin2 pvp Knight Online Pvp

En yeni üyeler

Stay Connected

Geri
Üst Alt