5e:Sidekick: Difference between revisions
mNo edit summary |
|||
| Line 13: | Line 13: | ||
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 | ||
|where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) | |where=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) AND 5e_Class.Sidekick=1 | ||
|fields=COUNT(5e_Class._pageName) | |fields=COUNT(5e_Class._pageName) | ||
}} Sidekick Classes (official and unofficial) | }} Sidekick Classes (official and unofficial) | ||
| Line 21: | Line 21: | ||
|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=(Pages_Info.Hidden='0' OR Pages_Info.Hidden IS NULL) | |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 | ||
}}</div> | }}</div> | ||
| Line 27: | Line 27: | ||
</div><!--gi-main--> | </div><!--gi-main--> | ||
<div class="source"> | <div class="source"> | ||
==Sources and Notes== | ==Sources and Notes== | ||
:* {{Cite Pub|Tasha's Cauldron of Everything|pages=142}} | :* {{Cite Pub|Tasha's Cauldron of Everything|pages=142}} | ||
Revision as of 16:37, 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`,`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) 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. ↑