[WEB/ADMN] ForumAcc v1.5 - Server forum activation. phpBB, MyBB [1060]

Discussion in 'Inactive/Unsupported Plugins' started by thekris1234, Jun 4, 2011.

  1. Offline




    Version: 1.5

    I'm no longer developing this plugin. If you would like to continue it the source code is in the JAR file. However, I think it needs to be started from scratch.

    What is ForumAcc?
    ForumAcc allows you to force any users that sign up to your forums to activate their account from your Minecraft server. Perfect for stopping spam!

    ForumAcc does NOT affect server ranks. If provides a better activation process for Minecraft server related forums (instead of Email or Admin activation)

    How to install

    1. Go to your forums, log in as an Administrator and go to the Administration Control Panel
    2. Under "General" > "Board Configuration" click "User Registration Settings"
    3. Set it to "By Admin"
    1. Go to your forums and log in as an Administrator and go to the Admin-CP
    2. Click on "Configuration" -> "User Registration and Profile Options"
    3. Change "Registration Method" to "Administrator Activation"
    1. Download plugin and put into /plugins
    2. Start server. The plugin will create /ForumAcc/config.yml in /plugins and disable itself
    3. Edit the file appropriately. HELP BELOW
    4. Reload Server. DONE

    #forumAcc will test DB connection at startup
        Table_Prefix: phpbb_
        Port: '3306' // You do not need to change this if it uses the default port
        Database: phpBB
        Password: password
        Username: root
        URL: localhost
        Type: phpbb  // Only phpbb or mybb are supported
        URL: http://forum.myserver.com
        Custom_Profile_FieldID: '' // Optional. Specifies the field id for the minecraft username in your forum. See "Custom Profile Field ID Help"
    Custom Profile Field ID Help
    Using a custom profile field allows users to choose a username other than their Minecraft username as their forum username. Here is how to find the Custom_Profile_FieldID for the config.

    Show Spoiler


    Show Spoiler


    How to use
    Log in as the username registered on the forum and type
    /account activate
    You will receive a confirmation message

    Version 1.5: Jar / ZIP

    • 1.5 - Added option for Auto-Activation when a player logs in.
    • 1.4 - Fixed phpBB not activating users. Better error/success reporting
    • 1.3 - Fixed phpBB Custom profile fields
    • 1.2 - Fixed a typo in SQL string for mybb custom field. Better Error reporting.
    • 1.1 - Added ability to specify custom profile field. This means the user does not have to use their Minecraft username as their forum username
    • 1.0 - Plugin now supports MyBB and phpBB without code editing. Better config.
    • 0.3 - ReWritten SQL. Now updates "newest_username, newest_user_id, newest_user_colour, num_users". Checks if it can connect to tables at startup
    • 0.2 - Fixed txt file bug
    • 0.1 - Initial Release
    Jonath198, MaMaxGER, Mattz0r and 2 others like this.
  2. Offline


    Should be fixed in 1.3. Download link in OP. Let me know if you have any trouble.
  3. Offline


    I'm getting the same errors :( - Thanks for the efforst!

    03:28:55 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minescf.phpbb_userfields' doesn't exist
    03:28:55 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    03:28:55 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    03:28:55 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    03:28:55 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    03:28:55 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    03:28:55 [SEVERE]       at com.mysql.jdbc.Util.getInstance(Util.java:382)
    03:28:55 [SEVERE]       at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    03:28:55 [SEVERE]       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    03:28:55 [SEVERE]       at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    03:28:55 [SEVERE]       at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    03:28:55 [SEVERE]       at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    03:28:55 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    03:28:55 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    03:28:55 [SEVERE]       at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1474)
    03:28:55 [SEVERE]       at info.thekris1234.SQLQuery.SELECT(SQLQuery.java:202)
    03:28:55 [SEVERE]       at info.thekris1234.SQLQuery.checkCustomColumn(SQLQuery.java:34)
    03:28:55 [SEVERE]       at info.thekris1234.ForumAcc.onEnable(ForumAcc.java:87)
    03:28:55 [SEVERE]       at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
    03:28:55 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:885)
    03:28:55 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
    03:28:55 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:178)
    03:28:55 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:161)
    03:28:55 [SEVERE]       at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:286)
    03:28:55 [SEVERE]       at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:273)
    03:28:55 [SEVERE]       at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:149)
    03:28:55 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:337)
    03:28:55 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
  4. Offline


    Thanks for the quick update! It seems things are getting closer for phpBB3.

    2011-08-28 21:15:41 [INFO] [ForumAcc] Database connected. Custom Field OK.

    #forumAcc will test DB connection at startup
        Table_Prefix: ''
        Port: '3306'
        Database: ##########
        Password: ##########
        Username: ##########
        URL: localhost
        Type: phpbb
        URL: http://##########/
        Custom_Username_FieldID: 'mc_username'
    /account activate -> Spits out: [ForumAcc] An Error Occured. Could not find user

    If I change the name in the custom field it then says: [ForumAcc] No account found. Go to http://#########/ to register

    The custom field is exactly what I registered the minecraft name including case: TheUsername and TheUsername

    Hope this helps... somehow ;) - If there is anything else I can provide... the logs are kind of empty though.
  5. Offline


    Are you definitely using the latest version?
  6. Offline


    Yes, I downloaded the file in the opening posted, Removed all instances of ForumAcc before putting it on. - I can do it again if you want to make sure :)


    I've just reinstalled, and getting exactly the same error - I don't need any other sort of plugin to make this work do I?
  7. Offline


    I've been having this same issue; also reinstalled. Using phpbb3, and the database connection is fine.
  8. Offline


    I'm currently working on these issues. I'll have to do some more testing because this works fine with 2 databases I've tested.
  9. Offline


    i get this when i start the server
    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
    18:23:20 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    18:23:20 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    18:23:20 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    18:23:20 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    18:23:20 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    18:23:20 [SEVERE]       at com.mysql.jdbc.SQLError.createCommunicationsException
    18:23:20 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionI
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Conne
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
    18:23:20 [SEVERE]       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
    18:23:20 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    18:23:20 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    18:23:20 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    18:23:20 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    18:23:20 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
    18:23:20 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
    18:23:20 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
    18:23:20 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
    18:23:20 [SEVERE]       at info.thekris1234.SQLQuery.sqlCon(SQLQuery.java:205)
    18:23:20 [SEVERE]       at info.thekris1234.ForumAcc.onEnable(ForumAcc.java:85)
    18:23:20 [SEVERE]       at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlug
    18:23:20 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(
    18:23:20 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.enablePlugin(Si
    18:23:20 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftSe
    18:23:20 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.enablePlugins(Craf
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.e(MinecraftServe
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.a(MinecraftServe
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.init(MinecraftSe
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    18:23:20 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    18:23:20 [SEVERE] Caused by: java.net.ConnectException: Connection timed out: co
    18:23:20 [SEVERE]       at java.net.PlainSocketImpl.socketConnect(Native Method)
    18:23:20 [SEVERE]       at java.net.PlainSocketImpl.doConnect(Unknown Source)
    18:23:20 [SEVERE]       at java.net.PlainSocketImpl.connectToAddress(Unknown Sou
    18:23:20 [SEVERE]       at java.net.PlainSocketImpl.connect(Unknown Source)
    18:23:20 [SEVERE]       at java.net.SocksSocketImpl.connect(Unknown Source)
    18:23:20 [SEVERE]       at java.net.Socket.connect(Unknown Source)
    18:23:20 [SEVERE]       at java.net.Socket.connect(Unknown Source)
    18:23:20 [SEVERE]       at java.net.Socket.<init>(Unknown Source)
    18:23:20 [SEVERE]       at java.net.Socket.<init>(Unknown Source)
    18:23:20 [SEVERE]       at com.mysql.jdbc.StandardSocketFactory.connect(Standard
    18:23:20 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    18:23:20 [SEVERE]       ... 26 more
  10. Offline


    I will bring out an update this weekend

    Version 1.4 released.

    This should address all issues with phpBB.

    Updating to 1.4 and using phpBB?
    It is HIGHLY RECOMMENDED that you check your phpbb users' groups. Make sure there are none that have gone astray due to a bug in version 1.3 of ForumAcc. MyBB is unaffected.

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


    20:23:37 [INFO] [ForumAcc] Database connected. Custom Field OK.

    :D :D :D :D :D - Now to test it in game!


    It's working - But With PHPBB Portal, it kind of overrides the forum registration - BAck to the drawing board in regards to my website, haha. But thank you thank you!!! :D
  12. Offline


    can u make tis for WBB too please?
  13. Offline


    Which version of WBB do you have?
  14. Offline


    the newest. i think its 3.1.6.. sry for my bad english

    Or is there a way to switch in wbb the permission-stat of an user?
    New users on the server Join as group "Default" on Permission 3.1.6 and cant do anything. But Users on Group "players" are allowed to build.
    Is it possible to switch from "Default" To "Player" over an Forum/Webinterface?
  15. Offline


    Hi, this plugin is exactly what I need, well done :), but unfortunetly but im getting an error, i've got 1.4 and the latest craftbukkit, any idea whats going wrong? [​IMG]

  16. Offline


    There appears to be an error in your config file. The line the error relates to is the "Custom_Username_FieldID". Can you post your config please. Don't forget to remove passwords.

    1.5 will include an Auto Activate feature for when users log in. It will advertise your server forum if they don't have an account.

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


    Table_Prefix: phpbb_
    Port: '3306'
    Database: aXXXX6_craft
    Username: aXXXX6_craft
    URL: mysql2.000webhost.com
    Type: phpbb
    URL: http://icecraft.net76.net/
    Custom_Profile_FieldID: ''
  18. Offline


    Are you ever gonna have it so it can change bukkitperms? Because that would be very useful.
  19. Offline


    What do you mean? If you mean it syncs permissions depending on whether the user is activated or not then I'm afraid not. This is here to solve 1 problem only, stopping spam accounts. There are several other plugins that can sync perms.
  20. Offline


    Would you mine linking me to one im new to this kinda stuff thanks.
  21. Offline


  22. Offline


    so any idea whats wrong with my config file? :(
  23. Offline


    Have you tried deleting the file and regenerating it?
  24. Offline


    Version 1.5 Released

    Added Auto-Activation option when a player logs in.

    You don't need to delete your config. It will update automatically!
  25. Offline


    You think you can add the feature for XenForo Forums??
  26. Offline


    Just deleted it, regened it and typed in my details again, seems like im getting somewhere but I'm getting a different error now:

  27. Offline


    is it possible to create a separate thread for the MySQL connection it hangs the server if the connection is to a remote server. or post source =P haha need to look in jar next time
  28. Offline


    Hi, (hope someone will be able to help me ^^ )

    My problem:
    My forum (phpbb3) provider does not give me the database, and there is no way to get it back.

    So i am creating a website now, for my server and my question is:
    If i create a logon, with a member space wich will use a database of username.
    Would it be possible to use that plugin but with my website in place of the forum (URL)?

    Thanx for answer... :rolleyes:

    Ps: Or any solution about that forum database problem ?
    got already more than 100 members, i dont wanna change forum...
  29. Offline


    I'm afraid I don't know what the error is about. I'll do some more internet trawling and see if I can find a solution.

    I don't know how to do multithreading but I'll read up on it and bring it out with the next update.

    I don't quite understand what your provider has done? Have you lost the entire site?

    I'll take a look to see how Xenforo deals with activations and hopefully bring it out with the net update.

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


    well I took the liberty of making your plugin thread safe (after re-writing allot) =/
    and one thing that got me thinking is that it's not very safe using remote mysql to register a user.
    so I decided to implement a SSH tunnel... didn't quite work. So unless you can figure it out I would actually disallow anything not local without a warning.

    I had to write a php proxy to hook into the phpbb script, and use public/private key encryption for communication.
    and I made it create a forum account not activate one. :p

    If you need any help let me or wolvereness know we will be glad to share.
  31. Offline


    :O Please Keep us informed :D

    There is Allot of Minecraft XenForo users out there! It will defiantly make this plugin that much popular :D\

    This forum is XenForo btw ;) Amazing php!​

Share This Page