Template:5e Spell Data: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
tables=5e_Spell,Pages_Info | tables=5e_Spell,Pages_Info | ||
|join on=5e_Spell._pageName=Pages_Info._pageName | |join on=5e_Spell._pageName=Pages_Info._pageName | ||
|where=5e_Spell.Spell_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}' | |where=5e_Spell.Spell_Name='{{#if: {{{1|}}}|{{{1}}}|{{PAGENAME}} }}' AND ({{#if: {{{hid|}}}|Pages_Info.Pointer=0 or Pages_Info.Pointer IS NULL|Pages_Info.Hidden=0 or Pages_Info.Hidden IS NULL|}}) | ||
|fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )=Spell,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters, 5e_Spell.Canon_Spell=Canon,Pages_Info.Sources | |fields=CONCAT( '[[', 5e_Spell._pageName, '|', 5e_Spell.Spell_Name, ']]' )=Spell,5e_Spell.Level,5e_Spell.School,5e_Spell.Action_Type=Casting,5e_Spell.Spell_Range=Range,5e_Spell.Component=VSM,5e_Spell.Valuable_Component=VC,5e_Spell.Consumable_Component=CC,5e_Spell.Casters, 5e_Spell.Canon_Spell=Canon,Pages_Info.Sources | ||
|order by=5e_Spell.Sort_Text | |order by=5e_Spell.Sort_Text | ||
| Line 17: | Line 17: | ||
'''Note:''' For spell names with an apostrophe ('), you must double the apostrophe (<nowiki>''</nowiki>). | '''Note:''' For spell names with an apostrophe ('), you must double the apostrophe (<nowiki>''</nowiki>). | ||
===Add'l Entries=== | |||
<pre>|hid= <!--blank or true--></pre> | |||
{{5e Spell Data}} | {{5e Spell Data}} | ||
Revision as of 17:33, 3 October 2020
Syntax
{{5e Spell Data|optSpellName}}
Note: For spell names with an apostrophe ('), you must double the apostrophe ('').
Add'l Entries
|hid= <!--blank or true-->
Spell data:
Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)
Spell data:
Cannot access the database: :real_connect(): (HY000/1226): User 'a1618b_wiki5' has exceeded the 'max_user_connections' resource (current value: 10)