Inactive [ADMN/WEB/SEC] Warrant 4 - Fast Forum Group Bridge [1.1-R6/1.2.2-R0.1]

Discussion in 'Inactive/Unsupported Plugins' started by Ant59, May 21, 2011.

  1. Offline

    Ant59

    • adfly link removed
    [​IMG]

    Warrant effectively allows you to control your users' permission ranks in-game through your forum/community system! I have designed this to work with Permissions 3 and SMF, however it is customisable to work with nearly any forum system using MySQL. All column names are customisable and information can be changed in the config.yml file.
    Warrant is perfect for subscription servers, where SMF subscriptions are used for example. It can grant VIP grouping as soon as the player logs in after taking out the subscription on the forum, or simply being moved rank on the forum.

    So far, I've had feedback of successful syncing with SMF, phpBB, XenForo, vBulletin, ccBoard and a few others I can't remember the names of :)

    Supports the following permissions plugins: PermissionsEx, bPermissions.
    Has Warrant been of any use to you?
    For now, this is my only source of income at university.
    Every donation is VERY much appreciated :D
    [​IMG]
    Version 4.0.3
    Version 3.2
    Just grab the JAR there, and drop it in your plugins folder! Simples ;)
    Let me know if there are any other features you want and if there are any bugs to squash!
    Currently, you will still need to create your own configuration file for Warrant to work from. Inside your plugins folder, create a folder called "Warrant", and inside there create a file called "config.yml". Here are example config.yml files for you to work from and customise as you wish. If anyone creates example files for any other forum system, I'd love to post them up here too!

    SMF (open)
    Code:
    forum:
        # Want to use information from a custom profile field instead of the user's forum username?
        multitable: false
        # Want to use a comma seperated list of additional groups to assign your member?
        use-additional-groups: true
        # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
        use-group-table: false
        # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
        use-boolean-ban: false
        # Bung in the info on where to look for the member data
        usertable:
            # Name of the member data table
            name: smf_members
            # Field to find the group id to match those set in the "groups" section of this file
            group-field: id_group
            # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
            username-field: member_name
            # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
            additional-groups-field: additional_groups
            # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
            banned-field:
            # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
            key-field: id_member
        # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
        profiletable:
            # Name of the custom profile fields table
            name: smf_custom_fields
            # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
            key-field: id_member
            # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
            minecraft-name-field:
        # This ONLY applies if you want to use a phpBB3 style group table
        grouptable:
            name: phpbb_user_group
            key-field: user_id
            group-field: group_id
     
    # Stick your database info here
    database:
        host: 'districtmine.net'
        port: '3306'
        db: 'database'
        user: 'username'
        pass: 'password'
    # Which worlds on your server should Warrant affect the permissions for?
    worlds:
        - world
    # What you gonna tell peeps that aren't whitelisted? (PS, telling them to go and register on the forum would be a good idea. Telling them to #"@! off, would not)
    kick-message: 'Sorry, you are not permitted to login to the server at your current rank'
    # What you gonna tell peeps that are banned by your forum? (Telling these guys to #"@! off may actually be a good idea lol)
    banned-message: 'Sorry, you are not permitted to login to the server as you are banned'
    # Tell players that they've been assigned ranks when they login, or just do it silently in the background?
    notify-group-on-login: true
    # Keep out those who aren't in any group stated below (false), or shall we let them in and assign them to their default permissions group (true)?
    whitelist-default: true
    # Stick all the mappings here for any groups you wish tp be auto-ranked
    # Make sure to surround the number in single quotes (''), else it may just self-destruct and noone wants that
    # If "whitelisted" is false, then you may ommit the rank, as there will be no need to assign a rank to disallowed players
    # You must give a default group that can be assigned to those players that have been demoted from a higher rank to prevent them from keeping permissions they no longer have access to
    default-group: Member
    groups:
        # Here, normal registered members can go ahead and just join in as normal members
        '0':
            rank: Member
            whitelisted: true
        # Admins are instantly granted all there rights as found in the Permissions configuration
        '1':
            rank: Admins
            whitelisted: true
        # Let's say this group is banned for example. We can forget about the rank because they don't deserve one :)
        '2':
            whitelisted: false
    

    phpBB3 (open)
    Code:
    forum:
        # Want to use information from a custom profile field instead of the user's forum username?
        multitable: false
        # Want to use a comma seperated list of additional groups to assign your member?
        use-additional-groups: false
        # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
        use-group-table: true
        # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
        use-boolean-ban: false
        # Bung in the info on where to look for the member data
        usertable:
            # Name of the member data table
            name: phpbb_users
            # Field to find the group id to match those set in the "groups" section of this file. This can be left blank if you are using the group-table
            group-field:
            # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
            username-field: username
            # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
            additional-groups-field:
            # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
            banned-field:
            # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
            key-field: user_id
        # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
        profiletable:
            # Name of the custom profile fields table
            name: smf_custom_fields
            # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
            key-field: id_member
            # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
            minecraft-name-field:
        # This ONLY applies if you want to use a phpBB3 style group table
        grouptable:
            name: phpbb_user_group
            key-field: user_id
            group-field: group_id
    # Stick your database info here
    database:
        host: 'localhost'
        port: '3306'
        db: 'minecraft'
        user: 'root'
        pass: 'xxxx'
    # Which worlds on your server should Warrant affect the permissions for?
    worlds:
        - world
    # What you gonna tell peeps that aren't whitelisted? (PS, telling them to go and register on the forum would be a good idea. Telling them to #"@! off, would not)
    kick-message: 'Sorry, you are not permitted to login to the server at your current rank'
    # What you gonna tell peeps that are banned by your forum? (Telling these guys to #"@! off may actually be a good idea lol)
    banned-message: 'Sorry, you are not permitted to login to the server as you are banned'
    # Tell players that they've been assigned ranks when they login, or just do it silently in the background?
    notify-group-on-login: true
    # Keep out those who aren't in any group stated below (false), or shall we let them in and assign them to the default permissions group (true)?
    whitelist-default: true
    # Stick all the mappings here for any groups you wish tp be auto-ranked
    # Make sure to surround the number in single quotes (''), else it may just self-destruct and noone wants that
    # If "whitelisted" is false, then you may ommit the rank, as there will be no need to assign a rank to disallowed players
    # You must give a default group that can be assigned to those players that have been demoted from a higher rank to prevent them from keeping permissions they no longer have access to
    default-group: Member
    groups:
        '1':
            rank: Guest
            whitelisted: true
        '5':
            rank: Owner
            whitelisted: true
        '11':
            rank: Moderator
            whitelisted: true
        '13':
            rank: Constructer
            whitelisted: true
        '14':
            rank: Builder
            whitelisted: true
        '17':
            rank: Admin
            whitelisted: true
    

    XenForo (open)
    Code:
    forum:
        # Want to use information from a custom profile field instead of the user's forum username?
        multitable: false
        # Want to use a comma seperated list of additional groups to assign your member?
        use-additional-groups: false
        # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
        use-group-table: false
        # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
        use-boolean-ban: false
        # Bung in the info on where to look for the member data
        usertable:
            # Name of the member data table
            name: xf_user
            # Field to find the group id to match those set in the "groups" section of this file
            group-field: user_group_id
            # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
            username-field: username
            # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
            additional-groups-field:
            # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
            banned-field: is_banned
            # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
            key-field:
        # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
        profiletable:
            # Name of the custom profile fields table
            name:
            # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
            key-field:
            # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
            minecraft-name-field:
        # This ONLY applies if you want to use a phpBB3 style group table
        grouptable:
            name:
            key-field:
            group-field:
     
    # Stick your database info here
    database:
        host: '*HOST*'
        port: '3306'
        db: '*DATABSE*'
        user: '*USERNAME*'
        pass: '*PASSWORD*'
    # Which worlds on your server should Warrant affect the permissions for?
    worlds:
        - world
    # What you gonna tell peeps that aren't whitelisted? (PS, telling them to go and register on the forum would be a good idea. Telling them to #"@! off, would not)
    kick-message: 'Maintenance going on. Connect later.'
    # What you gonna tell peeps that are banned by your forum? (Telling these guys to #"@! off may actually be a good idea lol)
    banned-message: 'Sorry, you are not permitted to login to the server as you are banned'
    # Tell players that they've been assigned ranks when they login, or just do it silently in the background?
    notify-group-on-login: true
    # Keep out those who aren't in any group stated below (false), or shall we let them in and assign them to their default permissions group (true)?
    whitelist-default: true
    # Stick all the mappings here for any groups you wish tp be auto-ranked
    # Make sure to surround the number in single quotes (''), else it may just self-destruct and noone wants that
    # If "whitelisted" is false, then you may ommit the rank, as there will be no need to assign a rank to disallowed players
    # You must give a default group that can be assigned to those players that have been demoted from a higher rank to prevent them from keeping permissions they no longer have access to
    default-group: guest
    groups:
        # Here, normal registered members can go ahead and just join in as normal members
        '1':
            whitelisted: false
        '2':
            whitelisted: false
        '3':
            rank: admin
            whitelisted: true
        '4':
            rank: mod
            whitelisted: true
    

    Joomla and ccBoard (open)
    Warning! This one includes only the forum section! You will need to get the rest of the config from one above.


    What is new in version 2?
    This version has been completely written from scratch. It is extremely improved in performance, processing everything in a separate thread to avoid lag when someone logs in. Although this method waits for a non-whitelisted player to enter the game before kicking them, it does stop any lag from Warrant when anyone joins the game. You can now whitelist individual groups, and you can control which worlds Warrant alters Permissions in. You can also set Warrant to apply additional groups to players by looking into a comma separated list in of additional groups in one of your database fields. Please let me know if you want anything else from Warrant!

    What is new in version 3?
    Permissions support! Warrant now supports a large array of permissions plugins. Unfortunately because Warrant manipulates grouping of players, it means that it has to individually support the different plugins and the way that they change the player's groups, and since there is no standard here, I have to individually code in extra parts for any new permissions plugin that users want me to support, so please let me know if any more are wanted!

    Changelog

    4.0
    + Added support for the new Bukkit events system
    - Dropped support for Permissions 2.x
    - Dropped support for Permissions 3.x
    ~ Made some minor adjustments for speed and threading

    3.2
    ~ Fixed all the class not found errors

    3.1
    ~ Worked all the bugs out of using multiple permissions managers
    ~ Fixed most of the class not found errors

    3.0.4
    ~ After the trouble of getting my test server to work again, I can't even remember what I changed, but I remember adding something and fixing a few things lol)

    3.0.3
    ~ Checks Permissions version using string instead of double

    3.0.2
    ~ Compatible with CraftBukkit 1240
    ~ Fixed group naming (removed formatting for console)

    3.0.1
    ~ Compiled against JDK6
    ~ Fixed error with bPermissions

    3.0
    + Now works with bPermissions, PermissionsEx, Permissions 3 and partially (hopefully lol) Permissions 2
    + Requires a default-group node in the config to specify a group which a player should be assigned when they no longer get set by the forum to solve a security issue

    2.5
    ~ Fixed major security issue when players are demoted to the default group
    ~ Fixed spelling mistake and variable reference error when notifying additional groups

    2.4
    ~ Changed the getUserObject and getGroupObject methods to their safe counterparts to prevent an error for users who aren't registered in Permissions yet

    2.3.1
    ~ Fixed event register in onEnable to the correct event

    2.3
    ~ Changed event to player join instead of player login to avoid major error

    2.2.2
    + Check to see if Permissions world exists for worlds in the config

    2.2.1
    + Check to see if user has parent groups before trying to remove them

    2.2
    + Added phpBB3 functionality and the ability to set a separate table for group keys

    2.1
    + Added banning ability from forum table flag
    + Added on kick/on ban messages
    ~ Corrected an inverted boolean setting for whitelisting guests

    2.0
    ~ Complete recode of the plugin from scratch with efficiency at the heart of it
    ~ All Warrant processing is now threaded to prevent server lag when someone logs in
    + Added TONS of new features, most things that people had asked for from the new version

    Old Post (v1.2 and backward) (open)

    Go ahead and grab v1.2 for your server now...

    Download JAR: http://dl.dropbox.com/u/29840218/Warrant.jar
    Download MySQL Connector: http://dl.dropbox.com/u/29840218/mysql.jar

    Installation
    1. Place Warrant.jar in your plugins directory
    2. Place mysql.jar (the mysql java connector) into the root of your bukkit server, in the same folder as craftbukkit.jar
    3. Requires EssentialsGroupManager.jar! Add this to your plugins folder too, from the Essentials plugin suite.
    4. It is suggested to add EssentialsGroupBridge.jar too, since this will give more compatability with plugins that only talk to Permissions instead of GroupManager. Do NOT use Permissions.jar with this plugin!
    Configuration








    All configuration settings can be found in the auto-generated properties file, found in plugins/Warrant/warrant.properties


    IMPORTANT!

    You MUST create a "groups.properties" file in the plugins/Warrant folder!


    The groups.properties file takes the format of



    Code:
    #forum group id=GroupManager rank
    1=Admins
    2=Member
    Properties and explanations

    These are the properties needed to be set in the warrant.properties file...

    mysql-host - The MySQL server IP or URL

    mysql-port - Port of MySQL server (3306 by default)

    mysql-db - Database to find member data

    users-table - The table used for member data

    minecraftname-table - The OPTIONAL table used for extra data, where the user's minecraft username lies - perfect for forums that set "Minecraft username" as an additional profile field :) If left blank, the plugin will default to single table mode

    mysql-user - Name of MySQL User

    mysql-pass - Password for MySQL user

    minecraftname-field - The field which stores the user's minecraft player name. This is either on the specified table in "minecraftname-table", or it is in the default "users-table" if the former is left blank.

    group-field - The field that stores the group ids of users in "users-table"

    memberid-field - When in two table mode (see "minecraftname-table"), the field used to store the user's id in the "users-table" - used to join the two tables together

    minecraftname-table-memberid-field - When in two table mode (see "minecraftname-table"), the field used to store the user's id in the "minecraftname-table" - used to join the two tables together


    I took my own time to make this plugin and distribute it and would really appreciate a small donation if you find it useful :) Thank you!

    [​IMG]


    Any suggestions welcome!!

    Changelog
    • v1.2
      • Done my best to optimize the plugin in every way I can think and better error handling too
      • Updated for build 818
      • Stuck some code in ready for when Permissions add hooks to change groups. Waiting on the Permissions team now to be able to support their plugin
    • v1.1
      • Moved warrant giving method into it's own thread, therefore allowing a player to login with no lag caused by warrant to the server, and it will grant the warrant to the player when it's all finished. Max timeout of 1 minute
      • Added support to have the minecraft username on a seperate MySQL table, linked to the members' table through members' ID#s.
    • v1.0 alpha
      • Initial Release
    Want to whitelist players with forum groups instead? Use Albus
     
  2. Offline

    Ant59

    Well it shouldn't be throwing the exception at all, but I guess last resort I could just catch it.
     
  3. Offline

    strontkever

    i give up, i just dont want anyone to get demoted at all, no matter what ranks/groups exist or not

    but thanks for the effort srry :)
     
  4. Offline

    Aurayu

    Code:
    2011-10-12 17:27:53 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    2011-10-12 17:27:52 [SEVERE] 	... 3 more
    2011-10-12 17:27:52 [SEVERE] 	at java.lang.ClassLoader.loadClass(Unknown Source)
    2011-10-12 17:27:52 [SEVERE] 	at java.lang.ClassLoader.loadClass(Unknown Source)
    2011-10-12 17:27:52 [SEVERE] 	at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:24)
    2011-10-12 17:27:52 [SEVERE] 	at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:36)
    2011-10-12 17:27:52 [SEVERE] 	at java.net.URLClassLoader.findClass(Unknown Source)
    2011-10-12 17:27:52 [SEVERE] 	at java.security.AccessController.doPrivileged(Native Method)
    2011-10-12 17:27:52 [SEVERE] 	at java.net.URLClassLoader$1.run(Unknown Source)
    2011-10-12 17:27:52 [SEVERE] 	at java.net.URLClassLoader$1.run(Unknown Source)
    2011-10-12 17:27:52 [SEVERE] Caused by: java.lang.ClassNotFoundException: de.bananaco.permissions.worlds.WorldPermissionsManager
    2011-10-12 17:27:52 [SEVERE] 	at java.lang.Thread.run(Unknown Source)
    2011-10-12 17:27:52 [SEVERE] 	at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:84)
    2011-10-12 17:27:52 [SEVERE] 	at net.districtmine.warrant.WarrantPermissionsHandler.setGroup(WarrantPermissionsHandler.java:150)
    2011-10-12 17:27:52 [SEVERE] java.lang.NoClassDefFoundError: de/bananaco/permissions/worlds/WorldPermissionsManager
    2011-10-12 17:27:52 [SEVERE] Exception in thread "Thread-23" 
    2011-10-12 17:27:52 [INFO] [Warrant 3.1] Set group of Aurayu to Administrator
    2011-10-12 17:27:51 [INFO] New max size: 784
    2011-10-12 17:27:51 [INFO] New max size: 484
    2011-10-12 17:27:50 [INFO] [Warrant 3.1] Checking group for Aurayu
    Still seems to not like you, using Warrant 3.1, Bukkit 1240, will try latest bukkit to see if problem is still there
     
  5. Offline

    Daje

    I'm using phpBB, and trying to use multitable mode so I can pull the users minecraft username from the custom profile field in which they enter it. Does anyone know which tables I need to specify in the configuration file in order to do this?
     
  6. Offline

    patey

    @Daje

    i modded my phpbb forum to add an extra username field.
    i can link you to the forum where i got help doing that if you'd like
     
  7. Offline

    Daje

    Well what I need to know is what tables to use from my MySQL database, and I need to figure out where the "key-field" is (honestly I'm not sure what that means fully). I do have full access to my database though and can look at all the tables through phpbbmyadmin, I'm just not sure which tables go where in the Warrant configuration.
     
  8. Offline

    patey

    @Daje

    Code:
        forum:
            # Want to use information from a custom profile field instead of the user's forum username?
            multitable: true
            # Want to use a comma seperated list of additional groups to assign your member?
            use-additional-groups: true
            # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
            use-group-table: true
            # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
            use-boolean-ban: false
            # Bung in the info on where to look for the member data
            usertable:
                # Name of the member data table
                name: phpbb_users
                # Field to find the group id to match those set in the "groups" section of this file. This can be left blank if you are using the group-table
                group-field: group_id
                # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
                username-field: username
                # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
                additional-groups-field:
                # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
                banned-field:
                # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
                key-field: user_id
            # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
            profiletable:
                # Name of the custom profile fields table
                name: phpbb_profile_fields_data
                # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
                key-field: user_id
                # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
                minecraft-name-field: pf_minecraftusername      <---THIS IS CUSTOM PROFILE FIELD NAME!
    that should work
     
  9. Offline

    Sna.ke

    I'm also getting this error message when using RB 1317 and PEX:

    Code:
    12:53:41 [SEVERE] Exception in thread "Thread-2578"
    12:53:41 [SEVERE] java.lang.NoClassDefFoundError: de/bananaco/permissions/worlds/WorldPermissionsManager
    12:53:41 [SEVERE]       at net.districtmine.warrant.WarrantPermissionsHandler.setGroup(WarrantPermissionsHandler.java:150)
    12:53:41 [SEVERE]       at net.districtmine.warrant.WarrantProcess.putInDefault(WarrantProcess.java:25)
    12:53:41 [SEVERE]       at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:115)
    12:53:41 [SEVERE]       at java.lang.Thread.run(Thread.java:636)
    
     
  10. Offline

    Daje

    I don't know what happened, but now I'm getting the SQL syntax error again when I login.

    Code:
    2011-10-15 23:28:05 [INFO] DaJe [/192.168.1.1:59882] logged in with entity id 86 at ([world] 720.71875, 111.0, -520.875)
    2011-10-15 23:28:05 [INFO] [Warrant 3.1] Checking group for DaJe
    2011-10-15 23:28:06 [INFO] New max size: 484
    2011-10-15 23:28:06 [INFO] New max size: 784
    2011-10-15 23:28:06 [WARNING] [Warrant 3.1] Error at SQL Query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null ON (pwnbb_users.user_id = null.null) INNER JOIN pwnbb_profile_fields_data O' at line 1
    2011-10-15 23:28:06 [SEVERE] Exception in thread "Thread-30" 
    2011-10-15 23:28:06 [SEVERE] java.lang.NullPointerException
    2011-10-15 23:28:06 [SEVERE]     at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:59)
    2011-10-15 23:28:06 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    And this is my config file

    Code:
        forum:
            # Want to use information from a custom profile field instead of the user's forum username?
            multitable: true
            # Want to use a comma seperated list of additional groups to assign your member?
            use-additional-groups: true
            # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
            use-group-table: true
            # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
            use-boolean-ban: false
            # Bung in the info on where to look for the member data
            usertable:
                # Name of the member data table
                name: pwnbb_users
                # Field to find the group id to match those set in the "groups" section of this file. This can be left blank if you are using the group-table
                group-field: group_id
                # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
                username-field: username
                # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
                additional-groups-field:
                # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
                banned-field:
                # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
                key-field: user_id
            # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
            profiletable:
                # Name of the custom profile fields table
                name: pwnbb_profile_fields_data
                # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
                key-field: user_id
                # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
                minecraft-name-field: pf_minecraft
            # This ONLY applies if you want to use a phpBB3 style group table
            grouptable:
                name:
                key-field:
                group-field:
    
    What to do? :<
     
  11. Offline

    Ablac

    I know this adds rank but does this also remove the rank if there rank changes on the forum? Cause i know in permissionsEX you can have Multiple Ranks.

    I want to use this for my VIP to get Instant Access to VIP once they purcahse it but it only lasts for 30 days so it should also automatically remove it when the forum removes it.
     
  12. Offline

    Daje


    Also, so I edited my config file a little. I filled in the part where it says
    Code:
    # This ONLY applies if you want to use a phpBB3 style group table
    And now I get this error
    Code:
    2011-10-16 16:56:18 [INFO] DaJe [/192.168.1.1:56275] logged in with entity id 86 at ([world] 725.5, 118.0, -535.5)
    2011-10-16 16:56:18 [INFO] [Warrant 3.1] Checking group for DaJe
    2011-10-16 16:56:19 [INFO] [MineBackup] Performing delayed backup
    2011-10-16 16:56:19 [INFO] [MineBackup] Backup started
    2011-10-16 16:56:19 [INFO] [MineBackup] Starting backup...
    2011-10-16 16:56:19 [INFO] [MineBackup]  * world
    2011-10-16 16:56:19 [WARNING] [Warrant 3.1] Error at SQL Query: Column 'group_id' in field list is ambiguous
    2011-10-16 16:56:19 [SEVERE] Exception in thread "Thread-35" 
    2011-10-16 16:56:19 [SEVERE] java.lang.NullPointerException
    2011-10-16 16:56:19 [SEVERE]     at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:59)
    2011-10-16 16:56:19 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    And here's my config file as of now
    Code:
        forum:
            # Want to use information from a custom profile field instead of the user's forum username?
            multitable: true
            # Want to use a comma seperated list of additional groups to assign your member?
            use-additional-groups: true
            # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
            use-group-table: true
            # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
            use-boolean-ban: false
            # Bung in the info on where to look for the member data
            usertable:
                # Name of the member data table
                name: pwnbb_users
                # Field to find the group id to match those set in the "groups" section of this file. This can be left blank if you are using the group-table
                group-field: group_id
                # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
                username-field: username
                # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
                additional-groups-field:
                # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
                banned-field:
                # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
                key-field: user_id
            # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
            profiletable:
                # Name of the custom profile fields table
                name: pwnbb_profile_fields_data
                # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
                key-field: user_id
                # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
                minecraft-name-field: pf_minecraft
            # This ONLY applies if you want to use a phpBB3 style group table
            grouptable:
                name: pwnbb_user_group
                key-field: user_id
                group-field: group_id
     
  13. Offline

    patey

    @Daje
    besides
    2011-10-16 16:56:19 [WARNING] [Warrant 3.1] Error at SQL Query: Column 'group_id' in field list is ambiguous
    its a problem with warrant itself. i've been getting the same error since RB #1185
     
  14. Offline

    Ant59

    I know it's a Warrant problem. I don't have the time to fix it. Just give me a few days and I will try and solve the errors.
     
  15. Offline

    Daje

    Well damn. I'll be patient and wait, I'm fine with that. It's just nice to know that it's a problem with the plugin, so I at least know what's wrong, and it's really nice knowing that it's known and will be worked on. So all is well, I'll just wait until you can get around to it :)
     
  16. Offline

    jasvecht

    http://pastie.org/2711955 whats this?

    Edit:

    On startup :


    Code:
    17:04:40 [INFO] [Warrant 3.1] bPermissions version 1.7.5 loaded.
    17:04:40 [SEVERE] Error occurred while enabling Warrant v3.1 (Is it up to date?): PLAYER_CHANGED_WORLD
    java.lang.NoSuchFieldError: PLAYER_CHANGED_WORLD
            at net.districtmine.warrant.Warrant.onEnable(Warrant.java:57)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:920)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:173)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:156)
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:297)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:284)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:152)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    
     
  17. Offline

    Chano27

    Hey guys, I have a vBulletin forum and i have no idea on how to implement this plug-in and get it working on my forum. If anyone has any idea on the setting i have to use or if someone has a config.yml file that they have used and that worked for them, could you please let me see it or tell me how to set up mine. I would greatly appreciate this. Thanks guys :) This plug-in looks awesome BTW, @Ant59!
     
  18. Offline

    Christhirteen

    This is the error I receive..
    Something wrong with the data I entered? or is it something else..
     
  19. Offline

    ScarHunter

    Hey im getting this error...
    Code:
    161 recipes
    17 achievements
    >ModLoader Server Beta 1.8.1 Initializing...
    19:50:35 [INFO] ModLoader Server Beta 1.8.1 Initializing...
    >Mod Loaded: mod_BuildCraftBuilders 2.2.1
    19:50:35 [INFO] Mod Loaded: mod_BuildCraftBuilders 2.2.1
    >Mod Loaded: mod_BuildCraftCore 2.2.1
    19:50:35 [INFO] Mod Loaded: mod_BuildCraftCore 2.2.1
    >Mod Loaded: mod_BuildCraftEnergy 2.2.1
    19:50:35 [INFO] Mod Loaded: mod_BuildCraftEnergy 2.2.1
    >Mod Loaded: mod_BuildCraftFactory 2.2.1
    19:50:35 [INFO] Mod Loaded: mod_BuildCraftFactory 2.2.1
    >Mod Loaded: mod_BuildCraftTransport 2.2.1
    19:50:35 [INFO] Mod Loaded: mod_BuildCraftTransport 2.2.1
    >Done.
    19:50:35 [INFO] ModLoaderMP Beta 1.8.1 Initialized
    >ModLoaderMP Beta 1.8.1 Initialized
    Adding Material: 4056:X4056
    Adding Material: 4057:X4057
    Adding Material: 4058:X4058
    Adding Material: 4059:X4059
    Adding Material: 4060:X4060
    Adding Material: 4062:X4062
    Adding Material: 4061:X4061
    Adding Material: 154:X154
    Setting material 154 name: markerBlock
    Adding Material: 154:MARKERBLOCK
    Adding Material: 155:X155
    Setting material 155 name: fillerBlock
    Adding Material: 155:FILLERBLOCK
    Adding Material: 157:X157
    Setting material 157 name: builderBlock
    Adding Material: 157:BUILDERBLOCK
    Adding Material: 158:X158
    Setting material 158 name: templateBlock
    Adding Material: 158:TEMPLATEBLOCK
    Adding Material: 161:X161
    Adding Material: 162:X162
    Setting material 162 name: oil
    Adding Material: 162:OIL
    Setting material 162 name: oilMoving
    Adding Material: 162:OILMOVING
    Adding Material: 163:X163
    Setting material 163 name: oil
    Setting material 163 name: oilStill
    Adding Material: 163:OILSTILL
    Adding Material: 4063:X4063
    Adding Material: 4064:X4064
    Adding Material: 4066:X4066
    Adding Material: 150:X150
    Setting material 150 name: miningWellBlock
    Adding Material: 150:MININGWELLBLOCK
    Adding Material: 151:X151
    Setting material 151 name: plainPipeBlock
    Adding Material: 151:PLAINPIPEBLOCK
    Adding Material: 152:X152
    Setting material 152 name: autoWorkbenchBlock
    Adding Material: 152:AUTOWORKBENCHBLOCK
    Adding Material: 160:X160
    Setting material 160 name: frameBlock
    Adding Material: 160:FRAMEBLOCK
    Adding Material: 153:X153
    Setting material 153 name: machineBlock
    Adding Material: 153:MACHINEBLOCK
    Adding Material: 165:X165
    Setting material 165 name: tankBlock
    Adding Material: 165:TANKBLOCK
    Adding Material: 164:X164
    Setting material 164 name: pumpBlock
    Adding Material: 164:PUMPBLOCK
    Adding Material: 167:X167
    Setting material 167 name: refineryBlock
    Adding Material: 167:REFINERYBLOCK
    Adding Material: 4065:X4065
    Adding Material: 166:X166
    Adding Material: 4306:X4306
    Adding Material: 4307:X4307
    Adding Material: 4308:X4308
    Adding Material: 4309:X4309
    Adding Material: 4310:X4310
    Adding Material: 4311:X4311
    Adding Material: 4312:X4312
    Adding Material: 4313:X4313
    Adding Material: 4314:X4314
    Adding Material: 4315:X4315
    Adding Material: 4316:X4316
    Adding Material: 4317:X4317
    Adding Material: 4320:X4320
    Adding Material: 4322:X4322
    Adding Material: 4324:X4324
    Adding Material: 145:X145
    Adding Material: 146:X146
    Adding Material: 147:X147
    Adding Material: 148:X148
    Adding Material: 149:X149
    Adding Material: 156:X156
    Adding Material: 159:X159
    19:50:35 [INFO] Starting minecraft server version Beta 1.8.1
    19:50:35 [INFO] Loading properties
    19:50:35 [INFO] Starting Minecraft server on *:25565
    19:50:35 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-1126
    -g35eac7a-b1317jnks (MC: 1.8.1)
    19:50:36 [INFO] [Permissions] (Yeti) was initialized.
    19:50:36 [INFO] [Permissions] version [3.1.6] (Yeti)  loaded
    19:50:36 [INFO] Preparing level "world"
    19:50:36 [INFO] Default game type: 0
    19:50:36 [INFO] Preparing start region for level 0 (Seed: -2881393836223572083)
    19:50:36 [INFO] Preparing start region for level 1 (Seed: -2881393836223572083)
    19:50:37 [INFO] Preparing spawn area: 77%
    19:50:37 [INFO] ----------------------------------
    19:50:37 [INFO] |  Buycraft version 2.7 enabled! |
    19:50:37 [INFO] ----------------------------------
    19:50:37 [INFO] Loaded Essentials build 2.6.3 by: Zenexer, ementalo, Aelux, Bret
    tflan, KimKandor, snowleo, ceulemans, Xeology, KHobbits
    19:50:37 [INFO] Essentials: Using Permissions 3 based permissions.
    19:50:37 [INFO] [Warrant 3.1] Permissions version 3 loaded.
    19:50:37 [INFO] [Warrant 3.1] Enabled
    19:50:37 [INFO] [iChat] Found Permissions v3.1.6
    19:50:37 [INFO] iChat (v2.4.3) enabled
    19:50:37 [INFO] Server permissions file permissions.yml is empty, ignoring it
    19:50:37 [INFO] Done (0.157s)! For help, type "help" or "?"
    19:50:37 [INFO] New max size: 484
    19:50:37 [INFO] New max size: 784
    19:50:53 [INFO] ScarHunter [/68.9.72.145:59465] logged in with entity id 484 at
    ([world] 58.73611530637835, 12.0, -12.041364262617723)
    19:50:53 [INFO] [Warrant 3.1] Checking group for ScarHunter
    19:50:54 [WARNING] [Warrant 3.1] SQLException! Access denied for user 'mbbender_
    minec'@'localhost' (using password: YES)
    19:50:54 [SEVERE] Exception in thread "Thread-44"
    19:50:54 [SEVERE] java.lang.NullPointerException
    19:50:54 [SEVERE]       at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery
    (DatabaseHandler.java:77)
    19:50:54 [SEVERE]       at net.districtmine.warrant.WarrantSql.sqlQuery(WarrantS
    ql.java:28)
    19:50:54 [SEVERE]       at net.districtmine.warrant.WarrantProcess.run(WarrantPr
    ocess.java:57)
    19:50:54 [SEVERE]       at java.lang.Thread.run(Unknown Source)
    19:50:54 [INFO] ScarHunter joined with mod_BuildCraftCore 2.2.1, mod_BuildCraftB
    uilders 2.2.1, mod_BuildCraftEnergy 2.2.1, mod_BuildCraftFactory 2.2.1, mod_Buil
    dCraftTransport 2.2.1
    19:50:54 [INFO] ScarHunter joined with mod_BuildCraftCore 2.2.1, mod_BuildCraftB
    uilders 2.2.1, mod_BuildCraftEnergy 2.2.1, mod_BuildCraftFactory 2.2.1, mod_Buil
    dCraftTransport 2.2.1
    19:50:57 [INFO] MinecraftForge V
    19:50:57 [INFO] 1
    19:50:57 [INFO] .
    19:50:57 [INFO] 1
    19:50:57 [INFO] .
    19:50:57 [INFO] 1
    19:50:57 [INFO]  Initialized
    
    >
    How do I fix?
     
  20. Offline

    jeremytrains

    Hey, does anybody use this with an Enjin? I need to know how to get access to the Enjin database? Anybody know how?
     
  21. Offline

    Daje

    It looks like you're having as issue connecting to your SQL database. Are you sure you entered in all of the database connection information properly? Go over and make sure your password and everything is right.
     
  22. Offline

    mnpeep

    anyone know how to set up the config file for myBB?

    EDIT:

    I did it! heres mine:

    Code:
    # Want to use information from a custom profile field instead of the user's forum username?
        multitable: true
        # Want to use a comma seperated list of additional groups to assign your member?
        use-additional-groups: false
        # Bung in the info on where to look for the member data
        usertable:
            name: mc_users
            group-field: usergroup
            username-field: username
            key-field: uid
        # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
        profiletable:
            name: mc_userfields
            key-field: uid
            minecraft-name-field: fid4
    
    # Stick your database info here
    database:
        host: 'bleh'
        port: '3306'
        db: 'minecraft'
        user: 'root'
        pass: 'xxxx'
    # Which worlds on your server should Warrant affect the permissions for?
    worlds:
        - tinykraft
        - tinykraft_nether
    # What you gonna tell peeps that aren't whitelisted? (PS, telling them to go and register on the forum would be a good idea. Telling them to #"@! off, would not)
    kick-message: 'Sorry, you need to be registered at www.TinyKraft.cu.cc in order to play!'
    # What you gonna tell peeps that are banned by your forum? (Telling these guys to #"@! off may actually be a good idea lol)
    banned-message: 'The Banhammer has spoken! Appeal at www.TinyKraft.cu.cc'
    # Tell players that they've been assigned ranks when they login, or just do it silently in the background?
    notify-group-on-login: false
    # Keep out those who aren't in any group stated below (false), or shall we let them in and assign them to the default permissions group (true)?
    whitelist-default: false
    # Stick all the mappings here for any groups you wish tp be auto-ranked
    # Make sure to surround the number in single quotes (''), else it may just self-destruct and noone wants that
    # If "whitelisted" is false, then you may ommit the rank, as there will be no need to assign a rank to disallowed players
    # You must give a default group that can be assigned to those players that have been demoted from a higher rank to prevent them from keeping permissions they no longer have access to
    default-group: Guest
    groups:
        '1':
            rank: Guest
            whitelisted: true
        '2':
            rank: User
            whitelisted: true
        '3':
            rank: Trusted
            whitelisted: true
        '4':
            rank: Admin
            whitelisted: true
        '6':
            rank: Mod
            whitelisted: true
        '8':
            rank: Head_Mod
            whitelisted: true
        '9':
            rank: Baby_Mod
            whitelisted: true
        '10':
            rank: Special
            whitelisted: true
        '11':
            rank: Donator
            whitelisted: true
            
     
  23. Offline

    BOSS302DK

    Is there a way to make warrant, work with GroupManager? :'(
     
  24. Offline

    mnpeep

    I'm getting this error for some reason on bukkit: 1337

    2011-10-24 14:42:41 [WARNING] [Warrant 3.1] SQLException! Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-10-24 14:42:41 [SEVERE] Exception in thread "Thread-10363"
    2011-10-24 14:42:41 [SEVERE] java.lang.NullPointerException
    2011-10-24 14:42:41 [SEVERE] at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler.java:77)
    2011-10-24 14:42:41 [SEVERE] at net.districtmine.warrant.WarrantSql.sqlQuery(WarrantSql.java:28)
    2011-10-24 14:42:41 [SEVERE] at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:57)
     
  25. Offline

    Ant59

    IT'S ALL FIXED AND WORKING :) Just tested out Warrant 3.2 on the large JRNetwork.net server and everything is working perfectly with PermissionsEx as the perms handler :) Enjoy!
     
  26. Offline

    jasvecht

    Hey Ant,

    Recently been getting these with latest CB, Warrant 3.1 AND 3.2. Still using the same permissions handler (bPerms) that worked before without updating it:

    Code:
    00:33:34 [INFO] [Warrant 3.2] Checking group for scoobydoo22
    00:33:34 [SEVERE] Exception in thread "Thread-65"
    00:33:34 [SEVERE] java.lang.NoSuchMethodError: com.alta189.sqlLibrary.MySQL.DatabaseHandler.<init>(Lnet/districtmine/warrant/WarrantSql;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
    00:33:34 [SEVERE]       at net.districtmine.warrant.WarrantSql.initialize(WarrantSql.java:23)
    00:33:34 [SEVERE]       at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:32)
    00:33:34 [SEVERE]       at java.lang.Thread.run(Unknown Source)
    00:33:34 [INFO] [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 0
    00:33:35 [INFO] JStriedl [/****:3648] logged in with entity id 560 at ([Survival] -18.4375, 66.0, 60.90625)
    00:33:35 [INFO] [Warrant 3.2] Checking group for JStriedl
    00:33:35 [SEVERE] Exception in thread "Thread-71"
    00:33:35 [SEVERE] java.lang.NoSuchMethodError: com.alta189.sqlLibrary.MySQL.DatabaseHandler.<init>(Lnet/districtmine/warrant/WarrantSql;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
    00:33:35 [SEVERE]       at net.districtmine.warrant.WarrantSql.initialize(WarrantSql.java:23)
    00:33:35 [SEVERE]       at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:32)
    00:33:35 [SEVERE]       at java.lang.Thread.run(Unknown Source)
    00:33:35 [INFO] [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 0
    
     
  27. Offline

    Waffletastic

    @Ant59 Does this support IPB?
     
  28. Offline

    Ant59

    Will look into it tomorrow, but it seems like you're using another plugin that uses a different version of the sqlLibrary.

    Yes, very well :) We've hooked it up with IPB really well on JRNetwork.net
     
  29. Offline

    Daje

    Does this work fine with phpBB now? Can someone help me configure this for phpBB? As stated before, I'm trying to use the multitable approach, so it'll look at the users Minecraft username in their profile in the custom profile field, and automatically assign them to the right group on the Minecraft server (if they don't have it filled out, they're in the Default group, and if they do, they're in the Builder group).

    Actually though, I would be willing to set this up so it matches the phpBB user groups to the Minecraft server user groups instead. So that way, I can put someone into a Builder group on phpBB and have them be a builder on Minecraft or something.


    I'm really fine with configuring it any way. I just want some way to link my Minecraft users to my phpBB users, and I need help.
     
  30. Offline

    jasvecht

    Could be, I use quite a few SQL plugins.


    And I use IPB as well :)
     
  31. Offline

    patey

    does it work with the 1.9 build?
     

Share This Page