User:Findar: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
(16 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Test Page | Test Page | ||
==testbed== | |||
{{Item table | |||
|q_where=items.rarity_id="unique" AND items.drop_enabled!="False" | |||
|q_limit=2000 | |||
|q_group_by=items.base_item | |||
|base_item=1 | |||
|drop_level=1 | |||
|no_html=1 | |||
}} | |||
==old stuff== | |||
<pre> | <pre> | ||
{{#cargo_query: | {{#cargo_query: | ||
Line 11: | Line 26: | ||
}} | }} | ||
</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= | |q_limit=800 | ||
| | |no_html | ||
| | | no html | ||
}} | }} | ||
</pre> | |||
<pre> | <pre> |
Latest revision as of 20:10, 10 October 2023
Test Page
testbed
old stuff
{{#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=800 |no_html | no html }}
{{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 }}