Binding of Isaac: Rebirth Wiki
Binding of Isaac: Rebirth Wiki
m
m ("unique on" test)
Line 1: Line 1:
 
<onlyinclude><includeonly>{{#invoke: cargo | query
 
<onlyinclude><includeonly>{{#invoke: cargo | query
| tables = collectible
+
| tables = collectible = c, collectible_name = n, collectible_image = i
  +
| join on = c.name = n.collectible, c.name = i.collectible
| fields = name, {{#if: {{{force|}}} | '{{#invoke: dlc | parse | {{{force}}} }}' = }} dlc
 
| where = {{#if: {{{where|}}} | {{{where}}}{{#lstmap: {{{1|}}} | , | @@@@ | \_OR name = "@@@@" }} | {{#lstmap: {{{1|}}} | , | @@@@ | name = "@@@@" | \_OR\_ }} }}
+
| fields = c._pageName = page, {{#if: {{{force|}}} | '{{#invoke: dlc | parse | {{{force}}} }}' | c.dlc }} = dlc, c.name = internal_name, n.name = name, image, id, quote, is_activated, description
  +
| where = {{#if: {{{where|}}} | {{{where}}}{{#lstmap: {{{1|}}} | , | @@@@ | \_OR c.name = "@@@@" }} | {{#lstmap: {{{1|}}} | , | @@@@ | c.name = "@@@@" | \_OR\_ }} }}
| order by = dlc DESC, name
 
| limit = {{#or: {{{limit|}}} | 800 }}
+
| order by = c.dlc DESC, c.name, n.dlc & {{context}} DESC, i.dlc & {{context}} DESC
  +
| limit = {{#or: {{{limit|}}} | 800 }}
| template = collectible rows/query
 
  +
| unique on = internal_name
 
| template = collectible row/query
 
}}</includeonly></onlyinclude>
 
}}</includeonly></onlyinclude>
 
{{doc}}
 
{{doc}}

Revision as of 18:45, 24 June 2020

Template-info.png Documentation

Usage

{{collectible rows | 1 | 2 | where = | order by = | limit = }} or {{collectible rows | 1 | where = | order by = | limit = | force = }}

Description

Returns multiple table rows of collectibles.

Template parameters

ParameterDescriptionTypeStatus
Names1

The names of the collectibles in the database, separated with commas.

Example
The Sad Onion, The Inner Eye
Stringsuggested
Wherewhere

Corresponds to the WHERE clause.

Example
is_activated = 1
Stringsuggested
Order byorder by

Corresponds to the ORDER BY clause.

Default
dlc DESC, alias
Example
id
Stringoptional
Limitlimit

Corresponds to the LIMIT clause

Example
10
Numberoptional
DLC constraintforce 2

Replaces the DLC of the collectibles with a more restricted DLC.

Example
a
Stringoptional