Difference between revisions of "Template:Main Page/Critters"

From Nookipedia, the Animal Crossing wiki
(creating template; imported from Dorsal Axe's design)
 
(converting to separate cargo tables to avoid duplicate argument errors)
Line 1: Line 1:
 
<div align=center style="position: relative; margin: 0 auto; font-size:14px; border-radius:20px; padding: 0.1em 1em; vertical-align:top; text-align:center; {{roundy|12px}}; justify-content: center;"><font face="Coustard" size=2>New in the Northern Hemisphere [[File:Northern Hemisphere icon.png|15px]]</font></div>
 
<div align=center style="position: relative; margin: 0 auto; font-size:14px; border-radius:20px; padding: 0.1em 1em; vertical-align:top; text-align:center; {{roundy|12px}}; justify-content: center;"><font face="Coustard" size=2>New in the Northern Hemisphere [[File:Northern Hemisphere icon.png|15px]]</font></div>
  
<div style="display: grid; grid-template-columns: repeat(auto-fill, 40px); grid-gap: 0.2em; margin: auto; justify-content: center; align-items: center; margin: 7px;">{{#if:{{#cargo_compound_query:
+
<div style="display: grid; grid-template-columns: repeat(auto-fill, 40px); grid-gap: 0.2em; margin: auto; justify-content: center; align-items: center; margin: 7px;">{{#if:{{#cargo_query:
tables=nh_fish;
+
|table=nh_fish
group by=name;
+
|group by=name
fields=_pageName=pagename,name,CONCAT('fish')=color,image;
+
|fields=_pageName=pagename,name,CONCAT('fish')=color,image
order by=number;
+
|order by=number
where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
+
|where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
|tables=nh_bug;
 
group by=name;
 
fields=_pageName=pagename,name,CONCAT('bugs')=color,image;
 
order by=number;
 
where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 
|tables=nh_sea_creature;
 
group by=name;
 
fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image;
 
order by=number;
 
where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
 
 
|format=template
 
|format=template
 
|template=Main Page/CritterDisplay
 
|template=Main Page/CritterDisplay
 
|named args=yes
 
|named args=yes
|limit=600
+
|limit=80
}}|{{#cargo_compound_query:
+
}}
tables=nh_fish;
+
{{#cargo_query:
group by=name;
+
|table=nh_bug
fields=_pageName=pagename,name,CONCAT('fish')=color,image;
+
|group by=name
order by=number;
+
|fields=_pageName=pagename,name,CONCAT('bugs')=color,image
where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
+
|order by=number
|tables=nh_bug;
+
|where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
group by=name;
 
fields=_pageName=pagename,name,CONCAT('bugs')=color,image;
 
order by=number;
 
where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 
|tables=nh_sea_creature;
 
group by=name;
 
fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image;
 
order by=number;
 
where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
 
 
|format=template
 
|format=template
 
|template=Main Page/CritterDisplay
 
|template=Main Page/CritterDisplay
 
|named args=yes
 
|named args=yes
|limit=600
+
|limit=80
 +
}}
 +
{{#cargo_query:
 +
|table=nh_sea_creature
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image
 +
|order by=number
 +
|where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=40
 +
}}
 +
|{{#cargo_query:
 +
|table=nh_fish
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('fish')=color,image
 +
|order by=number
 +
|where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=80
 +
}}
 +
{{#cargo_query:
 +
|table=nh_bug
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('bugs')=color,image
 +
|order by=number
 +
|where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=80
 +
}}
 +
{{#cargo_query:
 +
|table=nh_sea_creature
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image
 +
|order by=number
 +
|where=n_m{{{month|{{CURRENTMONTH1}}}}}=1 AND n_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=40
 
}}</div>|</div>
 
}}</div>|</div>
 
:''No new critters this month!''}}
 
:''No new critters this month!''}}
Line 46: Line 71:
 
<div align=center style="position: relative; margin: 0 auto; font-size:14px; border-radius:20px; padding:0.1em 1em;  vertical-align:top; text-align:center; {{roundy|12px}};"><font face="Coustard" size=2>New in the Southern Hemisphere [[File:Southern Hemisphere icon.png|15px]]</font></div>
 
<div align=center style="position: relative; margin: 0 auto; font-size:14px; border-radius:20px; padding:0.1em 1em;  vertical-align:top; text-align:center; {{roundy|12px}};"><font face="Coustard" size=2>New in the Southern Hemisphere [[File:Southern Hemisphere icon.png|15px]]</font></div>
  
<div style="display: grid; grid-template-columns: repeat(auto-fill, 40px); margin: auto; justify-content: center; align-items: center; grid-gap: 0.2em; margin: 7px;">{{#if:{{#cargo_compound_query:
+
<div style="display: grid; grid-template-columns: repeat(auto-fill, 40px); margin: auto; justify-content: center; align-items: center; grid-gap: 0.2em; margin: 7px;">{{#if:
tables=nh_fish;
+
{{#cargo_query:
group by=name;
+
|table=nh_fish
fields=_pageName=pagename,name,CONCAT('fish')=color,image;
+
|group by=name
order by=number;
+
|fields=_pageName=pagename,name,CONCAT('fish')=color,image
where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
+
|order by=number
|tables=nh_bug;
+
|where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
group by=name;
+
|format=template
fields=_pageName=pagename,name,CONCAT('bugs')=color,image;
+
|template=Main Page/CritterDisplay
order by=number;
+
|named args=yes
where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
+
|limit=80
|tables=nh_sea_creature;
+
}}
group by=name;
+
{{#cargo_query:
fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image;
+
|table=nh_bug
order by=number;
+
|group by=name
where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
+
|fields=_pageName=pagename,name,CONCAT('bugs')=color,image
 +
|order by=number
 +
|where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=80
 +
}}
 +
{{#cargo_query:
 +
|table=nh_sea_creature
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image
 +
|order by=number
 +
|where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=40
 +
}}|{{#cargo_query:
 +
|table=nh_fish
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('fish')=color,image
 +
|order by=number
 +
|where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 +
|format=template
 +
|template=Main Page/CritterDisplay
 +
|named args=yes
 +
|limit=80
 +
}}
 +
{{#cargo_query:
 +
|table=nh_bug
 +
|group by=name
 +
|fields=_pageName=pagename,name,CONCAT('bugs')=color,image
 +
|order by=number
 +
|where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 
|format=template
 
|format=template
 
|template=Main Page/CritterDisplay
 
|template=Main Page/CritterDisplay
 
|named args=yes
 
|named args=yes
|limit=600
+
|limit=80
}}|{{#cargo_compound_query:
+
}}
tables=nh_fish;
+
{{#cargo_query:
group by=name;
+
|table=nh_sea_creature
fields=_pageName=pagename,name,CONCAT('fish')=color,image;
+
|group by=name
order by=number;
+
|fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image
where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
+
|order by=number
|tables=nh_bug;
+
|where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
group by=name;
 
fields=_pageName=pagename,name,CONCAT('bugs')=color,image;
 
order by=number;
 
where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0
 
|tables=nh_sea_creature;
 
group by=name;
 
fields=_pageName=pagename,name,CONCAT('sea creatures')=color,image;
 
order by=number;
 
where=s_m{{{month|{{CURRENTMONTH1}}}}}=1 AND s_m{{#ifexpr:{{{month|{{CURRENTMONTH1}}}}}-1<=0|{{#expr:({{{month|{{CURRENTMONTH1}}}}}+12)-1}}|{{#expr:{{{month|{{CURRENTMONTH1}}}}}-1}}}}=0;
 
 
|format=template
 
|format=template
 
|template=Main Page/CritterDisplay
 
|template=Main Page/CritterDisplay
 
|named args=yes
 
|named args=yes
|limit=600
+
|limit=40
 
}}</div>|</div>
 
}}</div>|</div>
 
:''No new critters this month!''}}
 
:''No new critters this month!''}}

Revision as of 22:03, May 31, 2022

New in the Northern Hemisphere Northern Hemisphere icon.png
Giant snakehead
Tilapia
Piranha
Arowana
Dorado
Gar
Arapaima
Saddled bichir
Ribbon eel
Saw shark
Hammerhead shark
Great white shark
Whale shark
Suckerfish
emperor butterfly
firefly
drone beetle
Goliath Beetle
Rainbow Stag
mosquito
sea grapes
mussel
abalone
gazami crab
tiger prawn
New in the Southern Hemisphere Southern Hemisphere icon.png
Pond smelt
Stringfish
Sea butterfly
Squid
Oarfish
emperor butterfly
Rajah Brooke's birdwing
dung beetle
lobster