5e:Class: Difference between revisions
mNo edit summary |
|||
Line 16: | Line 16: | ||
tables=5e_Class, Pages_Info | tables=5e_Class, Pages_Info | ||
|join on=5e_Class._pageName=Pages_Info._pageName | |join on=5e_Class._pageName=Pages_Info._pageName | ||
|fields=CONCAT( '[[', 5e_Class._pageName, '|', 5e_Class.Class_Name, ']]' )=Class,5e_Class.Hit_Die,5e_Class.Prerequisites=Prereq,5e_Class.Class_Features,5e_Class.Class_Summary, | |fields=CONCAT( '[[', 5e_Class._pageName, '|', 5e_Class.Class_Name, ']]' )=Class,5e_Class.Hit_Die,5e_Class.Prerequisites=Prereq,5e_Class.Class_Features,5e_Class.Class_Summary,Pages_Info.Canon=Canon, Pages_Info.Sources | ||
|where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) | |where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) | ||
|order by=5e_Class.Sort_Text | |order by=5e_Class.Sort_Text |
Revision as of 08:00, 13 March 2021
See Class (disambiguation)
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`,COUNT(`rly2_cargo__5e_Class`.`_pageName`) AS `_pageName)` FROM `rly2_cargo__5e_Class` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Class`.`_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__Pages_Info`.`_pageID`,`rly2_cargo__5e_Class`.`_pageID`,COUNT(`rly2_cargo__5e_Class`.`_pageName`) LIMIT 100
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__Pages_Info`.`Canon` AS `Canon`,`Sources__full` AS `Sources` FROM `rly2_cargo__5e_Class` LEFT OUTER JOIN `rly2_cargo__Pages_Info` ON ((`rly2_cargo__5e_Class`.`_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_Class`.`Sort_Text` LIMIT 100
Multiclassing
see: Multiclassing [1]
Sources and Notes
See above
- Wizards RPG Team. SRD-OGL v5.1 (5e 2014) (2015.05.06). Wizards of the Coast. ↑