PDOStatement Object ( [queryString] => DROP TEMPORARY TABLE IF EXISTS osro.monsters )
PDOStatement Object ( [queryString] => DESCRIBE osro.mob_db2 )
PDOStatement Object ( [queryString] => CREATE TEMPORARY TABLE osro.monsters ( `id` int(11) unsigned NOT NULL , `name_aegis` varchar(24) NULL , `name_english` text NULL , `name_japanese` text NULL , `level` smallint(6) unsigned NULL , `hp` int(11) unsigned NULL , `sp` mediumint(9) unsigned NULL , `base_exp` int(11) unsigned NULL , `job_exp` int(11) unsigned NULL , `mvp_exp` int(11) unsigned NULL , `attack` smallint(6) unsigned NULL , `attack2` smallint(6) unsigned NULL , `defense` smallint(6) unsigned NULL , `magic_defense` smallint(6) unsigned NULL , `str` smallint(6) unsigned NULL , `agi` smallint(6) unsigned NULL , `vit` smallint(6) unsigned NULL , `int` smallint(6) unsigned NULL , `dex` smallint(6) unsigned NULL , `luk` smallint(6) unsigned NULL , `attack_range` tinyint(4) unsigned NULL , `skill_range` tinyint(4) unsigned NULL , `chase_range` tinyint(4) unsigned NULL , `size` varchar(24) NULL , `race` varchar(24) NULL , `racegroup_goblin` tinyint(1) unsigned NULL , `racegroup_kobold` tinyint(1) unsigned NULL , `racegroup_orc` tinyint(1) unsigned NULL , `racegroup_golem` tinyint(1) unsigned NULL , `racegroup_guardian` tinyint(1) unsigned NULL , `racegroup_ninja` tinyint(1) unsigned NULL , `racegroup_gvg` tinyint(1) unsigned NULL , `racegroup_battlefield` tinyint(1) unsigned NULL , `racegroup_treasure` tinyint(1) unsigned NULL , `racegroup_biolab` tinyint(1) unsigned NULL , `racegroup_manuk` tinyint(1) unsigned NULL , `racegroup_splendide` tinyint(1) unsigned NULL , `racegroup_scaraba` tinyint(1) unsigned NULL , `racegroup_ogh_atk_def` tinyint(1) unsigned NULL , `racegroup_ogh_hidden` tinyint(1) unsigned NULL , `racegroup_bio5_swordman_thief` tinyint(1) unsigned NULL , `racegroup_bio5_acolyte_merchant` tinyint(1) unsigned NULL , `racegroup_bio5_mage_archer` tinyint(1) unsigned NULL , `racegroup_bio5_mvp` tinyint(1) unsigned NULL , `racegroup_clocktower` tinyint(1) unsigned NULL , `racegroup_thanatos` tinyint(1) unsigned NULL , `racegroup_faceworm` tinyint(1) unsigned NULL , `racegroup_hearthunter` tinyint(1) unsigned NULL , `racegroup_rockridge` tinyint(1) unsigned NULL , `racegroup_werner_lab` tinyint(1) unsigned NULL , `racegroup_temple_demon` tinyint(1) unsigned NULL , `racegroup_illusion_vampire` tinyint(1) unsigned NULL , `racegroup_malangdo` tinyint(1) unsigned NULL , `racegroup_ep172alpha` tinyint(1) unsigned NULL , `racegroup_ep172beta` tinyint(1) unsigned NULL , `racegroup_ep172bath` tinyint(1) unsigned NULL , `racegroup_illusion_turtle` tinyint(1) unsigned NULL , `racegroup_rachel_sanctuary` tinyint(1) unsigned NULL , `racegroup_illusion_luanda` tinyint(1) unsigned NULL , `element` varchar(24) NULL , `element_level` tinyint(4) unsigned NULL , `walk_speed` smallint(6) unsigned NULL , `attack_delay` smallint(6) unsigned NULL , `attack_motion` smallint(6) unsigned NULL , `damage_motion` smallint(6) unsigned NULL , `damage_taken` smallint(6) unsigned NULL , `ai` varchar(2) NULL , `class` varchar(50) NULL , `mode_canmove` tinyint(1) unsigned NULL , `mode_looter` tinyint(1) unsigned NULL , `mode_aggressive` tinyint(1) unsigned NULL , `mode_assist` tinyint(1) unsigned NULL , `mode_castsensoridle` tinyint(1) unsigned NULL , `mode_norandomwalk` tinyint(1) unsigned NULL , `mode_nocast` tinyint(1) unsigned NULL , `mode_canattack` tinyint(1) unsigned NULL , `mode_castsensorchase` tinyint(1) unsigned NULL , `mode_changechase` tinyint(1) unsigned NULL , `mode_angry` tinyint(1) unsigned NULL , `mode_changetargetmelee` tinyint(1) unsigned NULL , `mode_changetargetchase` tinyint(1) unsigned NULL , `mode_targetweak` tinyint(1) unsigned NULL , `mode_randomtarget` tinyint(1) unsigned NULL , `mode_ignoremelee` tinyint(1) unsigned NULL , `mode_ignoremagic` tinyint(1) unsigned NULL , `mode_ignoreranged` tinyint(1) unsigned NULL , `mode_mvp` tinyint(1) unsigned NULL , `mode_ignoremisc` tinyint(1) unsigned NULL , `mode_knockbackimmune` tinyint(1) unsigned NULL , `mode_teleportblock` tinyint(1) unsigned NULL , `mode_fixeditemdrop` tinyint(1) unsigned NULL , `mode_detector` tinyint(1) unsigned NULL , `mode_statusimmune` tinyint(1) unsigned NULL , `mode_skillimmune` tinyint(1) unsigned NULL , `mvpdrop1_item` varchar(50) NULL , `mvpdrop1_rate` smallint(9) unsigned NULL , `mvpdrop1_option` varchar(50) NULL , `mvpdrop1_index` tinyint(2) unsigned NULL , `mvpdrop2_item` varchar(50) NULL , `mvpdrop2_rate` smallint(9) unsigned NULL , `mvpdrop2_option` varchar(50) NULL , `mvpdrop2_index` tinyint(2) unsigned NULL , `mvpdrop3_item` varchar(50) NULL , `mvpdrop3_rate` smallint(9) unsigned NULL , `mvpdrop3_option` varchar(50) NULL , `mvpdrop3_index` tinyint(2) unsigned NULL , `drop1_item` varchar(50) NULL , `drop1_rate` smallint(9) unsigned NULL , `drop1_nosteal` tinyint(1) unsigned NULL , `drop1_option` varchar(50) NULL , `drop1_index` tinyint(2) unsigned NULL , `drop2_item` varchar(50) NULL , `drop2_rate` smallint(9) unsigned NULL , `drop2_nosteal` tinyint(1) unsigned NULL , `drop2_option` varchar(50) NULL , `drop2_index` tinyint(2) unsigned NULL , `drop3_item` varchar(50) NULL , `drop3_rate` smallint(9) unsigned NULL , `drop3_nosteal` tinyint(1) unsigned NULL , `drop3_option` varchar(50) NULL , `drop3_index` tinyint(2) unsigned NULL , `drop4_item` varchar(50) NULL , `drop4_rate` smallint(9) unsigned NULL , `drop4_nosteal` tinyint(1) unsigned NULL , `drop4_option` varchar(50) NULL , `drop4_index` tinyint(2) unsigned NULL , `drop5_item` varchar(50) NULL , `drop5_rate` smallint(9) unsigned NULL , `drop5_nosteal` tinyint(1) unsigned NULL , `drop5_option` varchar(50) NULL , `drop5_index` tinyint(2) unsigned NULL , `drop6_item` varchar(50) NULL , `drop6_rate` smallint(9) unsigned NULL , `drop6_nosteal` tinyint(1) unsigned NULL , `drop6_option` varchar(50) NULL , `drop6_index` tinyint(2) unsigned NULL , `drop7_item` varchar(50) NULL , `drop7_rate` smallint(9) unsigned NULL , `drop7_nosteal` tinyint(1) unsigned NULL , `drop7_option` varchar(50) NULL , `drop7_index` tinyint(2) unsigned NULL , `drop8_item` varchar(50) NULL , `drop8_rate` smallint(9) unsigned NULL , `drop8_nosteal` tinyint(1) unsigned NULL , `drop8_option` varchar(50) NULL , `drop8_index` tinyint(2) unsigned NULL , `drop9_item` varchar(50) NULL , `drop9_rate` smallint(9) unsigned NULL , `drop9_nosteal` tinyint(1) unsigned NULL , `drop9_option` varchar(50) NULL , `drop9_index` tinyint(2) unsigned NULL , `drop10_item` varchar(50) NULL , `drop10_rate` smallint(9) unsigned NULL , `drop10_nosteal` tinyint(1) unsigned NULL , `drop10_option` varchar(50) NULL , `drop10_index` tinyint(2) unsigned NULL , `origin_table` varchar(12) NULL , PRIMARY KEY( `id` ), UNIQUE KEY `name_aegis` ( `name_aegis` ) ); )
PDOStatement Object ( [queryString] => INSERT INTO osro.monsters SELECT osro.mob_db.*, 'osro.mob_db' FROM osro.mob_db )
PDOStatement Object ( [queryString] => REPLACE INTO osro.monsters SELECT osro.mob_db2.*, 'osro.mob_db2' FROM osro.mob_db2 )
PDOStatement Object ( [queryString] => SELECT COUNT(monsters.ID) AS total FROM osro.monsters WHERE 1=1 )
PDOStatement Object ( [queryString] => SELECT origin_table, monsters.ID AS monster_id, name_english, name_japanese, level, hp, size, race, element, element_level, base_exp, job_exp, mvp_exp FROM osro.monsters WHERE 1=1 ORDER BY (CASE WHEN `monster_id` IS NULL THEN 1 ELSE 0 END) ASC, `monster_id` ASC LIMIT 0,20 )
Found a total of 1008 record(s) across 51 page(s). Displaying result(s) 1-20.
Monster ID ▲ | kRO Name | iRO Name | Level | HP | Size | Race | Element | Base EXP | Job EXP | Custom |
---|---|---|---|---|---|---|---|---|---|---|
1001 | Scorpion | Scorpion | 24 | 1,109 | Small | Insect | Fire (Lv 1) | 5,740 | 3,520 | No |
1002 | Poring | Poring | 1 | 50 | Medium | Plant | Water (Lv 1) | 40 | 20 | No |
1004 | Hornet | Hornet | 8 | 169 | Small | Insect | Wind (Lv 1) | 380 | 300 | No |
1005 | Familiar | Familiar | 8 | 155 | Small | Brute | Dark (Lv 1) | 560 | 300 | No |
1007 | Fabre | Fabre | 2 | 63 | Small | Insect | Earth (Lv 1) | 60 | 40 | No |
1008 | Pupa | Pupa | 2 | 427 | Small | Insect | Earth (Lv 1) | 40 | 80 | No |
1009 | Condor | Condor | 5 | 92 | Medium | Brute | Wind (Lv 1) | 120 | 100 | No |
1010 | Willow | Willow | 4 | 95 | Medium | Plant | Earth (Lv 1) | 100 | 80 | No |
1011 | Chonchon | Chonchon | 4 | 67 | Small | Insect | Wind (Lv 1) | 100 | 80 | No |
1012 | Roda Frog | Roda Frog | 5 | 133 | Medium | Fish | Water (Lv 1) | 120 | 100 | No |
1013 | Wolf | Wolf | 25 | 919 | Medium | Brute | Earth (Lv 1) | 6,580 | 3,980 | No |
1014 | Spore | Spore | 16 | 510 | Medium | Plant | Water (Lv 1) | 1,320 | 2,160 | No |
1015 | Zombie | Zombie | 15 | 534 | Medium | Undead | Undead (Lv 1) | 1,000 | 660 | No |
1016 | Archer Skeleton | Archer Skeleton | 31 | 3,040 | Medium | Undead | Undead (Lv 1) | 9,660 | 5,660 | No |
1018 | Creamy | Creamy | 16 | 595 | Small | Insect | Wind (Lv 1) | 2,100 | 1,400 | No |
1019 | Peco Peco | Peco Peco | 19 | 531 | Large | Brute | Fire (Lv 1) | 3,180 | 1,440 | No |
1020 | Mandragora | Mandragora | 12 | 405 | Medium | Plant | Earth (Lv 3) | 900 | 640 | No |
1023 | Orc Warrior | Orc Warrior | 24 | 1,400 | Medium | Demi-Human | Earth (Lv 1) | 8,160 | 3,200 | No |
1024 | Wormtail | Wormtail | 14 | 426 | Medium | Plant | Earth (Lv 1) | 1,180 | 800 | No |
1025 | Boa | Boa | 15 | 471 | Medium | Brute | Earth (Lv 1) | 1,440 | 960 | No |
PDOStatement Object ( [queryString] => DROP TEMPORARY TABLE IF EXISTS osro.monsters )