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!
@Spidiweb7
Yes, I still have to look at that delete error... But mining a coal / obsidian block didn't duplicate this error for me...
A lot of problems are coming from your MySql connector. I believe you are opening a temporary connection every time someone does something... this is the wrong thing to do. You should make a stream connection and feed everything through it. Otherwise if you have a server with 100+ players on it you can easil max out a 1000 connections limit with an error like follows:
http://pastebin.com/Fx2Vn6PV
I am also getting the delete error MajorCyto is getting.
@MCBuncey
MY pleasure and once again sorry for the wait. I'll think of a way to make it up to you all :P
Ty very much its updated been waiting for quite sometime now :D
@MajorCyto
Hmmm, interesting, and by interesting I mean annoying. Ummm I'm not sure it's a problem with the plugin as I have tested it. I'll take another look at it later on and see if i can fin a problem, although I don't see why it would, I haven't changed the database connection methods since (I think) version 0.1...
As I said I will check but I'm pretty sure this isn't the plugins fault, it's a strange error and sounds like something on your side (If it isn't I find it strange that no one has brought this up yet).
Everything works EXCEPT, the mining high scores.. i double/triple checked the table to make sure it ran the query correct. And it did, i checked and made sure the mysql user had all the proper permissions it does.. but when i mine a coal/obsidian block it produces a long error which i put in a paste here
http://www.pastebin.com/gWK2iY4D
I removed the ip address and mysql user on purpose, it says i dont have permission to delete for the table blocks.. but i do because i can delete it with a query, and in a program such as navicat. So thats impossible..
@Spidiweb7
It's fine on the server I play on, its also fine on my pc...
Hey man, can you confirm this plugin is closing it's mysql connections properly ? i am getting a 100+ connections to my database from something using the database i specified with this plugin. It is either on the website end, or the plugin end this is happening.
Thanks
Finally bukkit approved minescore v0.8 so now you can download it. Enjoy!
@Spidiweb7
read the instructions file :P And Idk why that happens, it doesn't happen for me, re upload the website files. If it happens again ,tell me and I'll look further into it. Although I seem to remember you saying this before, then I went on and searched for it and it was fine.
if i use the search for my name i get: ERROR: spidiweb7 does not exist on highscores.
also it appears the config file does not generate by itself on first launch.
@Spidiweb7
To log players names? What? Please explain more, your database should be fine if it worked in the last most recent one build. I haven't added anything new just fixed some bugs and updated it to work with the latest version.
Does the mysql query need to be updated to log player names to search in 0.8 ?
Also I'm REALLY sorry for the pretty extreme wait for this plugin. I have been busy but for such a small fix it took just too long, I kept putting it off. I can't really excuse that, so I am sorry. I will be more prompt in the future, look forward to future updates and stick with minescore :D
@Spidiweb7
Why are you messing with 0.7? 0.8 is the new one, it's still begin approved. 0.7 is for like mc 1.1 or something old :P the v0.7 one was a mistake so ignore that one :P
Any Dev version for 1.2.4? I had to disable this plugin which is bad since my players like this plugin
@Spidiweb7
I've almost done it it isn't particularly hard :P I just need to edit the config system now and I'm done, well I haven't tested it but It is without errors. It's just when I get the time to do it, sorry for the extremely slow update xD My bad.
If you need a hand just make a github and let us give you some pull requests :)
@Spidiweb7
Yes, sorry for the delay ._. I've been very busy with college and I haven't had time to update it yet, I'll do some today...