[Alpha] phpBB&mambo Users MOD

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

[Alpha] phpBB&mambo Users MOD

Post by alycad »

phpBB&mamboUsers MOD Mod v0.0.2
Developed by Álvaro Martins

Essencial colaboration of Pedro Seco, Carlos Correia, Mónica Sara, withou who this mod never get this far


Download v0.0.2
  • Requirements
  • This mod needs: phpBB e Mambo instaled on the same database.


    Functionalities
  • Register on both user
    from mambo to phpbb, or phpbb to mambo
  • Compatible with mambo 4.5.2.1 and phpBB 2.0.13
    update always to latest versions

    Detected Bugs
  • If any of the user tables has their order diferent than standart, it might avoid transfer script to function.


    Future updates

  • Modify both profiles, mambo and phpbb, when one is altered
  • Password recovery, rewrite on both user tabless.
  • Mantain session trought both scripts.


Edit: 15 June 2005


When submiting a user in mambo, it should return this error:


Could not insert data into users table
DEBUG MODE

SQL Error : 1062 Duplicate entry '0' for key 1

insert into mos_users (name, username, email, password) values ('cool', 'cool', 'tfrancois@heaven.fr', 'test3')

Line : 227
File : usercp_register.php


You must edit phpbb_users table, field ID, must be in "auto-increment", and the "Default" must be removed from 0 to empty.


[*] Install Description of [Alpha] phpBB&mambo Users MOD
[/b]


Code: Select all

################################################################# 
## Mod Title:phpBB&mambo Users
## Mod Version: 0.0.2 :: Segunda Feira, 11 Abril, 2005 22:05 GMT
## Author: Álvaro Martins alvaromartins@globalfree.net
## URL: http://www.phpbb.globalfree.net
## Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102
## Description: Mambo e phpBB ( standalone ) user integration##                   
##                   For existent phpBB and new mambo portal
##                   For existent mambo portal and new phpbb instalation
##                   For both new instalations of mambo and phpBB
##                   For systems that are already both instaled
##                  
## 
## Installation Level: Easy
## Installation Time: 5 Minutes 
## Files To Edit: 
## phpBB  > /includes/usercp_register.php 
## Mambo > /components/com_registration/registration.php 
## 
## Included Files: copyphpbb2mambo.php, copymambo2phpbb.php, Install_phpBB&mamboUsersMOD_Portuguese.txt, Install_phpBB&mamboUsersMOD_English.txt
################################################################# 
## Security purposes: This mod cannot be used out side non oficials phpbb or mambo portal or foruns
#################################################################
#
################################################################# 
# 
#-----[ Open ]------------------------------------------ 
# 
/includes/usercp_register.php 
# 
#-----[ search ]------------------------------------------ 
# 
message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql); 
         }
# 
#-----[ Line after add ]------------------------------------------ 
# 
// phpBB&mambo Users - Inicio da alteração
// URL: http://www.phpbb.globalfree.net
// Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102
$sql = "insert into mos_users (name, username, email, password) values ('" . str_replace("\'", "''", $username) . "',  '" . str_replace("\'", "''", $username) . "',  '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $new_password) . "')"; 
         if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) ) 
         { 
            message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql); 
         }
// phpBB&mambo Users - Fim da alteração
# 
#-----[ Open ]------------------------------------------ 
# 
com_registration/registration.php
# 
#-----[ Search ]------------------------------------------ 
# 
  if ( $mosConfig_useractivation == "1" ){ 
      echo _REG_COMPLETE_ACTIVATE; 
   } else { 
      echo _REG_COMPLETE; 
   }
# 
#-----[ Line after add ]------------------------------------------ 
#
// phpBB&mambo Users - Begining
// URL: http://www.phpbb.globalfree.net
// Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102
$passwordmonica = md5($pwd); 
$regdate = strtotime ("now"); 
$sql = "insert into phpbb_users (username, user_password, user_email, user_regdate) values ('".$username."', '". $passwordmonica."', '".$email."', '". $regdate."')"; 
   $database->setQuery( $sql ); 
   if (!$database->query()) { 
      die("SQL error" . $database->stderr(true)); 
   } 
// phpBB&mambo Users - End
// URL: http://www.phpbb.globalfree.net
// Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102# 
##
##
##
## 
## Mod Title:phpBB&mambo Users
## Mod Version: 0.0.2 :: Segunda Feira, 11 Abril, 2005 22:05 GMT
## Author: Álvaro Martins alvaromartins@globalfree.net
## URL: http://www.phpbb.globalfree.net
## Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102
## Description: Mambo e phpBB ( standalone ) user integration.
Last edited by alycad on Wed Jun 15, 2005 1:47 pm, edited 2 times in total.
bijanv
Registered User
Posts: 12
Joined: Thu Apr 07, 2005 8:30 pm

Post by bijanv »

Wow thank you guys so much! Been waiting for this for too long, especially the english version! :lol: Just one question however. What is the downloaded file for? The copymambo2php.php and copyphp2mambo.php

You have not specified where to use these files and when looking at them all the comments are in portugese! Please help clear this up!

Thank you for all of your hard work! :D


Edit: I was just looking at the code (although I'm not a very experienced or knowledgeble programmer) and there seems to be some things that don't make too much sense.

One thing is for the people that just copy and past the code note that in com_registeration/registeration.php:

This

Code: Select all

// Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102$passwordmonica = md5($pwd); 
Must be

Code: Select all

// Mod URL: http://www.phpbb.globalfree.net/forum/viewtopic.php?p=102

$passwordmonica = md5($pwd); 

Also in
$sql = "insert into phpbb_users (username, user_password, user_email, user_regdate) values ('".


I might be wrong but isn't there supposed to be another quotation mark somewhere there because it is basically making all the statements strings so they are not doing the functions they are supposed to? (I apologize if I'm wrong, it just looks a little akward to me)
Last edited by bijanv on Sun Apr 17, 2005 4:08 pm, edited 5 times in total.
Frold
Registered User
Posts: 447
Joined: Sat Nov 02, 2002 8:19 am

Post by Frold »

can you use a modded version of phpBB together with mambo?
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

Post by alycad »

Hi bijnev,
This
Código:
// Mod URL: http://www.phpbb.globalfree.net/forum/v ... wordmonica = md5($pwd);



Must be
Código:

// Mod URL: http://www.phpbb.globalfree.net/forum/v ... .php?p=102

$passwordmonica = md5($pwd);


You are correct.

Thanks ;)

But in here:

Also in
Citação:
$sql = "insert into phpbb_users (username, user_password, user_email, user_regdate) values ('".


The line is:

$sql = "insert into phpbb_users (username, user_password, user_email, user_regdate) values ('".$username."', '". $passwordmonica."', '".$email."', '". $regdate."')";

it as no mistakes :p
Wow thank you guys so much! Been waiting for this for too long, especially the english version! Just one question however. What is the downloaded file for? The copymambo2php.php and copyphp2mambo.php


Its used to copy, who needs..., users from phpbb user table to mambo user table, and the oposite

Ill try to translate the file coments ;)

Thanks,

Alvaro
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

Post by alycad »

Frold wrote: can you use a modded version of phpBB together with mambo?


Yes you can ;)

Because they work alone, only users are common ;)

My forum as many mods, thats why i cant use tim-online compoente for mambo :p

Alvaro
nickomash
Registered User
Posts: 4
Joined: Thu Apr 21, 2005 5:25 pm
Contact:

Post by nickomash »

Has anyone gotten this code to work properly?

I have made the necessary code additions to the required files, but I am having an extremely irritating problem when it comes to these areas:

Login: Can login to Mambo Cannot login to phpBB.

phpBB ACP: Cannot login to ACP, or any other phpBB board required login.

Mambo Login Issue: When a member logs into Mambo they are NOT logged into phpBB, I was under the impression this MOD not only registered users into the phpBB database, but also logged them in from one central location.

Newest Registered Users: Although members register and are logged in the "memberlist", on the bottom of the forum where it says newest registered users it keeps the superuser (me) and doesnt report any other users that HAVE registered.

Well these are all the problems I am currently experiencing, I completely reinstalled both Mambo and phpBB from scratch to use this mod, as Tim's phpBB component does not allow for a MODDED phpBB to be integrated. I have listed the problems in the order of their importance IMO.

If someone has installed this HACK properly than I would appreciate their support in explaining my login issues first and foremost. I login to Mambo just fine, but when I visit my phpBB I am unable to login there. After I attempt a login it spits me back to the forum main page, but I am NOT
logged in. No matter how I try to login it keeps redirecting me back to the login page again.

I would GREATLY appreciate any and all support that could be offered with this phpBB+Mambo Hack, as the "simple" code changes alone do not do all of what the creator said they would. I have a strong feeling his board and CMS is heavily modded and he is not explaining all of his HACK to us properly. I feel something major or simple is being left out and do to his unfortunate language barrier it is hard to explain in further detail.

Specs:
Mambo Latest Build 5.4.21
phpBB2 Latest Build 2.0.14
nickomash
Registered User
Posts: 4
Joined: Thu Apr 21, 2005 5:25 pm
Contact:

Post by nickomash »

Please disregard my above topic. Should anyone be having similar problems as myself and cant find your answer or a polite enough iNet user to answer you than please check the below links for "Mambo Plus" a specialized version able to run both Mambo and phpBB seperate (moddable) and keep databases and even sessions!!!!! together.

Mambo Plus Site:
http://demo.impleri.net/index.php

Mambo Plus @ Mambo Forge:
http://mamboforge.net/projects/mosplus/

Good Luck phpBB Buddies! :D
bijanv
Registered User
Posts: 12
Joined: Thu Apr 07, 2005 8:30 pm

Post by bijanv »

unfortunely i have no idea why... tried this mod at least 5 times and still does not work.. i have no clue what i'm doing wrong :cry:
Login: Can login to Mambo Cannot login to phpBB.


Same problem as me but I guess that means the installation DIDN'T work... cuz that's not what's supposed to be happen!! You should be able to login with same username/pass in both Mambo AND phpbb
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

Post by alycad »

Has anyone gotten this code to work properly?


Yes ;)

www.companhiadosanimais.com
www.golfinhos.net

I have made the necessary code additions to the required files, but I am having an extremely irritating problem when it comes to these areas:


Only two files are edited.
Login: Can login to Mambo Cannot login to phpBB.


When you register in mambo or phpbb does the user appear on the other user table?

U might have to check this.

phpBB ACP: Cannot login to ACP, or any other phpBB board required login.


phpbb issue.... not mod...
Mambo Login Issue: When a member logs into Mambo they are NOT logged into phpBB, I was under the impression this MOD not only registered users into the phpBB database, but also logged them in from one central location.


Not at this time... beta version will have that issue solved.
Newest Registered Users: Although members register and are logged in the "memberlist", on the bottom of the forum where it says newest registered users it keeps the superuser (me) and doesnt report any other users that HAVE registered.


not a mod problem, but phpbb...
Well these are all the problems I am currently experiencing, I completely reinstalled both Mambo and phpBB from scratch to use this mod, as Tim's phpBB component does not allow for a MODDED phpBB to be integrated. I have listed the problems in the order of their importance IMO.


and thats the way you should do.


First i advise you to install phpbb, and test all itens register, etc, before aplying mambo mod. ok?
If someone has installed this HACK properly than I would appreciate their support in explaining my login issues first and foremost. I login to Mambo just fine, but when I visit my phpBB I am unable to login there. After I attempt a login it spits me back to the forum main page, but I am NOT
logged in. No matter how I try to login it keeps redirecting me back to the login page again.


I have installed, and some portuguese and brasilian guys to. But that error is not from the mod...

I would GREATLY appreciate any and all support that could be offered with this phpBB+Mambo Hack, as the "simple" code changes alone do not do all of what the creator said they would. I have a strong feeling his board and CMS is heavily modded and he is not explaining all of his HACK to us properly. I feel something major or simple is being left out and do to his unfortunate language barrier it is hard to explain in further detail
.

I have tryed to explain all, but there is a simple question, that i have not mentioned.... sorry...

In phpbb_users table, field user_id u must remove "auto- increment"


Specs:
Mambo Latest Build 5.4.21
phpBB2 Latest Build 2.0.14[/quote]

Ill help to instal your mod, ig u have a test board, leave the link so we can try.

Best reg,

Alvaro
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

Post by alycad »

bijanv wrote: unfortunely i have no idea why... tried this mod at least 5 times and still does not work.. i have no clue what i'm doing wrong :cry:
Login: Can login to Mambo Cannot login to phpBB.


Same problem as me but I guess that means the installation DIDN'T work... cuz that's not what's supposed to be happen!! You should be able to login with same username/pass in both Mambo AND phpbb


try this:

In phpbb_users table, field user_id u must remove "auto- increment"
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

Post by alycad »

nickomash wrote: Please disregard my above topic. Should anyone be having similar problems as myself and cant find your answer or a polite enough iNet user to answer you than please check the below links for "Mambo Plus" a specialized version able to run both Mambo and phpBB seperate (moddable) and keep databases and even sessions!!!!! together.

Mambo Plus Site:
http://demo.impleri.net/index.php

Mambo Plus @ Mambo Forge:
http://mamboforge.net/projects/mosplus/

Good Luck phpBB Buddies! :D


This is not phpbb standalone...

And does not have the same table structure as phpbb... users table is diferent, and if a mod requires to change user table, or any variable related to user, it wont work..

ok?

My version is for standalone versions, not to create a simple package with mambo and phpbb, Tim-online as already done it, and i have installed in:

www.torresvedras.biz


and it works very very nice. Dont allow modifications...


My version, works, wiht:

Code: Select all

## Para fóruns phpBB já existentes que vão instalar mambo 
## Para portais mambo já existentes e que vão instalar o phpBB 
## Para instalações novas de mambo e phpBB 
## Para instalações já existentes de ambos os sistemas 
translating:

Code: Select all

]## already existent phpbb forun and new mambo install
]## already existent mambo and new phpbb forum
]## both new instalations
]## already in use, phpbb and mambo without being together.

Are u clarified now?
Gwitto
Registered User
Posts: 2
Joined: Sun May 23, 2004 9:55 pm
Contact:

Post by Gwitto »

Hi alycad,

thanx for publishing this MOD. It works fine, but what do you do if a user change his e-mail or password? These changes won't be synchronize with your MOD.

Do you have a solution for this problem (another mod) or must all users make their changes in phpbb and mambo?

I don't have so much experience with php to make the changes on my own.

Greetz from Germany
alycad
Registered User
Posts: 160
Joined: Thu Mar 04, 2004 10:13 am
Location: Portugal
Contact:

Post by alycad »

Gwitto wrote: Hi alycad,

thanx for publishing this MOD. It works fine, but what do you do if a user change his e-mail or password? These changes won't be synchronize with your MOD.

Do you have a solution for this problem (another mod) or must all users make their changes in phpbb and mambo?

I don't have so much experience with php to make the changes on my own.

Greetz from Germany


I gwito,

Thats what im working on.

My ideia is to try to find in mambo and in phpbb, the action of Lost Password, and when one of this is trigered it writes on both passw table fields.

Im working on it, i have made some progress but i still get some errors ;)

Wait for news ;)

Alvaro
Gwitto
Registered User
Posts: 2
Joined: Sun May 23, 2004 9:55 pm
Contact:

Post by Gwitto »

I think this is my main point:
Modify both profiles, mambo and phpbb, when one is altered


In my case, I think the main problem is changing email adresses and of course the password. Password recovery is less important for me. I'm not so familiar with php, but i'm still surprised that nobody else has done this before - it shouldn't be so difficult?!

I stay tuned and hope for updates.
bijanv
Registered User
Posts: 12
Joined: Thu Apr 07, 2005 8:30 pm

Post by bijanv »

If I have installed community builder and am using that login system, will I be able to still use this mod?
Post Reply

Return to “[2.0.x] MODs in Development”