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!

M3t · Jan 15, 2011

PLEASE UPDATE THIS SO WE CAN PLAY ^_^

Jasin · Jan 15, 2011

You can't expect them to update their plugin every 5 minutes. It was working before I updated to latest bukkit. Once I get all the plugins working I don't plan to update bukkit until all plugins are changed again. Easier then sitting with them all broke.

Silence · Jan 15, 2011

I'm not at home right now, so I'll fix it when I'm back tomorrow.
As Jasin said, Bukkit was updated which then broke the plugin, but I can't fix it without a PC ;-)

@Sourceode: Not so sure - I always released my stuff (not minecraft related) and got pissed of because every one used it in their own projects without follow the rules of GPL...event commercial ones. But as this stuff is so simple I think I'll release it.

@/whitelist list and whitelist on|off -> will implement that tomorrow.

McSpuds · Jan 15, 2011

M3t said: ↑

THANK GOD, emerg"a"ncy whitelist fucking sucked ass.

It worked when nothing else was available.
--- merged: Jan 15, 2011 11:23 PM ---

M3t said: ↑

THANK GOD, emerg"a"ncy whitelist fucking sucked ass.

BTW, last time I checked, 30 minutes ago, your plugin didn't even load up!
--- merged: Jan 15, 2011 11:26 PM ---

Jasin said: ↑

You can't expect them to update their plugin every 5 minutes. It was working before I updated to latest bukkit. Once I get all the plugins working I don't plan to update bukkit until all plugins are changed again. Easier then sitting with them all broke.

Yes, me too. I grew tired of chasing plugins with HMod, and now we are doing again. We are going to just stay with Emerg"a"cy Whitelist for now and stay vanilla.

M3t · Jan 15, 2011

Around what time? We got a community of 50+ players (all 22+ age mature, paying-to-play players).

I need to tell them something - what time will this be out??

Silence · Jan 15, 2011

10hrs from now on

McSpuds · Jan 15, 2011

M3t said: ↑

Around what time? We got a community of 50+ players (all 22+ age mature, paying-to-play players).

I need to tell them something - what time will this be out??

You mean a community of 50+ players (all 22+ age mature, paying-to-not-play players).

M3t · Jan 15, 2011

Silence please hurry =) I'd love to have you check out our server. We pay $120/mo to host it on the same server as Blizzard hosts WoW, and Sony hosts PS3 network ^_^ That means you'll get 20ping or less anywhere in the continental US! It's a vanilla server. All we need is whitelist and sethome. I'll pay you money to make mods for us. We have $400 in the bank

Vegarg · Jan 16, 2011

This plugin works very nicely thanks!

McSpuds · Jan 16, 2011

Vegarg said: ↑

This plugin works very nicely thanks!

Not for build #41

Vegarg · Jan 16, 2011

Hmmm I probobly need to update my bukkit then lol. Thanks for the info

Jasin · Jan 16, 2011

M3t, Since he isn't going to update for 10 more hours, I'd recommend reverting your craftbukit to an earlier build before it broke.
Edit or use one of the other whitelists for now.

M3t · Jan 16, 2011

That's a good idea USMC, but I'd like to stay current, we're doing a world-wide server reset tomorrow and I want everything to be perfect before then.

M3t · Jan 16, 2011

god i need this whitelist SO BAD...

so hey Silence can I hire you to do some more plugins / update them for us

Silence · Jan 16, 2011

Its 9 in the morning here, starting to fix :O

Edit: Fixed the changed namespaces, should work, but the latest bukkit server isn't starting at all for me (not whitelist related)

Silence · Jan 16, 2011

Done, new version released.
Will work with latest bukkit build.
Also implemented two new commands:
/whitelist on|off
and
/whitelist list
Downloadlink @first post

Fishcake · Jan 16, 2011

Awesome, works like a charm. Thanks for this

saiek · Jan 16, 2011

yes! thank youuu

Pitcher · Jan 16, 2011

Brilliant plugin.
Exactly what I was looking for. Thank you for your work.
I just working 2 Days with the Minecraft server, and I have another question
I can write manualy players in the Whitelist.txt - goes without problems.
But i cannot write commands - if i try "/ whitelist help" there is no response.
I got my self in OP.txt ... help?

Silence · Jan 16, 2011

There is a file called "whitelist.properties" in plugins/whitelist.
This file gets created after you run the plugin for the first time.
In there you can set the kick message, and also the playernames who can use the whitelist commands
Code:
kick-message=Sorry, you are not on the whitelist\!
whitelist-admins=Name1,Name2,Name3
Just replace Name1,Name2,Name3 with the users you want to be able to use the commands ingame

jimmyhendr0x · Jan 16, 2011

Thanks, working great =D

Pitcher · Jan 16, 2011

Silence said: ↑
There is a file called "whitelist.properties" in plugins/whitelist.
This file gets created after you run the plugin for the first time.
In there you can set the kick message, and also the playernames who can use the whitelist commands
Code:
kick-message=Sorry, you are not on the whitelist\!
whitelist-admins=Name1,Name2,Name3
Just replace Name1,Name2,Name3 with the users you want to be able to use the commands ingame
Thank a lot !!! - i will try this

Silence · Jan 16, 2011

@M3t Drop me a PM when you are back.

theotheoderich · Jan 16, 2011

It´s working great, thanks a lot!

Profanwolf · Jan 16, 2011

Any way you could make it work with txt's as well, so you can keep each name for whitelisting entry on one row of it's own, would be much easier for me with >800 whitelist entries

Silence · Jan 16, 2011

Profanwolf said: ↑

Any way you could make it work with txt's as well, so you can keep each name for whitelisting entry on one row of it's own, would be much easier for me with >800 whitelist entries

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

lowbeat · Jan 16, 2011

awesome plugin mate, could you add in next version, ip verification, so for users that have static ip adress, and want to protect their account even better, you could add ip they are allowed to connect with ?

KoBRaAndrey · Jan 16, 2011

I copy you plugin to plugins. And he doesn't work I not at whitelist and can connect to server.

Silence · Jan 16, 2011

@KoBRaAndrey: Do you have the latest version of bukkit?
What does the console say?

@lowbeat: Given that Bukkit can give you the IP this function is trivial to implement, its more a question of policy: I have to think off a way to make it easy to configure without breaking the current withlist.txt (or making it more complex).
I thought about binding whitelist optionaly to a SQL database and I will keep your request in mind and add it when possible

cartman-2000 · Jan 16, 2011

Silence said: ↑

Its 9 in the morning here, starting to fix :O

Edit: Fixed the changed namespaces, should work, but the latest bukkit server isn't starting at all for me (not whitelist related)

b50 is broken, it doesn't start for me either, and this doesn't work on my older build b44 I think..

Log in or Sign up

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

Silence

M3t

Jasin

Silence

McSpuds

M3t

Silence

McSpuds

M3t

Vegarg

McSpuds

Vegarg

Jasin

M3t

M3t

Silence

Silence

Fishcake

saiek

Pitcher

Silence

jimmyhendr0x

Pitcher

Silence

theotheoderich

Profanwolf

Silence

lowbeat

KoBRaAndrey

Silence

cartman-2000

Share This Page

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

Share This Page

Useful Searches