View Single Post
  #1  
Old 07-03-2010, 09:27 AM
  DogByteMan's Avatar 
DogByteMan DogByteMan is offline
 

X-Adept
  
Join Date: Mar 2003
Posts: 833
 

Default Installation of X-Payments Connector on X-Cart 4.1.12

This is provided to you without any guarantee that it will work for you. As always backup ALL files and data base before beginning.

This is not for the faint at heart. If you have any doubts what-so-ever about how to do it, pay for QTS to do it for you.

***********************************************

From your admin area go to Patch/Upgrade and in the Apply SQL patch, SQL query(ies):
Copy and paste the following then apply it.

Code:
DELETE FROM xcart_modules WHERE module_name='XPayments_Connector'; DELETE FROM xcart_config WHERE name LIKE 'xpc_%'; DELETE FROM xcart_languages WHERE name = 'module_descr_XPayments_Connector'; DELETE FROM xcart_languages WHERE name = 'module_name_XPayments_Connector'; DELETE FROM xcart_languages WHERE name = 'option_title_XPayments_Connector'; DELETE FROM xcart_languages WHERE name LIKE 'opt_xpc_%'; DELETE FROM xcart_languages WHERE name LIKE 'opt_descr_xpc_%'; DELETE FROM xcart_languages WHERE name LIKE 'lbl_xpc_%'; DELETE FROM xcart_languages WHERE name LIKE 'txt_xpc_%'; DELETE FROM xcart_languages WHERE name = 'lbl_aom_order_status_note_13';

From your admin area go to Patch/Upgrade and in the Apply SQL patch, SQL query(ies):
Copy and paste the following then apply it.

Code:
INSERT INTO xcart_modules (module_name, module_descr, active) VALUES ('XPayments_Connector','This module enables an ability to process payments via X-Payments software','Y'); INSERT INTO xcart_config VALUES ('xpc_sep1','X-Payments connection options','','XPayments_Connector',0,'separator','','',''); INSERT INTO xcart_config VALUES ('xpc_sep2','Payments <-> Order statuses compatibility list','','XPayments_Connector',75,'separator','','',''); INSERT INTO xcart_config VALUES ('xpc_shopping_cart_id','Shopping cart ID','','XPayments_Connector',10,'text','','','^[0-9a-f]{32}?$'); INSERT INTO xcart_config VALUES ('xpc_xpayments_url','X-Payments URL','','XPayments_Connector',20,'text','','',''); INSERT INTO xcart_config VALUES ('xpc_public_key','Encryption key','','XPayments_Connector',40,'textarea','','',''); INSERT INTO xcart_config VALUES ('xpc_private_key','Decryption key','','XPayments_Connector',50,'textarea','','',''); INSERT INTO xcart_config VALUES ('xpc_private_key_password','Decryption key password','','XPayments_Connector',60,'text','','',''); INSERT INTO xcart_config VALUES ('xpc_allowed_ip_addresses','IP addresses of X-Payments callbacks','','XPayments_Connector',70,'text','','',''); INSERT INTO xcart_config VALUES ('xpc_currency','Currency','USD','XPayments_Connector',72,'selector','','',''); INSERT INTO xcart_config VALUES ('xpc_status_new','Set order status if payment is in status \'New\' to','I','XPayments_Connector',80,'selector','',':lbl_xpc_do_not_change\nI:lbl_not_finished\nQ:lbl_queued\nP:lbl_processed\nB:lbl_backordered\nD:lbl_declined\nF:lbl_failed\nC:lbl_complete',''); INSERT INTO xcart_config VALUES ('xpc_status_auth','Set order status if payment is in status \'Authorized\' to','A','XPayments_Connector',90,'selector','',':lbl_xpc_do_not_change\nI:lbl_not_finished\nQ:lbl_queued\nP:lbl_processed\nB:lbl_backordered\nD:lbl_declined\nF:lbl_failed\nC:lbl_complete',''); INSERT INTO xcart_config VALUES ('xpc_status_charged','Set order status if payment is in status \'Charged\' to','P','XPayments_Connector',100,'selector','',':lbl_xpc_do_not_change\nI:lbl_not_finished\nQ:lbl_queued\nP:lbl_processed\nB:lbl_backordered\nD:lbl_declined\nF:lbl_failed\nC:lbl_complete',''); INSERT INTO xcart_config VALUES ('xpc_status_declined','Set order status if payment is in status \'Declined\' to','F','XPayments_Connector',110,'selector','',':lbl_xpc_do_not_change\nI:lbl_not_finished\nQ:lbl_queued\nP:lbl_processed\nB:lbl_backordered\nD:lbl_declined\nF:lbl_failed\nC:lbl_complete',''); INSERT INTO xcart_config VALUES ('xpc_status_refunded','Set order status if payment is in status \'Refunded\' to','','XPayments_Connector',120,'selector','',':lbl_xpc_do_not_change\nI:lbl_not_finished\nQ:lbl_queued\nP:lbl_processed\nB:lbl_backordered\nD:lbl_declined\nF:lbl_failed\nC:lbl_complete',''); INSERT INTO xcart_config VALUES ('xpc_status_part_refunded','Set order status if payment is in status \'Partially Refunded\' to','','XPayments_Connector',120,'selector','',':lbl_xpc_do_not_change\nI:lbl_not_finished\nQ:lbl_queued\nP:lbl_processed\nB:lbl_backordered\nD:lbl_declined\nF:lbl_failed\nC:lbl_complete','');
__________________
Dedicated Server provided by EWD Hosting
X-Cart version 4.1.12
PHP 5.3.2
MySQL server 5.0.87-community
Operation system Linux
Perl 5.008008
dogbytecomputer.com
Reply With Quote