Template:Skills Navbox: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
(Update format to remove nested navbox)
mNo edit summary
Line 4: Line 4:
| listclass  = hlist
| listclass  = hlist
| state      = {{{state|auto}}}
| state      = {{{state|auto}}}
| titlestyle = background:rgba(6,28,23,0.9); font-family:Source Code Pro;
| titlestyle = background:rgba(6,28,28,0.9); font-family:Source Code Pro;
| groupstyle = background:rgba(6,28,23,0.8); font-family:Source Code Pro; white-space:normal;
| groupstyle = font-family:Source Code Pro; white-space:normal;
| innerstyle = font-family:Source Code Pro;
| innerstyle = font-family:Source Code Pro;


Line 78: Line 78:
   | list11 = <span style="display:inline-block">{{#cargo_query:table=Skills|fields=_pageName=Skill|where=Class HOLDS 'Wayfaring' AND _pageName <> 'Wayfaring' AND RequiredStats HOLDS NOT ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
   | list11 = <span style="display:inline-block">{{#cargo_query:table=Skills|fields=_pageName=Skill|where=Class HOLDS 'Wayfaring' AND _pageName <> 'Wayfaring' AND RequiredStats HOLDS NOT ''|format=list|order by=RequiredStats, Cost ASC|group by=_pageName|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
}}
}}
}}<noinclude>[[Category:Navigation]]
}}<noinclude>[[Category:Navigation]]</noinlude>

Revision as of 19:10, 28 February 2021

v · d · eSkills and Powers
Weapon Skills
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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Axe') AND _pageName <> 'Axe' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Bow and Rifle') AND _pageName <> 'Bow and Rifle' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Cudgel') AND _pageName <> 'Cudgel' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Heavy Weapon') AND _pageName <> 'Heavy Weapon' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Long Blade') AND _pageName <> 'Long Blade' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Pistol') AND _pageName <> 'Pistol' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Shield') AND _pageName <> 'Shield' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Short Blade') AND _pageName <> 'Short Blade' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

Other Skills
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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Acrobatics') AND _pageName <> 'Acrobatics' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Cooking and Gathering') AND _pageName <> 'Cooking and Gathering' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Customs and Folklore') AND _pageName <> 'Customs and Folklore' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Dual Wield') AND _pageName <> 'Dual Wield' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Endurance') AND _pageName <> 'Endurance' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'First Aid') AND _pageName <> 'First Aid' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Persuasion') AND _pageName <> 'Persuasion' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Self-discipline') AND _pageName <> 'Self-discipline' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Tactics') AND _pageName <> 'Tactics' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Tinkering') AND _pageName <> 'Tinkering' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

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 'NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost...' at line 1 (localhost)

Function: CargoSQLQuery::run Query: SELECT `_pageName` AS `Skill` FROM `Skills` WHERE `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__Class` WHERE `_value`= 'Wayfaring') AND _pageName <> 'Wayfaring' AND `Skills`.`_ID` IN (SELECT `_rowID` FROM `Skills__RequiredStats` WHERE `_value`= NOT ) GROUP BY `_pageName` ORDER BY `Skills`.`RequiredStats__full` ,`Cost` LIMIT 100

</noinlude>

Retrieved from "https://wiki.cavesofqud.com/index.php?title=Template:Skills_Navbox&oldid=42173"