modules/recipe/recipe.module

<?php
// $Id: recipe.module,v 1.84 2009/06/26 12:18:11 marble Exp $

/**
 * @file
 * recipe.module - share recipes
 * for drupal 5.x
 *
 * Updated to drupal 6.x by shadow
 *
 * @todo
 */

/**
 * Implementation of hook_perm().
 */
function recipe_perm() {
  return array(t('create recipes'), t('edit own recipes'));
}

/**
 * Implementation of hook_load().
 */
function recipe_load($node) {
  $recipe = db_fetch_object(db_query('SELECT * FROM {recipe} WHERE nid = %d', $node->nid));
  $recipe->ingredients = recipe_load_ingredients($node);
  return $recipe;
}

/**
 * Implementation of hook_link().
 */
function recipe_link($type, $node = NULL, $teaser = FALSE) {
  $links = array();

  if ($type == 'node' && $node->type == 'recipe') {
    if (!$teaser) {
      if (variable_get('recipe_export_recipeml_enable', 1) == 1) {
        $links['recipe_recipeml'] = array(
          'title' => t('Export to RecipeML'),
          'href' => "recipe/export/recipeml/$node->nid",
          'attributes' => array('title' => t('Export this recipe to RecipeML.')),
        );
      }
      if (variable_get('recipe_export_html_enable', 1) == 1) {
        $links['recipe_html'] = array(
          'title' => t('Printer-friendly version'),
          'href' => "recipe/export/html/$node->nid",
          'attributes' => array('title' => t('Show a printer-friendly version of this recipe.')),
        );
      }
    }
  }

  return $links;
}

/**
 * Implementation of hook_node_info(). This function replaces hook_node_name()
 * and hook_node_types() from 4.6.
 */
function recipe_node_info() {
  return array(
    'recipe' => array(
      'name' => t('Recipe'),
      'module' => 'recipe',
      'description' => t("Share your favorite recipes with your fellow cooks."),
    )
  );
}

/**
 * Implementation of hook_help().
 */
function recipe_help($path, $arg) {
  switch ($path) {
    case 'node/add/recipe':
      return variable_get("recipe_help", "");
  }
}

/**
 * Implementation of hook_insert().
 *
 * As a new node is being inserted into the database, we need to do our own
 * database inserts.
 */
function recipe_insert($node) {
  db_query("INSERT INTO {recipe} (nid, source, yield, notes, instructions, preptime) VALUES (%d, '%s', '%s', '%s', '%s', '%d')", $node->nid, $node->source, $node->yield, $node->notes, $node->instructions, $node->preptime);
  recipe_save_ingredients($node);
}

/**
 * Implementation of hook_update().
 *
 * As an existing node is being updated in the database, we need to do our own
 * database updates.
 */
function recipe_update($node) {
  db_query("UPDATE {recipe} SET source = '%s', yield = '%s', notes = '%s', instructions = '%s', preptime = '%d' WHERE nid = %d", $node->source, $node->yield, $node->notes, $node->instructions, $node->preptime, $node->nid);
  recipe_save_ingredients($node);
}

/**
 * Implementation of hook_delete().
 *
 * When a node is deleted, we need to clean up related tables.
 */
function recipe_delete($node) {
  db_query("DELETE FROM {recipe} WHERE nid = %d", $node->nid);
  db_query("DELETE FROM {recipe_node_ingredient} WHERE nid = %d", $node->nid);
}

/**
* Implementation of hook_form().
*/
function recipe_form(&$node,$form_state) {
  // drupal 4.7 requires the title field to be defined by the custom node's module
  $form['title'] = array('#type' => 'textfield', '#title' => t('Title'),
    '#size' => 60, '#maxlength' => 128, '#required' => TRUE,
    '#default_value' => $node->title);

  // Now we define the form elements specific to our node type.
  $form['body'] = array(
    '#type' => 'textarea',
    '#title' => t('Description'),
    '#default_value' => $node->body,
    '#cols' => 60,
    '#rows' => 2,
    '#description' => t('A short description or "teaser" for the recipe.'),
    '#required' => TRUE,
  );
  $form['yield'] = array(
    '#type' => 'textfield',
    '#title' => t('Yield'),
    '#default_value' => $node->yield,
    '#size' => 10,
    '#maxlength' => 10,
    '#description' => t('The number of servings the recipe will make.'),
    '#attributes' => NULL,
    '#required' => TRUE,
  );
  $form['preptime'] = array(
    '#type' => 'select',
    '#title' => t("Preparation time"),
    '#default_value' => $node->preptime,
    '#options' => array(5 => t('5 minutes'), 10 => t('10 minutes'), 15 => t('15 minutes'), 20 => t('20 minutes'), 30 => t('30 minutes'), 45 => t('45 minutes'), 60 => t('1 hour'), 90 => t('1 1/2 hours'), 120 => t('2 hours'), 150 => t('2 1/2 hours'), 180 => t('3 hours'), 210 => t('3 1/2 hours'), 240 => t('4 hours'), 300 => t('5 hours'), 360 => t('6 hours')),
    '#description' => t("How long does this recipe take to prepare (i.e. elapsed time)"),
  );
  $form["source"] = array(
    '#type' => 'textfield',
    '#title' => t("Source"),
    '#default_value' => $node->source,
    '#size' => 60,
    '#maxlength' => 127,
    '#description' => t("Optional. Does anyone else deserve credit for this recipe?"),
  );

  // Table of existing ingredients
  $form['ingredients']['#tree'] = TRUE;
  $system = variable_get('recipe_ingredient_system', 'complex');
  if ($system == 'complex') {
    $form['ingredients']['headings'] = array(
      '#value' => '<div><table ><thead><tr><th>'. t('Quantity') .'</th><th>'.
                  t('Units') .'</th><th>'. t('Ingredient Name') .
                  '</th></tr></thead>'."\n".'<tbody>',
    );
  }
  else {
    $form['ingredients']['headings'] = array(
      '#value' => '<div><table ><thead><tr><th>'. t('Ingredients') .'</th></tr></thead>'."\n".'<tbody>',
    );
  }
  $rows = array();
  $callback = 'recipe/ingredient/autocomplete';
  $num_ingredients = 0;
  if ($node->ingredients) {
    foreach ($node->ingredients as $id => $ingredient) {
      $num_ingredients = $id+1;
      if ($id == 0) {
        $j = '0';
      } else {
        $j = $id;
      }
     
      // For preview, node->ingredients is an array, for actual display, it's an object
      $name = '';
      $unit_id = '';
      $abbreviation = '';
      $quantity = 0;
      if (is_array($ingredient)) {
        $name = $ingredient['name'];
        $unit_id = $ingredient['unit_id'];
        $abbreviation = $ingredient['abbreviation'];
        $quantity = $ingredient['quantity'];
      } else {
        $name = $ingredient->name;
        $unit_id = $ingredient->unit_id;
        $abbreviation = $ingredient->abbreviation;
        $quantity = $ingredient->quantity;
      }     

      if ($name && isset($quantity)) {
        // When can the following statement be true?
        if (!$ingredient) {
          drupal_set_message(t('Recipe Module: An error has occured.  Please report this error to the system administrator.'), 'error');
          if (is_array($ingredient)) {
            $ingredient['quantity'] = '';
            $ingredient['unit_id'] = 21;
            $ingredient['name'] = '';
          } else {
            $ingredient->quantity = '';
            $ingredient->unit_id = 21;
            $ingredient->name = '';
          }
        }
        if ($system == 'complex') {
          $form['ingredients'][$j]['open_tags'] = array(
            '#value' => '<tr><th>',
          );
          $form['ingredients'][$j]['quantity'] = array(
            '#type' => 'textfield',
            '#title' => '',
            '#default_value' => preg_replace('/\&frasl;/', '/', recipe_ingredient_quantity_from_decimal($quantity)),
            '#size' => 8,
            '#maxlength' => 8,
          );
          $form['ingredients'][$j]['mid1_tags'] = array(
            '#value' => '</th><th>',
          );
          $form['ingredients'][$j]['unit_id'] = array(
            '#type' => 'select',
            '#title' => '',
            '#default_value' => $unit_id,
            '#options' => recipe_unit_options(),
          );
          $form['ingredients'][$j]['mid2_tags'] = array(
            '#value' => '</th><th>',
          );
          $form['ingredients'][$j]['name'] = array(
            '#type' => 'textfield',
            '#title' => '',
            '#default_value' => $name,
            '#size' => 64,
            '#maxlength' => 128,
            '#autocomplete_path' => $callback,
          );
          $form['ingredients'][$j]['close_tags'] = array(
            '#value' => '</th></tr>',
          );
        }
        else {
          if ($name) {
            if ($quantity == 0) {
              $quantity = '';
            }
            else {
              $quantity .= ' ';
            }
            if ($abbreviation != '') {
              $abbreviation .= ' ';
            }
            $name = $quantity . $abbreviation . $name;
          }
          $form['ingredients'][$j]['open_tags'] = array(
            '#value' => '<tr><th>',
            '#tree' => TRUE,
          );
          $form['ingredients'][$j]['name'] = array(
            '#type' => 'textfield',
            '#title' => '',
            '#default_value' => $name,
            '#size' => 64,
            '#maxlength' => 128,
            '#autocomplete_path' => $callback,
          );
          $form['ingredients'][$j]['close_tags'] = array(
            '#value' => '</th></tr>',
          );
        } // else
      } // if ($ingredient->name && isset($ingredient->quantity))
    } // foreach ($node->ingredients as $id => $ingredient)
  } // if ($node->ingredients)
  // Add ten more spots for ingredients than are already used
  for ($i = $num_ingredients; $i < $num_ingredients+10; $i++) {
    if ($i == 0) {
      $j = '0';
    }
    else {
      $j = $i;
    }
    if ($system == 'complex') {
      $form['ingredients'][$j]['open_tags'] = array(
        '#value' => '<tr><th>',
      );
      $form['ingredients'][$j]['quantity'] = array(
        '#type' => 'textfield',
        '#title' => '',
        '#size' => 8,
        '#maxlength' => 8,
      );
      $form['ingredients'][$j]['mid1_tags'] = array(
        '#value' => '</th><th>',
      );
      $form['ingredients'][$j]['unit_id'] = array(
        '#type' => 'select',
        '#title' => '',
        '#options' => recipe_unit_options(),
        '#default_value' => 2,
      );
      $form['ingredients'][$j]['mid2_tags'] = array(
        '#value' => '</th><th>',
      );
      $form['ingredients'][$j]['name'] = array(
        '#type' => 'textfield',
        '#title' => '',
        '#size' => 64,
        '#maxlength' => 128,
        '#autocomplete_path' => $callback,
      );
      $form['ingredients'][$j]['close_tags'] = array(
        '#value' => '</th></tr>',
      );
    }
    else {
      $form['ingredients'][$j]['open_tags'] = array(
        '#value' => '<tr><th>',
      );
      $form['ingredients'][$j]['name'] = array(
        '#type' => 'textfield',
        '#title' => '',
        '#size' => 64,
        '#maxlength' => 128,
        '#autocomplete_path' => $callback,
      );
      $form['ingredients'][$j]['close_tags'] = array(
        '#value' => '</th></tr>',
      );
    }
  }
  $form['ingredients']['end'] = array(
    '#value' => '</tbody>'."\n".'</table></div>'."\n",
  );

  $form['instructions'] = array(
    '#type' => 'textarea',
    '#title' => t('Instructions'),
    '#default_value' => $node->instructions,
    '#cols' => 60,
    '#rows' => 10,
    '#description' => t('Step by step instructions on how to prepare and cook the recipe.'),
  );
  $form['notes'] = array(
    '#type' => 'textarea',
    '#title' => t("Additional Notes"),
    '#default_value' => $node->notes,
    '#cols' => 60,
    '#rows' => 5,
    '#description' => t("Optional. Describe a great dining experience relating to this recipe, or note which wine or other dishes complement this recipe"),
  );
  $form['filter'] = filter_form($node->format);

  return $form;
}

/**
 * Settings form for menu callback
 */
function recipe_admin_settings() {
  $form['recipe_index_depth'] = array(
    '#type' => 'select',
    '#title' => t('Index Depth'),
    '#default_value' => variable_get('recipe_index_depth', 0),
    '#options' => array(0 => t('All Terms'), 1 => "1", 2 => "2", 3 => "3", 4 => "4", 5 => "5", 6 => "6"),
    '#description' => t("Defines how many levels of terms should be displayed on any given recipe index page. For example, if you select 1 then only one level of the Recipe index tree will be displayed at a time."),
  );
  $form['recipe_recent_box_enable'] = array(
    '#type' => 'radios',
    '#title' => t('Recent Recipes Box'),
    '#default_value' => variable_get('recipe_recent_box_enable', 1),
    '#options' => array(t('Disabled'), t('Enabled')),
    '#description' => t('Enables or Disables the recent recipes box on the recipes index page.'),
    '#required' => false,
  );
  $form['recipe_recent_box_title'] = array(
    '#type' => 'textfield',
    '#title' => t('Box Title'),
    '#default_value' => variable_get('recipe_recent_box_title', t('Latest Recipes')),
    '#size' => 35,
    '#maxlength' => 255,
    '#description' => t('Title of the Recent Recipes Box on the Recipes index page.'),
  );
  $form['recipe_recent_display'] = array(
    '#type' => 'select',
    '#title' => t('Recipes to Display'),
    '#default_value' => variable_get('recipe_recent_display', '5'),
    '#options' => array(5 => "5", 10 => "10", 15 => "15"),
    '#description' => t("Sets the number of recent recipes that will be displayed in the Recent Recipes box. (0 = not displayed)."),
  );
  $form['recipe_help'] = array(
    '#type' => 'textarea',
    '#title' => t('Explanation or submission guidelines'),
    '#default_value' => variable_get('recipe_help', ''),
    '#cols' => 55,
    '#rows' => 4,
    '#description' => t('This text will be displayed at the top of the recipe submission form.  Useful for helping or instructing your users.'),
  );
  $options = array('simple' => t('Simple'), 'complex' => t('Complex'));
  $form['recipe_ingredient_system'] = array(
    '#type' => 'radios',
    '#title' => t('Ingredient entering system'),
    '#default_value' => variable_get('recipe_ingredient_system', 'complex'),
    '#options' => $options,
    '#description' => t('The simple ingredient system allows all ingredients to be entered on one line.  The complex system forces the user to seperate the quanity and units from the ingredient'),
  );
  $form['recipe_fraction_display'] = array(
    '#type' => 'textfield',
    '#title' => t('Fractions Display String'),
    '#default_value' => variable_get('recipe_fraction_display', t('{%d }%d&frasl;%d')),
    '#size' => 35,
    '#maxlength' => 255,
    '#description' => t('How fractions should be displayed.  Leave blank to display as decimals.  Each incidence of %d will be replaced by the whole number, the numerator, and the denominator in that order.  Anything between curly braces will not be displayed when the whole number is equal to 0.  Recommended settings are "{%d }%d&amp;frasl;%d" or "{%d }&lt;sup&gt;%d&lt;/sup&gt;/&lt;sub&gt;%d&lt;/sub&gt;"'),
  );
  $form['recipe_export_html_enable'] = array(
    '#type' => 'radios',
    '#title' => t('Export HTML'),
    '#default_value' => variable_get('recipe_export_html_enable', 1),
    '#options' => array(t('Disabled'), t('Enabled')),
    '#description' => t('Enables or Disables the Export as HTML link.'),
    '#required' => false,
  );
  $form['recipe_export_recipeml_enable'] = array(
    '#type' => 'radios',
    '#title' => t('Export RecipeML'),
    '#default_value' => variable_get('recipe_export_recipeml_enable', 1),
    '#options' => array(t('Disabled'), t('Enabled')),
    '#description' => t('Enables or Disables the Export as RecipeML link.'),
    '#required' => false,
  );
  return system_settings_form($form);
}

/**
 * Implementation of hook_menu().
 *
 * Note: when editing this function you must visit 'admin/menu' to reset the cache
 */
function recipe_menu() {
  $items = array();
    $items['recipe'] = array(
      'title' => t('Recipes'),
      'page callback' => 'recipe_page',
      'access arguments' => array('access content'),
      'type' => MENU_SUGGESTED_ITEM
    );
    $items['recipe/ingredient/autocomplete'] = array(
      'title' => t('Ingredient autocomplete'),
      'page callback' => 'recipe_autocomplete_page',
      'type' => MENU_CALLBACK,
      'access arguments' => array('access content')
    );
    $items['recipe/export'] = array(
      'page callback' => 'recipe_export',
      'type'  => MENU_CALLBACK,
      'access arguments' => array('access content')
    );
    $items['admin/settings/recipe'] = array(
      'title' => t('Recipe module'),
      'description' => t('Settings that control how the recipe module functions.'),
      'page callback' => 'drupal_get_form',
      'page arguments' => array('recipe_admin_settings'),
      'access arguments' => array('administer site configuration'),
      'type' => MENU_NORMAL_ITEM,
    );
  return $items;
}

/**
 * Implementation of hook_access().
 */
function recipe_access($op, $node, $account) {
  global $user;

  if ($op == 'create') {
    // Only users with permission to do so may create this node type.
    return user_access('create recipes');
  }

  // Users who create a node may edit or delete it later, assuming they have the
  // necessary permissions.
  if ($op == 'update' || $op == 'delete') {
    if (user_access('edit own recipes') && ($user->uid == $node->uid)) {
      return TRUE;
    }
  }
}

/**
 * Implementation of hook_block().
 */
function recipe_block($op = 'list', $delta = 0, $edit = array()) {
  // The $op parameter determines what piece of information is being requested.
  switch ($op) {
    case 'list':
      // If $op is "list", we just need to return a list of block descriptions.
      // This is used to provide a list of possible blocks to the administrator,
      // end users will not see these descriptions.
      $blocks[0]['info'] = t('Newest recipes');
      return $blocks;
    case 'view':
      // If $op is "view", then we need to generate the block for display
      // purposes. The $delta parameter tells us which block is being requested.
      switch ($delta) {
        case 0:
          // The subject is displayed at the top of the block. Note that it
          // should be passed through t() for translation.
          $block['subject'] = t('Newest Recipes');
          // The content of the block is typically generated by calling a custom
          // function.
          $result = db_query_range(db_rewrite_sql("SELECT n.nid, n.title, n.uid, u.name FROM {node} n INNER JOIN {node_revisions} r ON n.vid = r.vid INNER JOIN {users} u ON n.uid = u.uid WHERE n.type='recipe' AND n.status =1 ORDER BY n.created DESC"), 0, 5);
          $block["content"] = node_title_list($result);
          break;
      }
      return $block;
  }
}

/**
 * Implementation of hook_view().
 */
function recipe_view(&$node, $teaser = FALSE, $page = FALSE) {
  if ($page) {
    drupal_set_breadcrumb(array(l(t('Home'), ''), l(t('Recipes'), 'recipe')));
    drupal_add_css(drupal_get_path('module', 'recipe') .'/recipe.css');
  }
  $node = recipe_node_prepare($node, $teaser);

  $node->content['body'] = array(
    '#value' => $teaser ? $node->teaser : theme('recipe_node', $node, $page),
    '#weight' => 1,
  );

  return $node;
}

/**
 * Returns a cached array of recipe unit types
 */
function recipe_unit_options() {
  static $options;
  static $unit_rs;
  if ( !isset( $unit_rs ) ) {
    $unit_rs = db_query('SELECT id,type,name,abbreviation FROM {recipe_unit} ORDER BY type ASC, metric');
    $options = array();
    while ($r = db_fetch_object($unit_rs)) {
      if (isset($r->type)) {
          if (!isset($options[$r->type])) {
            $options[$r->type] = array();
          }
          $options[$r->type][$r->id] = $r->name .' ('. $r->abbreviation .')';
      }
      else {
        $options[$r->id] = $r->name .' ('. $r->abbreviation .')';
      }
    }
  }
  return $options;
}

/**
 * Converts a recipe ingredient name to and ID
 */
function recipe_ingredient_id_from_name($name) {
  static $cache;

  if (!$cache[$name]) {
    $ingredient_id = db_result(db_query("SELECT id FROM {recipe_ingredient} WHERE LOWER(name)='%s'", trim(strtolower($name))));

    if (!$ingredient_id) {
      global $active_db;
      $node_link = db_result(db_query("SELECT nid FROM {node} n WHERE title = '%s'", $name));

      db_query("INSERT INTO {recipe_ingredient} (name, link) VALUES ('%s', '%s')", $name, $node_link);
      $ingredient_id = db_result(db_query("SELECT id FROM {recipe_ingredient} WHERE LOWER(name)='%s'", trim(strtolower($name))));
    }
    $cache[$name] = $ingredient_id;
  }

  return $cache[$name];
}

/**
 * Converts an ingredient's quantity from decimal to fraction
 */
function recipe_ingredient_quantity_from_decimal($ingredient_quantity) {
  if (strpos($ingredient_quantity, '.') && variable_get('recipe_fraction_display', t('{%d} %d&frasl;%d'))) {
    $decimal = $ingredient_quantity;

    if ($decimal == 0) {
      $whole = 0;
      $numerator = 0;
      $denominator = 1;
      $top_heavy = 0;
    }
    else {
      $sign = 1;
      if ($decimal < 0)
        $sign = -1;
    }

    if (floor(abs($decimal)) == 0) {
      $whole = 0;
      $conversion = abs($decimal);
    }
    else {
      $whole = floor(abs($decimal));
      $conversion = abs($decimal);
    }

    $power = 1;
    $flag = 0;
    while ($flag == 0) {
      $argument = $conversion * $power;
      if ($argument == floor($argument)) {
        $flag = 1;
      }
      else {
        $power = $power * 10;
      }
    }

    // workaround for thirds, sixths, ninths, twelfths
    $overrides = array(
        '3333' => array(1, 3),  '6666' => array(2, 3),  '9999' => array(3, 3), // thirds
        '1666' => array(1, 6),  '8333' => array(5, 6), // sixths
        '1111' => array(1, 9),  '2222' => array(2, 9),  '4444' => array(4, 9),  '5555' => array(5, 9),  '7777' => array(7, 9),  '8888' => array(8, 9), // ninths
        '0833' => array(1, 12), '4166' => array(5, 12), '5833' => array(7, 12), '9166' => array(11, 12), // twelfths
    );
    $conversionstr = substr((string) ($conversion - floor($conversion)), 2, 4);
    if (array_key_exists($conversionstr, $overrides)) {
        if ($overrides[$conversionstr][0] == $overrides[$conversionstr][1]) {
            return ($whole + 1) * $sign;
        }
        $denominator = $overrides[$conversionstr][1];
        $numerator   = (floor($conversion) * $denominator) + $overrides[$conversionstr][0];
    }
    else {
        $numerator = $conversion * $power;
        $denominator = $power;
    }

    $hcf = recipe_euclid($numerator, $denominator);

    $numerator = $numerator/$hcf;
    $denominator = $denominator/$hcf;
    $whole = $sign * $whole;
    $top_heavy = $sign * $numerator;

    $numerator = abs($top_heavy) - (abs($whole) * $denominator);

    if (($whole == 0) && ($sign == -1)) {
        $numerator = $numerator * $sign;
    }

    $ingredient_quantity = sprintf(variable_get('recipe_fraction_display', t('{%d} %d&frasl;%d')), $whole, $numerator, $denominator);

    if ( ($whole == 0) && (strpos($ingredient_quantity, '{') >= 0) ) {
      /* remove anything in curly braces */
      $ingredient_quantity = preg_replace('/{.*}/', '', $ingredient_quantity);
    }
    else {
      /* remove just the curly braces, but keep everything between them */
      $ingredient_quantity = preg_replace('/{|}/', '', $ingredient_quantity);
    }
  }

  return filter_xss_admin($ingredient_quantity);
}

/**
 * Converts an ingredient's quantity from fractions to decimal
 */
function recipe_ingredient_quantity_from_fraction($ingredient_quantity) {
  if ($pos_slash = strpos($ingredient_quantity, '/')) {
    $pos_space = strpos($ingredient_quantity, ' ');
    // can't trust $pos_space to be a zero value if there is no space
    // so set it explicitly
    if ($pos_space === false)
      $pos_space = 0;

    $whole = substr($ingredient_quantity, 0, $pos_space);
    $numerator = substr($ingredient_quantity, $pos_space, $pos_slash);
    $denominator = substr($ingredient_quantity, $pos_slash+1);
    $ingredient_quantity = $whole+($numerator/$denominator);
  }

  return $ingredient_quantity;
}

/**
 * Saves the changed ingredients of a recipe node to the database
 * (by comparing the old and new ingredients first)
 */
function recipe_save_ingredients($node) {
  if (!$node->ingredients) {
    $node->ingredients = array();
  }
  $changes = recipe_ingredients_diff($node->ingredients, recipe_load_ingredients($node));

  if (count($changes->remove) > 0) {
    $ids = implode(',', $changes->remove);
    db_query("DELETE FROM {recipe_node_ingredient} WHERE id IN (%s)", $ids);
  }

  foreach ($changes->add as $ingredient) {
    $ingredient->id = recipe_ingredient_id_from_name($ingredient->name);
    $ingredient->quantity = recipe_ingredient_quantity_from_fraction($ingredient->quantity);
    db_query("INSERT INTO {recipe_node_ingredient} (nid,ingredient_id,quantity,unit_id) VALUES (%d,%d,%f,%d)", $node->nid, $ingredient->id, $ingredient->quantity, $ingredient->unit_id);
  }

  foreach ($changes->update as $ingredient) {
    $ingredient->id = recipe_ingredient_id_from_name($ingredient->name);
    $ingredient->quantity = recipe_ingredient_quantity_from_fraction($ingredient->quantity);
    db_query("UPDATE {recipe_node_ingredient} SET quantity='%f', unit_id='%d' WHERE nid='%d' AND  ingredient_id='%d'", $ingredient->quantity, $ingredient->unit_id, $node->nid, $ingredient->id);
  }
}

/**
 * Compares two arrays of ingredients and returns the differences
 */
function recipe_ingredients_diff($a1, $a2) {
  $return->add = array();
  $return->remove = array();
  $return->update = array();

  foreach ($a1 as $pl) {
    $pl = (object)$pl;
    $pl->name = trim($pl->name);
    if ($pl->name) {
      if (!_in_array($pl, $return->add)) {
        // Duplicate entries for the same ingredient are ignored.
        if (!_in_array($pl, $a2))
          $return->add[] = $pl;
        else
          if (!_in_array($pl, $return->update))
            $return->update[] = $pl;
      }
    }
  }
  foreach ($a2 as $k => $pl) {
    if (!_in_array($pl, $a1)) {
      $return->remove[] = $pl->id;
    }
  }
  return $return;
}

/**
 * Custom in_array() function because PHP 4 in_aray() doesnt seem to
 * handle the first arguement being an object
 */
function _in_array($a, $b) {
  $a->name = trim(strtolower($a->name));
  foreach ($b as $row) {
    $compareto="";
    if (is_array($row)) {
      $compareto = trim(strtolower($row["name"]));
    }
    else {
      $compareto = trim(strtolower($row->name));
    }
    if ($a->name === $compareto)
      return true;
  }
  return false;
}

/**
 * Loads the ingredients for a recipe
 */
function recipe_load_ingredients($node) {
  $rs = db_query('
  SELECT
    ri.id,
    i.name,
    i.link,
    ri.quantity,
    ri.unit_id,
    u.abbreviation,
    ri.ingredient_id
  FROM
    {recipe_node_ingredient} ri,
    {recipe_ingredient} i,
    {recipe_unit} u
  WHERE
    ri.ingredient_id = i.id
    AND ri.unit_id = u.id
    AND ri.nid=%d
  ORDER BY
  ri.id', $node->nid);
  $ingredients = array();
  while ($ingredient = db_fetch_object($rs)) {
    $ingredients[] = $ingredient;
  }
  return $ingredients;
}

/**
 * Converts a recipe unit ID to it's abbreviation
 */
function recipe_unit_abbreviation($unit_id) {
  static $abbreviations;

  if (!$abbreviations) {
    $rs = db_query('SELECT id,abbreviation FROM {recipe_unit}');
    while ($unit = db_fetch_object($rs)) {
      $abbreviations[$unit->id] = $unit->abbreviation;
    }
  }

  return $abbreviations[$unit_id];
}

/**
 * Converts a recipe unit ID to it's name */
function recipe_unit_name($unit_id) {
  static $unit_names;

  if (!$unit_names) {
    $rs = db_query('SELECT id,name FROM {recipe_unit}');
    while ($unit = db_fetch_object($rs)) {
      $unit_names[$unit->id] = $unit->name;
    }
  }

  return $unit_names[$unit_id];
}

/**
 * Menu callback; Generates various representation of a recipe page with
 * all descendants and prints the requested representation to output.
 *
 * The function delegates the generation of output to helper functions.
 * The function name is derived by prepending 'recipe_export_' to the
 * given output type.  So, e.g., a type of 'html' results in a call to
 * the function recipe_export_html().
 *
 * @param type
 *   - a string encoding the type of output requested.
 *       The following types are currently supported in recipe module
 *          html: HTML (printer friendly output)
 *          recipeml: XML (RecipeML formatted output)
 *       Other types can be supported with contributed modules.
 * @param nid
 *   - an integer representing the node id (nid) of the node to export
 *
 */
function recipe_export($type = 'html', $nid = 0) {
  $type = drupal_strtolower($type);
  $export_function = 'recipe_export_'. $type;

  if (function_exists($export_function)) {
    echo call_user_func($export_function, $nid);
  }
  else {
    drupal_set_message(t('Unknown export format.'));
    drupal_not_found();
  }
}

/**
 * This function is called by recipe_export() to generate HTML for export.
 *
 * @param nid
 *   - an integer representing the node id (nid) of the node to export
 * @return
 * - string containing HTML representing the recipe
 */
function recipe_export_html($nid) {
  if ($nid == 0) {
    drupal_goto('recipe');
  }
  $node = node_load(array('nid' => $nid, 'type' => 'recipe'));

  $node = recipe_node_prepare($node, FALSE);
  $output = theme('recipe_node', $node, FALSE);

  $html = theme('recipe_export_html', check_plain($node->title), $output);
  return $html;
}

/**
 * This function is called by recipe_export() to generate RecipeML for export.
 *
 * @param nid
 *   - an integer representing the node id (nid) of the node to export
 * @return
 * - string containing the recipe in RecipeML
 */
function recipe_export_recipeml($nid) {
  if ($nid == 0) {
    drupal_goto('recipe');
  }

  $node = node_load(array('nid' => $nid, 'type' => 'recipe'));

  drupal_set_header('Content-type: text/xml');

  $output = '<?xml version="1.0" encoding="UTF-8"?>'."\n".
  '<!DOCTYPE recipeml PUBLIC "-//FormatData//DTD RecipeML 0.5//EN" "http://www.formatdata.com/recipeml/recipeml.dtd">'."\n".
  '<recipeml version="0.5">'."\n".
  '  <recipe>'."\n".
  '    <head>'."\n".
  '      <title>'. $node->title .'</title>'."\n".
  '    </head>'."\n".
  '    <yield><qty>'. $node->yield .'</qty></yield>'."\n".
  '    <ingredients>';

  foreach ($node->ingredients as $ingredient) {
    $output .= "\n".'<ing><amt><qty>'. $ingredient->quantity .'</qty><unit>'. $ingredient->abbreviation .'</unit></amt><item>'. $ingredient->name .'</item></ing>';
  }

  $output .= "\n".
  '    </ingredients>'."\n".
  '    <directions>'. $node->instructions .'</directions>'."\n".
  '  </recipe>'."\n".
  '</recipeml>';

  return $output;
}

/**
 * Callback function for ingredient autocomplete
 */
function recipe_autocomplete_page($string = "", $limit = 10) {
  $matches = array();
  $rs = db_query("SELECT name FROM {recipe_ingredient} WHERE LOWER(name) LIKE '%s%%' ORDER BY name LIMIT %d", strtolower($string), $limit);
  while ($r = db_fetch_object($rs)) {
    $matches[$r->name] = check_plain($r->name);
  }
  print drupal_to_js($matches);
  exit();
}

/**
 * Implementation of hook_validate().
 *
 * Errors should be signaled with form_set_error().
 */
function recipe_validate(&$node) {
  if (!$node->ingredients) return;
  $ingredients = array();
  foreach ($node->ingredients as $key => $ingredient) {
    $ingredient = (object)$ingredient;
    if (!isset($ingredient->quantity)) {
      $ingredient = recipe_parse_ingredient_string($ingredient->name);
    }
    if ($ingredient->name && _in_array($ingredient, $ingredients)) {
      form_set_error("recipe", t('Duplicate ingredients are not allowed.'));
    }
    else {
      $ingredients[] = $ingredient;
    }
    $node->ingredients[$key] = $ingredient;
  }
}

/**
 * Converts an ingredients name string to an ingredient object
 */
function recipe_parse_ingredient_string($ingredient_string) {
  if (preg_match('#([0-9.]+(?:\s?\d*/\d*)?\s?)?(?:([a-zA-Z.]*)\s)?(.*)#', trim($ingredient_string), $matches)) {
    $ingredient->name = $matches[3];
    $ingredient->quantity = trim($matches[1]);
    if ($ingredient->quantity == 0) {
      $ingredient->quantity = 0;
    }
    $t_unit = $matches[2];
    $unit = recipe_unit_from_name($t_unit);

    if ($unit) {
      $ingredient->unit_id = $unit->id;
      $ingredient->abbreviation = $unit->abbreviation;
    }
    else {
      $ingredient->unit_id = 29;
      $ingredient->abbreviation = '';
      $ingredient->name = $t_unit .' '. $ingredient->name;
    }

    $ingredient->name = trim($ingredient->name);

    return $ingredient;
  }
  else {
    return false;
  }
}

/**
 * Returns information about a unit based on a unit abbreviation or name
 */
function recipe_unit_from_name($name) {
  if (strlen($name) > 1)
    $string = strtolower($name);
  else
    $string = $name;
  $ending = substr($string, -1, 1);
  if ($ending == 's'  && $string != 'ds' || $ending == '.') {
    $string = substr($string, 0, strlen($string) -1);
  }
  $ending = substr($string, -1, 1);
  if ($ending == 's'  && $string != 'ds'|| $ending == '.') {
    $string = substr($string, 0, strlen($string) -1);
  }

  static $units_array;

  if (!$units_array) {
    $rs = db_query('SELECT id,name,abbreviation FROM {recipe_unit}');
    while ($unit = db_fetch_object($rs)) {
      $units_array[strtolower($unit->name)] = $unit;
      $units_array[$unit->abbreviation] = $unit;
    }
  }

  return $units_array[$string];
}

/**
 * Menu Callback - created output for the main recipe page.
 *
 * @return $body
 */
function recipe_page() {
  $body = "";

  if (arg(1) == "feed") {
    module_invoke('node', 'feed', module_invoke('taxonomy', 'select_nodes', recipe_get_recipe_terms(), 'or', 0, FALSE));
  }
  else {
    if (arg(1) != NULL) {
      $breadcrumb = drupal_get_breadcrumb();
      $term = recipe_build_breadcrumbs($breadcrumb);
      drupal_set_breadcrumb($breadcrumb);

      if ($term != NULL) {
        $content = recipe_index($term->tid);
        if ($content != '') {
          $body = theme('box', $term->name .'- '. t('Sub Categories'), $content);
        }

        $terms = array_merge(array($term->tid), array_map('_recipe_get_tid_from_term', module_invoke('taxonomy', 'get_children', $term->tid)));
        $body .= module_invoke('taxonomy', 'render_nodes', module_invoke('taxonomy', 'select_nodes', $terms));
      }
    }
    else {
      $body = '';

      if (variable_get('recipe_recent_box_enable', 1)) {
        $body = theme('box', variable_get('recipe_recent_box_title', t('Latest Recipes')), module_invoke('node', 'title_list', recipe_get_latest(variable_get('recipe_recent_display', '5')), '') . theme('recipe_more_info', theme('feed_icon', url("recipe/feed"), t('Syndicate'))));
      }
      $content = recipe_index();
      if ($content != '') {
        $body .= theme('box', t('Recipe Categories'), $content);
      }
    }
  }
  return $body;
}

/**
 * Builds a breadcrumb list.
 *
 * @param breadcrumb a reference to the breadcrumb array. New items will be appending to this array.
 *
 * @return returns a term object if the last item in the url is a term, otherwise returns NULL.
 */
function recipe_build_breadcrumbs(&$breadcrumb) {
  if (arg(1) != NULL) {
    $i = 1;
    $url = 'recipe';
    $breadcrumb[] = l(ucwords(t('Recipes')), $url);
    while (arg($i) != NULL) {
      $last_term = urldecode(arg($i));
      $url = $url .'/'. urlencode($last_term);
      $breadcrumb[] = l(ucwords($last_term), $url);
      $i++;
    }

    $term = current(module_invoke('taxonomy', 'get_term_by_name', $last_term));
    return $term;
  }
  return NULL;
}

/**
 * Recursively traverses the term tree to construct the index.
 *
 * @return string the output for this tree.
 */
function recipe_build_index(&$tree, $parent_url) {
  $output = '';

  if ($tree == array()) {
    return '';
  }

  do {
    $cur =