Quote: › CREATE TABLE phpbb_gallery2_data (
g2i_dataName varchar(255) NULL, g2i_dataValue TEXT NULL
) CHARACTER SET 'utf8' COLLATE 'utf8_bin';

INSERT INTO phpbb_gallery2_data (g2i_dataName, g2i_dataValue) VALUES ('g2i_exportData', NULL);

INSERT INTO phpbb_gallery2_data (g2i_dataName, g2i_dataValue) VALUES ('g2i_acpAdmin', NULL);

ALTER TABLE phpbb_users
ADD user_gallery VARCHAR( 10 ) NULL DEFAULT NULL,
ADD user_gallery_links_data TEXT NULL DEFAULT NULL;

INSERT INTO phpbb_styles_imageset_data ( image_name , image_filename , image_lang , image_height , image_width ,
imageset_id ) VALUES ('icon_user_gallery' , 'icon_user_gallery.gif', '', 20, 25, 1);

INSERT INTO phpbb_styles_imageset_data ( image_name , image_filename , image_lang , image_height , image_width ,
imageset_id ) VALUES ('button_gallery' , 'button_gallery.gif', 'en', 18, 59, 1);

w91803 wrote: ›
In my PHPBB3, Database name is hk_phpb1. Table name is phpb1_users.

In my Gallery2, DataBase name is hk_gllr1. Table name is g2_user.


In the following codes, should I rename all to phpbb_ from phpb1_?

Also should I rename all to g2_user from user_gallery?

Let me know if it is correct? Thanks,......

IngerK wrote: ›
All database changes should be done in phpBB database as far as I can remember (I have both in same database). In the instructions, you have to use your own prefix phpbb1.

That is: phpbb1_gallery2_data (same with other tables).

Be sure to have backup or use a test forum/gallery. I always do both.

Quote: › Users are exported to G2 database. You have to configure the integration in phpBB administration panel -> Gallery2 settings, and sync users. Read all the DIY instructions.