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

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

  1. Offline

    THEK

    [​IMG]


    [​IMG]

    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


    phpBB:
    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"
    MyBB:
    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
    Config.yml

    Code:
    #forumAcc will test DB connection at startup
    Database:
        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
    Forum:
        Type: phpbb  // Only phpbb or mybb are supported
        URL: http://forum.myserver.com
    Optional:
        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.

    phpBB
    Show Spoiler

    [​IMG]


    MyBB
    Show Spoiler

    [​IMG]



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

    Download
    Version 1.5: Jar / ZIP

    Changelog
    • 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

    THEK

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

    Mattz0r

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

    Code:
    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

    teku

    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.

    Code:
    #forumAcc will test DB connection at startup
    Database:
        Table_Prefix: ''
        Port: '3306'
        Database: ##########
        Password: ##########
        Username: ##########
        URL: localhost
    Forum:
        Type: phpbb
        URL: http://##########/
    Optional:
        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

    THEK

    Are you definitely using the latest version?
     
  6. Offline

    Mattz0r

    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 :)

    EDIT:

    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

    Wiernusz

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

    THEK

    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

    blazinbai

    i get this when i start the server
    Code:
    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
    rce)
    18:23:20 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    18:23:20 [SEVERE]       at com.mysql.jdbc.SQLError.createCommunicationsException
    (SQLError.java:1116)
    18:23:20 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionI
    mpl.java:2334)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Conne
    ctionImpl.java:2371)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
    mpl.java:2163)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
    ava:794)
    18:23:20 [SEVERE]       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
    .java:47)
    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
    rce)
    18:23:20 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    18:23:20 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
    mpl.java:378)
    18:23:20 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
    eringDriver.java:305)
    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
    in.java:126)
    18:23:20 [SEVERE]       at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(
    JavaPluginLoader.java:878)
    18:23:20 [SEVERE]       at org.bukkit.plugin.SimplePluginManager.enablePlugin(Si
    mplePluginManager.java:272)
    18:23:20 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftSe
    rver.java:162)
    18:23:20 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.enablePlugins(Craf
    tServer.java:146)
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.e(MinecraftServe
    r.java:284)
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.a(MinecraftServe
    r.java:271)
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.init(MinecraftSe
    rver.java:148)
    18:23:20 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:335)
    18:23:20 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:422)
    18:23:20 [SEVERE] Caused by: java.net.ConnectException: Connection timed out: co
    nnect
    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
    rce)
    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
    SocketFactory.java:254)
    18:23:20 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    18:23:20 [SEVERE]       ... 26 more
     
  10. Offline

    THEK

    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

    Mattz0r

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

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


    EDIT:

    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

    Darkseal

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

    THEK

    Which version of WBB do you have?
     
  14. Offline

    Darkseal

    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?
    Example:
    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

    theone

    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]

    thanks
     
  16. Offline

    THEK

    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

    theone

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

    Nazerb

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

    THEK

    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

    Nazerb

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

    THEK

  22. Offline

    theone

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

    THEK

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

    THEK

    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

    dwdminecracked

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

    theone

    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

    StrikeForceZero

    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

    SkyteamZ

    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

    THEK

    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

    StrikeForceZero

    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

    dwdminecracked

    :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\

    EDIT:
    This forum is XenForo btw ;) Amazing php!​
     

Share This Page