|
|
| (72 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| {{#invoke:CargoQuery| main |q?tables=CreatureFactions,GeneralData|q?join=CreatureFactions._pageName=GeneralData._pageName|q?fields=CONCAT(CreatureFactions._pageName)=Page|q?where=Faction="{{{1|Crabs}}}" AND CreatureFactions._pageNamespace ='0'|q?orderBy=CreatureFactions._pageName|q?groupBy=CreatureFactions._pageName|format=template|template=favilink|delimiter= - </span><span style="display:inline-block">}} | | {{#invoke:Sandbox/User:Teamtoto/LuaModule|test}} |
| {{Navbox
| | <!--{{Teamtoto/EncounterTable|roll=each |
| | name = Creature Navbox
| | |{{EncounterTable/Row|weight=95|table=Artifact 0C}} |
| | title = Creatures in the {{{1|}}} Faction
| | |{{EncounterTable/Row|weight=5|table=Artifact 0R}} |
| | listclass = hlist
| |
| | state = {{{state|collapsed}}}
| |
| | titlestyle = background:rgba(6,28,23,0.9); font-family:Source Code Pro;
| |
| | groupstyle = background:rgba(6,28,23,0.8); font-family:Source Code Pro;
| |
| | innerstyle = font-family:Source Code Pro;
| |
| | |
| | group1style = background:rgba(6,28,23,0.2);
| |
| | |
| | list1 =<span style="display:inline-block">{{#invoke:CargoQuery| main |q?tables=GeneralData,CreatureFactions,_pageData
| |
| |q?join=_pageData._pageName=GeneralData._pageName,GeneralData._pageName=CreatureFactions._pageName
| |
| |q?fields=PlainName=Page
| |
| |q?where=Faction="{{{1|Barathrumites}}}" AND CreatureFactions._pageNamespace ='0' AND _isRedirect = '0' | |
| |q?orderBy=CreatureFactions._pageName | |
| |template=single query result
| |
| |delimiter= - </span><span style="display:inline-block">}}</span>
| |
| | |
| | list2=<span style="display:inline-block">{{#invoke:CargoQuery| main | |
| |q?tables=CreatureFactions,GeneralData,_pageData
| |
| |q?join=CreatureFactions._pageName=GeneralData._pageName, CreatureFactions._pageName=_pageData._pageName
| |
| |q?fields=GeneralData.PlainName=Page | |
| |q?where=Faction='Barathrumites' AND _pageData._pageNamespace ='0' AND _pageData._categories__full LIKE '%Unique Characters%' AND _isRedirect = '0'
| |
| |template=favilink
| |
| |delimiter= - </span><span style="display:inline-block">}}</span>
| |
| }} | | }} |
| | | {{#invoke:CargoQuery| main |
| | | | tables = GeneralData=GD, Characters = C, CreatureFactions = CF |
| {{Navbox | | | join = C.ObjectID = GD.ObjectID, C.ObjectID = CF.ObjectID |
| | name = Food Navbox | | | where = C.Demeanor = "aggressive" AND (C._pageNamespace= '0' OR C._pageNamespace = '10002') |
| | title = List of [[Food]] | | |group by = GD.ObjectID |
| | listclass = hlist
| | | fields = {{favilink format args}} |
| | state = {{{state|collapsed}}}
| | | default = {{Template Error|Creature level and faction}} |
| | titlestyle = background:rgba(6,28,23,0.9); font-family:Source Code Pro;
| | | one_to_many= CONCAT(' ([[', CF.Faction, ']])')=outro, C.ObjectID |
| | groupstyle = background:rgba(6,28,23,0.8); font-family:Source Code Pro;
| | | one_to_many_group=C.ObjectID |
| | navbar = plain
| | | one_to_many_sep=, |
| | innerstyle = font-family:Source Code Pro; | | | template = favilink format |
| | | | format = ul |
| | group2style = background:rgba(6,28,23,0.2);
| | | columns = 2 |
| | group2 =Meat
| |
| | list2 =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains LIKE "%Meat%" | |
| |format=list|delimiter= - </span><span style="display:inline-block">}}</span> | |
| | |
| | group3style = background:rgba(6,28,23,0.2);
| |
| | group3 =Plant
| |
| | list3 =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains LIKE "%Plant%"
| |
| |format=list|delimiter= - </span><span style="display:inline-block">}}</span> | |
| | |
| | group4style = background:rgba(6,28,23,0.2); | |
| | group4 =Fungi
| |
| | list4 =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains LIKE "%Fungi%"
| |
| |format=list|delimiter= - </span><span style="display:inline-block">}}</span> | |
| | |
| | group5style = background:rgba(6,28,23,0.2); | |
| | group5 =Etc | |
| | list5 =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains='none' | |
| |format=list|delimiter= - </span><span style="display:inline-block">}}</span> | |
| }} | | }} |
| | {{#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 |
| | }}--> |
