ÿØÿà JFIF    ÿÛ „ ( %!1!%*+...983,7(-.- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `Loaded66` -- -- -------------------------------------------------------- -- -- Table structure for table `address_book` -- CREATE TABLE `address_book` ( `address_book_id` int(11) NOT NULL AUTO_INCREMENT, `customers_id` int(11) NOT NULL DEFAULT '0', `entry_gender` char(1) NOT NULL DEFAULT '', `entry_company` varchar(255) DEFAULT NULL, `entry_company_tax_id` varchar(255) DEFAULT NULL, `entry_firstname` varchar(100) NOT NULL DEFAULT '', `entry_lastname` varchar(100) NOT NULL DEFAULT '', `entry_street_address` varchar(255) NOT NULL DEFAULT '', `entry_suburb` varchar(100) DEFAULT NULL, `entry_postcode` varchar(10) NOT NULL DEFAULT '', `entry_city` varchar(100) NOT NULL DEFAULT '', `entry_state` varchar(100) DEFAULT NULL, `entry_country_id` int(11) NOT NULL DEFAULT '0', `entry_zone_id` int(11) NOT NULL DEFAULT '0', `entry_telephone` varchar(100) NOT NULL DEFAULT '', `entry_fax` varchar(100) NOT NULL DEFAULT '', `entry_email_address` varchar(96) NOT NULL DEFAULT '', PRIMARY KEY (`address_book_id`), KEY `idx_address_book_customers_id` (`customers_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `address_book` -- INSERT INTO `address_book` VALUES (1, 1, 'm', 'Loaded Commerce, LLC', '', 'Sal', 'Iozzia', '1211 CR 436', '', '33538', 'Panasoffkee', '', 223, 18, '800.609.2141', '', 'sal@loadedcommerce.com'); -- -------------------------------------------------------- -- -- Table structure for table `address_format` -- CREATE TABLE `address_format` ( `address_format_id` int(11) NOT NULL AUTO_INCREMENT, `address_format` varchar(128) NOT NULL DEFAULT '', `address_summary` varchar(48) NOT NULL DEFAULT '', PRIMARY KEY (`address_format_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- Dumping data for table `address_format` -- INSERT INTO `address_format` VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country'), (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country'), (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country'), (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'), (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country'), (6, '$firstname $lastname$cr$streets$cr$city$cr$postcode$cr$country', '$city / $country'), (7, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$country', '$city / $country'), (8, '$firstname $lastname$cr$streets$cr$city $postcode$cr$country', '$city / $country'), (9, '$firstname $lastname$cr$streets$cr$postcode $city $state$cr$country', '$city / $country'), (10, '$firstname $lastname$cr$streets$cr$city$cr$postcode $country', '$city / $country'), (11, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country', '$city / $country'), (12, '$firstname $lastname$cr$streets$cr$city$cr$country $postcode', '$city / $country'); -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `admin_id` int(11) NOT NULL AUTO_INCREMENT, `admin_groups_id` int(11) DEFAULT NULL, `admin_firstname` varchar(100) NOT NULL DEFAULT '', `admin_lastname` varchar(100) DEFAULT NULL, `admin_email_address` varchar(96) NOT NULL DEFAULT '', `admin_password` varchar(40) NOT NULL DEFAULT '', `admin_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `admin_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `admin_logdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `admin_lognum` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`admin_id`), UNIQUE KEY `admin_email_address` (`admin_email_address`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `admin` -- INSERT INTO `admin` VALUES (1, 1, '[[admin_fname]]', '[[admin_lname]]', '[[admin_email]]', '[[admin_pass]]', '[[regtime]]', '[[regtime]]', '0000-00-00 00:00:00', 0); -- -------------------------------------------------------- -- -- Table structure for table `admin_files` -- CREATE TABLE `admin_files` ( `admin_files_id` int(11) NOT NULL AUTO_INCREMENT, `admin_files_name` varchar(255) NOT NULL DEFAULT '', `admin_files_is_boxes` tinyint(5) NOT NULL DEFAULT '0', `admin_files_to_boxes` int(11) NOT NULL DEFAULT '0', `admin_groups_id` set('1') NOT NULL DEFAULT '1', `query_string` varchar(255) NOT NULL DEFAULT '', `status` tinyint(4) NOT NULL DEFAULT '1', `visible` tinyint(4) NOT NULL DEFAULT '1', `sort` int(11) NOT NULL DEFAULT '0', `sub_section` tinyint(4) NOT NULL DEFAULT '0', `fa_icon_name` varchar(100) NOT NULL DEFAULT '', `constant_name` varchar(100) NOT NULL DEFAULT '', `function_name` varchar(100) NOT NULL DEFAULT '', `admin_related_files` text NOT NULL, `addon_name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`admin_files_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2111 ; -- -- Dumping data for table `admin_files` -- INSERT INTO `admin_files` VALUES (1, 'administrator.php', 1, 0, '1', '', 1, 1, 0, 0, 'fa-user', 'BOX_HEADING_ADMINISTRATOR', '', '', ''), (3, 'catalog.php', 1, 0, '1', '', 1, 1, 2, 0, 'fa-tasks', 'BOX_HEADING_CATALOG', '', '', ''), (4, 'modules.php', 1, 0, '1', '', 1, 1, 12, 0, 'fa-cubes', 'BOX_HEADING_MODULES', '', '', ''), (5, 'customers.php', 1, 0, '1', '', 1, 1, 3, 0, 'fa-users', 'BOX_HEADING_CUSTOMERS', '', '', ''), (6, 'taxes.php', 1, 0, '1', '', 1, 1, 13, 0, 'fa-bank', 'BOX_HEADING_LOCATION_AND_TAXES', '', '', ''), (7, 'localization.php', 1, 0, '1', '', 1, 1, 14, 0, 'fa-language', 'BOX_HEADING_LOCALIZATION', '', '', ''), (8, 'reports.php', 1, 0, '1', '', 1, 1, 6, 0, 'fa-bar-chart-o', 'BOX_HEADING_REPORTS', '', '', ''), (9, 'tools.php', 1, 0, '1', '', 1, 1, 15, 0, 'fa-wrench', 'BOX_HEADING_TOOLS', '', '', ''), (10, 'design_controls.php', 1, 0, '1', '', 1, 1, 10, 0, 'fa-archive', 'BOX_HEADING_DESIGN_CONTROLS', '', '', ''), (11, 'gv_admin.php', 1, 0, '1', '', 1, 1, 5, 0, 'fa-gift', 'BOX_HEADING_GV_ADMIN', '', '', ''), (12, 'links.php', 1, 0, '1', '', 1, 1, 11, 0, 'fa-external-link-square', 'BOX_HEADING_LINKS', '', '', ''), (15, 'data.php', 1, 0, '1', '', 1, 1, 7, 0, 'fa-database', 'BOX_HEADING_DATA', '', '', ''), (16, 'articles.php', 1, 0, '1', '', 1, 1, 9, 0, 'fa-book', 'BOX_CDS_ARTICLES', '', '', ''), (19, 'marketing.php', 1, 0, '1', '', 1, 1, 4, 0, 'fa-signal', 'BOX_HEADING_MARKETING', '', '', ''), (20, 'information.php', 1, 0, '1', '', 1, 1, 8, 0, 'fa-info', 'BOX_CDS_HEADING', '', '', ''), (100, 'admin_members.php', 0, 1, '1', 'selected_box=administrator§ion=admin_members', 1, 1, 0, 0, '', 'BOX_ADMINISTRATOR_MEMBERS', '', '', ''), (101, 'admin_files.php', 0, 1, '1', 'cID=1&selected_box=administrator§ion=menu_file_access', 1, 1, 3, 0, '', 'BOX_ADMINISTRATOR_BOXES', '', '', ''), (102, 'admin_account.php', 0, 1, '1', 'selected_box=administrator§ion=update_account', 1, 1, 2, 0, '', 'BOX_ADMINISTRATOR_ACCOUNT_UPDATE', '', '', ''), (103, 'admin_members.php', 0, 1, '1', 'gID=groups&selected_box=administrator§ion=admin_groups', 1, 1, 1, 0, '', 'BOX_ADMINISTRATOR_GROUPS', '', '', ''), (2002, 'configuration.php', 1, 0, '1', '', 1, 1, 1, 0, 'fa-gear', 'BOX_HEADING_CONFIGURATION', 'tep_configuration_menu', '', ''), (300, 'categories.php', 0, 3, '1', 'selected_box=catalog§ion=categories', 1, 1, 4, 0, '', 'BOX_CATALOG_CATEGORIES_PRODUCTS', '', '', ''), (301, 'products_attributes.php', 0, 3, '1', 'selected_box=catalog§ion=products_attributes', 1, 1, 5, 0, '', 'BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES', '', '', ''), (302, 'manufacturers.php', 0, 3, '1', 'selected_box=catalog§ion=manufacturers', 1, 1, 6, 0, '', 'BOX_CATALOG_MANUFACTURERS', '', '', ''), (304, 'reviews.php', 0, 3, '1', 'selected_box=catalog§ion=reviews', 1, 1, 7, 0, '', 'BOX_CATALOG_REVIEWS', '', '', ''), (305, 'shopbyprice.php', 0, 3, '1', 'selected_box=catalog§ion=shopbyprice', 1, 1, 8, 0, '', 'BOX_CATALOG_SHOP_BY_PRICE', '', '', ''), (306, 'products_expected.php', 0, 3, '1', 'selected_box=catalog§ion=products_expected', 1, 1, 11, 0, '', 'BOX_CATALOG_PRODUCTS_EXPECTED', '', '', ''), (307, 'xsell_products.php', 0, 3, '1', 'selected_box=catalog§ion=xsell_products', 1, 1, 9, 0, '', 'BOX_CATALOG_XSELL_PRODUCTS', '', '', ''), (308, 'define_mainpage.php', 0, 20, '1', 'selected_box=information', 1, 1, 56, 0, '', 'BOX_CATALOG_DEFINE_MAINPAGE', '', '', ''), (309, 'salemaker.php', 0, 2003, '1', '', 1, 1, 97, 0, '', '', '', '', ''), (310, 'listcategories.php', 0, 2003, '1', '', 1, 1, 114, 0, '', '', '', '', ''), (313, 'featured.php', 0, 3, '1', 'selected_box=catalog§ion=featured', 1, 1, 10, 0, '', 'BOX_CATALOG_FEATURED', '', '', ''), (314, 'salemaker_info.php', 0, 2003, '1', '', 1, 1, 115, 0, '', '', '', '', ''), (315, 'epconfigure.php', 0, 2003, '1', '', 1, 1, 116, 0, '', '', '', '', ''), (316, 'products_multi.php', 0, 2003, '1', '', 1, 1, 117, 0, '', '', '', '', ''), (400, 'modules.php', 0, 4, '1', 'set=payment', 1, 1, 76, 0, '', 'BOX_MODULES_PAYMENT', '', '', ''), (500, 'orders.php', 0, 5, '1', 'selected_box=customers§ion=order', 1, 1, 12, 0, '', 'BOX_CUSTOMERS_ORDERS', '', '', ''), (501, 'cre_marketplace.php', 0, 5, '1', 'selected_box=customers§ion=marketplace', 1, 1, 20, 1, '', 'BOX_CRE_MARKETPLACE', '', '', ''), (502, 'paypal.php', 0, 5, '1', '', 1, 1, 16, 0, '', 'BOX_CUSTOMERS_PAYPAL', '', '', ''), (503, 'edit_orders.php', 0, 2003, '1', '', 1, 1, 118, 0, '', '', '', '', ''), (504, 'create_account_success.php', 0, 2003, '1', '', 1, 1, 119, 0, '', '', '', '', ''), (505, 'create_account_process.php', 0, 2003, '1', '', 1, 1, 120, 0, '', '', '', '', ''), (506, 'create_order_admin.php', 0, 5, '1', 'selected_box=customers§ion=orders_admin', 1, 1, 15, 0, '', 'BOX_CREATE_ORDERS_ADMIN', '', '', ''), (507, 'create_account.php', 0, 5, '1', 'selected_box=customers§ion=create_account', 1, 1, 19, 1, '', 'BOX_MANUAL_ORDER_CREATE_ACCOUNT', '', '', ''), (508, 'create_order_process.php', 0, 2003, '1', '', 1, 1, 121, 0, '', '', '', '', ''), (509, 'account_details.php', 0, 2003, '1', '', 1, 1, 122, 0, '', '', '', '', ''), (510, 'ipn_test_panel.php', 0, 2003, '1', '', 1, 1, 123, 0, '', '', '', '', ''), (511, '', 0, 5, '1', '', 1, 1, 17, 1, '', 'BOX_CUSTOMERS_MENU', '', '', ''), (512, 'members.php', 0, 2003, '1', '', 1, 1, 124, 0, '', '', '', '', ''), (513, 'create_order.php', 0, 5, '1', 'selected_box=customers§ion=create_order', 1, 1, 14, 0, '', 'BOX_MANUAL_ORDER_CREATE_ORDER', '', '', ''), (514, 'create_order_payment.php', 0, 2003, '1', '', 1, 1, 125, 0, '', '', '', '', ''), (515, 'create_order_shipping.php', 0, 2003, '1', '', 1, 1, 126, 0, '', '', '', '', ''), (517, 'customers.php', 0, 5, '1', 'selected_box=customers§ion=customer', 1, 1, 18, 1, '', 'BOX_CUSTOMERS_CUSTOMERS', '', '', ''), (600, 'countries.php', 0, 6, '1', '', 1, 1, 81, 0, '', 'BOX_TAXES_COUNTRIES', '', '', ''), (601, 'zones.php', 0, 6, '1', '', 1, 1, 82, 0, '', 'BOX_TAXES_ZONES', '', '', ''), (602, 'geo_zones.php', 0, 6, '1', '', 1, 1, 83, 0, '', 'BOX_TAXES_GEO_ZONES', '', '', ''), (603, 'tax_classes.php', 0, 6, '1', '', 1, 1, 84, 0, '', 'BOX_TAXES_TAX_CLASSES', '', '', ''), (604, 'tax_rates.php', 0, 6, '1', '', 1, 1, 85, 0, '', 'BOX_TAXES_TAX_RATES', '', '', ''), (700, 'currencies.php', 0, 7, '1', '', 1, 1, 86, 0, '', 'BOX_LOCALIZATION_CURRENCIES', '', '', ''), (701, 'languages.php', 0, 7, '1', '', 1, 1, 87, 0, '', 'BOX_LOCALIZATION_LANGUAGES', '', '', ''), (702, 'orders_status.php', 0, 7, '1', '', 1, 1, 88, 0, '', 'BOX_LOCALIZATION_ORDERS_STATUS', '', '', ''), (800, 'stats_products_viewed.php', 0, 8, '1', 'selected_box=reports§ion=reports_products_viewed', 1, 1, 29, 0, '', 'BOX_REPORTS_PRODUCTS_VIEWED', '', '', ''), (801, 'stats_products_purchased.php', 0, 8, '1', 'selected_box=reports§ion=reports_products_purchased', 1, 1, 30, 0, '', 'BOX_REPORTS_PRODUCTS_PURCHASED', '', '', ''), (802, 'stats_customers.php', 0, 8, '1', 'selected_box=reports§ion=reports_orders_total', 1, 1, 34, 0, '', 'BOX_REPORTS_ORDERS_TOTAL', '', '', ''), (803, 'stats_monthly_sales.php', 0, 8, '1', 'selected_box=reports§ion=reports_monthly_sales', 1, 1, 41, 0, '', 'BOX_REPORTS_MONTHLY_SALES', '', '', ''), (804, 'orderlist.php', 0, 2003, '1', '', 1, 1, 113, 0, '', '', '', '', ''), (805, 'stats_sales_report2.php', 0, 8, '1', 'selected_box=reports§ion=reports_sales_report', 1, 1, 36, 0, '', 'BOX_REPORTS_SALES_REPORT2', '', '', ''), (806, 'stats_customers_orders.php', 0, 8, '1', 'selected_box=reports§ion=reports_orders', 1, 1, 33, 0, '', 'BOX_REPORTS_CUSTOMERS_ORDERS', '', '', ''), (807, 'stats_daily_products_sales_report.php', 0, 8, '1', 'selected_box=reports§ion=reports_daily_orders', 1, 1, 37, 0, '', 'BOX_REPORTS_DAILY_PRODUCTS_ORDERS', '', '', ''), (808, 'stats_wishlist.php', 0, 8, '1', 'selected_box=reports§ion=reports_wishlist', 1, 1, 32, 0, '', 'BOX_REPORTS_CUSTOMER_WISHLIST', '', '', ''), (809, 'stats_articles_viewed.php', 0, 8, '1', 'selected_box=reports§ion=reports_articles_viewed', 1, 1, 31, 0, '', 'BOX_REPORTS_ARTICLES_VIEWED', '', '', ''), (810, 'stats_products_notifications.php', 0, 8, '1', 'selected_box=reports§ion=reports_product_notifications', 1, 1, 39, 0, '', 'BOX_REPORTS_PRODUCTS_NOTIFICATIONS', '', '', ''), (811, 'stats_not_valid_users.php', 0, 8, '1', 'selected_box=reports§ion=reports_invalid_user', 1, 1, 35, 0, '', 'BOX_REPORTS_NOT_VALID_USER', '', '', ''), (812, 'stats_low_stock.php', 0, 8, '1', 'selected_box=reports§ion=reports_low_stock', 1, 1, 40, 0, '', 'BOX_LOW_STOCK_REPORT', '', '', ''), (900, 'backup.php', 0, 9, '1', '', 1, 1, 90, 0, '', 'BOX_TOOLS_BACKUP', '', '', ''), (901, 'cache.php', 0, 9, '1', '', 1, 1, 91, 0, '', 'BOX_TOOLS_CACHE', '', '', ''), (902, 'define_language.php', 0, 9, '1', '', 1, 1, 92, 0, '', 'BOX_TOOLS_DEFINE_LANGUAGE', '', '', ''), (903, 'mail.php', 0, 9, '1', '', 1, 1, 94, 0, '', 'BOX_TOOLS_MAIL', '', '', ''), (905, 'server_info.php', 0, 9, '1', '', 1, 1, 95, 0, '', 'BOX_TOOLS_SERVER_INFO', '', '', ''), (906, 'whos_online.php', 0, 9, '1', '', 1, 1, 96, 0, '', 'BOX_TOOLS_WHOS_ONLINE', '', '', ''), (907, 'backup_mysql.php', 0, 9, '1', '', 1, 1, 89, 0, '', 'BOX_TOOLS_MYSQL_BACKUP', '', '', ''), (909, 'edit_textdata.php', 0, 2003, '1', '', 1, 1, 112, 0, '', '', '', '', ''), (910, 'edit_textdata_help.php', 0, 2003, '1', '', 1, 1, 111, 0, '', '', '', '', ''), (911, 'email_subjects.php', 0, 9, '1', '', 1, 1, 93, 0, '', 'BOX_TOOLS_EMAIL_SUBJECTS', '', '', ''), (912, 'check_lang.php', 0, 2003, '1', '', 1, 1, 98, 0, '', '', '', '', ''), (1000, 'infobox_configuration.php', 0, 10, '1', 'gID={template_id}', 1, 1, 72, 0, '', 'BOX_HEADING_BOXES_ADMIN', '', '', ''), (1001, 'template_configuration.php', 0, 10, '1', 'cID={template_id}', 1, 1, 70, 0, '', 'BOX_HEADING_TEMPLATE_CONFIGURATION', '', '', ''), (1002, 'header_tags_fill_tags.php', 0, 10, '1', '', 1, 1, 65, 0, '', 'BOX_HEADER_TAGS_FILL_TAGS', '', '', ''), (1003, 'header_tags_english.php', 0, 10, '1', '', 1, 1, 64, 0, '', 'BOX_HEADER_TAGS_ENGLISH', '', '', ''), (1004, 'header_tags_controller.php', 0, 10, '1', '', 1, 1, 63, 0, '', 'BOX_HEADER_TAGS_ADD_A_PAGE', '', '', ''), (1005, 'template_admin.php', 0, 10, '1', '', 1, 1, 69, 0, '', 'BOX_HEADING_TEMPLATE_MANAGEMENT', '', '', ''), (1006, 'header_tags_popup_help.php', 0, 2003, '1', '', 1, 1, 99, 0, '', '', '', '', ''), (1007, 'branding_manager.php', 0, 10, '1', '', 1, 1, 67, 0, '', 'BOX_HEADING_BRANDING_MANAGER', '', '', ''), (1100, 'coupon_admin.php', 0, 11, '1', 'selected_box=gv_admin§ion=coupon_admin', 1, 1, 24, 0, '', 'BOX_COUPON_ADMIN', '', '', ''), (1101, 'gv_queue.php', 0, 11, '1', 'selected_box=gv_admin§ion=gv_queue', 1, 1, 26, 0, '', 'BOX_GV_ADMIN_QUEUE', '', '', ''), (1102, 'gv_mail.php', 0, 11, '1', 'selected_box=gv_admin§ion=gv_email', 1, 1, 27, 0, '', 'BOX_GV_ADMIN_MAIL', '', '', ''), (1103, 'gv_sent.php', 0, 11, '1', 'selected_box=gv_admin§ion=gv_sent', 1, 1, 28, 0, '', 'BOX_GV_ADMIN_SENT', '', '', ''), (1104, 'coupon_restrict.php', 0, 2003, '1', '', 1, 1, 100, 0, '', '', '', '', ''), (1105, 'validcategories.php', 0, 2003, '1', '', 1, 1, 101, 0, '', '', '', '', ''), (1106, 'validproducts.php', 0, 2003, '1', '', 1, 1, 102, 0, '', '', '', '', ''), (1107, 'listproducts.php', 0, 2003, '1', '', 1, 1, 103, 0, '', '', '', '', ''), (1108, 'gv_report.php', 0, 11, '1', 'selected_box=gv_admin§ion=gv_report', 1, 1, 25, 0, '', 'BOX_GV_REPORT', '', '', ''), (1109, 'treeview.php', 0, 2003, '1', '', 1, 1, 104, 0, '', '', '', '', ''), (1200, 'links.php', 0, 12, '1', '', 1, 1, 73, 0, '', 'BOX_LINKS_LINKS', '', '', ''), (1201, 'link_categories.php', 0, 12, '1', '', 1, 1, 74, 0, '', 'BOX_LINKS_LINK_CATEGORIES', '', '', ''), (1202, 'links_contact.php', 0, 12, '1', '', 1, 1, 75, 0, '', 'BOX_LINKS_LINKS_CONTACT', '', '', ''), (1400, 'faq_manager.php', 0, 20, '1', 'selected_box=information', 1, 1, 54, 0, '', 'BOX_FAQ_MANAGER', '', '', ''), (1405, 'faq_categories.php', 0, 20, '1', 'selected_box=information', 1, 1, 55, 0, '', 'BOX_FAQ_CATEGORIES', '', '', ''), (1500, 'data.php', 0, 2003, '1', '', 1, 1, 105, 0, '', '', '', '', ''), (1501, 'data_admin.php', 0, 2003, '1', '', 1, 1, 106, 0, '', '', '', '', ''), (1502, 'data_help.php', 0, 15, '1', '', 1, 1, 49, 2, '', 'BOX_DATA_HELP', '', '', ''), (1503, 'easypopulate_basic_export.php', 0, 15, '1', '', 1, 1, 46, 1, '', 'BOX_DATA_EASYPOPULATE_BASIC_EXPORT', '', '', ''), (1504, 'easypopulate_basic_import.php', 0, 15, '1', '', 1, 1, 47, 1, '', 'BOX_DATA_EASYPOPULATE_BASIC_IMPORT', '', '', ''), (1505, 'easypopulate_export.php', 0, 15, '1', '', 1, 1, 43, 0, '', 'BOX_DATA_EASYPOPULATE_EXPORT', '', '', ''), (1506, 'easypopulate_import.php', 0, 15, '1', '', 1, 1, 44, 0, '', 'BOX_DATA_EASYPOPULATE_IMPORT', '', '', ''), (1507, 'popup_data_help.php', 0, 2003, '1', '', 1, 1, 107, 0, '', '', '', '', ''), (1508, 'popup_ep_help.php', 0, 2003, '1', '', 1, 1, 108, 0, '', '', '', '', ''), (1509, 'google.php', 0, 2003, '1', '', 1, 1, 109, 0, '', '', '', '', ''), (1510, '', 0, 15, '1', '', 1, 1, 48, 0, '', 'BOX_DATA', '', '', ''), (1511, '', 0, 15, '1', '', 1, 1, 45, 0, '', 'BOX_DATA_EASYPOPULATE_BASIC', '', '', ''), (1512, '', 0, 15, '1', '', 1, 1, 42, 0, '', 'BOX_DATA_EASYPOPULATE', '', '', ''), (1513, 'google_pre1.php', 0, 2003, '1', '', 1, 1, 110, 0, '', '', '', '', ''), (1600, 'authors.php', 0, 16, '1', '', 1, 1, 59, 0, '', 'BOX_ARTICLES_AUTHORS', '', '', ''), (1601, 'articles_xsell.php', 0, 16, '1', '', 1, 1, 61, 0, '', 'BOX_ARTICLES_XSELL', '', '', ''), (1602, 'articles_config.php', 0, 16, '1', '', 1, 1, 58, 0, '', 'BOX_ARTICLES_CONFIG', '', '', ''), (1603, 'articles.php', 0, 16, '1', '', 1, 1, 57, 0, '', 'BOX_TOPICS_ARTICLES', '', '', ''), (1604, 'article_reviews.php', 0, 16, '1', '', 1, 1, 60, 0, '', 'BOX_ARTICLES_REVIEWS', '', '', ''), (1900, 'banner_statistics.php', 0, 2003, '1', '', 1, 1, 127, 0, '', '', '', '', ''), (1901, 'banner_manager.php', 0, 19, '1', 'selected_box=marketing§ion=banner_manager', 1, 1, 21, 0, '', 'BOX_MARKETING_BANNER_MANAGER', '', '', ''), (1902, 'specials.php', 0, 19, '1', 'selected_box=marketing§ion=specials', 1, 1, 22, 0, '', 'BOX_MARKETING_SPECIALS', '', '', ''), (1903, 'newsletters.php', 0, 19, '1', 'selected_box=marketing§ion=newsletter_manager', 1, 1, 23, 0, '', 'BOX_TOOLS_NEWSLETTER_MANAGER', '', '', ''), (2000, 'pages.php', 0, 20, '1', 'selected_box=information', 1, 1, 50, 0, '', 'BOX_CDS_PAGE_MANAGER', '', '', ''), (2001, 'cds_configuration.php', 0, 20, '1', 'selected_box=information&gID=480', 1, 1, 51, 0, '', 'BOX_CDS_CONFIGUARION', '', '', ''), (2003, 'hidden.php', 1, 0, '1', '', 0, 1, 17, 0, '', 'BOX_HEADING_HIDDEN', '', '', ''), (2005, 'stats_manufacturers_sales.php', 0, 8, '1', 'selected_box=reports§ion=reports_manufacturer_sales', 1, 1, 38, 0, '', 'BOX_REPORTS_SALES_MANUFACTURERS', '', '', ''), (2006, 'cds_backup_restore.php', 0, 20, '1', 'selected_box=information', 1, 1, 52, 0, '', 'BOX_CDS_BACKUP_RESTORE', '', '', ''), (2007, '', 0, 20, '1', 'selected_box=information', 1, 1, 53, 0, '', 'BOX_CDS_FAQ', '', '', ''), (2008, '', 0, 10, '1', '', 1, 1, 62, 0, '', 'BOX_HEADING_TEMPLATE_HEADER_TAGS', '', '', ''), (2009, '', 0, 10, '1', '', 1, 1, 66, 0, '', 'BOX_HEADING_BRANDING_MANAGER', '', '', ''), (2010, '', 0, 10, '1', '', 1, 1, 68, 0, '', 'BOX_HEADING_DESIGN_TEMPLATE', '', '', ''), (2011, '', 0, 10, '1', '', 1, 1, 71, 0, '', 'BOX_HEADING_DESIGN_INFOBOX', '', '', ''), (2012, 'modules.php', 0, 4, '1', 'set=shipping', 1, 1, 77, 0, '', 'BOX_MODULES_SHIPPING', '', '', ''), (2013, 'modules.php', 0, 4, '1', 'set=ordertotal', 1, 1, 78, 0, '', 'BOX_MODULES_ORDER_TOTAL', '', '', ''), (2014, 'modules.php', 0, 4, '1', 'set=checkout_success', 1, 1, 79, 0, '', 'BOX_MODULES_CHECKOUT_SUCCESS', '', '', ''), (2015, 'modules.php', 0, 4, '1', 'set=addons', 1, 1, 80, 0, '', 'BOX_MODULES_ADDONS', '', '', ''), (2110, 'edit_orders.php', 0, 5, '1', '', 1, 1, 13, 0, '', 'BOX_CUSTOMERS_EDIT_ORDERS', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `admin_groups` -- CREATE TABLE `admin_groups` ( `admin_groups_id` int(11) NOT NULL AUTO_INCREMENT, `admin_groups_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`admin_groups_id`), UNIQUE KEY `admin_groups_name` (`admin_groups_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `admin_groups` -- INSERT INTO `admin_groups` VALUES (1, 'Top Administrator'); -- -------------------------------------------------------- -- -- Table structure for table `algozone_fraud_queries` -- CREATE TABLE `algozone_fraud_queries` ( `order_id` varchar(6) NOT NULL DEFAULT '', `ip_address` varchar(30) NOT NULL DEFAULT '', `last_date_queried` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `fraud_level` varchar(5) DEFAULT NULL, `err_message` varchar(150) DEFAULT NULL, `distance_m` varchar(10) DEFAULT NULL, `distance_k` varchar(10) DEFAULT NULL, `country_code` varchar(21) DEFAULT NULL, `is_country_match` char(3) DEFAULT NULL, `is_free_email` char(3) DEFAULT NULL, `is_customer_phone_inloc` char(3) DEFAULT NULL, `proxy_level` varchar(5) DEFAULT NULL, `spam_level` varchar(5) DEFAULT NULL, `is_high_risk_country` varchar(5) DEFAULT NULL, `is_anonymous_proxy` char(3) DEFAULT NULL, `ip_city` varchar(21) DEFAULT NULL, `ip_region` varchar(21) DEFAULT NULL, `ip_isp` varchar(30) DEFAULT NULL, `ip_org` varchar(30) DEFAULT NULL, `ip_latitude` varchar(21) DEFAULT NULL, `ip_longitude` varchar(21) DEFAULT NULL, `bin_country_code` varchar(5) DEFAULT NULL, `is_bin_match` varchar(5) DEFAULT NULL, `is_bank_name_match` varchar(5) DEFAULT NULL, `bank_name` varchar(20) DEFAULT NULL, `is_bank_phone_match` varchar(5) DEFAULT NULL, `bank_phone` varchar(15) DEFAULT NULL, KEY `order_id` (`order_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `articles` -- CREATE TABLE `articles` ( `articles_id` int(11) NOT NULL AUTO_INCREMENT, `articles_date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `articles_last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `articles_date_available` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `articles_status` tinyint(1) NOT NULL DEFAULT '0', `authors_id` int(11) NOT NULL DEFAULT '0', `articles_image` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`articles_id`), KEY `idx_articles_date_added` (`articles_date_added`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Dumping data for table `articles` -- INSERT INTO `articles` VALUES (1, '0000-00-00 00:00:00', '2011-09-11 02:08:58', '2011-09-04 00:00:00', 1, 5, ''), (2, '0000-00-00 00:00:00', '2011-09-11 02:11:06', '2011-09-07 00:00:00', 1, 1, ''), (3, '0000-00-00 00:00:00', '2011-09-11 02:14:01', '2011-09-09 00:00:00', 1, 3, ''), (4, '0000-00-00 00:00:00', '2011-09-11 02:16:49', '2011-09-07 00:00:00', 1, 2, ''), (5, '0000-00-00 00:00:00', '2011-09-11 02:19:10', '2011-09-01 00:00:00', 1, 4, ''), (6, '0000-00-00 00:00:00', '2011-09-11 02:22:27', '2011-09-02 00:00:00', 1, 1, ''), (7, '0000-00-00 00:00:00', '2011-09-11 02:24:04', '2011-09-10 00:00:00', 1, 2, ''), (8, '0000-00-00 00:00:00', '2011-09-11 02:25:42', '2011-09-11 00:00:00', 1, 4, ''), (9, '0000-00-00 00:00:00', '2011-09-11 02:27:25', '2011-09-04 00:00:00', 1, 3, ''); -- -------------------------------------------------------- -- -- Table structure for table `articles_description` -- CREATE TABLE `articles_description` ( `articles_id` int(11) NOT NULL AUTO_INCREMENT, `language_id` int(11) NOT NULL DEFAULT '1', `articles_name` varchar(255) NOT NULL DEFAULT '', `articles_description` text, `articles_url` varchar(255) DEFAULT NULL, `articles_viewed` int(5) DEFAULT '0', `articles_head_title_tag` varchar(80) DEFAULT NULL, `articles_head_desc_tag` text, `articles_head_keywords_tag` text, PRIMARY KEY (`articles_id`,`language_id`), KEY `articles_name` (`articles_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Dumping data for table `articles_description` -- INSERT INTO `articles_description` VALUES (1, 1, 'Euismod mauris eu elit', 'Quisque libero cursus et, eros. Proin ultrices. Duis volutpat nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, risus a ultricies adipiscing, enim mi tempor lorem, eget mollis lectus pede et risus.', '', 8, 'Nullam velit dui, ac libero nec ligula consectetuer rhoncus.', 'Integer tincidunt aliquam fames ac turpis egestas. Fusce aliquet magna a neque. Nullam ut nisi a odio semper cursus. Integer mollis.', 'tortor, dictum, eu, placerat, eget, venenatis'), (2, 1, 'Maecenas iaculis ullamcorper viverra', 'Sed malesuada ac, eleifend vitae, erat. Vivamus nisi. Mauris nulla. Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas ornare egestas ligula. Nullam feugiat placerat velit. Quisque varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris eu turpis. Nulla aliquet. Proin velit.', '', 1, 'Cras dolor dolor tempus non sapien', 'Cras eget nisi dictum augue malesuada malesuada egestas nunc sed libero. Proin sed turpis nec mauris blandit mattis.', 'mi, tempor, lorem, eget, mollis, lectus, pede, et'), (3, 1, 'Curabitur consectetuer ipsum nunc id enim', '

Mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent interdum ligula eu enim. Etiam imperdiet dictum magna. Ut tincidunt orci quis lectus. Nullam suscipit, est ac facilisis facilisis, magna tellus faucibus leo, in lobortis tellus justo.

\r\n\r\n

Sed malesuada ac, eleifend vitae, erat. Vivamus nisi. Mauris nulla. Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas ornare egestas ligula. Nullam feugiat placerat velit. Quisque varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris eu turpis. Nulla aliquet. Proin velit.

', '', 2, 'Ultricies adipiscing, enim mi'' tempor lorem eget', 'Aliquam auctor, velit eget laoreet posuere, enim imperdiet non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem ipsum dolor sit amet, consectetuer adipiscing elit.', 'sagittis, duis, gravida, praesent, eu, nulla'), (4, 1, 'Auctor ullamcorper nisl arcu iaculis enim', '

Dignissim lacus aliquam rutrum lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra. Maecenas iaculis aliquet diam. Sed diam lorem, auctor quis, tristique ac, eleifend.

\r\n\r\n

Quisque nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed dictum. Proin!

', '', 8, 'Tempor erat neque non quam pellentesque habitant morbi tristique', 'Phasellus dolor elit, pellentesque a, facilisis non, eget massa. Suspendisse eleifend. Cras sed leo. Cras vehicula aliquet libero. Integer in magna.', 'interdum, feugiat, sed, nec, metus, facilisis, lorem, tristique, aliquet, phasellus, fermentum, convallis'), (5, 1, 'Cras dictum mauris sagittis placerat', '

Proin a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis odio. Nam interdum enim non nisi. Aenean eget metus. In nec orci. Donec nibh. Quisque nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed dictum.

\r\n\r\n

Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra. Maecenas iaculis aliquet diam. Sed diam lorem, auctor quis, tristique ac, eleifend dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus.

', '', 0, 'Suspendisse commodo metus aliquam erat volutpat', 'Nam interdum a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis odio.', 'sociis, natoque, penatibus, et, magnis, dis, parturient, montes, nascetur'), (6, 1, 'Blandit congue in scelerisque', '

Pellentesque, tellus sem mollis dui, in sodales elit erat vitae risus. Duis a mi fringilla mi lacinia mattis. Integer eu lacus. Quisque imperdiet, erat nonummy ultricies ornare, elit elit fermentum risus, at fringilla purus mauris a nunc. In at pede. Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra, felis eget varius ultrices, mauris.

\r\n\r\n

Duis a mi fringilla mi lacinia mattis. Integer eu lacus. Quisque imperdiet, erat nonummy ultricies ornare, elit elit fermentum risus, at fringilla purus mauris a nunc. In at pede. Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi eleifend egestas. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla vulputate dui, nec tempus mauris erat eget.

', '', 4, 'In ornare aliquet molestie tellus aenean egestas hendrerit neque', 'Lacinia mattis. Integer eu lacus. Quisque imperdiet, erat nonummy ultricies ornare, elit elit fermentum risus, at fringilla purus mauris a nunc.', 'ridiculus, mus, aenean, eget, magna, suspendisse, tristique, neque, venenatis'), (7, 1, 'Nulla facilisis volutpat', 'Et magnis dis parturient montes, nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque venenatis lacus. Etiam bibendum fermentum metus. Aenean sed pede nec ante blandit viverra. Donec tempus, lorem fringilla ornare placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna nec.', '', 0, 'Accumsan sed facilisis vita orci', 'Donec vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit sed.', 'donec, consectetuer, mauris, id, sapien, cras, dolor, dolor tempus'), (8, 1, 'Est congue aliquet vel vulputate', 'Tincidunt congue turpis. In condimentum. Donec at arcu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla vulputate dui, nec tempus mauris erat eget.', '', 2, 'Euismod est arcu ac orci congue aliquet', 'Diam lorem, auctor quis, tristique ac, eleifend vitae, erat. Vivamus nisi. Mauris nulla. Integer urna.', 'lorem, ipsum, sodales, purus, in, molestie, tortor, nibh, sit, amet, orci'), (9, 1, 'Dolor sit amet consectetuer', 'Auctor non, feugiat nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc sed pede. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus. Nullam velit et tatu.', '', 2, 'Nullam enim sed nulla ante iaculis nec', 'Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna. Sed eu eros. Nam consequat.', 'egestas, lacinia, sed, congue, elit, sed, consequat, auctor'); -- -------------------------------------------------------- -- -- Table structure for table `articles_to_topics` -- CREATE TABLE `articles_to_topics` ( `articles_id` int(11) NOT NULL DEFAULT '0', `topics_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`articles_id`,`topics_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `articles_to_topics` -- INSERT INTO `articles_to_topics` VALUES (1, 1), (2, 1), (3, 1), (4, 2), (5, 2), (6, 3), (7, 3), (8, 3), (9, 3); -- -------------------------------------------------------- -- -- Table structure for table `articles_xsell` -- CREATE TABLE `articles_xsell` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `articles_id` int(11) NOT NULL DEFAULT '0', `xsell_id` int(11) NOT NULL DEFAULT '0', `sort_order` smallint(3) unsigned NOT NULL DEFAULT '9999', PRIMARY KEY (`ID`), KEY `idx_articles_id` (`articles_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; -- -- Dumping data for table `articles_xsell` -- INSERT INTO `articles_xsell` VALUES (1, 4, 226, 1), (2, 4, 1265, 1), (3, 4, 1344, 1), (4, 6, 1317, 1), (5, 6, 833, 1), (6, 6, 1498, 1), (7, 6, 1003, 1), (8, 6, 979, 1), (9, 6, 1503, 1), (10, 5, 1318, 1), (11, 5, 1319, 1), (12, 8, 1316, 1), (13, 8, 1003, 1), (14, 8, 1208, 1), (30, 1, 1531, 1), (29, 1, 763, 1), (28, 1, 1500, 1), (27, 1, 1535, 1), (26, 1, 1134, 1), (25, 1, 1006, 1), (24, 7, 1291, 1); -- -------------------------------------------------------- -- -- Table structure for table `article_reviews` -- CREATE TABLE `article_reviews` ( `reviews_id` int(11) NOT NULL AUTO_INCREMENT, `articles_id` int(11) NOT NULL DEFAULT '0', `customers_id` int(11) NOT NULL DEFAULT '0', `customers_name` varchar(255) NOT NULL DEFAULT '', `reviews_rating` int(1) DEFAULT NULL, `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `reviews_read` int(5) NOT NULL DEFAULT '0', `approved` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`reviews_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `article_reviews` -- INSERT INTO `article_reviews` VALUES (1, 3, 1157, 'Aubrey Bryant', 4, '2011-09-11 02:33:56', '2011-09-11 02:34:25', 5, 1), (2, 8, 1133, 'Tad Washington', 3, '2011-09-11 02:37:07', '0000-00-00 00:00:00', 2, 1), (3, 4, 1100, 'Norman Mcfadden', 5, '2011-09-11 02:37:55', '0000-00-00 00:00:00', 8, 1), (4, 9, 1121, 'Ursa Maldonado', 4, '2011-09-11 02:38:50', '0000-00-00 00:00:00', 3, 1), (5, 1, 1058, 'Sophia Hartman', 2, '2011-09-11 02:39:52', '0000-00-00 00:00:00', 0, 0), (6, 6, 1083, 'Colt Cantrell', 5, '2011-09-11 02:41:02', '0000-00-00 00:00:00', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `article_reviews_description` -- CREATE TABLE `article_reviews_description` ( `reviews_id` int(11) NOT NULL DEFAULT '0', `languages_id` int(11) NOT NULL DEFAULT '0', `reviews_text` text NOT NULL, PRIMARY KEY (`reviews_id`,`languages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `article_reviews_description` -- INSERT INTO `article_reviews_description` VALUES (1, 1, 'Consequat nec, mollis vitae, posuere at, velit. Cras lorem lorem, luctus ut, pellentesque eget, dictum placerat, augue. Sed molestie. Sed id risus quis diam luctus lobortis.'), (2, 1, 'Mauris blandit enim consequat purus. Maecenas libero est, congue a, aliquet vel, vulputate eu, odio. Phasellus at augue id ante dictum cursus. Nunc mauris elit, dictum.'), (3, 1, 'Dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.'), (4, 1, 'Duis ac arcu torquent per conubia nostra, per inceptos hymenaeos. Mauris ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec egestas.'), (5, 1, 'Sed id risus quis diam luctus lobortis. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos hymenaeos. Mauris ut quam vel sapien.'), (6, 1, 'Proin sed turpis nec mauris blandit mattis. Cras eget nisi dictum augue malesuada malesuada. Integer id magna et ipsum cursus nunc sed libero.'); -- -------------------------------------------------------- -- -- Table structure for table `authors` -- CREATE TABLE `authors` ( `authors_id` int(11) NOT NULL AUTO_INCREMENT, `authors_name` varchar(255) NOT NULL DEFAULT '', `authors_image` varchar(255) DEFAULT NULL, `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`authors_id`), KEY `IDX_AUTHORS_NAME` (`authors_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- Dumping data for table `authors` -- INSERT INTO `authors` VALUES (1, 'Jane Thompson', NULL, '2011-09-11 01:53:50', '0000-00-00 00:00:00'), (2, 'Paki Coley', NULL, '2011-09-11 01:54:23', '0000-00-00 00:00:00'), (3, 'Joelle Gallagher', NULL, '2011-09-11 01:55:07', '0000-00-00 00:00:00'), (4, 'Declan de Vazquez', NULL, '2011-09-11 01:55:57', '0000-00-00 00:00:00'), (5, 'Ashley Fuentes', NULL, '2011-09-11 01:56:37', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `authors_info` -- CREATE TABLE `authors_info` ( `authors_id` int(11) NOT NULL DEFAULT '0', `languages_id` int(11) NOT NULL DEFAULT '0', `authors_description` text, `authors_url` varchar(255) NOT NULL DEFAULT '', `url_clicked` int(5) NOT NULL DEFAULT '0', `date_last_click` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`authors_id`,`languages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `authors_info` -- INSERT INTO `authors_info` VALUES (1, 1, '

\r\n Fermentum convallis ligula. Donec luctus aliquet odio. Etiam ligula tortor, dictum eu, placerat eget, venenatis a, magna. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Etiam laoreet, libero et tristique pellentesque, tellus sem mollis dui, in sodales elit erat vitae risus.

', '', 0, '0000-00-00 00:00:00'), (2, 1, '

\r\n Fringilla purus mauris a nunc. In at pede. Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra, felis eget varius ultrices, mauris ipsum porta elit, a feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem ut aliquam iaculis, lacus pede sagittis augue, eu atest.

', '', 0, '0000-00-00 00:00:00'), (3, 1, '

\r\n Sed auctor odio a purus. Duis elementum, dui quis accumsan convallis, ante lectus convallis est, vitae sodales nisi magna sed dui. Fusce aliquam, enim nec tempus scelerisque, lorem ipsum sodales purus, in molestie tortor nibh sit amet orci.

', '', 0, '0000-00-00 00:00:00'), (4, 1, '

\r\n Aliquam turpis egestas. Fusce aliquet magna a neque. Nullam ut nisi a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis odio. Nam interdum enim non nisi. Aenean eget metus. In nec orci. Donec nibh. Quisque nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas.

', '', 0, '0000-00-00 00:00:00'), (5, 1, '

\r\n Suspendisse eleifend porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris eu turpis. Nulla aliquet. Proin velit. Sed malesuada augue ut lacus. Nulla tincidunt, neque vitae semper egestas, urna justo faucibus lectus, a sollicitudin orci sem eget massa. Cras sed leo.

', '', 0, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `banners` -- CREATE TABLE `banners` ( `banners_id` int(11) NOT NULL AUTO_INCREMENT, `banners_title` varchar(255) NOT NULL DEFAULT '', `banners_url` varchar(255) NOT NULL DEFAULT '', `banners_image` varchar(255) NOT NULL DEFAULT '', `banners_group` varchar(10) NOT NULL DEFAULT '', `banners_html_text` text, `expires_impressions` int(7) DEFAULT '0', `expires_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `date_scheduled` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `date_status_change` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `status` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`banners_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `banners` -- INSERT INTO `banners` VALUES (1, 'Find Everything Right Here', '', 'LC-CE-slider-1.png', 'HOMESLIDER', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-07-24 07:41:30', '2018-08-15 06:07:04', 1), (2, 'Discover the Amazing Quality', '', 'LC-CE-slider-2.png', 'HOMESLIDER', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-07-24 07:42:43', '2018-08-15 06:07:04', 1), (3, 'Guaranteed Satisfication', '', 'LC-CE-slider-3.png', 'HOMESLIDER', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2018-07-24 07:43:41', '2018-08-15 06:07:04', 1); -- -------------------------------------------------------- -- -- Table structure for table `banners_history` -- CREATE TABLE `banners_history` ( `banners_history_id` int(11) NOT NULL AUTO_INCREMENT, `banners_id` int(11) NOT NULL DEFAULT '0', `banners_shown` int(5) NOT NULL DEFAULT '0', `banners_clicked` int(5) NOT NULL DEFAULT '0', `banners_history_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`banners_history_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `branding_description` -- CREATE TABLE `branding_description` ( `store_brand_image` varchar(255) NOT NULL DEFAULT '', `store_brand_favicon` varchar(255) NOT NULL DEFAULT '', `store_og_image` varchar(255) NOT NULL DEFAULT '', `store_brand_slogan` varchar(96) NOT NULL DEFAULT '', `store_brand_telephone` varchar(16) NOT NULL DEFAULT '', `store_brand_fax` varchar(16) NOT NULL DEFAULT '', `store_brand_homepage` varchar(255) NOT NULL DEFAULT '', `store_brand_name` varchar(255) NOT NULL DEFAULT '', `store_brand_support_email` varchar(128) NOT NULL DEFAULT '', `store_brand_support_phone` varchar(16) NOT NULL DEFAULT '', `store_brand_address` text NOT NULL, `facebook_link` varchar(255) NOT NULL DEFAULT '', `twitter_link` varchar(255) NOT NULL DEFAULT '', `pinterest_link` varchar(255) NOT NULL DEFAULT '', `google_link` varchar(255) NOT NULL DEFAULT '', `youtube_link` varchar(255) NOT NULL DEFAULT '', `linkedin_link` varchar(255) NOT NULL DEFAULT '', `footer_text` text NOT NULL, `custom_css` text NOT NULL, `site_settings` longtext NOT NULL, `language_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `branding_description` -- INSERT INTO `branding_description` VALUES ('LoadedCommerceSiteLogo.png', 'loaded-favicon-64.gif', '', '', '216.220.8766', '216.220.8768', 'http://www.loadedcommerce.com/', 'Loaded Commerce Professional CE', 'sales@loadedcommerce.com', '800.609.2141', 'Loaded Commerce, LLC\n1211 CR 436\nLake Panasoffkee, FL 33538\nPhone: 216.220.8766\nToll-Free: 800.609.2141\nFax: 216.220.8768', 'https://www.facebook.com/loadedcommerce', 'https://twitter.com/loadedcommerce', '', '', '', '', '', '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `cache_data` -- CREATE TABLE `cache_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cache_code` varchar(100) NOT NULL, `cache_data` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `card_blacklist` -- CREATE TABLE `card_blacklist` ( `blacklist_id` int(5) NOT NULL AUTO_INCREMENT, `blacklist_card_number` varchar(20) NOT NULL DEFAULT '', `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`blacklist_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `categories_id` int(11) NOT NULL AUTO_INCREMENT, `categories_image` varchar(255) DEFAULT NULL, `categories_banner_image` varchar(255) DEFAULT NULL, `parent_id` int(11) NOT NULL DEFAULT '0', `sort_order` smallint(3) unsigned NOT NULL DEFAULT '9999', `products_group_access` varchar(255) NOT NULL DEFAULT 'G,0', `products_nav_access` varchar(255) NOT NULL DEFAULT 'G,0', `categories_status` tinyint(1) NOT NULL DEFAULT '1', `show_in_top_nav` int(1) NOT NULL DEFAULT '0', `show_in_side_nav` int(1) NOT NULL DEFAULT '1', `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`categories_id`), KEY `idx_categories_parent_id` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Dumping data for table `categories` -- INSERT INTO `categories` VALUES (1, 'cam1.jpg', NULL, 0, 20, '0,G,1', '', 1, 1, 1, '2016-07-11 07:41:06', '2018-07-30 10:18:49'), (2, '18-200x200.jpg', NULL, 0, 40, '0,G,1', '', 1, 1, 1, '2016-07-11 07:45:12', '2018-07-30 10:20:37'), (3, 'f8.jpg', NULL, 0, 10, '0,G,1', '', 1, 1, 1, '2016-07-11 07:45:36', '2018-07-30 10:23:45'), (4, 'fff1234.jpg', NULL, 3, 0, '0,G,1', '', 1, 1, 1, '2016-07-11 07:46:08', '2018-07-30 10:30:29'), (5, '8-330x330.jpg', NULL, 3, 0, '0,G,1', '', 1, 1, 1, '2016-07-11 07:46:35', '2018-07-30 10:26:29'), (6, 'fff1234.jpg', NULL, 0, 30, '0,G,1', '', 1, 1, 1, '2016-07-11 07:47:49', '2018-07-30 10:19:41'), (7, 'p3.jpg', NULL, 0, 50, '0,G,1', '', 1, 1, 1, '2016-07-11 07:48:21', '2018-07-30 10:21:01'), (8, 'p1.jpg', NULL, 7, 0, '0,G,1', '', 1, 1, 1, '2016-07-11 07:48:51', '2016-07-11 09:56:17'), (9, 'p6.jpg', NULL, 7, 0, '0,G,1', '', 1, 1, 1, '2016-07-11 07:50:04', '2016-07-11 09:57:17'); -- -------------------------------------------------------- -- -- Table structure for table `categories_description` -- CREATE TABLE `categories_description` ( `categories_id` int(11) NOT NULL DEFAULT '0', `language_id` int(11) NOT NULL DEFAULT '1', `categories_name` varchar(255) NOT NULL DEFAULT '', `categories_heading_title` varchar(255) DEFAULT NULL, `categories_description` text, `categories_head_title_tag` varchar(80) DEFAULT NULL, `categories_head_desc_tag` longtext NOT NULL, `categories_head_keywords_tag` longtext NOT NULL, `categories_htc_title_tag` varchar(80) DEFAULT NULL, `categories_htc_desc_tag` longtext, `categories_htc_keywords_tag` longtext, `categories_htc_description` longtext, `permalink_name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`categories_id`,`language_id`), KEY `idx_categories_name` (`categories_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `categories_description` -- INSERT INTO `categories_description` VALUES (1, 1, 'Digital Camera', 'Digital Camera', '

Shop for popular Digital Cameras such as Digital SLRs, Point & Shoot Cameras, Mirrorless Cameras, Camera Lenses, Camera Cases & Bags and other Camera Accessories from Brands such as Canon, Nikon, Sony, Olympus, Fujifilm, Lowepro and many more. Buy cameras and other photography equipment and devices such as Camcorders, Binoculars & Telescopes, CCTV Cameras, Surveillance Cameras, Projectors, Action Cameras and Digital Photo Frames

', '', '', '', NULL, NULL, NULL, NULL, ''), (2, 1, 'Mobile Phones', 'Mobile Phones', 'Bestsellers. Add-on the perfect accessory to your mobile. Find Cases & Covers, Screen Protectors, Power banks, Bluetooth headsets, Wired Headsets, Data Cables, Mobile Chargers, Mobile utility/antivirus software and more', '', '', '', NULL, NULL, NULL, NULL, ''), (3, 1, 'Accessories', 'Accessories', 'a subordinate or supplementary part, object, or the like, used mainly for convenience, attractiveness, safety, etc., as a spotlight on an automobile or a lens cover on a camera.', '', '', '', NULL, NULL, NULL, NULL, ''), (4, 1, 'Mobile Accessories', 'Mobile Accessories', 'Add-on the perfect accessory to your mobile. Find Cases & Covers, Screen Protectors, Power banks, Bluetooth headsets, Wired Headsets, Data Cables, Mobile Chargers, Mobile utility/antivirus software and more.', '', '', '', NULL, NULL, NULL, NULL, ''), (5, 1, 'Desktop Accessories', 'Desktop Accessories', '

The comprehensive range of desk accessories and storage products make sure your desk is clutter free and you find all the items right when you need it. It reduces the trouble of buying a new item that is possibly laying somewhere in your messy cupboard.

', '', '', '', NULL, NULL, NULL, NULL, ''), (6, 1, 'Laptops', 'Laptops', '

Shop for a wide range of Laptops from top brands like HP, Dell, Lenovo, Acer, Apple, Asus, Microsoft, Intel and more. Popular searches:New releases in laptops, Laptop deals, Laptops under Rs.20,000, Touchscreen laptops, Gaming laptops, Windows 10 Laptops, i7 Laptops, i5 Laptops, Refurbished Laptops

', '', '', '', NULL, NULL, NULL, NULL, ''), (7, 1, 'Personal Care', 'Personal Care', 'The Natural Products Association (NPA) recognised BASF for having the largest selection of ingredients for cosmetic manufacturers who want to certify their products according to the NPA Natural Standard.', '', '', '', NULL, NULL, NULL, NULL, ''), (8, 1, 'Men', '', '', '', '', '', NULL, NULL, NULL, NULL, ''), (9, 1, 'Women', 'Women', '', '', '', '', NULL, NULL, NULL, NULL, ''); -- -------------------------------------------------------- -- -- Table structure for table `components` -- CREATE TABLE `components` ( `components_id` int(11) NOT NULL AUTO_INCREMENT, `serial_1` varchar(255) NOT NULL DEFAULT '', `serial_2` varchar(255) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `last_validated` date NOT NULL DEFAULT '0000-00-00', `validation_product` varchar(255) NOT NULL DEFAULT '', `expiration_date` date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`components_id`,`validation_product`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `configuration` -- CREATE TABLE `configuration` ( `configuration_id` int(11) NOT NULL AUTO_INCREMENT, `configuration_title` varchar(255) NOT NULL DEFAULT '', `configuration_key` varchar(255) NOT NULL DEFAULT '', `configuration_value` varchar(255) NOT NULL DEFAULT '', `configuration_description` varchar(255) NOT NULL DEFAULT '', `configuration_group_id` int(11) NOT NULL DEFAULT '0', `sort_order` smallint(3) unsigned NOT NULL DEFAULT '9999', `last_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `use_function` varchar(255) DEFAULT NULL, `set_function` varchar(255) DEFAULT NULL, PRIMARY KEY (`configuration_id`), UNIQUE KEY `idx_configuration_key` (`configuration_key`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3282 ; -- -- Dumping data for table `configuration` -- INSERT INTO `configuration` VALUES (1, 'Store Name', 'STORE_NAME', 'Loaded Commerce Community Edition', 'The name of my store', 1, 1, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (2, 'Store Owner', 'STORE_OWNER', 'Sal Iozzia', 'The name of my store owner', 1, 2, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (3, 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'me@mail.com', 'The e-mail address of my store owner', 1, 3, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (5, 'Country', 'STORE_COUNTRY', '223', 'The country my store is located in

Note: Please remember to update the store zone.', 1, 5, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_country_name', 'tep_cfg_pull_down_country_list('), (6, 'Zone', 'STORE_ZONE', '18', 'The zone my store is located in', 1, 6, '0000-00-00 00:00:00', '[[regtime]]', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list('), (7, 'Time Zone', 'STORE_TIME_ZONE', 'America/New_York', 'The Time Zone my store is located in', 1, 7, '0000-00-00 00:00:00', '[[regtime]]', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_timezone_list('), (9, 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'false', 'Automatically switch to the language''s currency when it is changed', 1, 9, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (10, 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', '', 'Send extra order emails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>', 1, 10, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (11, 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'false', 'Allow guests to tell a friend about a product', 1, 12, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (12, 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', 1, 13, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''and'', ''or''),'), (13, 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Loaded Commerce, LLC\r\n1211 CR 436\r\nLake Panasoffkee, FL 33538\r\nPhone: 216.220.8766\r\nToll-Free: 800.609.2141\r\nFax: 216.220.8768', 'This is the Store Name, Address and Phone used on printable documents and displayed online', 1, 14, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_textarea('), (14, 'Show Category Counts', 'SHOW_COUNTS', 'false', 'Count recursively how many products are in each category', 1, 15, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (15, 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', 1, 16, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (16, 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'false', 'Display prices with tax included (true) or add the tax at the end (false)', 1, 17, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (18, 'Store Logo', 'STORE_LOGO', 'LoadedCommerceSiteLogo.png', 'This is the logo for my store, for receipts', 1, 19, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (19, 'Welcome Gift Voucher Amount', 'NEW_SIGNUP_GIFT_VOUCHER_AMOUNT', '0', 'Welcome Gift Voucher Amount: If you do not wish to send a Gift Voucher in your create account email put 0 for no amount else if you do place the amount here i.e. 10.00 or 50.00 no currency signs', 1, 31, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (20, 'Welcome Discount Coupon Code', 'NEW_SIGNUP_DISCOUNT_COUPON', '', 'Welcome Discount Coupon Code: if you do not want to send a coupon in your create account email leave blank else place the coupon code you wish to use', 1, 20, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (21, 'Allow Category Descriptions', 'ALLOW_CATEGORY_DESCRIPTIONS', 'true', 'Allow use of full text descriptions for categories', 1, 21, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (22, 'Enable Admin Dhtml menu', 'MENU_DHTML', 'False', 'Do you want to display top DHTML menu?', 1, 22, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (23, 'Use US or UK style formats for English language', 'ENGLISH_LANGAUGE_SET', 'us', 'Use US or UK style formats for English language defines, This setting switches between the two formats', 1, 23, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''us'', ''uk''),'), (24, 'Category/Products Display Order', 'CATEGORIES_SORT_ORDER', 'PRODUCT_LIST_MODEL', 'Valid Orders:
products_name
products name
products model
manufacturer
products price
', 1, 24, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''PRODUCT_LIST_MODEL'', ''PRODUCT_LIST_NAME'', ''PRODUCT_LIST_MANUFACTURER'', ''PRODUCT_LIST_PRICE''),'), (101, 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', 2, 1, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (102, 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', 2, 2, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (103, 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', 2, 3, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (104, 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', 2, 4, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (105, 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', 2, 5, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (106, 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', 2, 6, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (107, 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', 2, 7, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (108, 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', 2, 8, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (109, 'State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', 2, 9, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (110, 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', 2, 10, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (111, 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '6', 'Minimum length of password. Suggested length = 12', 2, 11, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (112, 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', 2, 12, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (113, 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', 2, 13, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (114, 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', 2, 14, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (115, 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', 2, 15, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (116, 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the ''This Customer Also Purchased'' box', 2, 16, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (117, 'X-Sell', 'MIN_DISPLAY_XSELL', '1', 'Minimum number of X-sell products to display', 2, 17, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (201, 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', 3, 1, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (202, 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '6', 'Number of products to list', 3, 2, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (203, 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '10', 'Number of ''number'' links to use for page-sets', 3, 3, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (204, 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '4', 'Maximum number of products on special to display', 3, 4, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (205, 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '4', 'Maximum number of new products to display in a category', 3, 5, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (206, 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '4', 'Maximum number of products expected to display', 3, 6, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (207, 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '5', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', 3, 7, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (208, 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is ''1'' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', 3, 8, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (209, 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', 3, 9, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (210, 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', 3, 10, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (211, 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '4', 'How many records to select from to choose one random product review', 3, 11, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (212, 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '4', 'How many records to select from to choose one random new product to display', 3, 12, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (213, 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '5', 'How many records to select from to choose one random product special to display', 3, 13, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (214, 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '2', 'How many categories to list per row', 3, 14, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (215, 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '8', 'Maximum number of new products to display in new products page', 3, 15, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (216, 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', 3, 16, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (217, 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the ''This Customer Also Purchased'' box', 3, 17, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (218, 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', 3, 18, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (219, 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', 3, 19, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (220, 'Product Featured Maximum Display', 'MAX_DISPLAY_FEATURED_PRODUCTS', '6', 'Number of products to display on main page', 3, 20, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (221, 'Product Featured Display Results', 'MAX_DISPLAY_FEATURED_PRODUCTS_LISTING', '10', 'Number of products to list per page', 3, 21, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (222, 'Max Wish List', 'MAX_DISPLAY_WISHLIST_PRODUCTS', '12', 'How many wish list items to show per page on the main wishlist.php file', 3, 22, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (223, 'Max Wish List Box', 'MAX_DISPLAY_WISHLIST_BOX', '4', 'How many wish list items to display in the infobox before it changes to a counter', 3, 23, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (224, 'Max Wish List Columns', 'MAX_DISPLAY_WISHLIST_COLS', '1', 'How many columns to display in the wish list', 3, 24, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (301, 'Enable Additional Images?', 'ULTIMATE_ADDITIONAL_IMAGES', 'enable', 'Display Additional Images below Product Description?', 4, 1, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''enable'', ''disable''),'), (302, 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', 4, 2, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (303, 'Image Required', 'IMAGE_REQUIRED', 'false', 'Enable to display broken images. Good for development.', 4, 3, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (304, 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '50', 'The pixel width of heading images', 4, 4, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (305, 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '', 'The pixel height of heading images', 4, 5, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (306, 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '200', 'The pixel width of subcategory images', 4, 6, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (307, 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '200', 'The pixel height of subcategory images', 4, 7, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (308, 'Small Image Width (used in product list)', 'SMALL_IMAGE_WIDTH', '200', 'The pixel width of small images', 4, 10, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (309, 'Small Image Height (used in product list)', 'SMALL_IMAGE_HEIGHT', '150', 'The pixel height of small images', 4, 11, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (310, 'Additional Thumb Width', 'ULT_THUMB_IMAGE_WIDTH', '85', 'The pixel width of additional thumb images', 4, 8, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (311, 'Additional Thumb Height', 'ULT_THUMB_IMAGE_HEIGHT', '', 'The pixel height of additional thumb images', 4, 9, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (312, 'Medium Image Width (used for product info)', 'MEDIUM_IMAGE_WIDTH', '200', 'The pixel width of medium images', 4, 12, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (313, 'Medium Image Height (used for product info)', 'MEDIUM_IMAGE_HEIGHT', '150', 'The pixel height of medium images', 4, 13, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (314, 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', '0', 'The pixel width of large images (Pop-up)
(Use 0 for non-specific size)', 4, 14, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (315, 'Large Image Height (Pop-up)', 'LARGE_IMAGE_HEIGHT', '0', 'The pixel height of large images (Pop-up)
(Use 0 for non-specific size)', 4, 15, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (401, 'Gender', 'ACCOUNT_GENDER', 'false', 'Display gender in the customers account', 5, 1, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (402, 'Date of Birth', 'ACCOUNT_DOB', 'false', 'Display date of birth in the customers account', 5, 2, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (403, 'Company', 'ACCOUNT_COMPANY', 'true', 'Display company in the customers account', 5, 3, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (404, 'Suburb', 'ACCOUNT_SUBURB', 'true', 'Display suburb in the customers account', 5, 4, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (405, 'State', 'ACCOUNT_STATE', 'true', 'Display state in the customers account', 5, 5, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (406, 'Require E-mail Confirmation', 'ACCOUNT_EMAIL_CONFIRMATION', 'false', 'Require E-mail confirmation on account creation.', 5, 6, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (501, 'Default Currency', 'DEFAULT_CURRENCY', 'USD', 'Default Currency', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (502, 'Default Language', 'DEFAULT_LANGUAGE', 'en', 'Default Language', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (503, 'Default theme', 'DEFAULT_TEMPLATE', 'sevenofsix', 'Default responsive theme, set in Design Controls', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_pull_down_template_list('), (504, 'Default Order Status For New Orders', 'DEFAULT_ORDERS_STATUS_ID', '1', 'When a new order is created, this order status will be assigned to it.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (505, 'Last Database Restore', 'DB_LAST_RESTORE', '', 'Last database restore file', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (506, 'Shop By Price Ranges', 'MODULE_SHOPBYPRICE_RANGES', '0', 'How many ranges does the Shop by Price module support?', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (507, 'Shop By Price Over Range', 'MODULE_SHOPBYPRICE_OVER', 'True', 'Add a range to cover everything over the last specified range?', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''True'', ''False''),'), (508, 'Shop By Price Range', 'MODULE_SHOPBYPRICE_RANGE', '', 'An array of the shop by price ranges.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (510, 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'moneyorder.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (511, 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_shipping.php;ot_subtotal.php;ot_tax.php;ot_total.php', 'List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (512, 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', '', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (513, 'Installed Modules', 'MODULE_CHECKOUT_SUCCESS_INSTALLED', '', 'This is automatically updated. No need to edit.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (514, 'Installed Modules', 'MODULE_ADDONS_INSTALLED', '', 'This is automatically updated. No need to edit.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (520, 'Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', 6, 1, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (521, 'Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '500', 'Sort order of display.', 6, 2, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (522, 'Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', 6, 3, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''), '), (523, 'Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '50', 'Provide free shipping for orders over the set amount.', 6, 4, '0000-00-00 00:00:00', '[[regtime]]', 'currencies->format', ''), (524, 'Provide Free Shipping For Orders Made', 'MODULE_ORDER_TOTAL_SHIPPING_DESTINATION', 'national', 'Provide free shipping for orders sent to the set destination.', 6, 5, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''national'', ''international'', ''both''), '), (530, 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', 6, 6, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (531, 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '700', 'Sort order of display.', 6, 7, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (540, 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'true', 'Do you want to display the order tax value?', 6, 8, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (541, 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '800', 'Sort order of display.', 6, 9, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (550, 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', 6, 10, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (551, 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '900', 'Sort order of display.', 6, 11, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (552, 'PayPal Service', 'MODULE_PAYMENT_PAYPAL_SERVICE', 'Express Checkout', 'Choose which PayPal Service to use.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Website Payments Pro'', ''Express Checkout'', ''Website Payments Standard''), '), (553, '
WEBSITE PAYMENTS PRO
CRE Secure Account ID', 'MODULE_PAYMENT_PAYPAL_CRESECURE_LOGIN', '', 'The Account ID used for the CRE Secure payment service', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (554, 'CRE Secure API Token', 'MODULE_PAYMENT_PAYPAL_CRESECURE_PASS', '', 'The API Token used for the CRE Secure payment service', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (555, 'Accepted Credit Cards', 'MODULE_PAYMENT_CRESECURE_ACCEPTED_CC', 'American Express, MasterCard, Visa', 'The credit cards you currently accept', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', '_selectCREOptions(array(''American Express'', ''Discover'', ''MasterCard'', ''Visa''), '), (556, 'Set Completed Order Status', 'MODULE_PAYMENT_CRESECURE_ORDER_STATUS_COMPLETE_ID', '0', 'For Completed orders, set the status of orders made with this payment module to this value', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (557, 'Enable Sandbox Mode', 'MODULE_PAYMENT_CRESECURE_TEST_MODE', 'False', 'Set to ''True'' for sandbox test environment or set to ''False'' for production environment.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''True'', ''False''), '), (558, '
EXPRESS CHECKOUT
API Username', 'MODULE_PAYMENT_PAYPAL_XC_API_USERNAME', '', 'Your PayPal EC API Username', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (559, 'API Password', 'MODULE_PAYMENT_PAYPAL_XC_API_PASSWORD', '', 'Your PayPal EC API Password', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (560, 'API Signature', 'MODULE_PAYMENT_PAYPAL_XC_API_SIGNATURE', '', 'Your PayPal EC API Signature', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (561, 'Transaction Type', 'MODULE_PAYMENT_PAYPAL_XC_TRXTYPE', 'Sale', 'Should customers be charged immediately, or should we perform an authorization? If we perform authorizations, capture must be handled manually by the store owner.)', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Sale'', ''Authorization''), '), (562, 'Merchant Country', 'MODULE_PAYMENT_PAYPAL_XC_MERCHANT_COUNTRY', 'US', 'The country of merchant', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''US'', ''UK''), '), (563, 'Payment Zone', 'MODULE_PAYMENT_PAYPAL_XC_ZONE', '0', 'If a zone is selected, enable this payment method for that zone only.', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes('), (564, 'Set Order Status', 'MODULE_PAYMENT_PAYPAL_XC_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (565, 'Set Refund Order Status', 'MODULE_PAYMENT_PAYPAL_XC_REFUND_ORDER_STATUS_ID', '0', 'Set the status of refund orders made with this payment module to this value', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (566, 'Live or Sandbox API', 'MODULE_PAYMENT_PAYPAL_XC_SERVER', 'sandbox', 'Live: Live transactions
Sandbox: For developers and testing', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''live'', ''sandbox''), '), (570, 'Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments? [Help]', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''True'', ''False''), '), (571, '
WEBSITE PAYMENTS STANDARD
E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', '[[admin_email]]', 'The e-mail address to use for the PayPal service', 6, 1, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (572, 'Business ID', 'MODULE_PAYMENT_PAYPAL_BUSINESS_ID', '[[admin_email]]', 'Email address or account ID of the payment recipient', 6, 2, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (573, 'Default Currency', 'MODULE_PAYMENT_PAYPAL_DEFAULT_CURRENCY', 'USD', 'The default currency to use for when the customer chooses to checkout via the store using a currency not supported by PayPal.
(This currency must exist in your store)', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''USD'',''CAD'',''EUR'',''GBP'',''JPY'',''AUD''), '), (574, 'Transaction Currency', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'Selected Currency', 'The currency to use for credit card transactions', 6, 3, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Selected Currency'',''Only USD'',''Only CAD'',''Only EUR'',''Only GBP'',''Only JPY''), '), (575, 'Payment Zone', 'MODULE_PAYMENT_PAYPAL_ZONE', '0', 'If a zone is selected, enable this payment method for that zone only.', 6, 4, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes('), (576, 'Set Pending Notification Status', 'MODULE_PAYMENT_PAYPAL_PROCESSING_STATUS_ID', '1', 'Set the Pending Notification status of orders made with this payment module to this value (''Pending'' recommended)', 6, 5, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (577, 'Set Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_STATUS_ID', '2', 'Set the status of orders made with this payment module to this value
(''Processing'' recommended)', 6, 6, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (578, 'Set On Hold Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_ONHOLD_STATUS_ID', '5', 'Set the status of On Hold orders made with this payment module to this value', 6, 7, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (579, 'Set Canceled Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_CANCELED_STATUS_ID', '6', 'Set the status of Canceled orders made with this payment module to this value', 6, 8, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (580, 'Synchronize Invoice', 'MODULE_PAYMENT_PAYPAL_INVOICE_REQUIRED', 'False', 'Do you want to specify the order number as the PayPal invoice number?', 6, 9, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''True'', ''False''), '), (581, 'Sort order of display.', 'MODULE_PAYMENT_PAYPAL_SORT_ORDER', '100', 'Sort order of display. Lowest is displayed first.', 6, 10, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (582, 'Set Refunded Order Status', 'MODULE_PAYMENT_PAYPAL_ORDER_REFUNDED_STATUS_ID', '1', 'Set the status of Refunded orders made with this payment module to this value', 6, 0, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses('), (583, 'Background Color', 'MODULE_PAYMENT_PAYPAL_CS', 'White', 'Select the background color of PayPal''s payment pages.', 6, 11, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''White'',''Black''), '), (584, 'Processing logo', 'MODULE_PAYMENT_PAYPAL_PROCESSING_LOGO', 'loaded_header_logo.gif', 'The image file name to display the store''s checkout process', 6, 12, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (585, 'Store logo', 'MODULE_PAYMENT_PAYPAL_STORE_LOGO', '', 'The image file name for PayPal to display (leave empty if your store does not have SSL)', 6, 13, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (586, 'PayPal Page Style Name', 'MODULE_PAYMENT_PAYPAL_PAGE_STYLE', 'default', 'The name of the page style you have configured in your PayPal Account', 6, 14, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (587, 'Include a note with payment', 'MODULE_PAYMENT_PAYPAL_NO_NOTE', 'No', 'Choose whether your customer should be prompted to include a note or not?', 6, 15, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Yes'',''No''), '), (588, 'Shopping Cart Method', 'MODULE_PAYMENT_PAYPAL_METHOD', 'Aggregate', 'What type of shopping cart do you want to use?', 6, 16, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Aggregate'',''Itemized''), '), (589, 'Enable PayPal Shipping Address', 'MODULE_PAYMENT_PAYPAL_SHIPPING_ALLOWED', 'No', 'Allow the customer to choose their own PayPal shipping address?', 6, 17, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Yes'',''No''), '), (590, 'Debug Email Notifications', 'MODULE_PAYMENT_PAYPAL_IPN_DEBUG', 'Yes', 'Enable debug email notifications', 6, 18, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Yes'',''No''), '), (591, 'Digest Key', 'MODULE_PAYMENT_PAYPAL_IPN_DIGEST_KEY', 'PayPal_Shopping_Cart_IPN', 'Key to use for the digest functionality', 6, 19, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (592, 'Test Mode', 'MODULE_PAYMENT_PAYPAL_IPN_TEST_MODE', 'Off', 'Set test mode [IPN Test Panel]', 6, 20, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Off'',''On''), '), (593, 'Cart Test', 'MODULE_PAYMENT_PAYPAL_IPN_CART_TEST', 'Off', 'Set cart test mode to verify the transaction amounts', 6, 21, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''Off'',''On''), '), (594, 'Debug Email Notification Address', 'MODULE_PAYMENT_PAYPAL_IPN_DEBUG_EMAIL', '', 'The e-mail address to send debug notifications to', 6, 22, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (595, 'PayPal Domain', 'MODULE_PAYMENT_PAYPAL_DOMAIN', 'www.paypal.com', 'Select which PayPal domain to use
(for live production select www.paypal.com)', 6, 23, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''www.paypal.com'',''www.sandbox.paypal.com''), '), (596, 'Return URL behavior', 'MODULE_PAYMENT_PAYPAL_RM', '2', 'How should the customer be sent back from PayPal to the specified URL?
0=No IPN, 1=GET, 2=POST', 6, 24, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''0'',''1'',''2''), '), (601, 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '223', 'Select the country of origin to be used in shipping quotes.', 7, 1, '0000-00-00 00:00:00', '[[regtime]]', 'tep_get_country_name', 'tep_cfg_pull_down_country_list('), (602, 'Postal Code', 'SHIPPING_ORIGIN_ZIP', '94558', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', 7, 2, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (603, 'Maximum Package Weight', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', 7, 3, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (604, 'Package Tare Weight', 'SHIPPING_BOX_WEIGHT', '0', 'What is the weight of typical packaging for small to medium packages?', 7, 4, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (605, 'Percentage Increase for Larger Packages', 'SHIPPING_BOX_PADDING', '0', 'For 10% enter 10', 7, 5, '0000-00-00 00:00:00', '[[regtime]]', '', ''), (606, 'Shipping Estimator', 'SHOW_SHIPPING_ESTIMATOR', 'true', 'Show Shipping Estimator on Shopping Cart
true= always
false= button popup only', 7, 6, '0000-00-00 00:00:00', '[[regtime]]', '', 'tep_cfg_select_option(array(''true'', ''false''),'), (607, 'Skip Shipping Page', 'SHIPPING_SKIP', 'No', '