Template:Mob Stats: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#get_db_data: | <!-- 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: | |||
db=MediaWiki | db=MediaWiki | ||
|from=mob_stats | |from=mob_stats | ||
| Line 7: | Line 15: | ||
}} | }} | ||
{| class="wikitable mw-collapsible mw-collapsed R-Highlight" style="text-align:center;" width="560px;" | {| class="wikitable mw-collapsible mw-collapsed R-Highlight" style="text-align:center;" width="560px;" | ||
| colspan="7" align="left" | '''{{#for_external_table:|{{{mobName}}}}} Stats'''   | | colspan="7" align="left" | '''{{#for_external_table:|{{{mobName}}}}} {{{altName|}}} Stats'''   | ||
|- | |- | ||
! style="width:80px;" | Level !! style="width:80px;" | Max HP !! style="width:80px;" | Max MP | ! style="width:80px;" | Level !! style="width:80px;" | Max HP !! style="width:80px;" | Max MP | ||
| Line 38: | Line 46: | ||
}} | }} | ||
|- | |- | ||
! MATK !! MACC | ! MATK !! MACC<sup>1</sup> !! MDEF !! MEVA<sup>2</sup> | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{!}}- | {{!}}- | ||
| Line 56: | Line 64: | ||
{{!}} {{{Haste}}} | {{!}} {{{Haste}}} | ||
}} | }} | ||
|- | |||
| colspan="7" align="left" | '''Notes''' | |||
|- | |||
| colspan="7" align="left" | 1. Values used in calculations vary from listed values based on dINT. | |||
|- | |||
| colspan="7" align="left" | 2. Values used in calculations vary from listed values based on level difference, including item level. | |||
|} | |} | ||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
Latest revision as of 15:30, 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. Values used in calculations vary from listed values based on dINT. | ||||||
| 2. Values used in calculations vary from listed values based on level difference, including item level. | ||||||