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:
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 Name | Description |
| /mysqltop help | Displays 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 Name | Description |
| mysqltop.admin | Gives access to all commands beginning with /mysqltop |
| mysqltop.toplist | Gives 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
