Advertisement
Guest User

Untitled

a guest
Sep 1st, 2014
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. if(tag.equals("01")) {
  2. rs.close();
  3. rs = ps.executeQuery(String.format("SELECT name, word FROM toplisten where name != 'timeDay'"));
  4.  
  5. while(rs.next()) {
  6. String name = rs.getString("name");
  7. String word = rs.getString("word");
  8. String month = rs.getString("month");
  9. String year = rs.getString("year");
  10. Client n = Server.get().getClient(name);
  11. Statement p = con.createStatement();
  12. ResultSet r = p.executeQuery(String.format("SELECT name,career FROM accounts where name != '%s' order by %s desc limit 3", Server.get().getButler().getName(), name));
  13. int platz = 1;
  14.  
  15. while(r.next()) {
  16. String nick = r.getString("name");
  17. String career = r.getString("career");
  18. String text = String.format("%s. Platz Top-%s im %s / %s", platz, word, month, year);
  19. Client ns = Server.get().getClient(nick);
  20. if(ns != null) {
  21. ns.setCareer(String.format("%s|%s %s|", ns.getCareer(), datum, text));
  22. } else {
  23. Server.get().query(String.format("update accounts set career='%s|%s %s|' where name='%s'", career, datum, text, nick));
  24. }
  25.  
  26. Server.get().newMessage(Server.get().getButler().getName(), nick, word, String.format("Hallo %s,##diesen Monat hast du den %s. Platz auf der Topliste %s geschafft.#Diese besondere Leistung wurde in Form eines Career Eintrags bei dir dokumentiert.##dein James", nick, platz, word), time);
  27. platz++;
  28. }
  29. }
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement