Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Installing mvs 1.1


Guest

Recommended Posts

So first step before installing this contribution is i need to run mvs.sql as stated in the install text. "If you have NOT already run the mvs.sql file do that now." how do i run this. is it done through my control panel and if so what do i put in their. Here is sql document, would i put the whole document in at one or do i need to break it up? Im not to familiar with sql so any help would be great. Thanks again,

Jesse

 

 

#

# mvs.sql

# For MVS V1.0 2006/03/25 JCK/CWG

# osCommerce, Open Source E-Commerce Solutions

#

 

#

# Modify Table structure for table `configuration`

#

 

INSERT INTO `configuration` VALUES (NULL, 'Enable Vendor Shipping', 'SELECT_VENDOR_SHIPPING', 'false', 'Enable Multi-Vendor shipping-(true/false)', 7, 6, '2004-09-07 13:19:40', '2004-05-04 14:43:03', NULL, 'tep_cfg_select_option(array(''true'', ''false''),');

 

INSERT INTO `configuration` VALUES ('NULL', 'Use Optional Confirmation Email', 'SELECT_VENDOR_EMAIL_OPTION', 'false', 'Use the email showing a seperated list of Vendor''s group of products-(true/false)', '7', '10', '2005-03-16 08:10:45', '2004-05-04 14:43:03', NULL , 'tep_cfg_select_option(array(''true'', ''false''),'

);

 

INSERT INTO `configuration` VALUES ('NULL', 'When to send the Vendor Email', 'SELECT_VENDOR_EMAIL_WHEN', 'Admin', 'Select when in the checkout process to send the email to the Vendors. You can also disable automatic email. See the readme.txt file for details on these options.', '7', '11', NULL , '2005-04-25 11:00:43', NULL , 'tep_cfg_select_option(array(''Catalog'', ''Admin'', ''Both'', ''Not at all''),'

);

 

 

#

# Table structure for table `orders_shipping`

#

 

CREATE TABLE `orders_shipping` (

`orders_shipping_id` int(11) NOT NULL auto_increment,

`orders_id` int(11) NOT NULL default '0',

`vendors_id` int(11) NOT NULL default '1',

`shipping_module` varchar(16) NOT NULL default '',

`shipping_method` varchar(128) NOT NULL default '',

`shipping_cost` decimal(15,4) NOT NULL default '0.000',

`shipping_tax` decimal(15,4) NOT NULL default '0.000',

`vendors_name` varchar(64) NOT NULL default '',

`vendor_order_sent` varchar(3) NOT NULL default 'no',

PRIMARY KEY (`orders_shipping_id`)

) TYPE=MyISAM AUTO_INCREMENT=0 ;

 

#

# Table modification for table `orders_products`

#

 

ALTER TABLE `orders_products` ADD `vendors_id` int(11) NOT NULL default '1';

 

#

# Modify Table structure for table `products`

#

 

ALTER TABLE `products` ADD `vendors_id` int(11) default '1';

ALTER TABLE `products` ADD `vendors_product_price` decimal(15,4) NOT NULL default '0.0000';

ALTER TABLE `products` ADD `vendors_prod_id` varchar(24) NOT NULL default '';

ALTER TABLE `products` ADD `vendors_prod_comments` text;

 

#

# Table structure for table `vendor_configuration`

#

 

CREATE TABLE `vendor_configuration` (

`vendor_configuration_id` int(11) NOT NULL auto_increment,

`configuration_title` varchar(64) NOT NULL default '',

`configuration_key` varchar(64) NOT NULL default '',

`configuration_value` text,

`configuration_description` varchar(255) NOT NULL default '',

`configuration_group_id` int(11) NOT NULL default '0',

`sort_order` int(5) default NULL,

`last_modified` datetime default NULL,

`date_added` datetime NOT NULL default '0000-00-00 00:00:00',

`use_function` varchar(255) default NULL,

`set_function` text,

`vendors_id` int(11) NOT NULL default '0',

PRIMARY KEY (`vendor_configuration_id`)

) TYPE=MyISAM AUTO_INCREMENT=0 ;

 

#

# Table structure for table `vendors`

#

 

CREATE TABLE `vendors` (

`vendors_id` int(11) NOT NULL auto_increment,

`vendors_contact` varchar(32) NOT NULL default '',

`vendors_name` varchar(32) NOT NULL default '',

`vendors_phone1` varchar(20) NOT NULL default '',

`vendors_phone2` varchar(20) NOT NULL default '',

`vendors_fax` varchar(20) NOT NULL default '',

`vendors_email` varchar(64) NOT NULL default '',

`vendors_url` varchar(64) NOT NULL default '',

`vendors_comments` text,

`date_added` datetime default NULL,

`last_modified` datetime default NULL,

`vendors_image` varchar(32) default NULL,

`vendors_send_email` tinyint(1) default '0',

`vendors_status_send` int(11) NOT NULL default '2',

`vendors_zipcode` varchar(11) NOT NULL default '',

`vendor_street` varchar(32) default NULL,

`vendor_add2` varchar(32) default NULL,

`vendor_city` varchar(32) NOT NULL default '',

`vendor_state` varchar(32) default NULL,

`vendor_country` varchar(32) default NULL,

`vendor_add_info` text,

`account_number` varchar(32) default NULL,

`handling_charge` decimal(5,2) NOT NULL default '0.00',

`handling_per_box` decimal(5,3) NOT NULL default '0.000',

`tare_weight` decimal(5,2) NOT NULL default '0.00',

`max_box_weight` decimal(15,3) unsigned NOT NULL default '0.000',

`percent_tare_weight` int(3) NOT NULL default '0',

`zones` int(3) NOT NULL default '1',

PRIMARY KEY (`vendors_id`)

) TYPE=MyISAM COMMENT='Vendors table add-in' AUTO_INCREMENT=3 ;

 

#

# Dumping data for table `vendors`

#

 

INSERT INTO `vendors` VALUES (1, 'Store Owner', 'My Store', '555-543-9988', '', '', '[email protected]', 'www.mvs.com', '', '2005-03-09 19:51:22', '2005-03-09 19:51:22', NULL, 1, 2, 'change', '889977 Astreet', 'Address line 2', 'Somewhere', 'MV', '223', '', '9999999', 0.00, 0.000, 0.00, 40.000, 0, 3);

 

#

# Table structure for table `vendors_info`

#

 

CREATE TABLE `vendors_info` (

`vendors_id` int(16) NOT NULL default '0',

`languages_id` int(11) NOT NULL default '0',

`vendors_url` varchar(255) NOT NULL default '',

`url_clicked` int(5) NOT NULL default '0',

`date_last_click` datetime default NULL,

PRIMARY KEY (`vendors_id`,`languages_id`)

) TYPE=MyISAM;

Link to comment
Share on other sites

Via your hosts's control panel, they should have phpMyAdmin available. Log into phpMyAdmin, select your database if needed from the dropdown on the left, click the SQL tab along the top, and either copy and paste the contents of the file into that box, or select the file to run from your harddrive.

 

Always backup your database before you make any changes to it.

Contributions

 

Discount Coupon Codes

Donations

Link to comment
Share on other sites

Via your hosts's control panel, they should have phpMyAdmin available. Log into phpMyAdmin, select your database if needed from the dropdown on the left, click the SQL tab along the top, and either copy and paste the contents of the file into that box, or select the file to run from your harddrive.

 

Always backup your database before you make any changes to it.

Hey thanks i just got it and it said it was succesful so im making head way. Now i have a new question, im in the process of adding all the php documents for this contrib. Its says

 

"###### admin/includes/classes/vendor_order_data.php(added directly to classes/order.php for PHP compatibility)######"

 

How would i add directly the vendor_order_data.php to the order.php? Im not skilled with php so im hesitant to modify this.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...