Page History

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;