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!
-
View User Profile
-
Send Message
Posted Dec 11, 2011@Tombikos
im not sure what you mean bout the worldguard part but a player search is planned :D
-
View User Profile
-
Send Message
Posted Dec 11, 2011Searching for a player would be really great! Also try to add region (worldguard) count to each players, so we can see how "rich" he is.
-
View User Profile
-
Send Message
Posted Nov 18, 2011@Kamisoyokaze
Great to hear, looking forward to the next update!
-
View User Profile
-
Send Message
Posted Nov 18, 2011@Liger_XT5
The plugin doesnt make its own tables, it will once i've finished adding tables in though, but fornow it wont, i included SQL queries in a file to make them though.
-
View User Profile
-
Send Message
Posted Nov 18, 2011@SilentStray
I'm not sure why that's happenig nat all, IT works fine on all the servers I've seen it on, I'll look into it
-
View User Profile
-
Send Message
Posted Nov 16, 2011I've now got minescores running on my server, but when ever I use the webUI, it doesn't show any results. When I use the ingame command /ms mine for example, I get errors stating that the table highscores does not exist.
Does the plugin make it's own tables, or did something goof up on my end?
-
View User Profile
-
Send Message
Posted Nov 12, 2011Ok, now PVP and Farming are also getting errors on the site.
FARM:
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
Warning: Division by zero in /opt/lampp/htdocs/minescore/farmhighscores.php on line 58
PVP:
Warning: Division by zero in /opt/lampp/htdocs/minescore/pvphighscores.php on line 54
Warning: Division by zero in /opt/lampp/htdocs/minescore/pvphighscores.php on line 54
-
View User Profile
-
Send Message
Posted Nov 10, 2011@Kamisoyokaze
Got it working though I'm getting an error on the site.
P.S. Farm and Blocks are not created from using only the "New" SQL query.
Here's the link to it on my web server.
http://munxcraft.dyndns.org/minescore/
-
View User Profile
-
Send Message
Posted Nov 10, 2011@SilentStray
That has nothnig to do with the CB build as it has nothing to do with bukkit, anyhow you need to set up the tables using the queries i provided in the download
-
View User Profile
-
Send Message
Posted Nov 9, 2011@GameCharmer
Im getting the same issue. No tables in mysql. CB 1337
-
View User Profile
-
Send Message
Posted Oct 17, 2011@Kamisoyokaze
Yay! I'm not crazy! :P
-
View User Profile
-
Send Message
Posted Oct 17, 2011@GameCharmer
oh damn i totally forgot abotu that :S sorry
-
View User Profile
-
Send Message
Posted Oct 17, 2011@Kamisoyokaze
That's the thing bud. I was running a fresh install and the block table is not included in the fresh install SQL query.
-
View User Profile
-
Send Message
Posted Oct 16, 2011@GameCharmer
No you shouldn't run them all, you should run the one that applies to you, they are all labelled. If you arre using a fresh install you use the first one, if you are updating from 0.1 you use the second one etc. I take it you were updating from 0.4 so you only use the one that says Existing 0.4, which is the last one.
When 0.6 comes out, if it requires your database to be edited, you will use the querythat has Existing 0.5 above it :P
-
View User Profile
-
Send Message
Posted Oct 16, 2011@Kamisoyokaze
Ahh, I see. I thought the first set of queries in the included file would work. Instead, I need to run them all. Should throw that in there, since I wasn't updating (fresh install)
Correction, just run the block table create statement from the bottom of the text file.
-
View User Profile
-
Send Message
Posted Oct 16, 2011@GameCharmer
@gamecharmer
you shouldnt have manually touched your database, just used the updating query in the script.
minehighscores table shouldnt have been touched, boocks is a new table that both mining and farming highscores use to make sure people cant place blocks and then break them to boost their score,
change minehighscores back to how it was and rune the query that says existing 0.4 above it (if you had 0.4 before) and that should work, you should have pvphighscores, mobhighscores, minehighscores, farmhighscores and blocks tables
when i release a new version dont manually change your database because, i always include a query to do it for you!
-
View User Profile
-
Send Message
Posted Oct 16, 2011I'm getting a SQL error stating that highscores.blocks does not exist. The blocks tables doesn't exist, but a minehighscores table does. I renamed that table to blocks, which didn't work, so I renamed it back to minehighscores. I ran the included SQL file to create the initial tables and I don't see the block table in the SQL file. Also, nothing is being recorded to the minehighscores table.
This is creating quite a spam fest in the server logs. Any query I can run to update the tables?
-
View User Profile
-
Send Message
Posted Sep 21, 2011@KoshNaranek
I should have fixed this bug now, and i've released it as v0.4 along with another bugfix, please download it when it is accepted!
-
View User Profile
-
Send Message
Posted Sep 20, 2011@KoshNaranek
huh i'll have to check this out thanks.
-
View User Profile
-
Send Message
Posted Sep 19, 2011if you specify a different database name parameter "database:" in the config - MineScore.class, database.class still use predefined dbname "highscores". fixit, plz..