Flower Page

Revision as of 10:16, 6 December 2020

Template:Flower Page/docThis template defines the table "Flowers". View table.

@@ Line 4: / Line 4: @@
 -->{{#cargo_declare:
 _table=Flowers
+|Type=String
 |Name=Wikitext
+|Image=String
 |CatalogCategory=String
+|Event=String
 |Seed=String
-|Type=String
 |SellsFor=Wikitext
 |Rarity=String
@@ Line 15: / Line 17: @@
 -->{{#cargo_store:
 _table=Flowers
+|Type={{{type|Flowers}}}
 |Name=[[{{PAGENAME}}|{{{name|{{PAGENAME}}}}}]]
+|Image={{{image|{{PAGENAME}}}}}
+|CatalogCategory={{{catalogCategory|}}}
+|Event={{{event|}}}
 |Seed={{{seed|}}}
-|Type={{{type|Flowers}}}
 |SellsFor={{{sellsFor|}}}
 |Rarity={{{rarity|}}}
 }}<!--
+-->{{EntitiesStore|name={{{name|{{PAGENAME}}}}}|type={{{type|Flowers}}}|catalogCategory={{{catalogCategory|}}}|image={{{image|}}} }}<!--
 -->{{Flower Infobox
-|name={{{name|{{PAGENAME}}}}}
 |type={{{type|Flowers}}}
+|name={{{name|{{PAGENAME}}}}}
-|catalogCategory={{{catalogCategory|}}}
 |image={{{image|}}}
+|catalogCategory={{{catalogCategory|}}}
 |sellsFor={{{sellsFor|}}}
 |rarity={{{rarity|}}}
@@ Line 32: / Line 39: @@
 =How to Obtain=
-Obtained via planting [[File:{{{seed|}}}.png|30px|link={{{seed|}}}]] [[{{{seed|}}}]] and harvesting after {{sthc|{{#cargo_query:tables=Seeds|fields=Duration|where=_pageName="{{{seed|}}}"|group by=_pageName|no html}}}}.
+Obtained via planting [[File:{{#cargo_query:tables=Seeds|where=_pageName="{{{seed|}}}"|fields=Image|no html}}.png|30px|link={{{seed|}}}]] [[{{{seed|}}}]] and harvesting after {{sthc|{{#cargo_query:tables=Seeds|fields=Duration|where=_pageName="{{{seed|}}}"|group by=_pageName|no html}}}}.
 =Lloid Trade-in Rewards=
@@ Line 38: / Line 45: @@
 {{#cargo_query:
 tables=Furniture
-|fields=CONCAT('[[File:Furniture ', _pageName, '.png|60px|link=', _pageName, ']]<br/>[[', _pageName, ']]')=Name,CONCAT('[[File:', Theme, ' Banner.png|144px|link=]]<div style="display:none;">', Theme, '</div>')=Theme,CatalogCategory=Catalog Category,Size,MaterialCost=Material Cost,CONCAT (NumBells, '{{ItemText|Bells}}')=Bell Cost,CONCAT (SellingPrice, '{{ItemText|Bells}}')=Sell Price
+|fields=CONCAT('[[File:', Image, '.png|60px|link=', _pageName, ']]<br/>[[', _pageName, ']]')=Name,CONCAT('[[File:', Theme, ' Banner.png|144px|link=]]<div style="display:none;">', Theme, '</div>')=Theme,CatalogCategory=Catalog Category,Size,MaterialCost=Material Cost,CONCAT (NumBells, '{{ItemText|Bells}}')=Bell Cost,CONCAT (SellingPrice, '{{ItemText|Bells}}')=Sell Price
-|where=Furniture.MaterialCost LIKE "%{{PAGENAME}}%"
+|where=Furniture.Obtain LIKE "%{{PAGENAME}} %" AND Obtain NOT LIKE "%-{{PAGENAME}}%" OR mat1="{{PAGENAME}}"
 |format=table
 |group by=_pageName
@@ Line 49: / Line 56: @@
 {{#cargo_query:
 tables=Clothing
-|fields=CONCAT('[[File:', _pageName, '.png|60px|link=', _pageName, ']]<br/>[[', _pageName, ']]')=Name,CONCAT('[[File:', Theme, ' Banner.png|144px|link=]]<div style="display:none;">', Theme, '</div>')=Theme,CatalogCategory=Catalog Category,MaterialCost=Material Cost,Obtain,CONCAT (SellingPrice, '{{ItemText|Bells}}')=Sell Price
+|fields=CONCAT('[[File:', Image, '.png|60px|link=', _pageName, ']]<br/>[[', _pageName, ']]')=Name,CONCAT('[[File:', Theme, ' Banner.png|144px|link=]]<div style="display:none;">', Theme, '</div>')=Theme,CatalogCategory=Catalog Category,MaterialCost=Material Cost,Obtain,SellingPrice=Sell Price
-|where=Clothing.Obtain LIKE "%{{PAGENAME}}%"
+|where=Clothing.Obtain LIKE "%{{PAGENAME}}%" AND Obtain NOT LIKE "%-{{PAGENAME}}%"
 |format=table
 |group by=_pageName
@@ Line 57: / Line 64: @@
 }}
+{{Item Navbox}}[[Category:Catalog {{{catalogCategory|}}}]]{{#switch:{{{type|Flowers}}}
+|Flowers=[[Category:Flowers]]
-{{Item Navbox}}{{#switch:{{{type|Flowers}}}
-|Flowers=[[Category:Flowers]][[Category:Catalog Other - Flowers]]
+|Event Flowers = [[Category:Event Flowers]]
-|Event Flowers = [[Category:Event Flowers]][[Category:Catalog Uncategorized]]
 }}</includeonly>