Data Load Status

[Zegridathes]

This will be a bit easier than PM's...

I'm going to start using this as a running thread for questions and concerns and such.

In trying to load all the data into a database, I've run into some inconsistent stuff... I've mostly just been nulling it out but I'll still give you an idea what I've done.

RESOLVED ISSUES

ITEMS
-Removed the 7 or 8 untranslated columns that were all 0's. The only place it any of them were ever set to 1 was 5-7 rows of items called 'unused'
-Removed all the incomplete rows (no name, id, just untranslated text or any rows which were just an id)


MONSTERS
-Removed all drop references which were not numbers, replaced with 0.
-Sky Blue Young CoccKo (10620600) has a Defense % value of 'q', replaced with 0.
-Removed rear column of untranslated text.
-I think I removed some incomplete rows...

OUTSTANDING ISSUES
ITEMS
-Duplicate ItemIDs.... what should I do with those?
10032780 (Liquid Fuel(Quest), Gas Fuel(Quest))
10050604 (Orange Baby Marionette, Marionette Baby Orange)
10050605 (Golem Baby Orange, Orange Baby Golem)
10060200 (Wind Guardian(Small), Wind Guardian(Small))
10060202 (Wind Guardian(Large), Wind Guardian(Large))
20050022 (Spotlight, Spotlight)

MONSTERS
-Duplicate idnums... what should I do with those (they are all Level 0)?
30040004 (Western Fruit Tree, TREE)
30280005 (CONTAINER, Container)
30290005 (Wooden Box, Wooden Box)

CRITERIA FOR EXCLUDING DATA

I'd appreciate if you could give me a thumbs-up/thumbs-down on each of these as a way of filtering out what actually needs a page...

ITEMS
-??? You said some items with (Unused) actually show up?

MONSTERS
-LV = 0 (Excludes 277 rows. Most look like map objects, skill dummy monsters, gathering skill points? Most have missing or crazy stats (127 in all stats and 9999-9999 damage? all 1? Some have legitimate looking stats but bad names: GreenMons, Bloody, ANIMAL, INSECT, MAGIC_CREATURE)
-

TABLE SCHEMA

If you want to see what I've called the fields in the table...
ITEMS

Spoiler!

CREATE TABLE [dbo].[ITEM](
[NAME] [varchar](50) NULL,
[ITEMID] [int] NULL,
[PICTID] [int] NULL,
[ICONID] [int] NULL,
[TYPE] [varchar](50) NULL,
[PRICE] [int] NULL,
[WT] [int] NULL,
[CAP] [int] NULL,
[EQPWT] [int] NULL,
[PSSNWT] [int] NULL,
[REPAIR] [int] NULL,
[TREATCLUB] [int] NULL,
[ISFROMEVENT] [int] NULL,
[ISRECIPE] [int] NULL,
[ISDYABLE] [int] NULL,
[ISSTACKABLE] [int] NULL,
[ISTWOHANDED] [int] NULL,
[ISUSABLE] [int] NULL,
[COLOUR] [int] NULL,
[DURABILITY] [int] NULL,
[ISNOTCASHSHOP] [int] NULL,
[EVENTID] [int] NULL,
[EFFECT] [int] NULL,
[ACTIVESKLL] [int] NULL,
[USESKLL] [int] NULL,
[PASSIVESKLL] [int] NULL,
[TARGET] [varchar](20) NULL,
[ACTIVATETYPE] [varchar](20) NULL,
[RANGE] [int] NULL,
[EFFECTTIME] [int] NULL,
[EFFECTRANGE] [int] NULL,
[CASTTIME] [int] NULL,
[COOLDOWN] [int] NULL,
[HPPLUS] [int] NULL,
[MPPLUS] [int] NULL,
[SPPLUS] [int] NULL,
[WTPLUS] [int] NULL,
[CAPPLUS] [int] NULL,
[MOVPLUS] [int] NULL,
[STR] [int] NULL,
[MAG] [int] NULL,
[VIT] [int] NULL,
[DEX] [int] NULL,
[AGI] [int] NULL,
[INT] [int] NULL,
[LUK] [int] NULL,
[CHA] [int] NULL,
[ATK_H] [int] NULL,
[ATK_S] [int] NULL,
[ATK_T] [int] NULL,
[MATK] [int] NULL,
[DEF] [int] NULL,
[MDEF] [int] NULL,
[SHIT] [int] NULL,
[LHIT] [int] NULL,
[MHIT] [int] NULL,
[SAVOID] [int] NULL,
[LAVOID] [int] NULL,
[MAVOID] [int] NULL,
[CRITHIT] [int] NULL,
[CRITAVOID] [int] NULL,
[HPREGEN] [int] NULL,
[MPREGEN] [int] NULL,
[NEUTRAL] [int] NULL,
[FIRE] [int] NULL,
[WATER] [int] NULL,
[WIND] [int] NULL,
[EARTH] [int] NULL,
[LIGHT] [int] NULL,
[DARK] [int] NULL,
[POISON] [int] NULL,
[STONE] [int] NULL,
[PARALYZE] [int] NULL,
[SLEEP] [int] NULL,
[SILENT] [int] NULL,
[SLOW] [int] NULL,
[CONFUSION] [int] NULL,
[FROZE] [int] NULL,
[STUN] [int] NULL,
[EMIL] [int] NULL,
[TITANIAN] [int] NULL,
[DOMINION] [int] NULL,
[MALE] [int] NULL,
[FEMALE] [int] NULL,
[LV] [int] NULL,
[REQSTR] [int] NULL,
[REQMAG] [int] NULL,
[REQVIT] [int] NULL,
[REQDEX] [int] NULL,
[REQAGI] [int] NULL,
[REQINT] [int] NULL,
[REQLUK] [int] NULL,
[REQCHA] [int] NULL,
[NOVICE] [int] NULL,
[SWORDSMAN] [int] NULL,
[BLADEMASTER] [int] NULL,
[BOUNTYHUNTER] [int] NULL,
[FENCER] [int] NULL,
[KNIGHT] [int] NULL,
[DARKSTALKER] [int] NULL,
[SCOUT] [int] NULL,
[ASSASSIN] [int] NULL,
[COMMAND] [int] NULL,
[ARCHER] [int] NULL,
[STRIKER] [int] NULL,
[GUNNER] [int] NULL,
[WIZARD] [int] NULL,
[SORCERER] [int] NULL,
[SAGE] [int] NULL,
[SHAMAN] [int] NULL,
[SUMMONER] [int] NULL,
[ENCHANTER] [int] NULL,
[VATTERS] [int] NULL,
[DRUID] [int] NULL,
[BARD] [int] NULL,
[WARLOCK] [int] NULL,
[CABALIST] [int] NULL,
[NECROMANCER] [int] NULL,
[MINER] [int] NULL,
[BLACKSMITH] [int] NULL,
[MACHINIST] [int] NULL,
[FARMER] [int] NULL,
[ALCHEMIST] [int] NULL,
[MARIONETTER] [int] NULL,
[RANGER] [int] NULL,
[EXPLORER] [int] NULL,
[TREASUREHUNTER] [int] NULL,
[MERCHANT] [int] NULL,
[TRADER] [int] NULL,
[GAMBLER] [int] NULL,
[EAST] [int] NULL,
[WEST] [int] NULL,
[SOUTH] [int] NULL,
[NORTH] [int] NULL,
[UNKNOWN] [int] NULL,
[AMONSTERI] [int] NULL,
[SOMETHINGID] [int] NULL,
[MYSTERYID] [int] NULL,
[ITEMDESCRIPTION] [varchar](300) NULL,
[ITEMITEM] [int] NULL,
[ITEM2ITEM2] [int] NULL,
[ISLV] [int] NULL
) ON [PRIMARY]

MONSTERS

Spoiler!

CREATE TABLE [dbo].[MONSTER](
[IDNUM] [int] NULL,
[NAME] [varchar](50) NULL,
[PICTID] [int] NULL,
[TYPE] [varchar](50) NULL,
[WIDTH] [int] NULL,
[LENGTH] [int] NULL,
[SCALE] [decimal](10, 3) NULL,
[FLYING] [int] NULL,
[UNDEAD] [int] NULL,
[LV] [int] NULL,
[BRSTR] [int] NULL,
[MAG] [int] NULL,
[STR] [int] NULL,
[DEX] [int] NULL,
[AGI] [int] NULL,
[INT] [int] NULL,
[LUK] [int] NULL,
[CHA] [int] NULL,
[HP] [int] NULL,
[SP] [int] NULL,
[MP] [int] NULL,
[SPEED] [int] NULL,
[ATKMIN] [int] NULL,
[ATKMAX] [int] NULL,
[ATKTYPE] [varchar](10) NULL,
[MAGMIN] [int] NULL,
[MAGMAX] [int] NULL,
[DEF] [int] NULL,
[DEFPCT] [int] NULL,
[MDEF] [int] NULL,
[MDEFPCT] [int] NULL,
[HITSHORT] [int] NULL,
[HITLONG] [int] NULL,
[HITMAGIC] [int] NULL,
[EVADESHORT] [int] NULL,
[EVADELONG] [int] NULL,
[EVADEMAGIC] [int] NULL,
[CRITHIT] [int] NULL,
[CRITEVADE] [int] NULL,
[PRESILIENCE] [int] NULL,
[MRESILIENCE] [int] NULL,
[ATKSPDPHYSICAL] [int] NULL,
[ATKSPDCHANT] [int] NULL,
[ATKSPDRANGE] [int] NULL,
[NEUTRALATTR] [int] NULL,
[FIREATTR] [int] NULL,
[WATERATTR] [int] NULL,
[WINDATTR] [int] NULL,
[EARTHATTR] [int] NULL,
[LIGHTATTR] [int] NULL,
[DARKATTR] [int] NULL,
[POISONATTR] [int] NULL,
[PETRIFICATIONRESIST] [int] NULL,
[STUNRESIST] [int] NULL,
[SLEEPRESIST] [int] NULL,
[SILENCERESIST] [int] NULL,
[SLOWRESIST] [int] NULL,
[CONFUSIONRESIST] [int] NULL,
[FREEZERESIST] [int] NULL,
[COMARESIST] [int] NULL,
[ID1] [int] NULL,
[ID1CH] [int] NULL,
[ID2] [int] NULL,
[ID2CH] [int] NULL,
[ID3] [int] NULL,
[ID3CH] [int] NULL,
[ID4] [int] NULL,
[ID4CH] [int] NULL,
[ID5] [int] NULL,
[ID5CH] [int] NULL,
[IDARRIVE] [int] NULL,
[ARRIVECH] [int] NULL,
[DIE1] [int] NULL,
[DIE1CH] [int] NULL,
[DIE2] [int] NULL,
[DIE2CH] [int] NULL,
[DIE3] [int] NULL,
[DIE3CH] [int] NULL,
[DIE4] [int] NULL,
[DIE4CH] [int] NULL,
[DIE5] [int] NULL,
[DIE5CH] [int] NULL,
[FINALACT] [int] NULL,
[FINALACTCH] [int] NULL,
[SKILL1] [int] NULL,
[SKILL1CH] [int] NULL,
[SKILL2] [int] NULL,
[SKILL2CH] [int] NULL,
[SKILL3] [int] NULL,
[SKILL3CH] [int] NULL,
[SKILL4] [int] NULL,
[SKILL4CH] [int] NULL,
[SKILL5] [int] NULL,
[SKILL5CH] [int] NULL,
[SKILL6] [int] NULL,
[SKILL6CH] [int] NULL,
[EXP] [int] NULL,
[JOB] [int] NULL,
[DROPID] [int] NULL,
[DROP1] [int] NULL,
[DROP2] [int] NULL,
[DROP3] [int] NULL,
[DROP4] [int] NULL,
[DROP5] [int] NULL,
[DROP6] [int] NULL,
[DROP7] [int] NULL,
[DROP8] [int] NULL,
[DROP8CH] [int] NULL,
[UNINTELLIGIBLE] [varchar](300) NULL,
[WASTE0] [int] NULL,
[WASTE1] [int] NULL
) ON [PRIMARY]

[Noperative]

If you need help identifying which parameters match with which columns I can help, since most of them are shortened.

Which would be the best for the bot, a single parameter called Drop or a bunch of slots with rarity parameters?

[Zegridathes]

I updated OP

[Noperative]

Originally Posted by Zegridathes

OUTSTANDING ISSUES
ITEMS
-Duplicate ItemIDs.... what should I do with those?
10032780 (Liquid Fuel(Quest), Gas Fuel(Quest)) Delete, quest items are triggers and these are probably the same trigger. We don't need all the quest items.
10050604 (Orange Baby Marionette, Marionette Baby Orange) Use Orange Baby Marionette, marionette baby orange seems like a failed translation swept under the bed.
10050605 (Golem Baby Orange, Orange Baby Golem) same as above.
10060200 (Wind Guardian(Small), Wind Guardian(Small))
10060202 (Wind Guardian(Large), Wind Guardian(Large))
20050022 (Spotlight, Spotlight)just delete the copies, there's plenty of room for errors

MONSTERS
-Duplicate idnums... what should I do with those (they are all Level 0)?
30040004 (Western Fruit Tree, TREE)
30280005 (CONTAINER, Container)
30290005 (Wooden Box, Wooden Box)
These are just Objects in the game that you can break for some drops. TREE and CONTAINER are debugs, the rest are valid. Duplicate boxes/containers/treasure boxes are due to the fact that they have different drops depending on the location. (Beginner areas drop wooden box 1, higher levels may drop box 7, 8, etc.)
CRITERIA FOR EXCLUDING DATA

I'd appreciate if you could give me a thumbs-up/thumbs-down on each of these as a way of filtering out what actually needs a page...

ITEMS
-??? You said some items with (Unused) actually show up?
I've seen Time-Space Fire Staff(Unused) in game, though it may be the only exception. Notice how there isn't a normal Time-Space Fire staff, just the unused one so it might be a RUNDOWNGG.
MONSTERS
-LV = 0 (Excludes 277 rows. Most look like map objects, skill dummy monsters, gathering skill points? Most have missing or crazy stats (127 in all stats and 9999-9999 damage? all 1? Some have legitimate looking stats but bad names: GreenMons, Bloody, ANIMAL, INSECT, MAGIC_CREATURE)
-Delete everything except map objects. Some objects will have a copy since Farmers can grow plants with different drops, these should have CULTURE as a category, so change the name of those to something like Tree (Grown).

TABLE SCHEMA

If you want to see what I've called the fields in the table... *corrects a few and wonders if that's how you're naming the parameters*
ITEMS

Spoiler!

CREATE TABLE [dbo].[ITEM](
[NAME] [varchar](50) NULL,
[ITEMID] [int] NULL,
[PICTID] [int] NULL,
[ICONID] [int] NULL,
[TYPE] [varchar](50) NULL,
[PRICE] [int] NULL,
[WT] [int] NULL,
[CAP] [int] NULL,
[EQPWT] [int] NULL,
[PSSNWT] [int] NULL,
[REPAIR] [int] NULL,
[TREATCLUB] [int] NULL,
[ISFROMEVENT] [int] NULL,
[ISRECIPE] [int] NULL,
[ISDYABLE] [int] NULL,
[ISSTACKABLE] [int] NULL,
[ISTWOHANDED] [int] NULL,
[ISUSABLE] [int] NULL,
[COLOUR] [int] NULL,
[DURABILITY] [int] NULL,
[ISNOTCASHSHOP] [int] NULL,
[EVENTID] [int] NULL,
[EFFECT] [int] NULL,
[ACTIVESKLL] [int] NULL,
[USESKLL] [int] NULL,
[PASSIVESKLL] [int] NULL,
[TARGET] [varchar](20) NULL,
[ACTIVATETYPE] [varchar](20) NULL,
[RANGE] [int] NULL,
[EFFECTTIME] [int] NULL,
[EFFECTRANGE] [int] NULL,
[CASTTIME] [int] NULL,
[COOLDOWN] [int] NULL,
[HPPLUS] [int] NULL,
[MPPLUS] [int] NULL,
[SPPLUS] [int] NULL,
[WTPLUS] [int] NULL,
[CAPPLUS] [int] NULL,
[MOVPLUS] [int] NULL,
[STR] [int] NULL,
[MAG] [int] NULL,
[VIT] [int] NULL,
[DEX] [int] NULL,
[AGI] [int] NULL,
[INT] [int] NULL,
[LUK] [int] NULL,
[CHA] [int] NULL,
[ATK_H] [int] NULL,
[ATK_S] [int] NULL,
[ATK_T] [int] NULL,
[MATK] [int] NULL,
[DEF] [int] NULL,
[MDEF] [int] NULL,
[SHIT] [int] NULL,
[LHIT] [int] NULL,
[MHIT] [int] NULL,
[SAVOID] [int] NULL,
[LAVOID] [int] NULL,
[MAVOID] [int] NULL,
[CRITHIT] [int] NULL,
[CRITAVOID] [int] NULL,
[HPREGEN] [int] NULL,
[MPREGEN] [int] NULL,
[NEUTRAL] [int] NULL,
[FIRE] [int] NULL,
[WATER] [int] NULL,
[WIND] [int] NULL,
[EARTH] [int] NULL,
[LIGHT] [int] NULL,
[DARK] [int] NULL,
[POISON] [int] NULL,
[STONE] [int] NULL,
[PARALYZE] [int] NULL,
[SLEEP] [int] NULL,
[SILENT] [int] NULL,
[SLOW] [int] NULL,
[CONFUSION] [int] NULL,
[FROZE] [int] NULL,
[STUN] [int] NULL,
[EMIL] [int] NULL,
[TITANIAN] [int] NULL,
[DOMINION] [int] NULL,
[MALE] [int] NULL,
[FEMALE] [int] NULL,
[LV] [int] NULL,
[REQSTR] [int] NULL,
[REQMAG] [int] NULL,
[REQVIT] [int] NULL,
[REQDEX] [int] NULL,
[REQAGI] [int] NULL,
[REQINT] [int] NULL,
[REQLUK] [int] NULL,
[REQCHA] [int] NULL,
[NOVICE] [int] NULL,
[SWORDSMAN] [int] NULL,
[BLADEMASTER] [int] NULL,
[BOUNTYHUNTER] [int] NULL,
[FENCER] [int] NULL,
[KNIGHT] [int] NULL,
[DARKSTALKER] [int] NULL,
[SCOUT] [int] NULL,
[ASSASSIN] [int] NULL,
[COMMAND] [int] NULL,
[ARCHER] [int] NULL,
[STRIKER] [int] NULL,
[GUNNER] [int] NULL,
[WIZARD] [int] NULL,
[SORCERER] [int] NULL,
[SAGE] [int] NULL,
[SHAMAN] [int] NULL,
[SUMMONER] [int] NULL,
[ENCHANTER] [int] NULL,
[VATES] [int] NULL,
[DRUID] [int] NULL,
[BARD] [int] NULL,
[WARLOCK] [int] NULL,
[CABALIST] [int] NULL,
[NECROMANCER] [int] NULL,
[MINER] [int] NULL,
[BLACKSMITH] [int] NULL,
[MACHINIST] [int] NULL,
[FARMER] [int] NULL,
[ALCHEMIST] [int] NULL,
[MARIONETTIST] [int] NULL,
[RANGER] [int] NULL,
[EXPLORER] [int] NULL,
[TREASUREHUNTER] [int] NULL,
[MERCHANT] [int] NULL,
[TRADER] [int] NULL,
[GAMBLER] [int] NULL,
[EAST] [int] NULL,
[WEST] [int] NULL,
[SOUTH] [int] NULL,
[NORTH] [int] NULL,
[UNKNOWN] [int] NULL,
[AMONSTERI] [int] NULL,
[SOMETHINGID] [int] NULL,
[MYSTERYID] [int] NULL,
[ITEMDESCRIPTION] [varchar](300) NULL,
[ITEMITEM] [int] NULL,
[ITEM2ITEM2] [int] NULL,
[ISLV] [int] NULL
) ON [PRIMARY]

MONSTERS

Spoiler!

CREATE TABLE [dbo].[MONSTER](
[IDNUM] [int] NULL,
[NAME] [varchar](50) NULL,
[PICTID] [int] NULL,
[TYPE] [varchar](50) NULL,
[WIDTH] [int] NULL,
[LENGTH] [int] NULL,
[SCALE] [decimal](10, 3) NULL,
[FLYING] [int] NULL,
[UNDEAD] [int] NULL,
[LV] [int] NULL,
[BRSTR] [int] NULL,
[MAG] [int] NULL,
[STR] [int] NULL,
[DEX] [int] NULL,
[AGI] [int] NULL,
[INT] [int] NULL,
[LUK] [int] NULL,
[CHA] [int] NULL,
[HP] [int] NULL,
[SP] [int] NULL,
[MP] [int] NULL,
[SPEED] [int] NULL,
[ATKMIN] [int] NULL,
[ATKMAX] [int] NULL,
[ATKTYPE] [varchar](10) NULL,
[MAGMIN] [int] NULL,
[MAGMAX] [int] NULL,
[DEF] [int] NULL,
[DEFPCT] [int] NULL,
[MDEF] [int] NULL,
[MDEFPCT] [int] NULL,
[HITSHORT] [int] NULL,
[HITLONG] [int] NULL,
[HITMAGIC] [int] NULL,
[EVADESHORT] [int] NULL,
[EVADELONG] [int] NULL,
[EVADEMAGIC] [int] NULL,
[CRITHIT] [int] NULL,
[CRITEVADE] [int] NULL,
[PRESILIENCE] [int] NULL,
[MRESILIENCE] [int] NULL,
[ATKSPDPHYSICAL] [int] NULL,
[ATKSPDCHANT] [int] NULL,
[ATKSPDRANGE] [int] NULL,
[NEUTRALATTR] [int] NULL,
[FIREATTR] [int] NULL,
[WATERATTR] [int] NULL,
[WINDATTR] [int] NULL,
[EARTHATTR] [int] NULL,
[LIGHTATTR] [int] NULL,
[DARKATTR] [int] NULL,
[POISONATTR] [int] NULL,
[PETRIFICATIONRESIST] [int] NULL,
[STUNRESIST] [int] NULL,
[SLEEPRESIST] [int] NULL,
[SILENCERESIST] [int] NULL,
[SLOWRESIST] [int] NULL,
[CONFUSIONRESIST] [int] NULL,
[FREEZERESIST] [int] NULL,
[COMARESIST] [int] NULL,
[ID1] [int] NULL,
[ID1CH] [int] NULL,
[ID2] [int] NULL,
[ID2CH] [int] NULL,
[ID3] [int] NULL,
[ID3CH] [int] NULL,
[ID4] [int] NULL,
[ID4CH] [int] NULL,
[ID5] [int] NULL,
[ID5CH] [int] NULL,
[IDARRIVE] [int] NULL,
[ARRIVECH] [int] NULL,
[DIE1] [int] NULL,
[DIE1CH] [int] NULL,
[DIE2] [int] NULL,
[DIE2CH] [int] NULL,
[DIE3] [int] NULL,
[DIE3CH] [int] NULL,
[DIE4] [int] NULL,
[DIE4CH] [int] NULL,
[DIE5] [int] NULL,
[DIE5CH] [int] NULL,
[FINALACT] [int] NULL,
[FINALACTCH] [int] NULL,
[SKILL1] [int] NULL,
[SKILL1CH] [int] NULL,
[SKILL2] [int] NULL,
[SKILL2CH] [int] NULL,
[SKILL3] [int] NULL,
[SKILL3CH] [int] NULL,
[SKILL4] [int] NULL,
[SKILL4CH] [int] NULL,
[SKILL5] [int] NULL,
[SKILL5CH] [int] NULL,
[SKILL6] [int] NULL,
[SKILL6CH] [int] NULL,
[EXP] [int] NULL,
[JOB] [int] NULL,
[DROPID] [int] NULL,
[DROP1] [int] NULL,
[DROP2] [int] NULL,
[DROP3] [int] NULL,
[DROP4] [int] NULL,
[DROP5] [int] NULL,
[DROP6] [int] NULL,
[DROP7] [int] NULL,
[DROP8] [int] NULL,
[DROP8CH] [int] NULL,
[UNINTELLIGIBLE] [varchar](300) NULL,
[WASTE0] [int] NULL,
[WASTE1] [int] NULL
) ON [PRIMARY]

That's all I can say, I guess. A few of the columns in the tables aren't needed, but we could just exclude the parameters from the template so they won't show up anyway.

For monster drops, is it a good idea to just use..

Drop=[[Image:ECO Item.gif]][[Items/Equipment:Item|Item]] (Rarity)<br>[[Image:ECO Item.gif]][[Items/Equipment:Item|Item]] (Rarity)<br>etc..

And possibly create a MonsterList when making drop lists for Item pages. This isn't really needed so it's fine if you don't.

[Zegridathes]

The column names are just... sorta derived from csv column names... thinks like . and # and other characters just complicate things so I accounted for them... also dupe names.

[Noperative]

Do you want the template parameters changed so it'll be easier for the bot? Or is it fine to leave them as it is?

[Noperative]

So this is what I'm hoping for the monster dump to look like:

Spoiler!

Create new page: Monster:[NAME]
{{Monster
|Name=[NAME]
|Level=[LV]
|Exp=[EXP]
|JEXP=[JOB]
|HP=[HP]
|SP=[SP]
|MP=[MP]
|RACE=[TYPE]
|Behavior=
|PATK=[ATKMIN] ~ [ATKMAX]
|MATK=[MAGMIN] ~ [MAGMAX]
|PTYPE=[ATKTYPE]
|PDEF=[DEF] ([DEFPCT]%)
|MDEF=[MDEF] ([MDEFPCT]%)
|Neutral=[NEUTRALATTR]
|Fire=[FIREATTR]
|Water=[WATERATTR]
|Wind=[WINDATTR]
|Earth=[EARTHATTR]
|Dark=[DARKATTR]
|Light=[LIGHTATTR]
|Speed=[SPEED]
|ASpeed=[ATKSPDRANGE]
|CSpeed=[ATKSPDCHANT]
|SAVOID=[EVADESHORT]
|LAVOID=[EVADELONG]
|MAVOID=[EVADEMAGIC]
|SHIT=[HITSHORT]
|LHIT=[HITLONG]
|MHIT=[HITMAGIC]
|CHIT=[CRITHIT]
|CAVOID=[CRITEVADE]
|Skills=[[Skill:[SKILL1]|[SKILL1]]] ([SKILL1CH]%]<br>
[[Skill:[SKILL2]|[SKILL2]]] ([SKILL2CH]%)<br>
[[Skill:[SKILL3]|[SKILL3]]] ([SKILL3CH]%)<br>
[[Skill:[SKILL4]|[SKILL4]]] ([SKILL4CH]%)<br>
[[Skill:[SKILL5]|[SKILL5]]] ([SKILL5CH]%)<br>
[[Skill:[SKILL6]|[SKILL6]]] ([SKILL6CH]%)<br>
|Drops=[[Image:ECO [DROP1].gif]] [[Items:[DROP1]|[DROP1]]] (Common)<br>
[[Image:ECO [DROP2].gif]] [[Items:[DROP2]|[DROP2]]] (Common)<br>
[[Image:ECO [DROP3].gif]] [[Items:[DROP3]|[DROP3]]] (Uncommon)<br>
[[Image:ECO [DROP4].gif]] [[Items:[DROP4]|[DROP4]]] (Very Rare)<br>
[[Image:ECO [DROP5].gif]] [[Items:[DROP5]|[DROP5]]] (Very Rare)<br>
[[Image:ECO [DROP6].gif]] [[Items:[DROP6]|[DROP6]]] (Rare)<br>
[[Image:ECO [DROP7].gif]] [[Items:[DROP7]|[DROP7]]] (Extremely Rare)<br>
[[Image:ECO [DROP8].gif]] [[Items:[DROP8]|[DROP8]]] (Extremely Rare)<br>
|PoisonResist=[POISONATTR]
|PetrifyResist=[PETRIFICATIONRESIST]
|Paralyze Resist=[STUNRESIST]
|SleepResist=[SLEEPRESIST]
|SilenceResist=[SILENCERESIST]
|SlowResist=[SLOWRESIST]
|ConfusionResist=[CONFUSIONRESIST]
|FreezeResist=[FREEZERESIST]
|StunResist=[COMARESIST]
}}

Start on next row entry-

Create new page: Monster:[NAME]

etc etc

Parts in blue are only to be put in if they are not 0 or null.

Skill and Item Drops should be in their proper naming, so you'll have to cross reference with the Skill and Item tables.

When making a link in the Drops, if the linked page does NOT have another page linking to it, rewrite Items: to Equipment: . If it STILL does not have a page linking to it rewrite it to Pet: . Even if the bot makes a error and sends some pages into Pet, it'll be a lot easier to detect the errors than having to sift through the Item and Equipment categories.

I'll plan out how I hope the bot should dump an Item page later but it's a lot bigger than a Monster template.