$zones_result =& $dbconn->Execute($zones_query); while ($zones = $zones_result->fields) { $zones_names[] = $zones['zone_name']; $zones_values[] = $zones['zone_name']; $zones_result->MoveNext(); } $oSmarty->assign('zones_names', $zones_names); $oSmarty->assign('zones_values', $zones_values); } else { $state = oos_get_zone_name($country, $zone_id, $state); $oSmarty->assign('state', $state); $oSmarty->assign('zone_id', $zone_id); } $country_name = oos_get_country_name($country); $oSmarty->assign('country_name', $country_name); if ($newsletter == '1') { $news = $aLang['entry_newsletter_yes']; } else { $news = $aLang['entry_newsletter_no']; } $oSmarty->assign('news', $news); $oos_pagetitle = $oBreadcrumb->trail_title(' » '); $oos_pagetitle .= '»' . OOS_META_TITLE; // assign Smarty variables; $oSmarty->assign( array( 'pagetitle' => htmlspecialchars($oos_pagetitle),
function oos_address_format($address_format_id, $address, $html, $boln, $eoln) { $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $address_formattable = $oostable['address_format']; $query = "SELECT address_format as format FROM $address_formattable WHERE address_format_id = '" . $address_format_id . "'"; $result =& $dbconn->Execute($query); $address_format = $result->fields; // Close result set $result->Close(); $company = addslashes($address['company']); $firstname = addslashes($address['firstname']); $lastname = addslashes($address['lastname']); $street = addslashes($address['street_address']); $suburb = addslashes($address['suburb']); $city = addslashes($address['city']); $state = addslashes($address['state']); $country_id = $address['country_id']; $zone_id = $address['zone_id']; $postcode = addslashes($address['postcode']); $zip = $postcode; $country = oos_get_country_name($country_id); $state = oos_get_zone_code($country_id, $zone_id, $state); if ($html) { // HTML Mode $HR = '<hr>'; $hr = '<hr>'; if ( ($boln == '') && ($eoln == "\n") ) { // Values not specified, use rational defaults $CR = '<br />'; $cr = '<br />'; $eoln = $cr; } else { // Use values supplied $CR = $eoln . $boln; $cr = $CR; } } else { // Text Mode $CR = $eoln; $cr = $CR; $HR = '----------------------------------------'; $hr = '----------------------------------------'; } $statecomma = ''; $streets = $street; if ($suburb != '') $streets = $street . $cr . $suburb; if ($firstname == '') $firstname = addslashes($address['name']); if ($country == '') $country = addslashes($address['country']); if ($state != '') $statecomma = $state . ', '; $fmt = $address_format['format']; eval("\$address = \"$fmt\";"); $address = stripslashes($address); if ( (ACCOUNT_COMPANY == '1') && (!empty($company)) ) { $address = $company . $cr . $address; } return $boln . $address . $eoln; }
---------------------------------------------------------------------- Released under the GNU General Public License ---------------------------------------------------------------------- */ /** ensure this file is being included by a parent file */ defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.'); if ($oEvent->installed_plugin('down_for_maintenance')) { return false; } if ($sPage == $aPages['customers_image']) { return false; } $myworld_block = '0'; if (isset($_SESSION['customer_id'])) { $myworld_block = '1'; $customerstable = $oostable['customers']; $address_bookstable = $oostable['address_book']; $customers_infotable = $oostable['customers_info']; $sql = "SELECT c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_image,\n a.entry_city, a.entry_country_id, ci.customers_info_date_account_created AS date_account_created\n FROM {$customerstable} c,\n {$address_bookstable} a,\n {$customers_infotable} ci\n WHERE c.customers_id = '" . intval($_SESSION['customer_id']) . "'\n AND a.customers_id = c.customers_id\n AND ci.customers_info_id = c.customers_id\n AND a.address_book_id = '" . intval($_SESSION['customer_default_address_id']) . "'"; $myworld = $dbconn->GetRow($sql); if ($myworld['customers_gender'] == 'm') { $myworld_gender = $aLang['male']; } elseif ($account['customers_gender'] == 'f') { $myworld_gender = $aLang['female']; } $sCountryName = oos_get_country_name($myworld['entry_country_id']); $sAccountCreated = oos_date_short($myworld['date_account_created']); // assign Smarty variables; $oSmarty->assign(array('myworld' => $myworld, 'myworld_gender' => $myworld_gender, 'country_name' => $sCountryName, 'account_created' => $sAccountCreated)); } $oSmarty->assign('block_heading_myworld', $block_heading); $oSmarty->assign('myworld_block', $myworld_block);
function smarty_function_oos_address_format($params, &$smarty) { MyOOS_CoreApi::requireOnce('lib/smarty/libs/plugins/shared.escape_special_chars.php'); $address_format_id = ''; $address = ''; $html = ''; $boln = ''; $eoln = '<br />'; foreach ($params as $_key => $_val) { ${$_key} = smarty_function_escape_special_chars($_val); } $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $address_formattable = $oostable['address_format']; $query = "SELECT address_format AS format\n FROM {$address_formattable}\n WHERE address_format_id = '" . intval($address_format_id) . "'"; $address_format = $dbconn->GetRow($query); $company = addslashes($address['company']); $firstname = addslashes($address['firstname']); $lastname = addslashes($address['lastname']); $street = addslashes($address['street_address']); $suburb = addslashes($address['suburb']); $city = addslashes($address['city']); $state = addslashes($address['state']); $country_id = $address['country_id']; $zone_id = $address['zone_id']; $postcode = addslashes($address['postcode']); $zip = $postcode; $country = oos_get_country_name($country_id); $state = oos_get_zone_code($country_id, $zone_id, $state); if ($html) { // HTML Mode $HR = '<hr>'; $hr = '<hr>'; if ($boln == '' && $eoln == "\n") { // Values not specified, use rational defaults $CR = '<br />'; $cr = '<br />'; $eoln = $cr; } else { // Use values supplied $CR = $eoln . $boln; $cr = $CR; } } else { // Text Mode $CR = $eoln; $cr = $CR; $HR = '----------------------------------------'; $hr = '----------------------------------------'; } $statecomma = ''; $streets = $street; if ($suburb != '') { $streets = $street . $cr . $suburb; } if ($firstname == '') { $firstname = addslashes($address['name']); } if ($country == '') { $country = addslashes($address['country']); } if ($state != '') { $statecomma = $state . ', '; } $fmt = $address_format['format']; eval("\$address = \"{$fmt}\";"); $address = stripslashes($address); if (ACCOUNT_COMPANY == '1' && oos_is_not_null($company)) { $address = $company . $cr . $address; } print $boln . $address . $eoln; }
defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.'); if (!isset($_SESSION['customer_id'])) { $_SESSION['navigation']->set_snapshot(); MyOOS_CoreApi::redirect(oos_href_link($aModules['user'], $aFilename['login'], '', 'SSL')); } require 'includes/languages/' . $sLanguage . '/user_account.php'; $customerstable = $oostable['customers']; $address_bookstable = $oostable['address_book']; $sql = "SELECT c.customers_gender, c.customers_firstname, c.customers_lastname,\n c.customers_dob, c.customers_number, c.customers_email_address,\n c.customers_vat_id, c.customers_telephone, c.customers_fax, c.customers_newsletter,\n a.entry_company, a.entry_owner, a.entry_street_address, a.entry_suburb,\n a.entry_postcode, a.entry_city, a.entry_zone_id, a.entry_state,\n a.entry_country_id\n FROM {$customerstable} c,\n {$address_bookstable} a\n WHERE c.customers_id = '" . intval($_SESSION['customer_id']) . "'\n AND a.customers_id = c.customers_id\n AND a.address_book_id = '" . intval($_SESSION['customer_default_address_id']) . "'"; $account = $dbconn->GetRow($sql); if ($account['customers_gender'] == 'm') { $gender = $aLang['male']; } elseif ($account['customers_gender'] == 'f') { $gender = $aLang['female']; } $sCountryName = oos_get_country_name($account['entry_country_id']); if ($account['customers_newsletter'] == '1') { $newsletter = $aLang['entry_newsletter_yes']; } else { $newsletter = $aLang['entry_newsletter_no']; } // links breadcrumb $oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aModules['user'], $aFilename['account'], '', 'SSL')); $aOption['template_main'] = $sTheme . '/modules/user_account.html'; $aOption['page_heading'] = $sTheme . '/heading/page_heading.html'; $nPageType = OOS_PAGE_TYPE_ACCOUNT; require 'includes/oos_system.php'; if (!isset($option)) { require 'includes/info_message.php'; require 'includes/oos_blocks.php'; }
/** * Alias function to oos_get_country_name, which also returns the country name * * @param $country_id * @return string */ function oos_cfg_get_country_name($country_id) { return oos_get_country_name($country_id); }
/** * Return a formatted address * * @param $address_format_id * @param $address * @param $html * @param $boln * @param $eoln * @return string */ function oos_address_format($address_format_id, $address, $html, $boln, $eoln) { // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $address_formattable = $oostable['address_format']; $address_format_result = $dbconn->Execute("SELECT address_format AS format FROM {$address_formattable} WHERE address_format_id = '" . intval($address_format_id) . "'"); $address_format = $address_format_result->fields; $company = addslashes($address['company']); $firstname = addslashes($address['firstname']); $lastname = addslashes($address['lastname']); $street = addslashes($address['street_address']); $suburb = addslashes($address['suburb']); $city = addslashes($address['city']); $state = addslashes($address['state']); $country_id = $address['country_id']; $zone_id = $address['zone_id']; $postcode = addslashes($address['postcode']); $zip = $postcode; $country = oos_get_country_name($country_id); $state = oos_get_zone_code($country_id, $zone_id, $state); if ($html) { // HTML Mode $HR = '<hr>'; $hr = '<hr>'; if ($boln == '' && $eoln == "\n") { // Values not specified, use rational defaults $CR = '<br />'; $cr = '<br />'; $eoln = $cr; } else { // Use values supplied $CR = $eoln . $boln; $cr = $CR; } } else { // Text Mode $CR = $eoln; $cr = $CR; $HR = '----------------------------------------'; $hr = '----------------------------------------'; } $statecomma = ''; $streets = $street; if ($suburb != '') { $streets = $street . $cr . $suburb; } if ($firstname == '') { $firstname = addslashes($address['name']); } if ($country == '') { $country = addslashes($address['country']); } if ($state != '') { $statecomma = $state . ', '; } $fmt = $address_format['format']; eval("\$address = \"{$fmt}\";"); $address = stripslashes($address); if (ACCOUNT_COMPANY == '1' && oos_is_not_null($company)) { $address = $company . $cr . $address; } return $boln . $address . $eoln; }