Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public int getEloGuild(String guildname, String nomdelacolonne) {
- int value = 0;
- try {
- PreparedStatement q = connection.prepareStatement("SELECT uuid FROM playerguild WHERE guildname = ?");
- q.setString(1, guildname);
- ResultSet res = q.executeQuery();
- while (res.next()) {
- String s = res.getString("uuid");
- Main.guild.add(s);
- }
- q.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- for(String uuid : Main.guild) {
- try {
- String stat = "SELECT " + nomdelacolonne + " FROM stats WHERE uuid = ?";
- PreparedStatement q = connection.prepareStatement(stat);
- q.setString(1, uuid);
- ResultSet res = q.executeQuery();
- while (res.next()) {
- int valeur = res.getInt(nomdelacolonne);
- value += valeur;
- }
- q.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- if(Main.guild.size() != 0) {
- value = value / Main.guild.size();
- }
- Main.guild.clear();
- return value;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement