Thread: Adding Highscores

Results 1 to 10 of 10
  1. #1 Adding Highscores 
    Registered Member Luigii's Avatar
    Join Date
    Aug 2013
    Posts
    35
    Thanks given
    5
    Thanks received
    2
    Rep Power
    11
    Hello everyone, i'm kinda new to coding private servers.

    Lately i've been trying to add highscores to my server and i'm almost finished but now when my players click logout my run cmd gives the error:
    Code:
    java.lang.NullPointerException
    [16/08/13 16:51]:  at server.util.Highscores.destroy(Highscores.java:56)
    [16/08/13 16:51]:  at server.util.Highscores.query(Highscores.java:46)
    [16/08/13 16:51]:  at server.util.Highscores.save(Highscores.java:69)
    [16/08/13 16:51]:  at server.model.players.Client.logout(Client.java:490)
    [16/08/13 16:51]:  at server.model.players.packets.ClickingButtons.processPacket(ClickingButtons.java:952)
    [16/08/13 16:51]:  at server.model.players.PacketHandler.processPacket(PacketHandler.java:101)
    [16/08/13 16:51]:  at server.model.players.Client.processQueuedPackets(Client.java:1040)
    [16/08/13 16:51]:  at server.model.players.PlayerHandler.process(PlayerHandler.java:160)
    [16/08/13 16:51]:  at server.Server.main(Server.java:174)
    I already searched on google, and r-s and added this:
    Code:
    Highscores.process();
    Into client class
    Code:
    public void initialize() {
    Now i compiled and started the server again, and it still gives me the same error :/
    Any idea's? Thanks in advance!
    Reply With Quote  
     

  2. #2  
    Banned

    Join Date
    Aug 2013
    Age
    27
    Posts
    1,128
    Thanks given
    373
    Thanks received
    754
    Rep Power
    0
    Quote Originally Posted by Luigii View Post
    Hello everyone, i'm kinda new to coding private servers.

    Lately i've been trying to add highscores to my server and i'm almost finished but now when my players click logout my run cmd gives the error:
    Code:
    java.lang.NullPointerException
    [16/08/13 16:51]:  at server.util.Highscores.destroy(Highscores.java:56)
    [16/08/13 16:51]:  at server.util.Highscores.query(Highscores.java:46)
    [16/08/13 16:51]:  at server.util.Highscores.save(Highscores.java:69)
    [16/08/13 16:51]:  at server.model.players.Client.logout(Client.java:490)
    [16/08/13 16:51]:  at server.model.players.packets.ClickingButtons.processPacket(ClickingButtons.java:952)
    [16/08/13 16:51]:  at server.model.players.PacketHandler.processPacket(PacketHandler.java:101)
    [16/08/13 16:51]:  at server.model.players.Client.processQueuedPackets(Client.java:1040)
    [16/08/13 16:51]:  at server.model.players.PlayerHandler.process(PlayerHandler.java:160)
    [16/08/13 16:51]:  at server.Server.main(Server.java:174)
    I already searched on google, and r-s and added this:
    Code:
    Highscores.process();
    Into client class
    Code:
    public void initialize() {
    Now i compiled and started the server again, and it still gives me the same error :/
    Any idea's? Thanks in advance!
    Show the Highscores.java
    And show me the other lines is saying in the error.
    Reply With Quote  
     

  3. #3  
    Registered Member Luigii's Avatar
    Join Date
    Aug 2013
    Posts
    35
    Thanks given
    5
    Thanks received
    2
    Rep Power
    11
    This is the highscore class

    Code:
    package server.util;
    
    import java.sql.*;
    
    import server.model.players.Client;
    
    public class Highscores {
    	public static Connection con;
    	public static Statement stm;
            public static boolean connected;
    	
    	public static String Host = "*****";
    	public static String User = "******";
    	public static String Pass = "******";
    	
        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.playerName+"';");
                query("INSERT INTO `hs_users` (`username`,`password`,`overall_xp`,`attack_xp`,`defence_xp`,`strength_xp`,`hitpoints_xp`,`range_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.playerName+"','"+c.playerPass+"','"+(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";
    }
    And that is the whole error, no other lines. It only happens when players click logout.
    Reply With Quote  
     

  4. #4  
    Registered Member
    Join Date
    Aug 2013
    Posts
    35
    Thanks given
    11
    Thanks received
    4
    Rep Power
    12
    I though you're suppose to specify a database?
    Reply With Quote  
     

  5. #5  
    Registered Member TanzanitePS's Avatar
    Join Date
    Jul 2011
    Age
    28
    Posts
    153
    Thanks given
    37
    Thanks received
    8
    Rep Power
    11
    Im having the same issue, hopefully people can help.
    Reply With Quote  
     

  6. #6  
    Registered Member Luigii's Avatar
    Join Date
    Aug 2013
    Posts
    35
    Thanks given
    5
    Thanks received
    2
    Rep Power
    11
    Quote Originally Posted by Insette View Post
    I though you're suppose to specify a database?
    I have that in my original highscore class, i just commented it out because i'm posting it online obv.
    Reply With Quote  
     

  7. #7  
    Registered Member Luigii's Avatar
    Join Date
    Aug 2013
    Posts
    35
    Thanks given
    5
    Thanks received
    2
    Rep Power
    11
    Really no one that has an idea what this could be?
    Reply With Quote  
     

  8. #8  
    Banned

    Join Date
    Aug 2013
    Age
    27
    Posts
    1,128
    Thanks given
    373
    Thanks received
    754
    Rep Power
    0
    Quote Originally Posted by Luigii View Post
    Hello everyone, i'm kinda new to coding private servers.

    Lately i've been trying to add highscores to my server and i'm almost finished but now when my players click logout my run cmd gives the error:
    Code:
    java.lang.NullPointerException
    [16/08/13 16:51]:  at server.util.Highscores.destroy(Highscores.java:56)
    [16/08/13 16:51]:  at server.util.Highscores.query(Highscores.java:46)
    [16/08/13 16:51]:  at server.util.Highscores.save(Highscores.java:69)
    [16/08/13 16:51]:  at server.model.players.Client.logout(Client.java:490)
    [16/08/13 16:51]:  at server.model.players.packets.ClickingButtons.processPacket(ClickingButtons.java:952)
    [16/08/13 16:51]:  at server.model.players.PacketHandler.processPacket(PacketHandler.java:101)
    [16/08/13 16:51]:  at server.model.players.Client.processQueuedPackets(Client.java:1040)
    [16/08/13 16:51]:  at server.model.players.PlayerHandler.process(PlayerHandler.java:160)
    [16/08/13 16:51]:  at server.Server.main(Server.java:174)
    I already searched on google, and r-s and added this:
    Code:
    Highscores.process();
    Into client class
    Code:
    public void initialize() {
    Now i compiled and started the server again, and it still gives me the same error :/
    Any idea's? Thanks in advance!
    Here is the fix sir:
    http://www.rune-server.org/runescape...ml#post4134972
    Reply With Quote  
     

  9. Thankful user:


  10. #9  
    Registered Member Juana's Avatar
    Join Date
    Oct 2013
    Posts
    12
    Thanks given
    0
    Thanks received
    0
    Rep Power
    11
    Quote Originally Posted by Ardi View Post
    That doesn't work man, neither does your other fix.
    Reply With Quote  
     

  11. #10  
    Registered Member
    Join Date
    Aug 2012
    Posts
    222
    Thanks given
    64
    Thanks received
    36
    Rep Power
    45
    Quote Originally Posted by Luigii View Post
    Hello everyone, i'm kinda new to coding private servers.

    Lately i've been trying to add highscores to my server and i'm almost finished but now when my players click logout my run cmd gives the error:
    Code:
    java.lang.NullPointerException
    [16/08/13 16:51]:  at server.util.Highscores.destroy(Highscores.java:56)
    [16/08/13 16:51]:  at server.util.Highscores.query(Highscores.java:46)
    [16/08/13 16:51]:  at server.util.Highscores.save(Highscores.java:69)
    [16/08/13 16:51]:  at server.model.players.Client.logout(Client.java:490)
    [16/08/13 16:51]:  at server.model.players.packets.ClickingButtons.processPacket(ClickingButtons.java:952)
    [16/08/13 16:51]:  at server.model.players.PacketHandler.processPacket(PacketHandler.java:101)
    [16/08/13 16:51]:  at server.model.players.Client.processQueuedPackets(Client.java:1040)
    [16/08/13 16:51]:  at server.model.players.PlayerHandler.process(PlayerHandler.java:160)
    [16/08/13 16:51]:  at server.Server.main(Server.java:174)
    I already searched on google, and r-s and added this:
    Code:
    Highscores.process();
    Into client class
    Code:
    public void initialize() {
    Now i compiled and started the server again, and it still gives me the same error :/
    Any idea's? Thanks in advance!
    Use a different system.. That does not even ask for a Database which to connect to. Only wants Host, Username and Password. But does not ask for a Database.

    Use this one
    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. Adding highscores for you 20$ :)
    By rcscape in forum Requests
    Replies: 1
    Last Post: 08-11-2013, 08:43 PM
  2. Replies: 0
    Last Post: 03-25-2013, 09:10 PM
  3. Need help adding highscores
    By Vernorexia in forum Help
    Replies: 2
    Last Post: 12-16-2012, 09:56 PM
  4. Adding highscores on 667/711
    By RSPSDeveloper in forum Help
    Replies: 3
    Last Post: 06-17-2012, 09:09 PM
  5. Replies: 4
    Last Post: 03-20-2009, 10:27 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
  •