5e:Class: Difference between revisions
No edit summary |
|||
| Line 7: | Line 7: | ||
==Classes== | ==Classes== | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=5e_Class, Pages_Info | |||
|where=(Hidden= | |join on=5e_Class._pageName=Pages_Info._pageName | ||
|fields=COUNT(_pageName) | |where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) | ||
|fields=COUNT(5e_Class._pageName) | |||
}} Classes (official and unofficial) | }} Classes (official and unofficial) | ||
<div style="overflow:auto; font-size:0.75em;"> | <div style="overflow:auto; font-size:0.75em;"> | ||
| Line 16: | Line 17: | ||
|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,5e_Class.Canon_Class=Canon, Pages_Info.Sources | |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,5e_Class.Canon_Class=Canon, Pages_Info.Sources | ||
|where=( | |where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) | ||
|order by=5e_Class.Sort_Text | |order by=5e_Class.Sort_Text | ||
}}</div> | }}</div> | ||
==Multiclassing== | ==Multiclassing== | ||
''see: [[SRD5:Multiclassing|Multiclassing]] <ref name="srd5">{{Cite Pub|SRD-OGL v5.1}}</ref>'' | ''see: [[SRD5:Multiclassing|Multiclassing]] <ref name="srd5">{{Cite Pub|SRD-OGL v5.1}}</ref>'' | ||
Revision as of 21:38, 12 February 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__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`.`_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. ↑