Template:UniquePassiveSkillsWizard: Difference between revisions

From Wizardia Community Wiki

Content added Content deleted
mNo edit summary
mNo edit summary
Tag: Reverted
Line 7: Line 7:
|join on=UniquePassiveSkills.SkillFor=Wizards.Link
|join on=UniquePassiveSkills.SkillFor=Wizards.Link
|fields=CONCAT(Wizards.Link)=Link,Wizards.Name_full,UniquePassiveSkills.Description
|fields=CONCAT(Wizards.Link)=Link,Wizards.Name_full,UniquePassiveSkills.Description
|where=UniquePassiveSkills.SkillFor='{{{wizardlink}}}' AND Wizards.Rarity='Rare'
|where={{ifeq:{{{wizardlink}}}|||UniquePassiveSkills.SkillFor='{{{wizardlink}}}' AND }}Wizards.Rarity='Rare'
|order by=UniquePassiveSkills.Name ASC
|order by=UniquePassiveSkills.Name ASC
|format=template
|format=template

Revision as of 09:33, 14 August 2023

List of Unique Passive Skills available for {{{shortname}}}:

Wizard Description
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 '{ifeq:{{{wizardlink}}}|||`cargo__UniquePassiveSkills`.`SkillFor`='{{{wizardli...' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__Wizards`.`_pageID` AS `cargo_backlink_page_id_Wizards`,`cargo__UniquePassiveSkills`.`_pageID` AS `cargo_backlink_page_id_UniquePassiveSkills`,CONCAT(`cargo__Wizards`.`Link`) AS `Link`,`cargo__Wizards`.`Name_full` AS `Name full`,`cargo__UniquePassiveSkills`.`Description` AS `Description` FROM `cargo__UniquePassiveSkills` LEFT OUTER JOIN `cargo__Wizards` ON ((`cargo__UniquePassiveSkills`.`SkillFor`=`cargo__Wizards`.`Link`)) WHERE {{ifeq:{{{wizardlink}}}|||`cargo__UniquePassiveSkills`.`SkillFor`='{{{wizardlink}}}' AND }}`cargo__Wizards`.`Rarity`='Rare' ORDER BY `cargo__UniquePassiveSkills`.`Name` LIMIT 100

Cookies help us deliver our services. By using our services, you agree to our use of cookies.