Leaderboards

​

What are the supported plugins for the leaderboard?

We exclusively offer support for MySQL databases at present. Furthermore, the functionality does not extend to relational tables. As an illustration, it does not accommodate scenarios where user and statistics data are stored in separate tables.

​

How to create a leaderboard with AjLeaderBoards data?

1. Install the AjLeaderBoards plugin on your server. Learn more about the plugin here.
2. Connect the plugin to the database you created. Open the cache_storage.yml file in the AjLeaderBoards plugin folder. Change the method to mysql and enter your database information.

   method: mysql
   
   # You only need to touch these settings if you are using mysql
   ip: MYSQL_SERVER_IP:3306
   username: MYSQL_USERNAME
   password: MYSQL_PASSWORD
   database: MYSQL_DATABASE
   

3. Have your players data by using the /ajlb add %placeholder% command on AjLeaderBoards plugin.
4. Go to Dashboard > Misc > Leaderboards > Add New. You can add a new leaderboard by providing the following information:
   • Title: Enter the title of the leaderboard.
   • MySQL Server IP: Enter the IP address of the MySQL server.
   • MySQL Server Port: Enter the port of the MySQL server. (Default: 3306)
   • MySQL Database Name: Enter the name of the MySQL database.
   • MySQL Username: Enter the username of the MySQL database.
   • MySQL Password: Enter the password of the MySQL database.
   • MySQL Table Name: Enter the table name created by AjLeaderBoards plugin. Usually starts with ajlb_. You can find the table name in the MySQL database.
   • MySQL Username Column: namecache
   • MySQL Sorter Column: value
   • Data Limit: You can choose how many data you want to show on the leaderboard.
   • Table Columns: You can add the columns you want to show on the leaderboard.
     • Title: Enter the title of the column.
     • Database Column Name: value

​

How to create a leaderboard with other plugins data?

Firstly, check if the plugin you are using supports MySQL databases. If the plugin supports MySQL databases, you can create a leaderboard by following the steps below:

1. Create a MySQL database.
2. Connect your plugin to the database. You can connect your plugin to the database by changing the configuration file of the plugin.
3. Add the data of your players to the database.
4. Go to Dashboard > Misc > Leaderboards > Add New. You can add a new leaderboard by providing the following information:
   • Title: Enter the title of the leaderboard.
   • MySQL Server IP: Enter the IP address of the MySQL server.
   • MySQL Server Port: Enter the port of the MySQL server. (Default: 3306)
   • MySQL Database Name: Enter the name of the MySQL database.
   • MySQL Username: Enter the username of the MySQL database.
   • MySQL Password: Enter the password of the MySQL database.
   • MySQL Table Name: Enter the table name created by the plugin. You can find the table name in the MySQL database.
   • MySQL Username Column: Enter the column name that stores the player’s username.
   • MySQL Sorter Column: Enter the column name that stores the player’s statistics.
   • Data Limit: You can choose how many data you want to show on the leaderboard.
   • Table Columns: You can add the multiple columns you want to show on the leaderboard by clicking the Add Column button.
     • Title: Enter the title of the column.
     • Database Column Name: Enter the MySQL table column name that stores the player’s statistics.