User:Teamtoto/Sandbox: Difference between revisions

← Older edit

User:Teamtoto/Sandbox (view source)

Revision as of 23:01, 30 July 2023

440 bytes added , 23:01, 30 July 2023

m

no edit summary

Teamtoto

Bureaucrats, Interface administrators, Suppressors, Administrators

8,756

edits

@@ Line 1: / Line 1: @@
-<pre>{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories=PDC|fields=GD._pageName|join on=GD._pageName=CF._pageName,PDC._rowID=PD._ID,PD._pageName=GD._pageName|where=CF.Faction="Barathrumites" AND PDC._value <>"Unique_Characters"}}</pre>
+{{#invoke:Sandbox/User:Teamtoto/LuaModule|test}}
-{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories=PDC|fields=GD._pageName|join on=CF._pageName=GD._pageName,PDC._rowID=PD._ID,PD._pageName=GD._pageName|where=CF.Faction="Barathrumites" AND PDC._value <>"Unique_Characters"}}
+<!--{{Teamtoto/EncounterTable|roll=each
+|{{EncounterTable/Row|weight=95|table=Artifact 0C}}
+|{{EncounterTable/Row|weight=5|table=Artifact 0R}}
-{{#cargo_query:tables=GeneralData=GD,CreatureFactions=CF,_pageData=PD,_pageData___categories|fields=GD._pageName,PD._categories__full|join on=GD._pageName=CF._pageName,GD._pageName=PD._pageName, _pageData___categories._rowID=PD._ID|where=CF.Faction="Barathrumites"}}
+}}
+{{#invoke:CargoQuery| main
+| tables = GeneralData=GD, Characters = C, CreatureFactions = CF
+| join = C.ObjectID = GD.ObjectID, C.ObjectID = CF.ObjectID
+| where = C.Demeanor = "aggressive" AND (C._pageNamespace= '0' OR C._pageNamespace = '10002')
+|group by = GD.ObjectID
+| fields = {{favilink format args}}
+| default = {{Template Error|Creature level and faction}}
+| one_to_many= CONCAT(' ([[', CF.Faction, ']])')=outro, C.ObjectID
+| one_to_many_group=C.ObjectID
+| one_to_many_sep=,
+| template = favilink format
+| format = ul
+| columns = 2
+}}
+{{#invoke:CargoQuery|main
+| tables=GeneralData=GD, _pageData=PD
+| join= GD._pageName=PD._pageName
+| fields={{favilink format args}}
+| where=PD._categories HOLDS "Liquid_Containers" AND GD._pageNamespace = "0"
+| template=favilink format
+| format = ul
+| columns = 2
+}}
+{{#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
+}}-->