Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Merge categories

Home: General: General Discussions:

 

 


Giray
Novice

Karma: -0 / +0

Jul 11, 2005, 1:15 PM

Post #1 of 6 (9516 views)
Shortcut

Send Giray a wink
Merge categories Can't Post

Hi Andy. Did I miss it? Do you have a simple plug in that allows one to merge two categories' links in GLinks? Ideally it would be a 'click on the first category, click on the second, confirm!


Andy
Enthusiast

Karma: -1 / +7


Jul 12, 2005, 4:40 AM

Post #2 of 6 (9508 views)
Shortcut

Send Andy a wink
Re: [Giray] Merge categories [In reply to] Can't Post

Hi,

I'm afraid we don't have anything like that. Have you considered using the "browse" function in the GLinks admin panel? (top frame). This lets you move links from one category to another, pretty easily Smile

Hope that helps.

Cheers
Andy
Programmer/Designer/LinksSQL Freak Cool

http://www.ultranerds.com
http://www.imagesql.com



Giray
Novice

Karma: -0 / +0

Jul 12, 2005, 4:44 AM

Post #3 of 6 (9502 views)
Shortcut

Send Giray a wink
Re: [Andy] Merge categories [In reply to] Can't Post

Unless I missed something, this is fine for one link at a time. But if you want to move 100 links into another folder with its own links, then there is no way! Maybe through the sql tables... I'll ask our tech.


Andy
Enthusiast

Karma: -1 / +7


Jul 12, 2005, 4:57 AM

Post #4 of 6 (9501 views)
Shortcut

Send Andy a wink
Re: [Giray] Merge categories [In reply to] Can't Post

Hi,

If you know how to run MySQL commands, the you could do it via Database > MySQL Monitor


Code
UPDATE lsql_CatLinks SET CategoryID = 1234 WHERE CategoryID = 543;


Where 1234 is the category ID your moving links from...
and 543 is the ID number of the destination category.

Its not the simplest thing to do manually, but that should work Smile

Cheers
Andy
Programmer/Designer/LinksSQL Freak Cool

http://www.ultranerds.com
http://www.imagesql.com


pugdog
User

Karma: -0 / +1

Sep 29, 2005, 10:44 PM

Post #5 of 6 (6106 views)
Shortcut

Send pugdog a wink
Re: [Giray] Merge categories [In reply to] Can't Post

It's a little late, but I've been thinking about this.

Basically, rather than a "merge" function, which would be a tad sematically complex, a "Move All" function should be farily easy.

All that needs to be done to move links from one category to another is to update the CatLink table, changing the Category_ID from the old category to the new one:

The MySQL query is simply:

update prefix_CatLinks set Category_ID = new_category where Category_ID = old_category

Moving categories is a bit more complex.

Because duplicate entries should be disallowed, this would have to be done checking to see if a link already existed in the new category, and if so, deleting the old record, rather than modifying it.

If I ever get the toolbox cleaned up, this will probably be one of the features in it.

It would be nice if it could be integrated into the Browser code, but I'm not even going to attempt that ... you'll have an admin option to move links from one category to another, and you'll have a check box to move multiple links, and anoption to 'check all' to move all links.

On the list of things to do, though, unless I have a client site that needs this for some pressing reason, it probably won't get done until after the holidays.

It's a convenience thing, since for 90% of "pressing needs", entering the MySQL command to do it from the MySQLMan utility works, it just doesn't have a pretty interface.

How links are assigned to categories is one of the nicer features of Links/Glinks.


Giray
Novice

Karma: -0 / +0

Sep 29, 2005, 11:22 PM

Post #6 of 6 (6100 views)
Shortcut

Send Giray a wink
Re: [pugdog] Merge categories [In reply to] Can't Post

Thanks guys.

 
 
 


Search for (options) Powered by Gossamer Forum v.1.2.4