User:Toancaro/Cleric/Template:ExtraSpellTable: Difference between revisions

From Baldur's Gate 3 Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
<includeonly>
<includeonly>
{{#vardefine: clericDomainSpells | Charm Person,Command,Divine Favour,Light,Poison Spray,Thunderwave,Aid,Animal Friendship,Barkskin,Beacon of Hope,Bestow Curse,Bless,Burning Hands,Call Lightning,Calm Emotions,Confusion,Crusader's Mantle,Cure Wounds,Daylight,Death Ward,Destructive Wave,Dimension Door,Disguise Self,Dominate Beast,Dominate Person,Faerie Fire,Fear,Fireball,Flame Strike,Flaming Sphere,Fog Cloud,Freedom of Movement,Grasping Vine,Greater Restoration,Guardian of Faith,Gust of Wind,Hold Monster,Hold Person,Ice Storm,Insect Plague,Lesser Restoration,Magic Weapon,Mass Cure Wounds,Mirror Image,Otiluke's Resilient Sphere,Pass Without Trace,Plant Growth,Polymorph,Produce Flame,Revivify,Scorching Ray,Seeming,Shatter,Shield of Faith,Shillelagh,Sleep,Sleet Storm,Slow,Speak with Animals,Speak with Dead,Spike Growth,Spirit Guardians,Spiritual Weapon,Stoneskin,Telekinesis,Thorn Whip,Wall of Fire,Wall of Stone}}
{{#arraydefine: clericDomainSpells | Charm Person,Command,Divine Favour,Light,Poison Spray,Thunderwave,Aid,Animal Friendship,Barkskin,Beacon of Hope,Bestow Curse,Bless,Burning Hands,Call Lightning,Calm Emotions,Confusion,Crusader's Mantle,Cure Wounds,Daylight,Death Ward,Destructive Wave,Dimension Door,Disguise Self,Dominate Beast,Dominate Person,Faerie Fire,Fear,Fireball,Flame Strike,Flaming Sphere,Fog Cloud,Freedom of Movement,Grasping Vine,Greater Restoration,Guardian of Faith,Gust of Wind,Hold Monster,Hold Person,Ice Storm,Insect Plague,Lesser Restoration,Magic Weapon,Mass Cure Wounds,Mirror Image,Otiluke's Resilient Sphere,Pass Without Trace,Plant Growth,Polymorph,Produce Flame,Revivify,Scorching Ray,Seeming,Shatter,Shield of Faith,Shillelagh,Sleep,Sleet Storm,Slow,Speak with Animals,Speak with Dead,Spike Growth,Spirit Guardians,Spiritual Weapon,Stoneskin,Telekinesis,Thorn Whip,Wall of Fire,Wall of Stone}}
{{#vardefine: query | {{#arrayprint: clericDomainSpells | OR | @ | _pageName = "@" }}}}
{{#vardefine: query | {{#arrayprint: clericDomainSpells | OR | @ | _pageName = "@" }}}}
{{#vardefine: spellNamesQuery | {{#replace:{{#var: query}} | OR | <nowiki/> <nowiki/>OR<nowiki/> <nowiki/>}}}}
{{#vardefine: spellNamesQuery | {{#replace:{{#var: query}} | OR | <nowiki/> <nowiki/>OR<nowiki/> <nowiki/>}}}}
Line 7: Line 7:
tables = spells
tables = spells
| fields=_pageName=spell,name,classes,description,spell_school,damage_type=damage
| fields=_pageName=spell,name,classes,description,spell_school,damage_type=damage
| where={{#if: {{{where|}}} | {{{where}}} AND {{#var: spellNamesQuery}} | {{#var: spellNamesQuery}} }}
| where={{#if: {{{where|}}} | ({{{where}}}) AND ({{#var: spellNamesQuery}}) | {{#var: spellNamesQuery}} }}
| intro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Header}}
| intro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Header}}
| outro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Footer}}
| outro={{User:Toancaro/Cleric/Template:ExtraSpellTable/Footer}}
Line 14: Line 14:
| named args=yes
| named args=yes
}}</includeonly><noinclude>
}}</includeonly><noinclude>
{{User:Toancaro/Cleric/Template:ExtraSpellTable}}
{{User:Toancaro/Cleric/Template:ExtraSpellTable
| where=spell_level="0"
}}
</noinclude>
</noinclude>

Revision as of 07:45, 6 January 2024




Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<strong class="error">Error: String exceeds 1,000 character limit.</strong>) ...' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__spells`.`_pageID` AS `cargo_backlink_page_id_spells`,`_pageName` AS `spell`,`name` AS `name`,`classes__full` AS `classes`,`description` AS `description`,`spell_school` AS `spell school`,`damage_type` AS `damage` FROM `cargo__spells` WHERE (spell_level="0") AND (<strong class="error">Error: String exceeds 1,000 character limit.</strong>) ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100

Retrieved from "https://bg3.wiki/w/index.php?title=User:Toancaro/Cleric/Template:ExtraSpellTable&oldid=140759"