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);
}
