forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: polle on April 25, 2007, 09:27:33 pm

Title: [Closed]: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: polle on April 25, 2007, 09:27:33 pm
Hi, is there any documentation, files, tests or something going on in bridging beta 5 of phpBB 3 ?
I already tried with the current options with no luck, someone has any helpfull info for this ?

Thanks.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: mmstream on May 04, 2007, 08:55:00 am
Hello,

PHPBB3 is still in beta processing and they didn't make nay modifications for their phpb33 olympus yet. So I think , from the coppermine gallery point of view, they didn't make integration system or docs for the beta testing yet. Because anything is not stable yet.When their phpb33 olympus release, coppermine will make it for sure. So wait for the phpbb3 release.

Thanks.

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: polle on May 14, 2007, 09:23:39 pm
Hello,

PHPBB3 is still in beta processing and they didn't make nay modifications for their phpb33 olympus yet. So I think , from the coppermine gallery point of view, they didn't make integration system or docs for the beta testing yet. Because anything is not stable yet.When their phpb33 olympus release, coppermine will make it for sure. So wait for the phpbb3 release.

Thanks.


Thanks mmstream, I thought as the structure of Beta 5 will be the same as the Final, someone had already done something for integrating it, as things will not change.

If someone else has some info, it will be apreciated.

Thanks.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: ladysarajane on May 15, 2007, 12:13:22 am
Thanks mmstream, I thought as the structure of Beta 5 will be the same as the Final, someone had already done something for integrating it, as things will not change.

If someone else has some info, it will be apreciated.

Thanks.

Phpbb3 RC1 release and Beta 5 will not be the same at all. There are database improvements as well as a new default skin. Developers have been holding back, because of the changes that have occurred in the daily CVS releases and the beta release. Note that beta should not have been running live either. Phpbb will not support anyboards that are converted from beta to RC1. Only from phpbb2 to RC1.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: polle on May 20, 2007, 11:44:54 pm
Phpbb3 RC1 release and Beta 5 will not be the same at all. There are database improvements as well as a new default skin. Developers have been holding back, because of the changes that have occurred in the daily CVS releases and the beta release. Note that beta should not have been running live either. Phpbb will not support anyboards that are converted from beta to RC1. Only from phpbb2 to RC1.

I thout it will have the same structure.

But now its out of beta and its already out.

Anyone has any info in how to bridge it ?

Thanks.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKog on May 21, 2007, 02:30:49 am
Give the CPG guys a day or 2 and I bet you'll see something. Now that phpbb3 is at RC1 the integration for the bridge and db structure looks pretty stable. We tried out RC1 and are very happy with it -- very polished and the conversion process for some huge boards went well. We are not going to actually move to it until CPG publishes an official bridge patch for it even though we hacked up the existing bridge and got it to work...
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: polle on May 23, 2007, 02:41:03 pm
Give the CPG guys a day or 2 and I bet you'll see something. Now that phpbb3 is at RC1 the integration for the bridge and db structure looks pretty stable. We tried out RC1 and are very happy with it -- very polished and the conversion process for some huge boards went well. We are not going to actually move to it until CPG publishes an official bridge patch for it even though we hacked up the existing bridge and got it to work...

Hi, can you share how to do it, as I am about to start a new site, and obiously I dont want to start it with phpBB 2 now that 3 is out.

And waiting for an official bridging can take weeks, so it would be nice if you share how to do it and see if its a good solution in the meantime.

Thanks.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on May 23, 2007, 05:22:29 pm
1) There's no bridge file available for phpBB 3 yet, so there's no use requesting it.
2) Afaik phpbb3 is still in RC status. Although I'm not a phpbb expert, I am convinced that they will offer an upgrade option from phpbb2 to 3 once it get's released officially. Therefor, I'd go for phpBB2 now. Always use the most recent stable release for production sites.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKog on May 23, 2007, 07:03:34 pm
phpbb3 does offer an upgrade option for phpbb2 now and it works quite nicely -- documented as their "convert" function it actually copies and converts into a new db so as not to disturb your existing installation if you are unhappy with it. If you are an attachmod user it also automatically pics up your attachments since attachmod is built-in to phpbb3.

I will refrain from sharing my hack to get the bridge up tbecause the next thing you'll want is support ;) Even I am going to wait until the cpg folks release an official bridge to actually move over. I was just testing out RC1 for evaluation's sake.

If you need to deploy your new site go ahead and do it and add the bridge later...

In the meantime I urge the CPG folks to go ahead with an official bridge as phpbb3 RC1 is quite stable.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKog on May 23, 2007, 07:57:46 pm
Upon further review my hack has serious issues, lol... You wouldn't want it :)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: jerx on May 24, 2007, 06:39:18 pm
It would be really nice if you release a phpbb3 bridge before the real final release comes out. How about a compromise? Release an official bridge when RC2 or RC3 are out.

I am not a coder, but I think that although only in RC stage phpbb3 is more secure than phpbb2, just because of the fact that it is much newer and should have advanced coding techniques (phpbb2 was released more than 5 years ago). Moreover the development took quite some time. 2 or 3 months past before a new phpbb3 version had been released.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: WheelGuy on May 31, 2007, 06:03:32 am
I currently have CPG1.4.10 & using phpBB3 RC1. Unfortunately not bridged at the moment, but I "think" i am close. When I click the login link on the CPG, I am directed to my forums login box, after entering user/password, redirected back to CPG. Problem is, CPG is not recognizing me as being logged in even though the redirect link has a session id. Any clue as to what could be wrong or if i am fooling myself to think i am close to the bridge?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on May 31, 2007, 08:04:55 am
Bridging coppermine and phpBB3 currently goes unsupported (as in "don't ask questions how to accomplish this"), as we don't have a bridge file available yet. Replying to this thread with further requests for help or remarks like "I would like to have that bridge file as well" doesn't help - don't waste your time.
Only reply to this thread if you actually have a working bridge file to contribute.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: rainbowz on May 31, 2007, 01:49:28 pm
In that case, I'd like ti have that bridge file as well.

 ;)

How about a suggestion instead then: put a sticky in this forum something like...

<subject>NOTE: PHPBB 3 Bridge file: Not here yet</subject>

There is no known working bridge file for Coppermine>PHPBB 3 at this time.
Check this thread for further updates.
We'll announce the arrival of such a file in this very thread as soon as it becomes available.
Note that there is currently no estimated time of arrival for it.

Please be patient and refrain form asking when, we swear we'll let you know ASAP.

The Coppermine Team.


Then lock it. Update the sticky as needed and new info arrives.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on May 31, 2007, 06:02:52 pm
So you suggest a sticky thread for each bridge file that we don't have available but which get requested? ::) Prepare yourself for hundreds of sticky threads. :o

Your request is invalid. Before being allowed to post, users are suppossed to search. Searching for phpbb3 should lead them here anyway. That's all that is needed. Your previous suggestion is invalid. Please stop replying to this thread if you have nothing to say - I mean it! Don't force me to lock each and every thread. As I wrote above: bridge contributions would be welcome; instead of wasting everybody's time, why don't you just come up with a working bridge file instead of posting nonsense :-\.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKind on June 08, 2007, 04:21:16 pm
Okay, i made a bridging file for PhpBB 3.0 RC1.

I tested it, it works well but it's not finalised:

1) The field "user_active" does not exists animore, so i deleted the line
2) To use the file you'll have to edit it:
Line 114, change phpbb3_2i638 to the name fo you cookie (it's set on the ACP -> Cookies settings).

Use it carefully, only to test. This file may be buggy
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKind on June 08, 2007, 05:19:12 pm
Actually, only logged in/out status is working, i'll see what to do for admins groups.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on June 18, 2007, 11:34:34 pm
Any update TheKind? Anyone?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: merebel on June 26, 2007, 06:23:04 pm
Yes I am also wondering if there is any updates as well

Keith
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKind on June 26, 2007, 06:55:42 pm
I'm not working on bridging right now, but i'm not the only one who nows how to use PHP...
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 04, 2007, 10:54:53 am
any updates?
RC2 ist released, it's more than unlikely that there will be any major code changes.

but i'm not the only one who nows how to use PHP...
I'm quite firm in php, but I have no clue about briding coppermine, as I'm new to it.

Are there any developer docs?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 04, 2007, 05:39:32 pm
From what I have heard there is no set documentation, I could be wrong. I usually see people reply to use the bridge files in the CPG bridge folder and edit them accordingly.

Hope that helps. I would love to see a bridge file working soon :)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 04, 2007, 07:59:03 pm
Hi

From what I have heard there is no set documentation, I could be wrong. I usually see people reply to use the bridge files in the CPG bridge folder and edit them accordingly.
Hmm, ok, I must check that out.

Quote
Hope that helps. I would love to see a bridge file working soon :)
I'll try.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 05, 2007, 07:57:29 pm
Sorry, I don't know if it's against the common sense in this board, to post a direct reply to ones own post, but I'm not sure if an edit would be marked as new.

I got briding working so far, but everybody logged in seems to have admin rights.

Maybe some could give me a hint, else I'll continue tomorow.

Some parts are still hardcoded, but I think I'll manage that, too.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 06, 2007, 03:56:15 pm
Go, go tracer! :o ;D :D I wish I could be of some assistance, however I don't know the answer to your post. I hope someone can step up and give you some help/insight.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 06, 2007, 07:13:05 pm
Go, go tracer! :o ;D :D I wish I could be of some assistance, however I don't know the answer to your post. I hope someone can step up and give you some help/insight.

Thanks for the reply.

Can I attach the code, or should I link?

So far it works, with some glitches:

- some stuff still hardcoded
- only admins (Group ID = 5) can admin the board, registered users can upload, guests can only view.

I woulb be glad, if someone with more insight into Coppermine Code would clean my stuff up.

BTW, sorry for my english, I'm no native speaker.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on July 06, 2007, 08:50:11 pm
Attach the code (using additional options) or post the code inline (using the [ c o d e ]-button) - your choice.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: thecoalman on July 07, 2007, 05:08:51 am
RC2 ist released, it's more than unlikely that there will be any major code changes.

Is or isn't? Anyhow it's already been publicly stated by lead developer there will be a RC3.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 07, 2007, 07:57:12 am
Attach the code (using additional options) or post the code inline (using the [ c o d e ]-button) - your choice.

OK.

This must be changed in ucp.php in the forum directory.
Code: [Select]
case 'login':
                if ($user->data['is_registered'])
                {
                        // redirect(append_sid("{$phpbb_root_path}index.$phpEx"));
                        // tracer
                        redirect(append_sid(request_var('redirect', "{$phpb_root_path}index.$phpEx")));


I'll assign the bridge, take care, some stuff ist still hardcoded! (like cookies und some redirects)

Right now the bridge can only determine between registered, administrator and guests.



Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 07, 2007, 08:00:18 am
Is or isn't? Anyhow it's already been publicly stated by lead developer there will be a RC3.
When you take a look at the changelogs, there are only minor fixes.

Even when they change something, that would break the bridge, so what?
Then we will change the bridge accordingly.

Right now, that small peace of code helps me, when someone else can use ist too, I see no harm at all.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 07, 2007, 03:11:06 pm
I was testing this out on my site and ran into some errors. Maybe this will be a step to getting this working for EVERYONE. tracer, great job so far. I applaud your work. I do not mean to post this to take away from what you did, nor do I think you did a bad job. This is just what I came across and maybe this will help make this a more generic file for us all to use.


This is what I found, hope it helps.

Code: [Select]
class phpbb3_udb extends core_udb {

function phpbb3_udb()
{
global $BRIDGE;

if (!USE_BRIDGEMGR) {
$this->boardurl = 'http://www.volke-zu-wedel.de/forum';
require_once('../forum/config.php');

Where it says phpbb3_udb, I was having problems connecting. Then I changed it to my prefix_udb and that seemed to help.
I dont know how we could get this to not have to hardcode the boardurl and require once? If that is even possible. How did CPG make it so you could enter information in the Bridge Manager?

Next..

You left this alone ..

Code: [Select]
// Cookie settings - used in following functions only
$this->cookie_name = $BRIDGE['cookie_prefix'];

And changed it here...

Code: [Select]
$user_id = $_COOKIE['phpbb3_1tlo6_u'];
I am not sure how this works, but if you changed it up at the previous one, would that work for the entire code? Not just the one instance?

Can anyone help tell how to not have to hardcode the redirects?

Code: [Select]
$redirect = "http://www.volke-zu-wedel.de/gallery";

Lastly,

Code: [Select]
$cpg_udb = new phpbb3_udb;
I had to change that to my prefix on both cpg and the phpbb3, and then it caused an error in the init.inc.php in the includes folder on line 270, where then I changed that to my cpg prefix. So my question is, what is missing that would not make it point to the db prefixes without changing these?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 08, 2007, 03:25:28 pm
I was testing this out on my site and ran into some errors. Maybe this will be a step to getting this working for EVERYONE. tracer, great job so far. I applaud your work. I do not mean to post this to take away from what you did, nor do I think you did a bad job. This is just what I came across and maybe this will help make this a more generic file for us all to use.
Thank you. I understand, what you mean.
And for sure, feedback is always important for a developer ;)

Quote
This is what I found, hope it helps.

Code: [Select]
class phpbb3_udb extends core_udb {

function phpbb3_udb()
{
global $BRIDGE;

if (!USE_BRIDGEMGR) {
$this->boardurl = 'http://www.volke-zu-wedel.de/forum';
require_once('../forum/config.php');

Where it says phpbb3_udb, I was having problems connecting.
What kind of problems?

This is just a constructor in a class, nothing unusal.

Which php version do you use?

Quote
Then I changed it to my prefix_udb and that seemed to help.
That seems to be just a cure for the sympthom, but not the problem.

Quote
I dont know how we could get this to not have to hardcode the boardurl and require once? If that is even possible. How did CPG make it so you could enter information in the Bridge Manager?
That is possible, I'll change the code today or tomorow.

Quote
Next..

You left this alone ..

Code: [Select]
// Cookie settings - used in following functions only
$this->cookie_name = $BRIDGE['cookie_prefix'];

And changed it here...

Code: [Select]
$user_id = $_COOKIE['phpbb3_1tlo6_u'];
I am not sure how this works, but if you changed it up at the previous one, would that work for the entire code? Not just the one instance?
make it
Code: [Select]
$user_id = $this->cookie_name . "_u";
Quote
Can anyone help tell how to not have to hardcode the redirects?

Code: [Select]
$redirect = "http://www.volke-zu-wedel.de/gallery";
maybe by using $PHP_SELF, I'll try.

Quote

Lastly,

Code: [Select]
$cpg_udb = new phpbb3_udb;
I had to change that to my prefix on both cpg and the phpbb3, and then it caused an error in the init.inc.php in the includes folder on line 270, where then I changed that to my cpg prefix. So my question is, what is missing that would not make it point to the db prefixes without changing these?
I must at first know about the problem with the constructor.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: WheelGuy on July 09, 2007, 05:40:42 pm
tracer,  Does the attached file a few post up, contain the "fixes/updates" or you still working on that?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gele on July 09, 2007, 07:45:16 pm
The phpBB3 RC3 package was published yesterday
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: tracer on July 09, 2007, 08:48:36 pm
tracer,  Does the attached file a few post up, contain the "fixes/updates" or you still working on that?
No updates so far. :-(
Maybe tomorrow, when I'll can take some time.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: sneax on July 13, 2007, 03:47:41 pm
Hey good job people, I hope your bridge will mature soon! I can't wait for this to work because this userbase bridge is the ony thing stopping me from switching to phpBB3 - hopefully finally getting rid of the irritating bot-registrations!

Just a tip, make sure it copies usergroups over to coppermine too because I use them for album permissions ;)

Thread in favs :)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 13, 2007, 10:29:19 pm
Has anyone worked with tracers code to see if we can complete it. I try everything and no avail. Hope we can complete this soon :)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 17, 2007, 03:03:32 pm
bump.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on July 18, 2007, 09:40:02 am
As suggested earlier in this thread: I can understand that you want a bridge for phpbb3. However, there's no point in requesting it over and over. Call it as you want: asking for updates, news, progress status, whatever... It doesn't help the community to know that you want this too.

@all: do not ask on this thread, but give answers or contribute in one way or the other. Post answers, test results, code suggestions or whatever can be beneficial to come up with a fully working bridge. But do not post questions, bumps or similar things that are in fact questions in disguise, as they only clutter this thread.

Joachim
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 24, 2007, 02:10:34 pm
Hello,

at first excuse my (maybe) bad english, as someone said before: I'm not a native speaker.

I registered myself here only because of this thread - I had the same problem with integrating cpg into my phpbb3 installation.
I took the bridge file attached before and modified it for general use.
The problem with the redirection I've solved adding a function for resolving / normalizing paths.

In accordance to the attached file you have to do some things before using it (if not already done).

At first modify the ucp.php of your phpbb3 installation as described above (add the request var "redirect" to login / logout case).
Then update the values in the [cpg]_bridge table of your coppermine database:

That's all.

I tested it with different installation directories (same level, below and upper level to phpbb3) and using two different databases for the board and the gallery.

I hope that it will function with your installation, too.




Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 24, 2007, 05:54:26 pm
Redirect is working, everything seems to go well. However, when I do login on a user or admin account, it redirects to CPG and no one is logged in. :/
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 24, 2007, 06:02:05 pm
I couldn't edit my above post, maybe I missed the button. Anyways, I get "There was an error while processing a database query"

You say that you made it for general use, would that apply to all table prefixes for Coppermine and Phpbb3?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gassnerj on July 25, 2007, 03:38:29 am
I have completed all of the aforementioned steps. However I get the following error:
Quote
Fatal error: Cannot redeclare cpggetmicrotime() (previously declared in /home/content/g/a/s/gassnerj/html/photos/include/init.inc.php:35) in /home/content/g/a/s/gassnerj/html/photos/include/init.inc.php on line 33

I'm not sure what could be wrong. I have looked this up on google, but I do not get much out of that.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 25, 2007, 08:58:57 am
Hello,

thanks for your feedback.

Both problems I've already had, but due to the (small) work I've done on the bridge file I'm not sure how I solved them, but I think everything of this had to do with bridge configuration, because no hard coded prefixes are used (the Coppermine prefix is taken from the $CONFIG variable, and the phpBB prefix is taken from $table_prefix of the config.php from the board).
And I checked all other changes I had possible made due fixing the problems you have by using a diff tool - I didn't find anything else I've done.

Nevertheless I've attached a screenshot of my bridge configuration table, to show what should be configured.

Important are the items with the red borders around values.

Thats all. The value "use_standard_groups" seems to have no effect, but as I said, I'm not sure about this.

I hope this solves the problems.

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gele on July 25, 2007, 12:52:49 pm
Hello everybody

I have installed the last bridge.
All seem OK, except:
I can see an error message, when I push "user" button in the admin panel.

   :-[ Excuse my horrible english

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 25, 2007, 01:00:15 pm
Hello gele,

you're right, I'm working on this. I expect finishing it in the next hour, then I'll post it again.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 25, 2007, 02:22:01 pm
Sorry, I won't get this today, because I'm reworking the hole user and group management.

But I think I'll finish it tomorrow.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gassnerj on July 25, 2007, 06:50:56 pm
I finally got the bridge to work, save this error
Quote
Fatal error: Call to a member function on a non-object in /home/content/g/a/s/gassnerj/html/photos/include/init.inc.php on line 271

I commented it out and it works, except instead of having my username it says USER_NAME and it shows me as being an anonymous user. I'm just learning PHP, any help would be appreciated.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gassnerj on July 25, 2007, 07:44:37 pm
I no longer get this error. I had the last line of php code wrong. instead of $cpg_udb it was $cpg1411_udb. After fixing that, it does not recognize that I am logged in, and I don't get redirected to the login page of the bb. Still working on this to see what I am doing wrong.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gele on July 25, 2007, 09:20:13 pm
I can see other diference with the phpbb2 bridge

full_forum_url

phpbb2 ->  http://www.url.com/forum
phpbb3 ->  http://www.url.com/forum/

I hope this help you. I can't do any more, I don't know php
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gassnerj on July 25, 2007, 11:03:18 pm
I noticed that when I had bridging enabled and I went to view a gallery that I had created beforehand, that the user reg date was the same as on the forum. So some bridging was operational. I'm thinking it's something wrong with my cookie settings, but everything looks ok to me.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 27, 2007, 09:01:36 am
Hello,

I think I have it now. After two days looking into coppermine's code and understanding its user management, I changed the bridge to work with it (not using user levels or something, changed all to use phpbb3 groups).

Now you can use the post-based groups (set "post_based_groups" in the config table of the bridge to "1") and configure each of them.
This means you aren't bound to the standard groups of coppermine and can define restrictions for every group as defined in phpbb3 (RC3).
If you don't need this, leave the value for "post_based_groups" at "0".
Please note that switching between using post-based groups (or not) causes the loss of your group configuration data (max. upload space etc.), so you have to go to the group manager (link "groups") and update the group settings after switching. (This isn't a big piece of work)

If you want to enable a group defined in phpbb3 to have admin rights, add its group id to the initialisation of the admingroups array in constructor:

E.g. if you want to give global moderators (normally having ID 4) admin rights, change the line:
Code: [Select]
$this->admingroups = array($BRIDGE['admin_group']);

to
Code: [Select]
$this->admingroups = array($BRIDGE['admin_group'], 4);

I attached the reworked bridge file, please not that I tested it with the RC3 of phpbb3 only.

@gele: you're right - the board url must end with a slash, otherwise redirection won't function

@gassnerj: I wonder about changing the name of class instance, I ever thought this doesn't depend on Coppermines' table prefix.
I don't think your cookie settings aren't right, I think you haven't placed the correct cookie prefix into your bridge configuration table. This cookie prefix is different to every phpbb3 installation, so you can't use my posted one and have to take the value from phpbb3's config table 'cookie_name'.

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gassnerj on July 27, 2007, 04:18:21 pm
that worked great! so far I haven't had any issues. The bridge worked the first time.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: 08154711 on July 27, 2007, 05:30:47 pm
hmmm...

I'm getting the following: when trying to logon at
http://o8154711.de/cpg
my phpbb3 is at http://o8154711/phpbb3

"Not Found
The requested URL /phpbb3ucp.php was not found on this server."

################
phpbb3 domain:


Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: 08154711 on July 27, 2007, 05:35:24 pm
hmmm...

I'm getting the following: when trying to logon at
http://o8154711.de/cpg/index.html
(my phpbb3 is at http://o8154711/phpbb3)

"Not Found
The requested URL /phpbb3ucp.php was not found on this server."

################
phpbb3 domain: o8154711.de
phpbb3 cookie name;   phpbb3_7hi8t
phpbb3 cookie path: /
################

and if I just go to http://o8154711.de/cpg
I get the following FATAL ERROR

"While executing query "SELECT u.user_id AS id, u.username AS username, u.user_password AS password, u. AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_comment, ug.group_id AS group_id FROM `d0059ad3`.phpbb_users AS u, `d0059ad3`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2'" on Resource id #23

mySQL error: 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 'AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS a"
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on July 27, 2007, 07:06:38 pm
Everything works fine for me, except that I cannot access any of my admin pages for coppermine?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 27, 2007, 08:28:04 pm
@08154711: the board url is missing the trailing slash. I don't know where this bad sql request comes from, but surely not from the bridge - it doesn't query for something like 'avatar_url'. Are you sure of using the right bridge file and hav everythin configured correctly?

@gtk: have you read the prior posts in detail? Are you using RC3 of phpbb3? Are you using post based groups? However, try to access the groupmanager and have a look at the groups there. Calling the manager forces rebuilding the group table, that could possibly solve your problem.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 27, 2007, 10:14:33 pm
I ran into two things, and one may be the reason for the other.

This entire time, people have been saying that it works, however I have had two issues.

1. It seems set up properly, but it will not log the person into the gallery. They are redirected however they are not logged in. This was during andre_f's FIRST file.

2. The second file you did, the last post, redirects me to ../gallery thus not working properly for the following reason.

My gallery is at http//gallery.domain.com and my forums are at http://forums.domain.com. Could the fact be that I am using subdomains be the issue of the login issue?

Is there a way to code and understanding of subdomains so that I can retain structure of the site?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 28, 2007, 07:43:24 pm
Hello Grolley,

you detected the problem right.

The bridge is programmed for use in one domain, so you'll have only two ways solving it.

The first is not to use the subdomain. I think your both installations are reachable using relative paths, so you could configure that path in the bridge's configuration table.

The second would be overriding the redirection method of the bridge class like this (simply add this method to the phpbb3 bridge):
Code: [Select]
        function redirect($target)
        {
                header("Location: http://board.domain.com/$target");
                exit;
        }

Then find the following line in the bridges constructor:
Code: [Select]
    // get path for redirection
    $this->redirect_url = relative_paths(basename($_SERVER['PHP_SELF']), $BRIDGE['relative_path_to_config_file'].'config.php');
And change it to:
Code: [Select]
    $this->redirect_url = 'http://gallery.domain.com';

Unfortunately I can check this, but it should function for your case.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Grolley on July 28, 2007, 11:57:57 pm
That fixed the redirect issue.

However, I am still not having my users login. I hit the login button, it redirects me to phpbb3 to log in. I log in and then it redirects me to the gallery, but it still says login. It does not say Logout[Username]. Nor does the user have any rights.

What could the problem possibly be?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on July 29, 2007, 10:34:45 am
Please keep in mind that this is not actually a support thread where you just can ask questions. This thread is meant to develop a bridge file for cpg1.4.x and phpbb3. If you're not ready yet to provide the needed data or if you haven't understood the concept behind bridging, please stay out of this thread and wait untill the bridge file is mature/stable enough to be used by everyone. If you want to test it and report your results here, that's fine. But please make sure to have read the bridging section of the documentation (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#integrating) extra thoroughly. It is very important as well that you do exactly as suggested in the sticky thread on this board "When requesting bridge support - mandatory! (http://forum.coppermine-gallery.net/index.php?topic=24032.0)" (being covered in the documentation as well: "Integrating the script with your bulletin board (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#integrating)" -> "Bridging support (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#integrating_support_start)").
For the benefit of the entire community, stay out of this thread unless you have something to say, and you're capable to say it in a manner that will help others to spot your issues or issues that the existing beta bridge may still have.

This being said, I want to say a big "thank you" to Andre for his efforts to come up with a bridge file and the work he has done so far.

Joachim
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 29, 2007, 09:10:55 pm
I think you haven't set up the cookie name correctly (I think).

Please check the 'cookie_name' value of phpbb3's configuration table and enter that value as 'cookie_prefix' in coppermine's bridge configuration table.
I think it would be helpful if you post both values here.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on July 30, 2007, 01:20:16 am
@gtk: have you read the prior posts in detail? Are you using RC3 of phpbb3? Are you using post based groups? However, try to access the groupmanager and have a look at the groups there. Calling the manager forces rebuilding the group table, that could possibly solve your problem.
Yes, I read, and went back and re-read again.

I am using RC3, and post based groups (1).

My problem is I cannot access any admin pages, so I could not bring up the groupmgr page.  So I commented out the "if (!GALLERY_ADMIN_MODE) " in groupmgr.php, and then resync'd the groups as suggested.  This still did not work.

Again, I am logged in, but it is not recognizing me as "admin".

The only thing I see  that looks incorrect, is in my phpbb3_groups table, the "GROUP_TYPE" for "ADMINISTRATORS" is "3", which is the same for all the other standard delivered groups.   With that in mind, I did update  the code:
$this->admingroups = array($BRIDGE['admin_group'], 3);


Any ideas?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on July 30, 2007, 01:52:28 am
Coppermine is seeing my id as an Administrator.  WHen I pull up my  ID under "users" it shows:

Administrators
Global_moderators
Registered
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 30, 2007, 06:25:05 am
Hello GTK,

are you sure about the 3 as value for Admin Groups? Normally phpbb3 installs administrator group with a value of 5?!
Maybe that this is the problem?

What does coppermine say if you click the group manager button?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on July 30, 2007, 07:33:39 am
It is very important as well that you do exactly as suggested in the sticky thread on this board "When requesting bridge support - mandatory! (http://forum.coppermine-gallery.net/index.php?topic=24032.0)"
Can't spot the posting where you did as I suggested.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 30, 2007, 08:01:52 am
Thanks GauGau,

but I think that the informations requested there won't help solving the last posted problem.

@GTK:

I forgot something: if it is the case that your one and only admin group is configured having the id '3', please don't append it to the classes admingroups variable, but configure this group in coppermine's bridge configuration table as '3'. Otherwise it shows you as admin but assigns yourself to the group id from this table, so you won't have admin rights so far.

Due to this and some prior posts I suggest all other enquires to make sure having filled the bridge configuration table of your coppermine database as described before - this should save a lot of time and solve the most problems.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 30, 2007, 08:05:35 am
@GauGau: sorry, I've read the larger prior post only now.

If it isn't wanted here, is there another place to post the question from the others here? Some of them helped me fixing some issues in the bridge file.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on July 30, 2007, 08:11:09 am
but I think that the informations requested there won't help solving the last posted problem.
Maybe not in this particular case. But it will help sorting out people who legitimately try your new beta bridge and do everything right from people who just don't know how to apply the bridge in the first place. If users do as suggested there, you can take a look at things for yourself (does the bridging stick in the first place). The sticky thread I refered to exists because in our years of experience with supporting bridging issues it has turned out that having the requested information available helps troubleshooting 99% of all bridging issues. There's little point if you (as bridge contributor) tell people the opposite of what we tell users, as users will take your word. Make the suggested information mandatory to obtain valid reports. This will make test reports more valuable to help you come up with a stable bridge. You should really trust me on this issue - I have been around here very long already.

Joachim
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on July 30, 2007, 02:49:04 pm
Can't spot the posting where you did as I suggested.
@GauGau,  The install I am working on is a test database on my  home linux computer.  I am NOT posting a link & id/passwd to to my home setup.   Even if I did, the IP changes constantly.  If that is mandatory, I will just wait till someone else encounters, or I fix it myself.   Sorry.

I am running coppermine 1.4.10 & phpBB3.RC3

@andre_f
When I look at my phpbb3_groups  table via SQL, it is shows ADMINISTRATORS as group type '5'.   I think I know why though.   I did a "convert" on an existing board (2.x).  Also, I had three groups that I had created in the prior board, and it converted those as well.
group_type   group_name
0   PhotoAlbum
1   Moderators
2   Frequent Posters
3   GUESTS
3   REGISTERED
3   REGISTERED_COPPA
3   GLOBAL_MODERATORS
3   ADMINISTRATORS
3   BOTS

I will re-convert, but this time I will delete my groups prior to converting.

Thx!
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 30, 2007, 02:56:07 pm
Hello gtk,

the group_type is NOT the group_id, which is still wanted here.
I checked the group tables on different phpbb3 installations (some upgraded from further versions), and in every installation the group_id's for built-in groups (those having group_type set to 3) are the same.

Enter the group_id of your ADMINISTRATOR group (I'm sure it is 5) in the bridge configuration table as 'admin_group'.
If you want having your moderators or others, than you can APPEND their group_id's to the $this->admingroups array.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on July 30, 2007, 03:13:10 pm
Sorry for the confusion.  the group id from the phpbb_groups table is below:

group_id   group_type   group_name
93             0                  PhotoAlbum
268            1                  Moderators
538            2                  Frequent Posters
539            3                  GUESTS
540            3                  REGISTERED
541            3                  REGISTERED_COPPA
542            3                  GLOBAL_MODERATORS
543            3                  ADMINISTRATORS
544            3                  BOTS

Is this the group_id  your inquiring?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on July 30, 2007, 04:40:38 pm
I edited the phpbb3.inc.php file, and changed the line:

 $this->admingroups = array($BRIDGE['admin_group'], 5);

to match my group_id for admins.   This has seemed to fix the problem.   Why my phpbb3_groups table differs from everyone elses, I have no idea   :-\   , but that is not a question for this board.

Thanks so much for your assistance.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: WheelGuy on July 30, 2007, 05:05:32 pm
to match my group_id for admins.   This has seemed to fix the problem.   Why my phpbb3_groups table differs from everyone elses, I have no idea   :-\   , but that is not a question for this board.

Thanks so much for your assistance.
My "live" forum is like yours, with different id numbers. The one one my local machine is as andre_f mentions though. Just so you don't "feel" as if you are strange.. lol
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: ontherack on July 30, 2007, 05:47:45 pm
Thanks for the bridge file, unfortunately i too am having trouble getting it to work, i am using a fresh install of phpbb3 rc3, with a bit of fiddling i seem to have come close a few times but now things seem to have gone backwards, i get the following error once bridging is enabled,

While executing query "SELECT COUNT(*) FROM `ontherac_global`.phpbb_users" on 0

from gallery/include/functions.inc.php

no error details are returned, and i get the feeling that this means access to the database is completely failing, i have tried fresh installs of the bridge and it makes no difference, i have also tried specifying the db credentials in cpg_bridge which made no difference either.
any thoughts? im sure its something small that i cant see.

A few things i figured out too, i was getting an error where a query was looking for records with single_user=0 where this column didnt exist in my db, overriding standard groups in cpg_bridge solved this.
An error i was stuck on just before this was another query which was something along the lines of "where userid= and groupid=5" ie there was no value to the right of the =
all these errors were occuring immediately upon trying to load gallery after enabling bridging. Unfortunately i dont have the exact errors, anyone else getting these?

@GauGau sorry to clog this thread  :(, but my setup is using a clean install of cpg and phpbb3 so im sure others are getting these problems and hope by reporting them that we can come up with a finished bridge. Maybe the thread should be split or moved until a 100% working bridge is available
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on July 30, 2007, 07:45:16 pm
@GauGau,  The install I am working on is a test database on my  home linux computer.  I am NOT posting a link & id/passwd to to my home setup.   Even if I did, the IP changes constantly.  If that is mandatory, I will just wait till someone else encounters, or I fix it myself.
None of your replies is valid. DynDNS is an option for changing IP addresses. Free webhosting is an option for obtaining publicly available testing web space without cost. I'd love to see you test and evaluate the beta bridge, but imo you don't have the minimum requirements that I outlined previously.

I am running coppermine 1.4.10
Then you don't qualify as a valid tester. It's mandatory to run the most recent version (cpg1.4.12 currently) - why should we bother with issues that may be caused by outdated versions? Eliminate uncertainties when evaluating beta software.

@GauGau sorry to clog this thread  :(, but my setup is using a clean install of cpg and phpbb3 so im sure others are getting these problems and hope by reporting them that we can come up with a finished bridge.
That's wrong: I posted above what a valid report must contain. You have completely failed to read it, so you're not a valid tester. There is no such thing as a default/clean install. Setups differ, that's why it's mandatory to do as suggested and post information about your setup.

Maybe the thread should be split or moved until a 100% working bridge is available
No need to split it. Just read it before replying to it. It clearly says who the target audience of this beta bridge is, what the requirements are for posting and that this thread doesn't fall into the support category. If you can't play by the rules, then stay out of this thread.

From now on I'll delete all irrelevant/invalid replies in this thread without further notice to keep the thread usable. If you have something to say, say it properly. If not, then STFU and wait for a stable release.

Joachim
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on July 31, 2007, 07:59:23 am
Thanks to GauGau for this post, I hope this prevents from further posting about errors caused by ignoring the concept (or not reading the posts in detail).

@gtk: Ok, although I don't know how this can be because I even updated from a further phpbb version, but if your groups have another id's this no problem. But it isn't a good idea changing the code without having the bridge configuration concept used. May be I didn't understand what you've done, but the code line '$this->admingroups($BRIDGE['admin_group'])' should have the first value of this array unchanged, because the admin's group_id has to be entered in the bridge configuration table. (in your case this tables entree named 'admin_group' has to have a value of '543'). If you done it this, way, forget this paragraph.

@ontherack: None of this queries came from the bridge. Although I was sure about this, I checked both the udb base class and the phpbb3 bridge file for queries using 'single_user' or a combination of 'user_id' and 'group_id' in the way you specified - and found nothing. Please check you are using the right bridge file and having the bridge configuration table filled as posted some posts before.

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Bembi on August 14, 2007, 09:47:27 pm
Some testing reports.

1. System: Clean installation CPG 1.4.12 + pgpBB 3 RC4 (MySQL 4.1.22 with MySQL Client API 5.0.22, PHP 5.2.0) 

All done steps:
- Copied the latest bridge file phpbb3.inc.php into the \bridge directory
- Added a section to bridgemgr.php to recognize the new bridgefile
  (I copied the phpbb22 section (line 419 to 430) and changed 'full_name' to "phpBB 3.0' and 'short_name to "phpBB3"
- I started the bridge manager and setup the bridge (with post based groups enabled)
- I startet phpMyAdmin and changed the following fields within the 'cpg_bridge' Table
  'full_formum_url' : added the trailing slash to the path name
  'cookie_prefix'   : set to the value of the field 'cookie_name' from the 'phpBB3_config' table 
  'guest_group'    : set to the value of the corresponding 'group_id' field of the 'phpBB3_groups' table
  'member_group' : set to the value of the corresponding 'group_id' field of the 'phpBB3_groups' table
  'admin_group'    : set to the value of the corresponding 'group_id' field of the 'phpBB3_groups' table

Coppermine runs fine, shows all my phpBB groups and users and I can assign right to them.

2. System: Copy of life system with CPG 1.4.9 + modded phpBB 2.022 (MySQL 4.0.24 with MySQL Client API 3.23.58, PHP 4.4.7)

All done steps:
- Updated the cpg version from 1.4.9 to 1.4.12
- Installed a new installation of phpBB3 RC4 beside the existing
- Started the migration assistant from phpBB3, which copies the content into new tables
- followed the steps, as describes above.

Also this installation runs fine, shows all my phpBB groups and users and I can assign rights to them.

Some minor lacks, which I can see are the following:
- The default installation shows no BOTS (group_id = 6), the migrated installation does (group_id = 22)
- The Group description within CPG is not exacly the same than in pbpBB (case is different)
  A group called 'HTC-BClub' is shown as 'Htc-bclub' in Coppermine.

The migration assistant of phpBB adds the default system groups at the end of the table.
My migrated groups are:
GUEST = 17
ADMINISTRATORS = 21

My migrated users have the following IDs:
Anonymous (ID = 1, Group_ID = 17, Usertype = 2)
Admin (ID = 2, Group_ID = 21, Usertype = 3)

Users have user_type 0 and 1
Anonymous and BOTS have user_type 2
Admins have user_type 3

As the current bridge is working with default IDs and coppermine also seems to work with some IDs from the database, it seem not to be reliable to use the IDs as single identifier.

Assuming, that the anonymous and first admin account are allways the first accounts in phpBB, the following rule may be a way, to find out the correct group_IDs:

- Anonymous account has user_ID = 1, the group_ID value points to the GUEST group
- the first Admin account has user_ID = 2 and the user_type = 3, the group_id points to the ADMINISTRATORS group
- BOTS have the user_type=2 and NOT the user_ID=1 (which is the guest account).

Hope this helps.   
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: andre_f on August 15, 2007, 07:31:42 am
Hello Bembi,

thank you very much for this helpful testing.

Although you've done a good work, using the 'user_type' won't help, because this type has the following definition:

0 - normal user
1 - inactive user
2 - ignored user
3 - founder

An admin can have a 'user_type' of 3 as well as 0 (this is the case if you have more than one admin and only one of them has a founder status). This means, too, that a user can have a founder status...

I suggest two ways for migrated systems.
The first would be to add two configurations to the bridge configuration table named:
'guest_group_id' = [id of guest group]
'bot_group_id' = [id of bot group]

and to change the following lines in bridge class constructor:

Code: [Select]
    $this->guestgroup = 1;
    $this->botgroup = 6;

into

Code: [Select]
    $this->guestgroup = $BRIDGE['guest_group_id'];
    $this->botgroup = $BRIDGE['bot_group_id'];

The second would be to hardcode this, which isn't a good idea.

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on August 21, 2007, 06:03:03 pm
When I was in coppermine, and clicked a username to view the profile, it was always defaulting to the same userid (in my case, 2).

I changed the phpbb3.inc.php bridge file from this
Code: [Select]
//  function view_profile()
  {
    global $USER_DATA;
    $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$uid}");
  }
to this:
Code: [Select]
  function view_profile($uid)
  {
    global $USER_DATA;
    $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$uid}");
  }

This seems to work for me now.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on August 21, 2007, 06:05:02 pm
Please delete the prior post.. I posted the same code twice..

It should be as follows:

When I was in coppermine, and clicked a username to view the profile, it was always defaulting to the same userid (in my case, 2).

I changed the phpbb3.inc.php bridge file from this
Code: [Select]
//  function view_profile()
  {
    global $USER_DATA;
    $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");
  }

to this:

Code: [Select]
  function view_profile($uid)
  {
    global $USER_DATA;
    $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$uid}");
  }
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Bembi on August 31, 2007, 08:19:58 pm
New tests on all systems:

andre_f:
- I startet phpMyAdmin and changed the following fields within the 'cpg_bridge' Table
'bot_group' : field added to table
'bot_group' : set to the value of the corresponding 'group_id' field of the 'phpBB3_groups' table

a guest_group field is already existing, so used this:

- I changed the phpbb3.inc.php (corresponding to andre_f's post:
    $this->admingroups = array($BRIDGE['admin_group']);
    $this->guestgroup = 1
    $this->botgroup =  6;
into
    $this->admingroups = array($BRIDGE['admin_group']);
    $this->guestgroup = $BRIDGE['guest_group'];
    $this->botgroup =  $BRIDGE['bot_group'];

RESULT: Now the BOT group members are not shown anymore within copperfine --> fine

gtk:
I checked out your hint, your solution now redirects to the correct profiles, but the "My Profile" menu item was not working anymore. So I mixed it together and changed:

   function view_profile()
  {
    global $USER_DATA;
    $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");
  }

into:
   function view_profile($uid)
  {
    global $USER_DATA;
    if ($uid)
        $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$uid}");
    else
        $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");

  }
This shows both items correctly
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: gtk on September 18, 2007, 09:55:14 pm
I also have the "who's online" mod installed.

Unregistered users can upload to public albums, with admin approval.

Sometimes I am seeing the user "Anonymous" in the who's online, and when that user adds a picture, it gets added to the lowest userid's folder (10001).

Have you seen anything like this?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: TheKog on October 17, 2007, 03:57:15 am
Thanks andre and tracer for the proto-bridge. I had moderate success with this bridge testing with CPG 1.4.12 and RC7 of phpBB3. I followed the instructions:

- phpBB3 is unmodded with default install -- I did convert an existing phpBB2 install but it had stock user groups
- made the mod to ucp.php for login
- made my bridge entry in the DB look like Andre's image several pages back
- saw the later post to add the trailing slash to the forum absolute url (without this login/logout wasn't happy)

FWIW While I didn't do extensive testing. The only weirdness I saw was that the logoout redirection didn't being me back to cpg/index.php, it took me to the phpbb3/index/php (the refer var in the logout link only said index.php). Login redirection worked fine.

Thanks, Mike
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on October 17, 2007, 07:19:22 am
Use cpg1.4.13!
Read this thread to find out what you need to post in order to qualify for a valid test report. Yours doesn't qualify as such a valid test report.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on October 18, 2007, 08:02:14 am
The above user "TheKog" sent me this unsolicited PM:
How does this qualify as a valid test report?

Your  welcome -- it's worth the price paid -- so much great support out of the official CPG group for the top BB around. No one else has even tried it.

If you don't like it, delete it or just Gau Gau to H***! Your attitude sucks!
You should have read the thread you reply to: there currently is no official bridge file for phpBB3. This thread deals with a user-contributed bridge in beta stage. The thread clearly explains that the preliminary phpBB3-bridge file goes unsupported and that you're not allowed to ask for support. The only thing you're allowed to do is post a valid test report. This policy is meant to make sure that bugs that currently exist in this beta bridge can be ironed out. If you fail to post a valid report, your posting simply isn't helpfull.
Besides, there is a sticky thread within this board named "When requesting bridge support - mandatory! (http://forum.coppermine-gallery.net/index.php?topic=24032.0)" and a section in the documentation named "Bridging support (http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#integrating_support_start)" - you even failed to do as suggested there, so your posting doesn't even qualify as a valid support request.
When being told that your posting is not enough, a clever person would have read up what you need to do to make a valid posting. What you did (still ignoring the simple instructions to read this thread) just shows what kind of person you are. You should review your attitude. The app phpBB may be popular, that's undoubted. However, that doesn't mean that we can support what we don't know nor what we're not familiar with. Just wanting the bridge to work badly is not enough - do your homework and then you may get help from someone who is capable to give help.
Being rude and swearing in your PM just means one thing to me: I bid you a "farewell" and ban your account.

Joachim
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: sasa.stanic on October 19, 2007, 01:16:50 am
Hello,

we were succesfuly added it all. When we click on coppermine login, we make redirect to phpbb3 forum. But, when we make login and redirect to copermine, login fails. There is login on menu again. I don´t know what to do.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: sasa.stanic on October 19, 2007, 01:27:55 am
My test script: www.maglaj.net/fotografije

plese go to login >>

test user: sasa.stanic
      pass: kostamag

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on October 19, 2007, 07:44:49 am
Read this thread to find out what you need to post in order to qualify for a valid test report. Yours doesn't qualify as such a valid test report.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: sasa.stanic on October 19, 2007, 10:58:30 am
Quote
Coppermine install: http://maglaj.net/fotografije
Forum install: http://maglaj.net/forum
Coppermine version: cpg1.4.13
Forum version: phpBB3
Test user account: sasa.stanic/kostamag

BridgeManager settings:
Forum URL:  http://maglaj.net/fotografije/
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  0
Cookie name/preifx (if applicable)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: sasa.stanic on October 19, 2007, 11:04:20 am
We have problem, when we login sucesfuly and back to galery, on the menu is login again, and we can not see our control menu. Please help.


Quote
Coppermine install: http://maglaj.net/fotografije
Forum install: http://maglaj.net/forum
Coppermine version: cpg1.4.13
Forum version: phpBB3
Test user account: sasa.stanic/kostamag

BridgeManager settings:
Forum URL:  http://maglaj.net/forum
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:0   
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: sasa.stanic on October 22, 2007, 04:00:17 pm
Please help me...
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on October 23, 2007, 12:34:58 pm
You should have read the thread you reply to: there currently is no official bridge file for phpBB3. This thread deals with a user-contributed bridge in beta stage. The thread clearly explains that the preliminary phpBB3-bridge file goes unsupported and that you're not allowed to ask for support. The only thing you're allowed to do is post a valid test report.
There's no guarantee that someone will answer your question. As suggested various times already in this thread: this is not a support thread, so don't ask for support here. Use the stable product phpBB2 if you need to bridge it with coppermine.

All postings in this thread that just ask for support will be deleted without further notice.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: danniee on December 01, 2007, 11:52:57 pm
I have read a lot of the posts on this forum and I have to agree with many people. The admin guy or whoever he is, is acting like a jerk. You are being really rude and you dont seem to have no patience at all. Zero. You are treating this thing as if it is cancer. It sucks. You can ban me, like you did with everyone else that didnt follow your lame rules. I dont care.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Drewskie on December 11, 2007, 08:01:39 pm
I know this is rude to ask but does anyone have the steps in a text file I can use.

Time is a bit short at the moment and do not have the time to run through all the posts.

Any assistance will be greatly appreciated.

If I do not get a response, I will understand as everyone that has got this to work did do it the hard way.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: kryb81 on December 14, 2007, 08:50:37 am
phpBB 3.0.0 was released yesterday! Now the countdown for developing the bridge is running... ;) Thanx to all people who are doing this great work!
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: danniee on December 14, 2007, 10:31:15 pm
Seems to be a better chance of this happening at phpbb.com. This place has been quite for pretty long. At phpbb at least its under discussion and there is a guy trying his best.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on December 15, 2007, 12:12:04 pm
This thread is cluttered with requests for a stable bridge, which is just nonsense. Only asking for a bridge won't help. If you want to help, read the entire thread, get the beta bridge, evaluate it and post your test results in the manner discussed in this thread. We will look into valid reports, trying to improve the bridge and make it stable. Just whining that there is no progress in this thread is lame.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: danniee on December 15, 2007, 04:57:44 pm
You are lame for having such a stupid attitude. Look at the phpbb3, obviously you are notorious for being a dickhead. What is your problem, seriously? Never have I seen a moderator so rude as you. Its like you are asking us all to f*ck off.

Do you really think I have not read the entire thread? Dont you think I have tried all kinds of versions 2-3 times already. It doesn't work. Seriously, you are a dumbass and you might as well ban me cause I dont give a rats ass about you and your crappy program anymore. I'll try another photo gallery.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: roncop on December 17, 2007, 01:07:47 am
I was careless enough to upgrade to phpbb 3 first and then notice that I could not access the gallery anymore (nor disable the bridging because I had forgotten the stand-alone admin password).
So I worked my way through this thread to piece together the changes, first setting the values in the database as explained in this post (http://forum.coppermine-gallery.net/index.php?topic=43383.msg216847#msg216847). I believe that the "path from webroot" entry prefers a leading "/" but may be wrong, in any case it does not seem to hurt. As pointed out elsewhere in this thread, I also made the following file changes:

Code: [Select]
$ diff ucp_original.php ucp.php
78c78,80
<                       redirect(append_sid("{$phpbb_root_path}index.$phpEx"));
---
>               //      redirect(append_sid("{$phpbb_root_path}index.$phpEx"));
>               //      changed for phpbb3
>                       redirect(append_sid(request_var('redirect', "{$phpbb_root_path}index.$phpEx")));
339d340
<
$ diff bridgemgr_original.php bridgemgr.php
434a435,447
> $default_bridge_data['phpbb3'] = array(
>   'full_name' => 'phpBB 3.0',
>   'short_name' => 'phpbb3',
>   'support_url' => 'http://www.phpbb.com/',
>   'full_forum_url_default' => 'http://www.yoursite.com/forum/',
>   'full_forum_url_used' => 'mandatory,not_empty,trailing_slash',
>   'relative_path_to_config_file_default' => '../forum/',
>   'relative_path_to_config_file_used' => 'lookfor,config.php',
>   'use_post_based_groups_default' => '0',
>   'use_post_based_groups_used' => 'radio,1,0',
> );
>
> // status: bridge unknown, manager unknown
$ diff phpbb3_original.inc.php phpbb3_intermediate.inc.php
156,157c156,157
<     $this->guestgroup = 1;
<     $this->botgroup = 6;
---
>     $this->guestgroup = $BRIDGE['guest_group'];
>     $this->botgroup = $BRIDGE['bot_group'];
364c364
<   function view_profile()
---
>   function view_profile($uid)
367c367,370
<     $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");
---
>     if($uid)
>         $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$uid}");
>       else
>               $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");
$

However I still got "Fatal error :" with no further detail when trying to access the gallery.
The following additional modifications to the phpbb3.inc.php file, which I nicked from phpbb2018.inc.php, got things working for me:

Code: [Select]
$ diff phpbb3_intermediate.inc.php phpbb3_final.inc.php
144c144,148
<       'grouptbl_group_name' => 'group_name' // name of 'group name' field in groups table
---
>       'grouptbl_group_name' => 'group_name', // name of 'group name' field in groups table
>       'notify' => 'user_notify_pm',
>       'auto_subscribe_post' => 'user_notify',
>       'auto_subscribe_comment' => 'user_notify',
>       'avatar_url' => 'user_avatar'
$

It seems these values are referenced in a number of SELECT statements and empty values result in those errors I've seen.

I hope this helps someone.
Many thanks to all who contributed to the solution - with 10 "php-thumbs" I would not have gotten anywhere without the information shared in this thread (including the questions asked and answered).

Thanks again.
Cheers,

roncop
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on December 17, 2007, 08:25:47 am
Thanks for your report. Can anyone confirm?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: rphMedia on December 17, 2007, 08:47:14 am
I'm in the same situation. I'll be upgrading to the final release of phpBB3 within a couple of weeks (I currently have it bridged with RC5, which currently works fine).

I'll report back with my findings.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: socomnutzclan on December 22, 2007, 01:25:15 am
Alright, I started with a fresh load of both phpBB3, and Coppermine 1.14.13.

I am using the attached bridge file, which is from this string with the modiications suggested in this string as well.

Basically the bridge works with the following weird errors;

1. When I click member list on Coppermine I get this "critical error";
"There was an error while processing a database query"

http://basyes.com/cpg1414/usermgr.php

2. It only recognized myself as Admin, I added another user to my admin group but in coppermine that user is still only recognized as a normal registered user.

3.  It seems when I switch from admin mode to normal user mode using my made admin account, I cannot do anything as a new. Normal new registered users, as recognized as registered users by coppermine and get the default group settings.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: socomnutzclan on December 22, 2007, 07:40:21 pm
Alright I am still trying to track down the admin error I am getting.  Basically for whatever reason I cannot change the admin group Id to anything else, or I lose my admin rights.  This is from the default admin group ID of 5. I also however cannot add any other admins, as I have added others users into the admin group, but they do not have admin rights on the Coppermine board, so now I am stuck as the only admin.  What could be causing this?
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: nene on December 23, 2007, 12:28:42 pm
hi people.

I have a request. I am one of those who hasn't have the time to backup when applying some critical updates. And so is this time, when I tried to bridge my phpBB3 and coppermine with the bridge posted two posts above. I guess the problem was because the gallery and phpbb3 are on different databases. I get a fatal error when tring to access the gallery and similar when trying to access the bridgemgr.php to disable the bridge.

This is what i tried so far: I copied the forum tables to gallery database and vice versa, changing the names in phpbb3 and coppermine configs. No luck. I entered phpmyadmin, and found table cpg_bridge almost empty, so i filled in the missing information. Now i get this error:

Quote
While executing query "SELECT extension, mime, content, player FROM phpbb_filetypes;" on 0

mySQL error: Table 'cerkno.phpbb_filetypes' doesn't exist

my guess is the table wasnt created before the bridge error. Could anyone send me this table or help me with my problem?

Thanks a lot
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on December 24, 2007, 09:05:47 am
This is not a support thread, and yours is not a valid test report. Read the thread you're replying to.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: socomnutzclan on December 24, 2007, 09:35:22 pm
I just figured my problem out, and will let others know here in case they run into the same problem.  For whatever reason I had to go into phpBB, and select members from the group I identified as the photo admin group, and set that members to default group within the phpBB group.  Than Coppermine install recognizes them as admins..
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: ccirim on December 29, 2007, 10:14:48 am
Someone have a working config_file_bridge for php3??
can you post it?
thanks! ;D
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on December 29, 2007, 11:01:47 am
This is not a support thread, and yours is not a valid test report. Read the thread you're replying to.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: pmn1 on December 31, 2007, 06:04:40 am
I was careless enough to upgrade to phpbb 3 first and then notice that I could not access the gallery anymore (nor disable the bridging because I had forgotten the stand-alone admin password).
So I worked my way through this thread to piece together the changes, first setting the values in the database as explained in this post (http://forum.coppermine-gallery.net/index.php?topic=43383.msg216847#msg216847). I believe that the "path from webroot" entry prefers a leading "/" but may be wrong, in any case it does not seem to hurt. As pointed out elsewhere in this thread, I also made the following file changes:

Code: [Select]
$ diff ucp_original.php ucp.php
78c78,80
<                       redirect(append_sid("{$phpbb_root_path}index.$phpEx"));
---
>               //      redirect(append_sid("{$phpbb_root_path}index.$phpEx"));
>               //      changed for phpbb3
>                       redirect(append_sid(request_var('redirect', "{$phpbb_root_path}index.$phpEx")));
339d340
<
$ diff bridgemgr_original.php bridgemgr.php
434a435,447
> $default_bridge_data['phpbb3'] = array(
>   'full_name' => 'phpBB 3.0',
>   'short_name' => 'phpbb3',
>   'support_url' => 'http://www.phpbb.com/',
>   'full_forum_url_default' => 'http://www.yoursite.com/forum/',
>   'full_forum_url_used' => 'mandatory,not_empty,trailing_slash',
>   'relative_path_to_config_file_default' => '../forum/',
>   'relative_path_to_config_file_used' => 'lookfor,config.php',
>   'use_post_based_groups_default' => '0',
>   'use_post_based_groups_used' => 'radio,1,0',
> );
>
> // status: bridge unknown, manager unknown
$ diff phpbb3_original.inc.php phpbb3_intermediate.inc.php
156,157c156,157
<     $this->guestgroup = 1;
<     $this->botgroup = 6;
---
>     $this->guestgroup = $BRIDGE['guest_group'];
>     $this->botgroup = $BRIDGE['bot_group'];
364c364
<   function view_profile()
---
>   function view_profile($uid)
367c367,370
<     $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");
---
>     if($uid)
>         $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$uid}");
>       else
>               $this->redirect("memberlist.php?mode=viewprofile&sid={$this->sid}&u={$USER_DATA[user_id]}");
$

However I still got "Fatal error :" with no further detail when trying to access the gallery.
The following additional modifications to the phpbb3.inc.php file, which I nicked from phpbb2018.inc.php, got things working for me:

Code: [Select]
$ diff phpbb3_intermediate.inc.php phpbb3_final.inc.php
144c144,148
<       'grouptbl_group_name' => 'group_name' // name of 'group name' field in groups table
---
>       'grouptbl_group_name' => 'group_name', // name of 'group name' field in groups table
>       'notify' => 'user_notify_pm',
>       'auto_subscribe_post' => 'user_notify',
>       'auto_subscribe_comment' => 'user_notify',
>       'avatar_url' => 'user_avatar'
$

It seems these values are referenced in a number of SELECT statements and empty values result in those errors I've seen.

I hope this helps someone.
Many thanks to all who contributed to the solution - with 10 "php-thumbs" I would not have gotten anywhere without the information shared in this thread (including the questions asked and answered).

Thanks again.
Cheers,

roncop

I used the above settings/code changes outlined running phpBB3 (gold) and Coppermine 1.4.14
Appears to be working well...Thank you!!!!
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: pmn1 on December 31, 2007, 09:34:19 am
I am getting the data base error mentioned before when selecting users....with the above changes
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on December 31, 2007, 10:03:58 am
The next invalid reply to this thread will result in this thread getting locked >:(!  - I'm sick having to repeat this over and over! Read the entire thread before replying to it. Review the instructions posted that explain what a valid report posting must contain. Do as suggested there and post a valid report, or no report at all. I mean it. Don't be so selfish and expect support on this thread - it is not a support thread, but a thread dedicated to test the user contributed bridge and improve it. If you feel that you can't cope and don't understand the instructions posted, then just shut up and don't reply to this thread at all; just wait patiently untill others have done what you're suppossed to do and have supplied enough valid test reports and code improvement suggestions to make the preliminary, user-contributed bridge for phpbb3 a stable product.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: rphMedia on January 07, 2008, 10:38:32 pm
I'm in the same situation. I'll be upgrading to the final release of phpBB3 within a couple of weeks (I currently have it bridged with RC5, which currently works fine).

I'll report back with my findings.

I've upgraded to the final (non-rc) phpbb3 and it went flawlessly. I've attached a copy of the bridge file and a snapshot of my table structure (for reference only). Understand that I have, 3 admins, no special groups in the Gallery and a manually created Moderator group for the forum. There have been no negative issues at all. I cannot remember how I tweaked these parameters (I had probs in the beginning matching the group IDs - I believe), but hopefully, you'll be able to emulate what I have and get it working.

I hope it helps a bit.

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 08, 2008, 08:45:03 pm
Hi,

I am just going on to upgrade my forum to phpBB3. I'm also using coppermine and I have had the following requirements with respect to the bridging:

    * assignment of coppermine administration rights via phpBB3 permission system
    * support of permission granularity of phpBB3
    * assignment of coppermine administration rights not only to phpBB3 admins but also to phpBB3 moderators
    * select option for bot handling (e.g. googlebot): let bots spider coppermine gallery or not

As there is currently no bridge available which offers that functionality I have written a new one.

Please find it attached to this posting - it also includes an instruction how to install.

I have already published that bridge at phpbb.com some days ago, you can find the corresponding topic at:
http://www.phpbb.com/community/viewtopic.php?f=70&t=666235

Regards
fornit
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 10, 2008, 07:31:05 am
Code: [Select]
    function session_update()
    {
// update once a minute
if ( time() - $this->session_data['session_time'] > 60 )
{
$sql =
"UPDATE
" . $this->pref . "sessions
SET
session_time = " . time() . "
WHERE
session_id = " . quote_smart($this->session_id, $this->link_id);

cpg_db_query($sql, $this->link_id);
}
}

Hi, I think there is a problem with " and ' in the 0.9.2 version ( and 0.9.2.1 )

I update the code ... in the version 0.9.2.1: http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.2.1.7z (http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.2.1.7z)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 10, 2008, 09:44:34 am
Code: [Select]
    function session_update()
    {
// update once a minute
if ( time() - $this->session_data['session_time'] > 60 )
{
$sql =
"UPDATE
" . $this->pref . "sessions
SET
session_time = " . time() . "
WHERE
session_id = " . quote_smart($this->session_id, $this->link_id);

cpg_db_query($sql, $this->link_id);
}
}

Hi, I think there is a problem with " and ' in the 0.9.2 version ( and 0.9.2.1 )

I update the code ... in the version 0.9.2.1: http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.2.1.7z (http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.2.1.7z)

archive update
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 10, 2008, 04:06:28 pm
Hi,

thank you for your reply.

The function "quote_smart" sets the ' at the beginning and at the end of the expression. So, from my point if view, this should be correct in v0.9.2

Have you seen any problems with respect to the session update?

Regards
fornit
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 10, 2008, 10:02:58 pm
Thank you for that hint.

There was indeed a bug, but it had nothing to do with " or '. The variable in that function was named "$this->session_id", but it must be "$this->sid" ;)

I have fixed that. Please find the new version v0.9.3 attached to this posting.

Regards
fornit
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 11, 2008, 03:45:28 am
Thank you for that hint.

There was indeed a bug, but it had nothing to do with " or '. The variable in that function was named "$this->session_id", but it must be "$this->sid" ;)

I have fixed that. Please find the new version v0.9.3 attached to this posting.

Regards
fornit

You don't have my mod (0.9.2.1) in the 0.9.3 ??
archive update 11.10.2007
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 11, 2008, 05:05:09 am
Thank you for that hint.

There was indeed a bug, but it had nothing to do with " or '. The variable in that function was named "$this->session_id", but it must be "$this->sid" ;)

I have fixed that. Please find the new version v0.9.3 attached to this posting.

Regards
fornit

archive update 0.9.3.1 http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.3.1.7z (http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.3.1.7z)
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on January 11, 2008, 07:44:46 am
Not everyone has got 7-Zip (http://7-zip.org/) or knows about it. I suggest using "zip" as archive format instead of "7z".
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 11, 2008, 10:52:05 am
*.7z //
7zip is a open source program and this format can be open with a lot of program http://www.fileinfo.net/extension/7z
and it's the best program of 2007 : http://sourceforge.net/community/index.php/landing-pages/cca07/
website project : http://sourceforge.net/projects/sevenzip
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 11, 2008, 05:45:59 pm
Quote
You don't have my mod (0.9.2.1) in the 0.9.3 ??

No, I didn't - sorry for that.

The problem was that 7-zip format ;) I'm usually working on my company laptop where 7-zip is not installed. It's a a policy of my company that employees have no admin rights to install windows software (as 7-zip is) on the laptops.

From your comments I assumed that you have made changes to the function session_update, which seemed not to be a good idea to me :)

But I have now looked at your extensions - they are fine, thank you for that.

During the next week (or so) I will make further extensions. Phpbb3 has a persistent login and I want to support that, too. This is a bit tricky because it becomes necessary to create phpBB3 sessions (not only update).

I will write those changes based on the last version you have created.

Kind regards and sorry for my misunderstanding
fornit

Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 12, 2008, 06:33:09 am
No, I didn't - sorry for that.

The problem was that 7-zip format ;) I'm usually working on my company laptop where 7-zip is not installed. It's a a policy of my company that employees have no admin rights to install windows software (as 7-zip is) on the laptops.

From your comments I assumed that you have made changes to the function session_update, which seemed not to be a good idea to me :)

But I have now looked at your extensions - they are fine, thank you for that.

During the next week (or so) I will make further extensions. Phpbb3 has a persistent login and I want to support that, too. This is a bit tricky because it becomes necessary to create phpBB3 sessions (not only update).

I will write those changes based on the last version you have created.

Kind regards and sorry for my misunderstanding
fornit


There is no problem with the 0.9.3.1 ( it's based on your version 0.9.3 )
You can compare ...
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 12, 2008, 06:36:06 am
There is no problem with the 0.9.3.1 ( it's based on your version 0.9.3 )
You can compare ...

not function edit on this forum :(

*.7z : it's open with WinRAR, ... look this : http://www.fileinfo.net/extension/7z
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Neustradamus on January 12, 2008, 06:42:26 am
not function edit on this forum :(

*.7z : it's open with WinRAR, ... look this : http://www.fileinfo.net/extension/7z

I create ZIP file :

archive 0.9.3.1 : http://membres.lycos.fr/neustradamusdc/bridge%20cpg1414-phpbb3%20v0.9.3.1.zip
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on January 12, 2008, 10:27:21 am
Arguing about 7-Zip and other packagers is pointless and only clutters this thread. The extension "zip" is a standard on the internet. Using anything else is just silly. You can't expect others to download another packer just to get your archive... Please use zip archives in the future and stop arguing about that in this thread! >:(
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Bembi on January 13, 2008, 10:52:20 pm
Some hints from my site:

Ich checked the last bridging file and tried to compare it with the last published file based on the phpBB 2.x bridge.

First at all, I have to say, that it was very difficult to compare the files and functionality, as some code was not really rewritten, but only reformated or moved. This makes comparison difficult, to unterstand, what has changed and additionally is makes it difficult to test and support this.

Secondary, most of the files are not running on IIS as the file format is not correct. Esp. the language files for german are corrupting an existing  installation of phpBB, some pages are not shown anymore. Just open them in an Editor, if you see unformatted text, IIS will left the pages blank witch are using these files. Copying back the original phpBB files solves this. If they are correctly formatted, like all the other files in phpBB and coppermine, then they also will run on IIS.

The sql_files to update the database are not running as the auth_option_id field is an autoincrement field and you try to insert a blank value there.

Additionally, im not sure, if it is a good idea to change the default phpBB installation and database for the bridge. The bridge should not be a MOD, neither for phpBB nor for coppermine. It should work as it. If there is a need to add functionality to the bridge, it yould be work only with the bridgefile and the corresponding bridge table. Or it should be something optional. The result is, if you do not change the phpBB database, that you have no longer access to the coppermine gallery.

All other things I have dicovered, I will report later
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 14, 2008, 05:51:42 am
Some hints from my site:

Ich checked the last bridging file and tried to compare it with the last published file based on the phpBB 2.x bridge.

First at all, I have to say, that it was very difficult to compare the files and functionality, as some code was not really rewritten, but only reformated or moved. This makes comparison difficult, to unterstand, what has changed and additionally is makes it difficult to test and support this.

Secondary, most of the files are not running on IIS as the file format is not correct. Esp. the language files for german are corrupting an existing  installation of phpBB, some pages are not shown anymore. Just open them in an Editor, if you see unformatted text, IIS will left the pages blank witch are using these files. Copying back the original phpBB files solves this. If they are correctly formatted, like all the other files in phpBB and coppermine, then they also will run on IIS.

The sql_files to update the database are not running as the auth_option_id field is an autoincrement field and you try to insert a blank value there.

Additionally, im not sure, if it is a good idea to change the default phpBB installation and database for the bridge. The bridge should not be a MOD, neither for phpBB nor for coppermine. It should work as it. If there is a need to add functionality to the bridge, it yould be work only with the bridgefile and the corresponding bridge table. Or it should be something optional. The result is, if you do not change the phpBB database, that you have no longer access to the coppermine gallery.

All other things I have dicovered, I will report later

That's interesting, thank you.

Well ... first question: you don't say at which version you have looked, can you please add that to your comments?

From my point of view comparing the files for phpBB3 and phpBB2 makes as much sense as comparing the files of phpBB2 and vBulletin (or so). The reason is that things have changed much in phpBB3. And especially the things relevant for the bridge ...

If you insert a record with an autoincrement value and you leave the autoincrement-field blank the result should be that value is autoincremented, shouldn't it? ;)
The two statements do not change the database structure, they add two values only.

Adding texts to the language files or not is more a thing of philosophy - if you want to consider that as a modifcation, well ... but there are also texts in the language file for the other bridges.

Can you please describe that IIS problem in more detail? If you only write something about unformatted text it's difficult to understand what the problem really is.

Regards
fornit
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on January 14, 2008, 07:54:49 am
Additionally, im not sure, if it is a good idea to change the default phpBB installation and database for the bridge. The bridge should not be a MOD, neither for phpBB nor for coppermine. It should work as it. If there is a need to add functionality to the bridge, it yould be work only with the bridgefile and the corresponding bridge table. Or it should be something optional. The result is, if you do not change the phpBB database, that you have no longer access to the coppermine gallery.
I wholeheartedly and fully agree. The bridge should not modify the forum, under no circumstances.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: kryb81 on January 14, 2008, 08:23:47 am
I like the bridge very much. I haven't had enough time to test in detail. But after first problems of defining cookie-prefixes right it seems to work very well...
Specially the possibility of defining user rights in phpbb3-bord-admin for access to coppermine is very good. I would prefer this bridge&mod-solution.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 14, 2008, 11:13:38 pm
Quote
I wholeheartedly and fully agree. The bridge should not modify the forum, under no circumstances.

I can understand that - from a product point of view it wouldn't be a good idea to build each bridge in a way that it makes modifications in the system it is bridging to  ;)

Looking only at coppermine and phpBB3 from an integration and flexibility point of view people prefer the solution with the permission option in phpBB3 because it is smoother and more flexible.


Maybe a solution could be to make the modifications in phpBB3 optional - this would mean to add a new option in the bridge manager whether to use the phpBB3 permission option (as the bridge does now) or simply to use the system defined admin group from phpBB3.
If you are searching a phpBB3 bridge for coppermine standard you are welcome to contact me.

Regards
fornit
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: fornit on January 18, 2008, 10:03:13 pm
Hi,

there was a problem in the bridge displaying hebrew letters. It sholud work with those (and all other character sets) now.

[Edit GauGau] Replaced hotlinked image with attachment [/Edit]


You can find the new version, also including the extensions of Neustradamus, under:
http://www.team-andro.com/download-co3270.html

Regards
fornit
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on January 19, 2008, 01:14:12 pm
Thanks for your contribution. However, what I have said above applies to your bridge as well: we're not fond of bridges that require core code or database changes of the bridge app. In an ideal world (and a bridge that could possibly become part of the official coppermine distribution), there should only be a bridge file in coppermine's bridge folder and everything else should be done using coppermine's bridge manager. I'm not ready to hear complaints of users who accidentally broke their bridge app by a failed attempt to bridge with coppermine. Such a bridge file will not make it into the next distribution. I believe in not forcing users to hack code, simply because of the issues that this will bring along. Hacks are for geeks and coders. There are a lot of them around of course, so your bridge file is a valid contribution for this type of users.
So far, nobody has contributed a bridge file that meets those requirements (no fiddling with the bridge app's code nor the bridge app's database) - maybe because this is not possible due to the new design of phpbb3. If this is the case, there will be no support built-into cpg1.5.x for phpbb3 and the bridging will always remain a third-party hack (similar to Mehdi's Joomla bridge).

Joachim
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: mtr0212 on February 15, 2008, 05:13:38 am
I have to totally agree with Joachim Müller, it has to be safe 110%. if not is a mess for serious websites, who can not take any kind of stupid risks.

But anyway... keep the good work, this bridge is very important IMHO.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: BradP on February 15, 2008, 01:30:40 pm
Hello...

First time poster. I tried this bridge, made the small code changes necessary on my phpbb3 board, plus a couple of other minor glitchs fixed, but when the phpbb3 login page tries to redirect back to CPG, I get the list of files in my CPG folder. If I click on index.php, I see that I didn't log in. I am just back to where I started. I'm not sure yet if its a problem with the bridge and phpbb3 itself or some setting is not correct.

I'd figure I post my results for anyone interested.

Cheers
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: BradP on February 15, 2008, 01:52:08 pm
Hello...

First time poster. I tried this bridge, made the small code changes necessary on my phpbb3 board, plus a couple of other minor glitchs fixed, but when the phpbb3 login page tries to redirect back to CPG, I get the list of files in my CPG folder. If I click on index.php, I see that I didn't log in. I am just back to where I started. I'm not sure yet if its a problem with the bridge and phpbb3 itself or some setting is not correct.

I'd figure I post my results for anyone interested.

Cheers

Sorry to post again so soon, but I realized I never had index.php listed under the Directoryindex for Apache. So now that it redirects back to Coppermine, I am still not logged in. If I make any progress, I will post it up for everyone.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on February 15, 2008, 07:26:20 pm
Your postings are not valid test results. Read the thread you're replying to. It contains instructions how a valid test report is suppossed to look like (what it must contain).
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: scifirocket21 on February 18, 2008, 07:41:40 am
Hi,

there was a problem in the bridge displaying hebrew letters. It sholud work with those (and all other character sets) now.

[Edit GauGau] Replaced hotlinked image with attachment [/Edit]


You can find the new version, also including the extensions of Neustradamus, under:
http://www.team-andro.com/download-co3270.html

Regards
fornit

something is wrong with the login function now after i installed the bridge that you provided:  if you go to www.mydpnet.com/photos and click login, you will be able to see what I am talking about.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on February 18, 2008, 08:38:41 am
Not a valid test report! For the very last time: either post a valid test report, or don't reply at all to this thread. To find out how a valid test report is suppossed to look like, read this thread (I mean it: read the entire thread!). The next person who is going to reply to this thread with an invalid posting that doesn't respect the rules will cause this thread to get locked and his/her account to be banned. >:( >:( >:(
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: scifirocket21 on February 18, 2008, 06:42:27 pm
here we go...  :)

I have the following issue when trying to bridge coppermine and coppermine:
The login link for coppermine does not work properly.

Coppermine install: http://mydpnet.com/photos/
Forum install: http://mydpnet.com/forum/
Coppermine version: cpg1.4.2
Forum version: PHPBB3
Test user account: username: demo/ password: demo123

BridgeManager settings:
Forum URL:  http://mydpnet.com/forum
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  0
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on February 19, 2008, 07:53:15 am
You don't have cpg1.4.2, but cpg1.4.12 - be more carefull to post accurate information. Anyway, cpg1.4.14 is outdated - upgrade! You appear to have set stuff up improperly - I'm being redirected to http://domainhelp.search.com/search?q=mydpnet&d=www.mydpnet.com.com, which indicates that you haven't specified your forum URL properly in the bridge manager. Attach a hardcopy of your bridge manager page to your posting (using "additional options" when composing your message). Keep in mind that this is not a support thread - we assume that you know your way around in coppermine in the first place, as this is a beta bridge. If you would have reviewed the entire thread you're replying to, you would have noticed that others made the same mistakes you made - so your posting doesn't qualify as a valid test report either.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Cenobyte on February 28, 2008, 11:16:30 am
Hi everyone,

would be great if you could he me out, because my personal experiments didn't bring the results i wanted. Okay, so here's my setup:

I have the following issue when trying to bridge coppermine and phpbb3:
Quote
Fatal error: main() [function.require]: Failed opening required 'bridge/phpbb3.inc.php' (include_path='.:.:') in /var/www/vhosts/head-first.de/httpdocs/galerie/include/init.inc.php on line 239

I downloaded a phpbb3 bridge file from this thread - i dod not download a version, that modifies my phpbb, because that applications runs as i want it, and the gallery doesn't - the standalone installation works great and i really appreciate the efforts, but i would really love to get this bridge to work.

I tried a wrong file first, so i think i will had to change the entries in the DB - did that accoding to a picture of a screenshot i found in the DB here.

Coppermine install: http://www.head-first.de/galerie/
Forum install: http://www.head-first.de/forum/
Coppermine version: 1.4.14 (stable)
Forum version: PHPBB3 3.0.0 (stable)
Test user account: Test / test (only in the gallery - if you need one for the forum, let mee know)

BridgeManager settings:
Forum URL:  ../forum/
Relative path to your BBS's config file:  ../forum/
Use post-based groups?:  0
Cookie name/prefix (if applicable): phpbb3_5ag7k

Bridge settings in the db and the file i use (or better: don't use) can be found in this post as attachments.

Thanks for your work mates, think this is really one of the most important things to do for the otherwise brilliant gallery. Keep up the good work!


Thanks a lot... would be great if you can help me.
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: aunrea on March 09, 2008, 12:04:35 am
Hello,

I have been trying to bridge CPG and PHPBB3 using the bridge posted about v0.9.3. I found errors and one possible change:

When I go to the user section of the cpg admin or when I batch add images, instead of showing the blue circles I get the link text which when I click on, I get this message:

"There was an error while processing a database query"

That may be due to the fact that my cpg has the Stramm mod. Does anyone else have that mod and have the bridge working?

Also I noticed that when you click on "My Profile" it takes you to your profile display page, should it take you to "user control panel" instead?

Coppermine install: http://em.spot-design.net/gallery
Forum install: http://em.spot-design.net
Coppermine version: cpg1.4.16 w/ Stramm mod
Forum version: PHPBB 3.0.0
Test user account: testuser / test1234

BridgeManager settings:
Forum URL:  http://em.spot-design.net
Relative path to your BBS's config file:  ../
Use post-based groups?:  1
Title: Re: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on March 09, 2008, 01:49:27 pm
Not a valid test report! For the very last time: either post a valid test report, or don't reply at all to this thread. To find out how a valid test report is suppossed to look like, read this thread (I mean it: read the entire thread!). The next person who is going to reply to this thread with an invalid posting that doesn't respect the rules will cause this thread to get locked and his/her account to be banned. >:( >:( >:(
Congrats, you're that person. I had enough of those stupid requests for support although it had been said countless times in this thread that this is not a support thread and you mustn't ask for support here. Locking. You're banned from posting for 3 days.
Title: Re: [Closed]: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: johnny-b on April 12, 2008, 06:34:55 pm
I am now having coppermine 1.4.17 installed and phpbb3.0!

When i want to bridge coppermine with phpbb it will give me an fatal error after the bridging has been done.
I could re'do this bij clicking the back button on IE as it remembers the stand alone logging from coppermine and de-bridge it from phpbb.

In the meantime testing it through phpbb3 and logging in and changing the URL in IE to the coppermine link it just give me the logging screen of phpbb3 back as it overrules the coppermine link!

so that's why i de-bridged it.

however for the bridge settings i tryed to change it to:

- phpBB version 2.0.18 or better
- forum URL: http://www.website.ltd/forum
- relative folder BBS program: ../forum/
- cookie prefix: phpbb3mysql (instead of: phpbb2mysql)
- use message groups: Yes

But unfortionatlly it did not work as in the coppermine (online ftp) folder: bridge there is no phpbb3 bridge file indeed.

So i where surching for something and i came by this through google ;)

when i search on coppermine i got this with it:
http://documentation.coppermine-gallery.net/bridging.htm#integrating_bridge_start - cpg 1.5.0

But when i click on bridging files there is no phpbb3 bridge support file in it.
however i don't now if it is an official or stable coppermine release.

maybe the guys from cpg can tell me this or when they think there will be an phpbb3 bridge file available :) because i am running my website at this moment de-bridged and like it bridged very fast :D

so i hope for the best :D


Title: Re: [Closed]: phpBB 3 olympus and coppermine 1.4.10 bridge integration
Post by: Joachim Müller on April 13, 2008, 04:20:29 am
You should have read the thread you replied to. Unsupported means exactly what the name indicates. Re-locking.