MySQL Top

This project is abandoned and its default file will likely not work with the most recent version of Minecraft. Whether this project is out of date or its author has marked it as abandoned, this project is no longer maintained.

MySQL Top v1.0

Description

Please, leave comments if you're interested in further development of this plugin. I've developed it for my own server but felt like other Bukkit users might find it useful.

MySQL Top is a plugin that will fetch data from a specified Table in your MySQL Database and display on signs or as a list in chat. The best way to describe it (imho) is displayed on the image below:

MySQL Top in a nutshell

Features

  • Displays information from a specified table in specified order on signs
  • Displays information above in chat, whenever /toplist <ListName> is accessed
  • Updates information on signs every 30 seconds
  • Fully configurable lists
  • Doesn't require knowledge of MySQL Syntax
  • Basic knowledge of MySQL syntax will make installation and use easier.

Usage Example

For usage example please refer to this page.

URL: http://dev.bukkit.org/bukkit-plugins/mysql-top/pages/mys-ql-top-usage-example/

Configuration

Configuration is pretty self-explanatory. Here's an example of default config.yml:

# MySQL Top Config

# If set to true, will enable the plugin, while setting it to false will disable the plugin.
enablePlugin: true

# Set this to true to tell plugin you've configured the plugin.
# This setting is here to prevent plugin from attempt connection
# with dummy settings.
pluginConfigured: false

# If you're not familiar with MySQL and MySQL configuration, you'll probably find this part ambigious.
# In this case, it's not recommended for you to use this plugin.

# Your MySQL host (Default: localhost)
host: "localhost"

# MySQL port !!! AS A STRING !!! (Default: 3306)
port: "3306" 

# Your MySQL username. (Default: root)
user: "root" 

# Your MySQL user's password. (if default user is "root", pass is usually "" [null])
pass: "" 

# MySQL database to fetch data from. There is no default, it should be created by you or someone else.
db: "minecraft_db"

Commands

Command NameDescription
/mysqltop helpDisplays help section of the plugin.
/mysqltop define <List Name>Creates a list with name <List Name>
/mysqltop set <List Name> ispublic <TRUE or FALSE>Defines if the list can be accessed using /toplist <List Name>
/mysqltop set <List Name> table <Table Name>Defines table from which data will be fetched for the list
/mysqltop set <List Name> display <Field Name>Defines field which will be displayed in the list
/mysqltop set <List Name> orderby <Field Name>Defines field which the list will be ordered by
/mysqltop set <List Name> order <ASC or DESC>Defines the order in which the list will be displayed
/mysqltop set <List Name> color <Color (e.g. &4)>Defines the primary color of the list

Table, display field, order field and order are required for the list to function properly.

Permissions

Permission NameDescription
mysqltop.adminGives access to all commands beginning with /mysqltop
mysqltop.toplistGives access to /toplist <List Name>

Info

PM me if you have any problem, or If you a general comment on a project leave a comment here.

Source is coming

Statistics

Comments

  • To post a comment, please or register a new account.
Posts Quoted:
Reply
Clear All Quotes

About This Project

  • Project ID
    71011
  • Created
    Dec 21, 2013
  • Last Released File
    Dec 21, 2013
  • Total Downloads
    499
  • License
    MIT License

Categories

Members

Recent Files

Bukkit