protected override void __evt_KICK(NetworkKickEventArgs args)
{
if (args.ChannelName == Configuration.System.DebugChan && this.instance != Instance.PrimaryInstance)
{
return;
}
Channel channel = Core.GetChannel(args.ChannelName);
if (channel == null)
{
return;
}
SystemHooks.IrcKick(channel, args.SourceInfo, args.Target);
if (this.Nickname.ToLower() == args.Target.ToLower())
{
Syslog.Log("I was kicked from " + args.ChannelName + " by " + args.SourceInfo.Nick + " with kick message: " + args.Message);
lock (Configuration.Channels)
{
if (Configuration.Channels.Contains(channel))
{
Configuration.Channels.Remove(channel);
}
}
Configuration.Save();
}
}
private static void Reload(CommandParams parameters)
{
parameters.SourceChannel.LoadConfig();
SystemHooks.IrcReloadChannelConf(parameters.SourceChannel);
IRC.DeliverMessage(messages.Localize("Config", parameters.SourceChannel.Language), parameters.SourceChannel);
return;
}
public override int Delete(string table, string query)
{
int result = 0;
string sql = "DELETE FROM " + table;
if (!String.IsNullOrEmpty(query))
{
sql += " " + query;
}
SystemHooks.OnSQL(LocalName, sql);
lock (DatabaseLock)
{
try
{
Npgsql.NpgsqlCommand SqlCommand = new Npgsql.NpgsqlCommand(sql, this.connection);
result = SqlCommand.ExecuteNonQuery();
}
catch (Npgsql.NpgsqlException me)
{
ErrorBuffer = me.Message;
HandleError(sql);
}
}
return(result);
}
public override List <List <string> > Select(string sql, List <Database.Bind> bind_var = null)
{
if (!this.IsConnected)
{
throw new WmibException("The database is not connected");
}
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand(sql, this.connection);
if (bind_var != null)
{
BindVars(sql, bind_var, command);
}
SystemHooks.OnSQL(LocalName, sql);
Npgsql.NpgsqlDataReader dr = command.ExecuteReader();
List <List <string> > results = new List <List <string> >();
while (dr.Read())
{
List <string> line = new List <string>();
results.Add(line);
for (int i = 0; i < dr.FieldCount; i++)
{
line.Add(dr[i].ToString());
}
}
return(results);
}
/// <summary>
/// Log the specified Message and MessageType.
/// </summary>
/// <param name='Message'>
/// If set to <c>true</c> message.
/// </param>
/// <param name='MessageType'>
/// If set to <c>true</c> message type.
/// </param>
public static bool Log(string Message, Type MessageType)
{
if (IsQuiet)
{
return(false);
}
Logging.Write(Message, MessageType);
SystemHooks.SystemLog(Message, MessageType);
return(true);
}
/// <summary>
/// Writes the message immediately to console with no thread sync
/// </summary>
/// <returns>
/// The now.
/// </returns>
/// <param name='Message'>
/// If set to <c>true</c> message.
/// </param>
/// <param name='MessageType'>
/// If set to <c>true</c> message type.
/// </param>
public static bool WriteNow(string Message, Type MessageType)
{
if (IsQuiet)
{
return(false);
}
Logging.Display(DateTime.Now, Message, MessageType);
SystemHooks.SystemLog(Message, MessageType);
return(true);
}
/// <summary>
/// Log the specified message
/// </summary>
/// <param name='Message'>
/// Message that you want to log.
/// </param>
/// <param name='Warning'>
/// If this is true the message will be classified as a warning.
/// </param>
public static bool Log(string Message, bool Warning = false)
{
if (IsQuiet)
{
return(false);
}
Type MessageType = Type.Normal;
if (Warning)
{
MessageType = Type.Warning;
}
Logging.Write(Message, MessageType);
SystemHooks.SystemLog(Message, MessageType);
return(true);
}
/// <summary>
/// Writes the message immediately to console with no thread sync
/// </summary>
/// <returns>
/// The now.
/// </returns>
/// <param name='Message'>
/// Message that you want to log.
/// </param>
/// <param name='Warning'>
/// If this is true the message will be classified as a warning.
/// </param>
public static bool WriteNow(string Message, bool Warning = false)
{
if (IsQuiet)
{
return(false);
}
Type _Type = Type.Normal;
if (Warning)
{
_Type = Type.Warning;
}
Logging.Display(DateTime.Now, Message, _Type);
SystemHooks.SystemLog(Message, _Type);
return(true);
}
public override void ExecuteNonQuery(string sql, List <Bind> bind_var = null)
{
if (!this.IsConnected)
{
throw new WmibException("The database is not connected");
}
try
{
Npgsql.NpgsqlCommand c = new Npgsql.NpgsqlCommand(sql, this.connection);
if (bind_var != null)
{
BindVars(sql, bind_var, c);
}
SystemHooks.OnSQL(LocalName, sql);
c.ExecuteNonQuery();
}
catch (Npgsql.NpgsqlException me)
{
ErrorBuffer = me.Message;
HandleError(sql, bind_var);
}
}
public override void Commit()
{
SystemHooks.OnSQL(LocalName, "commit;");
Npgsql.NpgsqlCommand c = new Npgsql.NpgsqlCommand("commit;", this.connection);
c.ExecuteNonQuery();
}
public override bool InsertRow(string table, Row row)
{
StringBuilder sql = new StringBuilder();
lock (DatabaseLock)
{
try
{
if (!IsConnected)
{
Syslog.DebugLog("Postponing request to insert a row into database which is not connected");
//lock(unwritten.PendingRows)
//{
// unwritten.PendingRows.Add(new SerializedRow(table, row));
//}
//FlushRows();
return(false);
}
Npgsql.NpgsqlCommand s = new Npgsql.NpgsqlCommand();
s.Connection = this.connection;
sql.Append("INSERT INTO ");
sql.Append(table);
// let's check if there are headers
bool headers = true;
string header = "";
foreach (Row.Value value in row.Values)
{
if (value.Column == null)
{
headers = false;
break;
}
header += value.Column + ", ";
}
if (header.EndsWith(", "))
{
header = header.Substring(0, header.Length - 2);
}
if (headers)
{
sql.Append(" (" + header + ")");
}
sql.Append(" VALUES (");
int cv = 0;
foreach (Row.Value value in row.Values)
{
sql.Append(":v" + cv.ToString() + ", ");
switch (value.Type)
{
case DataType.Boolean:
s.Parameters.Add(new Npgsql.NpgsqlParameter("v" + cv.ToString(), NpgsqlTypes.NpgsqlDbType.Boolean));
s.Parameters[cv].Value = bool.Parse(value.Data);
break;
case DataType.Integer:
s.Parameters.Add(new Npgsql.NpgsqlParameter("v" + cv.ToString(), NpgsqlTypes.NpgsqlDbType.Integer));
s.Parameters[cv].Value = int.Parse(value.Data);
break;
case DataType.Varchar:
s.Parameters.Add(new Npgsql.NpgsqlParameter("v" + cv.ToString(), NpgsqlTypes.NpgsqlDbType.Varchar));
s.Parameters[cv].Value = value.Data;
break;
case DataType.Text:
s.Parameters.Add(new Npgsql.NpgsqlParameter("v" + cv.ToString(), NpgsqlTypes.NpgsqlDbType.Text));
s.Parameters[cv].Value = value.Data;
break;
case DataType.Date:
s.Parameters.Add(new Npgsql.NpgsqlParameter("v" + cv.ToString(), NpgsqlTypes.NpgsqlDbType.Timestamp));
s.Parameters[cv].Value = DateTime.Parse(value.Data);
break;
}
cv++;
}
if (sql.ToString().EndsWith(", "))
{
sql.Remove(sql.Length - 2, 2);
}
sql.Append(");");
s.CommandText = sql.ToString();
SystemHooks.OnSQL(LocalName, sql.ToString());
s.ExecuteNonQuery();
return(true);
}
catch (Npgsql.NpgsqlException me)
{
ErrorBuffer = me.Message;
Syslog.Log("Error while storing a row to DB " + me, true);
Syslog.DebugLog("SQL: " + sql.ToString());
HandleError(sql.ToString());
/*lock(unwritten.PendingRows)
* {
* unwritten.PendingRows.Add(new SerializedRow(table, row));
* }
* FlushRows();
*
*
*/
return(false);
}
}
}