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!
@Kamisoyokaze
Pretty much everything related to the plugin. Theres about a 4-5 second delay before it regesters when mining ores, hitting animals, and having death register. I also get those "Server can't keep up" messages. But no Errors.
@binarycoder
What lags? Could you be a little more specific?
Hi there! This looks like it'll be a great addition to our server! However, I can't seem to get the MySQL to query properly. I'm using 000webhost, and I have the database set up, but when it comes time to plug in the script you provided, I get this error:
Edit: Nevermind, I get it now. however my host isn't allowing me to run the script.... Edit 2: ok, figured that out, now im getting this: Edit 3: Alright, turns out it was my host. Its working now, but it lags alot. I would really apperiate any help you can offer!
@movaj
I do do that, just later on, it works fine for me the server i play on, my test server, and the other servers i've played on that have it.
I cant get the query to work.... im using MYSQL 5.5 and this is what I get when i try the NEW query:
The database gets created but not all the tables.
@MrJangles
Thanks ^-^
Installed. Love it. Thank you :).
http://www.minecraftaddicts.com/minescore.php
@Liger_XT5
Hmmm, probably just chance? It worked fine running off my pc, whic hisnt suited to run a server at all, it also works fine on the server i play on too :o I'll see if i cant tidy some of the code up but I'm not sure that it would do much ..
Just installed the new plugin.
Plugin does as it suppose to, but for some reason there is a lagg.
If I sit down and take out 6 wheat, they reappear in the same order I took them out, then all vanish at once. It seemed like normal lagg, but once I took out the plugin, everything worked just fine.
Within the next two days a new release will arrive :D minescore v0.7 :) Complete will kill streaks, fixed bugs, improved honor and player profiles!
@Spidiweb7
no I haven't , why would you want it, + i can probably do something about that :) either not count creative stuff or have a list of excluded players
The ability to hide people from the list would be awesome :) as currently it is picking up admins on my server in creative mode destroying blocks :( Have you got a github with your source on ?
@caidcurse
Thanks :) I'm gonna be honest and say i don't know how to make an intergrated web server, but i'm sure i can find out, if not i'll seek external help, it sounds like a good idea :)
As for heroes and mcmmos intergration etc. I'll get to that when I can
In the next update i am adding a revised version of Honor, mob tracking for each specific mob and with that hunters rating, also if i have the time i'll add the revised version of farmers rating, it's kind of complicated but 100 times better.
It's christmas holidays at the end of the week so i can put in more time than usual, but i do also have 3 AS level exams when i get back to college :L
but the above deffinately will be done during the holidays!
I agree with the previous poster who mentioned the dynmap method of the jar acting like a web server. I enjoy having the server itself host the page, with no setup.
I am also interested in the idea of having mcmmo and heroes integration for top lists. It'd be neat to see who had the highest gains of the week/month in levels and such.
I like where your plugin is going, looks great.
-Caid.
@TheGurw
I'll add that to the list of things to do, which apparently has gotten pretty large xD But as long as people want to use my plugin, I'll work hard :)
optional mcMMO support?
@SchwarzerZylinder
all you need is LAMP/WAMP installed on your server and uplaod the files and bingo yuou have the website set up , I'll look at dyn map to seewhat its like
How can I set up a website, if I don't have one? Could you add an internal webserver like dynmap?