Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

  1. Make sure that the RRPProxy Webnic2 module is enabled.
  2. Create App Connection for RRPProxy Webnic2.
  3. Connect to the database.
  4. You should run the query which is below.

...

Code Block
languagesql
titleMigration from Hexonet to RRPProxy
linenumberstrue
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

...