User:Toancaro/Cleric/Template:ExtraSpellTable: Difference between revisions
< User:Toancaro | Cleric
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly> | <includeonly> | ||
{{# | {{#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 06: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