Thread: highscores not saving, nullpointerexeception.

Results 1 to 4 of 4
  1. #1 highscores not saving, nullpointerexeception. 
    Banned

    Join Date
    Jul 2010
    Age
    34
    Posts
    773
    Thanks given
    39
    Thanks received
    83
    Rep Power
    0
    [19/04/2013 02:06 PM]: Connected to MySQL Database!
    [19/04/2013 02:06 PM]: Initializing Epicurus World 1.
    [19/04/2013 02:06 PM]: Epicurus is listening on port: 43594
    [19/04/2013 02:06 PM]: Developer mode: true
    [19/04/2013 02:06 PM]: Thread started for relay server, connecting shortly...
    [19/04/2013 02:06 PM]: Connection to relay server established.
    [19/04/2013 02:06 PM]: 'Legacy' has logged in. (xxx.xxx.xxx.xxx)
    [19/04/2013 02:06 PM]: java.lang.NullPointerException
    [19/04/2013 02:06 PM]: at epicurus.model.players.Highscores.destroy(Highscor es.java:59)
    [19/04/2013 02:06 PM]: at epicurus.model.players.Highscores.query(Highscores .java:49)
    [19/04/2013 02:06 PM]: at epicurus.model.players.Highscores.save(Highscores. java:72)
    [19/04/2013 02:06 PM]: at epicurus.model.players.Client.logout(Client.java:4 68)
    [19/04/2013 02:06 PM]: at epicurus.model.players.packet.packets.ClickingButt ons.processPacket(ClickingButtons.java:1193)
    [19/04/2013 02:06 PM]: at epicurus.model.players.packet.PacketHandler.proces sPacket(PacketHandler.java:149)
    [19/04/2013 02:06 PM]: at epicurus.model.players.Client.processQueuedPackets (Client.java:1121)
    [19/04/2013 02:06 PM]: at epicurus.model.players.PlayerHandler.process(Playe rHandler.java:108)
    [19/04/2013 02:06 PM]: at epicurus.Epicurus.main(Epicurus.java:163)
    [19/04/2013 02:06 PM]: 'Legacy' has logged out.

    Here's my Hiscores Class.

    Code:
    package epicurus.model.players;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class Highscores {
    
    	public static Connection con;
    	public static Statement stm;
            public static boolean connected;
    	
    	public static String Host = "jdbc:mysql://xxx.xxx.xxx.xxx/database";
    	public static String User = "username";
    	public static String Pass = "password";
    	
        public static void process() {
            try
            {
                Class.forName(Driver).newInstance();
    	    Connection con = DriverManager.getConnection(Host, User, Pass);
    	    stm = con.createStatement();
                connected = true;
            }
            catch(Exception e)
            {
                connected = false;
                e.printStackTrace();
            }
        }
    
        public static ResultSet query(String s)
            throws SQLException
        {
            if(s.toLowerCase().startsWith("select"))
            {
                ResultSet resultset = stm.executeQuery(s);
                return resultset;
            }
            try
            {
                stm.executeUpdate(s);
                return null;
            }
            catch(Exception e)
            {
                destroy();
            }
            process();
            return null;
        }
    
        public static void destroy() {
            try
            {
                stm.close();
                con.close();
                connected = false;
            }
            catch(Exception e)
            {
                e.printStackTrace();
            }
        }
    
        public static boolean save(Client c) {
            try
            {
                query("DELETE FROM `hs_users` WHERE username = '"+c.username+"';");
                query("INSERT INTO `hs_users` (`username`,`password`,`overall_xp`,`attack_xp`,`defence_xp`,`strength_xp`,`constitution_xp`,`ranged_xp`,`prayer_xp`,`magic_xp`,`cooking_xp`,`woodcutting_xp`,`fletching_xp`,`fishing_xp`,`firemaking_xp`,`crafting_xp`,`smithing_xp`,`mining_xp`,`herblore_xp`,`agility_xp`,`thieving_xp`,`slayer_xp`,`farming_xp`,`runecraft_xp`) VALUES ('"+c.username+"','"+c.password+"','"+(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])+"',"+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;
        }
    	public static String Driver = "com.mysql.jdbc.Driver";
    }
    Reply With Quote  
     

  2. #2  
    Registered Member remcowp's Avatar
    Join Date
    Jan 2011
    Posts
    651
    Thanks given
    57
    Thanks received
    37
    Rep Power
    12
    Did u add it correctly in SQL.java?
    Change your details there to, i forgot that to. I also deleted my Highscores again xD
    Reply With Quote  
     

  3. #3  
    Banned

    Join Date
    Jul 2010
    Age
    34
    Posts
    773
    Thanks given
    39
    Thanks received
    83
    Rep Power
    0
    i got everything setup right.
    Reply With Quote  
     

  4. #4  
    Registered Member
    Markian's Avatar
    Join Date
    Apr 2009
    Posts
    613
    Thanks given
    17
    Thanks received
    26
    Rep Power
    373
    I believe it's because it's not pointing to anything. You can try adding this statement in save above the try:

    Code:
    		if (c == null)
    			return;
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. [urgent]player files not saving![/urgent]
    By silabgarza in forum Help
    Replies: 6
    Last Post: 06-25-2011, 11:40 AM
  2. help on highscores not saving
    By Zᴀᴄʜ in forum Help
    Replies: 3
    Last Post: 06-19-2010, 12:43 AM
  3. Emulous Could not save
    By m2ti in forum Help
    Replies: 1
    Last Post: 03-25-2009, 09:40 PM
  4. Continuos errors and not saving
    By si force in forum Help
    Replies: 2
    Last Post: 10-27-2008, 08:31 AM
  5. Replies: 3
    Last Post: 09-14-2008, 07:12 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •