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

    Jamie Tees

    I'm using the newest latest version coded for multiple tables, I think ant was releasing it soon, but just to say it works great and I'm sure on public release it will be awesome too!
     
  3. Offline

    Ant59

    Still working on it. Wasn't able to do anything last night. Expect an upload shortly.
     
  4. Offline

    NeatMonster

  5. Offline

    Jamie Tees

    Ant can you forward me on any config changes I may need when yoou get chance?
    Thanks!
     
  6. Offline

    Jinivus

    This works amazingly. Got stuck for a second because I didn't read the part about creating our own "groups.properties" file, but once I realised and fixed that it works awesomely.

    Any plans to support subgroups?
     
  7. Offline

    Ant59

    PLUGIN UPDATE!
    PLEASE READ THE CONFIG SECTION IF YOU UPDATE FROM 1.0! Some fields in warrant.properties have changed!

    Warrant now uses a separate thread to execute it's MySQL business, avoiding login lag and general server lag on player logins :)

    Two table mode now available. Read OP.

    Yes, absolutely! It came to my attention earlier that I myself will soon need subgroups. Such that you could add a user to the additional group of VIP as a subscription-based group, but still retain their "rank" on a server :) Stay tuned for this feature :p
     
    seriosbrad likes this.
  8. Offline

    seriosbrad

    Thanks for the update, it had an immediate affect on reducing lag on my server
     
    Ant59 likes this.
  9. Offline

    Ant59

    That's brilliant :)
     
  10. Offline

    Kalman Olah

    Aw yeah, good job man :).

    EDIT: Is the link in the first post linking to Warrant 1.0? The new settings I added to the file do not seem to have any effects.

    Code:
    [Warrant] v1.0 - Statement failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 WHERE null = 'KalmanOlahPh'' at line 1
     
  11. Offline

    Ant59

    Damn. I seem to have problems with changing that link. It's twice now that it's pointed to the wrong place :( As soon as I get home, I will upload the 1.1 JAR to mediafire. Hopefully that will assure that it's the right one :)
     
  12. Offline

    Kalman Olah

    Great! Thanks a lot! :D
     
  13. Offline

    Ant59

    There we go :) All sorted. Editied OP with new link.

    <Edit by Moderator: Redacted mediafire url>
     
    Last edited by a moderator: Dec 14, 2016
    Kalman Olah likes this.
  14. Offline

    Kalman Olah

    Hey there...me again :).

    Code:
    [Warrant] v1.1 - The following statement failed: SELECT phpbb_users.user_rank FROM phpbb_users WHERE pf_mine_user = 'penguphilia'
    2011-05-25 16:53:35 [WARNING] [Warrant] v1.1 - Statement failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'pf_mine_user' in 'where clause'
    2011-05-25 16:53:35 [SEVERE] [Warrant] v1.1 - Warrant not issued! Warrant's authorisation thread was killed!
    Note the part after the WHERE clause...It seems Warrant is trying to select my rank from my rank table using my minecraft username instead of the user ID. (No, I didn't mess up my config file :p)

    My config file:
    Code:
    #Automatically generated config file
    #Wed May 25 16:45:23 CEST 2011
    group-field=user_rank
    minecraftname-field=pf_mine_user
    mysql-port=3306
    mysql-db=phpbb
    mysql-user=root2
    minecraftname-table=phpbb_profile_fields_data
    minecraftname-table-memberid-field=user_id
    mysql-pass=cleverpasshere
    mysql-host=genericgaming.net
    users-table=phpbb_users
    memberid-field=user_id
     
  15. Offline

    Ant59

    Sorry!! I hadn't correctly written the conditional statement to check for two table mode (I can't test for two tables myself). Fixed now, try redownloading :)
     
  16. Offline

    Kalman Olah

    You forgot to give me a link :p
     
  17. Offline

    Ant59

    Link in OP is updated.
     
  18. Offline

    Kalman Olah

    The same problem still persists.

    EDIT: I don't think you updated the link in OP, man...It's the same link as your .jar link on page 2.

    You just uploaded WorldEdit.jar :).

    Edit: this is pretty funny :p

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

    Ant59

    Jesus christ I'm useless sometimes!

    <Edit by Moderator: Redacted mediafire url>
     
    Last edited by a moderator: Dec 14, 2016
  20. Offline

    Kalman Olah

     
    Last edited by a moderator: Dec 14, 2016
  21. Offline

    Ant59

    So.. the output is still this?

    Code:
    [Warrant] v1.1 - The following statement failed: SELECT phpbb_users.user_rank FROM phpbb_users WHERE pf_mine_user = 'penguphilia'
    2011-05-25 16:53:35 [WARNING] [Warrant] v1.1 - Statement failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'pf_mine_user' in 'where clause'
    2011-05-25 16:53:35 [SEVERE] [Warrant] v1.1 - Warrant not issued! Warrant's authorisation thread was killed!
    That is the single-table SQL query though :S I can't work out what's going on here. This isn't right at all. Grr. Give me 20 minutes or so, I'll fiddle with it and see what I can do :) It might be the case that 1.6 is released today and I'll release a fix with my update for that.
     
  22. Offline

    Kalman Olah

    Yup.

    This is the query is used when I edited your source code to use two tables:

    Code:
    rs = sql.trySelect("SELECT " + propConfig.getProperty(PROP_GROUP_FIELD) + " FROM " + propConfig.getProperty(PROP_MYSQL_USERS_TABLE) + "," + propConfig.getProperty(PROP_MYSQL_MINE_TABLE) + " WHERE " + propConfig.getProperty(PROP_USERNAME_FIELD) + " = '" + playerName + "' AND " + propConfig.getProperty(PROP_MYSQL_MINE_TABLE) + ".user_id = " + propConfig.getProperty(PROP_MYSQL_USERS_TABLE) + ".user_id");
    I'm assuming that's pretty much what you're already using, though, since it looks like it's an issue with an IF statement.
    Something could be wrong with checking whether or not the multitable part of the values in the config are defined.
     
  23. Offline

    Ant59

    I'm going to have to apologise. I stayed up too late last night doing this (4am) and (as you can probably tell from not being able to put a single damn link up properly), I'm not really with it atm :L

    Here is what should be a working version: http://dl.dropbox.com/u/29840218/Warrant.jar Try that, and if not, then I'll wait until 1.6 is released and do it all in one go.
     
  24. Offline

    Kalman Olah

    Don't sweat it, bro. You're doing a great job.

    I'll just post this updated server log:
    Code:
    [Warrant] v1.1 - Running database connection...
    2011-05-25 18:28:46 [INFO] com.mysql.jdbc.StatementImpl@3fb2bb77
    2011-05-25 18:28:47 [INFO] [Warrant] v1.1 - null
    2011-05-25 18:28:47 [SEVERE] [Warrant] v1.1 - Warrant not issued! Warrant's authorisation thread was killed!
    2011-05-25 18:28:47 [SEVERE] [Warrant] v1.1 - java.lang.NullPointerException
    2011-05-25 18:28:47 [SEVERE] java.lang.NullPointerException
    2011-05-25 18:28:47 [SEVERE]     at org.anjocaido.groupmanager.dataholder.WorldDataHolder.getGroup(WorldDataHolder.java:186)
    2011-05-25 18:28:47 [SEVERE]     at net.districtmine.warrant.Warrant$AuthoriseWarrant.run(Warrant.java:103)
    2011-05-25 18:28:47 [SEVERE]     at java.lang.Thread.run(Unknown Source)
    2011-05-25 18:28:47 [INFO] [Warrant] v1.1 - Warrant processed
    2011-05-25 18:28:47 [INFO] penguphilia [/10.236.114.182:56622] logged in with entity id 50 at (-100.5, 73.62000000476837, 59.5)
    2011-05-25 18:28:47 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?
    I'll gladly wait for your 1.6 version :).

    Edit: I hope you don't mind if I put up a link for my modified 1.5 version until an official working version is available.
    Edit 2: DL link removed, since 1.6 will be out so soon.
     
  25. Offline

    Ant59

    Code:
    2011-05-25 18:28:47 [INFO] [Warrant] v1.1 - null
    ^ As far as I can tell, that means it found everything fine, but wasn't able to match it up to a group in groups.properties?
     
  26. Offline

    Kalman Olah

    I just tried changing my forum rank to see if it would trigger in-game changes, and the output was the exact same, with no changes in GroupManager rank. So no :p.

    Edit:
    my groups.properties:
    Code:
    #forum group id=GroupManager rank
    1=Admin
    2=SemiAdmin
    3=Moderator
     
  27. Offline

    Ant59

    And these match EXACTLY with the names of your GM ranks?
     
  28. Offline

    Kalman Olah

    Yup :p

    Code:
    groups:
      Default:
        default: true
        permissions:
        - commandbook.intro
        - commandbook.motd
        - commandbook.msg
        - commandbook.rules
        - commandbook.say.me
        - commandbook.who
        - craftbook.ic.safe
        - craftbook.mech.*
        - getwolfowner
        - herochat.color
        - minecartmania.signs.*
        - modtrs.command.modlist
        - modtrs.command.modreq
        - myhome.home.basic.delete
        - myhome.home.basic.home
        - myhome.home.basic.set
        inheritance: []
        info:
          prefix: ''
          build: true
          suffix: ''
      SemiAdmin:
        default: false
        permissions:
        - hmmmmmm
        inheritance:
        - moderator
        info:
          prefix: '&8[&4GM II&8] '
          build: true
          suffix: ''
      Moderator:
        default: false
        permissions:
        - bb.admin.info
        - bb.admin.rollback
        - commandbook.bans.*
        - commandbook.broadcast
        - commandbook.call
        - commandbook.clear
        - commandbook.clear.other
        - commandbook.give
        - commandbook.give.*
        - commandbook.kick
        - commandbook.more
        - commandbook.more.*
        - commandbook.mute
        - commandbook.return
        - commandbook.shock
        - commandbook.shock.other
        - commandbook.slap
        - commandbook.slap.other
        - commandbook.spawn
        - commandbook.spawnmob
        - commandbook.spawnmob.*
        - commandbook.teleport
        - commandbook.teleport.other
        - commandbook.thor
        - commandbook.thor.other
        - commandbook.time
        - commandbook.weather
        - commandbook.weather.thunder
        - commandbook.whereami
        - commandbook.whereami.compass
        - commandbook.whois
        - magiccarpet.mc
        - magiccarpet.ml
        - SpawnX.*
        - superpickaxe.use
        - tips.reload
        - worldedit.fixlava
        - worldedit.fixwater
        - worldedit.navigation.jumpto
        - worldedit.navigation.thru
        - worldguard.god
        - worldguard.god.other
        - worldguard.heal
        - worldguard.heal.other
        - worldguard.slay
        - worldguard.slay.other
        - modtrs.mod
        - modtrs.command.broadcast
        - modtrs.command.check
        - modtrs.command.teleport
        - modtrs.command.complete
        inheritance:
        - default
        info:
          prefix: '&8[&4GM I&8] '
          build: true
          suffix: ''
      Admin:
        default: false
        permissions:
        - '*'
        inheritance:
        - semiadmin
        info:
          prefix: '&8[&4GM III&8] '
          build: true
          suffix: ''
    
     
  29. Offline

    Jamie Tees

    Dude, Why don't you upload the one that you did for me?
    and tell users to grab this one if they want two tabled? It works fine and not laggy at all for me (and I'm using remote mysql to my forum)?

    I think you should do that till 1.6 is released since the plugin works great :D
     
  30. Offline

    Kalman Olah

    Because that one doesn't run in its own thread, which means anything bukkit-related is put on hold until the login/warrant fetch is complete. Now, this may not be an issue for the person logging in, and may not be an issue for small servers, but you'll start noticing it if it's not you logging in.

    edit: totally misread your question there :p
     
  31. Offline

    seriosbrad

    I was starting to get some lag again so I tried this link thinking I got the wrong version before. And now:

    Code:
    2011-05-25 15:06:17 [INFO] [Warrant] v1.1 - Player login! Attempting to grant warrant...
    2011-05-25 15:06:17 [INFO] [Warrant] v1.1 - Running database connection...
    2011-05-25 15:06:24 [INFO] com.mysql.jdbc.StatementImpl@5f6db53a
    2011-05-25 15:06:24 [WARNING] [Warrant] v1.1 - The following statement failed: SELECT null.usergroup FROM null INNER JOIN null ON (null.null = null.null AND null = 'Mooshe')
    2011-05-25 15:06:24 [WARNING] [Warrant] v1.1 - Statement failed: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 INNER JOIN null ON (null.null = null.null AND null = 'Mooshe')' at line 1
    2011-05-25 15:06:24 [SEVERE] [Warrant] v1.1 - Warrant not issued! Warrant's authorisation thread was killed!
    2011-05-25 15:06:24 [SEVERE] [Warrant] v1.1 - java.lang.NullPointerException
    2011-05-25 15:06:24 [SEVERE] java.lang.NullPointerException
    2011-05-25 15:06:24 [SEVERE] 	at net.districtmine.warrant.Warrant$AuthoriseWarrant.run(Warrant.java:99)
    2011-05-25 15:06:24 [SEVERE] 	at java.lang.Thread.run(Thread.java:636)
    2011-05-25 15:06:24 [INFO] [Warrant] v1.1 - Warrant processed
    :p

    Edit: ah, that was already posted on Page 2
     

Share This Page