VALUES ('$type')");
	$value = db_insert_id();

	if ($value < 1)
		trigger_error("Cannot generate unique id", E_USER_ERROR);

	db_query("DELETE FROM $sql_tbl[counters] WHERE type='$type' AND value<'$value'");

	return $value;
}

#
# Generate SQL-query relations
#
function func_generate_joins($joins, $parent = false) {
	$str = '';

	foreach ($joins as $jname => $j) {
		if ((!empty($parent) && $parent != $j['parent']) || (empty($parent) && !empty($j['parent'])))
###################
# NEVER CHANGE THE SETTINGS BELOW THIS LINE MANUALLY
################################################################################

#
# The variable $blowfish_key contains your Blowfish encryption key automatically
# generated by X-Cart during installation. This key is used to encrypt all the
# sensitive data in your store including user passwords, credit card data, etc. 
#
# NEVER try to change your Blowfish encryption key by editing the value  of the
# $blowfish_key variable in this file: your data is already encrypted with this
# key and X-Cart needs exactly the same key to be able to decrypt it. Changing
IOUS   COPYRIGHTS   AND |
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
-------------------------------------------------------------+
\*****************************************************************************/

#
# $Id: config.php,v 1.5.2.5 2007/03/22 13:55:03 svowl Exp $
#

if ( !defined('XCART_START') ) { header("Location: ../../"); die("Access denied"); }
#
# Global definitions for Wholesale Trading module
#

if (defined("IS_IMPORT")) {
	$modules_import_specification['WHOLESALE_PRICES'] = array(
		"script"		=> "/modules/Wholesale_Trading/import.php",
		"permissions"	=> "AP",
		"need_provider"	=> true,
		"parent"		=> "PRODUCTS",
		"export_sql"	=> "SELECT productid FROM $sql_tbl[pricing] WHERE (quantity > 1 OR membershipid != 0) GROUP BY productid",
		"table"         => "pricing",
		"key_field"     => "productid",
		"orderby"		=> 100,
		"finalize"		=> true,
		"columns"		=> array(
			"productid"		=> array(
				"type"		=> "N",
				"is_key"	=> true,
				"default"	=> 0),
			"productcode"	=> array(
				"is_key"	=> true),
			"product"		=> array(
				"is_key"    => true),
			"variantcode"	=> array(
				"is_key"	=> true),
			"quantity"		=> array(
				"array"		=> true,
				"required"	=> true,
				"type"		=> "N"),
count"		=> array(
				"type"		=> "N",
				"default"	=> 0.00),
			"coupon_type"	=> array(
				"required"	=> true),
			"productid"		=> array(
				"type"		=> "N",
				"default"	=> 0),
			"productcode"	=> array(),
			"product"		=> array(),
			"categoryid"	=> array(
				"type"		=> "N",
				"default"	=> 0),
			"category"		=> array(),
			"recursive"		=> array(
				"type"		=> "B"),
		"import_note"			=> "txt_import_note_products_extra_fields_values",
		"onstartimportsection"	=> "func_ef_before_import",
		"oninitexport"			=> "func_ef_init_export",
		"oninitimport"			=> "func_ef_init_import",
		"export_sql"			=> "SELECT $sql_tbl[extra_field_values].productid FROM $sql_tbl[extra_fields], $sql_tbl[extra_field_values] WHERE $sql_tbl[extra_fields].fieldid = $sql_tbl[extra_field_values].fieldid GROUP BY $sql_tbl[extra_field_values].productid",
        "table"         => "extra_field_values",
        "key_field"     => "productid",
		"columns"				=> array(
			"productid"				=> array(
				"type"					=> "N",
				"is_key"				=> true,
				"default"				=> 0),
			"productcode"			=> array(
				"is_key"				=> true),
			"product"				=> array(
				"is_key"    			=> true),
		)
	);

}
if (defined("TOOLS")) {
	$tbl_keys["extra_fields.provider"] = array(
		"keys" => array("extra_fields.provider" => "customers.login"),
iftcerts]",
		"table"			=> "giftcerts",
		"key_field"		=> "gcid",
		"orderby"		=> 10,
		"columns"		=> array(
			"gcid"					=> array(
				"required"	=> true),
			"orderid"				=> array(
				"type"		=> "N"),
			"purchaser"				=> array(
				"required"	=> true),
			"recipient"				=> array(
				"required"  => true),
			"send_via"				=> array(
				"type"		=> "E",
				"variants"	=> array("E","P"),
				"default"	=> "E"),
			"recipient_email"		=> array(),
			"recipient_firstname"	=> array(),
			"recipient_lastname"	=> array(),
			"recipient_address"		=> array(),
e")
	);
	$tbl_keys["variants.productid"] = array(
		"keys" => array("variants.productid" => "products.productid"),
		"fields" => array("productcode")
	);
	$tbl_keys["variant_items.variantid"] = array(
		"keys" => array("variant_items.variantid" => "variants.variantid"),
		"fields" => array("optionid")
	);
	$tbl_keys["variant_items.optionid"] = array(
		"keys" => array("variant_items.optionid" => "class_options.optionid"),
		"fields" => array("variantid")
	);
	$tbl_keys["images_W.id"] = array(
		"keys" => array("images_W.id" => "variants.variantid"),
		"fields" => array("imageid")
	);
	$tbl_keys["pricing.variants"] = array(
FTWARE.  VARIOUS   COPYRIGHTS   AND |
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
HIS |
| AGREEMENT, DO  NOT INSTALL OR USE THE SOFTWARE.  VARIOUS   COPYRIGHTS   AND |
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
********************************************************/

#
# $Id: config.php,v 1.6.2.2 2007/03/22 13:54:42 svowl Exp $
#

if ( !defined('XCART_START') ) { header("Location: ../../"); die("Access denied"); }
#
# Global definitions for Customer Reviews module
#

if (defined("IS_IMPORT")) {
	$modules_import_specification['CUSTOMER_REVIEWS'] = array(
		"script"		=> "/modules/Customer_Reviews/import.php",
		"permissions"	=> "AP",
		"need_provider"	=> true,
		"parent"		=> "PRODUCTS",
		"export_sql" 	=> "SELECT productid FROM $sql_tbl[product_reviews]",
		"table"         => "product_reviews",
		"key_field"     => "productid",
		"columns"		=> array(
			"productid"		=> array(
				"type"		=> "N",
				"is_key"	=> true,
				"default"	=> 0),
			"productcode"	=> array(
				"is_key"	=> true),
			"product"		=> array(
				"is_key"    => true),
			"email"			=> array(
				"required"  => true,
				"array"	=> true),
			"message"		=> array(
				"required"  => true,
				"array"		=> true)
		)
	);
}

if (defined("TOOLS")) {
	$tbl_keys["product_votes.productid"] = array(
ig["Shipping"]["realtime_shipping"] == "Y" and $config["Shipping"]["use_intershipper"] != "Y") {
	$insert_trademark = true;
	$smarty->assign("insert_trademark", 1);
	$mail_smarty->assign("insert_trademark", 1);
}
else
	$insert_trademark = false;

HIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
ANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |

| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
G, |
| COPYING   OR   OTHERWISE   USING   THE   SOFTWARE,  YOU  AND  YOUR  COMPANY |
| (COLLECTIVELY,  "YOU")  ARE  ACCEPTING  AND AGREEING  TO  THE TERMS OF THIS |
| LICENSE   AGREEMENT.   IF  YOU    ARE  NOT  WILLING   TO  BE  BOUND BY THIS |
| AGREEMENT, DO  NOT INSTALL OR USE THE SOFTWARE.  VARIOUS   COPYRIGHTS   AND |
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
EEING  TO  THE TERMS OF THIS |
| LICENSE   AGREEMENT.   IF  YOU    ARE  NOT  WILLING   TO  BE  BOUND BY THIS |
| AGREEMENT, DO  NOT INSTALL OR USE THE SOFTWARE.  VARIOUS   COPYRIGHTS   AND |
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |
NY |
| (COLLECTIVELY,  "YOU")  ARE  ACCEPTING  AND AGREEING  TO  THE TERMS OF THIS |
| LICENSE   AGREEMENT.   IF  YOU    ARE  NOT  WILLING   TO  BE  BOUND BY THIS |
| AGREEMENT, DO  NOT INSTALL OR USE THE SOFTWARE.  VARIOUS   COPYRIGHTS   AND |
| OTHER   INTELLECTUAL   PROPERTY   RIGHTS    PROTECT   THE   SOFTWARE.  THIS |
| AGREEMENT IS A LICENSE AGREEMENT THAT GIVES  YOU  LIMITED  RIGHTS   TO  USE |
| THE  SOFTWARE   AND  NOT  AN  AGREEMENT  FOR SALE OR FOR  TRANSFER OF TITLE.|
| THE AUTHOR RETAINS ALL RIGHTS NOT EXPRESSLY GRANTED BY THIS AGREEMENT.      |