Thread: [PI] Highscores What do i do now?

Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1 [PI] Highscores What do i do now? 
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    Hello so i got all my Highscores working but now idk what to do so it makes people on the highscores and ideas please help me

    Skype : owner-of-divinescape

    If u want you can help me via Teamviewer pm me

    or just comment please i really need help

    SQL :
    Code:
    package server.util;
    import java.sql.*;
    import java.security.MessageDigest;
    import server.model.players.Client;
    public class SQL {
    	
    	
    	public static Connection con = null;
    	public static Statement stmt;
    	public static boolean connectionMade;
    	public static void createConnection() {
    		try {
    			Class.forName("com.mysql.jdbc.Driver").newInstance();
    			con = DriverManager.getConnection("jdbc:mysql://localhost/highscores","root","PASS NOT POSTED");
    			stmt = con.createStatement();
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    	}
    	public static ResultSet query(String s) throws SQLException {
    		try {
    			if (s.toLowerCase().startsWith("select")) {
    				ResultSet rs = stmt.executeQuery(s);
    				return rs;
    			} else {
    				stmt.executeUpdate(s);
    			}
    			return null;
    		} catch (Exception e) {
    			destroyConnection();
    			createConnection();
    			e.printStackTrace();
    		}
    		return null;
    	}
    
    	public static void destroyConnection() {
    		try {
    			stmt.close();
    			con.close();
    			connectionMade = false;
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    	}
    
    	public static boolean saveHighScore(Client clientToSave) {
    		try {
    			query("DELETE FROM `skills` WHERE playerName = '"+clientToSave.playerName+"';");
    			query("DELETE FROM `skillsoverall` WHERE playerName = '"+clientToSave.playerName+"';");
    			query("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 ('"+clientToSave.playerName+"',"+clientToSave.playerLevel[0]+","+clientToSave.playerXP[0]+","+clientToSave.playerLevel[1]+","+clientToSave.playerXP[1]+","+clientToSave.playerLevel[2]+","+clientToSave.playerXP[2]+","+clientToSave.playerLevel[3]+","+clientToSave.playerXP[3]+","+clientToSave.playerLevel[4]+","+clientToSave.playerXP[4]+","+clientToSave.playerLevel[5]+","+clientToSave.playerXP[5]+","+clientToSave.playerLevel[6]+","+clientToSave.playerXP[6]+","+clientToSave.playerLevel[7]+","+clientToSave.playerXP[7]+","+clientToSave.playerLevel[8]+","+clientToSave.playerXP[8]+","+clientToSave.playerLevel[9]+","+clientToSave.playerXP[9]+","+clientToSave.playerLevel[10]+","+clientToSave.playerXP[10]+","+clientToSave.playerLevel[11]+","+clientToSave.playerXP[11]+","+clientToSave.playerLevel[12]+","+clientToSave.playerXP[12]+","+clientToSave.playerLevel[13]+","+clientToSave.playerXP[13]+","+clientToSave.playerLevel[14]+","+clientToSave.playerXP[14]+","+clientToSave.playerLevel[15]+","+clientToSave.playerXP[15]+","+clientToSave.playerLevel[16]+","+clientToSave.playerXP[16]+","+clientToSave.playerLevel[17]+","+clientToSave.playerXP[17]+","+clientToSave.playerLevel[18]+","+clientToSave.playerXP[18]+","+clientToSave.playerLevel[19]+","+clientToSave.playerXP[19]+","+clientToSave.playerLevel[20]+","+clientToSave.playerXP[20]+");");
    			query("INSERT INTO `skillsoverall` (`playerName`,`lvl`,`xp`) VALUES ('"+clientToSave.playerName+"',"+(clientToSave.getLevelForXP(clientToSave.playerXP[0]) + clientToSave.getLevelForXP(clientToSave.playerXP[1]) + clientToSave.getLevelForXP(clientToSave.playerXP[2]) + clientToSave.getLevelForXP(clientToSave.playerXP[3]) + clientToSave.getLevelForXP(clientToSave.playerXP[4]) + clientToSave.getLevelForXP(clientToSave.playerXP[5]) + clientToSave.getLevelForXP(clientToSave.playerXP[6]) + clientToSave.getLevelForXP(clientToSave.playerXP[7]) + clientToSave.getLevelForXP(clientToSave.playerXP[8]) + clientToSave.getLevelForXP(clientToSave.playerXP[9]) + clientToSave.getLevelForXP(clientToSave.playerXP[10]) + clientToSave.getLevelForXP(clientToSave.playerXP[11]) + clientToSave.getLevelForXP(clientToSave.playerXP[12]) + clientToSave.getLevelForXP(clientToSave.playerXP[13]) + clientToSave.getLevelForXP(clientToSave.playerXP[14]) + clientToSave.getLevelForXP(clientToSave.playerXP[15]) + clientToSave.getLevelForXP(clientToSave.playerXP[16]) + clientToSave.getLevelForXP(clientToSave.playerXP[17]) + clientToSave.getLevelForXP(clientToSave.playerXP[18]) + clientToSave.getLevelForXP(clientToSave.playerXP[19]) + clientToSave.getLevelForXP(clientToSave.playerXP[20]))+","+((clientToSave.playerXP[0]) + (clientToSave.playerXP[1]) + (clientToSave.playerXP[2]) + (clientToSave.playerXP[3]) + (clientToSave.playerXP[4]) + (clientToSave.playerXP[5]) + (clientToSave.playerXP[6]) + (clientToSave.playerXP[7]) + (clientToSave.playerXP[8]) + (clientToSave.playerXP[9]) + (clientToSave.playerXP[10]) + (clientToSave.playerXP[11]) + (clientToSave.playerXP[12]) + (clientToSave.playerXP[13]) + (clientToSave.playerXP[14]) + (clientToSave.playerXP[15]) + (clientToSave.playerXP[16]) + (clientToSave.playerXP[17]) + (clientToSave.playerXP[18]) + (clientToSave.playerXP[19]) + (clientToSave.playerXP[20]))+");");
    		} catch (Exception e) {
    			e.printStackTrace();
    			return false;
    		}
    		return true;
    	}
    }
    Log out :

    public void logout() { saveHighScores(this);
    Reply With Quote  
     

  2. #2  
    Extreme Donator


    Join Date
    Oct 2006
    Posts
    1,370
    Thanks given
    64
    Thanks received
    197
    Rep Power
    426
    You need to send SQL queries from your server for which you need to establish a database connection first, and then you can have it send queries which send the levels of the player to the database.


    ~flow@hacking . rs
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    Could u help me with that please ?
    Reply With Quote  
     

  4. #4  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    Anyone ?
    Reply With Quote  
     

  5. #5  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    still need help ?? please anyone help me at all?
    Reply With Quote  
     

  6. #6  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    I Still need help anyone ?? Please
    Reply With Quote  
     

  7. #7  
    Donator


    Join Date
    Jul 2011
    Posts
    921
    Thanks given
    199
    Thanks received
    178
    Rep Power
    189
    Isn't the tutorial easy enough ?
    Reply With Quote  
     

  8. #8  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    Quote Originally Posted by IxInDrEkxI View Post
    Isn't the tutorial easy enough ?
    I Was Looking for someone who can help and TBH That isnt helping and the tut i used dosnt have this bit in
    Reply With Quote  
     

  9. #9  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    SOMEONE PLEASE HELP
    Reply With Quote  
     

  10. #10  
    Registered Member
    Join Date
    Jan 2012
    Posts
    178
    Thanks given
    1
    Thanks received
    1
    Rep Power
    32
    Added Pics
    Reply With Quote  
     

Page 1 of 2 12 LastLast

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. Highscores Help
    By Humor in forum Help
    Replies: 6
    Last Post: 06-29-2011, 10:20 AM
  2. Help with highscores.
    By susurik in forum Application Development
    Replies: 1
    Last Post: 03-31-2011, 03:28 PM
  3. HighScores Help Please?
    By Insane in forum Help
    Replies: 4
    Last Post: 11-25-2010, 06:39 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
  •