Home Verkennen Help
Inloggen
oversu
/
fRO_french_translation_rAthena
1
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: a75c0475a2
Aftakkingen Labels
fRO_french_tran...
/
sql-files
/
mob_skill_db2.sql

mob_skill_db2.sql 13 KB
Geschiedenis Ruwe

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105 
  1. #
    2. 

  2. #  Table structure for table `mob_skill_db2`
    3. 

  3. #
    4. 

  4. 

  5. DROP TABLE IF EXISTS `mob_skill_db2`;
    6. 

  6. CREATE TABLE IF NOT EXISTS `mob_skill_db2` (
    7. 

  7.   `MOB_ID` smallint(6) NOT NULL,
    8. 

  8.   `INFO` text NOT NULL,
    9. 

  9.   `STATE` text NOT NULL,
    10. 

  10.   `SKILL_ID` smallint(6) NOT NULL,
    11. 

  11.   `SKILL_LV` tinyint(4) NOT NULL,
    12. 

  12.   `RATE` smallint(4) NOT NULL,
    13. 

  13.   `CASTTIME` mediumint(9) NOT NULL,
    14. 

  14.   `DELAY` int(9) NOT NULL,
    15. 

  15.   `CANCELABLE` text NOT NULL,
    16. 

  16.   `TARGET` text NOT NULL,
    17. 

  17.   `CONDITION` text NOT NULL,
    18. 

  18.   `CONDITION_VALUE` text,
    19. 

  19.   `VAL1` mediumint(9) DEFAULT NULL,
    20. 

  20.   `VAL2` mediumint(9) DEFAULT NULL,
    21. 

  21.   `VAL3` mediumint(9) DEFAULT NULL,
    22. 

  22.   `VAL4` mediumint(9) DEFAULT NULL,
    23. 

  23.   `VAL5` mediumint(9) DEFAULT NULL,
    24. 

  24.   `EMOTION` text,
    25. 

  25.   `CHAT` text
    26. 

  26. ) ENGINE=MyISAM;
    27. 

  27. 

  28. #  Mob Skill Database
    29. 

  29. # 
    30. 

  30. #  Structure of Database:
    31. 

  31. #  INSERT INTO `mob_skill_db2` (`MOB_ID`, `INFO`, `STATE`, `SKILL_ID`, `SKILL_LV`, `RATE`, `CASTTIME`, `DELAY`, `CANCELABLE`, `TARGET`, `CONDITION`, `CONDITION_VALUE`, `VAL1`, `VAL2`, `VAL3`, `VAL4`, `VAL5`, `EMOTION`, `CHAT`);
    32. 

  32. #
    33. 

  33. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    34. 

  34. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@AL_TELEPORT", "walk", 26, 1, 500, 0, 5000, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    35. 

  35. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@KN_BRANDISHSPEAR", "attack", 57, 10, 2000, 500, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    36. 

  36. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@MO_BODYRELOCATION", "chase", 264, 1, 200, 200, 1000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    37. 

  37. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_ARMORBRAKE", "attack", 344, 10, 2000, 0, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    38. 

  38. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_CALLSLAVE", "attack", 352, 1, 10000, 0, 30000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    39. 

  39. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_CALLSLAVE", "idle", 352, 1, 10000, 0, 30000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    40. 

  40. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_DARKBREATH", "attack", 202, 5, 2000, 800, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    41. 

  41. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_DARKSTRIKE", "chase", 340, 10, 200, 0, 1000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    42. 

  42. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_GUIDEDATTACK", "attack", 172, 5, 500, 0, 20000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    43. 

  43. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_POWERUP", "attack", 349, 5, 10000, 0, 30000, "yes", "self", "myhpltmaxrate", 30, NULL, NULL, NULL, NULL, NULL, 6, NULL);
    44. 

  44. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_SUMMONSLAVE", "attack", 196, 6, 10000, 700, 10000, "no", "self", "slavele", 3, 1902, NULL, NULL, NULL, NULL, NULL, NULL);
    45. 

  45. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@NPC_SUMMONSLAVE", "idle", 196, 6, 10000, 700, 10000, "no", "self", "slavele", 3, 1902, NULL, NULL, NULL, NULL, NULL, NULL);
    46. 

  46. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@WZ_VERMILION", "attack", 85, 10, 2000, 500, 2000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    47. 

  47. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@WZ_VERMILION", "chase", 85, 10, 200, 500, 2000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    48. 

  48. # REPLACE INTO mob_skill_db2 VALUES(1900, "Valaris@WZ_VERMILION", "chase", 85, 10, 500, 500, 2000, "no", "target", "skillused", 18, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    49. 

  49. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    50. 

  50. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_CURSEATTACK", "attack", 181, 3, 500, 800, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    51. 

  51. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_DARKNESSATTACK", "attack", 190, 2, 500, 500, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 6, NULL);
    52. 

  52. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_EMOTION", "chase", 197, 1, 20, 0, 5000, "yes", "self", "always", 0, 19, 129, NULL, NULL, NULL, NULL, NULL);
    53. 

  53. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_EMOTION", "idle", 197, 1, 200, 0, 5000, "yes", "self", "always", 0, 6, 1173, NULL, NULL, NULL, NULL, NULL);
    54. 

  54. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_EMOTION", "walk", 197, 1, 200, 0, 5000, "yes", "self", "always", 0, 2, NULL, NULL, NULL, NULL, NULL, NULL);
    55. 

  55. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_HALLUCINATION", "attack", 207, 1, 500, 500, 5000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    56. 

  56. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@NPC_HALLUCINATION", "chase", 207, 1, 50, 500, 5000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    57. 

  57. # REPLACE INTO mob_skill_db2 VALUES(1901, "Valaris's Worshipper@SA_DISPELL", "attack", 289, 1, 0, 0, 30000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    58. 

  58. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    59. 

  59. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@AL_TELEPORT", "walk", 26, 1, 500, 0, 5000, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    60. 

  60. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@KN_BRANDISHSPEAR", "attack", 57, 10, 2000, 500, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    61. 

  61. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@MO_BODYRELOCATION", "chase", 264, 1, 200, 200, 1000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    62. 

  62. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@NPC_ARMORBRAKE", "attack", 344, 10, 2000, 0, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    63. 

  63. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@NPC_DARKBREATH", "attack", 202, 5, 2000, 800, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    64. 

  64. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@NPC_DARKSTRIKE", "chase", 340, 10, 200, 0, 1000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    65. 

  65. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@NPC_GUIDEDATTACK", "attack", 172, 5, 500, 0, 20000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    66. 

  66. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@NPC_POWERUP", "attack", 349, 5, 10000, 0, 30000, "yes", "self", "myhpltmaxrate", 30, NULL, NULL, NULL, NULL, NULL, 6, NULL);
    67. 

  67. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@WZ_VERMILION", "attack", 85, 10, 2000, 500, 2000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    68. 

  68. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@WZ_VERMILION", "chase", 85, 10, 200, 500, 2000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    69. 

  69. # REPLACE INTO mob_skill_db2 VALUES(1902, "MC Cameri@WZ_VERMILION", "chase", 85, 10, 500, 500, 2000, "no", "target", "skillused", 18, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    70. 

  70. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@AC_DOUBLE", "attack", 46, 10, 500, 1000, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    71. 

  71. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@AC_SHOWER", "attack", 47, 8, 2000, 1000, 5000, "no", "target", "attackpcgt", 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    72. 

  72. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@BS_MAXIMIZE", "chase", 114, 5, 500, 1000, 5000, "no", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    73. 

  73. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@BS_MAXIMIZE", "attack", 114, 5, 500, 1000, 5000, "no", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    74. 

  74. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_AGIUP", "chase", 350, 5, 2500, 0, 5000, "no", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    75. 

  75. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_POWERUP", "attack", 349, 5, 500, 0, 30000, "yes", "self", "myhpltmaxrate", 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    76. 

  76. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@SN_SHARPSHOOTING", "attack", 382, 5, 500, 1000, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    77. 

  77. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@HT_SKIDTRAP", "idle", 115, 5, 50, 0, 5000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, 29, NULL);
    78. 

  78. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@HT_FREEZINGTRAP", "idle", 120, 5, 50, 0, 300000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    79. 

  79. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@HT_FREEZINGTRAP", "idle", 121, 5, 50, 0, 300000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    80. 

  80. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@AC_CHARGEARROW", "attack", 148, 1, 500, 0, 5000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    81. 

  81. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@HT_FLASHER", "idle", 120, 5, 50, 0, 300000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    82. 

  82. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_SUMMONSLAVE", "idle", 196, 5, 10000, 2000, 120000, "no", "self", "slavele", 1, 1659, 1660, 1661, 1662, 1663, 0, NULL);
    83. 

  83. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_CALLSLAVE", "attack", 352, 1, 2000, 0, 10000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    84. 

  84. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_CALLSLAVE", "idle", 352, 1, 2000, 0, 10000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    85. 

  85. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_CHANGEWATER", "attack", 162, 1, 10000, 2000, 600000, "no", "self", "myhpltmaxrate", 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    86. 

  86. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@NPC_CHANGETELEKINESIS", "attack", 169, 1, 500, 2000, 5000, "no", "self", "myhpltmaxrate", 10, NULL, NULL, NULL, NULL, NULL, 7, NULL);
    87. 

  87. # REPLACE INTO mob_skill_db2 VALUES(1903, "Poki#3@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    88. 

  88. # REPLACE INTO mob_skill_db2 VALUES(1921, "Easter Bunny@NPC_SUMMONSLAVE", "attack", 196, 5, 10000, 3000, 10000, "no", "self", "slavele", 2, 1063, NULL, NULL, NULL, NULL, NULL, NULL);
    89. 

  89. # REPLACE INTO mob_skill_db2 VALUES(1921, "Easter Bunny@NPC_SUMMONSLAVE", "idle", 196, 5, 5000, 2000, 40000, "no", "self", "always", 2, 1920, NULL, NULL, NULL, NULL, NULL, NULL);
    90. 

  90. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@AL_HEAL", "idle", 28, 10, 10000, 0, 2000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, 4, NULL);
    91. 

  91. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@AL_HEAL", "walk", 28, 10, 10000, 0, 2000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, 4, NULL);
    92. 

  92. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@AL_TELEPORT", "attack", 26, 1, 1000, 5000, 60000, "no", "self", "myhpltmaxrate", 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    93. 

  93. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@AL_TELEPORT", "idle", 26, 1, 10000, 0, 0, "yes", "self", "rudeattacked", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    94. 

  94. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@NPC_DARKBLESSING", "attack", 203, 1, 1000, 2000, 5000, "no", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, 18, NULL);
    95. 

  95. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@NPC_SUMMONSLAVE", "attack", 196, 16, 10000, 2000, 10000, "no", "self", "slavele", 3, 1491, 1431, 1433, NULL, NULL, 18, NULL);
    96. 

  96. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@NPC_SUMMONSLAVE", "idle", 196, 16, 10000, 2000, 10000, "no", "self", "slavele", 3, 1491, 1431, 1433, NULL, NULL, 18, NULL);
    97. 

  97. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@RG_INTIMIDATE", "attack", 219, 5, 1000, 0, 3000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    98. 

  98. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@RG_STRIPARMOR", "attack", 217, 5, 2000, 0, 3000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    99. 

  99. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@RG_STRIPHELM", "attack", 218, 5, 2000, 0, 3000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    100. 

  100. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@RG_STRIPSHIELD", "attack", 216, 5, 2000, 0, 3000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    101. 

  101. # REPLACE INTO mob_skill_db2 VALUES(1239, "Fire Poring@RG_STRIPWEAPON", "attack", 215, 5, 2000, 0, 3000, "yes", "target", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    102. 

  102. # REPLACE INTO mob_skill_db2 VALUES(3014, "Halloween Whisper@AS_CLOAKING", "idle", 135, 1, 2000, 200, 5000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    103. 

  103. # REPLACE INTO mob_skill_db2 VALUES(3014, "Halloween Whisper@AS_CLOAKING", "chase", 135, 1, 2000, 200, 5000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    104. 

  104. # REPLACE INTO mob_skill_db2 VALUES(3014, "Halloween Whisper@NPC_EMOTION", "idle", 197, 1, 2000, 0, 5000, "yes", "self", "always", 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    105. 

  105. # REPLACE INTO mob_skill_db2 VALUES(3014, "Halloween Whisper@NPC_EMOTION", "chase", 197, 1, 200, 0, 5000, "yes", "self", "always", 0, 19, 0x81, NULL, NULL, NULL, NULL, NULL);
    106.