19 comments

  1. ramdhan84

    i’ve found a problem .. Fatal error: Call to undefined function execute_row() when i’m trying to login.
    what is execute_row() ??

    Thx.
    Ramdhan

  2. Pingback: How to integrate phpbb forum login | King F1
  3. Dave

    Does this handle checking for an existing user by username/email address?

    I had a quick look through it but couldn’t see any reference to it.

    Cheers,

    Dave

  4. Soulast

    i love your tutorial but im having big time problem
    Is any1 know how to solve that error:

    Fatal error: Call to a member function sql_query() on a non-object in \forum\includes\cache.php on line 51

    ??
    It is always showing when im trying to login thx for any help in advance

  5. David

    General Error
    SQL ERROR [ mysqli ]

    Can’t connect to MySQL server.

    An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

  6. Jamar Phu

    Why spend money when you could learn for free ? That is the idea on the internet. Regardless of what you are searching for, the Internet always has an answer for you.

  7. stefano

    Buongiorno Giulio.
    Mi permetto di disturbarti, riguardo al tuo post
    - How to integrate phpbb forum login

    siamo un gruppetto di programmatori dilettanti che hanno un proprio sito
    con un proprio sistema di registrazione ed autenticazione.
    scritto da noi e quindi facilmente modificabile e configurabile basato su un db mysql.
    vorremmo appunto integrarlo con un forum

    la mia domanda base era (prima di perdere decine di ore in un lavoro al limite delle nostre capacità)

    - è, secondo te, possibile accedere a phpbb tramite il nostro sistema di login
    utilizzando il tuo sistema, ma PASSANDO i dati dei sottogruppi/forum a cui l’utente può accedere
    ovvero che l’utente A possa partecipare ai sottoforum Sezione1, sezione2
    mentre l’utente B possa accedere ai sottoforum Sezione1 e Sezione3 ecc ecc
    basandoci sui dati del nostro db opportunamente adattati?

    Se sì, partirebbe la seconda domanda: come? :-)
    ma sarebbe già sufficiente sapere di lavorare su un obiettivo possibile!

    Grazie per l’attenzione

  8. Djtale

    Hello.

    Thank you for this tutorial. It is exactly what I need.
    But I have one question.

    I have my index.php with the form to login.

    When I log in, the form calls login_member.php in which I have my authentication process with the phpBB3Integration.class included.

    At the end of the authentication, I redirect the user to the index.php page. But if I try to use the variable $user, I have this error “Notice: Undefined variable: user”.

    Do I have to insert another code in index.php ?

    Thank you.

  9. Alberto Fontana

    Thanks for the tutorial, very helpful.
    Btw, i found a bug:
    When you insert a new user into phpbb_users table, you must insert the original username in “username” column, but in “username_clean” you must insert the username with all lowercase character. In your script, this doesn’t happen, being the username_clean not converted to lowercase. So, for example, if i create in my register.php script a user with uppercase letters (for example Alberto), the username_clean column will contain “Alberto” insted of “alberto”.
    why is this important? Because if i create a user in my register.php script with username containing some uppercase letter, i will never be able to login into the forum. Don’t ask me why, but it happens.

    How to fix this bug?

    Easy:
    change into phpbbintegration.class.php the following line
    $sql .= “NULL, ’0′, ’2′, ’00000000006xv1ssxs\ni1cjyo000000\nqlc4pi000000\nzik0zi000000′, ’0′, ‘” . $ip . “‘, ‘” . time () . “‘, ‘$username’, ‘$username’,”;
    with the following two lines
    $username_lower = strtolower($username);
    $sql .= “NULL, ’0′, ’2′, ’00000000006xv1ssxs\ni1cjyo000000\nqlc4pi000000\nzik0zi000000′, ’0′, ‘” . $ip . “‘, ‘” . time () . “‘, ‘$username’, ‘$username_lower’,”;

    Hope it helped

  10. Wing

    The createSqlToAddUserRow needs to escape the fields it’s adding.
    At present, this code is vulnerable to SQL injection.

  11. soesilo

    Thanks, but it lacks of these functions:
    -changeUsername() // to change forum’s username
    -deleteUser() // to delete a user upon website user deletion

  12. Chris

    i am pretty sure there is bug in filling username_clean in phpBB_users when using capital letters.

    as soon phpBB_users.usernameclean contains capital letters, the user is not recognized (not by phpBB admin, which is really strange), as soon as I manually changed phpBB_users.cleanname (its only the cleanname) to small letters only, everything works.

    you can see it at the bots, the username clean is always small letters.

  13. Michael

    Not sure if this is still reviewed, but I have a problem with the login portion. The addition of the user to phpbb works fine, but it will not log them in. I am using version 3. Any thoughts on where the issue might be? I have essentially the exact same code for the login as you mention above. Thanks.

  14. Naung

    Hi,
    I integrated phpbb w/ my php site as you instructed. It’s working great but new users who register thru my script are not showing as newest member. That is why I always click Resynchronise statistics in admin panel to show new members. Please advise for my issue.
    I really appreciate for your Integration class.
    Thank you,
    Naung

  15. Geert

    hi,

    for a schoolproject i got to make a website with a forum and a login using codeigniter.
    So I’m trying to implement this. but it isn’t working.
    any hints?

    (when i fix 1 error, the other one shows up , ….)

    thx

Post a comment

You may use the following HTML:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>