Overview
...
If you were using Hexonet Webnic module to sell and manage domains in HostBill procedure below describes how to migrate your existing domains/tlds to CentralNic Reseller (rrpproxy) Webnic2 module
Migration
...
- Make sure that the RRPProxy Webnic2 module is enabled.
- Create App Connection for RRPProxy Webnic2.
- Connect to the database.
- You should run the query which is below.
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SET @rrpproxy@webnicV2 = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.rrpproxywebnic2.php'),; SET @hexonet@webnicV1 = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.hexonetwebnic.php'),; @server_group = (SELECT `id` FROM hb_server_groups WHERE moduleSET @module_resolved = IF(@rrpproxy@webnicV2 IS NOT NULL, @rrpproxy@webnicV2, @hexonet)), @serv@webnicV1); SET @server_group = (SELECT `id`id FROM hb_server_serversgroups WHERE group_idmodule = @server_group AND `default` = 1@module_resolved); DELETE w.* FROM hb_widgets w LEFT JOIN hb_widgets_config wc ON (w.widget_id = wc.id) WHERE wc.`widget` IN ('emailforwarding', 'registernameservers') AND w.`target_type` = 'Product' AND w.`target_id` INSET @serv = (SELECT `product_id``id` FROM hb_products_modulesservers WHERE `module` = @hexonet); UPDATE hb_config_items_cat cc SET cc.variable = UPPER(cc.variable) WHERE cc.product_id IN (SELECT `product_id` FROM hb_products_modules WHERE `module` = @hexonet);group_id = @server_group AND `default` = 1); UPDATE hb_products_modules p, hb_domains d, hb_domain_prices dp SET p.`module` = IF(@rrpproxy IS NOT NULL, @rrpproxy, @hexonet)@module_resolved, p.`server` = @serv, dp.`module` = IF(@rrpproxy IS NOT NULL, @rrpproxy, @hexonet), @module_resolved, d.`reg_module` = IF(@rrpproxy IS NOT NULL, @rrpproxy, @hexonet), @module_resolved, d.server_id = @serv WHERE p.`module` = @hexonet@webnicV1 OR dp.`module` = @hexonet@webnicV1 OR (d.`reg_module` = @hexonet@webnicV1 AND d.tld_id = p.product_id); |
...
Then execute the SQL query that is above.
Related
...
module
...