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

    Daje

    I just set this all up, and tried logging into my server just to test things out, and I got this error.

    Code:
    [INFO] DaJe [/192.168.1.1:62502] logged in with entity id 161 at ([world] -83.9375, 99.0, -181.09375)
    2011-08-15 20:12:57 [INFO] [Warrant 2.5] Detected login of DaJe
    2011-08-15 20:12:57 [INFO] CommandBook: No intro.mid; not playing intro song.
    2011-08-15 20:12:58 [SEVERE] [Warrant 2.5 SQL] 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-08-15 20:12:58 [SEVERE] [Warrant 2.5 SQL] 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-08-15 20:12:58 [SEVERE] Exception in thread "Thread-31" 
    2011-08-15 20:12:58 [SEVERE] java.lang.NullPointerException
    2011-08-15 20:12:58 [SEVERE]     at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler.java:86)
    2011-08-15 20:12:58 [SEVERE]     at net.districtmine.warrant.WarrantSql.sqlQuery(WarrantSql.java:31)
    2011-08-15 20:12:58 [SEVERE]     at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:61)
    2011-08-15 20:12:58 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    And I have no idea what to do, or what the problem could be.
     
  3. Offline

    Niemand

    Code:
    13:36:51 [WARNING] [Warrant 2.5] Error in the config! The world Freebuildworld1 may exist, but it has no Permissions loaded.
    13:36:51 [WARNING] [Warrant 2.5] Error in the config! The world Fablecraftwelt01 may exist, but it has no Permissions loaded.
    
    i thought i posted this before but: what is that? what does it want? can i just feed some griefers to it to make it quiet?

    it appears everytime when somebody logs in now. - i guess it also crashes my server and brings up some "out of ressources"-messages.
     
  4. Offline

    Butchey

    First, i want to thank you for this awesome Plugin! (;
    But i have the same problem like some other peoples above me in this thread.
    The config.yml is to 100% correct.
    Here is the Error:
    Code:
    2011-08-17 14:34:09 [INFO] Butchey [/77.184.224.138:51820] logged in with entity id 532 at ([world] -396.875, 77.5, -726.0625)
    2011-08-17 14:34:09 [INFO] [Warrant 2.5] Detected login of Butchey
    2011-08-17 14:34:09 [WARNING] [Warrant 2.5 SQL] 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 'INNER JOIN phpbb_profile_fields_data ON (phpbb_users.null = phpbb_profile_fields' at line 1
    2011-08-17 14:34:09 [SEVERE] Exception in thread "Thread-158"
    2011-08-17 14:34:09 [SEVERE] java.lang.NullPointerException
    2011-08-17 14:34:09 [SEVERE]     at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:63)
    2011-08-17 14:34:09 [SEVERE]     at java.lang.Thread.run(Thread.java:636)
    And here is my config.yml:
    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: 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:
        # 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_minecraftname
        # 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: 'board'
        user: 'root'
        pass: 'snipped'
    # 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
    groups:
        '5':
            rank: Fulladmin
            whitelisted: true
    
    Other Plugins on this Server:
    - WorldGuard
    - WorldEdit
    - VanishNoPickup
    - TNTFireworks
    - SimpleColoredChat
    - PickBoat
    - Permissions 3.1.6 Yeti (MySQL)
    - LagMeter
    - iConomy (MySQL)
    - Essentials
    - dynmap
    - CraftBook
    - Citizens
    - BlocksOnGlass

    If you'll / can fix this, i will enjoy to donate for you.
    Greets from Butchey @ Germany :)
     
  5. Offline

    Daje

    Well, I found out what my previous problem was, but now that it's taken care of, I'm running into another issue.

    Code:
    06:26:16 [WARNING] [Warrant 2.5 SQL] 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 'INNER JOIN pwnbb_profile_fields ON (pwnbb_users.user_id = pwnbb_profile_fields.m' at line 1
    2011-08-18 06:26:16 [SEVERE] Exception in thread "Thread-49" 
    2011-08-18 06:26:16 [SEVERE] java.lang.NullPointerException
    2011-08-18 06:26:16 [SEVERE]     at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:63)
    2011-08-18 06:26:16 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    
     
  6. Offline

    alfskan

    I use

    1. Windows7 64bit, APM, UTF-8 mysqlDB.

    2. another local BBS.(using UTF-8 mysqlDB)

    3. PermissionsEx

    Can I use it?
     
  7. Offline

    Niemand

    server crashes around 2 times ad day. No other plugin gives out any errors.
     
  8. Offline

    alfskan

    can I suggest another plugin that uses forumDB?

    I use points in my forum that involved with forum rank.

    I always think how about connecting forum points with iConomy.

    Means Players can buy forum points with iConomy currency.

    Is it possible idea?
     
  9. Offline

    Niemand

    I got forum-currency. and I got inGame-currency. ppl get money thru posts... and killing monsters. I just need a way to connect it. atm its two different worths. I would need one. :(

    but thats not the topic here.
     
  10. Offline

    Hacr

    How would this work with XenForo ?
     
  11. Offline

    alfskan

    I have some prob.

    My DB looks like this :

    1. member table - contains fields 'user_id', 'nick_name', 'user_number'

    2. groupset table - contains 'group_name', 'group_number'

    3. grouping table - contains 'group_number', 'user_number', 'recently_changed'

    How can I setup with current config?

    There is no custom profile.

    And all tables are connected with number.

    So I cant hook minecraft`s name from anywhere.
    (It could be a user_id, but grouping table doesnt contain that)

    Here is my config.yml
    Code:
    forum:
        multitable: false
        use-additional-groups: false
        use-group-table: true
        use-boolean-ban: false
        usertable:
            name: member
            group-field: (not exists)
            username-field: user_id
            additional-groups-field:
            banned-field:
            key-field:
    
        profiletable:
            name:
            key-field:
            minecraft-name-field:
    
        grouptable:
            name: grouping
            key-field: user_number
            group-field: group_number
    And attaching grouping table.
    (group_srl=group_number, member_srl=user_number, regdate=recently_changed)

    [​IMG]
     
  12. Offline

    Jombi

    Here's part of my config file:
    Code:
    # Stick your database info here
    database:
        host: '***.com'
        port: '3306'
        db: '***_ipb'
        user: '***_ipb'
        pass: '****'
    This is what I get when someone logs into the server:
    Code:
    2011-08-21 15:27:38 [SEVERE] [Warrant 2.5 SQL] SQLException! Access denied for user '***_ipb'@'108.60.193.14' (using password: YES) 2011-08-21 15:27:38 [SEVERE] [Warrant 2.5 SQL] SQLException! Access denied for user '***_ipb'@'108.60.193.14' (using password: YES) 2011-08-21 15:27:38 [SEVERE] Exception in thread "Thread-75"  2011-08-21 15:27:38 [SEVERE] java.lang.NullPointerException 2011-08-21 15:27:38 [SEVERE] 	at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler.java:86) 2011-08-21 15:27:38 [SEVERE] 	at net.districtmine.warrant.WarrantSql.sqlQuery(WarrantSql.java:31) 2011-08-21 15:27:38 [SEVERE] 	at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:61) 2011-08-21 15:27:38 [SEVERE] 	at java.lang.Thread.run(Unknown Source)
    I don't know the IP that shows up there. Its neither my server ip, nor the IP of my webserver. I've tried changing the "host" part of my database connection, but no matter what I change it to, I still get the same IP in the error.
     
  13. Offline

    thernztrom

    How does this work, does it change a users rank within Permissions? :)
    If so, what Permissions plugins does it support? PermissionsEx?
     
  14. Offline

    Cosmic Break

    does this work with permissionsbukkit?
     
  15. Offline

    Niemand

    still :(
     
  16. Offline

    Daje

    I'm still getting an SQL error for my SQL syntax. I'm not sure if it's because I put in the wrong tables or what.
     
  17. Offline

    SovHed

    I am also getting this error, which is extremely sad because I would dearly love this plugin. My Error is the same as others have had but I will provide it anyway:
    Code:
    2011-08-28 03:34:50 [WARNING] [Warrant 2.5 SQL] 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 'WHERE username = 'Emperor_Katurgu'' at line 1
    2011-08-28 03:34:50 [SEVERE] Exception in thread "Thread-69"
    2011-08-28 03:34:50 [SEVERE] java.lang.NullPointerException
    2011-08-28 03:34:50 [SEVERE] 	at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:63)
    2011-08-28 03:34:50 [SEVERE] 	at java.lang.Thread.run(Thread.java:722)
    I've tried looking at it some but I'm confused, as far as I know my config is good

    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: 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: 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: '****'
        port: '3306'
        db: '****'
        user: '****'
        pass: '****'
    # 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: 'Please Register with your MineCraft Username at www.sev3ria.com'
    # 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
    groups:
        '9':
            rank: Member
            whitelisted: true
        '8':
            rank: Donor
            whitelisted: true
    SQL Connects fine and all looks good until someone joins. :(
     
  18. Offline

    Daje

    I'm thinking maybe this mod isn't fully compatible with phpBB. All the errors people keep having are all the same, and all from people trying to use this mod with phpBB and multitables. Or everyone is just doing it wrong. Is there anyone here with the latest version of phpBB using this mod successfully with multitables?
     
  19. Offline

    Taranis01

    @Ant59
    hey :)
    may i ask if you will add Superperms support?
     
  20. Offline

    cyberjacob

    this would be great if you could!
     
  21. Offline

    Nazerb

    Does this work with bukkit perms?
     
  22. Offline

    Ablac

    I am currently using XenForo and am wondering if anyone know how to make the config for Warrant connect to XenForo.

    Also if anyone knows of a mod for XenForo that put a Minecraft Username section when you register that would be awesome :)

    Thanks for your help :p
     
  23. Offline

    Chojin

    Just test this for XenForo:
    I only pasted the forum section.

    +1

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 15, 2016
  24. Offline

    Ablac

    MYSQL Max_Allowed_Packet error, is there any way around this cause im using a Hosting servers that limits it to 1MB, and i am trying to get them to change it but it isn't going well. Currently Warrant is trying to use 3MB when a player logs in.

    There any way to get this number down without losing the features?
    We tried changing query_cache_limit but i dont think that will work :(
    Code:
    2011-09-12 14:21:23 [INFO] [Warrant 2.5] Detected login of ablac 2011-09-12 14:21:23 [SEVERE] [Warrant 2.5 SQL] SQLException! Packet for query is too large (3158578 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. 2011-09-12 14:21:24 [SEVERE] [Warrant 2.5 SQL] SQLException! Packet for query is too large (3158578 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. 2011-09-12 14:21:24 [SEVERE] Exception in thread "Thread-118729"  2011-09-12 14:21:24 [SEVERE] java.lang.NullPointerException 2011-09-12 14:21:24 [SEVERE] 	at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler.java:86) 2011-09-12 14:21:24 [SEVERE] 	at net.districtmine.warrant.WarrantSql.sqlQuery(WarrantSql.java:31) 2011-09-12 14:21:24 [SEVERE] 	at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:61) 2011-09-12 14:21:24 [SEVERE] 	at java.lang.Thread.run(Unknown Source)
     
  25. Offline

    Daje

    I'm still having the same SQL syntax error using phpBB3. Can anyone help?
     
  26. Offline

    Ablac

    IM getting this error everytime somebody joins
    Code:
    2011-09-13 20:59:16 [INFO] [Warrant 2.5] Detected login of Ablac
    2011-09-13 20:59:16 [SEVERE] [Warrant 2.5 SQL] SQLException! Packet for query is too large (3158578 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
    2011-09-13 20:59:16 [SEVERE] [Warrant 2.5 SQL] SQLException! Packet for query is too large (3158578 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
    2011-09-13 20:59:16 [SEVERE] Exception in thread "Thread-327321"
    2011-09-13 20:59:16 [SEVERE] java.lang.NullPointerException
    2011-09-13 20:59:16 [SEVERE] 	at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler.java:86)
    2011-09-13 20:59:16 [SEVERE] 	at net.districtmine.warrant.WarrantSql.sqlQuery(WarrantSql.java:31)
    2011-09-13 20:59:16 [SEVERE] 	at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:61)
    2011-09-13 20:59:16 [SEVERE] 	at java.lang.Thread.run(Unknown Source)
    
     
  27. Offline

    Ablac

    This gana be updated for 1.8? cause im getting a lot of errors.
     
  28. Offline

    Ant59

    I may do if I get some spare time. Once there's a stable 1.8, I think I may have to update it.

    Only problem is I can't find my source code :(

    All working perfectly fine with the latest 1.8 build (CB #1130).

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 15, 2016
  29. Offline

    ShaDooM

    Code:
    11:04:02 [INFO] [Warrant 2.5] Detected login of asiabunny
    11:04:02 [SEVERE] Exception in thread "Thread-2979"
    11:04:02 [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
    11:04:02 [SEVERE]       at net.districtmine.warrant.WarrantSql.initialize(WarrantSql.java:25)
    11:04:02 [SEVERE]       at net.districtmine.warrant.WarrantProcess.run(WarrantProcess.java:38)
    11:04:02 [SEVERE]       at java.lang.Thread.run(Thread.java:662)
    
    im getting that, whats up with that?

    edit: does it really only work with permissions 3.1.6 ? *Sadface*
     
  30. Offline

    Ant59

    No idea how you've gotten that error. I may release a new version sometime next week and try to fix everything. It only works with Permissions 3.1.6, yes. It was the only Permissions plugin that was widely used at the time I wrote 2.0. Warrant started off using only GroupManager.
     
  31. Offline

    jasvecht

    Woah, you are alive after all!

    So, ever going to give us the joy of BukkitPerms? Or perhaps a source code? (A) I promise I wouldn't call it "Tnarraw - The Secure and Efficient Plugin for bridging forums"
     

Share This Page