MineScore
MineScore adds an online highscores feature to your server, with multiple leader boards and easy configuration.
Updated 23/04/2012 v0.8.1 - Bug fixes!
- Visit our website to see a live demo of the score boards: http://www.minescore.com
NOTE: If starting a new database use this query and not the one provided, the one provided has 1 extra bracket in after NOT NULL and that basically breaks the whole thing, sorry! I'll fix it in the next release...
CREATE DATABASE highscores;
USE highscores;
CREATE TABLE pvphighscores (id SMALLINT
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL,
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL,
rating INT( 11 ) NOT NULL,
honor INT( 11 ) NOT NULL,
current INT( 11 ) NOT NULL,
killstreak INT( 11 ) NOT NULL);
CREATE TABLE mobhighscores (id SMALLINT
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL,
kills INT( 11 ) NOT NULL,
deaths INT( 11 ) NOT NULL);
CREATE TABLE minehighscores (id SMALLINT
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL,
coal INT( 11 ) NOT NULL DEFAULT 0,
iron INT( 11 ) NOT NULL DEFAULT 0,
redstone INT( 11 ) NOT NULL DEFAULT 0,
lapis INT( 11 ) NOT NULL DEFAULT 0,
gold INT( 11 ) NOT NULL DEFAULT 0,
obby INT( 11 ) NOT NULL DEFAULT 0,
diamond INT( 11 ) NOT NULL DEFAULT 0);
CREATE TABLE farmhighscores (id SMALLINT
UNSIGNED NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL,
wheat INT( 11 ) NOT NULL DEFAULT 0,
melon INT( 11 ) NOT NULL DEFAULT 0,
pumpkin INT( 11 ) NOT NULL DEFAULT 0,
pwheat INT( 11 ) NOT NULL DEFAULT 0,
pmelon INT( 11 ) NOT NULL DEFAULT 0,
ppumpkin INT( 11 ) NOT NULL DEFAULT 0);
CREATE TABLE blocks (location VARCHAR( 1000 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL);
Current Features:
- Pvp Kills and deaths and Mob Kills and deaths are recorded and sent to a database.
- A webpage displays a leader board depending on which one you have selected (out of Pvp and Mobs).
- Their rank, name, kills, deaths and kill to death ratio are displayed on both leader boards.
- Another leader board displaying mining info, telling you how many coal, iron, redstone, lapis, gold, obsidian and diamond you have ever mined and your total amount.
- Top killer is highlighted red.
- Attractive leader board layout
- Leader board displays 10 results and automatically generates pages to display the others
- Website can be configured with ease, including such choices as default leader board to be displayed and which leader boards you want to include.
- In game commands /minescore(or ms) pvp/mob/mine . Each different one displays your own stats in the specified board.
- Ready-made MySQL query included so you can create your database with ease.
- Instructions on how to install and use the mod are included also.
Future Features:
- Option to order leader board by best kill to death ratio, least deaths and alphabetically by name.
- If enough people use this plugin I would like to set up a global website, which every plugin will connect to so you can see how you do against people all over the minecraft community.
- More detailed stats, not just in pvp, 1.8 will open many doors I'm sure. These will be able to be turned off in config so you only display the scores YOU want.
- A more aesthetically pleasing leader board look and layout.
- Support for other plugins, for example Towny leader boards. Please Tell me what plugins you want support for.
- Any suggestions?
Don't forget to post a comment saying you have it on your server, as if enough people use it I would like to set up a global website, so you can see how your players fare against all the other people using this plugin!
Please pose screen shots of your high scores so I can add them to the post! And of course report any bugs to me so I can fix then ASAP!
Thank you for using MineScore!
When creating database using query provided in the description (not the file)
@GlabbichRulz
However some do, and of course, server host dependent you may be able to run a mySQL server off your mc server. If there isn't a way to do it by yourself, you should ask your hosters. Mysql databases are requirements for quite a few plugins including popular ones, they should be able to accommodate mysql servers. If it isn't a mine craft specific one and you have access to command line you can install it anyway.
@Kamisoyokaze
But most host dont allow remote acces.
Another suggestion: Maybe whenever gets a highscore, the server could broadcast a configurable message. That'd make things really competitive.
@GlabbichRulz
Well I guess it would be possible for me to do that, however I'd rather not, I don't think it's a particularly good way to go about doing it.
Use MySQL, it's not hard, you can find free database hosting services too, most free website hosters give you at least one MySQL database with the website... For example http://www.byethost.com/ gives you MySQL databases I think... Then jsut make your database, use the SQL code I provided to set up the tables and then enter the database info into the yaml inside the jar.
What are the requirements? Is it possible to set up with YAML list, not MySQL?
Works perfectly, I'll be introducing it to my players today: http://cheatsynation.com/scores/
Suggestion: Factions integration and maybe an option to reset all data with a command.
@Spidiweb7
Good Good
ALSO to all users, there won't be any updates so far as new features until come late june. I have exams atm so 80% of my time is school/revision and the other 20 is eating and sleeping :P I'll keep it updated with current minecraft and fix any bugs though.
New things will come in the summer, please, if you have any requests or suggestions don't hesitate to post them!
will need to wait till the weekend till my peak server time but so far looks as though the delete error and too many connection issues are solved :)
@CharlesWCrete
Demos not down for me, its not supposed to have any data in btw, I guess I should put some in! It's also an old version i think...
+ lol 2010 I'll fix that now xD. This plugin wasn't even out in 2010 xD
-_- ...
23/04/2010?!?!?!?!?!
ANd the demo is down...
Great plugin... will use it!
@groovyben008
Yes, of course, i'd appreciate it if you put a link in the footer to this page of course, but I won't make you. I'm glad you like my plugin :)
Hi, Love your plugin, works great, but can I have permission to custom code the php for my site and give it the same design. Thanks Groovyben008
Hay! Sep 6! My B-Day! lol great plugin!
@Spidiweb7
Done, waiting for it to be accepted now. Please tell me if the too many connections error still happens, I tried to fix it, but of course I can't test it!
Nice one :D
@Spidiweb7
Yes :P I've jsut finished a 3.5 hours revision session xD I'll do it now :P
EDIT: I'll also sort out that too many corrections error whilst I have the time on my hands...
Update soon then ? :P
@Spidiweb7
Rofl is that what I put xD? Well that's why it's not working for you but it is working for me then xD
Maybe the following line if the database isn't called highscores ;)
PreparedStatement delete = con.prepareStatement("DELETE FROM `highscores`.`blocks` WHERE `blocks`.`location` = '" + blockloc + "';");