Simple Joomla1.5 Bridge for phpBB3.0

Do you have an Open Source Product available for Joomla!? Let everyone know here.
Forum rules
Global Rules
Additional Rules for this forum <------- Please read before posting
mikovchain
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Fri Nov 09, 2007 5:35 am

Simple Joomla1.5 Bridge for phpBB3.0

Post by mikovchain » Fri Nov 09, 2007 5:43 am

#######################################################
## Title: Joomla1.5 User Bridge for phpBB3.0
## Author: IOsetting
## Description:
##      Integrate phpBB3 with Joomla1.5
## Version: 1.1 (Build 20080207)
##
## Installation Level: Easy
## Installation Time: 10 Minutes
## Download
## Demo
#######################################################

BEFORE INSTALL:
1. This bridge can handle one database only, which means your joomla and phpBB3 should be installed in the same database.


phpBB3:

1. COPY /phpbb_files/includes/auth/auth_db.php TO /includes/auth/auth_db.php
2. COPY /phpbb_files/includes/auth/helper.php TO /includes/auth/helper.php
3. OPEN
    /includes/auth/auth_db.php
    FIND
    jos_users
    REPLACE WITH
   


Joomla1.5:

1. COPY /libraries/phpbbtools TO /libraries/phpbbtools
2. COPY /adminstrator/language/en-GB/en-GB.plg_user_phpbb3.ini TO /adminstrator/language/en-GB/en-GB.plg_user_phpbb3.ini
3. Install the plugin in folder /plugins/user
4. Modify the 'phpbb db prefix' property of 'User-phpbb3' in Plugin Manager, it's 'phpbb_' by default
5. Enable 'User-phpbb3', disable 'User - Joomla!' in Plugin Manager.


Joomla style rhuk_milkyway for phpBB3:

1. COPY /phpbb_files/styles/prosilver/templateoverall_header.php, overall_footer.php TO /styles/prosilver/template
2. COPY /phpbb_files/styles/prosilver/theme/*.css TO /styles/prosilver/theme/
3. COPY /phpbb_files/styles/prosilver/theme/images/* TO /styles/prosilver/theme/images/
4. OPEN /styles/prosilver/theme/common.css
    FIND AND DELETE
    background-color: #FFFFFF;
   
    ADD following lines at the end of common.css:
    #page-header, #page-body, #page-footer {
margin: 0 21px 0px 21px;
background: #fff;
width: auto;
    }
    SAVE and CLOSE
   
    OPEN /styles/prosilver/theme/colours.css
    FIND AND DELETE
    background-color: #FFFFFF;
   
    SAVE and CLOSE, then refresh the prosilver theme in your phpbb ACP

If you have any questions, please feel free to ask in this forum
Last edited by mikovchain on Thu Feb 07, 2008 10:04 am, edited 1 time in total.

daskog
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Sun Sep 18, 2005 2:51 am
Location: Norway

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by daskog » Fri Nov 09, 2007 12:16 pm

Yeah sounds cool.

mikovchain
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Fri Nov 09, 2007 5:35 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by mikovchain » Fri Nov 09, 2007 6:48 pm

The demo is here
In this demo, two applications are both using the user name and password from joomla.(I think it's better let phpBB be sync with Joomla)

1. When you create joomla account, you will get an "Object id #124" error. It's a bug of joomla 1.5RC3. Don't worry about it.
2. Before you test the login/logout sync feature, you need log on phpBB once.

3. Login/logout joomla will also login/logout phpBB(after you finish step2), while login/logout phpBB won't affect joomla.
Last edited by mikovchain on Sun Nov 11, 2007 1:35 pm, edited 1 time in total.

mikovchain
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Fri Nov 09, 2007 5:35 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by mikovchain » Mon Nov 12, 2007 3:36 am

Updated with Joomla-like phpBB3 style  8)

palebluedot
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Sat Jul 15, 2006 8:24 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by palebluedot » Fri Nov 16, 2007 5:58 am

Keep up the good work.

adamhearn
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Mon Dec 05, 2005 8:06 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by adamhearn » Wed Nov 21, 2007 12:31 am

Looks like a great start - thanks for sharing!

User avatar
Casey Lee
Joomla! Explorer
Joomla! Explorer
Posts: 312
Joined: Sat Sep 03, 2005 10:22 pm
Location: AL
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by Casey Lee » Thu Dec 13, 2007 11:09 pm

This looks nice. I'll be glad to make some GPL phpbb3/joomla templates as soon as a bridge is available. keep up the good work!

User avatar
baijianpeng
Joomla! Guru
Joomla! Guru
Posts: 516
Joined: Mon Mar 20, 2006 3:17 pm
Location: China
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by baijianpeng » Mon Dec 17, 2007 6:08 am

I read the readme file in this simple bridge. There is one thing that I can't understand.

The author asks to replace some strings in the original sql file with
CHARACTER SET `utf8` COLLATE `utf8_bin`
why utf8_bin ? why not utf8_general_ci or utf8_unicode_ci ?

Thanks.
JoomlaGate - Chinese Joomla Users' Portal

http://www.joomlagate.com

mikovchain
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Fri Nov 09, 2007 5:35 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by mikovchain » Thu Feb 07, 2008 10:03 am

This bridge now supports Joomla1.5 stable and phpBB3.0.0
The installation is more easier.

Michael62
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Feb 06, 2008 10:08 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by Michael62 » Thu Feb 07, 2008 2:13 pm

Some problems with Demo (see screenshot)
You do not have the required permissions to view the files attached to this post.

mikovchain
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Fri Nov 09, 2007 5:35 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by mikovchain » Fri Feb 08, 2008 4:27 am

:)Hah, I didn't test it in IE. I am always using FF only. You are right there are some problems in the theme. I have update the package, now it works with IE.

jaswanttak
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Jun 04, 2007 2:21 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by jaswanttak » Fri Mar 14, 2008 1:21 pm

Dear All,

I have installed Joomla! 1.0.12 Stable version for my site, and want to integrate this with my running phpBB forum. for the phpBB I have 3.0 version. So could anybody please help me to integrate my joomla1.0.12 with phpBB3.0

Thanks
Jaswant

vinnie19
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Tue Aug 28, 2007 3:15 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by vinnie19 » Fri Mar 14, 2008 7:20 pm

3. Install the plugin in folder /plugins/user
How do you install this?
Because its not a package that are just 2 files.
And when i put them in the directory then i cant find them in my joomla

User avatar
N6REJ
Joomla! Explorer
Joomla! Explorer
Posts: 340
Joined: Sun Nov 27, 2005 9:25 am
Location: Ponca City, OK
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by N6REJ » Fri Mar 14, 2008 9:50 pm

How would you do this for commuinity builder?
Bear

dzungvn
Joomla! Apprentice
Joomla! Apprentice
Posts: 22
Joined: Mon May 29, 2006 12:35 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by dzungvn » Sat Mar 15, 2008 1:08 pm

Hi there,

I would love to try this, however, I am gone with JA_purity template already. can you give the suggestion stepwise to create a template for phpBB3 that is matched with joomla in JAPurity template?

any inputs is appreciated.

vinnie19
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Tue Aug 28, 2007 3:15 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by vinnie19 » Sun Mar 16, 2008 8:08 pm

The bridge works fine. But i get one problem when i want to login to the admin panel

This error i get

Code: Select all

SQL ERROR [ mysql4 ]

Incorrect table name '' [1103]

SQL

SELECT `id`, `username`, `usertype`, `email`, `gid`, `registerDate`, `lastvisitDate`, `password` FROM `` WHERE username= 'forum admin'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/auth/auth_db.php
LINE: 47
CALL: dbal_mysql->sql_query()

FILE: includes/auth.php
LINE: 784
CALL: login_db()

FILE: includes/functions.php
LINE: 2263
CALL: auth->login()

FILE: adm/index.php
LINE: 33
CALL: login_box()

EMRhelp
Joomla! Guru
Joomla! Guru
Posts: 510
Joined: Sat Aug 20, 2005 4:12 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by EMRhelp » Mon Mar 17, 2008 2:59 am

To demo it,

I created a demo account:

Login: test1
Pass: test1

lisazhou
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Mar 17, 2008 11:17 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by lisazhou » Mon Mar 17, 2008 11:38 am

i do it ,but i can not realization phpBB be sync with Joomla??
anybody can help me?

User avatar
chipshot
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Mar 13, 2008 11:47 am
Location: New York
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by chipshot » Tue Mar 18, 2008 12:38 am

I went through all the steps but now phpbb has lost the Administrator acct. so I can't log in as admin and refresh.
how can I recreate the admin acct.
Thank You,
chipshot

vinnie19
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Tue Aug 28, 2007 3:15 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by vinnie19 » Tue Mar 18, 2008 6:23 am

chipshot wrote:I went through all the steps but now phpbb has lost the Administrator acct. so I can't log in as admin and refresh.
how can I recreate the admin acct.
Thank You,
chipshot
Same problem here.
Look a earlier post of me there is the fould code what i get when i want to enter admin. panel

User avatar
chipshot
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Mar 13, 2008 11:47 am
Location: New York
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by chipshot » Wed Mar 19, 2008 8:22 am

well I don't get any error it just wiped out the admin acct in PHPBB
so I have no way of loggin into phpbb under a admin acct.

5942marine
Joomla! Apprentice
Joomla! Apprentice
Posts: 29
Joined: Mon Sep 24, 2007 9:13 pm
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by 5942marine » Thu Mar 20, 2008 3:30 pm

For some reason, part of the forum is outside of the main border, does anybody know what to tweak, to get it inside.

See image...
You do not have the required permissions to view the files attached to this post.

User avatar
chipshot
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Mar 13, 2008 11:47 am
Location: New York
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by chipshot » Fri Mar 21, 2008 3:41 am

I have the same exact issue...

5942marine
Joomla! Apprentice
Joomla! Apprentice
Posts: 29
Joined: Mon Sep 24, 2007 9:13 pm
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by 5942marine » Fri Mar 21, 2008 3:56 am

Figured out what it was. I never cleared the cache.

In the ACP, go to Styles -> Themes -> then click on 'refresh' on the right side.

After I did that, everything works like a charm.

User avatar
chipshot
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Mar 13, 2008 11:47 am
Location: New York
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by chipshot » Fri Mar 21, 2008 3:58 am

yes I stumbled onto that myself

but now how do I change the links int the top menu & the default bkgnd color?

Thanks,
chipshot

User avatar
chipshot
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Mar 13, 2008 11:47 am
Location: New York
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by chipshot » Fri Mar 21, 2008 4:02 am

also sorry to bump

I get this error in the phpbb acp
from:
styles/templates/prosilver/edit

[phpBB Debug] PHP Notice: in file /includes/acp/acp_styles.php on line 760: array_diff() [function.array-diff]: Argument #1 is not an array
[phpBB Debug] PHP Notice: in file /includes/acp/acp_styles.php on line 820: Invalid argument supplied for foreach()

User avatar
beduino
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Wed Aug 31, 2005 12:59 am
Location: Rio de Janeiro, Brasil
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by beduino » Fri Mar 21, 2008 4:37 am

hello
in instruction we see
jos_users
REPLACE WITH
replace with ??? blank?

tks in advance
joao barroca
aka beduino

User avatar
chipshot
Joomla! Apprentice
Joomla! Apprentice
Posts: 34
Joined: Thu Mar 13, 2008 11:47 am
Location: New York
Contact:

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by chipshot » Fri Mar 21, 2008 7:02 am

REPLACE WITH
<your joomla user table name>

Thebroken
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Wed Feb 13, 2008 4:43 pm

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by Thebroken » Fri Mar 21, 2008 3:05 pm

Download is dead? When I click to download the file, I get a "Server Timed Out" issue.

Also, has the admin problem been fixed?

*Added* There we go, after refreshing a bunch, finally got the download started.

I'm sorry if this is a dumb question, but how do I know which table has my users listed?

Would it be jos_comprofiler_members? if it's not jos_user

I'm not Too Familiar with the inside workings of Mysql

Kdar
Joomla! Intern
Joomla! Intern
Posts: 66
Joined: Sun Dec 17, 2006 5:43 am

Re: Simple Joomla1.5 Bridge for phpBB3.0

Post by Kdar » Sat Mar 22, 2008 12:47 pm

So... Before doing this, does PHPBB3 and Joomla have to be installed already?


Locked

Return to “Open Source Products for Joomla!”