[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

    Nazerb

    Code:
    2011-09-21 16:27:52 [SEVERE] [ForumAcc] SQL Error Occurred.
    2011-09-21 16:27:52 [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.
    2011-09-21 16:27:52 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-09-21 16:27:52 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2334)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    2011-09-21 16:27:52 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2011-09-21 16:27:52 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    2011-09-21 16:27:52 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at net.kdmdesign.SQLQuery.sqlCon(SQLQuery.java:252)
    2011-09-21 16:27:52 [SEVERE] at net.kdmdesign.SQLQuery.checkExists(SQLQuery.java:162)
    2011-09-21 16:27:52 [SEVERE] at net.kdmdesign.ForumAcc.activateUser(ForumAcc.java:156)
    2011-09-21 16:27:52 [SEVERE] at net.kdmdesign.ForumAcc.onCommand(ForumAcc.java:140)
    2011-09-21 16:27:52 [SEVERE] at org.bukkit.command.PluginCommand.execute(PluginCommand.java:39)
    2011-09-21 16:27:52 [SEVERE] at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
    2011-09-21 16:27:52 [SEVERE] at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:353)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:755)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:720)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:713)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:91)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:464)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    2011-09-21 16:27:52 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011-09-21 16:27:52 [SEVERE] Caused by: java.net.UnknownHostException: null
    2011-09-21 16:27:52 [SEVERE] at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
    2011-09-21 16:27:52 [SEVERE] at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.net.InetAddress.getAllByName0(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.net.InetAddress.getAllByName0(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at java.net.InetAddress.getAllByName(Unknown Source)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:244)
    2011-09-21 16:27:52 [SEVERE] at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
    2011-09-21 16:27:52 [SEVERE] ... 31 more
    What have i done wrong?
     
  3. Offline

    peaced

    It worked for one user, and now, it always return ; Account not found
    i checked the mc usernames, they are correct.
    Using CB 1188, same with 1185
    PHPBB3

    No error in the logs, the plugin seesm to connect to the mysql db just fine.
    It just wont activate accounts
     
  4. Offline

    SkyteamZ

    @THEK

    No, in fact i have already a forum, wich is a free one, and the provider of the forum does not give me any acces to my database. (the one i need for this plugin)
    I v been on many website to verify how to get the database of my free forum. and i had find only that message, on the free forum provider support page :

    So, i am doing a website now, because i want to have a website also for my server, and i will create a Member space on my website, so i will have a database from my website.

    So that was my question:

    Is it possible to use my website database with the plugin ?
    (because i cant get the database of my free forum)

    Or do you have any solutions (advise) to get my the database of my freeforum?
    because i don't want to destroy it and amke a new one...

    Thank you for quick answer ;)

    Sky
     
  5. Offline

    Zaros

    IPBoard support? <3
     
  6. Offline

    DemonCraft

    Will this Plugin every support XenForo?
     
  7. Offline

    MrMag518

    I hope this can support permissions 3x, so that you can make an account on the forums, then type the /activate ing or something, then u recive a specefic rank in-game. That would be very good for offline/cracked servers and preventing grifers/account spamming.
     
  8. Offline

    xtream1101

    This plugin works great, I just have one suggestion, could you make it so the names are not case sensitive? So like their forum username can be all lowercase but their mc name could have a capitol letter in it.

    Ex.
    forum : xtream1101
    minecraft: Xtream1101
    *this will not active their account

    Thanks
     
  9. Offline

    STiChad

    Anyway you could get vB support?
    I'm running 3.8.6 and would love this.
     
  10. Offline

    Nickname97

    Hey there! Any chance you could release the source?
     
  11. Offline

    lz7go

    hey i need that plugin for IPB
     
  12. Offline

    fffizzz

    Converting from MyBB to XenForo, would love to see support for it :)
     
  13. Offline

    fffizzz

    Did a little research for ya on XenForo.

    In order to activate an account, two things needs to happen.
    1. remove line from xf_user_confirmation, user id linked to user table.
    2. in the xf_user table, the row for the user, needs to have "user_state" set to valid.

    If you enable moderation, it likely removes the need for step 1 :)
     
  14. Offline

    THEK

    First off, apologies for the lack of support/updates here. I've just started Uni and got longer hours in my job so it's been a bit mad. I will begin working on this again soon. I will try to reply to your messages in the mean time.

    You could use this with your website providing your database is laid out like MyBB (easier than phpBB because I have to update statistics on that)

    I'll take a look at this. Currently having problems extracting information without buying the actual product.

    Looking into this. Was like banging my head against a brick wall on the XenForo forums. However it appears I've got more help here so I'll add this hopefully in the next update.

    This should support permissions however it does not give any ranks. There are other plugins available for that.

    I'll certainly add this in the next update.

    Yep I'll take a look. Again it might be harder to get database information from forums without buying the product but I'll give it a go.

    ]
    Source is in the jar file.

    I'll give it a go.

    Thank you very much for your help. As I said above the XenForo forums were the most useless place I've ever been to.

    I can't be sure when an update will be out but hopefully it will be soon.

    thank you for your patience.
     
    STiChad likes this.
  15. Offline

    fffizzz


    I'm proficient with MySQL/PHP and not afriad to get my hands dirty. So if I can assist in any way let me know (I dont know java unfortunately).

    With xenforo 1.0, they dont have custom user fields, 1.1 allows this, I just installed the beta, so I'll look into it and get some more specific data for you regarding that. However, Im gonna leave that off and force registration on minecraft name since I made the change already. XenForo really is an amazing piece of software...

    Code:
    CREATE TABLE IF NOT EXISTS `xf_user_field_value` (
      `user_id` int(10) unsigned NOT NULL,
      `field_id` varchar(25) NOT NULL,
      `field_value` mediumtext NOT NULL,
      PRIMARY KEY  (`user_id`,`field_id`),
      KEY `field_id` (`field_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table `xf_user_field_value`
    --
    
    INSERT INTO `xf_user_field_value` (`user_id`, `field_id`, `field_value`) VALUES
    (1, '4', 'fffizzz');
    
    CREATE TABLE IF NOT EXISTS `xf_user` (
      `user_id` int(10) unsigned NOT NULL auto_increment,
      `username` varchar(50) NOT NULL,
      `email` varchar(120) NOT NULL,
      `gender` enum('','male','female') NOT NULL default '' COMMENT 'Leave empty for ''unspecified''',
      `custom_title` varchar(50) NOT NULL default '',
      `language_id` int(10) unsigned NOT NULL,
      `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
      `timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
      `visible` tinyint(3) unsigned NOT NULL default '1' COMMENT 'Show browsing activity to others',
      `user_group_id` int(10) unsigned NOT NULL,
      `secondary_group_ids` varbinary(255) NOT NULL,
      `display_style_group_id` int(10) unsigned NOT NULL default '0' COMMENT 'User group ID that provides user styling',
      `permission_combination_id` int(10) unsigned NOT NULL,
      `message_count` int(10) unsigned NOT NULL default '0',
      `conversations_unread` smallint(5) unsigned NOT NULL default '0',
      `register_date` int(10) unsigned NOT NULL default '0',
      `last_activity` int(10) unsigned NOT NULL default '0',
      `trophy_points` int(10) unsigned NOT NULL default '0',
      `alerts_unread` smallint(5) unsigned NOT NULL default '0',
      `avatar_date` int(10) unsigned NOT NULL default '0',
      `avatar_width` smallint(5) unsigned NOT NULL default '0',
      `avatar_height` smallint(5) unsigned NOT NULL default '0',
      `gravatar` varchar(120) NOT NULL default '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
      `user_state` enum('valid','email_confirm','email_confirm_edit','moderated') NOT NULL default 'valid',
      `is_moderator` tinyint(3) unsigned NOT NULL default '0',
      `is_admin` tinyint(3) unsigned NOT NULL default '0',
      `is_banned` tinyint(3) unsigned NOT NULL default '0',
      `like_count` int(10) unsigned NOT NULL default '0',
      `warning_points` int(10) unsigned NOT NULL default '0',
      PRIMARY KEY  (`user_id`),
      UNIQUE KEY `username` (`username`),
      KEY `email` (`email`),
      KEY `user_state` (`user_state`),
      KEY `last_activity` (`last_activity`)
    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3035 ;
    
    --
    -- Dumping data for table `xf_user`
    --
    
    INSERT INTO `xf_user` (`user_id`, `username`, `email`, `gender`, `custom_title`, `language_id`, `style_id`, `timezone`, `visible`, `user_group_id`, `secondary_group_ids`, `display_style_group_id`, `permission_combination_id`, `message_count`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `alerts_unread`, `avatar_date`, `avatar_width`, `avatar_height`, `gravatar`, `user_state`, `is_moderator`, `is_admin`, `is_banned`, `like_count`, `warning_points`) VALUES
    (1, 'fffizzz', '[email protected]', '', '', 1, 0, 'Europe/London', 1, 3, '', 3, 16, 3280, 1587, 1285174538, 1318520082, 36, 0, 0, 0, 0, '', 'valid', 0, 1, 0, 0, 0);
    
    those are the two dumps you should need so you can understand the DB layout. lemme know if you need anything else.

    That includes the custom field (used in xenforo 1.1 which is still beta)[/code]

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

    MaMaxGER

    Nice i'ill try it out
     
  17. Offline

    Team Zeale

    SUPPORT XENFORO! (Caps Rage...)
     
  18. Offline

    fffizzz

    I gave him all the info he should need to do this :)

    Im waiting on transitioning over to XenForo on this plugin.. wish I knew java :(
     
  19. Offline

    alexander7567

    Hey.. I just downloaded this plugin and i love it. I wanted a way to be able to do this same thing but i did not know how.
    I only have one problem with this plugin. When i try and activate an account (my sql is hosted on webserver) it lags out the entire minecraft server until it is activated.

    Please fix this for this will be a deal breaker.

    If you want to test this my minecraft server is ak.akminecraft.com
    and my phpbb server is akminecraft.com
     
  20. Offline

    rmkilc

    Could you make it so if someone does /account activate, and they are already activated, it tells them that and does not adjust their forum rank? The problem I have is if a forum moderator does /account activate, it sets them as as the default registered rank on the forum, down from moderator.
     
    fffizzz likes this.
  21. Offline

    brown34

    we need support vbulletin :D
     
  22. Offline

    THEK

    Hi all,

    I have some bad news. I'm no longer developing this plugin. I have a huge project going at the moment which is taking up most of my spare time in between work and uni. If someone wants to continue this plugin the source code is in the JAR file.

    Sorry. It's been fun though.
     
  23. Offline

    fffizzz

    Ok, Ive been working on making it function with XenForo, think Im about done. Now i just need to figure out how to compile it, and will start testing :)
     
  24. Offline

    Shooty

    Need IP.BOARD :( !
     
  25. Offline

    dilo

    i use fourmotion abd i dont see the Custom Profile Field in the admin panel when adding a new profile field

     
  26. Offline

    microskies

    Was wondering if anyone could help me? I know the plugin is discontinued, but still on the hope someone will be able to help me with this one.

    Code:
    2011-12-15 20:35:19 [SEVERE] [ForumAcc] SQL Error Occurred.
    
    I KNOW the obvious thing is to say to read it and read that the "max connections" have been made, but I'm not completely sure what this means as everything was working perfectly before any of the 1.0.0 CB builds - which leads me to believe it just needs to be updated :/ Any kind dev feel like updating it? XD
    
    or any help in solving the problem that WAS FINE before any 1.0 CB builds?
     
  27. Offline

    Trandox

    Does this work with IPB?
     
  28. Offline

    pioluluso

    PLZ, update this plugin to 1.2.3 plz :(
     
  29. Offline

    furt

  30. Offline

    Bloodykittens

    Alot of MC related servers are using Xenforo as their forum of choice now. Is there anyway we can get an update to support it? Or is there a work around for it that we can do?
     
  31. Offline

    furt

    I plan on adding support for SMF bc thats my prefered forum, if u can upload the db structure for Xenforo and link it to me ill see about adding support for it aswell
     

Share This Page