public static long CreateGroup(string name, bool guest, string parent, byte r, byte g, byte b, SQLiteConnector conn, string[] nodes = null, string prefix = null, string suffix = null) { long id; using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.InsertInto(TableDefinition.TableName, 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) ); id = ((IDataConnector)conn).ExecuteInsert(bl); } if (nodes != null) foreach (var nd in nodes) { var nodeId = PermissionTable.InsertRecord(conn, nd, false); GroupPermissionsTable.InsertRecord(conn, id, nodeId); } return id; }
public void Initialise(SQLiteConnector conn) { if (!TableDefinition.Exists(conn)) { ProgramLog.Admin.Log("Permission node table does not exist and will now be created"); TableDefinition.Create(conn); } }
public void Initialise(SQLiteConnector conn) { if (!TableDefinition.Exists(conn)) { ProgramLog.Admin.Log("Permission node table does not exist and will now be created"); TableDefinition.Create(conn); } }
public long FindOrCreate(SQLiteConnector conn, string node, bool deny) { var existing = Find(node, deny); if (existing == null) { return Insert(conn, node, deny); } return existing.Value.Id; }
public static bool DeleteGroup(string name, SQLiteConnector conn) { using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.Delete(TableDefinition.TableName, new WhereFilter(TableDefinition.ColumnNames.Name, name)); return ((IDataConnector)conn).ExecuteNonQuery(bl) > 0; } }
public static bool Exists(SQLiteConnector conn) { using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.TableExists(TableName); return ((IDataConnector)conn).Execute(bl); } }
public static bool Create(SQLiteConnector conn) { using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.TableCreate(TableName, Columns); return ((IDataConnector)conn).ExecuteNonQuery(bl) > 0; } }
public static bool Exists(SQLiteConnector conn) { using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.TableExists(TableName); return(((IDataConnector)conn).Execute(bl)); } }
public static bool DeleteGroup(string name, SQLiteConnector conn) { using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.Delete(TableDefinition.TableName, new WhereFilter(TableDefinition.ColumnNames.Name, name)); return(((IDataConnector)conn).ExecuteNonQuery(bl) > 0); } }
public static bool Create(SQLiteConnector conn) { using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.TableCreate(TableName, Columns); return(((IDataConnector)conn).ExecuteNonQuery(bl) > 0); } }
public long FindOrCreate(SQLiteConnector conn, string node, bool deny) { var existing = Find(node, deny); if (existing == null) { return(Insert(conn, node, deny)); } return(existing.Value.Id); }
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 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 bool Delete(SQLiteConnector conn, long userId, long groupId) { var res = DeleteLink(conn, userId, groupId); //Alternatively we could reload, but this shouldn't be called often if (res) { _data = _data.Where(x => x.UserId != userId || x.GroupId != groupId).ToArray(); } return(res); }
public bool Delete(string name, SQLiteConnector conn) { var res = DeleteGroup(name, conn); //Alternatively we could reload, but this shouldn't be called often if (res) { _data = _data.Where(x => x.Name != name).ToArray(); } return(res); }
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 bool Delete(SQLiteConnector conn, long groupId, long permissionId) { var res = DeleteRecord(conn, groupId, permissionId); //Alternatively we could reload, but this shouldn't be called often if (res) { _data = _data.Where(x => x.GroupId != groupId || x.PermissionId != permissionId).ToArray(); } return res; }
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 bool Delete(SQLiteConnector conn, long userId, long groupId) { var res = DeleteLink(conn, userId, groupId); //Alternatively we could reload, but this shouldn't be called often if (res) { _data = _data.Where(x => x.UserId != userId || x.GroupId != groupId).ToArray(); } return res; }
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 bool Delete(SQLiteConnector conn, long groupId, long permissionId) { var res = DeleteRecord(conn, groupId, permissionId); //Alternatively we could reload, but this shouldn't be called often if (res) { _data = _data.Where(x => x.GroupId != groupId || x.PermissionId != permissionId).ToArray(); } return(res); }
void OnReadConfig(ref HookContext ctx, ref HookArgs.ConfigurationLine args) { switch (args.Key) { case "sqlite": if (_connector == null) { var cn = new SQLiteConnector(args.Value); cn.Open(); Storage.SetConnector(cn); _connector = cn; } break; } }
public long Insert(SQLiteConnector conn, string node, bool deny) { var id = InsertRecord(conn, node, deny); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new PermissionNode() { Id = id, Node = node, Deny = deny }; } return(id); }
void OnReadConfig(ref HookContext ctx, ref HookArgs.ConfigurationLine args) { switch (args.Key) { case "sqlite": if (_connector == null) { var cn = new SQLiteConnector(args.Value); cn.Open(); Storage.SetConnector(cn); _connector = cn; } break; } }
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); } }
public long Insert(SQLiteConnector conn, long userId, long groupId) { var id = CreateLink(conn, userId, groupId); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { if (_data == null) { _data = new TDSM.Data.SQLite.UserGroup[0]; } Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new TDSM.Data.SQLite.UserGroup() { Id = id, UserId = userId, GroupId = groupId }; } return(id); }
public long Insert(SQLiteConnector conn, long groupId, long permissionId) { var id = InsertRecord(conn, groupId, permissionId); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { if (_data == null) { _data = new TDSM.Data.SQLite.GroupPermission[0]; } Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new GroupPermission() { Id = id, GroupId = groupId, PermissionId = permissionId }; } return(id); }
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 long Insert(string name, bool guest, string parent, byte r, byte g, byte b, SQLiteConnector conn, string[] nodes = null, string prefix = null, string suffix = null) { var id = CreateGroup(name, guest, parent, r, g, b, conn, nodes, prefix, suffix); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { if (_data == null) { _data = new Group[0]; } Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new Group() { Id = id, Name = name, ApplyToGuests = guest, Parent = parent, Chat_Red = r, Chat_Green = g, Chat_Prefix = prefix, Chat_Suffix = suffix }; } return(id); }
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 bool Delete(string name, SQLiteConnector conn) { var res = DeleteGroup(name, conn); //Alternatively we could reload, but this shouldn't be called often if (res) { _data = _data.Where(x => x.Name != name).ToArray(); } return res; }
public long Insert(string name, bool guest, string parent, byte r, byte g, byte b, SQLiteConnector conn, string[] nodes = null, string prefix = null, string suffix = null) { var id = CreateGroup(name, guest, parent, r, g, b, conn, nodes, prefix, suffix); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { if (_data == null) _data = new Group[0]; Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new Group() { Id = id, Name = name, ApplyToGuests = guest, Parent = parent, Chat_Red = r, Chat_Green = g, Chat_Prefix = prefix, Chat_Suffix = suffix }; } return id; }
public long Insert(SQLiteConnector conn, string node, bool deny) { var id = InsertRecord(conn, node, deny); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new PermissionNode() { Id = id, Node = node, Deny = deny }; } return id; }
public long Insert(SQLiteConnector conn, long groupId, long permissionId) { var id = InsertRecord(conn, groupId, permissionId); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { if (_data == null) _data = new TDSM.Data.SQLite.GroupPermission[0]; Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new GroupPermission() { Id = id, GroupId = groupId, PermissionId = permissionId }; } return id; }
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; } }
public static long CreateGroup(string name, bool guest, string parent, byte r, byte g, byte b, SQLiteConnector conn, string[] nodes = null, string prefix = null, string suffix = null) { long id; using (var bl = new SQLiteQueryBuilder(Plugin.SQLSafeName)) { bl.InsertInto(TableDefinition.TableName, 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) ); id = ((IDataConnector)conn).ExecuteInsert(bl); } if (nodes != null) { foreach (var nd in nodes) { var nodeId = PermissionTable.InsertRecord(conn, nd, false); GroupPermissionsTable.InsertRecord(conn, id, nodeId); } } return(id); }
public long Insert(SQLiteConnector conn, long userId, long groupId) { var id = CreateLink(conn, userId, groupId); //Alternatively we could reload, but this shouldn't be called often if (id > 0L) { if (_data == null) _data = new TDSM.Data.SQLite.UserGroup[0]; Array.Resize(ref _data, _data.Length + 1); _data[_data.Length - 1] = new TDSM.Data.SQLite.UserGroup() { Id = id, UserId = userId, GroupId = groupId }; } return id; }