Template:Info for goat number

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(`Sex` —> `Gender`)
Line 30: Line 30:
<ul style="line-height:0.7">
<ul style="line-height:0.7">
{{#tag:mysqlinline|
{{#tag:mysqlinline|
-
SELECT CONCAT('<li><a href="/wiki/Dairy_production/', g.ID, '">', CONCAT(g.name, ' (', g.Breed, ' ', g.Sex, ')'), '</a></li>') AS `Name`
+
SELECT CONCAT('<li><a href="/wiki/Dairy_production/', g.ID, '">', CONCAT(g.name, ' (', g.Breed, ' ', g.Gender, ')'), '</a></li>') AS `Name`
FROM s_animals g
FROM s_animals g
WHERE g.Disposition = 'owned'
WHERE g.Disposition = 'owned'

Revision as of 05:52, 12 June 2019

Usage

This template is used to display various information for a goat.

It is typically placed on pages named like "Dairy production/5", in the following manner: {{info for goat number|{{SUBPAGENAME}}}}.

Parameters

  1. the ID number of the goat information to be displayed.

Example

as entered
{{info for goat number|15}}
as displayed

Statistics for goat #15, Nubian female: Taara

Dark brown with white star on forehead

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

Provenance

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

Kids

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

Production

by year

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

by month

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

First/Last by Year

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

Milker by year

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

Records

Due to pending litigation, EcoReality Co-op statistics are not available at this time.

EXPERIMENTAL STUFF

The extension MySQL needs to be turned into a parser function first, so that gender-specific statistics can be presented in a reasonable way. (We don't really want to know how much milk we got out of a buck, for example.)

Sex of this animal is: {{#mysqlinline:SELECT Sex FROM s_animals WHERE ID=15|database=EcoReality}} .

The sex of this animal is not defined.

The sex of this animal is undefined.

See also

See Also

Template

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro