Integrating PHPBB3 with Zencart

[jvalent]

Well, I have tried this about 10 times now and I can't get it to work. I don't get error codes or nothing.

Nothing happens. One thing I noticed is that the login info required for Zen uses email address and you need a username on PhpBB which is not being created when you make an account in ZEN.

I am at the point where I need to hire someone to fix this problem. I need to get the site announced and start generating traffic. I cannot have users having to register in the store and then the forum.

Anyone who is interested please email me at [email protected] and let me know what you would charge to fix this.

Thanks

Jeff

[dmagic]

Whats the point if the user need regiter twicw
one to store and two to the forum ?

i can install the forum without the zen cart
anyone can explain what's the point ?

Thanks

[jvalent]

The point is that you try to make your site as user friendly to your customers so that they wan to come back. Registering for both Zen and the forums at one time is way more user friendly.

Jeff

[dmagic]

The point is that you try to make your site as user friendly to your customers so that they wan to come back. Registering for both Zen and the forums at one time is way more user friendly.

Jeff

but i can't register both it's not working .

[hookah]

You were pretty close! I got it to work but the only thing wrong in your code was that you assume that the config table is "phpbb_config" in all installations I have seen it is just "config" and therefore the update queries failed. But it was an easy fix, I just changed the table names to config and all is working nicely.

These are steps to integrate zencart 1.3.8 with phpbb3. This step will ensure your phpbb3 display appropriate Total number of user and Newest Member nickname at the board index.

1. Install your phpbb3 and ensure it runs perfectly.
2. Edit your configure.php replace

define('DIR_WS_PHPBB', 'C:/your server/www/phpbb3/'); 

with correct physical path to your phpbb installation.

3. Enable link to your phpbb3 from your zencart administrator. Inside your store configuration set the Link to phpbb3 to true.

4. edit "class.phpbb.php" inside your .../includes/classes folders. Try to find phpbb_create_account function and replace with the following code.

  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, group_id, username, username_clean, user_password, user_email, user_regdate)
                values
                ('" . (int)$user_id . "',2, '" . $nick . "', '" . $nick . "', '" . md5($password) . "', '" . $email_address . "', '" . time() ."')";
        $this->db_phpbb->Execute($sql);
        $sql = "update phpbb_config SET config_value = '{$user_id}' WHERE config_name = 'newest_user_id'";
        $this->db_phpbb->Execute($sql);
        $sql = "update phpbb_config SET config_value = '{$nick}' WHERE config_name = 'newest_username'";
        $this->db_phpbb->Execute($sql);
        $sql = "update phpbb_config SET config_value = config_value + 1 WHERE config_name = 'num_users'";
        $this->db_phpbb->Execute($sql);


        $sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending)
                VALUES ($user_id, 2, 0)";
        $this->db_phpbb->Execute($sql);
      }
    } 

5. Enjoy your nicely integrated phpbb3 forum with zencart, and if you find better solution please let me know

You can find other zencart tips and tricks at my blog - ferolen.com/blog

[jvalent]

Where specifically did you change it cause I still cant get mine to work

Jeff

[DrByte]

Does this help? http://www.zen-cart.com/forum/showthread.php?t=111251

[dmagic]

where is phpbb_create_account ?

Thanks .

[Veronika7747]

i am not sure if this has been brought before....

..some text deleted..

Forums info:
To delete the test account login to your forums ACP > users and groups > find a member > click the 'last' page of your users > (your test account will be the last one, it is listed chronological) > select > submit > delete user: > retain posts > submit > confirm

.

Well I created two new "users" via zencart that I cannot delete from phpbb3 by following the info above. I can see those 2 names but when I select them and hit "submit" I get an error Information - The requested user does not exists.

I have changed the config.php, used the new class.phpbb.php, get an correct error message if "nick" exists, I get the "new member" showing in my footer on phpbb3, but cannot login with those two accounts and cannot delete them!Any help??
Both zencart and phpbb3 are new no active users.

[jhardman]

So, I have put in this code in my class.phpbb.php file:

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?
      }
    }

Everything pretty much works. Both accounts are created and all info in every table is updated correctly. The problem is that after clicking submit I just get a blank white page. Nothing. If I hit back, then I can see I am logged into the store. My phpbb login works too.

The URL I am taken too when clicking submit on the registration is

http://stungunsdefense.com/index.php...create_account

What could be causing this problem?