İlk 5 Clanın Heykeli

Konu: İlk 5 Clanın Heykeli C.tesi Mayıs 08, 2010 7:11 am

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