Page 1 of 3 123 LastLast
Results 1 to 10 of 26

Want to install AABox's MS2-MAX over OSC MS2 default?

This is a discussion on Want to install AABox's MS2-MAX over OSC MS2 default? within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; Copy MS@-MAX over your OLD install or use a compair tool like Beyond Compair Then copy the follwong code in ...

      
  1. 08-14-2003, 12:24 PM #1
    Anonymous
    Guest

    Default Want to install AABox's MS2-MAX over OSC MS2 default?

    Copy MS@-MAX over your OLD install or use a compair tool like Beyond Compair

    Then copy the follwong code in PHPMYADMIN or cPanel SQL command box for your database and press OK. Now your data base it updated!!

    Remember to change the default ADMIN user name AND password!

    Code:
    # --------------------------------------------------------
# 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(32) NOT NULL default '',
  `admin_lastname` varchar(32) default NULL,
  `admin_email_address` varchar(96) NOT NULL default '',
  `admin_password` varchar(40) NOT NULL default '',
  `admin_created` datetime default NULL,
  `admin_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `admin_logdate` datetime default NULL,
  `admin_lognum` int(11) NOT NULL default '0',
  PRIMARY KEY  (`admin_id`),
  UNIQUE KEY `admin_email_address` (`admin_email_address`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `admin`
#

INSERT INTO `admin` VALUES (1, 1, 'Default', 'Admin', 'admin@localhost.com', '05cdeb1aeaffec1c7ae3f12c570a658c:81', '2003-07-17 11:35:03', '2003-08-02 19:43:11', '2003-08-12 00:17:36', 47);

# --------------------------------------------------------
# Table structure for table `admin_files`
#

CREATE TABLE `admin_files` (
  `admin_files_id` int(11) NOT NULL auto_increment,
  `admin_files_name` varchar(64) 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','2') NOT NULL default '1',
  PRIMARY KEY  (`admin_files_id`)
) TYPE=MyISAM AUTO_INCREMENT=71 ;

#
# Dumping data for table `admin_files`
#

INSERT INTO `admin_files` VALUES (1, 'administrator.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (2, 'configuration.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (3, 'catalog.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (4, 'modules.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (5, 'customers.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (6, 'taxes.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (7, 'localization.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (8, 'reports.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (9, 'tools.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (10, 'admin_members.php', 0, 1, '1');
INSERT INTO `admin_files` VALUES (11, 'admin_files.php', 0, 1, '1');
INSERT INTO `admin_files` VALUES (12, 'configuration.php', 0, 2, '1');
INSERT INTO `admin_files` VALUES (13, 'categories.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (14, 'products_attributes.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (15, 'manufacturers.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (16, 'reviews.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (17, 'specials.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (18, 'products_expected.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (19, 'modules.php', 0, 4, '1');
INSERT INTO `admin_files` VALUES (20, 'customers.php', 0, 5, '1');
INSERT INTO `admin_files` VALUES (21, 'orders.php', 0, 5, '1');
INSERT INTO `admin_files` VALUES (22, 'countries.php', 0, 6, '1');
INSERT INTO `admin_files` VALUES (23, 'zones.php', 0, 6, '1');
INSERT INTO `admin_files` VALUES (24, 'geo_zones.php', 0, 6, '1');
INSERT INTO `admin_files` VALUES (25, 'tax_classes.php', 0, 6, '1');
INSERT INTO `admin_files` VALUES (26, 'tax_rates.php', 0, 6, '1');
INSERT INTO `admin_files` VALUES (27, 'currencies.php', 0, 7, '1');
INSERT INTO `admin_files` VALUES (28, 'languages.php', 0, 7, '1');
INSERT INTO `admin_files` VALUES (29, 'orders_status.php', 0, 7, '1');
INSERT INTO `admin_files` VALUES (30, 'stats_products_viewed.php', 0, 8, '1');
INSERT INTO `admin_files` VALUES (31, 'stats_products_purchased.php', 0, 8, '1');
INSERT INTO `admin_files` VALUES (32, 'stats_customers.php', 0, 8, '1');
INSERT INTO `admin_files` VALUES (33, 'backup.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (34, 'banner_manager.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (35, 'cache.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (36, 'define_language.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (37, 'file_manager.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (38, 'mail.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (39, 'newsletters.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (40, 'server_info.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (41, 'whos_online.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (42, 'banner_statistics.php', 0, 9, '1');
INSERT INTO `admin_files` VALUES (43, 'affiliate.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (44, 'affiliate_affiliates.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (45, 'affiliate_clicks.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (46, 'affiliate_banners.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (47, 'affiliate_contact.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (48, 'affiliate_invoice.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (49, 'affiliate_payment.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (50, 'affiliate_popup_image.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (51, 'affiliate_sales.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (52, 'affiliate_statistics.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (53, 'affiliate_summary.php', 0, 43, '1');
INSERT INTO `admin_files` VALUES (54, 'gv_admin.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (55, 'coupon_admin.php', 0, 54, '1');
INSERT INTO `admin_files` VALUES (56, 'gv_queue.php', 0, 54, '1');
INSERT INTO `admin_files` VALUES (57, 'gv_mail.php', 0, 54, '1');
INSERT INTO `admin_files` VALUES (58, 'gv_sent.php', 0, 54, '1');
INSERT INTO `admin_files` VALUES (59, 'paypalipn.php', 1, 0, '1');
INSERT INTO `admin_files` VALUES (60, 'paypalipn_tests.php', 0, 59, '1');
INSERT INTO `admin_files` VALUES (61, 'paypalipn_txn.php', 0, 59, '1');
INSERT INTO `admin_files` VALUES (62, 'coupon_restrict.php', 0, 54, '1');
INSERT INTO `admin_files` VALUES (64, 'xsell_products.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (65, 'easypopulate.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (68, 'define_mainpage.php', 0, 3, '1');
INSERT INTO `admin_files` VALUES (70, 'edit_orders.php', 0, 5, '1');

# --------------------------------------------------------
# Table structure for table `admin_groups`
#

CREATE TABLE `admin_groups` (
  `admin_groups_id` int(11) NOT NULL auto_increment,
  `admin_groups_name` varchar(64) default NULL,
  PRIMARY KEY  (`admin_groups_id`),
  UNIQUE KEY `admin_groups_name` (`admin_groups_name`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `admin_groups`
#

INSERT INTO `admin_groups` VALUES (1, 'Top Administrator');
INSERT INTO `admin_groups` VALUES (2, 'Marketing');

# --------------------------------------------------------
# Table structure for table `affiliate_affiliate`
#

CREATE TABLE `affiliate_affiliate` (
  `affiliate_id` int(11) NOT NULL auto_increment,
  `affiliate_gender` char(1) NOT NULL default '',
  `affiliate_firstname` varchar(32) NOT NULL default '',
  `affiliate_lastname` varchar(32) NOT NULL default '',
  `affiliate_dob` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_email_address` varchar(96) NOT NULL default '',
  `affiliate_telephone` varchar(32) NOT NULL default '',
  `affiliate_fax` varchar(32) NOT NULL default '',
  `affiliate_password` varchar(40) NOT NULL default '',
  `affiliate_homepage` varchar(96) NOT NULL default '',
  `affiliate_street_address` varchar(64) NOT NULL default '',
  `affiliate_suburb` varchar(64) NOT NULL default '',
  `affiliate_city` varchar(32) NOT NULL default '',
  `affiliate_postcode` varchar(10) NOT NULL default '',
  `affiliate_state` varchar(32) NOT NULL default '',
  `affiliate_country_id` int(11) NOT NULL default '0',
  `affiliate_zone_id` int(11) NOT NULL default '0',
  `affiliate_agb` tinyint(4) NOT NULL default '0',
  `affiliate_company` varchar(60) NOT NULL default '',
  `affiliate_company_taxid` varchar(64) NOT NULL default '',
  `affiliate_commission_percent` decimal(4,2) NOT NULL default '0.00',
  `affiliate_payment_check` varchar(100) NOT NULL default '',
  `affiliate_payment_paypal` varchar(64) NOT NULL default '',
  `affiliate_payment_bank_name` varchar(64) NOT NULL default '',
  `affiliate_payment_bank_branch_number` varchar(64) NOT NULL default '',
  `affiliate_payment_bank_swift_code` varchar(64) NOT NULL default '',
  `affiliate_payment_bank_account_name` varchar(64) NOT NULL default '',
  `affiliate_payment_bank_account_number` varchar(64) NOT NULL default '',
  `affiliate_date_of_last_logon` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_number_of_logons` int(11) NOT NULL default '0',
  `affiliate_date_account_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_date_account_last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_lft` int(11) NOT NULL default '0',
  `affiliate_rgt` int(11) NOT NULL default '0',
  `affiliate_root` int(11) NOT NULL default '0',
  PRIMARY KEY  (`affiliate_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `affiliate_affiliate`
#

INSERT INTO `affiliate_affiliate` VALUES (1, 'm', 'Test', 'Affiliate', '0000-00-00 00:00:00', 'admin@aabox.com', '5555555555', '', 'a71194003d9cd77d44b56ac09c49f838:94', 'http://aabox.com', '111 Street', '', 'City', '55555', '', 223, 4, 1, 'Michael Sasek', '3225547899', '0.00', 'Mike Sasek', '', 'Wells', '1221548', '', 'Nike', '5224789', '2003-08-10 10:43:07', 5, '2003-07-19 23:36:51', '2003-08-12 00:19:33', 1, 2, 1);

# --------------------------------------------------------
# Table structure for table `affiliate_banners`
#

CREATE TABLE `affiliate_banners` (
  `affiliate_banners_id` int(11) NOT NULL auto_increment,
  `affiliate_banners_title` varchar(64) NOT NULL default '',
  `affiliate_products_id` int(11) NOT NULL default '0',
  `affiliate_banners_image` varchar(64) NOT NULL default '',
  `affiliate_banners_group` varchar(10) NOT NULL default '',
  `affiliate_banners_html_text` text,
  `affiliate_expires_impressions` int(7) default '0',
  `affiliate_expires_date` datetime default NULL,
  `affiliate_date_scheduled` datetime default NULL,
  `affiliate_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_date_status_change` datetime default NULL,
  `affiliate_status` int(1) NOT NULL default '1',
  PRIMARY KEY  (`affiliate_banners_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Dumping data for table `affiliate_banners`
#

INSERT INTO `affiliate_banners` VALUES (3, 'aabox1', 0, 'banners/aaboxcom.gif', '', NULL, 0, NULL, NULL, '2003-08-09 21:07:41', NULL, 1);

# --------------------------------------------------------
# Table structure for table `affiliate_banners_history`
#

CREATE TABLE `affiliate_banners_history` (
  `affiliate_banners_history_id` int(11) NOT NULL auto_increment,
  `affiliate_banners_products_id` int(11) NOT NULL default '0',
  `affiliate_banners_id` int(11) NOT NULL default '0',
  `affiliate_banners_affiliate_id` int(11) NOT NULL default '0',
  `affiliate_banners_shown` int(11) NOT NULL default '0',
  `affiliate_banners_clicks` tinyint(4) NOT NULL default '0',
  `affiliate_banners_history_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`affiliate_banners_history_id`,`affiliate_banners_products_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `affiliate_banners_history`
#


# --------------------------------------------------------
# Table structure for table `affiliate_clickthroughs`
#

CREATE TABLE `affiliate_clickthroughs` (
  `affiliate_clickthrough_id` int(11) NOT NULL auto_increment,
  `affiliate_id` int(11) NOT NULL default '0',
  `affiliate_clientdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_clientbrowser` varchar(200) default 'Could Not Find This Data',
  `affiliate_clientip` varchar(50) default 'Could Not Find This Data',
  `affiliate_clientreferer` varchar(200) default 'none detected (maybe a direct link)',
  `affiliate_products_id` int(11) default '0',
  `affiliate_banner_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`affiliate_clickthrough_id`),
  KEY `refid` (`affiliate_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `affiliate_clickthroughs`
#

INSERT INTO `affiliate_clickthroughs` VALUES (1, 1, '2003-08-09 19:43:08', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)', '68.3.210.157', 'http://aabox.com/ms2/catalog/affiliate_banners.php', 0, 2);
INSERT INTO `affiliate_clickthroughs` VALUES (2, 1, '2003-08-09 20:54:21', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)', '68.3.210.157', '', 0, 2);

# --------------------------------------------------------
# Table structure for table `affiliate_payment`
#

CREATE TABLE `affiliate_payment` (
  `affiliate_payment_id` int(11) NOT NULL auto_increment,
  `affiliate_id` int(11) NOT NULL default '0',
  `affiliate_payment` decimal(15,2) NOT NULL default '0.00',
  `affiliate_payment_tax` decimal(15,2) NOT NULL default '0.00',
  `affiliate_payment_total` decimal(15,2) NOT NULL default '0.00',
  `affiliate_payment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_payment_last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_payment_status` int(5) NOT NULL default '0',
  `affiliate_firstname` varchar(32) NOT NULL default '',
  `affiliate_lastname` varchar(32) NOT NULL default '',
  `affiliate_street_address` varchar(64) NOT NULL default '',
  `affiliate_suburb` varchar(64) NOT NULL default '',
  `affiliate_city` varchar(32) NOT NULL default '',
  `affiliate_postcode` varchar(10) NOT NULL default '',
  `affiliate_country` varchar(32) NOT NULL default '0',
  `affiliate_company` varchar(60) NOT NULL default '',
  `affiliate_state` varchar(32) NOT NULL default '0',
  `affiliate_address_format_id` int(5) NOT NULL default '0',
  `affiliate_last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`affiliate_payment_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# No default data for table `affiliate_payment`
#


# --------------------------------------------------------
# Table structure for table `affiliate_payment_status`
#

CREATE TABLE `affiliate_payment_status` (
  `affiliate_payment_status_id` int(11) NOT NULL default '0',
  `affiliate_language_id` int(11) NOT NULL default '1',
  `affiliate_payment_status_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`affiliate_payment_status_id`,`affiliate_language_id`),
  KEY `idx_affiliate_payment_status_name` (`affiliate_payment_status_name`)
) TYPE=MyISAM;

#
# Dumping data for table `affiliate_payment_status`
#

INSERT INTO `affiliate_payment_status` VALUES (0, 1, 'Pending');
INSERT INTO `affiliate_payment_status` VALUES (0, 2, 'Offen');
INSERT INTO `affiliate_payment_status` VALUES (0, 3, 'Pendiente');
INSERT INTO `affiliate_payment_status` VALUES (1, 1, 'Paid');
INSERT INTO `affiliate_payment_status` VALUES (1, 2, 'Ausgezahlt');
INSERT INTO `affiliate_payment_status` VALUES (1, 3, 'Pagado');

# --------------------------------------------------------
# Table structure for table `affiliate_payment_status_history`
#

CREATE TABLE `affiliate_payment_status_history` (
  `affiliate_status_history_id` int(11) NOT NULL auto_increment,
  `affiliate_payment_id` int(11) NOT NULL default '0',
  `affiliate_new_value` int(5) NOT NULL default '0',
  `affiliate_old_value` int(5) default NULL,
  `affiliate_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_notified` int(1) default '0',
  PRIMARY KEY  (`affiliate_status_history_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# No Default data for table `affiliate_payment_status_history`
#


# --------------------------------------------------------
# Table structure for table `affiliate_sales`
#

CREATE TABLE `affiliate_sales` (
  `affiliate_id` int(11) NOT NULL default '0',
  `affiliate_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_browser` varchar(100) NOT NULL default '',
  `affiliate_ipaddress` varchar(20) NOT NULL default '',
  `affiliate_orders_id` int(11) NOT NULL default '0',
  `affiliate_value` decimal(15,2) NOT NULL default '0.00',
  `affiliate_payment` decimal(15,2) NOT NULL default '0.00',
  `affiliate_clickthroughs_id` int(11) NOT NULL default '0',
  `affiliate_billing_status` int(5) NOT NULL default '0',
  `affiliate_payment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `affiliate_payment_id` int(11) NOT NULL default '0',
  `affiliate_percent` decimal(4,2) NOT NULL default '0.00',
  `affiliate_salesman` int(11) NOT NULL default '0',
  PRIMARY KEY  (`affiliate_orders_id`,`affiliate_id`)
) TYPE=MyISAM;

#
# Dumping data for table `affiliate_sales`
#

INSERT INTO `affiliate_sales` VALUES (1, '2003-08-11 23:44:47', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)', '68.3.210.157', 15, '39.99', '4.00', 3, 0, '0000-00-00 00:00:00', 0, '10.00', 1);
INSERT INTO `affiliate_sales` VALUES (1, '2003-08-11 23:48:35', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)', '68.3.210.157', 16, '4999.90', '499.99', 3, 0, '0000-00-00 00:00:00', 0, '10.00', 1);

# --------------------------------------------------------
# Table structure for table `coupon_email_track`
#

CREATE TABLE `coupon_email_track` (
  `unique_id` int(11) NOT NULL auto_increment,
  `coupon_id` int(11) NOT NULL default '0',
  `customer_id_sent` int(11) NOT NULL default '0',
  `sent_firstname` varchar(32) default NULL,
  `sent_lastname` varchar(32) default NULL,
  `emailed_to` varchar(32) default NULL,
  `date_sent` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`unique_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Dumping data for table `coupon_email_track`
#

INSERT INTO `coupon_email_track` VALUES (1, 1, 2, 'Test', 'User', 'admin@aabox.com', '2003-07-29 13:52:48');
INSERT INTO `coupon_email_track` VALUES (2, 2, 0, 'Admin', NULL, 'admin@aabox.com', '2003-07-29 13:54:44');
INSERT INTO `coupon_email_track` VALUES (3, 3, 0, 'Admin', NULL, 'admin@aabox.com', '2003-07-29 13:54:44');
INSERT INTO `coupon_email_track` VALUES (4, 4, 0, 'Admin', NULL, 'msasek1@cox.net', '2003-08-03 17:38:50');

# --------------------------------------------------------
# Table structure for table `coupon_gv_customer`
#

CREATE TABLE `coupon_gv_customer` (
  `customer_id` int(5) NOT NULL default '0',
  `amount` decimal(8,4) NOT NULL default '0.0000',
  PRIMARY KEY  (`customer_id`),
  KEY `customer_id` (`customer_id`)
) TYPE=MyISAM;

#
# Dumping data for table `coupon_gv_customer`
#

INSERT INTO `coupon_gv_customer` VALUES (2, '37.5000');
INSERT INTO `coupon_gv_customer` VALUES (3, '70.0000');

# --------------------------------------------------------
# Table structure for table `coupon_gv_queue`
#

CREATE TABLE `coupon_gv_queue` (
  `unique_id` int(5) NOT NULL auto_increment,
  `customer_id` int(5) NOT NULL default '0',
  `order_id` int(5) NOT NULL default '0',
  `amount` decimal(8,4) NOT NULL default '0.0000',
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `ipaddr` varchar(32) NOT NULL default '',
  `release_flag` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`unique_id`),
  KEY `uid` (`unique_id`,`customer_id`,`order_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `coupon_gv_queue`
#

INSERT INTO `coupon_gv_queue` VALUES (1, 2, 7, '10.0000', '2003-07-29 13:05:52', '68.3.210.157', 'Y');
INSERT INTO `coupon_gv_queue` VALUES (2, 2, 9, '20.0000', '2003-07-29 15:17:57', '68.3.210.157', 'Y');

# --------------------------------------------------------
# Table structure for table `coupon_redeem_track`
#

CREATE TABLE `coupon_redeem_track` (
  `unique_id` int(11) NOT NULL auto_increment,
  `coupon_id` int(11) NOT NULL default '0',
  `customer_id` int(11) NOT NULL default '0',
  `redeem_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `redeem_ip` varchar(32) NOT NULL default '',
  `order_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`unique_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Dumping data for table `coupon_redeem_track`
#

INSERT INTO `coupon_redeem_track` VALUES (1, 1, 3, '2003-07-29 13:55:58', '68.3.210.157', 0);
INSERT INTO `coupon_redeem_track` VALUES (2, 3, 2, '2003-08-02 22:17:33', '68.3.210.157', 12);
INSERT INTO `coupon_redeem_track` VALUES (3, 4, 2, '2003-08-03 17:39:47', '68.3.210.157', 0);

# --------------------------------------------------------
# Table structure for table `coupons`
#

CREATE TABLE `coupons` (
  `coupon_id` int(11) NOT NULL auto_increment,
  `coupon_type` char(1) NOT NULL default 'F',
  `coupon_code` varchar(32) NOT NULL default '',
  `coupon_amount` decimal(8,4) NOT NULL default '0.0000',
  `coupon_minimum_order` decimal(8,4) NOT NULL default '0.0000',
  `coupon_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `coupon_expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `uses_per_coupon` int(5) NOT NULL default '1',
  `uses_per_user` int(5) NOT NULL default '0',
  `restrict_to_products` varchar(255) default NULL,
  `restrict_to_categories` varchar(255) default NULL,
  `restrict_to_customers` text,
  `coupon_active` char(1) NOT NULL default 'Y',
  `date_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`coupon_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Dumping data for table `coupons`
#

INSERT INTO `coupons` VALUES (1, 'G', '253e20d2fc', '10.0000', '0.0000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, NULL, NULL, NULL, 'N', '2003-07-29 13:52:48', '0000-00-00 00:00:00');
INSERT INTO `coupons` VALUES (2, 'G', '7428010604', '10.0000', '0.0000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, NULL, NULL, NULL, 'Y', '2003-07-29 13:54:44', '0000-00-00 00:00:00');
INSERT INTO `coupons` VALUES (3, 'P', '5dd5cb', '10.0000', '10.0000', '2003-08-02 00:00:00', '2004-08-02 00:00:00', 0, 1, '', '', NULL, 'Y', '2003-08-02 22:15:16', '2003-08-02 22:15:16');
INSERT INTO `coupons` VALUES (4, 'G', '61ea6c', '50.0000', '0.0000', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 0, NULL, NULL, NULL, 'N', '2003-08-03 17:38:50', '0000-00-00 00:00:00');

# --------------------------------------------------------
# Table structure for table `coupons_description`
#

CREATE TABLE `coupons_description` (
  `coupon_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '0',
  `coupon_name` varchar(32) NOT NULL default '',
  `coupon_description` text,
  KEY `coupon_id` (`coupon_id`)
) TYPE=MyISAM;

#
# Dumping data for table `coupons_description`
#

INSERT INTO `coupons_description` VALUES (3, 1, 'Coupon 10', '10 percent off with this coupon.');
INSERT INTO `coupons_description` VALUES (3, 2, '', '');
INSERT INTO `coupons_description` VALUES (3, 3, '', '');

# --------------------------------------------------------
# Table structure for table `paypalipn_txn`
#

CREATE TABLE `paypalipn_txn` (
  `paypalipn_txn_id` int(11) NOT NULL auto_increment,
  `txn_id` varchar(17) NOT NULL default '',
  `ipn_result` varchar(10) NOT NULL default '',
  `receiver_email` varchar(255) NOT NULL default '',
  `business` varchar(255) NOT NULL default '',
  `item_name` varchar(96) NOT NULL default '',
  `item_number` int(11) NOT NULL default '0',
  `quantity` int(11) NOT NULL default '0',
  `invoice` varchar(255) NOT NULL default '',
  `custom` varchar(255) NOT NULL default '',
  `option_name1` varchar(255) NOT NULL default '',
  `option_selection1` varchar(255) NOT NULL default '',
  `option_name2` varchar(255) NOT NULL default '',
  `option_selection2` varchar(255) NOT NULL default '',
  `num_cart_items` int(11) NOT NULL default '0',
  `payment_status` varchar(10) NOT NULL default '',
  `pending_reason` varchar(10) NOT NULL default '',
  `payment_date` varchar(100) NOT NULL default '',
  `settle_amount` varchar(32) NOT NULL default '',
  `settle_currency` varchar(32) NOT NULL default '',
  `exchange_rate` varchar(32) NOT NULL default '',
  `payment_gross` decimal(15,4) NOT NULL default '0.0000',
  `payment_fee` decimal(15,4) NOT NULL default '0.0000',
  `mc_gross` decimal(15,4) NOT NULL default '0.0000',
  `mc_fee` decimal(15,4) NOT NULL default '0.0000',
  `mc_currency` varchar(10) NOT NULL default '',
  `tax` varchar(32) NOT NULL default '',
  `txn_type` varchar(10) NOT NULL default '',
  `for_auction` varchar(255) NOT NULL default '',
  `memo` varchar(255) NOT NULL default '',
  `first_name` varchar(32) NOT NULL default '',
  `last_name` varchar(32) NOT NULL default '',
  `address_street` varchar(64) NOT NULL default '',
  `address_city` varchar(64) NOT NULL default '',
  `address_state` varchar(64) NOT NULL default '',
  `address_zip` varchar(10) NOT NULL default '',
  `address_country` varchar(32) NOT NULL default '',
  `address_status` varchar(11) NOT NULL default '',
  `payer_email` varchar(96) NOT NULL default '',
  `payer_id` varchar(128) NOT NULL default '',
  `payer_status` varchar(15) NOT NULL default '',
  `payment_type` varchar(7) NOT NULL default '',
  `notify_version` varchar(5) NOT NULL default '',
  `verify_sign` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`paypalipn_txn_id`),
  KEY `txn_id` (`txn_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `paypalipn_txn`
#

INSERT INTO `paypalipn_txn` VALUES (1, '1059874521', 'VERIFIED', 'msasek@synergetichealth.com', 'msasek@synergetichealth.com', 'item name', 14, 1, '222', '', '', '', '', '', 1, 'Completed', '', '19:35:21 Aug 2, 2003 PST', '', '', '', '25.0000', '1.0200', '25.0000', '1.0200', '', '', 'web_accept', '', '', 'Mike', 'Sasek', '111 Street', 'city', 'state', 'zip', 'United-States', 'confirmed', 'email@email.com', 'XPN8XCWPYAMW5', 'verified', 'instant', '1.4', 'DfDT6KaaWATTjfyzTIv4pohGWAs0XDitN19Y');
INSERT INTO `paypalipn_txn` VALUES (2, '1059874603', 'VERIFIED', 'msasek@synergetichealth.com', 'msasek@synergetichealth.com', 'item name', 11, 1, '111', '', '', '', '', '', 1, 'Completed', '', '19:36:43 Aug 2, 2003 PST', '', '', '', '25.0000', '1.0200', '25.0000', '1.0200', '', '', 'web_accept', '', '', 'Mike', 'Sasek', '111 Street', 'city', 'state', 'zip', 'United-States', 'confirmed', 'email@email.com', 'XPN8XCWPYAMW5', 'verified', 'instant', '1.4', 'DfDT6KaaWATTjfyzTIv4pohGWAs0XDitN19Y');

# --------------------------------------------------------
# Table structure for table `products_xsell`
#

CREATE TABLE `products_xsell` (
  `ID` int(10) NOT NULL auto_increment,
  `products_id` int(10) unsigned NOT NULL default '1',
  `xsell_id` int(10) unsigned NOT NULL default '1',
  `sort_order` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

#
# Dumping data for table `products_xsell`
#

INSERT INTO `products_xsell` VALUES (1, 8, 20, 1);
INSERT INTO `products_xsell` VALUES (2, 8, 5, 1);
INSERT INTO `products_xsell` VALUES (3, 8, 16, 1);
INSERT INTO `products_xsell` VALUES (4, 8, 12, 1);
INSERT INTO `products_xsell` VALUES (5, 8, 24, 1);
INSERT INTO `products_xsell` VALUES (6, 1, 27, 1);
INSERT INTO `products_xsell` VALUES (7, 1, 3, 1);
INSERT INTO `products_xsell` VALUES (8, 1, 25, 1);

# --------------------------------------------------------
# The End
    have fun!
  2. 08-14-2003, 12:55 PM #2
    michael_s
    michael_s is offline
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Donation Award 
    Rep Power
    567

    Default

    Thanks for that update. This should help a lot of folks out
    Michael Sasek
    osCMax Developer

    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation
  3. 08-15-2003, 12:42 PM #3
    Anonymous
    Guest

    Default

    Sorry forgot some entries:

    Code:
    INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function) VALUES ('PRODUCT DESCRIPTIONS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE', 'Enable', 'Enable/Disable WYSIWYG box', 112, 0, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function) VALUES ('Product Description Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_PD', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 10, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function) VALUES ('Product Description Layout Width', 'HTML_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 15, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function) VALUES ('Product Description Layout Height', 'HTML_AREA_WYSIWYG_HEIGHT', '240', 'How HIGH should the HTMLAREA be in pixels (default: 240)', 112, 19, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function) VALUES ('CUSTOMER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_EMAIL', 'Enable', 'Use WYSIWYG Area in Email Customers', 112, 20, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function) VALUES ('Customer Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_EMAIL', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 21, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Customer Email Layout Width', 'EMAIL_AREA_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 25, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Customer Email Layout Height', 'EMAIL_AREA_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 29, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('NEWSLETTER EMAILS use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_NEWSLETTER', 'Enable', 'Use WYSIWYG Area in Email Newsletter', 112, 30, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Newsletter Email Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_NEWSLETTER', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 32, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Newsletter Email Layout Width', 'NEWSLETTER_EMAIL_WYSIWYG_WIDTH', '505', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 35, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Newsletter Email Layout Height', 'NEWSLETTER_EMAIL_WYSIWYG_HEIGHT', '140', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 39, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('DEFINE MAINPAGE use WYSIWYG HTMLAREA?', 'HTML_AREA_WYSIWYG_DISABLE_DEFINE', 'Enable', 'Use WYSIWYG Area in Define Mainpage', 112, 40, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Enable\', \'Disable\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Define Mainpage Basic/Advanced Version?', 'HTML_AREA_WYSIWYG_BASIC_DEFINE', 'Basic', 'Basic Features FASTER<br>Advanced Features SLOWER', 112, 41, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Basic\', \'Advanced\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Define Mainpage Layout Width', 'DEFINE_MAINPAGE_WYSIWYG_WIDTH', '605', 'How WIDE should the HTMLAREA be in pixels (default: 505)', 112, 42, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Define Mainpage Layout Height', 'DEFINE_MAINPAGE_WYSIWYG_HEIGHT', '300', 'How HIGH should the HTMLAREA be in pixels (default: 140)', 112, 43, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('GLOBAL - User Interface Font Type', 'HTML_AREA_WYSIWYG_FONT_TYPE', 'Times New Roman', 'User Interface Font Type<br>(not saved to product description)', 112, 45, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'Arial\', \'Courier New\', \'Georgia\', \'Impact\', \'Tahoma\', \'Times New Roman\', \'Verdana\', \'Wingdings\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('GLOBAL - User Interface Font Size', 'HTML_AREA_WYSIWYG_FONT_SIZE', '12', 'User Interface Font Size (not saved to product description)<p><b>10 Equals 10 pt', 112, 50, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\\\'8\\\', \\\'10\\\', \\\'12\\\', \\\'14\\\', \\\'18\\\', \\\'24\\\', \\\'36\\\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('GLOBAL - User Interface Font Colour', 'HTML_AREA_WYSIWYG_FONT_COLOUR', 'Black', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or HTML colour code!<br>(not saved to product description)', 112, 55, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('GLOBAL - User Interface Background Colour', 'HTML_AREA_WYSIWYG_BG_COLOUR', 'White', 'White, Black, C0C0C0, Red, FFFFFF, Yellow, Pink, Blue, Gray, 000000, ect..<br>basically any colour or html colour code!<br>(not saved to product description)', 112, 60, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, '');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('GLOBAL - ALLOW DEBUG MODE?', 'HTML_AREA_WYSIWYG_DEBUG', '0', 'Moniter Live-html, It updates as you type in a 2nd field above it.<p>Disable Debug = 0<br>Enable Debug = 1<br>Default = 0 OFF', 112, 65, '2003-07-17 12:41:25', '2003-07-17 12:41:25', NULL, 'tep_cfg_select_option(array(\'0\', \'1\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('E-Mail Address', 'AFFILIATE_EMAIL_ADDRESS', '<affiliate@localhost.com>', 'The E Mail Address for the Affiliate Programm', 900, 1, '2003-07-17 21:46:04', '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Affiliate Pay Per Sale Payment % Rate', 'AFFILIATE_PERCENT', '10.0000', 'Percentage Rate for the Affiliate Program', 900, 2, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Payment Threshold', 'AFFILIATE_THRESHOLD', '50.00', 'Payment Threshold for paying affiliates', 900, 3, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Cookie Lifetime', 'AFFILIATE_COOKIE_LIFETIME', '7200', 'How long does the click count (seconds) if customer comes back', 900, 4, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Billing Time', 'AFFILIATE_BILLING_TIME', '30', 'Orders billed must be at least "30" days old.<br>This is needed if a order is refunded', 900, 5, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Order Min Status', 'AFFILIATE_PAYMENT_ORDER_MIN_STATUS', '3', 'The status an order must have at least, to be billed', 900, 6, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Pay Affiliates with check', 'AFFILIATE_USE_CHECK', 'true', 'Pay Affiliates with check', 900, 7, NULL, '2003-07-17 13:48:39', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Pay Affiliates with PayPal', 'AFFILIATE_USE_PAYPAL', 'true', 'Pay Affiliates with PayPal', 900, 8, NULL, '2003-07-17 13:48:39', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Pay Affiliates by Bank', 'AFFILIATE_USE_BANK', 'true', 'Pay Affiliates by Bank', 900, 9, NULL, '2003-07-17 13:48:39', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Individual Affiliate Percentage', 'AFFILATE_INDIVIDUAL_PERCENTAGE', 'true', 'Allow per Affiliate provision', 900, 10, NULL, '2003-07-17 13:48:39', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Use Affiliate-tier', 'AFFILATE_USE_TIER', 'false', 'Multilevel Affiliate provisions', 900, 11, '2003-07-17 21:46:43', '2003-07-17 13:48:39', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Number of Tierlevels', 'AFFILIATE_TIER_LEVELS', '0', 'Number of Tierlevels', 900, 12, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Percentage Rate for the Tierlevels', 'AFFILIATE_TIER_PERCENTAGE', '8.00;5.00;1.00', 'Percent Rates for the tierlevels<br>Example: 8.00;5.00;1.00', 900, 13, NULL, '2003-07-17 13:48:39', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Display Total', 'MODULE_ORDER_TOTAL_COUPON_STATUS', 'true', 'Do you want to display the Discount Coupon value?', 6, 1, NULL, '2003-07-26 14:23:49', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Sort Order', 'MODULE_ORDER_TOTAL_COUPON_SORT_ORDER', '9', 'Sort order of display.', 6, 2, NULL, '2003-07-26 14:23:49', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Include Shipping', 'MODULE_ORDER_TOTAL_COUPON_INC_SHIPPING', 'true', 'Include Shipping in calculation', 6, 5, NULL, '2003-07-26 14:23:49', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Include Tax', 'MODULE_ORDER_TOTAL_COUPON_INC_TAX', 'false', 'Include Tax in calculation.', 6, 6, NULL, '2003-07-26 14:23:49', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Re-calculate Tax', 'MODULE_ORDER_TOTAL_COUPON_CALC_TAX', 'None', 'Re-Calculate Tax', 6, 7, NULL, '2003-07-26 14:23:49', NULL, 'tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Tax Class', 'MODULE_ORDER_TOTAL_COUPON_TAX_CLASS', '0', 'Use the following tax class when treating Discount Coupon as Credit Note.', 6, 0, NULL, '2003-07-26 14:23:49', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Display Total', 'MODULE_ORDER_TOTAL_GV_STATUS', 'true', 'Do you want to display the Gift Voucher value?', 6, 1, NULL, '2003-07-26 14:23:56', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Sort Order', 'MODULE_ORDER_TOTAL_GV_SORT_ORDER', '740', 'Sort order of display.', 6, 2, NULL, '2003-07-26 14:23:56', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Queue Purchases', 'MODULE_ORDER_TOTAL_GV_QUEUE', 'true', 'Do you want to queue purchases of the Gift Voucher?', 6, 3, NULL, '2003-07-26 14:23:56', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Include Shipping', 'MODULE_ORDER_TOTAL_GV_INC_SHIPPING', 'true', 'Include Shipping in calculation', 6, 5, NULL, '2003-07-26 14:23:56', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Include Tax', 'MODULE_ORDER_TOTAL_GV_INC_TAX', 'false', 'Include Tax in calculation.', 6, 6, NULL, '2003-07-26 14:23:56', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Re-calculate Tax', 'MODULE_ORDER_TOTAL_GV_CALC_TAX', 'None', 'Re-Calculate Tax', 6, 7, NULL, '2003-07-26 14:23:56', NULL, 'tep_cfg_select_option(array(\'None\', \'Standard\', \'Credit Note\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Tax Class', 'MODULE_ORDER_TOTAL_GV_TAX_CLASS', '0', 'Use the following tax class when treating Gift Voucher as Credit Note.', 6, 0, NULL, '2003-07-26 14:23:56', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Credit including Tax', 'MODULE_ORDER_TOTAL_GV_CREDIT_TAX', 'false', 'Add tax to purchased Gift Voucher when crediting to Account', 6, 8, NULL, '2003-07-26 14:23:56', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Sort Order', 'MODULE_SHIPPING_ITEM_SORT_ORDER', '200', 'Sort order of display.', 6, 0, NULL, '2003-07-29 13:03:16', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Shipping Zone', 'MODULE_SHIPPING_ITEM_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2003-07-29 13:03:16', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Tax Class', 'MODULE_SHIPPING_ITEM_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2003-07-29 13:03:16', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Handling Fee', 'MODULE_SHIPPING_ITEM_HANDLING', '0', 'Handling fee for this shipping method.', 6, 0, NULL, '2003-07-29 13:03:16', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Shipping Cost', 'MODULE_SHIPPING_ITEM_COST', '2.50', 'The shipping cost will be multiplied by the number of items in an order that uses this shipping method.', 6, 0, NULL, '2003-07-29 13:03:16', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Enable Item Shipping', 'MODULE_SHIPPING_ITEM_STATUS', 'True', 'Do you want to offer per item rate shipping?', 6, 0, NULL, '2003-07-29 13:03:16', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Add Shipping to Amount', 'MODULE_PAYMENT_PAYPALIPN_ADD_SHIPPING_TO_AMOUNT', 'False', 'Add shipping amount to order amount? (will set shipping amount to $0 in PayPal)', 6, 5, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Use cURL', 'MODULE_PAYMENT_PAYPALIPN_CURL', 'True', 'Use cURL to communicate with PayPal?<br>cURL has been <b>DETECTED</b> in your system', 6, 4, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Notify URL', 'MODULE_PAYMENT_PAYPALIPN_NOTIFY_URL', 'http://aabox.com/ms2/catalog/paypal_notify.php', 'Exact location in which your paypal_notify.php file resides.', 6, 3, NULL, '2003-08-02 18:29:38', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('PayPal ID', 'MODULE_PAYMENT_PAYPALIPN_ID', 'msasek@synergetichealth.com', 'Your business ID at PayPal.  Usually the email address you signed up with.  You can create a free PayPal account at <a href="http://www.paypal.com/" target="_blank">http://www.paypal.com</a>.', 6, 2, NULL, '2003-08-02 18:29:38', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Allow PayPal IPN', 'MODULE_PAYMENT_PAYPALIPN_STATUS', 'True', 'Do you want to accept PayPal IPN payments and notifications?', 6, 1, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Allow Category Descriptions', 'ALLOW_CATEGORY_DESCRIPTIONS', 'true', 'Allow use of full text descriptions for categories', 1, 19, '2003-08-02 14:50:12', '2003-08-02 13:42:39', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Add Tax to Amount', 'MODULE_PAYMENT_PAYPALIPN_ADD_TAX_TO_AMOUNT', 'False', 'Add tax amount to order amount? (will set tax amount to $0 in PayPal)', 6, 5, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Update Stock Before Payment', 'MODULE_PAYMENT_PAYPALIPN_UPDATE_STOCK_BEFORE_PAYMENT', 'True', 'Should Products Stock be updated even when the payment is not yet COMPLETED?', 6, 6, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Allowed Currencies', 'MODULE_PAYMENT_PAYPALIPN_ALLOWED_CURRENCIES', 'USD,EUR', 'Allowed currencies in which customers can pay.<br>Allowed by PayPal: USD,EUR,GBP,CAD,JPY<br>Allowed in your shop: USD,EUR<br>To add more currencies to your shop go to Localization->Currencies.', 6, 9, NULL, '2003-08-02 18:29:38', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Default Currency', 'MODULE_PAYMENT_PAYPALIPN_DEFAULT_CURRENCY', 'USD', 'Default currency to use when customer try to pay in a NON allowed (because of PayPal or you) currency', 6, 10, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'USD\', \'EUR\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Test Mode', 'MODULE_PAYMENT_PAYPALIPN_TEST_MODE', 'True', 'Run in TEST MODE? If so, you will be able to send TEST IPN from Admin->PayPal_IPN->Test_IPN, BUT you will not be able to receive real IPN\'s from PayPal.', 6, 11, NULL, '2003-08-02 18:29:38', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Sort order of display.', 'MODULE_PAYMENT_PAYPALIPN_SORT_ORDER', '50', 'Sort order of display. Lowest is displayed first.', 6, 12, NULL, '2003-08-02 18:29:38', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Payment Zone', 'MODULE_PAYMENT_PAYPALIPN_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', 6, 13, NULL, '2003-08-02 18:29:38', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Set Order Status', 'MODULE_PAYMENT_PAYPALIPN_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', 6, 14, NULL, '2003-08-02 18:29:38', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Enable UPS Shipping', 'MODULE_SHIPPING_UPS_STATUS', 'True', 'Do you want to offer UPS shipping?', 6, 0, NULL, '2003-08-07 19:12:23', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('UPS Pickup Method', 'MODULE_SHIPPING_UPS_PICKUP', 'CC', 'How do you give packages to UPS? CC - Customer Counter, RDP - Daily Pickup, OTP - One Time Pickup, LC - Letter Center, OCA - On Call Air', 6, 0, NULL, '2003-08-07 19:12:23', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('UPS Packaging?', 'MODULE_SHIPPING_UPS_PACKAGE', 'CP', 'CP - Your Packaging, ULE - UPS Letter, UT - UPS Tube, UBE - UPS Express Box', 6, 0, NULL, '2003-08-07 19:12:23', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Residential Delivery?', 'MODULE_SHIPPING_UPS_RES', 'RES', 'Quote for Residential (RES) or Commercial Delivery (COM)', 6, 0, NULL, '2003-08-07 19:12:23', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Handling Fee', 'MODULE_SHIPPING_UPS_HANDLING', '0', 'Handling fee for this shipping method.', 6, 0, NULL, '2003-08-07 19:12:23', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Tax Class', 'MODULE_SHIPPING_UPS_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', 6, 0, NULL, '2003-08-07 19:12:23', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Shipping Zone', 'MODULE_SHIPPING_UPS_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', 6, 0, NULL, '2003-08-07 19:12:23', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Sort order of display.', 'MODULE_SHIPPING_UPS_SORT_ORDER', '300', 'Sort order of display. Lowest is displayed first.', 6, 0, NULL, '2003-08-07 19:12:23', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Shipping Methods', 'MODULE_SHIPPING_UPS_TYPES', 'GND', 'Select the USPS services to be offered.', 6, 13, NULL, '2003-08-07 19:12:23', NULL, 'tep_cfg_select_multioption(array(\'1DM\',\'1DML\', \'1DA\', \'1DAL\', \'1DAPI\', \'1DP\', \'1DPL\', \'2DM\', \'2DML\', \'2DA\', \'2DAL\', \'3DS\',\'GND\', \'STD\', \'XPR\', \'XPRL\', \'XDM\', \'XDML\', \'XPD\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Main Big Pic Extension', 'BIG_PIC_EXT', '_big', 'This is if you name your main big image like IMAGE_big.jpg, you would put <b>_big</b> here.  Otherwise leave it blank', 99, 6, '2003-08-08 22:11:00', '2003-08-08 02:40:20', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Mo Pics Thumbnail Image Type', 'THUMB_IMAGE_TYPE', 'gif', 'The file type of the mopic thumbnails', 99, 7, '2003-08-08 02:46:09', '2003-08-08 02:40:20', NULL, 'tep_cfg_select_option(array(\'jpg\', \'gif\', \'png\', \'bmp\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Big Images Directory', 'IN_IMAGE_BIGIMAGES', 'images_big/', 'The directory inside catalog/ images where your big images are stored.', 99, 1, NULL, '2003-08-08 02:40:20', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Mo Pics Big Image Type', 'BIG_IMAGE_TYPE', 'gif', 'The file type of the mopic big images', 99, 8, '2003-08-08 02:46:17', '2003-08-08 02:40:20', NULL, 'tep_cfg_select_option(array(\'jpg\', \'gif\', \'png\', \'bmp\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Thumbnail Images Directory', 'IN_IMAGE_THUMBS', 'thumbs/', 'The directory inside catalog/ images where you extra image thumbs are stored.', 99, 2, NULL, '2003-08-08 02:40:20', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Main Thumbnail In Thumb Directory', 'MAIN_THUMB_IN_SUBDIR', 'true', 'If you store your main thumb in the thumbnail directory set this true.  If it is in the main image dir, set it false.', 99, 3, '2003-08-08 22:05:34', '2003-08-08 02:40:20', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Number of Pics per Row', 'THUMBS_PER_ROW', '4', 'How Many images to show per row.', 99, 4, NULL, '2003-08-08 02:40:20', NULL, NULL);
INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, last_modified, use_function, set_function)  VALUES ('Mo Pics Extension', 'MORE_PICS_EXT', '_pic', 'The addition to your image name for the mopics', 99, 5, NULL, '2003-08-08 02:40:20', NULL, NULL);
    This adds more info into an existing database.
  4. 08-19-2003, 12:30 PM #4
    unistar
    unistar is offline
    New Member
    Join Date
    Oct 2002
    Posts
    9
    Rep Power
    0

    Default

    So after "end" goes the second part.
    Has anyone tested this?

    Is this the procedure recommended by OSCDox?
  5. 08-19-2003, 03:26 PM #5
    michael_s
    michael_s is offline
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Donation Award 
    Rep Power
    567

    Default

    Sure, but if remember to BACKUP your database BEFORE doing this, that way if something goes awry, you can restore your original.

    I dont expect you should have problems but:

    You have been warned
    Michael Sasek
    osCMax Developer

    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation
  6. 08-20-2003, 06:48 AM #6
    unistar
    unistar is offline
    New Member
    Join Date
    Oct 2002
    Posts
    9
    Rep Power
    0

    Default

    So the oscommerce.sql database is the original then you just add the second database included in the install, right?
  7. 08-20-2003, 10:19 AM #7
    michael_s
    michael_s is offline
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Donation Award 
    Rep Power
    567

    Default

    Nope. The ms2-max.sql is a full database for a full install. It is not just the changes. The oscommerce.sql file is there for historical purposes, or if you get into trouble and want to see the original db structure.

    If all you want to do is update your db without overwriting it, use the above instructions, it will only add the changes.
    Michael Sasek
    osCMax Developer

    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation
  8. 08-20-2003, 10:41 AM #8
    unistar
    unistar is offline
    New Member
    Join Date
    Oct 2002
    Posts
    9
    Rep Power
    0

    Default

    So if I understand correct:
    to use MS2-MAX just use ms2-max.sql
    correct?
  9. 08-20-2003, 11:05 AM #9
    michael_s
    michael_s is offline
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Donation Award 
    Rep Power
    567

    Default

    You are correct sir!
    Michael Sasek
    osCMax Developer

    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation
  10. 08-23-2003, 02:36 AM #10
    Anonymous
    Guest

    Default

    Hi
    I tried installing ms2 max on my loclhost and on install have the error
    "SQL file does not exist: /install/ms2-max.sql" The file is there plain as day. I have tried downloading a fresh copy but still the same problem. Any ideas?
Page 1 of 3 123 LastLast
« Align pics in category headers? | move title up in code? should be right after <head> »

Similar Threads

  1. Default install credit card and shipping problems
    By fourmat in forum osCmax v2 Installation issues
    Replies: 3
    Last Post: 06-02-2006, 03:28 PM
  2. catalog/install/install.php?step=2 repeats
    By devarajan.g in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 12-19-2004, 08:54 PM
  3. How to get rid of the "Welcome to AABox's MS2.." i
    By prankerz in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 10-27-2004, 10:16 AM
  4. /catalog/install/install.php?step=2 just hanging
    By geller in forum osCommerce 2.2 Installation Help
    Replies: 0
    Last Post: 12-03-2003, 02:34 PM
  5. default.php help
    By talon in forum osCommerce 2.2 Installation Help
    Replies: 7
    Last Post: 01-23-2003, 05:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules