21
intel352
Re: Need Help with MySQL syntax to merge two xoops_user tables
  • 2004/12/13 6:06

  • intel352

  • Module Developer

  • Posts: 824

  • Since: 2003/11/23


pm me tmrw, i'll work on it then (going to bed now)

22
brash
Re: Need Help with MySQL syntax to merge two xoops_user tables
  • 2004/12/13 6:46

  • brash

  • Friend of XOOPS

  • Posts: 2206

  • Since: 2003/4/10


No worries, will do

23
DonXoop
Re: Need Help with MySQL syntax to merge two xoops_user tables

I now have a similar need but maybe easier to accomplish. I'm creating a new site and would like to pre-populate the userbase with the 300 users from another site. The new site is fresh and will have a similar design except for using the new Forum and a much different group structure (groups by regions).

The basic users may be easy enough but setting up the groups could be a nightmare. As mentioned by Brash, the group handling after a certain number of users is more than painful. Maybe starting with the same groups if I can have that populated during the merge and then renaming and adjusting afterward?

24
pcracer
Re: Need Help with MySQL syntax to merge two xoops_user tables
  • 2006/11/2 15:04

  • pcracer

  • Just popping in

  • Posts: 31

  • Since: 2003/10/23


great thread! worked & saved me sooo much time thx!

how/what would be used to only merge 2 of my users into 1?
the only problem i have run into from merging db users, is that 1 of my users [an admin] had a different user name in 1 db & now has 2 accounts which both have forum posts & pics [myalbulm] posted...i merged forums & pics as well from the old site db
If Everything Seems Under Control...You're Not Going Fast Enough!

Login

Who's Online

212 user(s) are online (162 user(s) are browsing Support Forums)


Members: 0


Guests: 212


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits