nikes Posted February 27, 2009 Share Posted February 27, 2009 I trying to do a full integration of phpbb3 into dolphin 6.1.4. I'm currently looking at some steps on how to do so. I'm stuck on this step: (instead of (users) it's (profiles)) Mapping: Have to create mapping between the users inside the two tables. These will be referred as: user (website users) - and - phpbb_user (phpbb users) The question, how should I map website users onto phpbb users? There are many ways to do this. I chose the simplest one to implement. Map user.UserID to phpbb_users.user_id. This way a user can always be looked up into phpbb users and vice versa. There is one problem however. PHPBB3 fresh installation creates about 50 users by default. These include the super administrator, anonymous and search bots. That means user_id 1 to 50 are unavailable. I could have created 50 fake users in the user table so that any further website users can be mapped properly. However, I already had about 250+ users by the time integration was supposed to be made. So I chose to map by adding a constant - 1000. So: Website user #1 becomes phpbb user #1001 Website user #2 becomes phpbb user #1002 ... and so on. This way I don't have to run any lookup queries when I have for find phpbb user given website user id and vice versa. How do i do this? Quote Link to comment Share on other sites More sharing options...
nikes Posted February 27, 2009 Author Share Posted February 27, 2009 ??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.