RSPS-SCORES.COM

[LukaFurlan 0]

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

This is the hidden content, please

• Sign In
• or
• Sign Up

 and click Create highscores button 

Then fill registration form and click Sign up

This is the hidden content, please

• Sign In
• or
• Sign Up

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

This is the hidden content, please

• Sign In
• or
• Sign Up

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

This is the hidden content, please

• Sign In
• or
• Sign Up

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.

This is the hidden content, please

• Sign In
• or
• Sign Up

This is the hidden content, please

• Sign In
• or
• Sign Up

This is the hidden content, please

• Sign In
• or
• Sign Up

This is the hidden content, please

• Sign In
• or
• Sign Up

 

If you have any questions, please ask!

This is the hidden content, please

• Sign In
• or
• Sign Up

[acesucks 1,311]

I like the idea good luck with your project

[Satdown 4]

thanks for the tut.

[l2nn 12]

wow thanks man

[OfficialLegend 12]

I use this and its great!

[sanfor 1]

Thanks for it LukaFurlan

 

[noorsyed 1]

nice dude might use it

 

[nilsbulk 0]

Thank you for this, this will be handy for my first release

[Lolroker 5]

Wow cool tyty broooo love it

[SweatyRS 0]

This looks dope. Hope your keeping active in the rsps community need more people like ya!

[sedveka 6]

thank you for this

[xx501xx 0]

awesome!!!!!!!

[wulfite 0]

thank you

 

 

[Ary3x 0]

Cool will check out thanks

[christopherfinn 0]

thanks!