User:Egocarib/Sandbox: Difference between revisions
mNo edit summary |
mNo edit summary |
||
Line 6: | Line 6: | ||
<syntaxhighlight lang="html">{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND (ItemsTable.Extra HOLDS NOT LIKE 'Not Unequippable')|format=template|template=favilink ul query}}</syntaxhighlight> | <syntaxhighlight lang="html">{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND (ItemsTable.Extra HOLDS NOT LIKE 'Not Unequippable')|format=template|template=favilink ul query}}</syntaxhighlight> | ||
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND (ItemsTable.Extra HOLDS NOT LIKE 'Not Unequippable')|format=template|template=favilink ul query}} | {{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND (ItemsTable.Extra HOLDS NOT LIKE 'Not Unequippable')|format=template|template=favilink ul query}} | ||
<syntaxhighlight lang="html">{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND GeneralData.Image LIKE '%.png'|format=template|template=favilink ul query}}</syntaxhighlight> | |||
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND GeneralData.Image LIKE '%.png'|format=template|template=favilink ul query}} | |||
Revision as of 17:28, 1 September 2019
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND GeneralData.ParentObject <> 'NaturalWeapon'|format=template|template=favilink ul query}}
Template:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul query
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND (ItemsTable.Extra HOLDS NOT LIKE 'Not Unequippable')|format=template|template=favilink ul query}}
Function: CargoSQLQuery::run Query: SELECT `ItemsTable`.`_pageName` AS `_pageName` FROM `ItemsTable` LEFT OUTER JOIN `GeneralData` ON ((`ItemsTable`.`_pageName`=`GeneralData`.`_pageName`)) WHERE `ItemsTable`.`_pageNamespace`='0' AND `ItemsTable`.`Vibro`='1' AND (`ItemsTable`.`Extra` HOLDS NOT LIKE 'Not Unequippable') ORDER BY `ItemsTable`.`_pageName` LIMIT 100
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND GeneralData.Image LIKE '%.png'|format=template|template=favilink ul query}}
Template:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul query
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1'|format=template|template=favilink ul query}}
Template:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul query
/9 4 | |
Damage
|
2d122-24 (Avg: 13) |
Weight
|
1# |