5e:Class: Difference between revisions
| Line 14: | Line 14: | ||
tables=5e_Class, Pages_Info | tables=5e_Class, Pages_Info | ||
|join on=5e_Class.Page_Name=Pages_Info.Page_Name | |join on=5e_Class.Page_Name=Pages_Info.Page_Name | ||
|fields=CONCAT( '[[', 5e_Class.Page_Name, '|', 5e_Class.Class_Name, ']]' )=Class,5e_Class.Hit_Die,5e_Class.Prerequisites=Prereq,5e_Class.Class_Features,5e_Class. | |fields=CONCAT( '[[', 5e_Class.Page_Name, '|', 5e_Class.Class_Name, ']]' )=Class,5e_Class.Hit_Die,5e_Class.Prerequisites=Prereq,5e_Class.Class_Features,5e_Class.Class_Summary,5e_Class.Canon_Class=Canon, Pages_Info.Sources | ||
|where=(5e_Class.Hidden='0' OR 5e_Class.Hidden IS NULL) | |where=(5e_Class.Hidden='0' OR 5e_Class.Hidden IS NULL) | ||
|order by=5e_Class.Sort_Text | |order by=5e_Class.Sort_Text | ||
Revision as of 21:58, 21 February 2020
See Class (disambiguation)
Classes
18 Classes
Function: CargoSQLQuery::run Query: SELECT `rly2_cargo__Pages_Info`.`_pageID` AS `cargo_backlink_page_id_Pages_Info`,`rly2_cargo__5e_Class`.`_pageID` AS `cargo_backlink_page_id_5e_Class`,CONCAT( '', `rly2_cargo__5e_Class`.`Class_Name`, '' ) AS `Class`,`rly2_cargo__5e_Class`.`Hit_Die` AS `Hit Die`,`Prerequisites__full` AS `Prereq`,`Class_Features__full` AS `Class Features`,`rly2_cargo__5e_Class`.`Class_Summary` AS `Class Summary`,`rly2_cargo__5e_Class`.`Canon_Class` AS `Canon`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Class` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Class`.`Page_Name`=`rly2_cargo__Pages_Info`.`Page_Name`)) WHERE (`rly2_cargo__5e_Class`.`Hidden`='0' OR `rly2_cargo__5e_Class`.`Hidden` IS NULL) ORDER BY `rly2_cargo__5e_Class`.`Sort_Text` LIMIT 100
Multiclassing
see: Multiclassing [1]