Thread: HighScores via MySQL and online viewing

Page 1 of 6 123 ... LastLast
Results 1 to 10 of 55
  1. #1 HighScores via MySQL and online viewing 
    Registered Member
    Join Date
    Nov 2007
    Posts
    48
    Thanks given
    0
    Thanks received
    0
    Rep Power
    5
    Credits: 99.9% to Segadora, I am just posting the java file which he did not include (the one which was posted did not work)

    First follow Segadora's tut here:

    http://www.rune-server.org/f348/php-...e-t111526.html

    EDIT: Remove ID to get it to show a player's scores when you click their name.

    Then create a new file called highscore.java and put this in it:

    [code]
    Yay! i configured the java file to make it save highscores to the MySQL with no errors, it's realy not hard, I have absolutely no MySQL knowledge at all, i just googled and looked at other tuts, anyway here it is

    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
    Code:
    public void run()
    Code:
    		highscore.createCon();
    and this to
    Code:
    public void logout()
    Code:
    		highscore.save(this);
    and this to the top of you client.java file
    Code:
    import.java.sql.*;
    Anyway, thank Segadora for this! He owns it and stuff.
    Reply With Quote  
     

  2. #2  
    Registered Member
    doobie's Avatar
    Join Date
    Oct 2008
    Age
    29
    Posts
    637
    Thanks given
    12
    Thanks received
    14
    Rep Power
    200
    Wow coolio and nice


    Reply With Quote  
     

  3. #3  
    Renown Programmer

    Sean's Avatar
    Join Date
    May 2007
    Age
    32
    Posts
    2,757
    Thanks given
    264
    Thanks received
    1,090
    Rep Power
    4393
    i write that ugly java sql saver along time ago, almost year ago lol UGLYYYYYYYY
    Reply With Quote  
     

  4. #4  
    Flamefire
    Guest
    Does anyone have the com folder with the other files needed, and the drivemanager file?
    Reply With Quote  
     

  5. #5  
    ( ͡° ͜ʖ ͡°)
    Edgeville's Avatar
    Join Date
    Nov 2007
    Posts
    2,453
    Thanks given
    80
    Thanks received
    428
    Rep Power
    2589
    Sweet, Thanks

    Attached image
    Reply With Quote  
     

  6. #6  
    Totally Pro

    Fubergen's Avatar
    Join Date
    Nov 2007
    Age
    31
    Posts
    1,026
    Thanks given
    24
    Thanks received
    14
    Rep Power
    310
    i need sql import thing



    advertising without affiliate is rude
    Reply With Quote  
     

  7. #7  
    Respected Member


    Join Date
    Jan 2009
    Posts
    5,743
    Thanks given
    1,162
    Thanks received
    3,603
    Rep Power
    5000
    One problem with this, a characters ID changes alot on servers, so everytime it changes you would need to change your signature maybe someone could fix this?
    Reply With Quote  
     

  8. #8  
    Ben
    Guest
    Quote Originally Posted by Fubergen View Post
    i need sql import thing
    import.java.sql.*;

    Is that what you mean?
    Reply With Quote  
     

  9. #9  
    Registered Member
    Join Date
    Nov 2007
    Posts
    48
    Thanks given
    0
    Thanks received
    0
    Rep Power
    5
    i'll atacth the file
    Reply With Quote  
     

  10. #10  
    Old School Member

    Join Date
    Feb 2008
    Age
    29
    Posts
    2,163
    Thanks given
    372
    Thanks received
    40
    Rep Power
    687
    Quote Originally Posted by Songoty View Post
    import.java.sql.*;

    Is that what you mean?
    yes it was deeerrrrrrrrrrrrrr

    Quote Originally Posted by Colby View Post
    Rofl, moron. They're ALL going to be null idiot. This is such complete bullshit, it makes me want to strangle you.
    Reply With Quote  
     

Page 1 of 6 123 ... LastLast

Thread Information
Users Browsing this Thread

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


User Tag List

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •