SQLWhitelist
<center><font size=12 color=red>SQLWhitelist</font>
This lightweight plugin let you manage your whitelist over MySQL.
Lets just configure it with your MySQL data and it's automatically creates the table for itself,then you're ready to go!
Just fill the table with player names and enjoy.
You have questions?Read below!
How to install?
Just place the .JAR file in your "Plugins" directory and then launch the server.
The plugin create it's directory and it's config file in it.
Configure it with your MySQL data and then reload or restart the server.
If you configured it correctly the plugin connect to your database and create a table for itself.
If the plugin failed to create the table please read below.
Questions and Answers:
Q:It sounds fun,but what it is good for?
A:It's good because you can manage your whitelist over the internet,no need of FTP connections and with a very little knowledge of PHP you can write systems,or fork existings to work with this plugin.
Ex.: After your players registered on your website they can enter a username which is getting in this SQL table,and they can instantly come to play!
Q:Every time if i want to disable the plugin i have to delete the .JAR file or move it somewhere to dont let it launch up?
A:Of course there's an other way!You can disable the plugin in its configuration.Just set "settings->enabled" to "false" and the plugin wont launch up!
Q:There's option to custimize the kick message?
A:Yes,there is.In the configuration set the "settings->kickmessage" to what you want and have fun!
Q:The plugin says it's unable to create the table for itself and it pleases me to create it manually.How can i do this?
A:If the plugin fails while creating of the table,then you have to create it yourself in your MySQL database.
You can do it by using this code:
CREATE TABLE `your_table_name` ( name VARCHAR(50) NOT NULL UNIQUE);
Please note,you have to change the "your_table_name" part without touching the `-s and the "name" in the bracket.
or
You can do it by fully manually.You have to create a table with name what you want,and 1 column in it called "name".
"name" is a VARCHAR,it's lenght is 50,it's NOT NULL and finally it's UNIQUE.
Have fun!
This lightweight plugin let you manage your whitelist over MySQL.
Lets just configure it with your MySQL data and it's automatically creates the table for itself,then you're ready to go!
Just fill the table with player names and enjoy.
You have questions?Read below!
How to install?
Just place the .JAR file in your "Plugins" directory and then launch the server.
The plugin create it's directory and it's config file in it.
Configure it with your MySQL data and then reload or restart the server.
If you configured it correctly the plugin connect to your database and create a table for itself.
If the plugin failed to create the table please read below.
Questions and Answers:
Q:It sounds fun,but what it is good for?
A:It's good because you can manage your whitelist over the internet,no need of FTP connections and with a very little knowledge of PHP you can write systems,or fork existings to work with this plugin.
Ex.: After your players registered on your website they can enter a username which is getting in this SQL table,and they can instantly come to play!
Q:Every time if i want to disable the plugin i have to delete the .JAR file or move it somewhere to dont let it launch up?
A:Of course there's an other way!You can disable the plugin in its configuration.Just set "settings->enabled" to "false" and the plugin wont launch up!
Q:There's option to custimize the kick message?
A:Yes,there is.In the configuration set the "settings->kickmessage" to what you want and have fun!
Q:The plugin says it's unable to create the table for itself and it pleases me to create it manually.How can i do this?
A:If the plugin fails while creating of the table,then you have to create it yourself in your MySQL database.
You can do it by using this code:
CREATE TABLE `your_table_name` ( name VARCHAR(50) NOT NULL UNIQUE);
Please note,you have to change the "your_table_name" part without touching the `-s and the "name" in the bracket.
or
You can do it by fully manually.You have to create a table with name what you want,and 1 column in it called "name".
"name" is a VARCHAR,it's lenght is 50,it's NOT NULL and finally it's UNIQUE.
Have fun!
Hello, will you ever update it to 1.2.4? Thank you in advance.
It always re-writes over the config file, so i can't connect to the mysql database
@Filano
As i mentioned in PM,please update your Java JRE to version 7.
There you go: Link
hey great mod but by the latest bukkit version 1.0.1-R1 is an error:
2011-12-17 19:12:43 [SEVERE] Could not load 'plugins\SQLWhitelist.jar' in folder 'plugins': java.lang.UnsupportedClassVersionError: me/zephyr/sqlwhitelist/SQLWhitelist : Unsupported major.minor version 51.0 at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(Unknown Source) at java.lang.ClassLoader.defineClass(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$000(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:36) at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:24) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:170) at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:215) at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:136) at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:151) at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:127) at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:52) at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:145) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:399) at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
@FreeZed2
Well,maybe i add it later,thanks for your advice! :)
i like this..
maybe you can add freeze option example people go in minecraft but cant move, but you can see messige what you need to do become active member...
Example for msg: Go to xxx.com register account and activate.