Gossamer Forum
Home : Products : Gossamer Links : Discussions :

After Importing from Links2 Merge Users

Quote Reply
After Importing from Links2 Merge Users
Hello,

After I imported from Links2.0 I need to merge some users/listings in to a single account.

For example, USERA has 10 links and USERB has 4 links. I want USERB's 4 links moved into USERA's account, so USERB will no longer exist and USERA can login to the account acess all 14 links after logging into his account. How can I do this?

Thanks in advance,
Socrates
Quote Reply
Re: [socrates] After Importing from Links2 Merge Users In reply to
The easiest way would be via SQL:

Code:
UPDATE glinks_Links SET LinkOwner = "new_owner_username" WHERE LinkOwner = "old_username"

Hope that helps

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] After Importing from Links2 Merge Users In reply to
Andy,

Thanks but I don't follow. Can you please explain step by step how I do it.

Also when I want to update luna templates - do I upload changed template files to the "templates" directory or "templates/local" directory?

Thanks!
Quote Reply
Re: [socrates] After Importing from Links2 Merge Users In reply to
Hi,

Its pretty simple Smile

As per your example, you said:

Quote:
For example, USERA has 10 links and USERB has 4 links. I want USERB's 4 links moved into USERA's account, so USERB will no longer exist and USERA can login to the account acess all 14 links after logging into his account. How can I do this?

So all you would do, is run this via Database > SQL Monitor:

Code:
UPDATE glinks_Links SET LinkOwner = "USERA" WHERE LinkOwner = "USERB"

That would simply "assign" the links to USERA (from any links that were owned by USERB)

Quote:
Also when I want to update luna templates - do I upload changed template files to the "templates" directory or "templates/local" directory?

Yeah, to make it safe for future updates (otherwise they get overwritten when new upgrades are installed)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] After Importing from Links2 Merge Users In reply to
Thanks again Andy but when I do that, I get an internal server error - does it have anything to do with the glinks prefix or database name? My links prefix is glinks_

Perhaps it is an issue with Mod Security on my server - it will trip if any form input has quotemarks (") and such characters.

Is it possible to do this from MySQL Monitor?

Thanks!
Quote Reply
Re: [socrates] After Importing from Links2 Merge Users In reply to
For mySQLMan you get a 500 IS Error? Could just be a configuration error (especially if your site has been moved to different servers)

That command will run fine in SQL Monitor though.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!