Guest User

Untitled

a guest
Jul 30th, 2020
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1.  
  2. public static void createReport(String ReportetPlayer, String Reporter,String Grund){
  3. SimpleDateFormat date2 = new SimpleDateFormat("dd.MM.yyyy HH:mm:ss");
  4. String date = date2.format(new Date());
  5. MySQL.update("INSERT INTO Reports (Reportet, Reporter, Date, Grund) VALUES ('"+ReportetPlayer+"','"+Reporter+"','"+date+"','"+Grund+"')");
  6. }
  7.  
  8. public static String getReason(Player username){
  9. try {
  10. ResultSet ps = MySQL.getResult("SELECT * FROM Reports WHERE Reportet ='"+username.getName()+"'");
  11.  
  12. while (ps.next()) {
  13. return ps.getString("Grund");
  14. }
  15.  
  16. } catch (Exception e) {
  17. e.printStackTrace();
  18. }
  19. return "";
  20. }
  21. public static String getReportet(Player username){
  22. try {
  23. ResultSet ps = MySQL.getResult("SELECT Reportet FROM Reports WHERE Reportet ='"+username.getName()+"'");
  24.  
  25. while (ps.next()) {
  26. return ps.getString("Reportet");
  27. }
  28.  
  29. } catch (Exception e) {
  30. e.printStackTrace();
  31. }
  32. return "";
  33. }
Advertisement
Add Comment
Please, Sign In to add comment