5e:Height and Weight: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
{{ | <noinclude> | ||
<!--{{#cargo_declare: | |||
_table = 5e_Height_Weight | |||
|Species = String | |||
|Base_Height = String | |||
|BH_Inches = Integer | |||
|Base_Weight = String | |||
|BW_Pounds = Integer | |||
|Height_Mod = String | |||
|H_Mod = Integer | |||
|H_Mod_Die = Integer | |||
|Weight_Mod = String | |||
|W_Mod = Integer | |||
|W_Mod_Die = Integer | |||
|Avg_HW = String | |||
|Avg_H = Integer | |||
|Avg_W = Integer | |||
}}--> | |||
</noinclude> | |||
<div class="grid-container-std"> | |||
<div class="bctop">{{backto|{{5ed|Race}}}}</div> | |||
<div class="notice"></div> | |||
<div class="badge">{{5evaried}}</div> | |||
<div class="gi-main"> | |||
{{#cargo_query: | |||
tables=5e_Height_Weight, Pages_Info | |||
|join on=5e_Height_Weight._pageName=Pages_Info._pageName | |||
|where=(Pages_Info.Hidden=0 OR Pages_Info.Hidden IS NULL) | |||
|fields=CONCAT( '[[', 5e_Height_Weight._pageName, '|', 5e_Height_Weight.Species, ']]' )=Species,5e_Height_Weight.Base_Height,5e_Height_Weight.Base_Weight,5e_Height_Weight.Height_Mod,5e_Height_Weight.Weight_Mod,Avg_HW=Average | |||
|order by=5e_Height_Weight.Species | |||
|format=table | |||
}} | |||
</div><!--gi-main--> | |||
<div class="source"> | |||
==Sources and Notes== | |||
''See individual entry'' | |||
<references /> | |||
{{5e Footer|Race|Varied}} | |||
</div><!--source--> | |||
</div><!--grid-container-std--> | |||
Revision as of 19:53, 28 June 2020
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Height_Weight`.`_pageID` AS `cargo_backlink_page_id_5e_Height_Weight`,CONCAT( '', `rly2_cargo__5e_Height_Weight`.`Species`, '' ) AS `Species`,`rly2_cargo__5e_Height_Weight`.`Base_Height` AS `Base Height`,`rly2_cargo__5e_Height_Weight`.`Base_Weight` AS `Base Weight`,`rly2_cargo__5e_Height_Weight`.`Height_Mod` AS `Height Mod`,`rly2_cargo__5e_Height_Weight`.`Weight_Mod` AS `Weight Mod`,`Avg_HW` AS `Average` FROM `rly2_cargo__5e_Height_Weight` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Height_Weight`.`_pageName`=`rly2_cargo__Pages_Info`.`_pageName`)) WHERE (`rly2_cargo__Pages_Info`.`Hidden`=0 OR `rly2_cargo__Pages_Info`.`Hidden` IS NULL) ORDER BY `rly2_cargo__5e_Height_Weight`.`Species` LIMIT 100