public void Remove(string Name)
{
if(Name.IsNullOrEmpty())
return;
var db = SchumixBase.DManager.QueryFirstRow("SELECT 1 FROM ignore_channels WHERE Channel = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), _servername);
if(db.IsNull())
return;
_ignorelist.Remove(Name.ToLower());
SchumixBase.DManager.Delete("ignore_channels", string.Format("Channel = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), _servername));
if(SchumixBase.ExitStatus)
return;
db = SchumixBase.DManager.QueryFirstRow("SELECT Enabled, Password FROM channels WHERE Channel = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), _servername);
if(!db.IsNull())
{
if(db["Enabled"].ToString().IsNullOrEmpty() || !db["Enabled"].ToBoolean())
{
SchumixBase.DManager.Update("channels", "Enabled = 'true', Error = ''", string.Format("Channel = '{0}' And ServerName = '{1}'", sUtilities.SqlEscape(Name.ToLower()), _servername));
if(sIrcBase.Networks[_servername].Online)
{
string password = db["Password"].ToString();
if(password.IsNullOrEmpty())
sIrcBase.Networks[_servername].sSender.Join(Name.ToLower());
else
sIrcBase.Networks[_servername].sSender.Join(Name.ToLower(), db["Password"].ToString().Trim());
}
}
}
}