Beispiel #1
0
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;
Beispiel #2
0
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;
}