WordPress.org

Forums

PHPBB Single Sign On
Important updates for 0.8.5 (14 posts)

  1. AJenbo
    Member
    Posted 4 years ago #

    OK as there is a new version out I will make a new list of suggested fixed for it. With out some of thees changes many users won't be able to login!

    module.phpbb.php line 163, change:
    $sql = 'UPDATE ' . USERS_TABLE . ' SET user_password="' . $hashed . '",user_pass_convert=0,user_last_search=1 WHERE username = "' . $username . '"';
    to:
    $sql = 'UPDATE ' . USERS_TABLE . ' SET user_password="' . $hashed . '",user_pass_convert=0,user_last_search=1 WHERE username_clean = "' . utf8_clean_string($username) . '"';

    module.phpbb.php line 203, change:
    FROM ' . USERS_TABLE . " WHERE username = '" . $name . "'";
    to:
    FROM ' . USERS_TABLE . " WHERE username_clean = '" .utf8_clean_string($name) . "'";

    module.wp.php line 78, get_profile is depricated, change:
    return get_profile('id', $user);
    to:
    return (int) get_user_id_from_string($user);

    I might find more as a test it out in the next couple of weeks.

  2. heredia21
    Member
    Posted 4 years ago #

    Could you help me set it up on my board?

  3. AJenbo
    Member
    Posted 4 years ago #

    Probably better that you create your own topic rather then hijack this one. I might look in to helping other one i have mine fully running with the new version.

  4. heredia21
    Member
    Posted 4 years ago #

    ok

  5. heredia21
    Member
    Posted 4 years ago #

    What is your site url if you dont mind so i can see how it works?

  6. AJenbo
    Member
    Posted 4 years ago #

    http://ubuntudanmark.dk/forum/ It's currently running with 0.7.1, not much to look at as fare as the plugin goes.

  7. heredia21
    Member
    Posted 4 years ago #

    Just tested it. It works awesome! Wish i could get mine working.

  8. AJenbo
    Member
    Posted 4 years ago #

    module.phpbb.php line 28:
    define('IN_PHPBB', true);
    to:

    if(!defined('IN_PHPBB')) {
    
                define('IN_PHPBB', true);
            }

    module.phpbb.php line 252:
    " WHERE username = '" . esc_sql($name) . "'";
    to:
    " WHERE username_clean = '" . esc_sql(utf8_clean_string($name)) . "'";

    files/auth_wpbb.php line 62:
    WHERE username = '" . $db->sql_escape($username) . "'";
    to:
    WHERE username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

  9. AJenbo
    Member
    Posted 4 years ago #

    This last one is also very importat if you care about your forum being found on google!

    files/common.php line 121 add:
    header("HTTP/1.0 200 OK");

  10. heredia21
    Member
    Posted 4 years ago #

    Thanks for these fixes! Sent you an email.

  11. mrpinkcricut
    Member
    Posted 3 years ago #

    I am running wordpress 3.2.1, PHPbb3 3.0.9, and version 0.8.5 of this plugin. I have most of it working, but what I cannot get to work is the backwards login from PHPbb to WordPress. I can only get the login to work one way. Where do I need to look in order to modify the code for this to work?

  12. AJenbo
    Member
    Posted 3 years ago #

    mrpinkcricut you should starte a new topic as it is not related to this one.

  13. wplasma
    Member
    Posted 3 years ago #

    Do i have to make those changes to PHPBB Single Sign On v0.8.5 and phpBB v3.0.9 (UTF-8), to make it work.

    I installed half-ok, but then it kick me out WP, and admin passwords are wrong. After deleting folder and put backup files to phpbb.

    And is any update comming?

  14. sheba2
    Member
    Posted 3 years ago #

    Can you please tell me which is the latest version. 0.8.5 or 2.0.6 stated on your site?

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • PHPBB Single Sign On
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic