$city = $address['entry_city']; $state = oos_get_zone_code($address['entry_country_id'], $address['entry_zone_id'], $address['entry_state']); $country = $address['countries_name']; $address_formattable = $oostable['address_format']; $address_format_query = "SELECT address_summary\n FROM {$address_formattable}\n WHERE address_format_id = '" . intval($address['address_format_id']) . "'"; $address_format = $dbconn->GetRow($address_format_query); $address_summary = $address_format['address_summary']; eval("\$address = \"{$address_summary}\";"); return $address; } $address_booktable = $oostable['address_book']; $sql = "SELECT address_book_id, entry_firstname, entry_lastname\n FROM {$address_booktable}\n WHERE customers_id = '" . intval($_SESSION['customer_id']) . "'\n AND address_book_id > 1\n ORDER BY address_book_id"; $address_book_result = $dbconn->Execute($sql); $aAddressBook = array(); while ($address_book = $address_book_result->fields) { $aAddressBook[] = array('address_book_id' => $address_book['address_book_id'], 'entry_firstname' => $address_book['entry_firstname'], 'entry_lastname' => $address_book['entry_lastname'], 'address_summary' => oos_address_summary($_SESSION['customer_id'], $address_book['address_book_id'])); $address_book_result->MoveNext(); } // links breadcrumb $oBreadcrumb->add($aLang['navbar_title_1'], oos_href_link($aPages['account'], '', 'SSL')); $oBreadcrumb->add($aLang['navbar_title_2'], oos_href_link($aPages['account_address_book'], '', 'SSL'), bookmark); $aOption['template_main'] = $sTheme . '/modules/address_book.html'; $aOption['page_heading'] = $sTheme . '/heading/page_heading.html'; $aOption['breadcrumb'] = 'default/system/breadcrumb.html'; $nPageType = OOS_PAGE_TYPE_ACCOUNT; require 'includes/oos_system.php'; if (!isset($option)) { require 'includes/info_message.php'; require 'includes/oos_blocks.php'; } // assign Smarty variables;
$address_booktable = $oostable['address_book']; $sql = "SELECT address_book_id, entry_firstname, entry_lastname FROM $address_booktable WHERE customers_id = '" . intval($_SESSION['customer_id']) . "' AND address_book_id > 1 ORDER BY address_book_id"; $address_book_result = $dbconn->Execute($sql); $aAddressBook = array(); while ($address_book = $address_book_result->fields) { $aAddressBook[] = array('address_book_id' => $address_book['address_book_id'], 'entry_firstname' => $address_book['entry_firstname'], 'entry_lastname' => $address_book['entry_lastname'], 'address_summary' => oos_address_summary($_SESSION['customer_id'], $address_book['address_book_id'])); $address_book_result->MoveNext(); } // links breadcrumb $oBreadcrumb->add($aLang['navbar_title_1'], oos_href_link($aPages['account'], '', 'SSL')); $oBreadcrumb->add($aLang['navbar_title_2']); $aOption['template_main'] = $sTheme . '/modules/address_book.html'; $aOption['page_heading'] = $sTheme . '/heading/page_heading.html'; $nPageType = OOS_PAGE_TYPE_ACCOUNT; require 'includes/oos_system.php'; if (!isset($option)) {