Hi,

I, along with many other users of Piwigo, would like to be able to integrate Piwigo with other systems; forums, CMS, etc... Using user_id throughout your script creates a significant amount of compatibility issues with doing that.

In my case, I'm integrating Piwigo with phpBB forums. By string replacing "user_id" with "pwg_user_id" in Piwigo, and the Community plugin, I was able to integrate with phpBB without any problems. Without making that change, it simply doesn't function properly.

Here's the full story:

I decided to go ahead and do a test install of Piwigo, first replacing user_id with pwg_user_id in all the source code. Then I did a fresh install of my modified Piwigo version. I did the same string replace of user_id with pwg_user_id on the Community plugin that was also causing errors.

I then exported my phpbb_users table with over 30,000 users in it, and imported it into my new Piwigo database.

I modified the config_default.inc.php file with the following code (note that my password hash is for phpBB 3.1.x, phpBB 3.0.x uses md5 instead of password_hash):

// +-----------------------------------------------------------------------+
// | phpBB MODS                                                            |
// +-----------------------------------------------------------------------+

$conf['users_table'] = 'phpbb_users';
$conf['external_authentification'] = true;
$conf['user_fields'] = array(
  'id' => 'user_id',
  'username' => 'username',
  'password' => 'user_password',
  'email' => 'user_email'
  );
$conf['password_hash'] = create_function('$s', 'return password_hash($s);');
$conf['password_verify'] = 'pwg_password_verify';
$conf['guest_id'] = 1;
$conf['default_user_id'] = $conf['guest_id'];
$conf['browser_language'] = true;
$conf['webmaster_id'] = 2;
$conf['guest_access'] = false; // change this one if you want
$conf['insensitive_case_logon'] = true;

I would not recommend using "username_clean" for the username field because that would result in all the new user albums being created with lowercase names.

I did the following as recommended, even though most of it is not necessary on a fresh install:

delete from piwigo_user_access;
delete from piwigo_user_cache;
delete from piwigo_user_feed;
delete from piwigo_user_group;
delete from piwigo_user_infos;
delete from piwigo_sessions;
delete from piwigo_rate;
update piwigo_images set rating_score = null, added_by = <webmaster_id>;
delete from piwigo_caddie;
delete from piwigo_favorites;

I then logged in with my phpBB admin username. It worked flawlessly. I was able to view the user manager page in the admin fine.

I activated the Community plugin and the user manager in the admin still worked fine. I did not need to do the other mods done before to fix the Community plugin. All errors were a result of the use of user_id in the Piwigo source code.

Obviously doing this method on the user end will need to be repeated for future updates, and Piwigo should implement it themselves and save us the trouble. I'm going to see if I can manipulate the way Piwigo is accessing the database to work better with phpBB, but I'm not sure if it will work or not. Most of what I've seen is already being aliased.

THREE NOTES:

1. Make sure NOT to change default_user_id to default_pwg_user_id in your auto find&replace.

2. Do NOT make any changes to config_default.inc.php for the clean install prior to bridging the scripts.

3. If you don't want to edit config_default.inc.php (since you're technically not supposed to), you can instead create a file called config.inc.php and put it in the /local/config folder within your Piwigo installation. That will override any of the default file's settings, and be safe from future updates.

I activated the Community plugin and the user manager in the admin still worked fine. I did not need to do the other mods done before to fix the Community plugin. All errors were a result of the use of user_id in the Piwigo source code.

UPDATE:

I've since tested this with a live phpBB board, and it works great. The next step is to make it work with a single sign-on, but making this change to Piwigo would be a good first step to improving compatibility with other scripts.

Piwigo version: 2.8.2
PHP version: 5.6
MySQL version: 5.5

Last edited by KungFuJosh (2016-10-03 15:54:11)