mistic100 wrote:

Hi,

1) Piwigo can share the user table of any other software, they just need to be in the same database and you have to configure some things (see include/config_default.inc.php for details)

Code:

$conf['users_table'] = null;

$conf['user_fields'] = array(
  'id' => 'id',
  'username' => 'username',
  'password' => 'password',
  'email' => 'mail_address'
  );

you can also share the autologin cookie but I never used it

Code:

$conf['remember_me_name'] = 'pwg_remember';

2) [extension by plg] Community is basic but allow many things, moreover with [extension by icy] Icy Picture Modify

Thank you for your speedy reply.

I must confess that I am not much of a coder! I was actually hoping to keep both applications on separate databases. I will look into the autologin cookie.

I will check out the Community  and Icy Picture Modify extensions.

Bob

With the current architecture it's impossible with separate databases, because it needs to have two MySQL connection

As a very limited number of users can have more than one database (and more fewer really need more databases), it's not implemented

about the code I gave ? it's quite simple
activate the plugin LocalFilesEditor to have access to the advanced configuration (the first tab on the plugin page)

and complete the file with this code (modified)

$conf['users_table'] = 'other_table_name';

$conf['user_fields'] = array(
  'id' => 'id',
  'username' => 'username',
  'password' => 'password',
  'email' => 'mail_address'
  );

'users_table' is the name of table you want to use, the users table of SMF if I understood

'user_fields' is an array used to map table fields name to Piwigo internal names, if the SMF users table is like that :
|-- user_id --|-- username --|-- password--|-- email --|
use this (change the second collumn) :

$conf['user_fields'] = array(
  'id' => 'user_id',
  'username' => 'username',
  'password' => 'password',
  'email' => 'email'
  );

there is also an other interesting parameter :

$conf['guest_id'] = 2;

defining the guest (not logged) user id
if this id is not 2 in SMF you must change it here AND update the table piwigo_user_infos (change the user_id fields of the guest user)

mistic100 wrote:

With the current architecture it's impossible with separate databases, because it needs to have two MySQL connection

You don't need 2 connections because you can use $conf['users_table'] = 'other_database.other_table_name'; as soon as the MySQL user has privileges on both databases.

You've also add
$conf['external_authentification'] = true;

Hello,

As the OP of this thread, I'd like to say thank you for the interest being taken. I must confess that I am lost with the coding side of this!

I have installed Piwigo on my test site and it uses the same database as my test SMF forum. I am not sure whether there is any benefit from running them on the same database other than the suggested limitations mentioned by mistic100 in his first reply to me.

I must confess to being confused when told "activate the plugin LocalFilesEditor to have access to the advanced configuration (the first tab on the plugin page) and complete the file with this code (modified)"

I have the LocalFilesEditor installed and activated. I am assuming that reference to the first tab on the plugin page is referring to LocalFilesEditor itself. If that is the case, which file should be completed with the code?

I warned you that my coding skills were minimal!

Bob

mistic100

Good morning! My first attempt failed last night and so I cleared the piwigo tables from the database, deleted the files and have done a reinstall. No problem!

May I confirm that I have understood you correctly. The fields in table piwigo_users that we are referring to are:

id, username, password and mail_address.

User details appear to be held in SMF in the table smf_members and are: id_members, member_name, passwd and email_address.

Therefore, the code that I should be entering is:

$conf['piwigo_users'] = 'smf_members';

$conf['user_fields'] = array(
  'id' => 'id_members',
  'username' => 'members_name',
  'password' => 'passwd',
  'mail_address' => 'email_address'
  );

I ask this because I am not sure that I have the references on the correct side of the '=>'.

Next, may I query your comment about the guest id. ($conf['guest_id'] = 2;)

I have examined the piwigo table and as you say the id is always '2'. However, I cannot find any reference to a guest id in SMF! Maybe that application relies upon the fact that the user simply has not logged in. (I am guessing here!)

If my guess is correct, would it be acceptable to simply change the guest id in piwigo to something outrageous like 1000000? (The forum is popular but not that popular!

Thank you for your help.

Bob