Template:Mob Stats: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 4: | Line 4: | ||
|where=mob_stats.mob_id = {{{mobID}}} | |where=mob_stats.mob_id = {{{mobID}}} | ||
|data= | |data= | ||
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" style="text-align:center;" | ||
|+ Stats | |+ {{#for_external_table:| | ||
{{!}}- | |||
{{!}} {{{mobName}}} | |||
}} 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 | ||
Revision as of 21:05, 8 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 |