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:
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:
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
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.