Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.35 KB | None | 0 0
  1. public class CMD_Top implements CommandExecutor
  2. {
  3. public boolean onCommand(CommandSender s, Command cmd, String label, String[] args)
  4. {
  5. if (MySQLConnector.isConnected()) {
  6. try
  7. {
  8. ResultSet rs = MySQLConnector.query("SELECT `KILLS`,`NAME` FROM `Stats` ORDER BY KILLS DESC LIMIT 10;");
  9.  
  10. int i = 0;
  11. while (rs.next())
  12. {
  13. i++;
  14. String op = rs.getString(2);
  15. if (i == 1) {
  16. s.sendMessage(Main.Prefix + "§cTop10 §eSpieler");
  17. s.sendMessage(Main.Prefix + "§a#1 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  18. }
  19. if (i == 2) {
  20. s.sendMessage(Main.Prefix + "§a#2 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  21. }
  22. if (i == 3) {
  23. s.sendMessage(Main.Prefix + "§a#3 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  24. }
  25. if (i == 4) {
  26. s.sendMessage(Main.Prefix + "§a#4 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  27. }
  28. if (i == 5) {
  29. s.sendMessage(Main.Prefix + "§a#5 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  30. }
  31. if (i == 6) {
  32. s.sendMessage(Main.Prefix + "§a#6 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  33. }
  34. if (i == 7) {
  35. s.sendMessage(Main.Prefix + "§a#7 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  36. }
  37. if (i == 8) {
  38. s.sendMessage(Main.Prefix + "§a#8 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  39. }
  40. if (i == 9) {
  41. s.sendMessage(Main.Prefix + "§a#9 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  42. }
  43. if (i == 10) {
  44. s.sendMessage(Main.Prefix + "§a#10 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
  45. }
  46. }
  47. }
  48. catch (SQLException localSQLException) {}
  49. } else {
  50. s.sendMessage(Main.Prefix + "§bEs besteht zurzeit keine Berbindung zu einer Datenbank");
  51. }
  52. return false;
  53. }
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement