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