public static void removeReport(int number) {
try {
Statement st = dbmanager.getConnection().createStatement();
st.executeUpdate("DELETE FROM Reports WHERE Number='" + number + "'");
} catch (SQLException e) {
System.out.println(
"[BungeeUtilisals]: Can't remove request number " + number + ", " + e.getMessage());
}
}
public static String getReason(int number) {
String reason = "";
try {
Statement st = dbmanager.getConnection().createStatement();
ResultSet rs = null;
rs = st.executeQuery("SELECT * FROM Reports WHERE Number='" + number + "'");
while (rs.next()) {
reason = rs.getString("Reason");
}
} catch (SQLException e) {
e.printStackTrace();
}
return reason;
}
public static List<Integer> getReportNumbers() {
List<Integer> reports = new ArrayList<Integer>();
try {
Statement st = dbmanager.getConnection().createStatement();
ResultSet rs = null;
rs = st.executeQuery("SELECT * FROM Reports");
while (rs.next()) {
int reportnumber = rs.getInt("Number");
reports.add(reportnumber);
}
} catch (SQLException e) {
System.out.println(
"[BungeeUtilisals]: An error occured while contacting the Database! " + e.getMessage());
}
return reports;
}
public static void addReport(
int number, ProxiedPlayer reporter, ProxiedPlayer reported, String reason) {
try {
Statement st = dbmanager.getConnection().createStatement();
st.executeUpdate(
"INSERT INTO Reports(Number, Reporter, Player, Reason) VALUES ('"
+ number
+ "', '"
+ reporter.getName()
+ "', '"
+ reported.getName()
+ "', '"
+ reason
+ "')");
} catch (SQLException e) {
System.out.println(
"[BungeeUtilisals]: Can't add Report from: "
+ reporter.getName()
+ ", "
+ e.getMessage());
}
}