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