Class MultiServerActivityIndexQueries

java.lang.Object
com.djrapitops.plan.storage.database.queries.analysis.MultiServerActivityIndexQueries

public class MultiServerActivityIndexQueries extends Object
Queries for Activity Index that support multiple ServerUUIDs.
  • Method Details

    • fetchActivityGroupCount

      public static Query<Integer> fetchActivityGroupCount(long date, Collection<ServerUUID> serverUUIDs, long playtimeThreshold, double above, double below)
    • fetchActivityGroupCounts

      public static Query<Map<String,Integer>> fetchActivityGroupCounts(long date, Collection<ServerUUID> serverUUIDs, long playtimeThreshold)
    • getActivityIndex

      public static Query<Double> getActivityIndex(long date, long playtimeThreshold, UUID playerUUID, List<ServerUUID> serverUUIDs)
    • averagePlaytimePerRegularPlayer

      public static Query<Long> averagePlaytimePerRegularPlayer(long after, long before, Collection<ServerUUID> serverUUIDs, long playtimeThreshold)
    • averageAfkPerRegularPlayer

      public static Query<Long> averageAfkPerRegularPlayer(long after, long before, Collection<ServerUUID> serverUUIDs, long playtimeThreshold)
    • averageSessionLengthPerRegularPlayer

      public static Query<Long> averageSessionLengthPerRegularPlayer(long after, long before, Collection<ServerUUID> serverUUIDs, long playtimeThreshold)
    • countNewPlayersTurnedRegular

      public static Query<Integer> countNewPlayersTurnedRegular(long after, long before, Collection<ServerUUID> serverUUIDs, long playtimeThreshold)
    • countRegularPlayersTurnedInactive

      public static Query<Integer> countRegularPlayersTurnedInactive(long start, long end, Collection<ServerUUID> serverUUIDs, long playtimeThreshold)
      Parameters:
      start - Start of the tracking, those regular will be counted here.
      end - End of the tracking, those inactive will be counted here.
      serverUUIDs - UUIDs of the servers.
      playtimeThreshold - Playtime threshold
      Returns:
      Query how many players went from regular to inactive in a span of time.