volcom wrote:

The new 1.5.0RC1 allows users form phpbb to login on PWG.  Try it :-)

Awesome two improvements I am looking for!! Should I do a fresh install or upgrade?

Thanks

Outie

To tie the two databases you must edit the include/config_default.inc.php file. The lines to edit stand at the end of the file just after
// +-----------------------------------------------------------------------+
// |                            authentication                             |
// +-----------------------------------------------------------------------+

You have to edit the pwg table (you'll find the informations in the file).
And after you have to specify in the file, the names of phpbb's field.

I hope that I'm enought clear with my poor english :)

For example, this is a part of my config_default.inc.php file (to tie pwg and phpbb 2.0.17) :

// All informations contained in these tables and column are related to
// phpwebgallery_users table.
$conf['users_table'] = 'phpbb_users';

// user_fields : mapping between generic field names and table specific
// field names. For example, in PWG, the mail address is names
// "mail_address" and in punbb, it's called "email".
$conf['user_fields'] = array(
  'id' => 'user_id',
  'username' => 'username',
  'password' => 'user_password',
  'email' => 'user_email'
  );

// pass_convert : function to crypt or hash the clear user password to store
// it in the database
$conf['pass_convert'] = create_function('$s', 'return md5($s);');

// guest_id : id of the anonymous user
$conf['guest_id'] = -1;

// webmaster_id : webmaster'id.
$conf['webmaster_id'] = 2;

Last edited by Vassae (2005-09-24 12:42:49)

When editing mine simliar to yours i get the following error:

SELECT user_id AS id
     , username AS username
     , user_password AS password
     , user_email AS email
  FROM phpwebgallery_phpbb_users
  WHERE user_id = '1'
;
[mysql error 1146] Table 'aacovers_PHPgallery.phpwebgallery_phpbb_users' doesn't exist



Thanks for your help

PS. I did run the queries in phpmyadmin agains the PHPWebGallery tables:

delete from phpwebgallery_user_access;
delete from phpwebgallery_user_cache;
delete from phpwebgallery_user_feed;
delete from phpwebgallery_user_group;
delete from phpwebgallery_user_infos;
delete from phpwebgallery_sessions;
delete from phpwebgallery_rate;
update phpwebgallery_images set average_rate = NULL;
delete from phpwebgallery_caddie;
delete from phpwebgallery_favorites;

and got this resultant:

SQL query:
DELETE FROM phpwebgallery_user_access;# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM phpwebgallery_user_cache;# Affected rows:2
DELETE FROM phpwebgallery_user_feed;# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM phpwebgallery_user_group;# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM phpwebgallery_user_infos;# Affected rows:3
DELETE FROM phpwebgallery_sessions;# Affected rows:2
DELETE FROM phpwebgallery_rate;# MySQL returned an empty result set (i.e. zero rows).
UPDATE phpwebgallery_images SET average_rate = NULL ;# MySQL returned an empty result set (i.e. zero rows).
DELETE FROM phpwebgallery_caddie;# Affected rows:13
DELETE FROM phpwebgallery_favorites;# MySQL returned an empty result set (i.e. zero rows).

so seems everything went ok

Last edited by Outie (2005-09-25 01:15:51)

Ok I seemed to of got it to verify by the phpbb user database but for some reason when going from the PWG to PHPBB I have to login again on the PHPBB side. Is there a setting for sessions somewhere so they both use the same one? Thanks

Outie

Ok gotcha, I found a script that claims to join the sessions together!! So ill will try to implement that today. Is there a way to combine the groups or only use the groups in phpbb also? Thanks

Outie

Ok ill let you know. Got real busy at work so ill try it out tonight.

Outie