1
BeautyBrains
Can I Merge User Accounts

I have two accounts on the site; a account that is a registered user and one that is Admin.

Is it possible to transfer all postings from one account to another and then have each mod update and reflect the new posting count?

Also would I do this by modifying my sql file, if so what precautions would be necessary?
A man without history is like a tree without roots. Marcus Garvey (1917) http://CaribbeanAncestry.com http://JamaicaGenealogy.com http://thephilosophizers.com Teach what you know and learn what you don't; stay open to all. 24/7

2
madDan
Re: Can I Merge User Accounts
  • 2010/7/17 10:41

  • madDan

  • Not too shy to talk

  • Posts: 105

  • Since: 2010/1/6 1


You are probably best trying this on a local copy first in xampp or whatever.

take a backup of DB before you start, then have a go updating the one uid to the one you wish to merge with site wide accross the tables

Then see the end result if, satisfied you can repeat on the actual site.

3
BeautyBrains
Re: Can I Merge User Accounts

I have no clue what xampp is but I will do some research and then give it a try. Thanks a mille
A man without history is like a tree without roots. Marcus Garvey (1917) http://CaribbeanAncestry.com http://JamaicaGenealogy.com http://thephilosophizers.com Teach what you know and learn what you don't; stay open to all. 24/7

4
Catzwolf
Re: Can I Merge User Accounts
  • 2010/7/24 1:02

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


WARNING: I wouldn't follow that advice on the website, unless you want to lose a lot of user information.

To do this correctly you will have to do a lot more than that... there will be many other modules that use a 'User ID' and if you follow this advice they may not match up afterwards.

5
BeautyBrains
Re: Can I Merge User Accounts

Oh Lord! Thanks Katz. I didn't try it as yet. I'll just leave it alone for now.

What I need wordpress has it. If I delete a user in wordpress it will ask, "who do you wish to assign the posts to." Then I delete the user and all their postings are automatically transfered to the user I selected.

It would be nice to have this implemented in future updates of xoops.
A man without history is like a tree without roots. Marcus Garvey (1917) http://CaribbeanAncestry.com http://JamaicaGenealogy.com http://thephilosophizers.com Teach what you know and learn what you don't; stay open to all. 24/7

Login

Who's Online

316 user(s) are online (241 user(s) are browsing Support Forums)


Members: 0


Guests: 316


more...

Donat-O-Meter

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

Latest GitHub Commits