SET SQL_MODE = 'NO_ENGINE_SUBSTITUTION,NO_AUTO_VALUE_ON_ZERO';
INSERT INTO internet_main (
uid,
tp_id,
logins,
registration,
ip,
filter_id,
speed,
netmask,
cid,
password,
disable,
join_service,
turbo_mode,
free_turbo_mode,
activate,
expire,
login,
personal_tp,
detail_stats,
nas_id,
port,
vlan,
server_vlan,
cpe_mac,
ipn_activate
)
SELECT dv.uid,
if(tp.tp_id IS NULL, 0, tp.tp_id),
dv.logins,
dv.registration,
if(dh.ip IS NULL, dv.ip, dh.ip),
dv.filter_id,
dv.speed,
dv.netmask,
if (dh.mac <> '00:00:00:00:00:00', dh.mac, dv.cid),
dv.password,
dv.disable,
dv.join_service,
dv.turbo_mode,
dv.free_turbo_mode,
'0000-00-00',
dv.expire,
dv.dv_login,
dv.personal_tp,
dv.traf_detail,
if (dh.nas IS NULL, 0, dh.nas),
if (dh.ports<>'', dh.ports, dv.port),
if (dh.vid IS NULL, 0, dh.vid),
if (dh.server_vid IS NULL, 0, dh.server_vid),
'',
if (dh.server_vid IS NULL, 0, dh.ipn_activate)
FROM dv_main dv
LEFT JOIN tarif_plans tp ON (dv.tp_id=tp.id AND (tp.module='Dv' OR tp.module='Internet'))
LEFT JOIN dhcphosts_hosts dh ON (dv.uid=dh.uid);
UPDATE internet_main im, users u SET im.activate=u.activate WHERE im.uid=u.uid; |