using System;
using MySql.Data.MySqlClient;

namespace ResetStatsProgram
{
    class Program
    {
        public static string IpAddress { get; } = "localhost";
        public static string Port { get; } = "3306";
        public static string Database { get; } = "mafia";
        public static string Uid { get; } = "rank_reseter";
        public static string Pwd { get; } = "RankReseter1*";
        
        static void Main(string[] args)
        {
            string connectionString = null;
            MySqlConnection cnn ;
            connectionString = $"Server={IpAddress};Database={Database};port={Port};User Id={Uid};password={Pwd}";
            cnn = new MySqlConnection(connectionString);
            try
            {
                cnn.Open();
                var query = "UPDATE mafia.users SET rank_number = 0 WHERE 1 = 1";
                var cmd = new MySqlCommand(query, cnn);
                cmd.ExecuteNonQuery();
                cnn.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }
    }
}