/** * Creates a new PreEvent for the specified Guild. * * @param _guildId The ID of the guild. */ public PreEvent(long _guildId) { guildId = _guildId; eventId = "N/a"; timeZone = "Unknown"; color = EventColor.NONE; recur = false; recurrence = new Recurrence(); eventData = new EventData(guildId); editing = false; lastEdit = System.currentTimeMillis(); }
public ArrayList<EventData> getAllEventData() { ArrayList<EventData> allData = new ArrayList<>(); try { if (databaseInfo.getMySQL().checkConnection()) { String eventTableName = String.format("%sevents", databaseInfo.getPrefix()); PreparedStatement stmt = databaseInfo.getConnection().prepareStatement("SELECT * FROM " + eventTableName); ResultSet res = stmt.executeQuery(); while (res.next()) { if (res.getString("EVENT_ID") != null) { EventData data = new EventData(Long.valueOf(res.getString("GUILD_ID"))); data.setEventId(res.getString("EVENT_ID")); data.setEventEnd(res.getLong("EVENT_END")); data.setImageLink(res.getString("IMAGE_LINK")); allData.add(data); } } stmt.close(); } } catch (SQLException e) { Logger.getLogger().exception(null, "Failed to get all event data", e, this.getClass()); } return allData; }
public EventData getEventData(long guildId, String eventId) { EventData data = new EventData(guildId); if (eventId.contains("_")) eventId = eventId.split("_")[0]; data.setEventId(eventId); try { if (databaseInfo.getMySQL().checkConnection()) { String eventTableName = String.format("%sevents", databaseInfo.getPrefix()); String query = "SELECT * FROM " + eventTableName + " WHERE GUILD_ID= ?"; PreparedStatement statement = databaseInfo.getConnection().prepareStatement(query); statement.setString(1, guildId + ""); ResultSet res = statement.executeQuery(); while (res.next()) { if (res.getString("EVENT_ID").equals(eventId)) { data.setEventEnd(res.getLong("EVENT_END")); data.setImageLink(res.getString("IMAGE_LINK")); break; } } statement.close(); } } catch (SQLException e) { Logger.getLogger().exception(null, "Failed to get event data", e, this.getClass()); } return data; }
EventData ed = new EventData(settings.getGuildID()); if (!body.getString("image").equalsIgnoreCase("")) { ed.setImageLink(body.getString("image"));
EventData ed = new EventData(settings.getGuildID()); if (!body.getString("image").equalsIgnoreCase("")) { ed.setImageLink(body.getString("image"));
EventData ed = new EventData(settings.getGuildID()); ed.setEventId(event.getId());
EventData ed = new EventData(settings.getGuildID()); ed.setEventId(event.getId());
EventData ed = new EventData(settings.getGuildID()); ed.setEventId(event.getId());
EventData ed = new EventData(settings.getGuildID()); if (!body.getString("image").equalsIgnoreCase("")) { ed.setImageLink(body.getString("image"));