summaryrefslogtreecommitdiff
path: root/sql-files/mob_db2.sql
blob: b2f54ed73c90fef5914bfad2d2fe670249fe8852 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
--
-- Table structure for table `mob_db2`
--

DROP TABLE IF EXISTS `mob_db2`;
CREATE TABLE `mob_db2` (
  `ID` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Sprite` TEXT NOT NULL,
  `kName` TEXT NOT NULL,
  `iName` TEXT NOT NULL,
  `LV` TINYINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `HP` INT(9) UNSIGNED NOT NULL DEFAULT '0',
  `SP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `EXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `JEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Range1` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `ATK1` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `ATK2` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `DEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `MDEF` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `STR` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `AGI` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `VIT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `INT` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `DEX` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `LUK` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `Range2` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `Range3` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `Scale` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `Race` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `Element` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `Mode` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `Speed` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `aDelay` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `aMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `dMotion` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  `MEXP` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `MVP1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `MVP1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `MVP2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `MVP2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `MVP3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `MVP3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop1id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop1per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop2id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop2per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop3id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop3per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop4id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop4per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop5id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop5per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop6id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop6per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop7id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop7per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop8id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop8per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop9id` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `Drop9per` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `DropCardid` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  `DropCardper` SMALLINT(9) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM;

-- Monsters Additional Database
--
-- Structure of Database :
-- REPLACE INTO `mob_db2` VALUES (ID,'Sprite_Name','kROName','iROName',LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper);

--  Athena Dev Team
-- REPLACE INTO `mob_db` VALUES (1900,'VALARIS','Valaris','Valaris',99,668000,0,107250,37895,2,3220,4040,35,45,1,152,96,85,120,95,10,10,2,6,67,0x1973,100,1068,768,576,13000,608,1000,750,400,923,3800,1466,200,2256,200,2607,800,714,500,617,3000,984,4300,985,5600,0,0,0,0,4147,1);
-- REPLACE INTO `mob_db` VALUES (1901,'VALARIS_WORSHIPPER','Valaris\'s Worshipper','Valaris\'s Worshipper',50,8578,0,2706,1480,1,487,590,15,25,1,75,55,1,93,45,10,12,0,6,27,0x1685,100,868,480,120,0,0,0,0,0,0,0,923,500,984,63,1464,2,607,50,610,100,503,300,2405,50,0,0,0,0,4129,1);
-- REPLACE INTO `mob_db` VALUES (1902,'MC_CAMERI','MC Cameri','MC Cameri',99,668000,0,107250,37895,2,3220,4040,35,45,1,152,96,85,120,95,10,10,2,6,67,0x1973,100,1068,768,576,13000,608,1000,750,400,923,3800,1466,200,2256,200,2607,800,714,500,617,3000,984,4300,985,5600,0,0,0,0,4147,1);
-- REPLACE INTO `mob_db` VALUES (1903,'POKI','Poki#3','Poki#3',99,1349000,0,4093000,1526000,9,4892,9113,22,35,1,180,39,67,193,130,10,12,1,7,64,0x1973,120,500,672,480,92100,603,5500,617,3000,1723,1000,1228,100,1236,500,617,2500,1234,75,1237,125,1722,250,1724,100,1720,50,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1904,'SENTRY','Sentry','Sentry',99,668000,0,107250,37895,2,3220,4040,35,45,1,152,96,85,120,95,10,10,2,6,67,0x1973,100,1068,768,576,13000,608,1000,750,400,923,3800,1466,200,2256,200,2607,800,714,500,617,3000,984,4300,985,5600,0,0,0,0,4147,1);

--  Custom Hollow Poring (overrrides/collides with META_ANDRE)
-- REPLACE INTO `mob_db` VALUES (1237,'HOLLOW_PORING','Hollow Poring','Hollow Poring',1,50,0,2,1,1,7,10,0,5,1,1,1,0,6,30,10,12,1,3,21,0x83,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,512,150,619,20,0,0,0,0,4001,10);
--  Custom Fire Poring. Warning, Colides with META_DENIRO
-- REPLACE INTO `mob_db` VALUES (1239,'FIRE_PORING','Fire Poring','Fire Poring',1,50,0,2,1,1,7,10,0,5,1,1,1,1,6,30,10,12,1,3,21,0x131,400,1872,672,480,0,0,0,0,0,0,0,909,7000,1202,100,938,400,512,1000,713,1500,741,5,619,20,0,0,0,0,4001,20);

--  Lunar New Year 2008 Event Monster overrides
--  Uncomment if event is enabled, as these drops modifications are nessecary.
-- REPLACE INTO `mob_db` VALUES (1145,'MARTIN','Martin','Martin',18,1109,0,134,86,1,52,63,0,5,12,18,30,15,15,5,10,12,0,2,42,0x81,300,1480,480,480,0,0,0,0,0,0,0,1017,9000,1018,500,1251,10,2225,5,5009,1,10010,10,2224,15,7869,1500,0,0,4046,1);
-- REPLACE INTO `mob_db` VALUES (1175,'TAROU','Tarou','Tarou',11,284,0,57,28,1,34,45,0,0,1,20,11,10,24,5,10,12,0,2,27,0x91,150,1744,1044,684,0,0,0,0,0,0,0,1016,9000,919,3000,949,800,528,1000,701,2,7869,2500,0,0,0,0,0,0,4028,1);
-- REPLACE INTO `mob_db` VALUES (1209,'CRAMP','Cramp','Cramp',56,4720,0,2300,1513,1,395,465,0,5,1,85,35,5,65,60,10,12,0,2,45,0x3095,100,1000,500,1000,0,0,0,0,0,0,0,7007,4656,528,1000,726,80,746,110,568,250,510,70,984,95,7869,1500,0,0,4296,1);

--  iRO St. Patricks Day 2008 Event Monster overrides
--  Uncomment if event is enabled, as these drops modifications are nessecary.
-- REPLACE INTO `mob_db` VALUES (1841,'G_SNAKE_','Snake Lord\'s Minon','Snake Lord\'s Minon',15,471,0,72,48,1,46,55,0,0,1,15,15,10,35,5,10,12,1,2,22,0x81,200,1576,576,576,0,0,0,0,0,0,0,7915,1000,7916,100,7720,30,12715,7,0,0,0,0,0,0,0,0,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1842,'G_ANACONDAQ_','Snake Lord\'s Minon','Snake Lord\'s Minon',23,1109,0,300,149,1,124,157,0,0,1,23,28,10,36,5,10,12,1,2,25,0x91,200,1576,576,576,0,0,0,0,0,0,0,7915,1000,7916,100,7720,30,12715,7,0,0,0,0,0,0,0,0,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1843,'SIDE_WINDER_','Snake Lord\'s Minon','Snake Lord\'s Minon',43,4929,0,1996,993,1,240,320,5,10,38,43,40,15,115,20,10,12,1,2,25,0x3095,200,1576,576,576,0,0,0,0,0,0,0,7915,1000,7916,100,7720,30,12715,7,0,0,0,0,0,0,0,0,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1844,'G_ISIS_','Snake Lord\'s Minon','Snake Lord\'s Minon',47,7003,0,3709,1550,1,423,507,10,35,38,65,43,50,66,15,10,12,2,6,27,0x3195,200,1384,768,336,0,0,0,0,0,0,0,7915,1000,7916,100,7720,30,12715,8,0,0,0,0,0,0,0,0,0,0,0,0);

--  iRO Christmas 2008 Event
--  Uncomment if event is enabled, as these drops modifications are nessecary.
-- REPLACE INTO `mob_db` VALUES (1244,'JAKK_XMAS','Christmas Jakk','Christmas Jakk',38,3581,0,1113,688,1,315,382,5,30,1,38,38,43,75,45,10,12,1,0,43,0x81,200,1180,480,648,0,0,0,0,0,0,0,529,1000,530,1000,14546,1000,14550,1000,7174,1000,7175,1000,6092,1000,12355,1250,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1245,'GOBLINE_XMAS','Christmas Goblin','Christmas Goblin',25,1176,0,282,171,1,118,140,10,5,1,53,25,20,38,45,10,12,1,7,24,0x81,100,1120,620,240,0,0,0,0,0,0,0,529,1000,530,1000,14546,1000,14550,1000,7174,1000,7175,1000,6092,1000,12355,1250,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1246,'COOKIE_XMAS','Christmas Cookie','Christmas Cookie',28,2090,0,461,284,1,140,170,0,50,1,24,30,53,45,100,10,12,0,7,46,0x91,400,1248,1248,240,0,0,0,0,0,0,0,529,1000,530,1000,14546,1000,14550,1000,7174,1000,7175,1000,6092,1000,12355,1250,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (1247,'ANTONIO','Antonio','Antonio',10,10,0,3,2,1,13,20,100,0,1,1,1,50,100,100,10,12,1,3,66,0xC1,100,720,720,432,0,0,0,0,0,0,0,604,500,12354,500,14550,500,5136,500,12132,500,12225,500,5811,500,0,0,0,0,4243,1);

--  iRO Halloween 2009 Event
--  Uncomment if event is enabled. Uncomment the skills for Halloween Whisper in mob_skill_db2.
-- REPLACE INTO `mob_db` VALUES (3014,'HALLOWEEN_WHISPER','Halloween Whisper','Halloween Whisper',1,800,0,0,0,1,10,13,0,45,1,51,14,0,60,0,10,12,0,6,68,0x81,150,1960,960,504,0,0,0,0,0,0,0,12396,150,6299,5335,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
-- REPLACE INTO `mob_db` VALUES (3015,'HALLOWEEN_DARK_LORD','Halloween Dark Lord','Halloween Dark Lord',1,45,0,0,0,1,10,13,0,45,1,51,14,0,60,0,10,12,2,6,89,0x81,100,868,768,480,0,0,0,0,0,0,0,12396,800,12397,5335,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

--  iRO Halloween 2008 Event
--  Uncomment if event is enabled.
-- REPLACE INTO `mob_db` VALUES (3000,'ZOMBIE','Zombie','Zombie',15,534,0,50,33,1,67,79,0,10,1,8,7,0,15,0,10,12,1,1,29,0x3885,400,2612,912,288,0,0,0,0,0,0,0,957,9000,724,5,938,1000,958,50,727,70,0,0,0,0,0,0,0,0,4038,1);
-- REPLACE INTO `mob_db` VALUES (3001,'GHOUL','Ghoul','Ghoul',40,5418,0,1088,622,1,420,500,5,20,1,20,29,0,45,20,10,12,1,1,49,0x3885,250,2456,912,504,0,0,0,0,0,0,0,958,6000,756,110,509,700,511,800,2609,60,934,150,1260,1,0,0,0,0,4110,1);
-- REPLACE INTO `mob_db` VALUES (3002,'ZOMBIE_MASTER','Zombie Master','Zombie Master',62,14211,0,7610,2826,1,824,1084,37,26,25,20,30,5,77,35,10,12,1,1,29,0x3695,175,2612,912,288,0,0,0,0,0,0,0,7071,4413,938,1500,958,1500,723,200,727,100,1260,1,2324,2,0,0,0,0,4274,1);