Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 17th, 2012  |  syntax: None  |  size: 6.43 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Bifrost Key:
  2.  
  3. INSERT INTO ITEM (389217000,'Bifrost Key',95,15,0,0,0,0,0,1,1,500000,0,0,1,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)
  4.  
  5. K_NPC:
  6.  
  7. 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 ( 9993, 'Bi-frost Gate[Orc]', 30100, 100, 0, 0, 1, 7, 137, 1, 3, 3, 0, 80, 12000, 1000, 1500000, 0, 0, 10000, 375, 375, 0, 0, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 250, 7, 14, 35, 35000, 9993, 0, 0, 1 );
  8. 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 ( 9992, 'Bi-frost Gate[Human]', 30100, 100, 0, 0, 2, 7, 137, 1, 3, 3, 0, 80, 12000, 1000, 1500000, 0, 0, 10000, 375, 375, 0, 0, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 250, 7, 14, 35, 35000, 9992, 0, 0, 1 );
  9. 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 ( 9991, 'Bi-frost Monument', 30020, 100, 0, 0, 2, 7, 0, 1, 3, 3, 0, 80, 12000, 1000, 1500000, 0, 0, 10000, 375, 375, 0, 0, 0, 0, 1000, 0, 0, 0, 175, 175, 175, 175, 175, 175, 175, 100, 7, 14, 35, 35000, 9991, 0, 0, 1 );
  10. 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 ( 9990, 'Bi-frost Monument', 30020, 100, 0, 0, 1, 7, 0, 1, 3, 3, 0, 80, 12000, 1000, 1500000, 0, 0, 10000, 375, 375, 0, 0, 0, 0, 1000, 0, 0, 0, 175, 175, 175, 175, 175, 175, 175, 100, 7, 14, 35, 35000, 9991, 0, 0, 1 );
  11. 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 ( 9995, 'Bi-frost Çikis', 21000, 100, 151210118, 170210255, 1, 7, 137, 1, 3, 3, 0, 80, 100, 500, 100000, 0, 0, 15000, 375, 375, 5000, 1500, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 20000, 21510, 0, 0, 1 );
  12. 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 ( 9994, 'Bi-frost Çikis', 21000, 100, 151210118, 170210255, 2, 7, 137, 1, 3, 3, 0, 80, 100, 500, 100000, 0, 0, 15000, 375, 375, 5000, 1500, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 35, 20000, 21510, 0, 0, 1 );
  13.  
  14.  
  15.  
  16.  
  17.  
  18.  
  19. K_NPCPOS:
  20.  
  21. 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 ( 201, 9993, 103, 0, 0, 0, 0, 1025, 1017, 1025, 1017, 0, 0, 0, 0, 1, 4400, 0, 3, '' );
  22. 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 ( 201, 9992, 103, 0, 0, 0, 0, 1002, 1022, 1002, 1022, 0, 0, 0, 0, 1, 4400, 0, 3, '' );
  23. 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 ( 201, 9991, 102, 0, 0, 0, 0, 1021, 991, 1021, 991, 0, 0, 0, 0, 1, 1500, 0, 3, '' );
  24. 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 ( 201, 9990, 102, 0, 0, 0, 0, 1006, 991, 1006, 991, 0, 0, 0, 0, 1, 1500, 0, 3, '' );
  25.  
  26. Run this in query :
  27.  
  28.  
  29. update k_npc set bygroup = '1'
  30. where ssid = '601'
  31.  
  32. update k_npc set bytype = '137'
  33. where ssid = '1602'
create a new version of this paste RAW Paste Data