1299 İlk 3 Clan Heykeli Sorunsuz



Merhaba Anlatımları Adım Adım Yaparsanız Sorun Yaşamassınız Yedek Almayı İhmal Etmeyiniz Başlıyoruz

Ayrıca Bu kodları kullanarak Moradon(server genel), EMC(Elmo) ve Luferson’a (Karus) ilk 3 clanın adlarını taşıyan heykeller dikeceğiz.

Kod:
DELETE FROM K_NPC WHERE sSid = 16048 or sSid = 16049 or sSid = 16050
GO
Kod:
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 (16048, N'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 (16049, N'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 (16050, N'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 (26148, N'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 (26149, N'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 (26150, N'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 (26248, N'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 (26249, N'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 (26250, N'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
Kod:
DELETE FROM K_NPCPOS WHERE NpcID = 16048 or NpcID = 16049 or NpcID = 16050
GO
Kod:
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 (21, 16048, 103, 0, 0, 0, 0, 334, 370, 334, 370, 334, 370, 334, 370, 1, 3600, 0, 2, '0334037003340370')
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 (21, 16049, 103, 0, 0, 0, 0, 331, 379, 331, 379, 331, 379, 331, 379, 1, 3600, 0, 2, '0331037903310379')
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 (21, 16050, 103, 0, 0, 0, 0, 343, 367, 343, 367, 343, 367, 343, 367, 1, 3600, 0, 2, '0343036703430367')
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, 26148, 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, 26149, 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, 26150, 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 (2, 26248, 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, 26249, 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, 26250, 103, 0, 0, 0, 0, 1617, 406, 1617, 406, 1617, 406, 1617, 406, 1, 3600, 0, 2, '1617040616170406')
GO
Kod:
CREATE TABLE [dbo].[HEYKEL] (
[Num] smallint IDENTITY(1, 1) NOT NULL,
[IDName] varchar(21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nRank] smallint NULL,
[Nation] smallint CONSTRAINT [DF__HEYKEL__Nation__5669C4BE] DEFAULT 0 NOT NULL
)
ON [PRIMARY]
GO
Kod:
CREATE PROCEDURE OSCAR AS

DECLARE
@Nation smallint

set @Nation = 0


TRUNCATE TABLE HEYKEL
INSERT HEYKEL select TOP 3 strName, nRank, @Nation from KNIGHTS_RATING order by nRank ASC
UPDATE K_NPC SET strName = '1. ' + (select IDName From HEYKEL where Num = 1) where sSid = 16048
UPDATE K_NPC SET strName = '2. ' + (select IDName From HEYKEL where Num = 2) where sSid = 16049
UPDATE K_NPC SET strName = '3. ' + (select IDName From HEYKEL where Num = 3) where sSid = 16050


TRUNCATE TABLE HEYKEL
INSERT HEYKEL select TOP 3 strName, nRank, @Nation+1 from KNIGHTS_RATING where shIndex < 15000 order by nRank ASC
UPDATE K_NPC SET strName = '1. ' + (select IDName From HEYKEL where Num = 1) where sSid = 26148
UPDATE K_NPC SET strName = '2. ' + (select IDName From HEYKEL where Num = 2) where sSid = 26149
UPDATE K_NPC SET strName = '3. ' + (select IDName From HEYKEL where Num = 3) where sSid = 26150



TRUNCATE TABLE HEYKEL
INSERT HEYKEL select TOP 3 strName, nRank, @Nation+2 from KNIGHTS_RATING where shIndex > 15000 order by nRank ASC
UPDATE K_NPC SET strName = '1. ' + (select IDName From HEYKEL where Num = 1) where sSid = 26248
UPDATE K_NPC SET strName = '2. ' + (select IDName From HEYKEL where Num = 2) where sSid = 26249
UPDATE K_NPC SET strName = '3. ' + (select IDName From HEYKEL where Num = 3) where sSid = 26250

HER RESDE ATILCAK KOD:

Kod:
exec oscar

Not: Ben Denemiştim Sorunsuz Kullandım Sorunsuzdur Denemek Yapmak Size Kalmıştır

Kullanımı …

1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.
2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.
3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.

Resimler Görüntüler

Hakkında alpa2011
www.extra.forum7.biz admini

Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Twitter resmi

Twitter hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Google+ fotoğrafı

Google+ hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Connecting to %s

%d blogcu bunu beğendi: