public override void Load(IDataConnector conn)
{
using (var sb = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
sb.SelectAll(TableDefinition.TableName);
_data = conn.ExecuteArray <UserGroup>(sb);
}
ProgramLog.Error.Log(this.GetType().Name + ": " + (_data == null ? "NULL" : _data.Length.ToString()));
}
public static bool DeleteLink(SQLiteConnector conn, long userId, long groupId)
{
using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
bl.Delete(TableDefinition.TableName,
new WhereFilter(TableDefinition.ColumnNames.UserId, userId.ToString()),
new WhereFilter(TableDefinition.ColumnNames.GroupId, groupId.ToString()));
return(((IDataConnector)conn).ExecuteNonQuery(bl) > 0);
}
}
public static long InsertRecord(SQLiteConnector conn, string node, bool deny)
{
using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
bl.InsertInto(TableDefinition.TableName,
new DataParameter(TableDefinition.ColumnNames.Node, node),
new DataParameter(TableDefinition.ColumnNames.Deny, deny)
);
return(((IDataConnector)conn).ExecuteInsert(bl));
}
}
public static long InsertRecord(SQLiteConnector conn, long groupId, long permissionId)
{
using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
bl.InsertInto(TableDefinition.TableName,
new DataParameter(TableDefinition.ColumnNames.GroupId, groupId),
new DataParameter(TableDefinition.ColumnNames.PermissionId, permissionId)
);
return(((IDataConnector)conn).ExecuteInsert(bl));
}
}
public static bool UpdateGroup(string name, bool guest, string parent, byte r, byte g, byte b, SQLiteConnector conn, string prefix = null, string suffix = null)
{
using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
bl.Update(TableDefinition.TableName, new DataParameter[]
{
new DataParameter(TableDefinition.ColumnNames.Name, name),
new DataParameter(TableDefinition.ColumnNames.ApplyToGuests, guest),
new DataParameter(TableDefinition.ColumnNames.Parent, parent),
new DataParameter(TableDefinition.ColumnNames.Chat_Red, r),
new DataParameter(TableDefinition.ColumnNames.Chat_Green, g),
new DataParameter(TableDefinition.ColumnNames.Chat_Blue, b),
new DataParameter(TableDefinition.ColumnNames.Chat_Prefix, prefix),
new DataParameter(TableDefinition.ColumnNames.Chat_Suffix, suffix)
}, new WhereFilter(TableDefinition.ColumnNames.Name, name));
return(((IDataConnector)conn).ExecuteNonQuery(bl) > 0);
}
}
public static bool Create(SQLiteConnector conn)
{
try
{
using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName))
{
bl.TableCreate(TableName, Columns);
((IDataConnector)conn).ExecuteNonQuery(bl);
}
//Set defaults
var pc = CommandParser.GetAvailableCommands(AccessLevel.PLAYER);
var ad = CommandParser.GetAvailableCommands(AccessLevel.OP);
var op = CommandParser.GetAvailableCommands(AccessLevel.CONSOLE); //Funny how these have now changed
CreateGroup("Guest", true, null, 255, 255, 255, conn, pc
.Where(x => !String.IsNullOrEmpty(x.Value.Node))
.Select(x => x.Value.Node)
.Distinct()
.ToArray());
CreateGroup("Admin", false, "Guest", 240, 131, 77, conn, ad
.Where(x => !String.IsNullOrEmpty(x.Value.Node))
.Select(x => x.Value.Node)
.Distinct()
.ToArray());
CreateGroup("Operator", false, "Admin", 77, 166, 240, conn, op
.Where(x => !String.IsNullOrEmpty(x.Value.Node))
.Select(x => x.Value.Node)
.Distinct()
.ToArray());
return(true);
}
catch (Exception e)
{
ProgramLog.Log(e);
return(false);
}
}
