Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class CMD_Top implements CommandExecutor
- {
- public boolean onCommand(CommandSender s, Command cmd, String label, String[] args)
- {
- if (MySQLConnector.isConnected()) {
- try
- {
- ResultSet rs = MySQLConnector.query("SELECT `KILLS`,`NAME` FROM `Stats` ORDER BY KILLS DESC LIMIT 10;");
- int i = 0;
- while (rs.next())
- {
- i++;
- String op = rs.getString(2);
- if (i == 1) {
- s.sendMessage(Main.Prefix + "§cTop10 §eSpieler");
- s.sendMessage(Main.Prefix + "§a#1 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 2) {
- s.sendMessage(Main.Prefix + "§a#2 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 3) {
- s.sendMessage(Main.Prefix + "§a#3 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 4) {
- s.sendMessage(Main.Prefix + "§a#4 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 5) {
- s.sendMessage(Main.Prefix + "§a#5 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 6) {
- s.sendMessage(Main.Prefix + "§a#6 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 7) {
- s.sendMessage(Main.Prefix + "§a#7 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 8) {
- s.sendMessage(Main.Prefix + "§a#8 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 9) {
- s.sendMessage(Main.Prefix + "§a#9 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- if (i == 10) {
- s.sendMessage(Main.Prefix + "§a#10 §8» §7" + op + " §8» §a" + String.valueOf(rs.getInt(1)) + " §eKills");
- }
- }
- }
- catch (SQLException localSQLException) {}
- } else {
- s.sendMessage(Main.Prefix + "§bEs besteht zurzeit keine Berbindung zu einer Datenbank");
- }
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement