function simple_package_tracking_save_tracking in Simple Package Tracking 6

Same name and namespace in other branches

1. 7 simple_package_tracking.module \simple_package_tracking_save_tracking()

1 call to simple_package_tracking_save_tracking()

simple_package_tracking_add_tracking_submit in ./simple_package_tracking.module

File

./simple_package_tracking.module, line 131

Code

function simple_package_tracking_save_tracking($order_id, $number, $url, $carrier, $id = NULL) {
  $url = preg_replace('/\\s+/', '', $url);
  if (!$id) {
    $result = db_query("INSERT INTO {tracking_numbers} (order_id, tracking_number, tracking_url, tracking_carrier) VALUES (%d, '%s', '%s', '%s')", $order_id, $number, $url, $carrier);
    $id = db_last_insert_id('tracking_numbers', 'tracking_id');
    if ($result) {
      drupal_set_message(t('Added tracking number for order @oid', array(
        '@oid' => $order_id,
      )));
    }
  }
  else {
    $result = db_query("UPDATE {tracking_numbers} SET order_id = %d, tracking_number = '%s', tracking_url = '%s', tracking_carrier = '%s' WHERE tracking_id = %d", $order_id, $number, $url, $carrier, $id);
    if ($result) {
      drupal_set_message(t('Updated tracking number for order @oid', array(
        '@oid' => $order_id,
      )));
    }
  }
  return $id;
}