public uint Count(uint estateID, RegionFlags flags) { IEstateConnector estates = Framework.Utilities.DataManager.RequestPlugin <IEstateConnector>(); if (estates == null) { return(0); } EstateSettings es = estates.GetEstateSettings((int)estateID); QueryFilter filter = new QueryFilter(); filter.andBitfieldAndFilters["Flags"] = (uint)flags; List <GridRegion> query = ParseQuery(null, GD.Query(new string[] { "*" }, m_realm, filter, null, null, null)); uint count = 0; query.ForEach(delegate(GridRegion region) { if (region.EstateOwner == es.EstateOwner && estates.GetEstateID(region.RegionID) == es.EstateID) { ++count; } }); return(count); }
public List <GridRegion> Get(RegionFlags flags) { QueryFilter filter = new QueryFilter(); filter.andBitfieldAndFilters["Flags"] = (uint)flags; return(ParseQuery(null, GD.Query(new string[1] { "*" }, m_realm, filter, null, null, null))); }
public uint Count(RegionFlags includeFlags, RegionFlags excludeFlags) { QueryFilter filter = new QueryFilter(); if (includeFlags > 0) { filter.andBitfieldAndFilters["Flags"] = (uint)includeFlags; } if (excludeFlags > 0) { filter.andBitfieldNandFilters["Flags"] = (uint)excludeFlags; } return(uint.Parse(GD.Query(new string[1] { "COUNT(*)" }, m_realm, filter, null, null, null)[0])); }
public List <GridRegion> Get(RegionFlags includeFlags, RegionFlags excludeFlags, uint?start, uint?count, Dictionary <string, bool> sort) { QueryFilter filter = new QueryFilter(); if (includeFlags > 0) { filter.andBitfieldAndFilters["Flags"] = (uint)includeFlags; } if (excludeFlags > 0) { filter.andBitfieldNandFilters["Flags"] = (uint)excludeFlags; } return(ParseQuery(null, GD.Query(new string[1] { "*" }, m_realm, filter, sort, start, count))); }
public List <GridRegion> Get(uint start, uint count, uint estateID, RegionFlags flags, Dictionary <string, bool> sort) { List <GridRegion> resp = new List <GridRegion>(); IEstateConnector estates = Framework.Utilities.DataManager.RequestPlugin <IEstateConnector>(); if (count == 0 || estates == null) { return(resp); } EstateSettings es = estates.GetEstateSettings((int)estateID); QueryFilter filter = new QueryFilter(); filter.andBitfieldAndFilters["Flags"] = (uint)flags; while (resp.Count < count) { uint limit = count - (uint)resp.Count; List <GridRegion> query = ParseQuery(null, GD.Query(new string[] { "*" }, m_realm, filter, sort, start, count)); if (query.Count == 0) { break; } query.ForEach(delegate(GridRegion region) { if (region.EstateOwner == es.EstateOwner && estates.GetEstateID(region.RegionID) == es.EstateID) { resp.Add(region); } }); start += limit; } return(resp); }
public List <GridRegion> Get(RegionFlags flags, Dictionary <string, bool> sort) { return(Get(flags, 0, null, null, sort)); }