HeadsLeaderBoards
HeadsLeaderBoards
VERSION 4.0 HAS BEEN RELEASED
This update brings some major changes to Heads Leaderboards. But don't worry, it's still backwards compatible with your old leaderboards!! :) The first change you will notice is that the leaderboard.yml is gone and replaced with a Leaderboards directory containing a separate file for each leaderboard. Everything else is related to MySQL leaderboards. In the new yml's for the leaderboards you will notice plenty of new options. First, Database is now a variable for each leaderboard. This will allow you to connect different leaderboards to different databases. Solving one of the most requested features. Second, you will notice a variable for usingUUID. When set to true, you can use a UUID column instead of playernames and the plugin will plugin the playername from Mojang. Third, you will notice the variable for multiStat. When enabled and setup this will allow you to show two stats on one table. For instance you could have a pvp leaderboard that shows both Kills and Deaths of the leaders. The leaderboard will still be sort by the first stat.
INFO FROM PREVIOUS RELEASE
FFS - Head's Leaderboards Finally Supports Flat File Storage. You don't have MySQL, NO WORRIES. Supports both JSON and YML filetypes. Supports files named by UUID or PlayerName.
Version 3.6 has continued to build Flat File support by adding the ability to use sqlite flat file databases (like ScoreboardStats uses, ie. ".db" files). You can do this by creating a SQL leaderboard and enabling flatFileDB in the leaderboard.yml. You will also have to set the path to the db file in the leaderboard.yml. This is the path from the server directory including the filename. (ie. For ScoreboardStats this would be: \plugins\scoreboardstats\scoreboardstats.db) **
One point about using .db files is that you still need to know the table and column names. To find these you can use a SQlite DB Browser
What does this Plugin Do?
This plugin allows you to create sign leaderboards (with heads) using data in a MySQL database OR Flat File Storage. This plugin does not track any player data!! It merely gives you another way to display the data stored in your MySQL database OR store by minecraft or other plugins in Flat File Storage (Such as Kills, Wins, etc...).
Installation
- Copy the Jar file to your plugins directory.
- Edit the created config or use the Setup command to enter the required information for the MySQL database.
- Enable the plugin using the Enable command or by updating the config.
- Create your leaderboard(s).
- Edit the leadarboards.yml or use the Setup command to enter the required information for your leaderboard.
- Enable your leaderboard using the Enable command.
- Create leaderboard signs and place heads above them.
Basic Tutorial (Needs to Be Updated - Coming Soon)
Advanced Tutorial
Customizing Signs Tutorial
Commands and Permissions
Command | Description | Permission |
---|---|---|
/hlb setup | Start the setup utility to enter the Database information in Config.yml | hlb.commands |
/hlb enable | Enables or disables the plugin | hlb.commands |
/hlb create <leaderboard> <leaderboard type> | Creates a new leaderboard named <leaderboard> of the type <leaderboard type>. Leaderboard type bust be either "sql" for MySQL or "ffs" for Flat File Storage | hlb.commands |
/hlb delete <leaderboard> | Deletes the leaderboard named <leaderboard> | hlb.commands |
/hlb list | Lists all of your created leaderboards | hlb.commands |
/hlb setup <leaderboard> | Starts the setup utility for the selected leaderboard | hlb.commands |
/hlb enable <leaderboard> | Enables or disables the selected leaderboard | hlb.commands |
/hlb reload | Reloads the plugin config files | hlb.commands |
/hlbupdate | Updates all enabled leaderboards | hlb.update |
Allows the user to create and destroy HLB signs | hlb.signs | |
Color Codes | black(0), dark blue(1), dark green(2), dark aqua(3), dark red(4), dark purple(5), gold(6), gray(7), dark gray(8), blue(9), green(a), aqua(b), red(c), light purple(d), yellow(e), white(f) | You can use either the "color name" or the "Minecraft Color Code", but do not use the & |
MySQL Leaderboard Sample (Enemy Kills from "Stats" by Lolmewn
Flat File Storage Leaderboard Sample
Flat File SQLite Database Leaderboard Sample
HLB Signs
Place a sign, putting [hlb] on the first line, <the leaderboard name> on the second line, and the position you want to display on the sign on the third line. Optional: Place a Skull above the sign (either directly above or on top of the block the sign is on). Run /hlbupdate or wait for the leaderboard to update!! |
To Do List
Customizable colors for HLB signs.The ability to do reverse order leaderboards.The ability to set the length of the leaderboards.The ability to use databases that store player names in a separate table.- SUGGESTIONS??
Compatible Plugins
The following plugins have been tested and work with HeadsLeaderBoards. In addition, any MySQL database created by a bukkit plugin should work. If you encounter a plugin/database that doesn't work, please create a ticket and I'll look into it.
Metrics
This plugin now uses Metrics. This will help me keep track of how many servers are using the plugin. The plugins metrics can be view at the link below. To opt out of metrics, set opt-out: to "true" in the metrics config in your plugins directory.
@Miyukifei
The column name must not be "id" then. Check the column name in your MySQL table and make sure you have it correct.
why I always get this when trying to setup a leaderboard?
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' in 'field list'
I'm doing exactly what the setup says..
@walrusone
Yeah, I use numbers alone and it doesnt works, i'll try shutting down the server and see if it works like that. Thanks!
EDIT:
I found the problem, Mineversechat conflicts with it... i have to disable it to setup this plugin.
@Miyukifei
For the port, it only accepts numbers, don't know why it wouldn't work. As for writing to the configuration, make sure to shut down the server before making changes, or reload the plugin right after you make the changes.
Everytime I try to setup, I get stuck on the port input, it keeps asking over and over the port no matter how many times I write, and IF i try to set all by the file it gets overwritten by the default file.. i'm on spigot 1.7.10
@PedrinhoDev
I haven't used WickedSkyWars lately. Assuming you are storing your data in MySQL, the setup is pretty easy. Message me and I'll walk you through it.
I'm trying to get a setup video uploaded today!!! Although it I run outta time, it may be a little later in the week.
Can someone help me at setting up the plugin for WickedSkyWars? I want theleaderboard to show to wins.
@kahlilnc
That might be possible. In what ways would you like them to be configurable?
Could you make the sign formatting configurable?
Coud it be possible to move it to a .yml or something? I have no mysql and i like this plugin really.
I have this error when heads are updated and they become a skeleton head for some seconds and then they switch to the skinned head of the player in a loop.
@Lolmewn
Thanks, will do.
I'm looking at ways to make the plugin easier to setup and I'm thinking about adding some native support for some of the more popular plugins. That way all the user has to do is enter the database info and then select the plugin he wants to use for stats and then create the signs. Although this could make future updates a bit of a pain if the other plugins change their table setups.
However, I still plan to leave the custom option so that it can work with any database.
@Omega3395
In the next update. I'm working on it, but with bukkits demise it's harder to get motivated. The fact that Spigot appears to be moving forward is a plus tho.
Suggestion: Actually hook into the API for Stats so you don't have to constantly poll the database. Performance saving ftw!
The caps bug is still there, when i do /hlb assign password DaDaDaPl (for example) in the config it turns in dadadapl without caps. Can you fix this?
Wooh, it supports my plugin! <3
@superzyr
I'm working on a update that will hopefully make setup a little easier. When I finish the update I plan to add a video tutorial. This probably won't be done before the end of next week.
Please add clear instructions on how to setup this plugin.
@Omega3395
Quake doesn't use MySQL, so there is no way I can implement it right now within this plugin. I haven't actually used the quake plugin, but I will look into this to see if and how they are storing data(is there a highscore table or anything??). Otherwise, is quake the only thing you are running on the server? If so you may be able to use a plugin like PVP Stats that will track kills, deaths, longest killstreak etc. Then you could use that data to create a leaderboard. If you PM me your server info, I'll log on your server and see how the quake plugin looks.
Quake support maybe? I'll be greateful! http://dev.bukkit.org/bukkit-plugins/quakecraft/