Migration from Webnic to Webnic2 Module

Overview

If you were using Webnic module to sell and manage domains in HostBill procedure below describes how to migrate your existing domains/tlds to Webnic2 module

Migration

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

Query

Migration from Hexonet to RRPProxy

SET @webnicV2 = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.webnic2.php');
SET @webnicV1 = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.webnic.php');
SET @module_resolved = IF(@webnicV2 IS NOT NULL, @webnicV2, @webnicV1);
SET @server_group = (SELECT id FROM hb_server_groups WHERE module = @module_resolved);
SET @serv = (SELECT `id` FROM hb_servers WHERE group_id = @server_group AND `default` = 1);

UPDATE hb_products_modules p, hb_domains d, hb_domain_prices dp
SET p.`module` = @module_resolved,
p.`server` = @serv,
dp.`module` = @module_resolved,
d.`reg_module` = @module_resolved,
d.server_id = @serv
WHERE p.`module` = @webnicV1 OR dp.`module` = @webnicV1 OR (d.`reg_module` = @webnicV1 AND d.tld_id = p.product_id);

If you do not have any program to connect to the database, you can execute this query using the command line.

Log in to the server where you have the HostBill installation.
Then use the commands:

mysql;

use {$database_name};

Where {$database_name} is the name of the database you want to connect to. You can find the name of your database in the file public_html/includes/config.php

Then execute the SQL query that is above.

Related module

Webnic