custom_npcaidata.sql 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. CREATE TABLE IF NOT EXISTS `custom_npcaidata` (
  2. `npcId` mediumint(7) unsigned NOT NULL,
  3. `minSkillChance` tinyint(3) unsigned NOT NULL DEFAULT '7',
  4. `maxSkillChance` tinyint(3) unsigned NOT NULL DEFAULT '15',
  5. `primarySkillId` smallint(5) unsigned DEFAULT '0',
  6. `agroRange` smallint(4) unsigned NOT NULL DEFAULT '0',
  7. `canMove` tinyint(1) unsigned NOT NULL DEFAULT '1',
  8. `targetable` tinyint(1) unsigned NOT NULL DEFAULT '1',
  9. `showName` tinyint(1) unsigned NOT NULL DEFAULT '1',
  10. `minRangeSkill` smallint(5) unsigned DEFAULT '0',
  11. `minRangeChance` tinyint(3) unsigned DEFAULT '0',
  12. `maxRangeSkill` smallint(5) unsigned DEFAULT '0',
  13. `maxRangeChance` tinyint(3) unsigned DEFAULT '0',
  14. `soulShot` smallint(4) unsigned DEFAULT '0',
  15. `spiritShot` smallint(4) unsigned DEFAULT '0',
  16. `spsChance` tinyint(3) unsigned DEFAULT '0',
  17. `ssChance` tinyint(3) unsigned DEFAULT '0',
  18. `aggro` smallint(4) unsigned NOT NULL DEFAULT '0',
  19. `isChaos` smallint(4) unsigned DEFAULT '0',
  20. `clan` varchar(40) DEFAULT NULL,
  21. `clanRange` smallint(4) unsigned DEFAULT '0',
  22. `enemyClan` varchar(40) DEFAULT NULL,
  23. `enemyRange` smallint(4) unsigned DEFAULT '0',
  24. `dodge` tinyint(3) unsigned DEFAULT '0',
  25. `aiType` varchar(8) NOT NULL DEFAULT 'fighter',
  26. PRIMARY KEY (`npcId`)
  27. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  28. INSERT IGNORE INTO `custom_npcaidata` VALUES
  29. (50007,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  30. (70010,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  31. (1000003,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  32. -- eventmod Elpies
  33. (900100,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  34. -- eventmod Rabbits
  35. (900101,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  36. (900102,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  37. -- eventmod Race
  38. (900103,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter'),
  39. (900104,7,15,0,1000,0,1,1,0,0,0,0,0,0,0,0,0,0,NULL,300,NULL,0,0,'fighter');