마음의 안정을 찾기 위하여 - [마인크래프트][플러그인] Whitelist v2.1
1868140
29
619
관리자새글쓰기
태그위치로그방명록
별일없다의 생각
dawnsea's me2day/2010
색상(RGB)코드 추출기(Color...
Connection Generator/2010
최승호PD, '4대강 거짓말 검...
Green Monkey**/2010
Syng의 생각
syng's me2DAY/2010
천재 작곡가 윤일상이 기획,...
엘븐킹's Digital Factory/2010
[마인크래프트][플러그인] Whitelist v2.1
게임 이야기/MineCraft | 2011/02/22 10:49
링크 : http://forums.bukkit.org/threads/admn-gen-whitelist-v2-1-287.587/

Whitelist
Version: v2.1

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 *new*
    * Support for every SQL database, that has a JDBC implementation available *new*
    * User-defined table and database layouts supported *new*

Download Whitelist
Source Code


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. Please read the documentation to understand how to install this probably.
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%>'
2011/02/22 10:49 2011/02/22 10:49
Article tag list Go to top
View Comment 0
Trackback URL :: 이 글에는 트랙백을 보낼 수 없습니다
 
 
 
 
: [1] ... [99][100][101][102][103][104][105][106][107] ... [852] :
«   2021/04   »
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30  
전체 (852)
출판 준비 (0)
My-Pro... (41)
사는 ... (492)
블로그... (22)
My Lib... (32)
게임 ... (23)
개발관... (3)
Smart ... (1)
Delphi (76)
C Builder (0)
Object... (0)
VC, MF... (9)
Window... (1)
Open API (3)
Visual... (0)
Java, JSP (2)
ASP.NET (0)
PHP (4)
Database (12)
리눅스 (28)
Windows (21)
Device... (1)
Embedded (1)
게임 ... (0)
Web Se... (2)
Web, S... (19)
잡다한... (5)
프로젝트 (0)
Personal (0)
대통령... (9)
Link (2)