<?php

/* -----------------------------------------------------------------
 * 	$Id: general.php 719 2013-11-05 16:43:02Z akausch $
 * 	Copyright (c) 2011-2021 commerce:SEO by Webdesign Erfurt
 * 	http://www.commerce-seo.de
 * ------------------------------------------------------------------
 * 	based on:
 * 	(c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
 * 	(c) 2002-2003 osCommerce - www.oscommerce.com
 * 	(c) 2003     nextcommerce - www.nextcommerce.org
 * 	(c) 2005     xt:Commerce - www.xt-commerce.com
 * 	Released under the GNU General Public License
 * --------------------------------------------------------------- */

defined('_VALID_XTC') or die('Direct Access to this location is not allowed.');
require_once(DIR_FS_INC . 'xtc_date_short.inc.php');

function clear_string($value) {

    $string = str_replace("'", '', $value);
    $string = str_replace(')', '', $string);
    $string = str_replace('(', '', $string);
    $array = explode(',', $string);
    return $array;
}

function check_stock($products_id) {
    $stock_flag = false;
    $stock_query = xtc_db_query("SELECT products_quantity FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . $products_id . "'");
    $stock_values = xtc_db_fetch_array($stock_query);
    if ($stock_values['products_quantity'] <= 0) {
        $stock_flag = true;
        $stock_warn = TEXT_WARN_MAIN;

        $attribute_stock_query = xtc_db_query("SELECT attributes_stock, options_values_id FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = '" . $products_id . "'");
        while ($attribute_stock_values = xtc_db_fetch_array($attribute_stock_query)) {
            if ($attribute_stock_values['attributes_stock'] <= '0') {
                $stock_flag = true;
                $which_attribute = xtc_db_fetch_array(xtc_db_query("SELECT products_options_values_name FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_id = '" . $attribute_stock_values['options_values_id'] . "' AND language_id = '" . $_SESSION['languages_id'] . "';"));
                $stock_warn .= ', ' . $which_attribute['products_options_values_name'] . '(' . $attribute_stock_values['attributes_stock'] . ')';
            }
        }
    }
    if ($stock_flag && $products_id != '') {
        return '<div class="stock_warn">' . $stock_warn . '</div>';
    } else {
        return xtc_image(DIR_WS_IMAGES . 'icon_status_green.gif', $stock_values['products_quantity'] . ' ' . IMAGE_ICON_STATUS_GREEN_STOCK, 10, 10);
    }
}

// Set Categorie Status
function xtc_set_categories_status($categories_id, $status) {
    if ($status == '1') {
        return xtc_db_query("update " . TABLE_CATEGORIES . " set categories_status = '1' WHERE categories_id = '" . $categories_id . "'");
    } elseif ($status == '0') {
        return xtc_db_query("update " . TABLE_CATEGORIES . " set categories_status = '0' WHERE categories_id = '" . $categories_id . "'");
    } else {
        return -1;
    }
}

function xtc_set_groups($categories_id, $permission_array) {

    // get products in categorie
    $products_query = xtc_db_query("SELECT products_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE categories_id='" . $categories_id . "'");
    while ($products = xtc_db_fetch_array($products_query)) {
        xtc_db_perform(TABLE_PRODUCTS, $permission_array, 'update', 'products_id = \'' . $products['products_id'] . '\'');
    }
    // set status of categorie
    xtc_db_perform(TABLE_CATEGORIES, $permission_array, 'update', 'categories_id = \'' . $categories_id . '\'');
    // look for deeper categories and go rekursiv
    $categories_query = xtc_db_query("SELECT categories_id FROM " . TABLE_CATEGORIES . " WHERE parent_id='" . $categories_id . "'");
    while ($categories = xtc_db_fetch_array($categories_query)) {
        xtc_set_groups($categories['categories_id'], $permission_array);
    }
}

// Set Admin Access Rights
function xtc_set_admin_access($fieldname, $status, $cID) {
    if ($status == '1') {
        return xtc_db_query("update " . TABLE_ADMIN_ACCESS . " set " . $fieldname . " = '1' WHERE customers_id = '" . $cID . "'");
    } else {
        return xtc_db_query("update " . TABLE_ADMIN_ACCESS . " set " . $fieldname . " = '0' WHERE customers_id = '" . $cID . "'");
    }
}

// Check whether a referer has enough permission to open an admin page
function xtc_check_permission($pagename) {
    if ($pagename != 'index') {
        // $access_permission_query = xtc_db_query("SELECT ".$pagename." FROM ".TABLE_ADMIN_ACCESS." WHERE customers_id = '".$_SESSION['customer_id']."'");
        $access_permission_query = xtc_db_query("SELECT " . xtc_db_input($pagename) . " FROM " . TABLE_ADMIN_ACCESS . " WHERE customers_id = '" . $_SESSION['customer_id'] . "'");
        $access_permission = xtc_db_fetch_array($access_permission_query);

        if (($_SESSION['customers_status']['customers_status_id'] == '0') && ($access_permission[$pagename] == '1')) {
            return true;
        } else {
            return false;
        }
    } else {
        xtc_redirect(xtc_href_link(FILENAME_LOGIN));
    }
}

////
// Redirect to another page or site
function xtc_redirect($url) {
    global $logger;

    header('Location: ' . $url);

    if (STORE_PAGE_PARSE_TIME == 'true') {
        if (!is_object($logger))
            $logger = new logger;
        $logger->timer_stop();
    }

    exit;
}

function xtc_customers_name($customers_id) {
    $customers = xtc_db_query("SELECT customers_firstname, customers_lastname FROM " . TABLE_CUSTOMERS . " WHERE customers_id = '" . $customers_id . "'");
    $customers_values = xtc_db_fetch_array($customers);

    return $customers_values['customers_firstname'] . ' ' . $customers_values['customers_lastname'];
}

function xtc_get_path($current_category_id = '') {
    global $cPath_array;

    if ($current_category_id == '') {
        $cPath_new = implode('_', $cPath_array);
    } else {
        if (sizeof($cPath_array) == 0) {
            $cPath_new = $current_category_id;
        } else {
            $cPath_new = '';
            $last_category_query = xtc_db_query("SELECT parent_id FROM " . TABLE_CATEGORIES . " WHERE categories_id = '" . $cPath_array[(sizeof($cPath_array) - 1)] . "'");
            $last_category = xtc_db_fetch_array($last_category_query);
            $current_category_query = xtc_db_query("SELECT parent_id FROM " . TABLE_CATEGORIES . " WHERE categories_id = '" . $current_category_id . "'");
            $current_category = xtc_db_fetch_array($current_category_query);
            if ($last_category['parent_id'] == $current_category['parent_id']) {
                for ($i = 0, $n = sizeof($cPath_array) - 1; $i < $n; $i++) {
                    $cPath_new .= '_' . $cPath_array[$i];
                }
            } else {
                for ($i = 0, $n = sizeof($cPath_array); $i < $n; $i++) {
                    $cPath_new .= '_' . $cPath_array[$i];
                }
            }
            $cPath_new .= '_' . $current_category_id;
            if (substr($cPath_new, 0, 1) == '_') {
                $cPath_new = substr($cPath_new, 1);
            }
        }
    }

    return 'cPath=' . $cPath_new;
}

function xtc_get_all_get_params($exclude_array = '') {

    if ($exclude_array == '')
        $exclude_array = array();

    $get_url = '';

    reset($_GET);
    while (list ($key, $value) = each($_GET)) {
        if (($key != session_name()) && ($key != 'error') && (!xtc_in_array($key, $exclude_array)))
            $get_url .= $key . '=' . $value . '&';
    }

    return $get_url;
}

function xtc_date_long($raw_date) {
    if (($raw_date == '0000-00-00 00:00:00') || ($raw_date == ''))
        return false;

    $year = (int) substr($raw_date, 0, 4);
    $month = (int) substr($raw_date, 5, 2);
    $day = (int) substr($raw_date, 8, 2);
    $hour = (int) substr($raw_date, 11, 2);
    $minute = (int) substr($raw_date, 14, 2);
    $second = (int) substr($raw_date, 17, 2);

    return strftime(DATE_FORMAT_LONG, mktime($hour, $minute, $second, $month, $day, $year));
}

function xtc_datetime_short($raw_datetime, $format = DATE_TIME_FORMAT) {
    if (($raw_datetime == '0000-00-00 00:00:00') || ($raw_datetime == ''))
        return false;

    $year = (int) substr($raw_datetime, 0, 4);
    $month = (int) substr($raw_datetime, 5, 2);
    $day = (int) substr($raw_datetime, 8, 2);
    $hour = (int) substr($raw_datetime, 11, 2);
    $minute = (int) substr($raw_datetime, 14, 2);
    $second = (int) substr($raw_datetime, 17, 2);

    return strftime($format, mktime($hour, $minute, $second, $month, $day, $year));
}

function xtc_array_merge($array1, $array2, $array3 = '') {
    if (!is_array($array1)) {
        $array1 = array();
    }
    if (!is_array($array2)) {
        $array2 = array();
    }
    if (!is_array($array3)) {
        $array3 = array();
    }
    if (function_exists('array_merge')) {
        $array_merged = array_merge($array1, $array2, $array3);
    } else {
        while (list ($key, $val) = each($array1))
            $array_merged[$key] = $val;
        while (list ($key, $val) = each($array2))
            $array_merged[$key] = $val;
        if (sizeof($array3) > 0)
            while (list ($key, $val) = each($array3))
                $array_merged[$key] = $val;
    }

    return (array) $array_merged;
}

if (!function_exists('xtc_in_array')) {

    function xtc_in_array($lookup_value, $lookup_array) {
        if (function_exists('in_array')) {
            if (in_array($lookup_value, $lookup_array))
                return true;
        } else {
            reset($lookup_array);
            while (list ($key, $value) = each($lookup_array)) {
                if ($value == $lookup_value)
                    return true;
            }
        }

        return false;
    }

}

function xtc_get_category_tree($parent_id = '0', $spacing = '', $exclude = '', $category_tree_array = '', $include_itself = false) {

    if (!is_array($category_tree_array))
        $category_tree_array = array();
    if ((sizeof($category_tree_array) < 1) && ($exclude != '0'))
        $category_tree_array[] = array('id' => '0', 'text' => TEXT_TOP);

    if ($include_itself) {
        $category_query = xtc_db_query("SELECT cd.categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE cd.language_id = '" . $_SESSION['languages_id'] . "' and cd.categories_id = '" . $parent_id . "'");
        $category = xtc_db_fetch_array($category_query);
        $category_tree_array[] = array('id' => $parent_id, 'text' => $category['categories_name']);
    }

    $categories_query = xtc_db_query("SELECT c.categories_id,
											cd.categories_name,
											c.parent_id
											FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
											WHERE c.categories_id = cd.categories_id
											and cd.language_id = '" . $_SESSION['languages_id'] . "'
											and c.parent_id = '" . $parent_id . "'
											order by c.sort_order, cd.categories_name");
    while ($categories = xtc_db_fetch_array($categories_query)) {
        if ($exclude != $categories['categories_id']) {
            $category_tree_array[] = array('id' => $categories['categories_id'],
                'text' => $spacing . $categories['categories_name']);
        }

        $category_tree_array = xtc_get_category_tree($categories['categories_id'], $spacing . '&nbsp;&nbsp;&nbsp;', $exclude, $category_tree_array);
    }

    return $category_tree_array;
}

function xtc_get_tree($id = '0', $css_id = 'tree_view') {
    $subcat = '';

    $categories_query = xtc_db_query("SELECT c.categories_id,
											cd.categories_name,
											c.parent_id
											FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
											WHERE c.categories_id = cd.categories_id
											and cd.language_id = '" . $_SESSION['languages_id'] . "'
											and c.parent_id = '" . $id . "'
											order by c.sort_order, cd.categories_name");
    if (xtc_db_num_rows($categories_query)) {
        $category_tree .= '<ul ' . ($id == '0' ? 'id="' . $css_id . '">' : '>');
        while ($categories = xtc_db_fetch_array($categories_query)) {

            $category_tree .= '<li><a href="categories.php?cPath=' . $categories['categories_id'] . '">' . $categories['categories_name'] . '</a>';

            $subcat = xtc_get_tree($categories['categories_id']);
            if ($subcat != '')
                $category_tree .= $subcat;

            $category_tree .= '</li>';
        }
        $category_tree .= '</ul>';
        return $category_tree;
    } else
        return;
}

function xtc_draw_products_pull_down($name, $parameters = '', $exclude = '') {
    global $currencies;

    if ($exclude == '') {
        $exclude = array();
    }
    $SELECT_string = '<SELECT name="' . $name . '"';
    if ($parameters) {
        $SELECT_string .= ' ' . $parameters;
    }
    $SELECT_string .= '>';
    $products_query = xtc_db_query("SELECT p.products_id, pd.products_name,p.products_tax_class_id, p.products_price FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = pd.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "' order by products_name");
    while ($products = xtc_db_fetch_array($products_query)) {
        if (!xtc_in_array($products['products_id'], $exclude)) {
            //brutto admin:
            if (PRICE_IS_BRUTTO == 'true') {
                $products['products_price'] = xtc_round($products['products_price'] * ((100 + xtc_get_tax_rate($products['products_tax_class_id'])) / 100), PRICE_PRECISION);
            }
            $SELECT_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . xtc_round($products['products_price'], PRICE_PRECISION) . ')</option>';
        }
    }
    $SELECT_string .= '</SELECT>';

    return $SELECT_string;
}

function xtc_cfg_pull_down_css_bg_pic_sets() {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    if ($dir = opendir(DIR_FS_CATALOG . 'images/css_button_bg/')) {
        $pictures_array = array('id' => '', 'text' => TEXT_NONE);
        while (($pictures = readdir($dir)) !== false) {
            if (is_dir(DIR_FS_CATALOG . 'images/css_button_bg/') and ($pictures != ".") and ($pictures != "..")) {
                $pictures_array[] = array('id' => $pictures, 'text' => $pictures);
            }
        }
        closedir($dir);
        sort($pictures_array);
        return xtc_draw_pull_down_menu($name, $pictures_array, CSS_BUTTON_BACKGROUND_PIC);
    }
}

function xtc_cfg_pull_down_css_wk_bg_pic_sets() {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    if ($dir = opendir(DIR_FS_CATALOG . 'images/css_button_bg/')) {
        $pictures_array = array('id' => '', 'text' => TEXT_NONE);
        while (($pictures = readdir($dir)) !== false) {
            if (is_dir(DIR_FS_CATALOG . 'images/css_button_bg/') and ($pictures != ".") and ($pictures != "..")) {
                $pictures_array[] = array('id' => $pictures, 'text' => $pictures);
            }
        }
        closedir($dir);
        sort($pictures_array);
        return xtc_draw_pull_down_menu($name, $pictures_array, WK_CSS_BUTTON_BACKGROUND_PIC);
    }
}

function xtc_cfg_pull_down_css_bg_pic_hover_sets() {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    if ($dir = opendir(DIR_FS_CATALOG . 'images/css_button_bg/')) {
        $pictures_array = array('id' => '', 'text' => TEXT_NONE);
        while (($pictures = readdir($dir)) !== false) {
            if (is_dir(DIR_FS_CATALOG . 'images/css_button_bg/') and ($pictures != ".") and ($pictures != "..")) {
                $pictures_array[] = array('id' => $pictures, 'text' => $pictures);
            }
        }
        closedir($dir);
        sort($pictures_array);
        return xtc_draw_pull_down_menu($name, $pictures_array, CSS_BUTTON_BACKGROUND_PIC_HOVER);
    }
}

function xtc_cfg_pull_down_css_wk_bg_pic_hover_sets() {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    if ($dir = opendir(DIR_FS_CATALOG . 'images/css_button_bg/')) {
        $pictures_array = array('id' => '', 'text' => TEXT_NONE);
        while (($pictures = readdir($dir)) !== false) {
            if (is_dir(DIR_FS_CATALOG . 'images/css_button_bg/') and ($pictures != ".") and ($pictures != "..")) {
                $pictures_array[] = array('id' => $pictures, 'text' => $pictures);
            }
        }
        closedir($dir);
        sort($pictures_array);
        return xtc_draw_pull_down_menu($name, $pictures_array, WK_CSS_BUTTON_HOVER_BACKGROUND_PIC);
    }
}

function xtc_options_name($options_id) {

    $options = xtc_db_query("SELECT products_options_name FROM " . TABLE_PRODUCTS_OPTIONS . " WHERE products_options_id = '" . $options_id . "' and language_id = '" . $_SESSION['languages_id'] . "'");
    $options_values = xtc_db_fetch_array($options);

    return $options_values['products_options_name'];
}

function xtc_values_name($values_id) {

    $values = xtc_db_query("SELECT products_options_values_name FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " WHERE products_options_values_id = '" . $values_id . "' and language_id = '" . $_SESSION['languages_id'] . "'");
    $values_values = xtc_db_fetch_array($values);

    return $values_values['products_options_values_name'];
}

function xtc_info_image($image, $alt, $width = '', $height = '') {
    if (($image) && (file_exists(DIR_FS_CATALOG_IMAGES . $image))) {
        $image = xtc_image(DIR_WS_CATALOG_IMAGES . $image, $alt, $width, $height);
    } else {
        $image = TEXT_IMAGE_NONEXISTENT;
    }

    return $image;
}

function xtc_info_image_c($image, $alt, $width = '', $height = '') {
    if (($image) && (file_exists(DIR_FS_CATALOG_IMAGES . 'categories/' . $image))) {
        $image = xtc_image(DIR_WS_CATALOG_IMAGES . 'categories/' . $image, $alt, $width, $height);
    } else {
        $image = TEXT_IMAGE_NONEXISTENT;
    }

    return $image;
}

function xtc_product_thumb_image($image, $alt, $width = '', $height = '') {
    if (($image) && (file_exists(DIR_FS_CATALOG_THUMBNAIL_IMAGES . $image))) {
        $image = xtc_image(DIR_WS_CATALOG_THUMBNAIL_IMAGES . $image, $alt, $width, $height);
    } else {
        $image = TEXT_IMAGE_NONEXISTENT;
    }

    return $image;
}

function xtc_break_string($string, $len, $break_char = '-') {
    $l = 0;
    $output = '';
    for ($i = 0; $i < strlen($string); $i++) {
        $char = substr($string, $i, 1);
        if ($char != ' ') {
            $l++;
        } else {
            $l = 0;
        }
        if ($l > $len) {
            $l = 1;
            $output .= $break_char;
        }
        $output .= $char;
    }

    return $output;
}

function xtc_get_country_name($country_id) {
    $country_query = xtc_db_query("SELECT countries_name FROM " . TABLE_COUNTRIES . " WHERE countries_id = '" . $country_id . "'");

    if (!xtc_db_num_rows($country_query)) {
        return $country_id;
    } else {
        $country = xtc_db_fetch_array($country_query);
        return $country['countries_name'];
    }
}

function xtc_get_zone_name($country_id, $zone_id, $default_zone) {
    $zone_query = xtc_db_query("SELECT zone_name FROM " . TABLE_ZONES . " WHERE zone_country_id = '" . $country_id . "' and zone_id = '" . $zone_id . "'");
    if (xtc_db_num_rows($zone_query)) {
        $zone = xtc_db_fetch_array($zone_query);
        return $zone['zone_name'];
    } else {
        return $default_zone;
    }
}

function xtc_browser_detect($component) {

    return stristr($_SERVER['HTTP_USER_AGENT'], $component);
}

function xtc_tax_classes_pull_down($parameters, $SELECTed = '') {
    $SELECT_string = '<SELECT ' . $parameters . '>';
    $classes_query = xtc_db_query("SELECT tax_class_id, tax_class_title FROM " . TABLE_TAX_CLASS . " order by tax_class_title");
    while ($classes = xtc_db_fetch_array($classes_query)) {
        $SELECT_string .= '<option value="' . $classes['tax_class_id'] . '"';
        if ($SELECTed == $classes['tax_class_id'])
            $SELECT_string .= ' SELECTED';
        $SELECT_string .= '>' . $classes['tax_class_title'] . '</option>';
    }
    $SELECT_string .= '</SELECT>';

    return $SELECT_string;
}

function xtc_geo_zones_pull_down($parameters, $SELECTed = '') {
    $SELECT_string = '<SELECT ' . $parameters . '>';
    $zones_query = xtc_db_query("SELECT geo_zone_id, geo_zone_name FROM " . TABLE_GEO_ZONES . " order by geo_zone_name");
    while ($zones = xtc_db_fetch_array($zones_query)) {
        $SELECT_string .= '<option value="' . $zones['geo_zone_id'] . '"';
        if ($SELECTed == $zones['geo_zone_id'])
            $SELECT_string .= ' SELECTED';
        $SELECT_string .= '>' . $zones['geo_zone_name'] . '</option>';
    }
    $SELECT_string .= '</SELECT>';

    return $SELECT_string;
}

function xtc_get_geo_zone_name($geo_zone_id) {
    $zones_query = xtc_db_query("SELECT geo_zone_name FROM " . TABLE_GEO_ZONES . " WHERE geo_zone_id = '" . $geo_zone_id . "'");

    if (!xtc_db_num_rows($zones_query)) {
        $geo_zone_name = $geo_zone_id;
    } else {
        $zones = xtc_db_fetch_array($zones_query);
        $geo_zone_name = $zones['geo_zone_name'];
    }

    return $geo_zone_name;
}

function xtc_address_format($address_format_id, $address, $html, $boln, $eoln) {
    $address_format_query = xtc_db_query("SELECT address_format as format FROM " . TABLE_ADDRESS_FORMAT . " WHERE address_format_id = '" . $address_format_id . "'");
    $address_format = xtc_db_fetch_array($address_format_query);

    $company = addslashes($address['company']);
    $firstname = addslashes($address['firstname']);
    $cid = addslashes($address['csID']);
    $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 = xtc_get_country_name($country_id);
    $state = xtc_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 == 'true') && (xtc_not_null($company))) {
        $address = $company . $cr . $address;
    }

    return $address;
}

function xtc_get_zone_code($country, $zone, $def_state) {

    $state_prov_query = xtc_db_query("SELECT zone_code FROM " . TABLE_ZONES . " WHERE zone_country_id = '" . $country . "' and zone_id = '" . $zone . "'");

    if (!xtc_db_num_rows($state_prov_query)) {
        $state_prov_code = $def_state;
    } else {
        $state_prov_values = xtc_db_fetch_array($state_prov_query);
        $state_prov_code = $state_prov_values['zone_code'];
    }

    return $state_prov_code;
}

function xtc_get_uprid($prid, $params) {
    $uprid = $prid;
    if ((is_array($params)) && (!strstr($prid, '{'))) {
        while (list ($option, $value) = each($params)) {
            $uprid = $uprid . '{' . $option . '}' . $value;
        }
    }

    return $uprid;
}

function xtc_get_prid($uprid) {
    $pieces = explode('{', $uprid);

    return $pieces[0];
}

function xtc_get_languages() {
    $languages_query = xtc_db_query("SELECT languages_id, name, code, image, directory, status, status_admin FROM " . TABLE_LANGUAGES . " WHERE status_admin = 1 ORDER BY sort_order");
    while ($languages = xtc_db_fetch_array($languages_query)) {
        $languages_array[] = array('id' => $languages['languages_id'], 'name' => $languages['name'], 'code' => $languages['code'], 'image' => $languages['image'], 'directory' => $languages['directory'], 'status' => $languages['status'], 'status_admin' => $languages['status_admin']);
    }
    return $languages_array;
}

function get_languages() {
    $languages_query = xtc_db_query("SELECT languages_id, name, code, image, directory, status, status_admin FROM " . TABLE_LANGUAGES . " WHERE status_admin = 1 ORDER BY sort_order");
    while ($languages = xtc_db_fetch_array($languages_query)) {
        $languages_array[] = array('id' => $languages['languages_id'], 'name' => $languages['name'], 'code' => $languages['code'], 'image' => $languages['image'], 'directory' => $languages['directory'], 'status' => $languages['status'], 'status_admin' => $languages['status_admin']);
    }
    return $languages_array;
}

function xtc_get_languages_head() {
    $languages_query = xtc_db_query("SELECT languages_id, name, code, image, directory FROM " . TABLE_LANGUAGES . " ORDER BY sort_order");
    while ($languages = xtc_db_fetch_array($languages_query)) {
        $languages_array[] = array('id' => $languages['languages_id'], 'name' => $languages['name'], 'code' => $languages['code'], 'image' => $languages['image'], 'directory' => $languages['directory']);
    }
    return $languages_array;
}

function xtc_get_categories_name($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_name'];
}

function xtc_get_categories_url_alias($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_url_alias FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_url_alias'];
}

function xtc_get_categories_heading_title($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_heading_title FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);
    return $category['categories_heading_title'];
}

function xtc_get_categories_google_taxonomie($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_google_taxonomie FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);
    return $category['categories_google_taxonomie'];
}

function xtc_get_categories_short_description($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_short_description FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_short_description'];
}

function xtc_get_categories_description($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_description FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_description'];
}

function xtc_get_categories_description_footer($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_description_footer FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_description_footer'];
}

function xtc_get_categories_pic_alt($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_pic_alt FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_pic_alt'];
}

function xtc_get_categories_pic_footer_alt($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_pic_footer_alt FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_pic_footer_alt'];
}

function xtc_get_categories_pic_nav_alt($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_pic_nav_alt FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_pic_nav_alt'];
}

function xtc_get_categories_meta_title($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_meta_title FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_meta_title'];
}

function xtc_get_categories_meta_description($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_meta_description FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_meta_description'];
}

function xtc_get_categories_meta_keywords($category_id, $language_id) {
    $category_query = xtc_db_query("SELECT categories_meta_keywords FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = '" . $category_id . "' and language_id = '" . $language_id . "'");
    $category = xtc_db_fetch_array($category_query);

    return $category['categories_meta_keywords'];
}

function xtc_get_orders_status_name($orders_status_id, $language_id = '') {

    if (!$language_id)
        $language_id = $_SESSION['languages_id'];
    $orders_status_query = xtc_db_query("SELECT orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE orders_status_id = '" . $orders_status_id . "' and language_id = '" . $language_id . "'");
    $orders_status = xtc_db_fetch_array($orders_status_query);

    return $orders_status['orders_status_name'];
}

function xtc_get_cross_sell_name($cross_sell_group, $language_id = '') {

    if (!$language_id)
        $language_id = $_SESSION['languages_id'];
    $cross_sell_query = xtc_db_query("SELECT groupname FROM " . TABLE_PRODUCTS_XSELL_GROUPS . " WHERE products_xsell_grp_name_id = '" . $cross_sell_group . "' and language_id = '" . $language_id . "'");
    $cross_sell = xtc_db_fetch_array($cross_sell_query);

    return $cross_sell['groupname'];
}

function xtc_get_shipping_status_name($shipping_status_id, $language_id = '') {

    if (!$language_id)
        $language_id = $_SESSION['languages_id'];
    $shipping_status_query = xtc_db_query("SELECT shipping_status_name FROM " . TABLE_SHIPPING_STATUS . " WHERE shipping_status_id = '" . $shipping_status_id . "' and language_id = '" . $language_id . "'");
    $shipping_status = xtc_db_fetch_array($shipping_status_query);

    return $shipping_status['shipping_status_name'];
}

function xtc_get_orders_status() {

    $orders_status_array = array();
    $orders_status_query = xtc_db_query("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE language_id = '" . $_SESSION['languages_id'] . "' order by orders_status_id");
    while ($orders_status = xtc_db_fetch_array($orders_status_query)) {
        $orders_status_array[] = array('id' => $orders_status['orders_status_id'], 'text' => $orders_status['orders_status_name']);
    }

    return $orders_status_array;
}

function xtc_get_cross_sell_groups() {

    $cross_sell_array = array();
    $cross_sell_query = xtc_db_query("SELECT products_xsell_grp_name_id, groupname FROM " . TABLE_PRODUCTS_XSELL_GROUPS . " WHERE language_id = '" . $_SESSION['languages_id'] . "' order by products_xsell_grp_name_id");
    while ($cross_sell = xtc_db_fetch_array($cross_sell_query)) {
        $cross_sell_array[] = array('id' => $cross_sell['products_xsell_grp_name_id'], 'text' => $cross_sell['groupname']);
    }

    return $cross_sell_array;
}

function xtc_get_products_vpe_name($products_vpe_id, $language_id = '') {

    if (!$language_id)
        $language_id = $_SESSION['languages_id'];
    $products_vpe_query = xtc_db_query("SELECT products_vpe_name FROM " . TABLE_PRODUCTS_VPE . " WHERE products_vpe_id = '" . $products_vpe_id . "' and language_id = '" . $language_id . "'");
    $products_vpe = xtc_db_fetch_array($products_vpe_query);

    return $products_vpe['products_vpe_name'];
}

function xtc_get_shipping_status() {

    $shipping_status_array = array();
    $shipping_status_query = xtc_db_query("SELECT shipping_status_id, shipping_status_name FROM " . TABLE_SHIPPING_STATUS . " WHERE language_id = '" . $_SESSION['languages_id'] . "' order by shipping_status_id");
    while ($shipping_status = xtc_db_fetch_array($shipping_status_query)) {
        $shipping_status_array[] = array('id' => $shipping_status['shipping_status_id'], 'text' => $shipping_status['shipping_status_name']);
    }

    return $shipping_status_array;
}

function xtc_get_products_name($product_id, $language_id = 0) {
    if ($language_id == 0)
        $language_id = $_SESSION['languages_id'];
    $product_query = xtc_db_query("SELECT products_name FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_name'];
}

function xtc_get_img_alt($product_id, $language_id = 0) {
    if ($language_id == 0)
        $language_id = $_SESSION['languages_id'];
    $product = xtc_db_fetch_array(xtc_db_query("SELECT products_img_alt FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' AND language_id = '" . $language_id . "'"));

    return $product['products_img_alt'];
}

function xtc_get_products_url_alias($product_id, $language_id = 0) {
    if ($language_id == 0)
        $language_id = $_SESSION['languages_id'];
    $product_query = xtc_db_query("SELECT products_url_alias FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_url_alias'];
}

function xtc_get_products_description($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_description FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_description'];
}

function xtc_get_products_short_description($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_short_description FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_short_description'];
}

function xtc_get_products_zusatz_description($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_zusatz_description FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_zusatz_description'];
}

function xtc_get_products_keywords($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_keywords FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_keywords'];
}

function xtc_get_url_text($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT url_text FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['url_text'];
}

function xtc_get_url_old_text($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT url_old_text FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['url_old_text'];
}

function xtc_get_products_meta_title($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_meta_title FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_meta_title'];
}

function xtc_get_products_meta_description($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_meta_description FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_meta_description'];
}

function xtc_get_products_meta_keywords($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_meta_keywords FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_meta_keywords'];
}

function xtc_get_products_google_taxonomie($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_google_taxonomie FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_google_taxonomie'];
}

function xtc_get_products_taxonomie($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_taxonomie FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_taxonomie'];
}

function xtc_get_products_tag_cloud($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_tag_cloud FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_tag_cloud'];
}

function xtc_get_products_url($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_url FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_url'];
}

//Treepodia
function xtc_get_products_treepodia_catch_phrase_1($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_treepodia_catch_phrase_1 FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_treepodia_catch_phrase_1'];
}

function xtc_get_products_treepodia_catch_phrase_2($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_treepodia_catch_phrase_2 FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_treepodia_catch_phrase_2'];
}

function xtc_get_products_treepodia_catch_phrase_3($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_treepodia_catch_phrase_3 FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_treepodia_catch_phrase_3'];
}

function xtc_get_products_treepodia_catch_phrase_4($product_id, $language_id) {
    $product_query = xtc_db_query("SELECT products_treepodia_catch_phrase_4 FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = xtc_db_fetch_array($product_query);

    return $product['products_treepodia_catch_phrase_4'];
}

//recover carts
function xtc_get_products_special_price($product_id, $customer_id, $qty = 1) {
    $customer_group_query = xtc_db_query("SELECT customers_status FROM " . TABLE_CUSTOMERS . " WHERE customers_id = '" . $customer_id . "'");
    $customer_group = xtc_db_fetch_array($customer_group_query);
    $personal_query = xtc_db_query("SELECT personal_offer FROM " . TABLE_PERSONAL_OFFERS_BY . $customer_group['customers_status'] . " WHERE products_id=" . (int) $product_id . " AND quantity<=" . (int) $qty . " ORDER BY quantity DESC LIMIT 1");
    if (xtc_db_num_rows($personal_query)) {
        $personal = xtc_db_fetch_array($personal_query);
        return $personal['personal_offer'];
    }
    $product_query = xtc_db_query("SELECT specials_new_products_price FROM " . TABLE_SPECIALS . " WHERE products_id = '" . (int) $product_id . "' and status");
    $product = xtc_db_fetch_array($product_query);
    return $product['specials_new_products_price'];
}

//recover carts END
////
// Return the manufacturers URL in the needed language
// TABLES: manufacturers_info
function xtc_get_manufacturer_url($manufacturer_id, $language_id) {
    $manufacturer_query = xtc_db_query("SELECT manufacturers_url FROM " . TABLE_MANUFACTURERS_INFO . " WHERE manufacturers_id = '" . $manufacturer_id . "' and languages_id = '" . $language_id . "'");
    $manufacturer = xtc_db_fetch_array($manufacturer_query);

    return $manufacturer['manufacturers_url'];
}

////
// Wrapper for class_exists() function
// This function is not available in all PHP versions so we test it before using it.
function xtc_class_exists($class_name) {
    if (function_exists('class_exists')) {
        return class_exists($class_name);
    } else {
        return true;
    }
}

////
// Returns an array with countries
// TABLES: countries
function xtc_get_countries($default = '') {
    $countries_array = array();
    if ($default) {
        $countries_array[] = array('id' => STORE_COUNTRY, 'text' => $default);
    }
    $countries_query = xtc_db_query("SELECT countries_id, countries_name FROM " . TABLE_COUNTRIES . " WHERE status = '1' ORDER BY countries_name");
    while ($countries = xtc_db_fetch_array($countries_query)) {
        $countries_array[] = array('id' => $countries['countries_id'], 'text' => $countries['countries_name']);
    }

    return $countries_array;
}

////
// return an array with country zones
function xtc_get_country_zones($country_id) {
    $zones_array = array();
    $zones_query = xtc_db_query("SELECT zone_id, zone_name FROM " . TABLE_ZONES . " WHERE zone_country_id = '" . $country_id . "' order by zone_name");
    while ($zones = xtc_db_fetch_array($zones_query)) {
        $zones_array[] = array('id' => $zones['zone_id'], 'text' => $zones['zone_name']);
    }

    return $zones_array;
}

function xtc_prepare_country_zones_pull_down($country_id = '') {
    // preset the width of the drop-down for Netscape
    $pre = '';
    if ((!xtc_browser_detect('MSIE')) && (xtc_browser_detect('Mozilla/4'))) {
        for ($i = 0; $i < 45; $i++)
            $pre .= '&nbsp;';
    }

    $zones = xtc_get_country_zones($country_id);

    if (sizeof($zones) > 0) {
        $zones_SELECT = array(array('id' => '', 'text' => PLEASE_SELECT));
        $zones = xtc_array_merge($zones_SELECT, $zones);
    } else {
        $zones = array(array('id' => '', 'text' => TYPE_BELOW));
        // create dummy options for Netscape to preset the height of the drop-down
        if ((!xtc_browser_detect('MSIE')) && (xtc_browser_detect('Mozilla/4'))) {
            for ($i = 0; $i < 9; $i++) {
                $zones[] = array('id' => '', 'text' => $pre);
            }
        }
    }

    return $zones;
}

////
// Get list of address_format_id's
function xtc_get_address_formats() {
    $address_format_query = xtc_db_query("SELECT address_format_id FROM " . TABLE_ADDRESS_FORMAT . " order by address_format_id");
    $address_format_array = array();
    while ($address_format_values = xtc_db_fetch_array($address_format_query)) {
        $address_format_array[] = array('id' => $address_format_values['address_format_id'], 'text' => $address_format_values['address_format_id']);
    }
    return $address_format_array;
}

////
// Alias function for Store configuration values in the Administration Tool
function xtc_cfg_pull_down_country_list($country_id) {
    return xtc_draw_pull_down_menu('configuration_value', xtc_get_countries(), $country_id);
}

function xtc_cfg_pull_down_zone_list($zone_id) {
    return xtc_draw_pull_down_menu('configuration_value', xtc_get_country_zones(STORE_COUNTRY), $zone_id);
}

function xtc_cfg_pull_down_tax_classes($tax_class_id, $key = '') {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');

    $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
    $tax_class_query = xtc_db_query("SELECT tax_class_id, tax_class_title FROM " . TABLE_TAX_CLASS . " order by tax_class_title");
    while ($tax_class = xtc_db_fetch_array($tax_class_query)) {
        $tax_class_array[] = array('id' => $tax_class['tax_class_id'], 'text' => $tax_class['tax_class_title']);
    }

    return xtc_draw_pull_down_menu($name, $tax_class_array, $tax_class_id);
}

////
// Function to read in text area in admin
function xtc_cfg_textarea($text) {
    return xtc_draw_textarea_field('configuration_value', false, 35, 5, $text, 'class="resizable"');
}

function xtc_cfg_get_zone_name($zone_id) {
    $zone_query = xtc_db_query("SELECT zone_name FROM " . TABLE_ZONES . " WHERE zone_id = '" . $zone_id . "'");

    if (!xtc_db_num_rows($zone_query)) {
        return $zone_id;
    } else {
        $zone = xtc_db_fetch_array($zone_query);
        return $zone['zone_name'];
    }
}

////
// Sets the status of a banner
function xtc_set_banner_status($banners_id, $status) {
    if ($status == '1') {
        return xtc_db_query("UPDATE " . TABLE_BANNERS . " set status = '1', date_status_change = now() WHERE banners_id = '" . $banners_id . "'");
    } elseif ($status == '0') {
        return xtc_db_query("UPDATE " . TABLE_BANNERS . " set status = '0', date_status_change = now() WHERE banners_id = '" . $banners_id . "'");
    } else {
        return -1;
    }
}

////
// Sets the status of a product on special
function xtc_set_specials_status($specials_id, $status) {
    if ($status == '1') {
        return xtc_db_query("UPDATE " . TABLE_SPECIALS . " SET status = '1', date_status_change = now() WHERE specials_id = '" . $specials_id . "'");
    } elseif ($status == '0') {
        return xtc_db_query("UPDATE " . TABLE_SPECIALS . " SET status = '0', date_status_change = now() WHERE specials_id = '" . $specials_id . "'");
    } else {
        return -1;
    }
}

////
// Sets timeout for the current script.
// Cant be used in safe mode.
function xtc_set_time_limit($limit) {
    if (!get_cfg_var('safe_mode')) {
        @ set_time_limit($limit);
    }
}

////
// Alias function for Store configuration values in the Administration Tool
function xtc_cfg_SELECT_option($SELECT_array, $key_value, $key = '') {
    for ($i = 0, $n = sizeof($SELECT_array); $i < $n; $i++) {
        $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
        $string .= '<input type="radio" name="' . $name . '" value="' . $SELECT_array[$i] . '"';
        if ($key_value == $SELECT_array[$i])
            $string .= ' CHECKED';
        $string .= '> ' . $SELECT_array[$i] . '<br>';
    }

    return $string;
}

////
// Alias function for module configuration keys
function xtc_mod_SELECT_option($SELECT_array, $key_name, $key_value) {
    reset($SELECT_array);
    while (list ($key, $value) = each($SELECT_array)) {
        if (is_int($key))
            $key = $value;
        $string .= '<br><input type="radio" name="configuration[' . $key_name . ']" value="' . $key . '"';
        if ($key_value == $key)
            $string .= ' CHECKED';
        $string .= '> ' . $value;
    }

    return $string;
}

////
// Retreive server information
function xtc_get_system_information() {

    $db_query = xtc_db_query("SELECT now() as datetime");
    $db = xtc_db_fetch_array($db_query);

    list ($system, $host, $kernel) = preg_split('/[\s,]+/', @ exec('uname -a'), 5);

    return array('date' => xtc_datetime_short(date('Y-m-d H:i:s')), 'system' => $system, 'kernel' => $kernel, 'host' => $host, 'ip' => gethostbyname($host), 'uptime' => @ exec('uptime'), 'http_server' => $_SERVER['SERVER_SOFTWARE'], 'php' => PHP_VERSION, 'zend' => (function_exists('zend_version') ? zend_version() : ''), 'db_server' => DB_SERVER, 'db_ip' => gethostbyname(DB_SERVER), 'db_version' => 'MySQL ' . (function_exists('mysql_get_server_info') ? mysql_get_server_info() : ''), 'db_date' => xtc_datetime_short($db['datetime']));
}

function xtc_array_shift(& $array) {
    if (function_exists('array_shift')) {
        return array_shift($array);
    } else {
        $i = 0;
        $shifted_array = array();
        reset($array);
        while (list ($key, $value) = each($array)) {
            if ($i > 0) {
                $shifted_array[$key] = $value;
            } else {
                $return = $array[$key];
            }
            $i++;
        }
        $array = $shifted_array;

        return $return;
    }
}

function xtc_array_reverse($array) {
    if (function_exists('array_reverse')) {
        return array_reverse($array);
    } else {
        $reversed_array = array();
        for ($i = sizeof($array) - 1; $i >= 0; $i--) {
            $reversed_array[] = $array[$i];
        }
        return $reversed_array;
    }
}

function xtc_generate_category_path($id, $FROM = 'category', $categories_array = '', $index = 0) {

    if (!is_array($categories_array))
        $categories_array = array();

    if ($FROM == 'product') {
        $categories_query = xtc_db_query("SELECT categories_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = '" . $id . "'");
        while ($categories = xtc_db_fetch_array($categories_query)) {
            if ($categories['categories_id'] == '0') {
                $categories_array[$index][] = array('id' => '0', 'text' => TEXT_TOP);
            } else {
                $category_query = xtc_db_query("SELECT cd.categories_name, c.parent_id FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = '" . $categories['categories_id'] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $_SESSION['languages_id'] . "'");
                $category = xtc_db_fetch_array($category_query);
                $categories_array[$index][] = array('id' => $categories['categories_id'], 'text' => $category['categories_name']);
                if ((xtc_not_null($category['parent_id'])) && ($category['parent_id'] != '0'))
                    $categories_array = xtc_generate_category_path($category['parent_id'], 'category', $categories_array, $index);
                $categories_array[$index] = xtc_array_reverse($categories_array[$index]);
            }
            $index++;
        }
    }
    elseif ($FROM == 'category') {
        $category_query = xtc_db_query("SELECT cd.categories_name, c.parent_id FROM " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = '" . $id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . $_SESSION['languages_id'] . "'");
        $category = xtc_db_fetch_array($category_query);
        $categories_array[$index][] = array('id' => $id, 'text' => $category['categories_name']);
        if ((xtc_not_null($category['parent_id'])) && ($category['parent_id'] != '0'))
            $categories_array = xtc_generate_category_path($category['parent_id'], 'category', $categories_array, $index);
    }

    return $categories_array;
}

function xtc_output_generated_category_path($id, $FROM = 'category') {
    $calculated_category_path_string = '';
    $calculated_category_path = xtc_generate_category_path($id, $FROM);
    for ($i = 0, $n = sizeof($calculated_category_path); $i < $n; $i++) {
        for ($j = 0, $k = sizeof($calculated_category_path[$i]); $j < $k; $j++) {
            $calculated_category_path_string .= $calculated_category_path[$i][$j]['text'] . '&nbsp;&gt;&nbsp;';
        }
        $calculated_category_path_string = substr($calculated_category_path_string, 0, -16) . '<br>';
    }
    $calculated_category_path_string = substr($calculated_category_path_string, 0, -4);

    if (strlen($calculated_category_path_string) < 1)
        $calculated_category_path_string = TEXT_TOP;

    return $calculated_category_path_string;
}

//deletes all product image files by filename
function xtc_del_image_file($image) {
    if (file_exists(DIR_FS_CATALOG_POPUP_IMAGES . $image)) {
        @ unlink(DIR_FS_CATALOG_POPUP_IMAGES . $image);
    }
    if (file_exists(DIR_FS_CATALOG_ORIGINAL_IMAGES . $image)) {
        @ unlink(DIR_FS_CATALOG_ORIGINAL_IMAGES . $image);
    }
    if (file_exists(DIR_FS_CATALOG_THUMBNAIL_IMAGES . $image)) {
        @ unlink(DIR_FS_CATALOG_THUMBNAIL_IMAGES . $image);
    }
    if (file_exists(DIR_FS_CATALOG_INFO_IMAGES . $image)) {
        @ unlink(DIR_FS_CATALOG_INFO_IMAGES . $image);
    }
    if (file_exists(DIR_FS_CATALOG_MINI_IMAGES . $image)) {
        @ unlink(DIR_FS_CATALOG_MINI_IMAGES . $image);
    }
}

//deletes movies files by filename
function xtc_del_movie_file($movie) {
    if (file_exists(DIR_WS_CATALOG_MOVIES . $movie)) {
        @unlink(DIR_WS_CATALOG_MOVIES . $movie);
    }
}

function xtc_remove_order($order_id, $restock = false) {
    if ($restock == 'on') {
        $order_query = xtc_db_query("
			SELECT
				orders_products_id,
				products_id,
				products_quantity
			FROM
				" . TABLE_ORDERS_PRODUCTS . "
			WHERE
				orders_id = '" . xtc_db_input($order_id) . "'
		");

        //nc_patch restock_attributes BOF
        while ($order = xtc_db_fetch_array($order_query)) {
            xtc_db_query("
				update " . TABLE_PRODUCTS . "
				set
					products_quantity = products_quantity + " . $order['products_quantity'] . ",
					products_ordered 	= products_ordered 	- " . $order['products_quantity'] . "
				WHERE
					products_id = '" . $order['products_id'] . "'
			");

            $result = xtc_db_query('
				SELECT *
				FROM orders_products_attributes
				WHERE
					orders_id 					= "' . $order_id . '" AND
					orders_products_id 	= "' . $order['orders_products_id'] . '"
			');
            while (($row = xtc_db_fetch_array($result))) {
                $attributes_id = nc_get_products_attributes_id($order['products_id'], $row['products_options'], $row['products_options_values']);
                xtc_db_query('
					UPDATE products_attributes
					SET
						attributes_stock = attributes_stock + ' . $order['products_quantity'] . '
					WHERE
						products_attributes_id = "' . $attributes_id . '"
				');
                // echo mysql_error();
            }
        }
        //nc_patch restock_attributes EOF
    }

    xtc_db_query("delete FROM " . TABLE_ORDERS . " WHERE orders_id = '" . xtc_db_input($order_id) . "'");
    xtc_db_query("delete FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . xtc_db_input($order_id) . "'");
    xtc_db_query("delete FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE orders_id = '" . xtc_db_input($order_id) . "'");
    xtc_db_query("delete FROM " . TABLE_ORDERS_STATUS_HISTORY . " WHERE orders_id = '" . xtc_db_input($order_id) . "'");
    xtc_db_query("delete FROM " . TABLE_ORDERS_TOTAL . " WHERE orders_id = '" . xtc_db_input($order_id) . "'");
}

function xtc_reset_cache_block($cache_block) {
    global $cache_blocks;

    for ($i = 0, $n = sizeof($cache_blocks); $i < $n; $i++) {
        if ($cache_blocks[$i]['code'] == $cache_block) {
            if ($cache_blocks[$i]['multiple']) {
                if ($dir = @ opendir(DIR_FS_CACHE)) {
                    while ($cache_file = readdir($dir)) {
                        $cached_file = $cache_blocks[$i]['file'];
                        $languages = xtc_get_languages();
                        for ($j = 0, $k = sizeof($languages); $j < $k; $j++) {
                            $cached_file_unlink = preg_replace('/-language/', '-' . $languages[$j]['directory'], $cached_file);
                            if (preg_match('/^' . $cached_file_unlink . '/', $cache_file)) {
                                @ unlink(DIR_FS_CACHE . $cache_file);
                            }
                        }
                    }
                    closedir($dir);
                }
            } else {
                $cached_file = $cache_blocks[$i]['file'];
                $languages = xtc_get_languages();
                for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {
                    $cached_file = preg_replace('/-language/', '-' . $languages[$i]['directory'], $cached_file);
                    @ unlink(DIR_FS_CACHE . $cached_file);
                }
            }
            break;
        }
    }
}

function xtc_get_file_permissions($mode) {
    // determine type
    if (($mode & 0xC000) == 0xC000) { // unix domain socket
        $type = 's';
    } elseif (($mode & 0x4000) == 0x4000) { // directory
        $type = 'd';
    } elseif (($mode & 0xA000) == 0xA000) { // symbolic link
        $type = 'l';
    } elseif (($mode & 0x8000) == 0x8000) { // regular file
        $type = '-';
    } elseif (($mode & 0x6000) == 0x6000) { //bBlock special file
        $type = 'b';
    } elseif (($mode & 0x2000) == 0x2000) { // character special file
        $type = 'c';
    } elseif (($mode & 0x1000) == 0x1000) { // named pipe
        $type = 'p';
    } else { // unknown
        $type = '?';
    }

    // determine permissions
    $owner['read'] = ($mode & 00400) ? 'r' : '-';
    $owner['write'] = ($mode & 00200) ? 'w' : '-';
    $owner['execute'] = ($mode & 00100) ? 'x' : '-';
    $group['read'] = ($mode & 00040) ? 'r' : '-';
    $group['write'] = ($mode & 00020) ? 'w' : '-';
    $group['execute'] = ($mode & 00010) ? 'x' : '-';
    $world['read'] = ($mode & 00004) ? 'r' : '-';
    $world['write'] = ($mode & 00002) ? 'w' : '-';
    $world['execute'] = ($mode & 00001) ? 'x' : '-';

    // adjust for SUID, SGID and sticky bit
    if ($mode & 0x800)
        $owner['execute'] = ($owner['execute'] == 'x') ? 's' : 'S';
    if ($mode & 0x400)
        $group['execute'] = ($group['execute'] == 'x') ? 's' : 'S';
    if ($mode & 0x200)
        $world['execute'] = ($world['execute'] == 'x') ? 't' : 'T';

    return $type . $owner['read'] . $owner['write'] . $owner['execute'] . $group['read'] . $group['write'] . $group['execute'] . $world['read'] . $world['write'] . $world['execute'];
}

function xtc_array_slice($array, $offset, $length = '0') {
    if (function_exists('array_slice')) {
        return array_slice($array, $offset, $length);
    } else {
        $length = abs($length);
        if ($length == 0) {
            $high = sizeof($array);
        } else {
            $high = $offset + $length;
        }

        for ($i = $offset; $i < $high; $i++) {
            $new_array[$i - $offset] = $array[$i];
        }

        return $new_array;
    }
}

function xtc_remove($source) {
    global $messageStack, $xtc_remove_error;

    if (isset($xtc_remove_error))
        $xtc_remove_error = false;

    if (is_dir($source)) {
        $dir = dir($source);
        while ($file = $dir->read()) {
            if (($file != '.') && ($file != '..')) {
                if (is_writeable($source . '/' . $file)) {
                    xtc_remove($source . '/' . $file);
                } else {
                    $messageStack->add(sprintf(ERROR_FILE_NOT_REMOVEABLE, $source . '/' . $file), 'error');
                    $xtc_remove_error = true;
                }
            }
        }
        $dir->close();

        if (is_writeable($source)) {
            rmdir($source);
        } else {
            $messageStack->add(sprintf(ERROR_DIRECTORY_NOT_REMOVEABLE, $source), 'error');
            $xtc_remove_error = true;
        }
    } else {
        if (is_writeable($source)) {
            unlink($source);
        } else {
            $messageStack->add(sprintf(ERROR_FILE_NOT_REMOVEABLE, $source), 'error');
            $xtc_remove_error = true;
        }
    }
}

////
// Wrapper for constant() function
// Needed because its only available in PHP 4.0.4 and higher.
function xtc_constant($constant) {
    if (function_exists('constant')) {
        $temp = constant($constant);
    } else {
        eval("\$temp=$constant;");
    }
    return $temp;
}

////
// Output the tax percentage with optional padded decimals
function xtc_display_tax_value($value, $padding = TAX_DECIMAL_PLACES) {
    if (strpos($value, '.')) {
        $loop = true;
        while ($loop) {
            if (substr($value, -1) == '0') {
                $value = substr($value, 0, -1);
            } else {
                $loop = false;
                if (substr($value, -1) == '.') {
                    $value = substr($value, 0, -1);
                }
            }
        }
    }

    if ($padding > 0) {
        if ($decimal_pos = strpos($value, '.')) {
            $decimals = strlen(substr($value, ($decimal_pos + 1)));
            for ($i = $decimals; $i < $padding; $i++) {
                $value .= '0';
            }
        } else {
            $value .= '.';
            for ($i = 0; $i < $padding; $i++) {
                $value .= '0';
            }
        }
    }

    return $value;
}

function xtc_get_tax_class_title($tax_class_id) {
    if ($tax_class_id == '0') {
        return TEXT_NONE;
    } else {
        $classes_query = xtc_db_query("SELECT tax_class_title FROM " . TABLE_TAX_CLASS . " WHERE tax_class_id = '" . $tax_class_id . "'");
        $classes = xtc_db_fetch_array($classes_query);

        return $classes['tax_class_title'];
    }
}

function xtc_banner_image_extension() {
    if (function_exists('imagetypes')) {
        if (imagetypes() & IMG_PNG) {
            return 'png';
        } elseif (imagetypes() & IMG_JPG) {
            return 'jpg';
        } elseif (imagetypes() & IMG_GIF) {
            return 'gif';
        }
    } elseif (function_exists('imagecreateFROMpng') && function_exists('imagepng')) {
        return 'png';
    } elseif (function_exists('imagecreateFROMjpeg') && function_exists('imagejpeg')) {
        return 'jpg';
    } elseif (function_exists('imagecreateFROMgif') && function_exists('imagegif')) {
        return 'gif';
    }

    return false;
}

// Wrapper function for round()
function xtc_round($value, $precision) {
    return round($value, $precision);
}

// Calculates Tax rounding the result
// function xtc_calculate_tax($price, $tax) {
// global $currencies;
// return xtc_round($price * $tax / 100, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']);
// }

function xtc_call_function($function, $parameter, $object = '') {
    if (function_exists(call_user_func)) {
        if ($object == '') {
            return @call_user_func($function, $parameter);
        } else {
            return @call_user_func(array($object, $function), $parameter);
        }
    }
}

function xtc_get_zone_class_title($zone_class_id) {
    if ($zone_class_id == '0') {
        return TEXT_NONE;
    } else {
        $classes_query = xtc_db_query("SELECT geo_zone_name FROM " . TABLE_GEO_ZONES . " WHERE geo_zone_id = '" . $zone_class_id . "'");
        $classes = xtc_db_fetch_array($classes_query);

        return $classes['geo_zone_name'];
    }
}

function xtc_cfg_pull_down_template_sets() {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    if ($dir = opendir(DIR_FS_CATALOG . 'templates/')) {
        while (($templates = readdir($dir)) !== false) {
            if (is_dir(DIR_FS_CATALOG . 'templates/' . "//" . $templates) and ($templates != "CVS") and ($templates != "shopscripte") and ($templates != "admin") and ($templates != ".") and ($templates != "..")) {
                $templates_array[] = array('id' => $templates, 'text' => $templates);
            }
        }
        closedir($dir);
        sort($templates_array);
        return xtc_draw_pull_down_menu($name, $templates_array, CURRENT_TEMPLATE);
    }
}

function xtc_cfg_pull_down_trusted_shop_template() {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    if ($dir = opendir(DIR_FS_CATALOG . 'templates/' . CURRENT_TEMPLATE . '/boxes/trusted_shop/')) {
        while (($trusted_templates = readdir($dir)) !== false) {
            if (($trusted_templates != "CVS") and ($trusted_templates != ".") and ($trusted_templates != "..")) {
                $trusted_templates_array[] = array('id' => $trusted_templates, 'text' => $trusted_templates);
            }
        }
        closedir($dir);
        sort($trusted_templates_array);
        return xtc_draw_pull_down_menu($name, $trusted_templates_array, TRUSTED_SHOP_TEMPLATE);
    }
}

function xtc_cfg_pull_down_zone_classes($zone_class_id, $key = '') {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');

    $zone_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
    $zone_class_query = xtc_db_query("SELECT geo_zone_id, geo_zone_name FROM " . TABLE_GEO_ZONES . " order by geo_zone_name");
    while ($zone_class = xtc_db_fetch_array($zone_class_query)) {
        $zone_class_array[] = array('id' => $zone_class['geo_zone_id'], 'text' => $zone_class['geo_zone_name']);
    }

    return xtc_draw_pull_down_menu($name, $zone_class_array, $zone_class_id);
}

function xtc_cfg_pull_down_order_statuses($order_status_id, $key = '') {

    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');

    $statuses_array = array(array('id' => '1', 'text' => TEXT_DEFAULT));
    $statuses_query = xtc_db_query("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE language_id = '" . $_SESSION['languages_id'] . "' order by orders_status_name");
    while ($statuses = xtc_db_fetch_array($statuses_query)) {
        $statuses_array[] = array('id' => $statuses['orders_status_id'], 'text' => $statuses['orders_status_name']);
    }

    return xtc_draw_pull_down_menu($name, $statuses_array, $order_status_id);
}

function xtc_get_order_status_name($order_status_id, $language_id = '') {

    if ($order_status_id < 1)
        return TEXT_DEFAULT;

    if (!is_numeric($language_id))
        $language_id = $_SESSION['languages_id'];

    $status_query = xtc_db_query("SELECT orders_status_name FROM " . TABLE_ORDERS_STATUS . " WHERE orders_status_id = '" . $order_status_id . "' and language_id = '" . $language_id . "'");
    $status = xtc_db_fetch_array($status_query);

    return $status['orders_status_name'];
}

////
// Return a random value
function xtc_rand($min = null, $max = null) {
    static $seeded;

    if (!$seeded) {
        mt_srand((double) microtime() * 1000000);
        $seeded = true;
    }

    if (isset($min) && isset($max)) {
        if ($min >= $max) {
            return $min;
        } else {
            return mt_rand($min, $max);
        }
    } else {
        return mt_rand();
    }
}

// nl2br() prior PHP 4.2.0 did not convert linefeeds on all OSs (it only converted \n)
function xtc_convert_linefeeds($FROM, $to, $string) {
    if ((PHP_VERSION < "4.0.5") && is_array($FROM)) {
        return preg_replace('/(' . implode('|', $FROM) . ')/', $to, $string);
    } else {
        return str_replace($FROM, $to, $string);
    }
}

// Return all customers statuses for a specified language_id and return an array(array())
// Use it to make pull_down_menu, checkbox....
function xtc_get_customers_statuses() {

    $customers_statuses_array = array(array());
    $customers_statuses_query = xtc_db_query("SELECT customers_status_id, customers_status_name, customers_status_image, customers_status_discount, customers_status_ot_discount_flag, customers_status_ot_discount FROM " . TABLE_CUSTOMERS_STATUS . " WHERE language_id = '" . $_SESSION['languages_id'] . "' order by customers_status_id");
    $i = 1; // this is changed FROM 0 to 1 in cs v1.2
    while ($customers_statuses = xtc_db_fetch_array($customers_statuses_query)) {
        $i = $customers_statuses['customers_status_id'];
        $customers_statuses_array[$i] = array('id' => $customers_statuses['customers_status_id'], 'text' => $customers_statuses['customers_status_name'], 'csa_public' => $customers_statuses['customers_status_public'], 'csa_image' => $customers_statuses['customers_status_image'], 'csa_discount' => $customers_statuses['customers_status_discount'], 'csa_ot_discount_flag' => $customers_statuses['customers_status_ot_discount_flag'], 'csa_ot_discount' => $customers_statuses['customers_status_ot_discount'], 'csa_graduated_prices' => $customers_statuses['customers_status_graduated_prices']);
    }
    return $customers_statuses_array;
}

function xtc_get_customer_status($customers_id) {

    $customer_status_array = array();
    $customer_status_query = xtc_db_query("SELECT customers_status, member_flag, customers_status_name, customers_status_public, customers_status_image, customers_status_discount, customers_status_ot_discount_flag, customers_status_ot_discount, customers_status_graduated_prices  FROM " . TABLE_CUSTOMERS . " left join " . TABLE_CUSTOMERS_STATUS . " on customers_status = customers_status_id WHERE customers_id='" . $customers_id . "' and language_id = '" . $_SESSION['languages_id'] . "'");
    $customer_status_array = xtc_db_fetch_array($customer_status_query);
    return $customer_status_array;
}

function xtc_get_customers_status_name($customers_status_id, $language_id = '') {

    if (!$language_id)
        $language_id = $_SESSION['languages_id'];
    $customers_status_query = xtc_db_query("SELECT customers_status_name FROM " . TABLE_CUSTOMERS_STATUS . " WHERE customers_status_id = '" . $customers_status_id . "' and language_id = '" . $language_id . "'");
    $customers_status = xtc_db_fetch_array($customers_status_query);
    return $customers_status['customers_status_name'];
}

//to set customers status in admin for default value, newsletter, guest...
function xtc_cfg_pull_down_customers_status_list($customers_status_id, $key = '') {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    return xtc_draw_pull_down_menu($name, xtc_get_customers_statuses(), $customers_status_id);
}

// Function for collecting ip
// return all log info for a customer_id
function xtc_get_user_info($customer_id) {
    $user_info_array = xtc_db_query("SELECT customers_ip, customers_ip_date, customers_host, customers_advertiser, customers_referer_url FROM " . TABLE_CUSTOMERS_IP . " WHERE customers_id = '" . $customer_id . "'");
    return $user_info_array;
}

//---------------------------------------------------------------kommt wieder raus spaeter!!
function xtc_get_uploaded_file($filename) {
    if (isset($_FILES[$filename])) {
        $uploaded_file = array('name' => $_FILES[$filename]['name'], 'type' => $_FILES[$filename]['type'], 'size' => $_FILES[$filename]['size'], 'tmp_name' => $_FILES[$filename]['tmp_name']);
    } elseif (isset($_FILES[$filename])) {
        $uploaded_file = array('name' => $_FILES[$filename]['name'], 'type' => $_FILES[$filename]['type'], 'size' => $_FILES[$filename]['size'], 'tmp_name' => $_FILES[$filename]['tmp_name']);
    } else {
        $uploaded_file = array('name' => $GLOBALS[$filename . '_name'], 'type' => $GLOBALS[$filename . '_type'], 'size' => $GLOBALS[$filename . '_size'], 'tmp_name' => $GLOBALS[$filename]);
    }

    return $uploaded_file;
}

function get_group_price($group_id, $product_id) {
    // well, first try to get group price FROM database
    $group_price_query = xtc_db_query("SELECT personal_offer FROM " . TABLE_PERSONAL_OFFERS_BY . $group_id . " WHERE products_id = '" . $product_id . "' and quantity=1");
    $group_price_data = xtc_db_fetch_array($group_price_query);
    // if we found a price, everything is ok if not, we will create new entry
    // if there is no entry, create one. if there are more entries. keep one, dropp rest.
    if (!xtc_db_num_rows($group_price_query)) {
        xtc_db_query("INSERT INTO " . TABLE_PERSONAL_OFFERS_BY . $group_id . " (price_id, products_id, quantity, personal_offer) VALUES ('', '" . $product_id . "', '1', '0.00')");
        $group_price_query = xtc_db_query("SELECT personal_offer FROM " . TABLE_PERSONAL_OFFERS_BY . $group_id . " WHERE products_id = '" . $product_id . "' ORDER BY quantity ASC");
        $group_price_data = xtc_db_fetch_array($group_price_query);
    } else
    if (xtc_db_num_rows($group_price_query) > 1) {
        while ($data = xtc_db_fetch_array($group_price_query)) {
            $group_price_data['personal_offer'] = $data['personal_offer'];
        }
        xtc_db_query("DELETE FROM " . TABLE_PERSONAL_OFFERS_BY . $group_id . " WHERE products_id='" . $product_id . "' and quantity=1");
        xtc_db_query("INSERT INTO " . TABLE_PERSONAL_OFFERS_BY . $group_id . " (price_id, products_id, quantity, personal_offer) VALUES ('', '" . $product_id . "', '1', '" . $group_price_data['personal_offer'] . "')");
        $group_price_query = xtc_db_query("SELECT personal_offer FROM " . TABLE_PERSONAL_OFFERS_BY . $group_id . " WHERE products_id = '" . $product_id . "' ORDER BY quantity ASC");
        $group_price_data = xtc_db_fetch_array($group_price_query);
    }

    return $group_price_data['personal_offer'];
}

function format_price($price_string, $price_special, $currency, $allow_tax, $tax_rate) {
    // calculate currencies
    $currencies_query = xtc_db_query("SELECT
	                                          symbol_left,
	                                          symbol_right,
	                                          decimal_places,
	                                          value
	                                      FROM
	                                          " . TABLE_CURRENCIES . "
	                                      WHERE
	                                          code = '" . $currency . "'");
    $currencies_value = xtc_db_fetch_array($currencies_query);
    $currencies_data = array();
    $currencies_data = array('SYMBOL_LEFT' => $currencies_value['symbol_left'], 'SYMBOL_RIGHT' => $currencies_value['symbol_right'], 'DECIMAL_PLACES' => $currencies_value['decimal_places'], 'VALUE' => $currencies_value['value']);

    // round price
    if ($allow_tax == 1)
        $price_string = $price_string / ((100 + $tax_rate) / 100);
    $price_string = precision($price_string, $currencies_data['DECIMAL_PLACES']);
    if ($price_special == '1') {
        $price_string = $currencies_data['SYMBOL_LEFT'] . ' ' . $price_string . ' ' . $currencies_data['SYMBOL_RIGHT'];
    }
    return $price_string;
}

function precision($number, $places) {
    $number = number_format($number, $places, '.', '');
    return $number;
}

function xtc_get_lang_definition($search_lang, $lang_array, $modifier) {
    $search_lang = $search_lang . $modifier;
    return $lang_array[$search_lang];
}

function xtc_CheckExt($filename, $ext) {
    $passed = FALSE;
    $testExt = "\." . $ext . "$";
    if (preg_match('/' . $testExt . '/i', $filename)) {
        $passed = TRUE;
    }
    return $passed;
}

function xtc_get_status_users($status_id) {
    $status_query = xtc_db_query("SELECT count(customers_status) as count FROM " . TABLE_CUSTOMERS . " WHERE customers_status = '" . $status_id . "'");
    $status_data = xtc_db_fetch_array($status_query);
    return $status_data['count'];
}

function xtc_mkdirs($path, $perm) {

    if (is_dir($path)) {
        return true;
    } else {

        //$path=dirname($path);
        if (!mkdir($path, $perm))
            return false;
        mkdir($path, $perm);
        return true;
    }
}

function xtc_spaceUsed($dir) {
    if (is_dir($dir)) {
        if ($dh = opendir($dir)) {
            while (($file = readdir($dh)) !== false) {
                if (is_dir($dir . $file) && $file != '.' && $file != '..') {
                    xtc_spaceUsed($dir . $file . '/');
                } else {
                    $GLOBALS['total'] += filesize($dir . $file);
                }
            }
            closedir($dh);
        }
    }
}

function create_coupon_code($salt = "secret", $length = SECURITY_CODE_LENGTH) {
    $ccid = md5(uniqid("", "salt"));
    $ccid .= md5(uniqid("", "salt"));
    $ccid .= md5(uniqid("", "salt"));
    $ccid .= md5(uniqid("", "salt"));
    srand((double) microtime() * 1000000); // seed the random number generator
    $random_start = @ rand(0, (128 - $length));
    $good_result = 0;
    while ($good_result == 0) {
        $id1 = substr($ccid, $random_start, $length);
        $query = xtc_db_query("SELECT coupon_code FROM " . TABLE_COUPONS . " WHERE coupon_code = '" . $id1 . "'");
        if (xtc_db_num_rows($query) == 0)
            $good_result = 1;
    }
    return $id1;
}

// Update the Customers GV account
function xtc_gv_account_update($customer_id, $gv_id) {
    $customer_gv_query = xtc_db_query("SELECT amount FROM " . TABLE_COUPON_GV_CUSTOMER . " WHERE customer_id = '" . $customer_id . "'");
    $coupon_gv_query = xtc_db_query("SELECT coupon_amount FROM " . TABLE_COUPONS . " WHERE coupon_id = '" . $gv_id . "'");
    $coupon_gv = xtc_db_fetch_array($coupon_gv_query);
    if (xtc_db_num_rows($customer_gv_query) > 0) {
        $customer_gv = xtc_db_fetch_array($customer_gv_query);
        $new_gv_amount = $customer_gv['amount'] + $coupon_gv['coupon_amount'];
        $gv_query = xtc_db_query("update " . TABLE_COUPON_GV_CUSTOMER . " set amount = '" . $new_gv_amount . "' WHERE customer_id = '" . $customer_id . "'");
    } else {
        $gv_query = xtc_db_query("insert into " . TABLE_COUPON_GV_CUSTOMER . " (customer_id, amount) values ('" . $customer_id . "', '" . $coupon_gv['coupon_amount'] . "')");
    }
}

// Output a day/month/year dropdown SELECTor
function xtc_draw_date_SELECTor($prefix, $date = '') {
    $month_array = array();
    $month_array[1] = _JANUARY;
    $month_array[2] = _FEBRUARY;
    $month_array[3] = _MARCH;
    $month_array[4] = _APRIL;
    $month_array[5] = _MAY;
    $month_array[6] = _JUNE;
    $month_array[7] = _JULY;
    $month_array[8] = _AUGUST;
    $month_array[9] = _SEPTEMBER;
    $month_array[10] = _OCTOBER;
    $month_array[11] = _NOVEMBER;
    $month_array[12] = _DECEMBER;
    $usedate = getdate($date);
    $day = $usedate['mday'];
    $month = $usedate['mon'];
    $year = $usedate['year'];
    $date_SELECTor = '<SELECT name="' . $prefix . '_day">';
    for ($i = 1; $i < 32; $i++) {
        $date_SELECTor .= '<option value="' . $i . '"';
        if ($i == $day)
            $date_SELECTor .= 'SELECTed';
        $date_SELECTor .= '>' . $i . '</option>';
    }
    $date_SELECTor .= '</SELECT>';
    $date_SELECTor .= '<SELECT name="' . $prefix . '_month">';
    for ($i = 1; $i < 13; $i++) {
        $date_SELECTor .= '<option value="' . $i . '"';
        if ($i == $month)
            $date_SELECTor .= 'SELECTed';
        $date_SELECTor .= '>' . $month_array[$i] . '</option>';
    }
    $date_SELECTor .= '</SELECT>';
    $date_SELECTor .= '<SELECT name="' . $prefix . '_year">';
    for ($i = 2001; $i < 2019; $i++) {
        $date_SELECTor .= '<option value="' . $i . '"';
        if ($i == $year)
            $date_SELECTor .= 'SELECTed';
        $date_SELECTor .= '>' . $i . '</option>';
    }
    $date_SELECTor .= '</SELECT>';
    return $date_SELECTor;
}

function xtc_getDownloads() {
    require_once(DIR_FS_INC . 'xtc_format_filesize.inc.php');
    $files = array();

    $dir = DIR_FS_CATALOG . 'download/';
    if ($fp = opendir($dir)) {
        while (($file = readdir($fp)) !== false) {
            if (is_file($dir . $file) && $file != '.htaccess' && $file != 'Thumb.db' && $file != 'Thumbs.db' && $file != 'index.html') {
                $size = filesize($dir . $file);
                $files[] = array('id' => $file, 'text' => $file . ' | ' . xtc_format_filesize($size), 'size' => $size, 'date' => date("F d Y H:i:s.", filemtime($dir . $file)));
            }
        }
        closedir($fp);
        sort($files);
    }
    return $files;
}

function xtc_try_upload($file = '', $destination = '', $permissions = '777', $extensions = '') {
    $file_object = new upload($file, $destination, $permissions, $extensions);
    if ($file_object->filename != '')
        return $file_object;
    else
        return false;
}

function xtc_button($value, $type = 'submit', $parameter = '') {
    return '<input type="' . $type . '" class="button" onClick="this.blur();" value="' . $value . '" ' . $parameter . ' >';
}

function xtc_button_link($value, $href = 'javascript:void(null)', $parameter = '') {
    return '<a href="' . $href . '" class="button" onClick="this.blur()" ' . $parameter . ' >' . $value . '</a>';
}

//--------------------------------------------------------------------------------------Ende


function nc_get_products_attributes_id($products_id, $products_options, $products_options_values) {
    //parameter
    /*
      $products_options 				= 'Farbe';
      $products_options_values	= 'silber';
     */

    //needle
    $products_options_id = false;
    $products_options_values_id = false;

    $result = xtc_db_query('
		SELECT products_options_id
		FROM products_options
		WHERE
			products_options_name = "' . $products_options . '" AND
			language_id = "' . $_SESSION['languages_id'] . '" LIMIT 1;');
    if (xtc_db_num_rows($result) > 0) {
        $result = xtc_db_fetch_array($result);
        $products_options_id = $result['products_options_id'];
    }

    $result = xtc_db_query('
		SELECT
			pov.products_options_values_id AS products_options_values_id
		FROM
			products_options_values											pov,
			products_options_values_to_products_options	pov2po
		WHERE
			pov2po.products_options_id = "' . $products_options_id . '" AND
			pov2po.products_options_values_id = pov.products_options_values_id AND
			pov.products_options_values_name = "' . $products_options_values . '" AND
			pov.language_id = "' . $_SESSION['languages_id'] . '" LIMIT 1;');
    if (xtc_db_num_rows($result) > 0) {
        $result = xtc_db_fetch_array($result);
        $products_options_values_id = $result['products_options_values_id'];
    }

    if ($products_options_id === false || $products_options_values_id === false)
        return false;

    $result = xtc_db_query('
		SELECT products_attributes_id
		FROM products_attributes
		WHERE
			products_id = "' . $products_id . '" AND
			options_id = "' . $products_options_id . '" AND
			options_values_id = "' . $products_options_values_id . '"
	');
    if (xtc_db_num_rows($result) == 0)
        return false;

    $result = xtc_db_fetch_array($result);

    return $result['products_attributes_id'];
}

function xtc_draw_separator($img = '', $height = '', $width = '') {
    return '&nbsp;';
}
