Code:
package server.model.players;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
public class HiscoresHandler {
private static boolean HiScores = true;
private static final String DB = "propkcom_highscores";
private static final String URL = "pro-pk.com";
private static final String USER = "propkcom_brian";
private static final String PASS = "number2123z";
private static final Properties prop;
static {
prop = new Properties();
HiscoresHandler.prop.put("user", HiscoresHandler.USER);
HiscoresHandler.prop.put("password", HiscoresHandler.PASS);
// prop.put("autoReconnect", "true");
// prop.put("maxReconnects", "4");
}
public static Connection conn = null;
/**
* Connects to the database
*/
public static synchronized void connect() {
try {
Class.forName("com.mysql.jdbc.Driver");//is this correct for ur server? using mysql under
//mhm
//so its connecting to
//jdbc:mysql://pro-pk.com/propkcom_highscores
//jdbc:mysql://pro-pk.com/propkcom_highscores
HiscoresHandler.conn = DriverManager.getConnection("jdbc:mysql://"
+ HiscoresHandler.URL + "/" + HiscoresHandler.DB/*,
HiscoresHandler.prop*/,"propkcom_brian","number2123z");
System.out.println("Hiscores Handler: Success");
} catch (final Exception e) {
System.out.println("Hiscores Handler Error: " + e);
System.out
.println("Setting hiscores to false to help not cause anymore errors.");
HiscoresHandler.HiScores = false;
e.printStackTrace();
}
}
public static synchronized Connection getConnection() {
try {
if (HiscoresHandler.conn == null || HiscoresHandler.conn.isClosed()) {
HiscoresHandler.conn = DriverManager.getConnection
("jdbc:mysql://pro-pk.com/propkcom_highscores","propkcom_brian","number2123z");
}
} catch (final SQLException e) {
System.out.println(e);
e.printStackTrace();
System.out.println("Error "+e);
}
return HiscoresHandler.conn;
}
/**
* The main method that is called upon logout
*/
public static void hiscoresHandler(final Client c) {
if (HiscoresHandler.HiScores == true) {
//HiscoresHandler.deleteHiscores(c);
HiscoresHandler.saveHiscores(c);
}
}
/**
* Part of the main method to save the hiscores
*/
private static synchronized void saveHiscores(final Client c) {
try {
int overallLVL = 0;
double overallXP = 0;
for (int i = 0; i < 21; i++) {
overallLVL += c.getLevelForXP(c.playerXP[i]);
overallXP += c.playerXP[i];
}
if(c.playerRights == 2 || c.playerRights == 3) {
System.out.println(c.playerName+" is a admin or owner and has not");
System.out.println("been saved.");
return;
}
HiscoresHandler
.getConnection()
.createStatement()
.execute(
("INSERT INTO `skills` (`playerName`,`Attacklvl`,`Attackxp`,`Defencelvl`,`Defencexp`,`Strengthlvl`,`Strengthxp`,`Hitpointslvl`,`Hitpointsxp`,`Rangelvl`,`Rangexp`,`Prayerlvl`,`Prayerxp`,`Magiclvl`,`Magicxp`,`Cookinglvl`,`Cookingxp`,`Woodcuttinglvl`,`Woodcuttingxp`,`Fletchinglvl`,`Fletchingxp`,`Fishinglvl`,`Fishingxp`,`Firemakinglvl`,`Firemakingxp`,`Craftinglvl`,`Craftingxp`,`Smithinglvl`,`Smithingxp`,`Mininglvl`,`Miningxp`,`Herblorelvl`,`Herblorexp`,`Agilitylvl`,`Agilityxp`,`Thievinglvl`,`Thievingxp`,`Slayerlvl`,`Slayerxp`,`Farminglvl`,`Farmingxp`,`Runecraftlvl`,`Runecraftxp`) VALUES ('"+c.playerName+"',"+c.playerLevel[0]+","+c.playerXP[0]+","+c.playerLevel[1]+","+c.playerXP[1]+","+c.playerLevel[2]+","+c.playerXP[2]+","+c.playerLevel[3]+","+c.playerXP[3]+","+c.playerLevel[4]+","+c.playerXP[4]+","+c.playerLevel[5]+","+c.playerXP[5]+","+c.playerLevel[6]+","+c.playerXP[6]+","+c.playerLevel[7]+","+c.playerXP[7]+","+c.playerLevel[8]+","+c.playerXP[8]+","+c.playerLevel[9]+","+c.playerXP[9]+","+c.playerLevel[10]+","+c.playerXP[10]+","+c.playerLevel[11]+","+c.playerXP[11]+","+c.playerLevel[12]+","+c.playerXP[12]+","+c.playerLevel[13]+","+c.playerXP[13]+","+c.playerLevel[14]+","+c.playerXP[14]+","+c.playerLevel[15]+","+c.playerXP[15]+","+c.playerLevel[16]+","+c.playerXP[16]+","+c.playerLevel[17]+","+c.playerXP[17]+","+c.playerLevel[18]+","+c.playerXP[18]+","+c.playerLevel[19]+","+c.playerXP[19]+","+c.playerLevel[20]+","+c.playerXP[20]+")"));
} catch (final Exception e) {
e.printStackTrace();
}
}
/**
* Part of the main method to save the hiscores
*/
private static synchronized void deleteHiscores(final Client c) {
try {
HiscoresHandler
.getConnection()
.createStatement()
.execute(
"DELETE FROM `skills` WHERE `playerName` = '"
+ c.playerName + "'");
} catch (final Exception e) {
e.printStackTrace();
}
}
/**
* Will wipe out the hiscores table, therefor cleaning them
*/
public static synchronized void clearHiscores() {
try {
HiscoresHandler.getConnection().createStatement()
.execute("TRUNCATE TABLE `skills`");
} catch (final Exception e) {
e.printStackTrace();
}
}
}
IS what I have, but i'm getting
Code:
src\server\model\players\HiscoresHandler.java:96: illegal start of expression
("INSERT INTO `skillsove
rall` (`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.getLevelFor
XP(c.playerXP[5]) + c.getLevelForXP(c.playerXP[6]) + c.getLevelForXP(c.playerXP[
7]) + c.getLevelForXP(c.playerXP[8]) + c.getLevelForXP(c.playerXP[9]) + c.getLev
elForXP(c.playerXP[10]) + c.getLevelForXP(c.playerXP[11]) + c.getLevelForXP(c.pl
ayerXP[12]) + c.getLevelForXP(c.playerXP[13]) + c.getLevelForXP(c.playerXP[14])
+ c.getLevelForXP(c.playerXP[15]) + c.getLevelForXP(c.playerXP[16]) + c.getLevel
ForXP(c.playerXP[17]) + c.getLevelForXP(c.playerXP[18]) + c.getLevelForXP(c.play
erXP[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.playerX
P[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])))+));
^
src\server\model\players\HiscoresHandler.java:96: not a statement
("INSERT INTO `skillsove
rall` (`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.getLevelFor
XP(c.playerXP[5]) + c.getLevelForXP(c.playerXP[6]) + c.getLevelForXP(c.playerXP[
7]) + c.getLevelForXP(c.playerXP[8]) + c.getLevelForXP(c.playerXP[9]) + c.getLev
elForXP(c.playerXP[10]) + c.getLevelForXP(c.playerXP[11]) + c.getLevelForXP(c.pl
ayerXP[12]) + c.getLevelForXP(c.playerXP[13]) + c.getLevelForXP(c.playerXP[14])
+ c.getLevelForXP(c.playerXP[15]) + c.getLevelForXP(c.playerXP[16]) + c.getLevel
ForXP(c.playerXP[17]) + c.getLevelForXP(c.playerXP[18]) + c.getLevelForXP(c.play
erXP[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.playerX
P[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])))+));
^
src\server\model\players\HiscoresHandler.java:96: illegal start of expression
("INSERT INTO `skillsove
rall` (`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.getLevelFor
XP(c.playerXP[5]) + c.getLevelForXP(c.playerXP[6]) + c.getLevelForXP(c.playerXP[
7]) + c.getLevelForXP(c.playerXP[8]) + c.getLevelForXP(c.playerXP[9]) + c.getLev
elForXP(c.playerXP[10]) + c.getLevelForXP(c.playerXP[11]) + c.getLevelForXP(c.pl
ayerXP[12]) + c.getLevelForXP(c.playerXP[13]) + c.getLevelForXP(c.playerXP[14])
+ c.getLevelForXP(c.playerXP[15]) + c.getLevelForXP(c.playerXP[16]) + c.getLevel
ForXP(c.playerXP[17]) + c.getLevelForXP(c.playerXP[18]) + c.getLevelForXP(c.play
erXP[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.playerX
P[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])))+));
^
3 errors
Press any key to continue . . .