Hi,

How can I move all the links from a category to an existing one, that also has links?

Thanks,
Emilio

If you delete the category and then click on Check Links, it will notify you that you have a missing category. One of the options will be to move the uncategorized links into another existing category.

Cheers,

Alex

Expanding on this issue:

1) make sure you have no bad links before doing this.

2) If you want to move to an existing category, just delete the old category and then click on Check Links, you'll be prompted to move them to an existing category.

3) If you want to move the links to a NEW category, first create the new category, then start back at #1



------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/

 
Or simply rename the existing category to the new one (assuming you don't want the old category anymore).

Cheers,

Alex

Good point -- I was using old logic.

That's a change from Links 2.0 I guess, since the category heierarchy is rebuilt each time, the links could be moved in the tree, where in links 2.0 they couldn't.

It's also possible to use the SQL monitor to change all links with the old category number to the new one:

UPDATE Links SET CategoryID="new_value" where CategoryID="old_value"

Because LinkSQL keeps the category only in a reference (an ID to the Category table) it's easier to move links around the database.





------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/

Thanks!

OK...

Pugdog and if I want to move a category and all yours sub-categories inside of another category already existent? would have to move all the sub-categories one to one?

You need to do something like:

UPDATE Category
SET Name = REPLACE(Name,'/old/category/path/','/new/category/path/')
WHERE Name LIKE '/old/category/path/%'

The idea is to update the Category.Name field with the new prefix-path where the category started with the old prefix-path.

Because the links are keyed by number, all you need to do is change the category name. But, each category keeps the full path, so you need to change every subcategory...

Anyway, not guaranteed to work, could destroy your site, use with caution, make a back up first, etc.

Sorry guys.... where is "Check Links" button?

I can not find it.

Gabriel.

Under the 'Database' tab there are a few options to do with your links?

- wil

This is the Links SQL 1.13 forum Wil ....a lot has changed since then (if I remember correctly) :)

Aha, yeah. Oops!

- wil

// Even moer confused...

Right, guys, I noticed that the post was 2 years old...

Still, is there a way to move links from one category to another not one-by-one?

Thx, Gabriel.


__________________



I was even stupidf enough to delete a category