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; }
String eventTableName = String.format("%sevents", databaseInfo.getPrefix()); if (data.getEventId().contains("_")) { data.setEventId(data.getEventId().split("_")[0]); statement.setString(1, data.getEventId()); " VALUES (?, ?, ?, ?)"; PreparedStatement ps = databaseInfo.getConnection().prepareStatement(insertCommand); ps.setString(1, String.valueOf(data.getGuildId())); ps.setString(2, data.getEventId()); ps.setLong(3, data.getEventEnd()); ps.setString(4, data.getImageLink()); PreparedStatement ps = databaseInfo.getConnection().prepareStatement(update); ps.setString(1, data.getImageLink()); ps.setLong(2, data.getEventEnd()); ps.setString(3, data.getEventId());
EventData ed = new EventData(settings.getGuildID()); if (!body.getString("image").equalsIgnoreCase("")) { ed.setImageLink(body.getString("image")); ed.setEventId(eventId); ed.setEventEnd(event.getEnd().getDateTime().getValue()); if (!ImageUtils.validate(ed.getImageLink(), settings.isPatronGuild())) { JSONObject respondBody = new JSONObject(); respondBody.put("Message", "Failed to create event!"); if (ed.shouldBeSaved()) DatabaseManager.getManager().updateEventData(ed);
jo.put("image", ed.getImageLink());
/** * 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(); }
EventData ed = new EventData(settings.getGuildID()); if (!body.getString("image").equalsIgnoreCase("")) { ed.setImageLink(body.getString("image")); ed.setEventId(eventId); ed.setEventEnd(event.getEnd().getDateTime().getValue()); if (!ImageUtils.validate(ed.getImageLink(), settings.isPatronGuild())) { JSONObject respondBody = new JSONObject(); respondBody.put("Message", "Failed to create event!"); if (ed.shouldBeSaved()) DatabaseManager.getManager().updateEventData(ed);
jo.put("image", ed.getImageLink());
EventData ed = new EventData(settings.getGuildID()); ed.setEventId(event.getId()); ed.setImageLink(body.getString("image")); ed.setEventEnd(event.getEnd().getDateTime().getValue()); if (!ImageUtils.validate(ed.getImageLink(), settings.isPatronGuild())) { response.setContentType("application/json"); response.setStatus(400); if (ed.shouldBeSaved()) DatabaseManager.getManager().updateEventData(ed);
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; }
jo.put("image", ed.getImageLink());
EventData ed = new EventData(settings.getGuildID()); ed.setEventId(event.getId()); ed.setImageLink(body.getString("image")); ed.setEventEnd(event.getEnd().getDateTime().getValue()); if (!ImageUtils.validate(ed.getImageLink(), settings.isPatronGuild())) { response.setContentType("application/json"); response.setStatus(400); if (ed.shouldBeSaved()) DatabaseManager.getManager().updateEventData(ed);
EventData ed = new EventData(settings.getGuildID()); ed.setEventId(event.getId()); ed.setImageLink(body.getString("image")); ed.setEventEnd(event.getEnd().getDateTime().getValue()); if (!ImageUtils.validate(ed.getImageLink(), settings.isPatronGuild())) { response.setContentType("application/json"); response.setStatus(400); if (ed.shouldBeSaved()) DatabaseManager.getManager().updateEventData(ed);
EventData ed = new EventData(settings.getGuildID()); if (!body.getString("image").equalsIgnoreCase("")) { ed.setImageLink(body.getString("image")); ed.setEventId(eventId); ed.setEventEnd(event.getEnd().getDateTime().getValue()); if (!ImageUtils.validate(ed.getImageLink(), settings.isPatronGuild())) { JSONObject respondBody = new JSONObject(); respondBody.put("Message", "Failed to create event!"); if (ed.shouldBeSaved()) DatabaseManager.getManager().updateEventData(ed);