Code:
import java.sql.*;
import java.security.MessageDigest;
public class highscore {
public static Connection con = null;
public static Statement stm;
public static void createCon() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://databaseURL/databaseName", "username", "password");
stm = con.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
public static ResultSet query(String s) throws SQLException {
try {
if (s.toLowerCase().startsWith("select")) {
ResultSet rs = stm.executeQuery(s);
return rs;
} else {
stm.executeUpdate(s);
}
return null;
} catch (Exception e) {
misc.println("MySQL Error:"+s);
e.printStackTrace();
}
return null;
}
public static void destroyCon() {
try {
stm.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static boolean save(client c) {
try {
query("DELETE FROM `skills` WHERE playerName = '"+c.playerName+"';");
query("DELETE FROM `skillsoverall` WHERE playerName = '"+c.playerName+"';");
query("INSERT INTO `skills`(`playerName`,`Attackxp`,`Defencexp`,`Strengthxp`,`Hitpointsxp`,`Rangexp`,`Prayerxp`,`Magicxp`,`Cookingxp`,`Woodcuttingxp`,`Fletchingxp`,`Fishingxp`,`Firemakingxp`,`Craftingxp`,`Smithingxp`,`Miningxp`,`Herblorexp`,`Agilityxp`,`Thievingxp`,`Slayerxp`,`Farmingxp`,`Runecraftxp`) VALUES ('"+c.playerName+"','"+c.playerXP[0]+"','"+c.playerXP[1]+"','"+c.playerXP[2]+"','"+c.playerXP[3]+"','"+c.playerXP[4]+"','"+c.playerXP[5]+"','"+c.playerXP[6]+"','"+c.playerXP[7]+"','"+c.playerXP[8]+"','"+c.playerXP[9]+"','"+c.playerXP[10]+"','"+c.playerXP[11]+"','"+c.playerXP[12]+"','"+c.playerXP[13]+"','"+c.playerXP[14]+"','"+c.playerXP[15]+"','"+c.playerXP[16]+"','"+c.playerXP[17]+"','"+c.playerXP[18]+"','"+c.playerXP[19]+"','"+c.playerXP[20]+"');");
query("INSERT INTO `skillsoverall` (`playerName`,`lvl`,`xp`) VALUES ('"+c.playerName+"','"+(c.getLevelForXP(c.playerXP[0]) + c.getLevelForXP(c.playerXP[1]) + c.getLevelForXP(c.playerXP[2]) + c.getLevelForXP(c.playerXP[3]) + c.getLevelForXP(c.playerXP[4]) + c.getLevelForXP(c.playerXP[5]) + c.getLevelForXP(c.playerXP[6]) + c.getLevelForXP(c.playerXP[7]) + c.getLevelForXP(c.playerXP[8]) + c.getLevelForXP(c.playerXP[9]) + c.getLevelForXP(c.playerXP[10]) + c.getLevelForXP(c.playerXP[11]) + c.getLevelForXP(c.playerXP[12]) + c.getLevelForXP(c.playerXP[13]) + c.getLevelForXP(c.playerXP[14]) + c.getLevelForXP(c.playerXP[15]) + c.getLevelForXP(c.playerXP[16]) + c.getLevelForXP(c.playerXP[17]) + c.getLevelForXP(c.playerXP[18]) + c.getLevelForXP(c.playerXP[19]) + c.getLevelForXP(c.playerXP[20]))+"','"+((c.playerXP[0]) + (c.playerXP[1]) + (c.playerXP[2]) + (c.playerXP[3]) + (c.playerXP[4]) + (c.playerXP[5]) + (c.playerXP[6]) + (c.playerXP[7]) + (c.playerXP[8]) + (c.playerXP[9]) + (c.playerXP[10]) + (c.playerXP[11]) + (c.playerXP[12]) + (c.playerXP[13]) + (c.playerXP[14]) + (c.playerXP[15]) + (c.playerXP[16]) + (c.playerXP[17]) + (c.playerXP[18]) + (c.playerXP[19]) + (c.playerXP[20]))+"');");
} catch (Exception e) {
e.printStackTrace();
return false;
}
return true;
}
}
Don't forget to add this to your