示例#1
0
  /**
   * Get a ban for this player name. This may return null if the ban does not exist
   *
   * @param name
   * @return Returns a ban object if that ban was found, null otherwise
   */
  public Ban getBan(String name) {
    Ban newBan = null;
    Canary.db().prepare();
    DatabaseRow[] toLift = getTable().getFilteredRows("name", name);

    if (toLift != null && toLift.length > 0) {
      // It should only be one
      newBan = new Ban();
      DatabaseRow row = toLift[0];
      newBan.setReason(row.getStringCell("reason"));
      newBan.setSubject(row.getStringCell("name"));
      newBan.setIp(row.getStringCell("ip"));
      newBan.setTimestamp(row.getLongCell("timestamp"));
    }
    Canary.db().execute();
    return newBan;
  }
示例#2
0
  /**
   * Load and return all recorded bans
   *
   * @return
   */
  public ArrayList<Ban> loadBans() {
    Canary.db().prepare();
    ArrayList<Ban> banList = new ArrayList<Ban>();
    DatabaseTable table = getTable();

    DatabaseRow[] rows = table.getAllRows();
    if (rows != null) {
      for (DatabaseRow row : rows) {
        Ban ban = new Ban();
        ban.setIp(row.getStringCell("ip"));
        ban.setReason(row.getStringCell("reason"));
        ban.setSubject(row.getStringCell("name"));
        ban.setTimestamp(row.getLongCell("timestamp"));
        banList.add(ban);
      }
    }
    Canary.db().execute();
    return banList;
  }