Template:Mob Stats: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 6: | Line 6: | ||
mobName=REPLACE(mob_name,'_',' '), Lvl = mob_lvl, HP = mob_max_hp, MP = mob_max_mp, STR = mob_STR, DEX = mob_DEX, VIT = mob_VIT, AGI = mob_AGI, INT = mob_INT, MND = mob_MND, CHR = mob_CHR, Regen = mob_Regen, Haste = mob_Haste, ATK = mob_ATK, DEF = mob_DEF, MDEF = mob_MDEF, ACC = mob_ACC, EVA = mob_EVA, MEVA = mob_MEVA, MACC = mob_MACC, MATK = mob_MATT, DT = mob_DT, PDT = mob_PDT, MDT = mob_MDT | mobName=REPLACE(mob_name,'_',' '), Lvl = mob_lvl, HP = mob_max_hp, MP = mob_max_mp, STR = mob_STR, DEX = mob_DEX, VIT = mob_VIT, AGI = mob_AGI, INT = mob_INT, MND = mob_MND, CHR = mob_CHR, Regen = mob_Regen, Haste = mob_Haste, ATK = mob_ATK, DEF = mob_DEF, MDEF = mob_MDEF, ACC = mob_ACC, EVA = mob_EVA, MEVA = mob_MEVA, MACC = mob_MACC, MATK = mob_MATT, DT = mob_DT, PDT = mob_PDT, MDT = mob_MDT | ||
}} | }} | ||
{| class="wikitable" style="text-align:center;" | {| class="wikitable mw-collapsible mw-collapsed R-Highlight" style="text-align:center;" width="560px;" | ||
|+ {{#for_external_table:|{{{mobName}}}}} Stats | |+ {{#for_external_table:|{{{mobName}}}}} Stats | ||
|- | |- | ||
Revision as of 01:41, 9 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}}} ).
| Level | Max HP | Max MP | ||||
|---|---|---|---|---|---|---|
| STR | DEX | VIT | AGI | INT | MND | CHR |
| ATK | ACC | DEF | EVA | |||
| MATK | MACC | MDEF | MEVA | |||
| DT | PDT | MDT | Regen | Haste |