public MYSQLUserDB(string host, int port, string database, string user, string pass)
{
this.host = host;
this.port = port;
this.user = user;
this.pass = pass;
this.database = database;
this.isconnected = false;
try
{
db = new MySqlConnection(string.Format("Server={1};Port={2};Uid={3};Pwd={4};Database={0};", database, host, port, user, pass));
dbinactive = new MySqlConnection(string.Format("Server={1};Port={2};Uid={3};Pwd={4};Database={0};", database, host, port, user, pass));
db.Open();
}
catch (MySqlException ex)
{
Logger.ShowSQL(ex, null);
}
catch (Exception ex)
{
Logger.ShowError(ex,null);
}
if (db != null) { if (db.State != ConnectionState.Closed)this.isconnected = true; else { Console.WriteLine("SQL Connection error"); } }
}