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

The easiest way would be via SQL:


Hope that helps

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

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!

Hi,

Its pretty simple

As per your example, you said:


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


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


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

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

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!

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

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates