public CloseableIterator<PlayerWarnData> findWarnings(long fromTime) throws SQLException {
    if (fromTime == 0) {
      return iterator();
    }

    long checkTime = fromTime + DateUtils.getTimeDiff();

    QueryBuilder<PlayerWarnData, Integer> query = queryBuilder();
    Where<PlayerWarnData, Integer> where = query.where();
    where.ge("created", checkTime);

    query.setWhere(where);

    return query.iterator();
  }
  public double getCurrentNoise(TitaniumDb helper) throws SQLException, AngryJulienException {
    Dao<NoiseEntry, Long> dao = helper.dao(NoiseEntry.class, Long.class);
    QueryBuilder<NoiseEntry, Long> qb = dao.queryBuilder();
    long curTime = System.currentTimeMillis();

    double weekAgo = 0.0, dayAgo = 0.0, hourAgo = 0.0;

    //// WEEK AGO
    int count = 0;
    qb.where()
        .eq(NoiseEntry.COLUMN_NAME_PARENT_ID, this.id)
        .and()
        .between(
            NoiseEntry.COLUMN_NAME_TIMESTAMP,
            curTime - TimeUtils.WEEK - TimeUtils.HOUR,
            curTime - TimeUtils.WEEK + TimeUtils.HOUR);
    CloseableIterator<NoiseEntry> it = qb.iterator();
    while (it.hasNext()) {
      weekAgo += it.next().getNoise();
      count++;
    }
    it.close();
    if (count == 0) {
      weekAgo = -1.1;
    } else {
      weekAgo /= count;
    }

    /// DAY AGO
    count = 0;
    qb = dao.queryBuilder();
    qb.where()
        .eq(NoiseEntry.COLUMN_NAME_PARENT_ID, this.id)
        .and()
        .between(
            NoiseEntry.COLUMN_NAME_TIMESTAMP,
            curTime - TimeUtils.DAY - TimeUtils.HOUR,
            curTime - TimeUtils.DAY + TimeUtils.HOUR);
    it = qb.iterator();
    while (it.hasNext()) {
      dayAgo += it.next().getNoise();
      count++;
    }
    it.close();
    if (count == 0) {
      dayAgo = -1.1;
    } else {
      dayAgo /= count;
    }

    //// HOUR AGO
    count = 0;
    qb = dao.queryBuilder();
    qb.where()
        .eq(NoiseEntry.COLUMN_NAME_PARENT_ID, this.id)
        .and()
        .between(
            NoiseEntry.COLUMN_NAME_TIMESTAMP,
            curTime - TimeUtils.HOUR - (5 * TimeUtils.MINUTE),
            curTime - TimeUtils.HOUR + (5 * TimeUtils.MINUTE));
    it = qb.iterator();
    while (it.hasNext()) {
      hourAgo += it.next().getNoise();
      count++;
    }
    it.close();
    if (count == 0) {
      hourAgo = -1.1;
    } else {
      hourAgo /= count;
    }

    double time = 0;
    count = 0;
    if (dayAgo != -1.1) {
      count++;
      time += dayAgo;
    }
    if (weekAgo != -1.1) {
      count++;
      time += weekAgo;
    }
    if (hourAgo != -1.1) {
      count++;
      time += hourAgo;
    }

    if (count > 0) {
      return time / count;
    }

    time = 0.0;
    count = 0;

    it = noiseEntries.closeableIterator();
    while (it.hasNext()) {
      time += it.next().getNoise();
      count++;
    }

    if (count > 0) return time / count;
    throw new AngryJulienException("I am so mad at this point b/c you ain't got anything");
  }