Inactive [ADMN/GEN] Whitelist v2.7 [1337]

Silence · Jan 15, 2011

Whitelist
Version: v2.7

This plugin allows only people on your whitelist to join the server.

Features:

Simple and easy to use

Whitelist is automatically reloaded when changed outsite of minecraft (e.g. with a texteditor)

Whitelist supports console commands

SQL support

Support for every SQL database, that has a JDBC implementation available

User-defined table and database layouts supported

Download Whitelist
Source Code
Donate

Changelog:
Version 2.7

Fixed SQL injections with malformed player names (thanks to Uroz for reporting!)

Version 2.6

Fixed null ptr exception introduced with 2.5

Version 2.5

(Possible) fix for some SQL related errors

Version 2.4

Improved SQL connector handling with new settings directive

Version 2.3

Fixed an unhandled exception (thx to Puremin0rez for reporting!)

Version 2.2

Removed TSLPC

Support for build #415

Version 2.1

Add/Remove commands are working in SQL mode now

Version 2.0

Added SQL support

Minor fixes

Version 1.9

Support for build #287

Version 1.8

Fixed fix for non working permissions.

Version 1.7

Fixed non working permissions (thanks to Kainzo for reporting!)

Version 1.6

Support for Bukkit #186 (also confirmed to work with #230)

Version 1.5

Fixed a null pointer error.

Roadmap:

Add permissions, once implemented in Bukkit

Installation / configuration:
Copy Whitelist.jar in your plugins folder and start your server. The plugin will create new configuration files in plugins\whitelist.
In plugins\whitelist.properties you can set the following options:

kick-message - The message that will be displayed, when a player is kicked from the server because he is not on the whitelist

disable-list-command - Disables the /whitelist list command.

whitelist-admins - A comma separated list of players, who are allowed to modify the whitelist ingame.

Commands:
These commands can be used by Ops ingame or in the server console. When used with the server console don't type '/' before the command.

/whitelist help - Shows the help ;-)

/whitelist reload - Reloads the whitelist and it's settings

/whitelist add [playername] - Adds a player to the whitelist)

/whitelist remove [playername] - Removes a player from the whitelist)

/whitelist on|off - Activates/deactivates the whitelist

/whitelist list - Lists all whitelisted players

SQL configuration:
To support as many different database configurations as possible, Whitelist sets flexibility over simplicity.
This way virtually every existing database can be used as a base for authentification.

For the following example I will assume you are using a MySQL Database with the following configuration:

Username: root

Passwort: fun

Database name: Bukkit

Table name: tbl_names with one column named "name"

Because we are using MySQL, we need the MySQL Connector/J. It can be found here.

Now that we have the connector up and running, it is time to configure Whitelist. This is done in plugins\whitelist.properties.
1) Activate SQL mode
sql-enable=true
2) Set the correct JDBC driver. Because we are using MySQL in our example we choose:
sql-driver=com.mysql.jdbc.Driver
3) Set the connection string. It depends on the database system and layout used.
In our example it is jdbc:mysql://localhost/Bukkit?user=root&password=fun.
Because we have to escape some characters in *.propertie files, we add:
sql-driver-connection=jdbc\:mysql\://localhost/Bukkit?user\=root&password\=fun
4)We have to specify a query, that will be executed on the given database. If the query's result has at least one element, the user is allowed to access the server. There is a placeholder that will be replaced with the name of the person that is trying to join: <%USERNAME%>.
We add:
sql-query=SELECT name FROM tbl_names WHERE name\='<%USERNAME%>'
5)Optional: If /whitelist add should be available in SQL mode, we have to specify a query for it:
sql-query-add=INSERT INTO tbl_users (Id, Name, Waa, Naaa) VALUES (NULL, '<%USERNAME%>', '1', '2')
6)Optional: If /whitelist remove should be available in SQL mode, we have to specify a query for it:
sql-query-remove=DELETE FROM tbl_users WHERE Name\='<%USERNAME%>'

Help, I get a 'class not found error'
Put the following line in your whitelist.properties file: sql-driver-jar={path to the connector}
The base path is the directory your craftbukkit.jar is placed in, so if you have named the connector "mysql-connector.jar" and placed it in the same directory as craftbukkit.jar you would add
sql-driver-jar=mysql-connector.jar

I need more informations!
There is a very nice written guide by MrDylan (thx!) on using Whitelist and MySQL with SMF boards, get it here.
Thats all!

Silence · Jan 16, 2011

Works with build 48:
http://bamboo.lukegb.com/browse/BUKKIT-CRAFTBUKKIT-48/artifact

Profanwolf · Jan 16, 2011

Silence said: ↑

It already is: Whitelisted names are put in whitelist.txt, one name per row.
The Entrys in whitelist.properties are the admins.

Oh, thank you!

zajacmp3 · Jan 16, 2011

Works great!

It would be very nice though if the Whitelist folder was maked in main folder where the craftbukkit is not in Plugins folder.

Hope you will think about it ; )

Silence · Jan 16, 2011

61 is the latest Craftbukkit and 47 the latest Bukkit version.
Yes, the numbers are increasing.
The plugin is working with 61, not sure which is the minimal version it needs, because the API is in a flux atm and its hard to keep track of it :X
http://bamboo.lukegb.com/browse/BUKKIT-CRAFTBUKKIT-JOB1-61/artifact

M3t · Jan 16, 2011

Silence, will you make a /sethome /home command that will save even if server resets? Version 48 here.

We'll pay $10, is this feasible?

Silence · Jan 16, 2011

Shouldn't http://forums.bukkit.org/threads/myhome-sweet-home.249/ work?
Thought its already working

M3t · Jan 16, 2011

How about $15
--- merged: Jan 16, 2011 8:33 PM ---
Would you please get on Ventrilo: Krypton.typefrag.com 6945

Silence · Jan 16, 2011

Its not a money problem - I'm a professional software developer and in my line of business the hourly rate is six times as high ;-)

That being said, I can make you a simple one 4 free tomorrow (its 10PM here).
But because it would save the positions in flat files it would be slower than tkelly's solution, when you have a huge number of players.

Edit: Can't join vent, again not at home XD

M3t · Jan 16, 2011

tkelly's doesnt work for 48, does it?

Silence · Jan 16, 2011

Hmm no idea
I think there were at least 2 plugin breaking changes in the last two days, so I lost track what is working @What version

M3t · Jan 16, 2011

I have a problem with kelly's because it's too fumbly with weird syntax, and gives the users far more powers than we want to give them than the 2 basic commands. All we need are /sethome and /home. We don't want to be putting space in between our commands either like /set home, and /set invite location or whatever he's up to. We don't want to give our users access to all those extraneous commands.

Plus, his version frequently crashes and breaks if the server is restarted, which we do twice a day.
--- merged: Jan 16, 2011 9:07 PM ---
THIS WHITELIST IS E-MAZING.

Silence · Jan 16, 2011

Ok, tomorrow morning (thats in 11 hours in case you wonder) I'll write you a simple /sethome /home plugin

M3t · Jan 16, 2011

Thanks hun

Kainzo · Jan 16, 2011

Simanova said: ↑

/whitelist list ( feedback a list of allowed players )

would be nice

Please god no. We have 2000+ players whitelisted - this would crash any server that is public.

M3t · Jan 16, 2011

Don't write it for me - write it for the public! We'll love you :3 Simple is better.

Silence · Jan 16, 2011

Kainzo said: ↑

Please god no. We have 2000+ players whitelisted - this would crash any server that is public.

Well, only admins can use it, so just tell them not to
I'll add a settings to disable it.

M3t · Jan 16, 2011

Alright, alright, what's your paypal. I must donate.

tekac · Jan 16, 2011

i'll donate if he implements /home and /home set

Kainzo · Jan 16, 2011

BUG REPORT:
Latest bmod/whitelist plugin.

When doing /whitelist off and then stopping the server- upon bringing it back up - the whitelist 'off' feature is now toggled and an admin has to /whitelist off again

Is this intended?

Silence · Jan 16, 2011

@Donation: None needed/wanted
If the stuff works tomorrow you might want to buy me a cup of coffee, I'll maybe post link after the stuff is done XD

@Kainzo: This is intended, the /whitelist on|off was implemented so it can be switched off temporary. To deactivate it even after reboot you have to disable the plugin. Otherwise admins might forgett to turn on the list again (you would not see it, because server log says whitelist enabled).
However, if enough folks want this feature, I'll gladly implement it

Kainzo · Jan 16, 2011

Well - typically its not needed for when this is all stable - but its a bitch otherwise

Just wanted to give you feedback!

M3t · Jan 16, 2011

If you aim to please, make the syntax /home and /sethome just like classic hMod had it.
--- merged: Jan 16, 2011 11:42 PM ---
By the way whats up Kainzo heard you got a pretty cool server running.
I run AtlantaMinecraft.com 110% Vanilla realistic build only. Seems like we have opposite server types

darknesschaos · Jan 16, 2011

If you do not mind, I will be using some of your whitelist code inside of my plugin. It will also use your whitelist file. If you are curious as to what I am doing feel free to message me. But overall nice plugin you have here.

Silence · Jan 16, 2011

@M3t: Yeah, this will be the syntax
@Darknesschaos: Nope, I don't mind because I will release the source under GPL anyway. Please note: As the code is under GPL so have to be yours if you want to ever release it

Mcbibbles · Jan 16, 2011

i might be an idiot, but whenever i extract, im not getting a jar file. also ive tried putting the.zip in the plugins folder, and the whitelist folder that extracting generates in the plugins folder, but nothing is working

darknesschaos · Jan 17, 2011

Silence said: ↑

@M3t: Yeah, this will be the syntax
@Darknesschaos: Nope, I don't mind because I will release the source under GPL anyway. Please note: As the code is under GPL so have to be yours if you want to ever release it

I wouldn't mind. Because all efforts here are to strictly help the community, and anything that helps works.

edit - Also, considering these are jars, if someone wanted the source, they could get it easily.

4am · Jan 17, 2011

Mcbibbles said: ↑

i might be an idiot, but whenever i extract, im not getting a jar file. also ive tried putting the.zip in the plugins folder, and the whitelist folder that extracting generates in the plugins folder, but nothing is working

What do you get when you extract?

Mcbibbles · Jan 17, 2011

4am said: ↑

What do you get when you extract?

A Folder Titled "Whitelist"

4am · Jan 17, 2011

Mcbibbles said: ↑

A Folder Titled "Whitelist"

...and what is in the folder?

Starrk · Jan 17, 2011

4am said: ↑

...and what is in the folder?

It's in the Plugins folder. After putting Whitelist.jar into the plugins folder, just refresh it and it will make a folder called Whitelist.

In that folder you will have "Whitelist.txt" and "whitelist.properties.txt"

Edit Whitelist.txt with IGN's.

i.e :

bobmarley
derekjeter
ichigo

and in Whitelist.properties.txt you can edit the kick message.

Log in or Sign up

Inactive [ADMN/GEN] Whitelist v2.7 [1337]

Silence

Silence

Profanwolf

zajacmp3

Silence

M3t

Silence

M3t

Silence

M3t

Silence

M3t

Silence

M3t

Kainzo

M3t

Silence

M3t

tekac

Kainzo

Silence

Kainzo

M3t

darknesschaos

Silence

Mcbibbles

darknesschaos

4am

Mcbibbles

4am

Starrk

Share This Page

Inactive [ADMN/GEN] Whitelist v2.7 [1337]

Share This Page

Useful Searches