View Profile
View Forum Posts
Private Message
Visit Homepage
I need a MySQL request to copy this data :
From table : e107_user
To table : ibf_members
Copy column = user_id
to column = id
Where
colum user_name in table e107_user = colum name in table ibf_members
Thanx
I need a MySQL request to copy this data :
From table : e107_user
To table : ibf_members
Copy column = user_id
to column = id
Where
colum user_name in table e107_user = colum name in table ibf_members
Thanx
It's okey I've found a way
Didn't even give me a chance to answer
There was a problem with the e107 integration to IBF !
The script copies accounts but not their IDs so a user has a different ID on e107 than the one on IBF. Users were getting problems opening their settings control panel from e107 login menu and were redirected into other members profiles !
So I made this SQL request :
I had the following error : Unknown table "ibf_members"Code:UPDATE e107_user SET e107_user.user_id = ibf_members.id WHERE e107_user.user_name = ibf_members.name
The solution was to do the request this way :
I suggest you copy this into e107-IBF integration forum in case somebody has the same problem as I did !Code:UPDATE ibf_members, e107_user SET e107_user.user_id = ibf_members.id WHERE e107_user.user_name = ibf_members.name
The redirection, login, ect.. are all username based though. The script doesn't focus at all on user ids, it is username based (this is the third or fourth integration I have done, I learned by the second that it was easier to just base it off of usernames).
I don't understand where you were having problems?
When a user was clicking on his "Profile" from e107, he was redirected using a different ID...
Let's say member "Smith" clicks "profile" from e107 login menu... when he get's redirected into invision profile, he's seing member "Gabrielle" !
if users have different ID's in e107 and IBF the profile redirection is done wrong, and I prefer to keep the both databases synchro,ized with same ID's... Just to have it clean and nice
