Page Comparison

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_serversserver_groups 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` IN (SELECT `product_id`SET @serv = (SELECT `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);