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

    dfdgsdfg

  3. Offline

    Phinary

    Awesome plugin. Please keep it updated :p
     
  4. Offline

    Jamie Tees

    Hey man,

    Will you be able to get a fixed version out for 1.6 as soon as the recommended build is out due to the fact we now rely on this plugin :D
    Thanks,
    Jamie
     
  5. Offline

    Xelatyper

    Any help here, I am looking forward to this working it is just what I need, I get this error.

    I am using SMF forum so.

    MYSQL Connection Failed

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-05-26 23:42:33 [WARNING] [Warrant] v1.1 - The following statement failed: SELECT smf_members.id_group FROM smf_members INNER JOIN ON (smf_members.id_member = smf_members.id_member AND member_name = 'Laserspewpew')
    2011-05-26 23:42:33 [WARNING] [Warrant] v1.1 - Statement failed: java.lang.NullPointerException
    2011-05-26 23:42:33 [SEVERE] [Warrant] v1.1 - Warrant not issued! Warrant's authorisation thread was killed!
    2011-05-26 23:42:33 [SEVERE] [Warrant] v1.1 - java.lang.NullPointerException
    2011-05-26 23:42:33 [SEVERE] java.lang.NullPointerException
    2011-05-26 23:42:33 [SEVERE] at net.districtmine.warrant.Warrant$AuthoriseWarrant.run(Warrant.java:99)
    2011-05-26 23:42:33 [SEVERE] at java.lang.Thread.run(Unknown Source)
    2011-05-26 23:42:33 [INFO] [Warrant] v1.1 - Warrant processed
    2011-05-26 23:42:33 [INFO] Laserspewpew [/69.207.181.115:4975] logged in with entity id 52 at (74.5, 71.62000000476837, 22.5)


    This is the config. Blocked out personal details

    #Automatically generated config file
    #Thu May 26 10:56:26 CEST 2011
    group-field=id_group
    minecraftname-field=member_name
    mysql-port=3306
    mysql-db=*******
    mysql-user=********
    minecraftname-table=
    minecraftname-table-memberid-field=
    mysql-pass=*********
    mysql-host=db2715.oneandone.co.uk
    users-table=smf_members
    memberid-field=id_member

    Hope someone can help xD thanks
     
  6. Offline

    Jamie Tees

    It seems that either the querey is incorrect or the tables selected in the config are incorrect. I know V1.1 has more bugs than 1.0 - Ant will be releasing a new version for 1.6 soon :D
     
  7. Offline

    jasvecht

    Hey Ant! Found your plugin by coincidence :D Good job mate, good luck developing it. If I wouldn't be using Permissions.... :p

    Brilliant, just brilliant.
     
  8. Am getting the same error, Its only putting users in the group I define 9

    So If my forum group is 5 (admin) I should be added to group admins by the settings in groups.properties 5=Admins but am getting put into group 9=Member.

    Settings

    Code:
    #Automatically generated config file
    #Fri May 27 07:23:46 MDT 2011
    mysql-port=3306
    mysql-db=**
    mysql-user=**
    mysql-pass=**
    mysql-host=**
    
    users-table=phpbb_users
    memberid-field=user_id
    group-field=group_id
     
    minecraftname-table=phpbb_profile_fields_data
    minecraftname-table-memberid-field=user_id
    minecraftname-field=pf_minecraftname
    Code:
      
    #forum group id=GroupManager rank
    1=Guest
    2=Member
    4=Mods
    5=Admins
    7=Guest
    8=Member
    9=Member
    10=Member
     
  9. Offline

    Kalman Olah

    You're getting the error because Warrant 1.1 is broken. The author, Ant59 plans to release a version for minecraft v. 1.6.x when Bukkit is updated.

    You can use this version, specifically made for phpBB3, in the meantime.
    <Edit by Moderator: Redacted mediafire url>
    You'll have to delete your warrant.properties and let it create a new one.
    <font color="rgb(255, 0, 0)">Please note that this is a modification of Warrant 1.0, and as such is missing the performance updates included with 1.1
    </font>
     
    Last edited by a moderator: Dec 14, 2016
  10. Ty ill use that till ant has updated
     
  11. Offline

    Dr Danco

    would this work with phpbb?
    also do i have to have an sql server? my server is flatfile...havent figured out the sql thing yet lolz
    thanks in advance!
     
  12. Offline

    Kalman Olah

    Ofcourse it works with phpBB, it works with any type of forum. As for the SQL, the config file is used to connect to your forum's SQL database, which you MUST have if you're running phpBB.
     
  13. Offline

    NeatMonster

    Can you add subgroups support please?
     
  14. Offline

    grapeman

    THANK YOU! i've been looking for a plugin like this for a long time! i've perviously been using your albus plugin (which is also amazing) but now look foward to using warrant :)
     
  15. Offline

    Lucke1234

    Hi, please add a feature I can select the SQL-code itself. Like the option: my-sql-select=SELECT `group` FROM `users` WHERE `username` = '{user}'
     
  16. Offline

    Ant59

    Since the Bukkit team are working on a build for 1.6.6 now, hopefully if it gets promoted to recommended, the tonight I will work to release a version of Warrant for 1.6.6 that WORKS :) Thanks to everyone so far who has helped me test out the plugin and find bugs etc :)
     
  17. Offline

    Ant59

    Updated! :)

    Now works with b818. Optimized and better error handling.
     
  18. Offline

    NeatMonster

    UP :D.
     
  19. Offline

    Zottelchen

    can you please make it permissions-friendly? i dont have / want groupmanager...
     
  20. Offline

    Ant59

    I'm really trying, but there is no simple way to set group in the new Permissions. It's as if they've left out that one function from their API :S

    I need Permissions support too, so this will be done ASAP.

    Also, as for subgroups. that only applies to GroupManager afaik, and I'll try to add them, but no promises.
     
  21. Offline

    NeatMonster

    Thanks!
     
  22. Offline

    Jamie Tees

    Ant was using my server to bug test the new build, we were up till 3 in the morning :D Finally works perfect :D

    Thanks again ant your awesome
     
    Ant59 likes this.
  23. Offline

    registered

    Wonder if there is a config file for myBB?

    Ah I don't think this plugin does what I need. I think a great feature would be to make this read the password and username form the forum SQL and let you log into minecraft with the same user and password.

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

    Ant59

    How on Earth do you suppose anyone achieves that!? That's impossible since minecraft.net authenticates every login, not your personal server unless you mod the client. And I'm pretty sure none of your users want to mod their client so they have to login to your server to play minecraft, also preventing them from playing on anyone else's.

    However, yes it's perfectly simple to write the config file for myBB if you so wish. Warrant let's you sync user groups, not setup a private server with a hacked client.
     
  25. Offline

    registered

  26. Offline

    Jamie Tees

    Interesting plugin, although I prefer warrant, Easier :D
     
  27. Offline

    registered

    I'm just saying I would LOVE warrant with the Xauth sytle enter password when someone logs in(thats from the forum). But seems like a great plugin I would love a config file for MyBB so I can test it out.
     
  28. Offline

    Ant59

    Okay, I withdraw my previous tone. That's actually a rather intriguing idea. I think I'll have to add that as a feature :)
     
  29. Offline

    Charles Harvey

    So I'm having issues getting warrant to work. In general I'm pretty good with getting shit working but this one I can't seem to get there...

    Anyhow I'm getting invalid SQL queries which generally mean the settings are wrong, but I've double checked and even copied and pasted someone elses phpbb3 database file(changing obvious info that needs to be changes --username -pass -db) and can't seem to get this working.

    mysql-port=3306
    mysql-db=phpbb3
    mysql-user=
    mysql-pass=
    mysql-host=

    users-table=phpbb_users
    memberid-field=user_id
    group-field=group_id

    minecraftname-table=phpbb_profile_fields_data
    minecraftname-table-memberid-field=user_id
    minecraftname-field=minecraft_name\

    The SQL error is:

    22:07:04 [WARNING] [Warrant] - The following statement failed: SELECT phpbb_users.group_id FROM phpbb_users INNER JOIN phpbb_profile_fields_data ON (phpbb_users.phpbb_users = phpbb_profile_fields_data.phpbb_profile_fields_data AND minecraft_name = 'ctharvey')

    For some reason it appears that its doubling up on the table for users and I'm not sure if that's intended.
     
  30. Offline

    Ant59

    Yeah, you're right is is doubling up there :S That is really odd. I thought I'd solved that bug once before lol. I will give it a look at tonight and see what I can do about it for you :)
     
  31. Great Plugin. Am using it with my phpBB forum and it works really nicely.:D

    Keep up the good work.
     
    Ant59 likes this.

Share This Page