5e:Sidekick: Difference between revisions
mNo edit summary |
|||
| Line 20: | Line 20: | ||
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 | |fields=CONCAT( '[[', 5e_Class._pageName, '|', 5e_Class.Class_Name, ']]' )=Class,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) AND 5e_Class.Sidekick=1 | |where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) AND 5e_Class.Sidekick=1 | ||
|order by=5e_Class.Sort_Text | |order by=5e_Class.Sort_Text | ||
Latest revision as of 21:38, 3 March 2021
A sidekick is a special type of NPC. They are creatures (CR 1/2 or lower) that have a sidekick class added to it.
A sidekick can be added as a member of the adventurer's party or someone they meet. A player may even use a sidekick class as their character's class. [1]
Sidekick 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) AND `rly2_cargo__5e_Class`.`Sidekick`=1 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`,`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) AND `rly2_cargo__5e_Class`.`Sidekick`=1 ORDER BY `rly2_cargo__5e_Class`.`Sort_Text` LIMIT 100
Sources and Notes
- Jeremy Crawford, et. al.. Tasha's Cauldron of Everything (5e 2014) (2020-11-17). Wizards of the Coast. ISBN 9780786967025. p. 142.
- Unofficial Description by user:Rlyehable. ↑