using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data.SqlClient;
using System.Data;
using System.Collections;
using System.Threading;

namespace accounts
{
    class Program
    {
        static void Main(string[] args)
        {



            while (true)
            {

                string MyConString = "SERVER=localhost;" +
                   "DATABASE=emulator;" +
                   "UID=root;" +
                   "PASSWORD=;";
                MySqlConnection connection = new MySqlConnection(MyConString);
                MySqlCommand command = connection.CreateCommand();
                MySqlDataReader Reader;
                command.CommandText = "SELECT id,password,mail FROM users";
                Console.WriteLine("Accountok keresése..");
                string MsConString = "Data source=.\\SQLEXPRESS;Database=silkroad;User=sa;Password=1234;";
                SqlConnection connection2 = new SqlConnection(MsConString);
                SqlCommand command2 = connection2.CreateCommand();
                connection.Open();
                Reader = command.ExecuteReader();
                while (Reader.Read())
                {

                    connection2.Open();
                    string id = Reader["id"].ToString();
                    string pw = Reader["password"].ToString();
                    command2.CommandText = ("INSERT INTO users (id,password) VALUES ('" + id + "','" + pw + "')");
                    command2.ExecuteReader();
                    connection2.Close();
                    Console.WriteLine("Új account az adatbázisban!");
                    Console.WriteLine("Újra ellenőrzés hamarosan...");
                }
                connection.Close();
                Thread.Sleep(10000);
            }
            }

    }
}