015
 dekros
Offline
dekros
Użytkownik
tak wygląda metoda od nadawania każdemu turbo dropu
Kod (java):

public static void turboDropAll(CommandSender sender, long time) {
int i = 0;
long timer = 0;
Connection conn = AwesomeDrop.getMySQL().getConnection();
if (conn == null) {
try {
conn = AwesomeDrop.getMySQL().openConnection();
} catch (Exception e) {
}
}
PreparedStatement st;
ResultSet rs;
try {
st = conn.prepareStatement("SELECT * FROM `AwesomeDrop`");
rs = st.executeQuery();
timer = System.currentTimeMillis();
while (rs.next()) {
i++;
// if (Bukkit.getPlayer(UUID.fromString(rs.getString("uuid"))) == null) {
long turbotime;
if (System.currentTimeMillis() - rs.getLong("turbodropstart") > rs.getLong("turbodroptime")) {
turbotime = time;
} else {
turbotime = rs.getLong("turbodroptime") + time;
}
long now = System.currentTimeMillis();
StringBuilder query = new StringBuilder();
query.append("INSERT INTO `AwesomeDrop` (`uuid`, `name`, `turbodropstart`, `obsidian`, `stone`,`turbodroptime`,`points`) ")
.append("VALUES (?,?,?,?,?,?,?)")
.append(" ON DUPLICATE KEY UPDATE ")
.append("`turbodropstart`=VALUES(`turbodropstart`), ")
.append("`turbodroptime`=VALUES(`turbodroptime`)");
st = conn.prepareStatement(query.toString());
st.setString(1, rs.getString("uuid"));
st.setString(2, rs.getString("name"));
st.setLong(3, now);
st.setInt(4, rs.getInt("obsidian"));
st.setInt(5, rs.getInt("stone"));
st.setLong(6, turbotime);
st.setInt(7, rs.getInt("points"));
st.executeUpdate();
AwesomeDrop.getMySQL().closeResources(null, st);
// } else {
// User user = UserManager.getUser(UUID.fromString(rs.getString("uuid")));
// user.setDropType(DropType.TURBO);
// user.setTurboDropStart(System.currentTimeMillis());
// user.setTurboDropTime(user.getTurboDropTime() + time);
// user.save();
// }
}
} catch (SQLException e) {
e.printStackTrace();
}
sender.sendMessage("nadawanie turbodropu dla " + i + " osob trwalo to " + (System.currentTimeMillis() - timer));
sender.sendMessage(MyUtils.fixColor("&2" + i + "&6 osob/y dostalo turbo drop na: &4" + getStringFromLong(time)));
HashMap<String, String> vars = new HashMap<>();
vars.put("admin", sender.getName());
vars.put("turbo_time", getStringFromLong(time));
Message.Message_turboDropAll.vars(vars).broadcast();