SELECT pix.pid,pix.galleryid,pix.description,pix.alttext,ref
FROM wp_ngg_pictures pix
INNER JOIN (
   SELECT cf.pid,group_concat(cf.field_value)AS ref
   FROM wp_nggcf_field_values cf
   GROUP BY cf.pid
   ) cfv ON pix.pid = cfv.pid
WHERE (
   pix.description LIKE '%currie%' OR 
   pix.alttext LIKE '%currie%' OR 
   ref LIKE '%currie%'
)
ORDER BY pix.galleryid ASC

Next up is to figure out how to create an on-the-fly gallery out of the results that looks and feels like the other galleries.

Original post blogged on b2evolution.

Original post blogged on b2evolution.

Original post blogged on b2evolution.

wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/nextgen_basic_gallery/templates/thumbnails/index.php

template, I changed the display of the thumbnail to include the source field by adding this:

<br/>Source: <?php echo nggcf_get_field($image->pid, "Source");

to the existing title attribute. I expect this will be transferable to other templates and fields.

Straightforward retrieval of CWGC info: if you know the CWGC id (in this case 922332 - Eric Bowen-Smith) of the soldier use
http://www.cwgc.org/find-war-dead/casualty-details.aspx?cid=922332

Not-so-straightforward retrieval of CWGC info, scraping soldier info from page:

curl --silent "http://www.cwgc.org/find-war-dead/casualty-details.aspx?cid=922332" | tr '\n\r' ' '|sed 's/  //g'| grep -o 'dottedBoxContent"><h2 class="redText">.*<div class="casualty_buttons">' | sed 's/dottedBoxContent">\(.*\)<div class="casualty_buttons">.*/\1/'

Which returns some HTML like:
<h2 class="redText">BOWEN-SMITH, ERIC</h2>
<dl>
<dt>Rank:</dt><dd>Private</dd>
<dt>Service No:</dt><dd>13152</dd>
<dt>Date of Death:</dt><dd>02/06/1916</dd>
<dt>Age:</dt><dd>23</dd>
<dt>Regiment/Service:</dt><dd>Canadian Infantry</dd>
<dt>&nbsp;</dt><dd>"D" Coy. 5th Bn.</dd>
<dt>Panel Reference</dt><dd>Panel 18 - 26 - 28.</dd>
<dt>Memorial</dt><dd><a href="/find-a-cemetery/cemetery/91800/YPRES (MENIN GATE) MEMORIAL">YPRES (MENIN GATE) MEMORIAL</a></dd>
</dl>
<h3>Additional Information:</h3>
<p>Son of Sidney C. and Jessie M. Bowen-Smith, of 2247, Albert St., Regina, Saskatchewan.</p>

which is totally digestible for inclusion in a report. It might be useful to use as a simple method for checking on a suspect record.

~~~~~~~~
Straightforward retrieval of LAC info: if you know the LAC id (in this case 236439) of the soldier use
http://www.collectionscanada.gc.ca/databases/cef/001042-119.01-e.php?&id_nbr=236439

Not-so-straightforward retrieval of attestation record images, creating two links (note that I'm using an actual LAC ID here - in this case 105755):

curl --silent "http://www.collectionscanada.gc.ca/databases/cef/001042-119.01-e.php?&id_nbr=236439" | grep -o 'image_url=.*\.gif' | sed 's/image_url=\(.*\)&.*">.*=\(.*\)/<a href="\1">First page<\/a> - <a href="\2">Second page<\/a>/'

Which returns something like:
First page - Second page

Some files have been digitized, and a PDF can retrieved by running this:

curl --silent "http://www.collectionscanada.gc.ca/databases/cef/001042-119.01-e.php?&id_nbr=236439" | grep -o 'href=.*\.pdf' | sed 's/href="\(.*\)">.*/\1/'

Which returns something like:
http://data2.collectionscanada.gc.ca/cef/9001-10000/9032-35.pdf

July 15-19: 30 hours (Short week because I had the Paint-In that weekend and required time off to do volunteer training).
July 22-26: 40 hours (with the city council meeting being a long day).
July 29-Aug 2: 37 hours (this is when I finished the microfilms).
Aug 5-9: 34 hours

Total: 141 hours or 8,460 minutes

Original post blogged on b2evolution.