Situation: you need a heap of imagefields that more or less have the same setup. Let's not go into why.

You could spend half an hour bored witless clicking through the interface.

Or you could create just the one field, export the content type with content copy, and then doctor the code a little before importing it back in. Like this....

<?php
// The usual content type stuff here.
// Set of image fields
$image_fields = array(
'field_image_1' => 'Image 1',
'field_image_2' => 'Image 2',
// etc
);

foreach ($image_fields as $name => $label) {

Firstly, hello Planet Drupal (or Drupal Planet... or Drupal folks, generally). *waves*

This is my first post since http://www.drupaler.co.uk was added to the list over there, so hopefully at least some of you will find it useful/interesting/both. Thanks to Robert Douglass for the addition.

This is a quick HOWTO on altering the core Search module's database query in Drupal 5.x and 6.x. I think this will be different in 7.x, as there seem to be new, better hooks for manipulating queries, but we're not there yet.

For now, the hook you need is hook_db_rewrite_sql(). This allows you to add JOINs and WHERE clauses to existing SQL queries being generated by other Drupal modules.

Or at least, I think it is. My new module. I managed to release a dev snapshot last night which answers some of the bigger issues with it. There are already new features backing up to be implemented (and at least one already done) but, for now, CCK Gallery is hot to trot! =)

I've even created some half-decent documentation, in the form of an FAQ on the project page. Quick summary: