The challenge: Make a profile link point to a different profile!

[classixuk]

I very much doubt that this can be solved as I have asked on other boards and people seem to shy away from this, or cannot solve it.

 

This website looks more promising, so I have bookmarked it and here is my first challenge!

 

I am running an installation of Joomla 1.5.7 with Community builder, and phpBB 3.0.2.

 

I need to point user profiles in phpBB to the existing user profiles in Community builder (2 different databases held on the same domain).

 

So, in phpBB, the profile URLs are formatted like this:

 

http://www.yourdomain.com/community/memberlist.php?mode=viewprofile&u={userid}

 

In Joomla, the profile URLS are formatted like this:

 

http://www.yourdomain.com/index.php?option=com_comprofiler&task=userProfile&user={userid}

 

I can alter the phpBB profile link without a problem, but the issue is that phpBB and Joomla use different user id's for the same person.

 

However, the usernames are always the same and also unique.

 

So my thinking is that:

 

In phpBB, $profileuserid should = Get phpbb username that is linked to the current phpbb userid. Open the jos.users table in the Joomla database. Find the {joomlausername} that correlates with the {phpbbusername}. From that same row, get the {joomlauserid}.

 

And then the link hack in phpBB would be:

[code]http://www.yourdomain.com/index.php?option=com_comprofiler&task=userProfile&user={$profileuserid}

[/code]

 

 

And yet, nobody so far on other boards seems to be able to direct me on how to code up these instructions?

 

What about you guys? Are you able to fathom this one out?

 

I am very new to php so still learning. Forgive me if I think this is simpler than it sounds.

 

Thanks for any help or guidance you can give.

 

Chris

[trq]

In phpBB, $profileuserid should = Get phpbb username that is linked to the current phpbb userid. Open the jos.users table in the Joomla database. Find the {joomlausername} that correlates with the {phpbbusername}. From that same row, get the {joomlauserid}.

 

That sounds like a plan. Where exactly are you stuck?

[Mchl]

Where exactly are you stuck?

 

I suppose in phpBB's messy code...