Template:Mob Stats: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<!-- Editor's note --> | |||
<!-- | |||
To use this template paste the next line of text into the wiki page where you want it to appear: | |||
{{Mob Stats|mobID=########}} | |||
You '''must''' provide a mob ID from the database mob_stats table for this template to display values. | |||
If the mob ID you need isn't present in the mob_stats table then the information can be loaded into the table by going to the NM in game and using !check on it. | |||
If you need to make a custom adjustment to the table's header (ex. specifying which Waughroon Shrine Sinister Reign Dark Dragon is which enemy) use the following modification: | |||
{{Mob Stats|mobID=########|altName=altTextHere}} | |||
--> | |||
{{#get_db_data: | {{#get_db_data: | ||
db=MediaWiki | db=MediaWiki | ||
Revision as of 03:56, 12 August 2025
The query SELECT REPLACE(mob_name,'_',' '),mob_lvl,mob_max_hp,mob_max_mp,mob_STR,mob_DEX,mob_VIT,mob_AGI,mob_INT,mob_MND,mob_CHR,mob_Regen,mob_Haste,mob_ATK,mob_DEF,mob_MDEF,mob_ACC,mob_EVA,mob_MEVA,mob_MACC,mob_MATT,mob_DT,mob_PDT,mob_MDT FROM `mob_stats` WHERE mob_stats.mob_id = {{{mobID}}} is invalid (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Template:MobID}' at line 1
Function: EDConnectorRdbms::fetch
Query: SELECT REPLACE(mob_name,'_',' '),mob_lvl,mob_max_hp,mob_max_mp,mob_STR,mob_DEX,mob_VIT,mob_AGI,mob_INT,mob_MND,mob_CHR,mob_Regen,mob_Haste,mob_ATK,mob_DEF,mob_MDEF,mob_ACC,mob_EVA,mob_MEVA,mob_MACC,mob_MATT,mob_DT,mob_PDT,mob_MDT FROM `mob_stats` WHERE mob_stats.mob_id = {{{mobID}}}
).
| Stats | ||||||
| Level | Max HP | Max MP | ||||
|---|---|---|---|---|---|---|
| STR | DEX | VIT | AGI | INT | MND | CHR |
| ATK | ACC | DEF | EVA | |||
| MATK | MACC1 | MDEF | MEVA2 | |||
| DT | PDT | MDT | Regen | Haste | ||
| Notes | ||||||
| 1. Varies from listed values based on dINT. | ||||||
| 2. Varies from listed values based on level difference, including item level. | ||||||