Search the Community

Hello, so I created website that offers free highscores hosting service. Creating highscores takes no more then 4 minutes! So let me tell you what to do First go to http://rsps-scores.com and click Create highscores button Then fill registration form and click Sign up http://image.prntscr.com/image/25f581e1896842a495d590fd4a163438.png Website will then take you to your newly created dashboard. In dashboard you can add any URL to your highscore page or add different game modes by completing these forms http://image.prntscr.com/image/2b51bdd5600e433b9ea3632ac43bb767.png You can also change your highscores theme (theme examples will be at the end of the thread) I have provided two examples on how to install highscores server sided, I will explain how to install on ruse based servers in this thread For first you have to create new class in com.ruse called HighscoresHandler with these contents: package com.ruse; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import com.ruse.model.Skill; import com.ruse.world.entity.impl.player.Player; import com.mysql.jdbc.Statement; public class HighscoresHandler implements Runnable{ /** * Secret key */ final static String secret = ""; /** * Username that is used for mysql connection */ final static String user = ""; private Player player; public HighscoresHandler(Player player) { this.player = player; } /** * Function that handles everything, it inserts or updates * user data in database */ @Override public void run() { /** * Players username */ final String username = player.getUsername(); /** * Represents game mode * If you want to set game modes do this: */ final int gameMode = 0; /** * Represents overall xp */ final long overallXp = player.getSkillManager().getTotalExp(); /** * Represents attack xp */ final long attackXp = player.getSkillManager().getExperience(Skill.ATTACK); /** * Represents defence xp */ final long defenceXp = player.getSkillManager().getExperience(Skill.DEFENCE); /** * Represents strength xp */ final long strengthXp = player.getSkillManager().getExperience(Skill.STRENGTH); /** * Represents constitution xp */ final long constitutionXp = player.getSkillManager().getExperience(Skill.CONSTITUTION); /** * Represents ranged xp */ final long rangedXp = player.getSkillManager().getExperience(Skill.RANGED); /** * Represents prayer xp */ final long prayerXp = player.getSkillManager().getExperience(Skill.PRAYER); /** * Represents magic xp */ final long magicXp = player.getSkillManager().getExperience(Skill.MAGIC); /** * Represents cooking xp */ final long cookingXp = player.getSkillManager().getExperience(Skill.COOKING); /** * Represents woodcutting xp */ final long woodcuttingXp = player.getSkillManager().getExperience(Skill.WOODCUTTING); /** * Represents fletching xp */ final long fletchingXp = player.getSkillManager().getExperience(Skill.FLETCHING); /** * Represents fishing xp */ final long fishingXp = player.getSkillManager().getExperience(Skill.FISHING); /** * Represents firemaking xp */ final long firemakingXp = player.getSkillManager().getExperience(Skill.FIREMAKING); /** * Represents crafting xp */ final long craftingXp = player.getSkillManager().getExperience(Skill.CRAFTING); /** * Represents smithing xp */ final long smithingXp = player.getSkillManager().getExperience(Skill.SMITHING); /** * Represents mining xp */ final long miningXp = player.getSkillManager().getExperience(Skill.MINING); /** * Represents herblore xp */ final long herbloreXp = player.getSkillManager().getExperience(Skill.HERBLORE); /** * Represents agility xp */ final long agilityXp = player.getSkillManager().getExperience(Skill.AGILITY); /** * Represents thieving xp */ final long thievingXp = player.getSkillManager().getExperience(Skill.THIEVING); /** * Represents slayer xp */ final long slayerXp = player.getSkillManager().getExperience(Skill.SLAYER); /** * Represents farming xp */ final long farmingXp = player.getSkillManager().getExperience(Skill.FARMING); /** * Represents runecrafting xp */ final long runecraftingXp = player.getSkillManager().getExperience(Skill.RUNECRAFTING); /** * Represents hunter xp */ final long hunterXp = player.getSkillManager().getExperience(Skill.HUNTER); /** * Represents construction xp */ final long constructionXp = player.getSkillManager().getExperience(Skill.CONSTRUCTION); /** * Creates new instance of jdbc driver * if that driver exists */ try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (InstantiationException | IllegalAccessException | ClassNotFoundException e1) { e1.printStackTrace(); } /** * Sets Connection variable to null */ Connection connection = null; /** * Sets Statement variable to null */ Statement stmt = null; /** * Attempts connecting to database */ try { connection = DriverManager.getConnection("jdbc:mysql://198.211.123.88:3306/admin_scores_data", user, secret); } catch (SQLException e) { e.printStackTrace(); return; } /** * Checks if connection isnt null */ if (connection != null) { try { stmt = (Statement) connection.createStatement(); ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS count FROM `"+user+"_scores` WHERE username='" +username+ "'"); if(rs.next()) { if(rs.getInt("count") > 0) { stmt.executeUpdate("UPDATE `"+user+"_scores` SET overall_xp = '"+overallXp+"', attack_xp = '"+attackXp+"', defence_xp = '"+defenceXp+"', strength_xp = '"+strengthXp+"', constitution_xp = '"+constitutionXp+"', ranged_xp = '"+rangedXp+"', prayer_xp = '"+prayerXp+"', magic_xp = '"+magicXp+"', cooking_xp = '"+cookingXp+"', woodcutting_xp = '"+woodcuttingXp+"', fletching_xp = '"+fletchingXp+"', fishing_xp = '"+fishingXp+"', firemaking_xp = '"+firemakingXp+"', crafting_xp = '"+craftingXp+"', smithing_xp = '"+smithingXp+"', mining_xp = '"+miningXp+"', herblore_xp = '"+herbloreXp+"', agility_xp = '"+agilityXp+"', thieving_xp = '"+thievingXp+"', slayer_xp = '"+slayerXp+"', farming_xp = '"+farmingXp+"', runecrafting_xp = '"+runecraftingXp+"', hunter_xp = '"+hunterXp+"', construction_xp = '"+constructionXp+"' WHERE username = '"+username+"'"); } else { stmt.executeUpdate("INSERT INTO `"+user+"_scores` (username, mode, 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, runecrafting_xp, hunter_xp, construction_xp) VALUES ('"+username+"', '"+gameMode+"', '"+overallXp+"', '"+attackXp+"', '"+defenceXp+"', '"+strengthXp+"', '"+constitutionXp+"', '"+rangedXp+"', '"+prayerXp+"', '"+magicXp+"', '"+cookingXp+"', '"+woodcuttingXp+"', '"+fletchingXp+"', '"+fishingXp+"', '"+firemakingXp+"', '"+craftingXp+"', '"+smithingXp+"', '"+miningXp+"', '"+herbloreXp+"', '"+agilityXp+"', '"+thievingXp+"', '"+slayerXp+"', '"+farmingXp+"', '"+runecraftingXp+"', '"+hunterXp+"', '"+constructionXp+"')"); } } stmt.close(); connection.close(); } catch (SQLException e1) { e1.printStackTrace(); } } else { System.out.println("Failed to make connection!"); } return; } } Please fill your secret and user with ones provided on dashboard http://image.prntscr.com/image/c1221a854e9d4c0b9e9a874ccc2f52b5.png After you have done that click save and close this class. Next open up PlayerHandler.java and search for if(player.logout() || exception) { under that add new Thread(new HighscoresHandler(player)).start(); save and close PlayerHandler class and compile! You have now installed highscores server-sided too. Player data will be sent everytime you log out. http://image.prntscr.com/image/9e655b1aab644d4f8c8ba4ba8470f564.png http://image.prntscr.com/image/6283247dcf594a5582c854bc92f0c385.png http://image.prntscr.com/image/900d5ab1312d468c87fe8ec6008e5dfd.png http://image.prntscr.com/image/b683f656b4d94485b835e791947830de.png If you have any questions, please ask! http://rsps-scores.com