
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!
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:
Future Features:
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!