$db-Execute() issue with fields... Please please please help.

**RodG** · 3 Oct 2012, 09:17 AM

Originally Posted by Ooba_Scott

So, we added the line...

Code:

'gift_message' => $_SESSION['gift-message'],

to :

Code:

 LINE 350 (approx)...

$this->info = array('order_status' => DEFAULT_ORDERS_STATUS_ID,
                          'currency' => $_SESSION['currency'],
                          'currency_value' => $currencies->currencies[$_SESSION['currency']]['value'],
                          'payment_method' => $GLOBALS[$class]->title,
                          'payment_module_code' => $GLOBALS[$class]->code,
                          'coupon_code' => $coupon_code->fields['coupon_code'],
      //                          'cc_type' => (isset($GLOBALS['cc_type']) ? $GLOBALS['cc_type'] : ''),
      //                          'cc_owner' => (isset($GLOBALS['cc_owner']) ? $GLOBALS['cc_owner'] : ''),
      //                          'cc_number' => (isset($GLOBALS['cc_number']) ? $GLOBALS['cc_number'] : ''),
      //                          'cc_expires' => (isset($GLOBALS['cc_expires']) ? $GLOBALS['cc_expires'] : ''),
      //                          'cc_cvv' => (isset($GLOBALS['cc_cvv']) ? $GLOBALS['cc_cvv'] : ''),
                          'shipping_method' => (is_array($_SESSION['shipping']) ? $_SESSION['shipping']['title'] : $_SESSION['shipping']),
                          'shipping_module_code' => (isset($_SESSION['shipping']['id']) && strpos($_SESSION['shipping']['id'], '_') > 0 ? $_SESSION['shipping']['id'] : $_SESSION['shipping']),
                          'shipping_cost' => $_SESSION['shipping']['cost'],
                          'subtotal' => 0,
                          'shipping_tax' => 0,
                          'tax' => 0,
                          'total' => 0,
                          'tax_groups' => array(),
                          'comments' => (isset($_SESSION['comments']) ? $_SESSION['comments'] : ''),
                          'gift_message' => $_SESSION['gift-message'],
                          'ip_address' => $_SESSION['customers_ip_address'] . ' - ' . $_SERVER['REMOTE_ADDR']
                          );

Suggestion: change your added code to read:
'gift_message' => (isset($_SESSION['gift_message']) ? $_SESSION['gift_message'] : ''),

It'll prevent the warnings that would normally be generated when $_SESSION['gift_message'] isn't set.

Cheers
Rod