Caves of Qud Wiki

User:Teamtoto/Sandbox: Difference between revisions

User:Teamtoto/Sandbox (view source)

Revision as of 23:01, 30 July 2023

645 bytes removed ,  23:01, 30 July 2023
m
no edit summary
mNo edit summary
mNo edit summary
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
<pre>
{{#invoke:Sandbox/User:Teamtoto/LuaModule|test}}
{{#invoke:CargoQuery| main
<!--{{Teamtoto/EncounterTable|roll=each
| tables=ItemsTable=IT,GeneralData=GD
|{{EncounterTable/Row|weight=95|table=Artifact 0C}}
| join on = IT.ObjectID = GD.ObjectID
|{{EncounterTable/Row|weight=5|table=Artifact 0R}}
| fields={{favilink format args}}
}}
| where= HarvestedInto= "vinewafer"
|template=favilink format
| delimiter = </br>
|default=None}}
</pre>
{{#invoke:CargoQuery| main
{{#invoke:CargoQuery| main
| tables=ItemsTable=IT,GeneralData=GD
| tables = GeneralData=GD, Characters = C, CreatureFactions = CF
| join on = IT.ObjectID = GD.ObjectID
| join = C.ObjectID = GD.ObjectID, C.ObjectID = CF.ObjectID
| fields={{favilink format args}}
| where = C.Demeanor = "aggressive" AND (C._pageNamespace= '0' OR C._pageNamespace = '10002')
| where= HarvestedInto= "vinewafer"
|group by = GD.ObjectID
|template=favilink format
| fields = {{favilink format args}}
| delimiter = </br>
| default = {{Template Error|Creature level and faction}}
|default=None}}
| one_to_many= CONCAT(' ([[', CF.Faction, ']])')=outro, C.ObjectID
 
| one_to_many_group=C.ObjectID
<Pre>{{#invoke:CargoQuery| compound
| one_to_many_sep=,
| 1=table=ItemsTable
; fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
|template=favilink id
| delimiter = </br>
|default=None}}</pre>
{{#invoke:CargoQuery| compound
| 1=table=ItemsTable
; fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
| 2 = table=Characters
;fields=ObjectID=Page
; where= HarvestedInto= "vinewafer"
|template=favilink id
| delimiter = </br>
|default=None}}
 
this one is broken:
<pre>
{{#invoke:CargoQuery| compound
| 1=tables=tables=ItemsTable=IT, GeneralData=GD
; join on = IT.ObjectID = GD.ObjectID
; fields= {{favilink format args}}
; where= HarvestedInto= "vinewafer"
| template = favilink format
| delimiter = </br>
|default=None}}
</pre>
{{#invoke:CargoQuery| compound
| 1=tables=tables=ItemsTable=IT, GeneralData=GD
; join = IT.ObjectID = GD.ObjectID
; fields= {{favilink format args}}
; where= HarvestedInto= "vinewafer"
| template = favilink format
| template = favilink format
| delimiter = </br>
| format = ul
|default=None}}
| columns = 2
<!--{{#invoke:cargo_query|main
| table=Factions=F
| fields = FLOOR(5)= mintier, FLOOR(7)= maxtier, F._pageName=faction
| template = possible cultists
| delimiter = </br>
|where = F.Old="1" AND IsVisible="1"
}}
}}
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
|table=Anatomies=A
| tables=GeneralData=GD, _pageData=PD
|fields=Name
| join= GD._pageName=PD._pageName
|one_to_many=Type
| fields={{favilink format args}}
|one_to_many_group=Name
| where=PD._categories HOLDS "Liquid_Containers" AND GD._pageNamespace = "0"
|one_to_many_sep=,&nbsp;
| template=favilink format
|format = table
| format = ul
| limit = 1000
| columns = 2
}}
}}
TODO: concat laterality and include child stuff, format it prettier?-->
{{#invoke:CargoQuery|main
| tables=GeneralData=GD, PhysicalProperties=PP
| join =GD.ObjectID= PP.JoinKey
| fields={{favilink format args}}
| where=PP.Volume > 0 AND GD._pageNamespace = "0"
| template=favilink format
| format = ul
| columns = 2
}}-->
Retrieved from "https://wiki.cavesofqud.com/wiki/Special:MobileDiff/33611...88272"