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

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

Query

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.

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

mysql;

use {$database_name};

Then execute the SQL query that is above.

After the SQL query is executed, it is necessary to update the components in each domain product using the Webnic Registrar module. Please manually delete the components from the admin area, refresh the page, and then add the required components.

Related module

• Webnic