Complete jFusion / phpBB 3 / Community Builder Thread

[darksoul88]

works with the core SEF?

[anniejackson]

Umm...I applied this hack but something strange has happened. My profile button is gone. Wasn't this hack supposed to link the forum to CB? Such as by using the profile link to link to the CB profile...? Or did I misunderstand the purpose of this hack?

[anniejackson]

Nevermind, my fault! I was putting my own comments throughout the file (trying to learn php) and I accidentally commented out a parenthesis.

Works great, this is awesome!! Because I am using Mehdi bridge I just opened both your viewtopic and the inc_viewtopic files and changed the code that differed. If anyone is using Mehdi I've attached the "new" inc_viewtopic (though no promises that I haven't done some other changes as I mess around in my core files quite a lot in an effort to learn). I still maintain that it is best to not use Mehdi but I know some people (like me) are for various reasons so hopefully this helps you.

[anniejackson]

Does anyone know how to add a PM link (into phpbb3) to the CB profile page?

[anniejackson]

Does anyone know how to add a PM link (into phpbb3) to the CB profile page?

Hi *waves*

I finally figured out how to do this and it is embarrassingly easy. Simply create a new field in CB and make it a "field delimiter" then in the description, in the WYSIWYG view of the editor (not html view - at least html didn't work for me) write the a href code as you normally would on the html side and where you need the user id you just write "user_id" with square brackets around it (where those quotes are).

[marcoo]

This thread is becoming soo long, and some discussion has become obsolete, so it's probably good to make a status update on the integration joomla/phpbb and community builder

Can someone answer this:
Is it possible right now (latest bridge version) when Joomla is master and phpbb slave:
-to show phpbb avatar in cb profile?
-to show phpbb recent messages in cb profile?
-to change password from within cb profile?
-to change password from within phpbb profile?

[anniejackson]

Is it possible right now (latest bridge version) when Joomla is master and phpbb slave:
-to show phpbb avatar in cb profile?
Yes, but actually it's the other way around, you can get phpbb to use CB's avatar.
-to show phpbb recent messages in cb profile?
Yes, instructions are in this thread however be aware that threads from private forums DO show.
-to change password from within cb profile?
Yes, because phpbb is the slave which means CB (Joomla) is in control of this.
-to change password from within phpbb profile?
I don't know, not in my configuration because I turned it off (I can't remember if that was part of Jfusion set up or not)

You can see all this at http://www.fashionstudentsonline.com - you have to be registered to see profiles though. Not all users have posts in the forum so go to the forum first and then click on profile to see how the forum postings look on the CB profile.

It's a lot of work to get them integrated though, fyi

[yukos]

hi

thanks for your post - it is very nice for me and I love it - but I build phpbb and joomla in 2 database seprately - Do you have any solution for me?

tks in advance

[argentario84]

For those still interested in a hack that works fine without sh404SEF.

After having a look into the jfusion database tables I don't fully understand why a synchronisation is absolutely necessary, although it'd make life a few keystrokes easier.

Line 1116 in phpBB 3.0.5

Code: Select all

// Only show the link if not anonymous
   if ($mode != 'no_profile' && $user_id && $user_id != ANONYMOUS)
   {
      // Do not show the link if the user is already logged in but do not have u_viewprofile permissions (relevant for bots mostly).
      // For all others the link leads to a login page or the profile.
      if ($user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile'))
      {
         $profile_url = '';
      }
      else
      {

   $result = mysql_query("SELECT * FROM jos_jfusion_users_plugin WHERE userid=".$user_id);
   $row = mysql_fetch_array($result);
      
         $profile_url = "index.php?option=com_comprofiler&task=userProfile&user=".$row['id']." \" target=\"_parent\"";

      }
   }

This compares the two IDs which are conveniently stored in the same table and retrieves the Joomla ID after sourcing the corresponding phpBB ID. A crude hack but easily removed come update season.

Hi!
first of all, sorry for my bad english...

I put this code in functions_content.php and work great in the site... but when i login in the control panel of phpBB, i've got these errors...

Code: Select all

[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: A link to the server could not be established
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1128: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: A link to the server could not be established
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1128: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: A link to the server could not be established
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1128: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: A link to the server could not be established
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1128: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1127: mysql_query() [function.mysql-query]: A link to the server could not be established
[phpBB Debug] PHP Notice: in file /includes/functions_content.php on line 1128: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

some help?

[deathorglory]

I went through this entire thread post by post trying to figure out what to do. Id rather not hack anything (thats why I love jfusion so much) but I am trying to get my CB integrated with my phpbb3; That said, I saw a few posts that auto-integration would be out come 1.1.3. Its now 1.2.3 and was wondering if this is an option yet?

Thanks so much for this wonderful component. It really is worth $500,000

Your friend,
Adam