Integrating PHPBB3 with Zencart

[IllusionGuy]

I am also looking to intergrate Zen Cart and phpBB3, Zen Cart and phpBB3 is like peanut butter and chocolate they just go togeather! It would also be nice to get phpBB to work within a page with in Zen Cart so that your customer never leaves your store.

[sadr1an1]

I have succesfuly begin integration with phpbb3, all i have managed to do is sincronising account creation from zencart into phpbb. After the modification in admin section Configuration->My store->Enable phpBB linkage? = true, and the config file, i have to modify class.phpbb.php, just the following function:


function phpbb_create_account($nick, $password, $email_address) {
if ($this->phpBB['installed'] != true || !zen_not_null($password) || !zen_not_null($email_address) || !zen_not_null($nick)) return false;
if ($this->phpbb_check_for_duplicate_email($email_address) == 'already_exists') {
// $this->phpbb_change_email($old_email, $email_address);
} else {
$sql = "select max(user_id) as total from " . $this->phpBB['users_table'];
$phpbb_users = $this->db_phpbb->Execute($sql);
$user_id = ($phpbb_users->fields['total'] + 1);
$sql = "insert into " . $this->phpBB['users_table'] . "
( username,username_clean, user_password, user_email, user_regdate)
values
( '" . $nick . "','" . $nick . "', '" . md5($password) . "', '" . $email_address . "', '" . time() ."')";
$this->db_phpbb->Execute($sql);
//could do a check here to see if Insert_ID() matches $user_id...


// @TODO: MySQL5

//$sql = "INSERT INTO " . $this->phpBB['groups_table'] . " (group_name, group_desc, group_single_user, group_moderator)
// VALUES (0, 'Personal User', 1, 0)";
//$this->db_phpbb->Execute($sql);
//$group_id = $this->db_phpbb->Insert_ID();
$sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending)
VALUES ($user_id, 2, 0)";
$this->db_phpbb->Execute($sql);
//might optionally send an extra email welcoming them to the phpBB forum, reminding them of their nickname?
}
}



Now when i register a new user in zencart it will be registered in phpbb too.
Now i'm loking for something like wordpress integration: wordpress is oppend inside zencart. If iwon\t find anithing usefull this day i will start customisation myself.

[rainthebat]

Hi sadr1an1,

It looks like you got the furthest. Could you be a little more explicit in your instructions, I can't find the code that you are replacing.

[lazerradial2003]

Great work sadr1an1, this has been driving me crazy, your function works a treat.

rainthebat: the file is includes/classes/class.phpbb.php and you need to replace the function phpbb_create_account with sadr1an1's version of it.

Next step would be to find a way of combining sessions, so that logging into either the forum or zen cart logged the user into the other part of the site. Any suggestions from anyone?

[Frenchy]

Génial sadr1an1,

Ça fonctionne parfaitement.

Cordialement..........

[madmumbler]

Yes!!! I finally got it to work!!!

Not sure exactly what I did.... *LOL*

I had to hack the templates/template_default/templates/tpl_modules_create_account.php

and saved it to my custom template folder so it would display the nickname field.

I had to set the phpBB forum to default to Registered User for new members. (It wasn't before, and I've never used phpBB before, so it took me a while to figure it out.) Once I did that, it allowed new users to post.

muwaHAHAHAHAHA!!!!!!

On to conquering the world! Well, okay, Joomla login. But YAY ME!

THANK YOU sadr1an1!!!!!!!!!

[madmumbler]

Okay, I realized that while it does pass the user across the database to populate the forum, it doesn't pass the login status.

Anyone have any ideas how to do that?

[neteasy]

I have to update the CONFIG table in PHPBB3 so the newest member will be displayed on the PHPBB3 homepage

    function phpbb_create_account($nick, $password, $email_address) {
      if ($this->phpBB['installed'] != true || !zen_not_null($password) || !zen_not_null($email_address) || !zen_not_null($nick)) return false;
      if ($this->phpbb_check_for_duplicate_email($email_address) == 'already_exists') {
//        $this->phpbb_change_email($old_email, $email_address);
      } else {
        $sql = "select max(user_id) as total from " . $this->phpBB['users_table'];
        $phpbb_users = $this->db_phpbb->Execute($sql);
        $user_id = ($phpbb_users->fields['total'] + 1);
//        $sql = "insert into " . $this->phpBB['users_table'] . "
//                (user_id, username, user_password, user_email, user_regdate)
//                values
//                ('" . (int)$user_id . "', '" . $nick . "', '" . md5($password) . "', '" . $email_address . "', '" . time() ."')";
        $sql = "insert into " . $this->phpBB['users_table'] . "
                ( username,username_clean, user_password, user_email, user_regdate, user_passchg, group_id, user_permissions, user_sig, user_occ, user_interests, user_email_hash)
                values
                ( '" . $nick . "','" . $nick . "', '" . md5($password) . "', '" . $email_address . "', '" . time() . "', '" . time(). "', 2, '', '', '', '', '" . crc32(strtolower($email_address)) . strlen($email_address) . "')";
        $this->db_phpbb->Execute($sql);
//could do a check here to see if Insert_ID() matches $user_id...

    $sql = "SELECT user_id, username, user_colour
        FROM " . $this->phpBB['users_table'] . "
        WHERE user_type IN ('0', '3')
        ORDER BY user_id DESC LIMIT 1";
    $phpbb_newest_user = $this->db_phpbb->Execute($sql);

    $sql = "UPDATE " . $this->phpBB['config_table'] . "
        SET config_value = '" . $phpbb_newest_user->fields['user_id'] . "'
        WHERE config_name = 'newest_user_id'";
    $this->db_phpbb->Execute($sql);
    
    $sql = "UPDATE " . $this->phpBB['config_table'] . "
        SET config_value = '" . $phpbb_newest_user->fields['username'] . "'
        WHERE config_name = 'newest_username'";
    $this->db_phpbb->Execute($sql);    
    
    $sql = "UPDATE " . $this->phpBB['config_table'] . "
        SET config_value = '" . $phpbb_newest_user->fields['user_colour'] . "'
        WHERE config_name = 'newest_user_colour'";
    $this->db_phpbb->Execute($sql);    
    
    $sql = "UPDATE " . $this->phpBB['config_table'] . "
        SET config_value = config_value + 1 
        WHERE config_name = 'num_users'";
    $this->db_phpbb->Execute($sql);

// @TODO: MySQL5

//      $sql = "INSERT INTO " . $this->phpBB['groups_table'] . " (group_name, group_desc, group_single_user, group_moderator)
//              VALUES (0, 'Personal User', 1, 0)";
//      $this->db_phpbb->Execute($sql);
//      $group_id = $this->db_phpbb->Insert_ID();
        $sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending)
                VALUES ($user_id, 2, 0)";
        $this->db_phpbb->Execute($sql);
        //might optionally send an extra email welcoming them to the phpBB forum, reminding them of their nickname?
      }
    } 

[madmumbler]

I didn't have to do that -- it passed them through okay for me. Just not the login status.

[neteasy]

but phpbb3 will not show the correct "newest member" and "total members" if I use sadr1an1's function

zencart user has to login to PHPBB3 separately.