define('APPAREL_BRAND_WARN_GB', 'Item in apparel group should have brand and can\'t appear in google base'); define('SHOW_STATS_GB', 'Show Statistics and Errors report when generating a feed'); define('HINT_GB', 'Google Merchant Center has different required fields per country:<br />- Select "USA", "UK, DE, FR" or "Japan" depending on where you are going to promote your products.<br />- Select "All countries" if you sell products to different countries, for example USA and Europe (this value includes requirements from all countries) or generate separate feeds under two different names.<br />- Select "Other Countries" if you sell products to other not-specified countries (this value excludes all other countries requirements).<br />'); //end // include admin messages $root_folder_path = "../"; include_once $root_folder_path . "messages/" . $language_code . "/admin_messages.php"; // Admin Site URL settings $admin_folder = get_admin_dir(); $site_url = get_setting_value($settings, "site_url", ""); $secure_url = get_setting_value($settings, "secure_url", ""); $admin_site_url = $site_url . $admin_folder; $admin_secure_url = $secure_url . $admin_folder; // check sites number $sitelist = false; if (comp_vers(va_version(), "3.3.3") == 1) { $sql = " SELECT COUNT(*) FROM " . $table_prefix . "sites"; $sites_number = get_db_value($sql); if ($sites_number > 1) { $sitelist = true; } } // SSL settings $ssl_admin_tickets = get_setting_value($settings, "ssl_admin_tickets", 0); $ssl_admin_ticket = get_setting_value($settings, "ssl_admin_ticket", 0); $ssl_admin_helpdesk = get_setting_value($settings, "ssl_admin_helpdesk", 0); $secure_admin_order_create = get_setting_value($settings, "secure_admin_order_create", 0); if ($ssl_admin_tickets && strlen($secure_url)) { $tickets_site_url = $admin_secure_url; } else { $tickets_site_url = $admin_site_url;
function get_currency($currency_code = "", $update_session = true) { global $db, $table_prefix, $is_admin_path, $site_id; if ($currency_code == "") { $currency_code = get_param("currency_code"); } $currency = get_session("session_currency"); if (strlen($currency_code) || !is_array($currency)) { if ($is_admin_path) { $version = va_version(); $sql = " SELECT c.* "; if (comp_vers($version, "3.6.19") == 1) { $sql .= " FROM (" . $table_prefix . "currencies c "; $sql .= " LEFT JOIN " . $table_prefix . "currencies_sites cs ON c.currency_id=cs.currency_id) "; } else { $sql .= " FROM " . $table_prefix . "currencies c"; } $sql_where = ""; if (comp_vers($version, "3.5.20") == 1) { $sql_where .= " c.show_for_user=1 "; } if (strlen($currency_code)) { if ($sql_where) { $sql_where .= " AND "; } $sql_where .= " ( c.currency_code=" . $db->tosql($currency_code, TEXT); $sql_where .= " OR c.currency_value=" . $db->tosql($currency_code, TEXT) . " ) "; } elseif (comp_vers($version, "3.5.22") == 1) { if ($sql_where) { $sql_where .= " AND "; } $sql_where .= " c.is_default_show=1 "; } if (comp_vers($version, "3.6.19") == 1) { if ($sql_where) { $sql_where .= " AND "; } $sql_where .= " (c.sites_all=1 OR cs.site_id=" . $db->tosql($site_id, INTEGER) . ")"; } if ($sql_where) { $sql .= " WHERE " . $sql_where; } } else { $sql = " SELECT c.* "; $sql .= " FROM (" . $table_prefix . "currencies c "; $sql .= " LEFT JOIN " . $table_prefix . "currencies_sites cs ON c.currency_id=cs.currency_id) "; $sql .= " WHERE c.show_for_user=1 "; $sql .= " AND (c.sites_all=1 OR cs.site_id=" . $db->tosql($site_id, INTEGER) . ")"; $sql .= " AND ( c.currency_code=" . $db->tosql($currency_code, TEXT); $sql .= " OR c.currency_value=" . $db->tosql($currency_code, TEXT) . " ) "; } $db->query($sql); if ($db->next_record()) { $currency["code"] = $db->f("currency_code"); $currency["value"] = $db->f("currency_value"); $currency["left"] = $db->f("symbol_left"); $currency["right"] = $db->f("symbol_right"); $currency["rate"] = $db->f("exchange_rate"); $currency["decimals"] = $db->f("decimals_number"); $currency["point"] = $db->f("decimal_point"); $currency["separator"] = $db->f("thousands_separator"); } else { $sql = " SELECT c.* "; $sql .= " FROM (" . $table_prefix . "currencies c "; $sql .= " LEFT JOIN " . $table_prefix . "currencies_sites cs ON c.currency_id=cs.currency_id) "; $sql .= " WHERE c.show_for_user=1 "; $sql .= " AND (c.sites_all=1 OR cs.site_id=" . $db->tosql($site_id, INTEGER) . ")"; $sql .= " AND c.is_default_show=1 "; $db->query($sql); if ($db->next_record()) { $currency["code"] = $db->f("currency_code"); $currency["value"] = $db->f("currency_value"); $currency["left"] = $db->f("symbol_left"); $currency["right"] = $db->f("symbol_right"); $currency["rate"] = $db->f("exchange_rate"); $currency["decimals"] = $db->f("decimals_number"); $currency["point"] = $db->f("decimal_point"); $currency["separator"] = $db->f("thousands_separator"); } else { $currency["left"] = ""; $currency["right"] = ""; $currency["code"] = ""; $currency["value"] = ""; $currency["rate"] = 1; $currency["decimals"] = 2; $currency["point"] = "."; $currency["separator"] = ","; } } if ($update_session) { set_session("session_currency", $currency); } } return $currency; }