Talk:Shadowstitch: Difference between revisions
Jump to navigation
Jump to search
>Neokowloon (Created page with "==corrupted implicit infobox== Anyone know how to write a query for the infobox parameter "implicit1_random_list" . I don't know how to use join or field when "spawn_weights.t...") |
>Neokowloon |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==corrupted implicit infobox== | ==corrupted implicit infobox== | ||
Anyone know how to write a query for the infobox parameter "implicit1_random_list" . I don't know how to use join or field when "spawn_weights.tag in ( 'armour ', 'body_armour')" is used. [[User:Neokowloon|Neokowloon]] ([[User talk:Neokowloon|talk]]) 09:10, 2 May 2020 (UTC) | Anyone know how to write a query for the infobox parameter "implicit1_random_list" . I don't know how to use join or field when "spawn_weights.tag in ( 'armour ', 'body_armour')" is used. [[User:Neokowloon|Neokowloon]] ([[User talk:Neokowloon|talk]]) 09:10, 2 May 2020 (UTC) | ||
:Something like this: | |||
<pre>{{#cargo_query: | |||
|tables=mods, spawn_weights | |||
|join on=mods._pageID=spawn_weights._pageID | |||
|fields=mods.id | |||
|where=mods.domain=1 AND mods.generation_type=5 AND spawn_weights.tag in ( 'armour ', 'body_armour') AND spawn_weights.weight > 0 | |||
|orderBy=mods.id ASC | |||
|no html | |||
|limit=300 | |||
}}</pre> | |||
:--[[User:Ruba159753|Ruba159753]] ([[User talk:Ruba159753|talk]]) 09:56, 2 May 2020 (UTC) | |||
::Thanks, will copy to this article and [[Hands of the High Templar]]. [[User:Neokowloon|Neokowloon]] ([[User talk:Neokowloon|talk]]) 10:03, 2 May 2020 (UTC) | |||
Latest revision as of 10:03, 2 May 2020
corrupted implicit infobox
Anyone know how to write a query for the infobox parameter "implicit1_random_list" . I don't know how to use join or field when "spawn_weights.tag in ( 'armour ', 'body_armour')" is used. Neokowloon (talk) 09:10, 2 May 2020 (UTC)
- Something like this:
{{#cargo_query:
|tables=mods, spawn_weights
|join on=mods._pageID=spawn_weights._pageID
|fields=mods.id
|where=mods.domain=1 AND mods.generation_type=5 AND spawn_weights.tag in ( 'armour ', 'body_armour') AND spawn_weights.weight > 0
|orderBy=mods.id ASC
|no html
|limit=300
}}
- --Ruba159753 (talk) 09:56, 2 May 2020 (UTC)
- Thanks, will copy to this article and Hands of the High Templar. Neokowloon (talk) 10:03, 2 May 2020 (UTC)