public override PanelStats GetPanelStats() { var stats = new PanelStats(); using (SqlConnection _conn = new SqlConnection(connectionString)) { _conn.Open(); using (SqlCommand _cmd = new SqlCommand(@"SELECT COUNT(*) FROM UserDatabase;", _conn)) { stats.TotalDatabaseCount = GetScalarValue(_cmd.ExecuteScalar()); stats.TotalDatabaseDiskSpace = 0; } using (SqlCommand _cmd = new SqlCommand(@"SELECT COUNT(*) FROM HostDomain WHERE DomainAliasId <> 0", _conn)) { stats.TotalDomainAliasCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SqlCommand _cmd = new SqlCommand(@"SELECT COUNT(*) FROM HostDomain WHERE DomainAliasId = 0 AND SubDomainId = 0", _conn)) { stats.TotalDomainCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SqlCommand _cmd = new SqlCommand(@"SELECT SUM(CurrentDiskspaceUsage) FROM HostDomain", _conn)) { stats.TotalDomainDiskSpace = GetScalarValue(_cmd.ExecuteScalar()); } using (SqlCommand _cmd = new SqlCommand(@"SELECT COUNT(*) FROM POP3Account", _conn)) { stats.TotalEmailCount = GetScalarValue(_cmd.ExecuteScalar()); stats.TotalEmailDiskSpace = 0; } using (SqlCommand _cmd = new SqlCommand(@"SELECT COUNT(*) FROM Account WHERE AccountType <> 0", _conn)) { stats.TotalResellerCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SqlCommand _cmd = new SqlCommand(@"SELECT COUNT(*) FROM HostDomain WHERE SubDomainId <> 0", _conn)) { stats.TotalSubdomainCount = GetScalarValue(_cmd.ExecuteScalar()); stats.TotalSubdomainDiskSpace = 0; } _conn.Close(); } return(stats); }
public override PanelStats GetPanelStats() { var _tmp = new PanelStats(); _tmp.TotalDatabaseCount = GetCountFromDatabase("SELECT COUNT(*) AS Cnt FROM MySQL_Details"); _tmp.TotalDatabaseDiskSpace = 0; _tmp.TotalDomainAliasCount = GetCountFromDatabase("SELECT COUNT(*) AS Cnt FROM Alias_Details"); _tmp.TotalDomainCount = GetCountFromDatabase("SELECT COUNT(*) AS Cnt FROM Host_Accounts"); _tmp.TotalDomainDiskSpace = GetCountFromDatabase("SELECT ROUND(SUM(WebSpace_Usage)) AS Cnt FROM Host_Accounts"); _tmp.TotalEmailCount = 0; _tmp.TotalEmailDiskSpace = 0; _tmp.TotalResellerCount = GetCountFromDatabase("SELECT COUNT(*) AS Cnt FROM Reseller_Accounts"); _tmp.TotalSubdomainCount = GetCountFromDatabase("SELECT COUNT(*) AS Cnt FROM SubDomain_List"); _tmp.TotalSubdomainDiskSpace = 0; return(_tmp); }
private void connectionButton_Click(object sender, EventArgs e) { var selectedProvider = comboSourceDatabase.SelectedItem != null?comboSourceDatabase.SelectedItem.ToString() : String.Empty; if (String.IsNullOrEmpty(selectedProvider)) { MessageBox.Show("Please select database provider", "", MessageBoxButtons.OK, MessageBoxIcon.Error); comboSourceDatabase.Focus(); return; } if (_migrate.PanelType == PanelTypes.Unknown) { MessageBox.Show("Please select panel", "", MessageBoxButtons.OK, MessageBoxIcon.Error); comboSourcePanel.Focus(); return; } using (var dbform = new DatabaseForm(selectedProvider)) { if (dbform.ShowDialog() == System.Windows.Forms.DialogResult.OK) { DatabaseConnectionTest = true; _migrate.SourceDatabase.Username = dbform.Username; _migrate.SourceDatabase.Password = dbform.Password; _migrate.SourceDatabase.Port = dbform.Port; _migrate.SourceDatabase.Provider = dbform.Provider; _migrate.SourceDatabase.Host = dbform.Host; _migrate.SourceDatabase.DataseFile = dbform.DatabaseFile; _migrate.SourceDatabase.Database = dbform.DatabaseName; _migrate.LoadInstalledPanel(_migrate.PanelType, _migrate.SourceDatabase); panelStats = _migrate.PanelData.GetPanelStats(); SetPanelStats(); } dbform.Dispose(); } }
private void buttonAutoDiscover_Click(object sender, System.EventArgs e) { _migrate.DetermineInstalledPanel(); if (_migrate.PanelType == PanelTypes.Unknown) { MessageBox.Show("Panel cannot be determine", "MaestroPanel", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (_migrate.CurrentPanel == null) { MessageBox.Show(String.Format("Panel is {0} but discovery time error. (Provider not found)", _migrate.PanelType), "MaestroPanel", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //MessageBox.Show(_migrate.SourceDatabase.Username); //MessageBox.Show(_migrate.SourceDatabase.ConnectionString()); labelPanelVersion.Text = _migrate.CurrentPanel.Version(); SelectSourcePanel(_migrate.PanelType); SelectSourceDatabase(_migrate.CurrentPanel.GetDatabaseProvider()); textboxDefaultVhost.Text = _migrate.CurrentPanel.VhostPath(); textboxSourceEmailPath.Text = _migrate.CurrentPanel.GetEmailPath(); panelStats = _migrate.PanelData.GetPanelStats(); SetPanelStats(); DatabaseConnectionTest = true; }
public override PanelStats GetPanelStats() { var pstats = new PanelStats(); using (OleDbConnection _conn = new OleDbConnection(connectionString)) { _conn.Open(); #region Disk Space using (OleDbCommand _cmd = new OleDbCommand(@"SELECT SUM(httpdocs) AS httpdocs, SUM(mysql_dbases) + SUM(mssql_dbases) AS totaldbsize, SUM(mailboxes) AS totalmailboxsize, SUM(subdomains) AS subdomainsize FROM disk_usage", _conn)) { using (OleDbDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { if (_read["httpdocs"] is System.Int64) { pstats.TotalDomainDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <System.Int64>(_read, "httpdocs")); } else { pstats.TotalDomainDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "httpdocs"); } if (_read["totaldbsize"] is System.Int64) { pstats.TotalDatabaseDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <Int64>(_read, "totaldbsize")); } else { pstats.TotalDatabaseDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "totaldbsize"); } if (_read["totalmailboxsize"] is System.Int64) { pstats.TotalEmailDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <Int64>(_read, "totalmailboxsize")); } else { pstats.TotalEmailDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "totalmailboxsize"); } if (_read["subdomainsize"] is System.Int64) { pstats.TotalSubdomainDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <Int64>(_read, "subdomainsize")); } else { pstats.TotalSubdomainDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "subdomainsize"); } } } } #endregion #region Count pstats.TotalDomainCount = StatsItem <int>("SELECT COUNT(*) FROM domains"); pstats.TotalEmailCount = StatsItem <int>("SELECT COUNT(*) FROM mail"); pstats.TotalResellerCount = StatsItem <int>("SELECT COUNT(*) FROM clients"); pstats.TotalDatabaseCount = StatsItem <int>("SELECT COUNT(*) FROM data_bases"); pstats.TotalDomainAliasCount = StatsItem <int>("SELECT COUNT(*) FROM domain_aliases"); pstats.TotalSubdomainCount = StatsItem <int>("SELECT COUNT(*) FROM subdomains"); #endregion _conn.Close(); } return(pstats); }
public override PanelStats GetPanelStats() { var pstats = new PanelStats(); using (MySqlConnection _conn = new MySqlConnection(connectionString)) { _conn.Open(); #region Disk Space using (MySqlCommand _cmd = new MySqlCommand(@"SELECT CAST(SUM(httpdocs) AS SIGNED) as httpdocs, CAST((SUM(dbases)) AS SIGNED) as totaldbsize, CAST(SUM(mailboxes) AS SIGNED) as totalmailboxsize, CAST(SUM(subdomains) AS SIGNED) as subdomainsize FROM disk_usage", _conn)) { using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { //form MySQL 4 if (_read["httpdocs"] is System.Int64) { pstats.TotalDomainDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <System.Int64>(_read, "httpdocs")); } else { pstats.TotalDomainDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "httpdocs"); } if (_read["totaldbsize"] is System.Int64) { pstats.TotalDatabaseDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <Int64>(_read, "totaldbsize")); } else { pstats.TotalDatabaseDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "totaldbsize"); } if (_read["totalmailboxsize"] is System.Int64) { pstats.TotalEmailDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <Int64>(_read, "totalmailboxsize")); } else { pstats.TotalEmailDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "totalmailboxsize"); } if (_read["subdomainsize"] is System.Int64) { pstats.TotalSubdomainDiskSpace = Convert.ToDecimal(DataExtensions.GetColumnValue <Int64>(_read, "subdomainsize")); } else { pstats.TotalSubdomainDiskSpace = DataExtensions.GetColumnValue <decimal>(_read, "subdomainsize"); } } } } #endregion #region Count using (MySqlCommand _cmd = new MySqlCommand(@"SELECT (SELECT COUNT(*) FROM domains) as domaincount, (SELECT COUNT(*) FROM mail) as mailcount, (SELECT COUNT(*) FROM clients) as resellercount, (SELECT COUNT(*) FROM data_bases) as databasecount, (SELECT COUNT(*) FROM domainaliases) as aliascount, (SELECT COUNT(*) FROM subdomains) as subdomaincount", _conn)) { using (MySqlDataReader _read = _cmd.ExecuteReader()) { while (_read.Read()) { pstats.TotalDomainCount = DataExtensions.GetColumnValue <long>(_read, "domaincount"); pstats.TotalEmailCount = DataExtensions.GetColumnValue <long>(_read, "mailcount"); pstats.TotalResellerCount = DataExtensions.GetColumnValue <long>(_read, "resellercount"); pstats.TotalDatabaseCount = DataExtensions.GetColumnValue <long>(_read, "databasecount"); pstats.TotalDomainAliasCount = DataExtensions.GetColumnValue <long>(_read, "aliascount"); pstats.TotalSubdomainCount = DataExtensions.GetColumnValue <long>(_read, "subdomaincount"); } } } #endregion _conn.Close(); } return(pstats); }
public override PanelStats GetPanelStats() { var pstats = new PanelStats(); using (SQLiteConnection _conn = new SQLiteConnection(connectionString)) { _conn.Open(); #region total database count using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SUM(DbSize) FROM DomainMsSQL", _conn)) { pstats.TotalDatabaseDiskSpace = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SUM(DbSize) FROM DomainMsSQL2012", _conn)) { pstats.TotalDatabaseDiskSpace += GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SUM(DbSize) FROM DomainMySQL", _conn)) { pstats.TotalDatabaseDiskSpace += GetScalarValue(_cmd.ExecuteScalar()); } #endregion #region total database size using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) FROM DomainMsSQL", _conn)) { pstats.TotalDatabaseCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) FROM DomainMySQL", _conn)) { pstats.TotalDatabaseCount += GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) FROM DomainMsSQL2012", _conn)) { pstats.TotalDatabaseCount += GetScalarValue(_cmd.ExecuteScalar()); } #endregion using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) From DomainAlias", _conn)) { pstats.TotalDomainAliasCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) From Domain", _conn)) { pstats.TotalDomainCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SUM(Usage) as WebSize FROM DomainLimit WHERE LimitName = 'MSFTP_FTPQUOTA'", _conn)) { pstats.TotalDomainDiskSpace = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SUM(Usage) as MailBoxCount FROM DomainLimit WHERE LimitName IN ('MAILBOXCOUNT','ICEWARP_MAILBOX_ACCOUNT_LIMIT','SmarterMailUsers')", _conn)) { pstats.TotalEmailCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT SUM(Usage) as MailSize FROM DomainLimit WHERE LimitName IN ('MAILBOXSIZEQUOTA','ICEWARP_TOTAL_DISKQUOTA','SmarterMailDiskSpace')", _conn)) { pstats.TotalEmailDiskSpace = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) From LoginAccount WHERE UserType = 1", _conn)) { pstats.TotalResellerCount = GetScalarValue(_cmd.ExecuteScalar()); } using (SQLiteCommand _cmd = new SQLiteCommand(@"SELECT COUNT(*) From SubDomain", _conn)) { pstats.TotalSubdomainCount = GetScalarValue(_cmd.ExecuteScalar()); pstats.TotalSubdomainDiskSpace = 0; } _conn.Close(); } return(pstats); }
void Awake() { instance = this; DontDestroyOnLoad(gameObject); }