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;

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

            //mysql kezdődik itt
            Console.WriteLine("--------------------------------------");

             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";

            connection.Open();
            string MsConString = "Data source=.\\SQLEXPRESS;Database=silkroad;User=sa;Password=1234;";
            SqlConnection connection2 = new SqlConnection(MsConString);
            SqlCommand command2 = connection2.CreateCommand();
            SqlDataReader Reader2;
            Reader = command.ExecuteReader();

            while (Reader.Read())
            {

                string id2 = Reader["id"].ToString();
                string pw2 = Reader["password"].ToString();
                string mail2 = Reader["mail"].ToString();




                connection2.Open();
                command2.CommandText = "INSERT INTO users (id,password,ban,online,serverid,silk,gold,mail) VALUES ('" + id2 + "','" + pw2 + "','0','0','1905','200','999999','" + mail2 + "') " ;

                Reader2 = command2.ExecuteReader();
                connection2.Close();


            }
            connection.Close();

        }
    }
}