Originally Posted by
idyte
Nothing happends
Next try:
Code:
public HiscoreUpdater(Player player) {
this.player = player;
System.out.println("Sends highscore!");
}
Code:
public void run() {
System.out.println("Attempt a run for highscore");
try {
if (!connect(HOST, DATABASE, USER, PASS)) {
return;
}
String name = player.getUsername();
int totalPrestige = 0;
for (int prestige : player.getSkillPrestiges()) {
if (prestige > 0) {
totalPrestige += prestige;
}
}
PreparedStatement stmt1 = prepare("DELETE FROM "+TABLE+" WHERE username=?");
stmt1.setString(1, player.getUsername().trim().replaceAll(" ", "_"));
stmt1.execute();
PreparedStatement stmt2 = prepare(generateQuery());
stmt2.setString(1, player.getUsername().trim().replaceAll(" ", "_"));
stmt2.setInt(2, player.getRights());
stmt2.setInt(3, totalPrestige);
stmt2.setLong(4, player.getSkill().getTotalExperience());
for (int i = 0; i < 44; i += 2) {
stmt2.setInt(5 + i, (int)player.getSkill().getExperience()[i/2]);
stmt2.setInt(5 + i + 1, (int)player.getSkillPrestiges()[i/2]);
}
stmt2.execute();
destroy();
} catch (Exception e) {
e.printStackTrace();
}
}
If it do not send anything, then you have not told it to read the run value when your player log out.