Page 5 of 9 FirstFirst ... 34567 ... LastLast
Results 41 to 50 of 82
  1. #41
    Join Date
    Jul 2005
    Posts
    538
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Quote Originally Posted by whoknowswhat View Post
    I get an error...
    [20-Jun-2008 15:21:27] PHP Parse error: syntax error, unexpected T_VARIABLE, expecting T_FUNCTION in /class.phpbb.php on line 363

    I get that from the zencart debug tool, sad thing is, there is no line 363.... It also makes my index.php show up blank.....
    That sort of thing is symptomatic of having either bad files (bad upload) or you've created a PHP syntax error in one of your customizations.

  2. #42
    Join Date
    Feb 2008
    Posts
    7
    Plugin Contributions
    0

    help question Re: Integrating PHPBB3 with Zencart

    I have made this changes, but its not working. please HELP.
    Is there any need to make changes in classes.phpbb.php file

    Please tell me all the information to integrate PHPBB with zencart step by step if possible.

    Thanks

  3. #43
    Join Date
    Feb 2008
    Posts
    7
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Quote Originally Posted by felixh View Post
    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
    PHP Code:
    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.

    PHP 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
    I have made this changes, but its not working. please HELP.
    Is there any need to make changes in classes.phpbb.php file

    Please tell me all the information to integrate PHPBB with zencart step by step if possible.

    Thanks

  4. #44
    Join Date
    Jun 2008
    Location
    MI, USA
    Posts
    7
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Quote Originally Posted by chuck View Post
    That sort of thing is symptomatic of having either bad files (bad upload) or you've created a PHP syntax error in one of your customizations.
    It very well could be, I'll give it another shot when I have time.....

  5. #45
    Join Date
    Feb 2005
    Location
    New Jersey
    Posts
    646
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    I just added a forum to my site again and tried integrating with my Zen Cart. I changed my config files to show where my forum is located and I "turned on" the switch in my admin section. But...when I create a test account to check for the integration I ma getting the following error;

    1062 Duplicate entry '' for key 2
    in:
    [insert into phpbb_users (user_id, username, user_password, user_email, user_regdate) values ('56', 'josiej', '791ea51bfed310e8a28379a7cef11362', 'josie@mysite.com', '1215149682')]
    I tried it with a few different names just in case there is actually someone that used the same nick name back when I had the forum before and it does the same thing.

    Any ideas?

    Thanks,
    Kelly

  6. #46
    Join Date
    Jun 2008
    Posts
    7
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Quote Originally Posted by deepiristo View Post
    I have made this changes, but its not working. please HELP.
    Is there any need to make changes in classes.phpbb.php file

    Please tell me all the information to integrate PHPBB with zencart step by step if possible.

    Thanks
    In case you have not figure out. Felixh hardcodes his config table name which you might not be the same naming convention with yours. Here is what you can do:

    Replace
    "update phpBB_config SET config value ...

    to
    "update " . $this->phpBB['config_table'] . " SET config_value ...

    There are total of three lines that you need to change.
    Hope that works out for you.

  7. #47
    Join Date
    May 2008
    Posts
    6
    Plugin Contributions
    1

    Default Re: Integrating PHPBB3 with Zencart

    *Bolded items in red are changes from original posts*

    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 includes/configure.php replace
    PHP Code:
    Code:
    define('DIR_WS_PHPBB', 'C:/your server/www/phpbb3/');
    with correct VIRTUAL path to your phpbb installation 'phpbb3/' (no leading /).

    3. Enable link to your phpbb3 from your zencart administrator. Inside your store configuration set the “Link to phpbb” 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.
    PHP Code:
    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 " . $this->phpBB['config_table'] . "SET config_value = '{$user_id}' WHERE config_name = 'newest_user_id'"; 
            $this->db_phpbb->Execute($sql); 
            $sql = " update " . $this->phpBB['config_table'] . "SET config_value = '{$nick}' WHERE config_name = 'newest_username'"; 
            $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); 
    
    
            $sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending) 
                    VALUES ($user_id, 2, 0)"; 
            $this->db_phpbb->Execute($sql); 
          } 
        }
    Modified from work by deepiristo and Vypero. Tested with ZC 1.38a and phpBB 3.0.2

    Note that phpbb3 is installed as a subdirectory (store/phpbb3) within zencart with a link of http://www.example.com/forums.
    Separate installs will still need to provide the PHYSICAL path.
    Last edited by nzinni; 1 Aug 2008 at 12:53 AM.

  8. #48
    Join Date
    Apr 2008
    Posts
    23
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Is it possible to do exactly the opposite ???
    I mean is it possible for users accessing my forum first to register in the forum and make that registration active in my ZenCart site ?

    ho.. and thanx for the tip ... it worked for me ;)

  9. #49
    Join Date
    May 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Quote Originally Posted by nzinni View Post
    *Bolded items in red are changes from original posts*

    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 includes/configure.php replace
    PHP Code:
    Code:
    define('DIR_WS_PHPBB', 'C:/your server/www/phpbb3/');
    with correct VIRTUAL path to your phpbb installation 'phpbb3/' (no leading /).

    3. Enable link to your phpbb3 from your zencart administrator. Inside your store configuration set the “Link to phpbb” 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.
    PHP Code:
    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 " . $this->phpBB['config_table'] . "SET config_value = '{$user_id}' WHERE config_name = 'newest_user_id'"; 
            $this->db_phpbb->Execute($sql); 
            $sql = " update " . $this->phpBB['config_table'] . "SET config_value = '{$nick}' WHERE config_name = 'newest_username'"; 
            $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); 
    
    
            $sql = "INSERT INTO " . $this->phpBB['user_group_table'] . " (user_id, group_id, user_pending) 
                    VALUES ($user_id, 2, 0)"; 
            $this->db_phpbb->Execute($sql); 
          } 
        }
    Modified from work by deepiristo and Vypero. Tested with ZC 1.38a and phpBB 3.0.2

    Note that phpbb3 is installed as a subdirectory (store/phpbb3) within zencart with a link of http://www.example.com/forums.
    Separate installs will still need to provide the PHYSICAL path.
    Hi, I followed these instructions above but get the following error after creating a new account in Zen Cart:

    [FONT=Times New Roman]1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '54' WHERE config_name = 'newest_user_id'' at line 1
    in:
    [ update phpbb_configSET config_value = '54' WHERE config_name = 'newest_user_id']
    [/FONT]

    I've looked at that section of the code in class.phpbb.php but cannot see a problem. I've also checked the MySQL database, and indeed the newest_user_id value in the phpbb_config table is still set to 2, instead of 54 which i guess is what it should be, according to the error message. i actually only have 2 users at the moment, but in the mySql phpbb_users table there are lots of users for search engines etc that take up 52 rows, is that normal?

    any help would be greatly appreciated! my forum is at www.purlalpacadesigns.com/pads and i have updated my zen cart includes/configure.php file with the firtual directory for phpbb (just "pads/" without the first backslash.

    thanks for any help!

    Kyle

  10. #50
    Join Date
    May 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: Integrating PHPBB3 with Zencart

    Hi, i found out what my problem was with the class.phpbb.php edits listed above. there was simply a SPACE [ ] missing before the word "SET" on three lines of the create account function here:

    $sql = " update " . $this->phpBB['config_table'] . " SET config_value = '{$user_id}' WHERE config_name = 'newest_user_id'";
    $this->db_phpbb->Execute($sql);
    $sql = " update " . $this->phpBB['config_table'] . " SET config_value = '{$nick}' WHERE config_name = 'newest_username'";
    $this->db_phpbb->Execute($sql);
    $sql = " update " . $this->phpBB['config_table'] . " SET config_value = config_value + 1 WHERE config_name = 'num_users'";

    the version i have typed in above includes the space, before it looked like this:

    "SET

    hope that helps people!

    kyle

 

 
Page 5 of 9 FirstFirst ... 34567 ... LastLast

Similar Threads

  1. Integrating my payment gateway with zencart
    By gpgoud in forum General Questions
    Replies: 3
    Last Post: 19 Sep 2009, 07:48 AM
  2. [Request] Integrate ZenCart with phpBB3
    By austin881 in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 17 Jun 2008, 10:34 AM
  3. Replies: 11
    Last Post: 30 Apr 2008, 06:21 PM
  4. Integrating ZenCart With My Design ??
    By Jack Gleeson in forum Templates, Stylesheets, Page Layout
    Replies: 11
    Last Post: 19 Oct 2006, 05:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR