Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

mass changes of link owners

Dec 11, 2002, 1:49 PM
rayhne
Enthusiast (582 posts)
rayhne's avatar
Dec 11, 2002, 1:49 PM
Post #1 of 3
Views: 1290
Shortcut
Quote Reply
mass changes of link owners
I need to change a number of Link Owners over to admin...is there a quick, easy way to do this rather then going in and doing them one by one?
Dec 11, 2002, 2:41 PM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Dec 11, 2002, 2:41 PM
Post #2 of 3
Views: 1252
Shortcut
Quote Reply
Re: [rayhne] mass changes of link owners In reply to
Could do it via MySQLMan if you dont mind finding out their ID's;

UPDATE lsql_Links SET LinkOwner = "new person" WHERE ID = 1,2,3,4

I'm not sure of the syntax for the last part of the query. Give it a go, and see if it works Smile

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!
Dec 11, 2002, 2:55 PM
Paul
Veteran (19537 posts)
Dec 11, 2002, 2:55 PM
Post #3 of 3
Views: 1244
Shortcut
Quote Reply
Re: [Andy] mass changes of link owners In reply to
WHERE ID IN ('1','2','3','4')