$stalker_db = new mysqli('localhost', 'root', 'epsontm88', 'stalker_db');
$xtream_iptvpro = new mysqli('localhost', 'root', 'epsontm88', 'xtream_iptvpro');

$mags = $stalker_db->query("SELECT `fname`,`stb_type`,`mac` FROM `users`");

while ($mag = $mags->fetch_assoc()) {
  $xtream_iptvpro->query("CREATE TEMPORARY TABLE tmp SELECT * FROM reg_users WHERE id = 2");
  $xtream_iptvpro->query("ALTER TABLE tmp drop ID");
  $xtream_iptvpro->query("UPDATE tmp SET username='".$stalker_db->real_escape_string($mag['fname'])."',email=''");
  $xtream_iptvpro->query("INSERT INTO reg_users SELECT 0,tmp.* FROM tmp");
  $reg_users_id=$xtream_iptvpro->insert_id; echo $reg_users_id;
  $xtream_iptvpro->query("DROP TABLE tmp");

  $xtream_iptvpro->query("CREATE TEMPORARY TABLE tmp SELECT * FROM users WHERE id = 3");
  $xtream_iptvpro->query("ALTER TABLE tmp drop ID");
  $xtream_iptvpro->query("UPDATE tmp SET username='".$stalker_db->real_escape_string(str_replace('=','',base64_encode(crc32(microtime(true)))))."',password='".$stalker_db->real_escape_string(str_replace('=','',base64_encode(crc32(microtime(true)))))."',member_id=".$reg_users_id);
  $xtream_iptvpro->query("INSERT INTO users SELECT 0,tmp.* FROM tmp");
  $reg_users_id=$xtream_iptvpro->insert_id; echo $reg_users_id;
  $xtream_iptvpro->query("DROP TABLE tmp");

  $xtream_iptvpro->query("CREATE TEMPORARY TABLE tmp SELECT * FROM mag_devices WHERE mag_id = 2");
  $xtream_iptvpro->query("ALTER TABLE tmp drop mag_id");
  $xtream_iptvpro->query("UPDATE tmp SET user_id=".$reg_users_id.",mac='".$stalker_db->real_escape_string(base64_encode($mag['mac']))."'");
  $xtream_iptvpro->query("INSERT INTO mag_devices SELECT 0,tmp.* FROM tmp");
  $reg_users_id=$xtream_iptvpro->insert_id; echo $reg_users_id;
  $xtream_iptvpro->query("DROP TABLE tmp");