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; }
ed.setImageLink(body.getString("image")); ed.setEventId(eventId); ed.setEventEnd(event.getEnd().getDateTime().getValue());
ed.setImageLink(body.getString("image")); ed.setEventId(eventId); ed.setEventEnd(event.getEnd().getDateTime().getValue());
ed.setEventEnd(event.getEnd().getDateTime().getValue());
ed.setEventEnd(event.getEnd().getDateTime().getValue());
ed.setEventEnd(event.getEnd().getDateTime().getValue());
ed.setImageLink(body.getString("image")); ed.setEventId(eventId); ed.setEventEnd(event.getEnd().getDateTime().getValue());