User:Findar: Difference between revisions
No edit summary |
No edit summary |
||
Line 11: | Line 11: | ||
}} | }} | ||
</pre> | </pre> | ||
<pre> | |||
{{Query unique items | {{Query unique items | ||
|tables=items | |tables=items | ||
|where=items.rarity_id="unique" AND items.drop_enabled!="False" | |where=items.rarity_id="unique" AND items.drop_enabled!="False" | ||
|q_limit=600 | |q_limit=600 | ||
|no_html | |||
| no html | |||
}} | |||
</pre> | |||
{{Item table | |||
|q_tables=item_stats | |||
|q_join=items._pageID=item_stats._pageID | |||
|q_where=item_stats.rarity_id="unique" AND item_stats.drop_enabled!="False" | |||
|base_item=1 | |base_item=1 | ||
|drop_level=1 | |drop_level=1 | ||
|no_html | |no_html | ||
}} | }} | ||
Revision as of 20:01, 10 October 2023
Test Page
{{#cargo_query: tables=items |where = items.rarity_id="unique" AND items.drop_enabled!="False" |group by=items.base_item |format=table |fields=items.name,items.base_item, items.drop_level | no html |limit=25 }}
{{Query unique items |tables=items |where=items.rarity_id="unique" AND items.drop_enabled!="False" |q_limit=600 |no_html | no html }}
Lua error: Error 1054: Unknown column 'cargo__item_stats.rarity_id' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`base_item` AS `items.base_item`,`cargo__items`.`base_item_page` AS `items.base_item_page`,`cargo__items`.`drop_level` AS `items.drop_level` FROM `cargo__items` LEFT OUTER JOIN `cargo__item_stats` ON ((`cargo__items`.`_pageID`=`cargo__item_stats`.`_pageID`)) WHERE (`cargo__item_stats`.`rarity_id`="unique" AND `cargo__item_stats`.`drop_enabled`!="False") AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`_pageID`,`cargo__items`.`_pageName`,`cargo__items`.`name`,`cargo__items`.`inventory_icon`,`cargo__items`.`html` LIMIT 5000 .
{{Item table |q_tables=item_stats |q_join=items._pageID=item_stats._pageID |q_where=items.rarity_id="unique" |large=1 }}
yuvuyu
{{#cargo_query: tables=items |where = items.rarity_id="unique" |group by=items.base_item |format=table |fields=items.name,items.base_item | no html |limit=25 }}
items._pageID=maps._pageID, maps.area_id=areas.id,
{{#cargo_query: tables=items |where = items.class_id="DivinationCard" |group by=items.name |format=table |fields=items.name,items.drop_areas |limit=25 }}
{{#cargo_query: tables=items, maps |join on=items._pageName=maps._pageName |where = items.class_id="Map" AND items.rarity_id!="unique" |group by = items.name |format=table |fields=items.name, maps.area_id | no html }}
{{#cargo_query: tables=items=divCards,items=mapItems, maps |where = mapItems.class_id="Map" AND mapItems.rarity_id!="unique" |join on=mapItems._pageName=maps._pageName, divCards.drop_areas HOLDS maps.area_id |format=table |fields=mapItems.name, divCards.name, maps.area_id |limit=25 | no html }}