Template:ID to Character
Takes a pattern (yeah, misnomer, it's late and I'll fix it later) and returns most of a character infobox/namebox for that ID. Usage:
{{ID to Character|Jotun%}}
Output: Lua error: 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 'ORDER BY `GD`.`PlainName` LIMIT 100' at line 1 (localhost) Function: CargoSQLQuery::run Query: SELECT `C`.`Level` AS `lv`,`C`.`HP` AS `hp`,`C`.`AV` AS `av`,`C`.`DV` AS `dv`,`C`.`MA` AS `ma`,`C`.`MARange` AS `marange`,`C`.`Strength` AS `strength`,`C`.`StrengthMult` AS `strengthmult`,`C`.`Agility` AS `agility`,`C`.`AgilityMult` AS `agilitymult`,`C`.`Intelligence` AS `intelligence`,`C`.`IntelligenceMult` AS `intelligencemult`,`C`.`Willpower` AS `willpower`,`C`.`WillpowerMult` AS `willpowermult`,`C`.`Ego` AS `ego`,`C`.`EgoMult` AS `egomult`,`C`.`XPValue` AS `xpvalue`,`C`.`XPTier` AS `xptier`,`GD`.`Description` AS `desc`,`C`.`Corpse` AS `corpse`,`C`.`CorpseChance` AS `corpsechance`,`C`.`MoveSpeed` AS `movespeed`,`C`.`Demeanor` AS `demeanor`,`Skills__full` AS `skills`,`C`.`Quickness` AS `quickness`,`C`.`HarvestedInto` AS `harvestedinto`,`C`.`Role` AS `role`,`GD`.`DisplayName` AS `title`,`GD`.`Image` AS `image`,`GD`.`DisplayChar` AS `renderstr`,`GD`.`Weight` AS `weight`,`GD`.`Tier` AS `tier`,`GD`.`Categories` AS `categories`,`GD`.`ParentObject` AS `inheritingfrom`,`P`.`AcidResist` AS `acid`,`P`.`ElectricResist` AS `electric`,`P`.`ColdResist` AS `coldresist`,`P`.`HeatResist` AS `heat`,`P`.`LightRadius` AS `light`,`P`.`Seeping` AS `seeping`,`P`.`Inhaled` AS `inhaled`,`P`.`Volume` AS `maxvol`,`P`.`LiquidGenType` AS `liquidgentype`,`P`.`LiquidGenRate` AS `liquidgenrate` FROM `Characters` `C` LEFT OUTER JOIN `GeneralData` `GD` ON ((`C`.`JoinKey`=`GD`.`JoinKey`)) LEFT OUTER JOIN `PhysicalProperties` `P` ON ((`C`.`JoinKey`=`P`.`JoinKey`)) WHERE `GD`.`PlainName` LIKE Jotun% ORDER BY `GD`.`PlainName` LIMIT 100 .