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):
From your admin area go to Patch/Upgrade and in the Apply SQL patch, SQL query(ies):
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','');