[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

    Twisted420

    hi ive set up the phpbb boards and edited the configs as stated, ive done this once before but i didnt get this error the first time so maybe you can assist me as i did it the exact same as the first time
    errors are not plugin related but forum related
    [phpBB Debug] PHP Notice: in file /includes/functions.php on line 4505: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
    [phpBB Debug] PHP Notice: in file /includes/functions.php on line 4507: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
    [phpBB Debug] PHP Notice: in file /includes/functions.php on line 4508: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
    [phpBB Debug] PHP Notice: in file /includes/functions.php on line 4509: Cannot modify header information - headers already sent by (output started at /language/en/common.php:1)
    i dont rlly know wat it means

    ^^ fixed Never Mind

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

    darkcloud784

    Code:
    22:39:33 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Commu
    nications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
    22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    22:39:33 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    22:39:33 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    22:39:33 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    22:39:33 [SEVERE]       at com.mysql.jdbc.SQLError.createCommunicationsException
    (SQLError.java:1116)
    22:39:33 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionI
    mpl.java:2334)
    22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Conne
    ctionImpl.java:2371)
    22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionI
    mpl.java:2163)
    22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.j
    ava:794)
    22:39:33 [SEVERE]       at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection
    .java:47)
    22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    0(Native Method)
    22:39:33 [SEVERE]       at sun.reflect.NativeConstructorAccessorImpl.newInstance
    (Unknown Source)
    22:39:33 [SEVERE]       at sun.reflect.DelegatingConstructorAccessorImpl.newInst
    ance(Unknown Source)
    22:39:33 [SEVERE]       at java.lang.reflect.Constructor.newInstance(Unknown Sou
    rce)
    22:39:33 [SEVERE]       at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    22:39:33 [SEVERE]       at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionI
    mpl.java:378)
    22:39:33 [SEVERE]       at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegist
    eringDriver.java:305)
    22:39:33 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
    22:39:33 [SEVERE]       at java.sql.DriverManager.getConnection(Unknown Source)
    22:39:33 [SEVERE]       at com.imineserver.imine.SQLQuery.checkUser(SQLQuery.jav
    a:68)
    22:39:33 [SEVERE]       at com.imineserver.imine.phpBBManager.onCommand(phpBBMan
    ager.java:121)
    22:39:33 [SEVERE]       at org.bukkit.command.PluginCommand.execute(PluginComman
    d.java:35)
    22:39:33 [SEVERE]       at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCo
    mmandMap.java:129)
    22:39:33 [SEVERE]       at org.bukkit.craftbukkit.CraftServer.dispatchCommand(Cr
    aftServer.java:298)
    22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.handleCommand(N
    etServerHandler.java:711)
    22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.chat(NetServerH
    andler.java:676)
    22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHand
    ler.java:669)
    22:39:33 [SEVERE]       at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:3
    3)
    22:39:33 [SEVERE]       at net.minecraft.server.NetworkManager.b(NetworkManager.
    java:226)
    22:39:33 [SEVERE]       at net.minecraft.server.NetServerHandler.a(NetServerHand
    ler.java:84)
    22:39:33 [SEVERE]       at net.minecraft.server.NetworkListenThread.a(SourceFile
    :105)
    22:39:33 [SEVERE]       at net.minecraft.server.MinecraftServer.h(MinecraftServe
    r.java:451)
    22:39:33 [SEVERE]       at net.minecraft.server.MinecraftServer.run(MinecraftSer
    ver.java:361)
    22:39:33 [SEVERE]       at net.minecraft.server.ThreadServerApplication.run(Sour
    ceFile:422)
    22:39:33 [SEVERE] Caused by: java.net.ConnectException: Connection refused: conn
    ect
    22:39:33 [SEVERE]       at java.net.PlainSocketImpl.socketConnect(Native Method)
    
    22:39:33 [SEVERE]       at java.net.PlainSocketImpl.doConnect(Unknown Source)
    22:39:33 [SEVERE]       at java.net.PlainSocketImpl.connectToAddress(Unknown Sou
    rce)
    22:39:33 [SEVERE]       at java.net.PlainSocketImpl.connect(Unknown Source)
    22:39:33 [SEVERE]       at java.net.SocksSocketImpl.connect(Unknown Source)
    22:39:33 [SEVERE]       at java.net.Socket.connect(Unknown Source)
    22:39:33 [SEVERE]       at java.net.Socket.connect(Unknown Source)
    22:39:33 [SEVERE]       at java.net.Socket.<init>(Unknown Source)
    22:39:33 [SEVERE]       at java.net.Socket.<init>(Unknown Source)
    22:39:33 [SEVERE]       at com.mysql.jdbc.StandardSocketFactory.connect(Standard
    SocketFactory.java:254)
    22:39:33 [SEVERE]       at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    22:39:33 [SEVERE]       ... 29 more
    >

    This error returns when I attempt to activate an account.

    Code:
    host=darkcloud784.ipagemysql.com
    user=******
    pass=****
    database=bleh
    table_prefix=phpbb_
    
     
  4. Offline

    Twisted420

    have u tried putting the port to you database in under host?
    st=darkcloud784.ipagemysql.com
    port=3306 (this is default port)
    user=******
    pass=****
    database=bleh
    table_prefix=phpbb_
     
  5. Offline

    Demonofbirth

    After editing these logging in takes you to a blank white page.

    edit: I think I have fixed it.
     
  6. Offline

    Parrothead

    I think I did something wrong. When someone finishes a registration, it says the quote below, and they can freely post.

    Even though I replaced the language files. I'm sure its related to the Activation Method though. I don't see where to set it to 'by user' (image below).

    http://imageshack.us/f/43/wharitis.png/
     
  7. Offline

    THEK

    Sorry for the late reply? If you haven't fixed it it might be worth checking with PHPBB forums. I've never seen an admin control panel with only two options. Have you installed any mods that remove them?
     
  8. Offline

    Ratchet

    any idea why this is happening?
    Code:
    2011-07-25 08:36:13 [INFO] phpBBManager Enabled
    2011-07-25 08:36:13 [SEVERE] java.sql.SQLException: Access denied for user 'sunwind'@'216.172.97.29' (using password: YES)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-07-25 08:36:13 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-07-25 08:36:13 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-07-25 08:36:13 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-07-25 08:36:13 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-07-25 08:36:13 [SEVERE]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-07-25 08:36:13 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-07-25 08:36:13 [SEVERE]     at java.sql.DriverManager.getConnection(Unknown Source)
    2011-07-25 08:36:13 [SEVERE]     at com.imineserver.thekris1234.SQLQuery.sqlCon(SQLQuery.java:90)
    2011-07-25 08:36:13 [SEVERE]     at com.imineserver.thekris1234.SQLQuery.checkTables(SQLQuery.java:17)
    2011-07-25 08:36:13 [SEVERE]     at com.imineserver.thekris1234.phpBBManager.onEnable(phpBBManager.java:77)
    2011-07-25 08:36:13 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
    2011-07-25 08:36:13 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:878)
    2011-07-25 08:36:13 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:278)
    2011-07-25 08:36:13 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:162)
    2011-07-25 08:36:13 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:146)
    2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
    2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
    2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
    2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
    2011-07-25 08:36:13 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    216.172.97.29 this is my servers IP, not the server with phpBB on. this is the config;
    host=db.hackr.net
    user=sunwind
    pass=xxxxxxx
    database=sunwinddb
    table_prefix=phpbb_
    forum_url=forum.ragnacraft.com
    not sure why it's trying to use the servers IP?
     
  9. Offline

    THEK

    The server IP is showing because that is where you're connecting from. That's normal. It is a username/password problem.
     
  10. Offline

    Ratchet

    ah ok, thanks
     
  11. Offline

    jeffadkins51

  12. Offline

    THEK

    phpBBManager is now ForumAcc.

    Changelog:
    • Now supports MyBB!
    • phpBB no longer requires code editing!
    • Far better config.
    Download links in OP.

    (Sorry it took so long but we got there eventually)
     
  13. Offline

    ACallander

    Does this work with xenforo? I have users sign up on my forums and "Request Residency" so Is there a way when I approve there application they get approved in game?
     
  14. Offline

    THEK

    I'm afraid I don't quite follow. The answer to your first question is no. I would need to find out how xenforo handles activations.

    However I don't understand the second question. This doesn't really change anything in game. It just edits the database to activate a user so they can log in. It doesn't affect anything within the Minecraft server iteself.
     
  15. Offline

    fffizzz

    I was able to get this setup and working right away, great job. One small update..

    for MyBB, and for whatever reason, most users decide NOT to use thier minecraft name as thier forum name (3k registered members now), i have a custom field set for minecraft username, can we allow it to look for that instead of the main username?

    for example.
    the table mybb_userfields, and for mine, its fid4, which is a required field during signup.

    After that, I'll be able to use this and rid my forum of polish spam bots :D
     
  16. Offline

    THEK

    Working on this now.

    Version 1.1:

    Allows you to specify custom profile field. If specified the plugin will use this instead of the default. Please let me know if you have any problems.

    Download in OP

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

    fffizzz

    Ok, finally had some time to test..

    When using it,
    i see "09:57:30 [INFO] [ForumAcc] WrenisPinkle Activated" in console, but it doesnt actually activate the account..
     
  18. Offline

    Cosmic Break

    i was hoping that the way this worked was they sign up for the forum, and then login to the server. and by doing so would activate thier account. without any commands.
     
  19. Offline

    THEK

    I'll take a look at this now.

    I can easily add an option for that.
     
  20. Offline

    10Hearts.com

    when i do / activate account i get this

    Code:
    >13:57:02 [SEVERE] [ForumAcc] [ForumAcc] SQ Error Occurred.
    
    >13:57:02 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
      
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    
    >13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
    >13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    
    >13:57:02 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    
    >13:57:02 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    
    >13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    
    >13:57:02 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    
    >13:57:02 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    
    >13:57:02 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    
    >13:57:02 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)
    
    >13:57:02 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)
    
    >13:57:02 [SEVERE] at info.thekris1234.SQLQuery.sqlCon(SQLQuery.java:165)
    
    >13:57:02 [SEVERE] at info.thekris1234.SQLQuery.checkUser(SQLQuery.java:147)
    
    >13:57:02 [SEVERE] at info.thekris1234.ForumAcc.onCommand(ForumAcc.java:117)
    
    >13:57:02 [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
    
    >13:57:02 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
    
    >13:57:02 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:320)
    
    >13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:713)
    
    >13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:677)
    
    >13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:670)
    
    >13:57:02 [SEVERE] at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    
    >13:57:02 [SEVERE] at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    
    >13:57:02 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:85)
    
    >13:57:02 [SEVERE] at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
    
    >13:57:02 [SEVERE] at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
    
    >13:57:02 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
    
    >13:57:02 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    
    >13:57:02 [SEVERE] Caused by: java.net.UnknownHostException: db.8243955.hostedresource.com
    
    >13:57:02 [SEVERE] at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method)
    
    >13:57:02 [SEVERE] at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
    
    >13:57:02 [SEVERE] at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
    
    >13:57:02 [SEVERE] at java.net.InetAddress.getAllByName0(Unknown Source)
    
    >13:57:02 [SEVERE] at java.net.InetAddress.getAllByName(Unknown Source)
    
    >13:57:02 [SEVERE] at java.net.InetAddress.getAllByName(Unknown Source)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)
    
    >13:57:02 [SEVERE] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    
    >13:57:02 [SEVERE] ... 30 more
    
    >13:57:13 [WARNING] Can't keep up! Did the system time change, or is the server overloaded?

    Im using
    Table_Prefix: phpbb_
    Port: '3306'
    Database: a0h1122508380147
    Password: xxxx
    Username: yyyy
    URL: zzzz.db.8243955.hostedresource.com
     
  21. Offline

    epsn

    what is the texturepack in the picture?
     
  22. Offline

    THEK

    Please try the latest version (1.2) and see if it produces the same error. If it does please let me know.

    The texture pack is MixCraft HD
     
  23. Offline

    LucidLethargy

    My port setting is default and I have not touched it... any idea what I may be doing wrong? :/
    I am on CB 1000 and using forumacc 1.2

    Config:

    P.S. Love the plugin, can't wait to see it in action! This is amazing stuff!
     
  24. Offline

    THEK

    hmm. It could be your Database URL. HTTP:// forces the connection through port 80 and with 3306 as the other port there could be a conflict. Are you sure it is correct? Normally the URL would be sql.myserver.com or something along those lines. If your database is hosted on the same server as the forum then try the URL as "paradigne.com"
     
  25. Offline

    LucidLethargy

    I use bluehost for my web hosting, so it should work... I know I tie into the same area when I use npcx and my information for npcx is as follows:
    db-host=tbclick.com
    db-name=tbclickc_<censored>
    db-port=3306
    db-user=tbclickc_<censored>

    As such I tried "tbclick.com" and "http://www.tbclick.com" for my database URL, but still nothing :/
     
  26. Offline

    giotjuh

    This is awesome! It works right ahead, this is the first authenication plugin that worked for me thanks bro.
    I have 1 idea, if the user is banned on the forum, that he cant get ingame. Because now they can and we need to ban twice -,-. And the other way: ingame ban = forum ban :)
     
  27. Offline

    teku

    Does the custom field option work with phpBB3? This table doesn't exists... custom fields are stored in phpbb_profile_fields

    Code:
    2011-08-26 22:22:15 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'forums.userfields' doesn't exist
     
  28. Offline

    THEK

    hmm. Try regenerating your config file and typing in the URL as tbclick.com. If it doesn't work let me know and I'll look further into it.

    For that functionality you would need to use plugins such as Warrant (I think). It performs the synchronisation features you're looking for. At the moment this plugin will only be for activating accounts.

    Can you post your config file please. (remember to star(*) out any usernames/passwords
     
  29. Offline

    Mattz0r


    Hello, I'm getting the same problem.

    The issue isn't within the config. But where-ever you have set the field that it needs to look for.

    My config is as below:

    Code:
    #forumAcc will test DB connection at startup
    Database:
        Table_Prefix: phpbb_
        Port: '3306'
        Database: minescf
        Password: *******
        Username: minescf
        URL: localhost
    Forum:
        Type: phpbb
        URL: http://*****************/phpBB3/
    Optional:
        Custom_Username_FieldID: 'mc_username'
    
    Hope this helps... As there isn't an option to set the table it needs to look at :(

    EDIT:

    Perhaps a separate release version for phpBB3 users or a configuration setting to specify the table it needs to look at.
     
  30. Offline

    THEK

    The problem is in the code somewhere. The plugin should change which tables and columns it uses depending on what database type is given. For some reason it is defaulting to mybb even when phpbb is given. I'll take a look at it today.
     
  31. Offline

    Mattz0r

    Awesome, Thanks! I'm really eager to get this sorted :D - Kudos to you ^_^
     

Share This Page